INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Axim30user on October 08, 2004, 01:29:07 pm

Title: import cd's
Post by: Axim30user on October 08, 2004, 01:29:07 pm

I'm currently trying MC10 and want to import my CD database which is currently in excel format. Is it possible to do this or do I have to insert each CD in the computer to be known to the system?

thanks

Title: Re:import cd's
Post by: Alex B on October 08, 2004, 03:03:36 pm

Maybe. Could paste here a sample of your Excel sheet?

MC understands this format:

Quote

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0">
<Item>
<Field Name="Filename">D:\Music\Stravinsky\Concertos Vol.5\Igor_ Stravinsky_Concertos_V5.ogg;3</Field>
<Field Name="Artist">Igor Stravinsky</Field>
<Field Name="Album">Igor Stravinsky edition, vol. 6 of 12, Concertos</Field>
<Field Name="Name">Concerto for piano and wind instruments - III. Allegro</Field>
<Field Name="Band">Columbia Symphony Orchestra</Field>
<Field Name="File Type">ogg</Field>
<Field Name="Genre">Classical</Field>
<Field Name="Date">18328,578125</Field>
<Field Name="Comment">Piano: Philippe Entremont</Field>
<Field Name="Image File">Igor_ Stravinsky_Concertos_V5_Front.JPG</Field>
<Field Name="Media Type">Audio</Field>
<Field Name="Last Played">1097170100</Field>
<Field Name="File Size">2293</Field>
<Field Name="Duration">304</Field>
<Field Name="Number Plays">4</Field>
<Field Name="Track #">3</Field>
<Field Name="Date Created">1097008156</Field>
<Field Name="Date Modified">1097001094</Field>
<Field Name="Date Imported">1097009925</Field>
<Field Name="Replay Gain">-5,9841899999999999</Field>
<Field Name="Peak Level">0,99997</Field>
<Field Name="Intensity">1</Field>
<Field Name="BPM">117</Field>
<Field Name="Composer">Igor Stravinsky</Field>
<Field Name="Playback Range">850160-1154333,333333</Field>
<Field Name="Complete Album">1</Field>
<Field Name="Album Gain">-5,9841899871826172</Field>
<Field Name="Conductor">Igor Stravinsky</Field>
<Field Name="Encoder">OGGenc1.1_q9_ns-15</Field>
<Field Name="Comment 2">Remastered CD 1991</Field>
</Item>
</MPL>

So about everything can be imported if it is in the right format.

Edit

Oh sorry, this was for a music files database, not for importing Audio CD info. I guess you have not ripped your CDs and you are only going to play them with MC. Though you could still paste a sample here. Perhaps somebody knows how to do it.

Title: Re:import cd's
Post by: Axim30user on October 08, 2004, 03:49:31 pm

Should have been a bit more specific, but I do indeed mean normal audioCD (not ripped).

The spreadsheet is just a few columns with artist/title/year etc, would be failry easy to make something with fields as described above if I knew MC10 would import it.

Maybe the excel2003 xml export would be handy, anybody know a bit more?