Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

CD Remote Data

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
powermixx
Asked:
powermixx
  • 19
  • 12
1 Solution
 
munsieCommented:
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
 
powermixxAuthor Commented:
Adjusted points from 100 to 200
0
 
powermixxAuthor Commented:
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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
munsieCommented:
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
 
powermixxAuthor Commented:
YES!!! That would be great! Have you done this before? Thanks!

-Robert
0
 
munsieCommented:
give me about a half hour or so (maybe longer but not much)

dennis
0
 
powermixxAuthor Commented:
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
 
munsieCommented:
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
 
powermixxAuthor Commented:
Adjusted points from 200 to 500
0
 
powermixxAuthor Commented:
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
 
munsieCommented:
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
 
powermixxAuthor Commented:
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
 
powermixxAuthor Commented:
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
 
munsieCommented:
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
 
powermixxAuthor Commented:
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
 
powermixxAuthor Commented:
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
 
powermixxAuthor Commented:
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
 
munsieCommented:
my email address is munsied@home.com

dennis
0
 
powermixxAuthor Commented:
Dennis,
I sent the "Plus" file to your email address. please let me know if you need anything else. And...thanks again!


Robert
0
 
munsieCommented:
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
 
powermixxAuthor Commented:
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
 
munsieCommented:
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
 
powermixxAuthor Commented:
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
 
powermixxAuthor Commented:
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
 
powermixxAuthor Commented:
Adjusted points from 500 to 600
0
 
powermixxAuthor Commented:
Dennis,
You still with me?

-Robert
0
 
munsieCommented:
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
 
powermixxAuthor Commented:
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
 
munsieCommented:
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
 
munsieCommented:
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
 
powermixxAuthor Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 19
  • 12
Tackle projects and never again get stuck behind a technical roadblock.
Join Now