I use a program called CDJ to play my music. It's used to control Sony CD jukeboxes and also plays mp3 files. It's fairly tightly integrated with all of my home automation systems, so changing to something else is not an option I want to consider. I'm getting rid of the jukeboxes, so am in the process of converting all of my CDs to mp3s. I'm storing my mp3s in a directory structure of folders for each artist with subfolders for each album. I'm trying to use mp3tag to export mp3 information to import into CDJ. CDJ stores its information in an Access database in two tables (Albums and Tracks). I've created the following export files to populate the tables:
$loop(%_folderpath%,1)%artist%;%album%;%_total_files%;%_total_time_raw%;%artist% - %album%.jpg $loopend()
A fair amount of manual work remains to import this into CDJ as CDJ uses a unique identifier (called CDJID) that is a 16 character hex number. This identifier is unique to each Album and is also used in the Tracks table to match each track to its album. I have three questions:
Can I combine the two exports above into one that still creates two separate files (one called tracks.csv and one albums.csv)? If so, how do I do that?
Once I have the export combined into one, how can I generate a 16 char hex number that I can then use as a field in the album file and in the tracks file?
CDJ uses two fields for album and track lengths: minutes and seconds. Can I use scripting/regular expressions in the mp3tag export that takes the information in seconds and converts it into two values (minutes and remaining seconds)?
Thanks for any help.