i need a way to keep track of what I got on my player.. HELP

In emplode, you can export the database to a CSV file. Then open that CSV file in Excel.

You can't go the other direction, though (changing the data in Excel and then pulling it back into emplode).

___________
Tony Fabris

Although the data will most likely not come out in the form you'd like it in. It reports the files by FID, not in some pretty form like your playlist structure. Unfortunately I found the database export function to be a bit useless because of this.

DiGNAN
Ob-La-Di, Ob-La-Da, etc.

The whole point of exporting the database in raw form is so that you can use your own code to order it however you want.

If you're good with Excel (or perhaps Access), I'm sure you could work up a script that allowed you to organize the CSV data in playlist order.

My question is: Why would you WANT to? Emplode already shows all your files in playlist order. If someone is exporting the database to CSV, it's usually because they want it in some format that Emplode won't show them.

___________
Tony Fabris

My question is: Why would you WANT to? Emplode already shows all your files in playlist order.

Can you say "cheatsheet"!

Mk2 #105 12g blue
Car install complete...........Boat forthcoming

wait if I export it raw and import to excel will it say the filename or the fid? the whole reason I want it is to know what is on my empeg.. so much music so little of my memory hasnt been killled by ummm BEER!

Heh, well, you could TRY IT and find out...

(FYI, it says both the file name and the FID.)

___________
Tony Fabris

I'm sure you could work up a script that allowed you to organize the CSV data in playlist order

I hate to say it, but frankly no, you can't. Sure, it reports the FID and the filename, but the songs will most likely not be in the order you have them in your playlists. Therefore there isn't a way to get an exact copy of what you have on your player. At least not a pretty one.

I've tried to do stuff with the imported database, but it sure doesnt' look good.

DiGNAN
Ob-La-Di, Ob-La-Da, etc.

And honestly, it seems to me like it would be even easier to report exactly what emplode sees. Wouldn't that be more useful than what you get from the csv info?

DiGNAN
Ob-La-Di, Ob-La-Da, etc.

FYI, it says both the file name and the FID.

Sorry, re-reading that post I realized that a slight slip-up in semantics might have been confusing at a technical level.

The file name is the FID with a digit added. What I meant to say is that the exported CSV database contains both the FID and the Track Title, which is what I think the original question was asking.

___________
Tony Fabris

The exported file contains playlists too. Each playlist has a list of all the FIDs it contains in order. It may not be 1NF but it is possible to generate the playlist tree in the right order from it.

The only way I can see of exporting in a 1NF form is to also export a parent to child mapping table that takes care of the many-many relationship.

Remember that the export is designed to give as much of the data as possible in the raw form so that people can write scripts, Access databases or even COBOL to convert it into the form they want.

--
Mike Crowe
I may not be speaking on behalf of empeg above :-)

Well, frankly, all I can say is that you couldn't have been trying too hard.

I took the CSV output, dropped it into a new spreadsheet. I then sorted on playlist and on Track number, and within about half an hour had something looking almost what I would expect from the playlist hierarchy I have built by category on the empeg itself. This was done manually, but I am pretty certain that with the CSV listing I could pre-sort it using a scripted filter using regular expressions, and then feed the result into a pre-formatted Excel template to create the hieracrchy overview any time I wanted to.

One of the few remaining Mk1 owners... #00015

Why? If the empeg pre-formats it, then you have less flexibility!

With CSV, you can do just about what you like with the data, on any machine you move it to. It's not a coincidence that just about every spreadsheet and database program on the planet accepts CSV, you know...

One of the few remaining Mk1 owners... #00015

GEEZ!! Sorry everybody, but I wasn't awaare that it exported playlists as well, and that it exported it in order. That's all you have to tell me!

Yeesh!

DiGNAN
Ob-La-Di, Ob-La-Da, etc.

The original filename isn't stored anywhere on the player. So we can't get that back.


Roger - not necessarily speaking for empeg