I'd like to do the following:
1) Export the MB playlist data (playlist path, its name and of course the tracks info) to a spreadsheet
2) Convert MB playlists (some or all, chosen by tickboxes) to external playlist files, replicating the folder structure of the MB playlists
Critterman: it's nothing to do with syncing (which works fine for me, btw having multiple virtual devices to play with is bliss after iTunes!): having thought about it more I suppose item 1 above is more a reporting function.
Now the second option could be done by using the existing Virtual Device feature: point it at a folder of choice, and have an option so that only the playlists are created (don't copy the music), and have it replicate the MB playlist folder structure.
Psychoadept: I tried playing with auto-playlists but it didn't quite do what I wanted: one issue is if a whole bunch of playlists are imported from my iTunes xml I'd then have to go and set each one to auto-export manually.
Btw, your Mellon Remix skin is a thing of beauty!
Background:
I've been using iTunes for many years, and having collected a reasonable number of tracks and playlists, I want to 'liberate my data' relating to my library.
The management of playlists in iTunes is just horrible. It used to be possible to open a playlist in a separate window and have it side by side with the main library, which made dragging and dropping files from the library to add to the playlist quite easy. That feature was removed. Now you have to scroll to make the playlist visible in the LH tree, then drag the file onto it. It's a small target so it's easy to get the wrong one. The right-click 'Add to Playlists' feature is unusable if you have hundreds of playlists.
Also, if you have many playlists grouped into folders and subfolders, and you want to move them around, it's fiddly to do using the LH tree control.
By contrast, I was delighted to see that in MB the playlists are stored as discrete files which can be easily managed using two Windows Explorers side by side. Any changes made there are seamlessly shown in the MB Playlist tree. That feature alone I think puts MB way ahead of iTunes.
For analysing playlist data, it's possible to get it out of iTunes as it publishes it to an xml file, but it's fiddly to convert the playlist info to a flat table showing playlist path, name and tracks.
The ideal solution is to be able to select some or all MB playlists, and write the data to a flat table which shows
Playlist Path
Playlist Name
Track info, including Location, Artist, Album Artist, Title etc.