Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Skeezix]

Repost from July 8 (or thereabouts):

In MC12 Help, searching on "CSV" brings up Supported File Types. Displaying that topic presents a table that lists MS Office, webpage files, Acrobat, etc.

Where can I find more information about this feature, and specifically, information about importing the contents of an XLS (Excel worksheet) file into MC12??

[Alex B]

MC does not handle the contents of the "document" files. It's database and tools can be used for organizing and cataloging these file types. The play command opens these files in the default external program. The "right-click > Send to > External" tool can be used for running a file with specific command line parameters.

[Alex B]

Where can I find more information about this feature, and specifically, information about importing the contents of an XLS (Excel worksheet) file into MC12??

What kind of data you would like to import? Do you have media file tags in excel sheets?
MC can apply library data from properly formatted XML files.

Here is an example of such a file:

Code: [Select]

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="Various file types in a playlist">
<Item>
<Field Name="Filename">Y:\B5\4\Babylon 5 - S4E11 - Lines of Communication.avi</Field>
<Field Name="Artist">Babylon 5</Field>
<Field Name="Album">Season 4</Field>
<Field Name="Name">S4E11 - Lines of Communication</Field>
<Field Name="File Type">avi</Field>
<Field Name="Genre">SciFi</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Last Played">1147159033</Field>
<Field Name="Number Plays">7</Field>
<Field Name="Track #">11</Field>
<Field Name="Date Created">1095000728</Field>
<Field Name="Date Modified">1095594489</Field>
<Field Name="Date Imported">1095625241</Field>
<Field Name="Date">35065</Field>
</Item>
<Item>
<Field Name="Filename">Y:\B5\4\Babylon 5 - S4E11 - Lines of Communication.srt</Field>
<Field Name="Artist">Babylon 5</Field>
<Field Name="Album">Season 4</Field>
<Field Name="Name">S4E11 - Lines of Communication</Field>
<Field Name="File Type">srt</Field>
<Field Name="Genre">Subtitles</Field>
<Field Name="Media Type">Data</Field>
<Field Name="Track #">11</Field>
<Field Name="Date Created">1110658919</Field>
<Field Name="Date Modified">1101203828</Field>
<Field Name="Date Imported">1159802295</Field>
<Field Name="Date">35065</Field>
</Item>
<Item>
<Field Name="Filename">X:\Bach\Brandenburg Concerts 4-5-6 (Goebel)\03 - Concerto No. 4 (BWV 1049) in F major - 3. Presto.apl</Field>
<Field Name="Artist">Bach</Field>
<Field Name="Album">Brandenburg Concerts 4-5-6 (Goebel)</Field>
<Field Name="Name">Concerto No. 4 (BWV 1049) in F major - 3. Presto</Field>
<Field Name="File Type">apl</Field>
<Field Name="Genre">Classical</Field>
<Field Name="Bitrate">711</Field>
<Field Name="Image File">Bach - Brandenburg Concerts 4-5-6 (Goebel).jpg</Field>
<Field Name="Media Type">Audio</Field>
<Field Name="Last Played">1162159605</Field>
<Field Name="Rating">4</Field>
<Field Name="Number Plays">2</Field>
<Field Name="Track #">3</Field>
<Field Name="Date Created">1162122820</Field>
<Field Name="Date Modified">1162175163</Field>
<Field Name="Date Imported">1162125308</Field>
<Field Name="Composer">J.S. Bach (1685-1750)</Field>
<Field Name="Date">31778</Field>
<Field Name="Album Rating">9</Field>
<Field Name="Album Gain">-3,9095336369105746</Field>
</Item>
<Item>
<Field Name="Filename">X:\Klubbingman\Welcome to the Club No. 1\Welcome to the Club No. 1 - tracklist.xls</Field>
<Field Name="Artist">Klubbingman</Field>
<Field Name="Album">Welcome to the Club No. 1</Field>
<Field Name="Name">Tracklist (Excel)</Field>
<Field Name="File Type">xls</Field>
<Field Name="Genre">Info</Field>
<Field Name="Media Type">Data</Field>
<Field Name="Date Created">1102852791</Field>
<Field Name="Date Modified">1106511528</Field>
<Field Name="Date Imported">1106512534</Field>
<Field Name="Date">37987</Field>
</Item>
<Item>
<Field Name="Filename">X:\Manowar\Gods of War\Gods of War - Booklet.pdf</Field>
<Field Name="Artist">Manowar</Field>
<Field Name="Album">Gods of War</Field>
<Field Name="Name">Booklet</Field>
<Field Name="File Type">pdf</Field>
<Field Name="Genre">Info/Art</Field>
<Field Name="Media Type">Data</Field>
<Field Name="Date Created">1174342632</Field>
<Field Name="Date Modified">1174346232</Field>
<Field Name="Date Imported">1174777861</Field>
<Field Name="Date">39083</Field>
</Item>
<Item>
<Field Name="Filename">X:\Pink Floyd\A Momentary Lapse Of Reason\02 - Learning To Fly.mpc</Field>
<Field Name="Artist">Pink Floyd</Field>
<Field Name="Album">A Momentary Lapse Of Reason</Field>
<Field Name="Name">Learning To Fly</Field>
<Field Name="File Type">mpc</Field>
<Field Name="Genre">Progressive Rock</Field>
<Field Name="Image File">Pink Floyd - A Momentary Lapse Of Reason.jpg</Field>
<Field Name="Media Type">Audio</Field>
<Field Name="Rating">5</Field>
<Field Name="Track #">2</Field>
<Field Name="Date Created">1141764288</Field>
<Field Name="Date Modified">1147904750</Field>
<Field Name="Date Imported">1147864618</Field>
<Field Name="Date">31778</Field>
</Item>
<Item>
<Field Name="Filename">X:\Procol Harum\Exotic Birds And Fruit\Exotic Birds And Fruit - Back.jpg</Field>
<Field Name="Artist">Procol Harum</Field>
<Field Name="Album">Exotic Birds And Fruit</Field>
<Field Name="Name">Back</Field>
<Field Name="File Type">jpg</Field>
<Field Name="Genre">Art</Field>
<Field Name="Media Type">Image</Field>
<Field Name="Last Played">1146406039</Field>
<Field Name="Number Plays">2</Field>
<Field Name="Date Created">1085008789</Field>
<Field Name="Date Modified">1118347866</Field>
<Field Name="Date Imported">1085012830</Field>
<Field Name="Width">1405</Field>
<Field Name="Height">1200</Field>
</Item>
<Item>
<Field Name="Filename">X:\Talking Heads\The Best of - Once in a Lifetime\09 - Road to Nowhere.mp3</Field>
<Field Name="Artist">Talking Heads</Field>
<Field Name="Album">The Best of - Once in a Lifetime</Field>
<Field Name="Name">Road to Nowhere</Field>
<Field Name="File Type">mp3</Field>
<Field Name="Genre">Alt Rock</Field>
<Field Name="Comment">1977-1992</Field>
<Field Name="Image File">Talking Heads - The Best of - Once in a Lifetime.jpg</Field>
<Field Name="Media Type">Audio</Field>
<Field Name="Last Played">1134922483</Field>
<Field Name="Rating">5</Field>
<Field Name="Number Plays">3</Field>
<Field Name="Track #">9</Field>
<Field Name="Date Created">1110503390</Field>
<Field Name="Date Modified">1163727908</Field>
<Field Name="Date Imported">1086984921</Field>
<Field Name="Date">33604</Field>
<Field Name="Album Rating">9</Field>
</Item>
</MPL>
 
The filename extension must be .mpl.
The "File > Import Playlist" tool can apply "mpl" metadata to already imported files. The other import tools can import mpl metadata only if the media files that are included in the mpl playlist file are not already present in the library.

[hit_ny]

To import from CSV will require you to transform it via xsl to xml, specifically mc's flavour of xml or mpl.

To see what mpl looks like, select some files, then File->Export Playlist->mpl

output range (choose selection).

looks like alex beat me to it

[Skeezix]

Yes, it is doable, but the porting from Excel to XML is indirect and rather involved, more involved than simply editing within MC12.

Thanks to the help from folks like you in this forum, I bit the bullet and finished editing my tags without having to use the Excel file. There is a bit of a learning curve in MC12, but after learning and being told the various shortcuts and capabilities, I'm quite happy with the results and have since deleted the old Excel file.