ojos504 Posted November 15, 2019 Report Share Posted November 15, 2019 Hi! I tried to export the information of my SonicStage Library, or a playlist, into let's say a *.csv text File, but couldn't find that functionnality. My intention is to import the data (trackname, all it's attributes, path) into a spreadsheet in order to manage the more than eight hundred tracks that I have recorded. Main reason I need this, is that I plan to change a HDD in my system (after a crash) and want to secure access to my recordings after replacement. A spreadsheet would be very useful to monitor the status of each track (whether it's restricted or not, whether I have converted it to wav or not) , and the different locations where reside the different versions of the track. (While many of the original tracks exist still on my Hi-MD's, I also have overwritten some of them, and my MD-Player is getting older and weaker...) Does SonicStage offer such a feature as exporting a playlist as *.csv file ? Or: Does some third party plugin offer such functionality ? Or: Does there exist some software that can extract the information from the SonicStage database? Thanks in advance Quote Link to comment Share on other sites More sharing options...
sfbp Posted November 16, 2019 Report Share Posted November 16, 2019 You could open the database in Access or SQL Server. Be very careful not to "touch" or modify the contents of any sound files. This inevitably requires them to be removed and readded to be used in SS. HOWEVER, I would be inclined to do two things: 1. List out all the directories under your SS imported files. 2. Write yourself a utility to parse the headers (they are almost identical to MP3 with "ID3" replaced by "EA3"). Get all those headers into your own excel spreadsheet. You can find out the meanings of some of the headers from the MP3 docs, and the rest from the #linux-minidisc sources. Good luck! Quote Link to comment Share on other sites More sharing options...
ojos504 Posted November 16, 2019 Author Report Share Posted November 16, 2019 Thank you for your answer. It seems quite difficult. "You could open the database in Access or SQL Server. " => but what is the name of the file ? Quote Link to comment Share on other sites More sharing options...
sfbp Posted November 16, 2019 Report Share Posted November 16, 2019 Mine looks like this (no guarantees): You'll still need to figure out the meanings of all the fields (in the database), as well as all the fields (in the headers of the files) to get what you want. I wouldn't bother to try and track WAV files at all - things get very confusing and WAV files don't have metadata (in the file). Quote Link to comment Share on other sites More sharing options...
ojos504 Posted November 16, 2019 Author Report Share Posted November 16, 2019 I managed to open a copy of a SonicStage *.mdb file with OpenOffice, and copy a table ('t_object') to a spreadsheet. I think i will try work with that. At least it gives me a complete name list. Thank you very much ! Quote Link to comment Share on other sites More sharing options...
sfbp Posted November 16, 2019 Report Share Posted November 16, 2019 Have fun. If you come up with anything we can all use, we'd be interested...... Quote Link to comment Share on other sites More sharing options...
ojos504 Posted November 16, 2019 Author Report Share Posted November 16, 2019 It seems quite tricky, and I have not much hope to come back with some working method... but I'll try Quote Link to comment Share on other sites More sharing options...
sfbp Posted November 17, 2019 Report Share Posted November 17, 2019 I still think you'd be better off not messing with the DB (there are SO MANY fields and you have to figure out how to use them), but simply scanning all the headers of all known files. But no one got anywhere without trying. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.