Import Myriad Playout CSV export to highlight discrepencies

[theshillito]

Right, it is possible to export a CSV from Myriad which includes the following fields in this order:

• ItemType (always "Song" for our purposes)
• MediaId (PRIMARY KEY, the cart number in myriad, for quick searching without relying on myriad's own search feature)
• Title
• Artists
• Description (this is where we stored the record label when we still included that information)
• Category (this is always "(CAT) Specialist")
• SecondaryCategory (always blank for us)
• Type (always "Anime" once it's populated, this is in progress now)
• Gender (I am leaving this blank)
• Era (I am leaving this blank)
• Tags (I am leaving this blank)
• Intro (timecode for the intro length)
• Extro (timecode for the extro length)
• HasHook (whether a section of the track has been marked for quick play out as part of my opening preview, I'll get back to you when I add some with what this data looks like)
• HasLoops (idk fam)
• FirstReleaseYear
• Ending (this will say if it's Ends, Fades, Slow Fade, Sustain, I'll get back to you when I add some with what this data looks like)
• AddedDate
• LastModifiedDate
• StartDate (N/A)
• EndDate (N/A)
• DeleteDate (N/A)

In particular, adding the MediaId to the tracks in nkdsu will be a big help, especially if the metadata in nkdsu and Myriad are out of sync, as it means I just type in a number to quickly find a track to play instead of typing out title, artist, anime and finding it in a list.

I would also appreciate an icon to say if a hook has been added, as that will save me time in pre-show prep as I play three hooks as part of my intro.

It would also be a nice idea to do a metadata comparison between Myriad and nkdsu to keep track of metadata updates as once they're put into nkdsu, they'll need copying over to myriad. This should be made easier with the MediaId allowing metadata changes to be tracked based on that ID after that first import (initial import will require some fuzzy matching at first).

An example export is attached.
Myriad Neko Desu Export.csv