Solved

CD Remote Data

Posted on 2000-04-10
31
308 Views
Last Modified: 2012-05-04
Is there a way to export the data in the "CD Remote Programs" file (located in the System Folder/ Preferences). I want to export the data in that file to a text file - ultimately into a database. Can this be done? I tried ResEdit, but I know nothing about it and had no luck. Has anyone else ever tried this? Thanks!

***** If this can be done and if you know how, let me know and I will up the points to 500. Yes 500. I need an easy way to get the data from the "CD Remote Programs (Song Title, Artist, Time, etc) into a text file. Good luck.
0
Comment
Question by:powermixx
  • 19
  • 12
31 Comments
 
LVL 2

Expert Comment

by:munsie
ID: 2702300
do you want source code? :)

the format of the file is described in a technote - http://developer.apple.com/technotes/dv/dv_25.html

if you want source, let me know and i'll dig through my code i have to access the file.

good luck,
dennis
0
 

Author Comment

by:powermixx
ID: 2702383
Adjusted points from 100 to 200
0
 

Author Comment

by:powermixx
ID: 2702384
Forgive me, but I'm a newbie at this. Can you please explain how I can get the text only out of all that source code? Is there a utility for doing this? All of that code mumbo jumbo looks a bit daunting.....
0
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 2

Expert Comment

by:munsie
ID: 2702399
ok, do you want a program that you can run and it dumps out a text file?

if you want that, i can get that for you.

just let me know

dennis
0
 

Author Comment

by:powermixx
ID: 2702412
YES!!! That would be great! Have you done this before? Thanks!

-Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2702423
give me about a half hour or so (maybe longer but not much)

dennis
0
 

Author Comment

by:powermixx
ID: 2702434
Dennis, here's what I'm trying to do....

Go to cddb.com
They have software (downloadable cd players).
You put a Compact Disc in your CD Rom drive and query their database.
Their database populates the CD Remote file on your machine. From there, I want to export the data to a text file, and finally into Microsoft Access. This would be a HUGE time saver! Unfortunately, their service does not include output to a text file, I asked but they replied saying...NOPE! This is my reasoning for this.....thanks!
0
 
LVL 2

Expert Comment

by:munsie
ID: 2702578
well, here is something that i hope helps

go download http://munsie.dhs.org/CD_Remote_Dump.sit

run this.. if everything goes good, the program will return to the finder with no errors.  In the directory where the program is located will be a file called 'CD Output.txt'.  Open this file with a text editor, and it should be a list of every cd currently in the CD Remote Database.

If anyone wants the source code, send me an email and I'll send it to you.

good luck,
dennis

btw, as a disclaimer, I'm not responsible for any damages that may occur... I've tested this on my machine and nothing bad happened, but that doesn't mean their isn't any bugs.  As a precaution, make a copy of your 'CD Remote Programs' file before running.  Otherwise, everything should run just fine.
0
 

Author Comment

by:powermixx
ID: 2702762
Adjusted points from 200 to 500
0
 

Author Comment

by:powermixx
ID: 2702763
Dennis,

Awesome job! I'll award the 500 points as promised, but I have a few other concerns:

Is there a way to also extract the track length and type of song?

I think the track length is in the CD Remote Programs file. Can it be done?

In the System Folder, there's another file "CD Remote Programs Plus". This file contains the type of song.

I'll even up the points another 100 if I can get the "Cd Output.txt" file to be "tab" delimited. This way, I can easily import it into my database.

