Solved

CD Remote Data

Posted on 2000-04-10
31
302 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Create a default user profile for Mac OS X 10.7/10.8 Create a user account on OS X that will be a template for every other user of that computer. I usually call it “profile” and make it an administrator account for the time being. 1. Install a…
A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now