Export ALL to a CSV?

[justw]

I've been an OrangeCd user for a long time and like it a lot but am abandoning Windows as an operationg system. One of the apps I will miss is Orange CD. Is there a way to export all of the fields in the database to a csv so I can import into another database? So far the only option I have is to export via HTML with each CD on it 's own page. This is fine and I can add future cds via an HTML editor but would prefer a csv export then regardless of what I do in the future I can use the csv file as a datasource.

Also, is there a way to transfer my OCD license to someone else? Some of my friends would enjoy using it.

[frederf]

I don't know about CSV, but I think you can export everything to XML.. after that if your new program can't import XML there are other programs that can convert the XML into other formats.. MS Excel can read XML and then you can export to CSV.

But I don't think that in any case the data will be nice and clean.. ;O)

fred

[Paternoster]

[...] Is there a way to export all of the fields in the database to a csv [...]

Go to "Database" Menu and chose "Import and Export ...". What you are looking for is the "Export to plain text" action.

-pn

[justw]

Go to "Database" Menu and chose "Import and Export ...". What you are looking for is the "Export to plain text" action.

-pn

I don't think I can get track titles or times with that.

"I don't know about CSV, but I think you can export everything to XML.. after that if your new program can't import XML there are other programs that can convert the XML into other formats.. MS Excel can read XML and then you can export to CSV."

I'll look into the XML stuff. I'm not that familiar with XML so didn't look at that option.

[Paternoster]

OMG ... you are obviously right. Even that export function is crippled ...

My fault! I never checked the csv's for such trivial things like titles and times, but only for some of my self defined fields and stuff. I took it for granted that those basic things would always be included ...

That's a bad joke, isn't it?

-pn

[justw]

yeah, I expect a database program to be able to dump all of it's records and fields into a generic format. I stll need to explore XML but I'm not hopeful.

[andrei_c]

XML is the full export in OrangeCD. It contains everything there is in the database except artwork images.

Andrei