Example:
01      Track One title here          3:35    (track number, title and track length  separated by a <tab>.

Thanks again!

Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2704226
well, the track length and type are not in the database.

everything that you see in the "CD Ouput.txt" file is what is in the CD Remote Programs file.

This other file 'CD Remote Programs Plus" sounds like a non-standard file of some sort.  It's probally something that your CDDB software adds.  If you can give me the name of the software, I can take a look at it tonight and see what I can do.

as for the formating, that's easy to change... where do you want the album titles?

would something like this work?

album title
01 song one 00:00:15
02 song two 00:00:20

album title
01 ...

the first line is the album title, and then the rest of the lines up to a blank line are the titles.  would that work for you?

dennis

0
 

Author Comment

by:powermixx
ID: 2704305
Dennis,
Thanks for the response. If I can be picky, I'd like to see this type of formatting:

Track #   Track Name    Artist       Album Title    Song Type   Track Length
   01        Smooth         Santana   Supernatural  Rock              3:45
   02        Bla Bla           Santata    Supernatural  Rock              4:05

Having the Artist and Album Titles on each line would be great (if possible). Yes, I believe the "CD Remote Programs Plus" file is created by the software I'm running. CDDB.com has several apps that use this "download" capability. I use "SoundJam" which I purchased from "SoundJam.com. Would you like me to email the "Plus" file to you? Thanks again!!

Robert
0
 

Author Comment

by:powermixx
ID: 2704319
Oh yea, I'd like the fields separated by a <tab> if possible. And if you can't get the Artist and Album Title on the same line, that's okay.

Man this is going to save me a lot of time. Thank you Dennis!
0
 
LVL 2

Expert Comment

by:munsie
ID: 2704451
yes, if you can email the file that would be great.

don't forget to hqx the file before sending... if you don't then i won't be able to read it.

dennis
0
 

Author Comment

by:powermixx
ID: 2704513
Oh yea, I'd like the fields separated by a <tab> if possible. And if you can't get the Artist and Album Title on the same line, that's okay.

Man this is going to save me a lot of time. Thank you Dennis!
0
 

Author Comment

by:powermixx
ID: 2704515
Oh yea, I'd like the fields separated by a <tab> if possible. And if you can't get the Artist and Album Title on the same line, that's okay.

Man this is going to save me a lot of time. Thank you Dennis!
0
 

Author Comment

by:powermixx
ID: 2704622
Where can I find your email address?

Sorry for the duplicate posts. I refreshed to see if you responded and it reposts! Ahh!

When I get home, I'll forward the file to you in .hqx format. Thanks again.

Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2704643
my email address is munsied@home.com

dennis
0
 

Author Comment

by:powermixx
ID: 2705361
Dennis,
I sent the "Plus" file to your email address. please let me know if you need anything else. And...thanks again!


Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2705825
ok, i just took a look at that file.  From the looks of it, all I can grab out of it that isn't already in the CD Remote Programs file is the song type.  It doesn't have the track time in it.

I need a copy of your 'CD Remote Programs' file as well to make sure that I can use both files together.

If you could just email that to me at the above address, that would be great.

dennis
0
 

Author Comment

by:powermixx
ID: 2706177
Not my day I guess. I had difficulties with my ISP. I sent the files 3 times. My apologies if you actually got ALL 3! Thank you aaaaagain!

Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2706243
i'll try to get something for you to try wednesday night.  The only thing it won't show is the track time.  As long as your album title and artist name are separated by a '-' or a '/', I should be able to tab separate those.

I've been trying with my own file and the additional file you sent me, and everything looks good for the most part... just a couple of loose ends to tie up, and everything should be ready.

dennis
0
 

Author Comment

by:powermixx
ID: 2706252
Thanks Dennis.
Darn shame I can't get the track times. I understand though. I believe the software determines the track length automatically. As you probably know, when you insert a *new* CD, the track times always show up - therefore, I guess there's no "Track Length" field to extract. Basically, i understand. Look forward to hearing from you again. Thanks!

Robert
0
 

Author Comment

by:powermixx
ID: 2708251
Footnote,
If it makes things easier, the final .txt file could be separated by a "/" or any character. Microsoft Access will accept any "delimiter". Thanks.

Robert
0
 

Author Comment

by:powermixx
ID: 2714350
Adjusted points from 500 to 600
0
 

Author Comment

by:powermixx
ID: 2714351
Dennis,
You still with me?

-Robert
0
 
LVL 2

Expert Comment

by:munsie
ID: 2715845
yes... sorry, i've had a few things come up over the past two days.

i'll post the latest version of the program sometime saturday.  I'm going to also include the source.

If you could still try to send your CD Remote Programs file again, that would be great.  I don't think I'll need it, but it would be nice to have just incase.

dennis
0
 

Author Comment

by:powermixx
ID: 2719283
Dennis,
I just sent you the two files again. I've added a lot of data to them. I hope the files are still managable. Thank you. Talk to ya soon.

Robert
0
 
LVL 2

Accepted Solution

by:
munsie earned 600 total points
ID: 2719735
ok, here is the final version... it's available at http://munsie.dhs.org/CD_Remote_Dump.sit again... make sure your browser doesn't cache the old version -- this file should be 23015 bytes when you download it.

This version has all the changes you mentioned above, and should give you everything that is in your "CD Remote Programs and CD Remote Programs Plus" files.

good luck,
dennis
0
 
LVL 2

Expert Comment

by:munsie
ID: 2719741
btw, source is located at http://munsie.dhs.org/CDRemoteDump.c if anyone wants it... it's not the pretiest code, but it may help someone looking to use one of these files.

dennis
0
 

Author Comment

by:powermixx
ID: 2719818
Well Dennis,
All I can say is U.F.B. (Un-F**cking-Believable). This script is going to save me a ton of work. I am so glad I never entered this data manually. Now, at last, I can easily import all of this data with little effort. I will make several backups to protect my data., but all looks okay. THANKS AGAIN FOR AN OUTSTANDING PROCESS!!!! woohoo!!!!!!!!!!!!!!!!!!!!!!!!!!

Best Regards,
Robert Steele
http://www.powermixx.com
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes in detail how to set up the iPad in the Enterprise using iPCU aka iPhone Configuration Utility.  This could also be used for the iPhone although I have not detailed out any differences. Preparation as an iPad Administrator:…
There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question