New
#1
Convert EXCEL sheets to MySql / MariaDB with links to music
Hi folks
I'm trying to create a decent Music Database
Basically rather than messing around with zillions of files / tracks / playlists etc I want to use one of the Free database systems (MySQL / MariaDB - both similar and work on Windows).
I have a load of spreadsheets -- what I want basically to start testing (can add other fields later) is for Album title, file / track name and path where the link will be able to link directly to the music track and application will play the file
Using this type of database I can then create my own queries if I want specific music etc
Once you get 1 TB or more of music data using traditional libraries / playlists etc doesn't really cut it any more
For the spreadsheets I used Mp3tag to save as csv, imported into excel where the ';' character is used as mp3tags delimiter and now I want to import these spreadsheets into MySQL -- not sure though how to handle the binary objects (the music files)
Here's a typical spreadsheet I want to import into the DB.
Any ideas anyone
From the sample spreadsheet shown above -- just a small test to start with say 3 or 4 fields in the DB would be fine -- I can expand later -- what I need is the best way of handling the binary files - MariaDB or MySQL are so similar - either will do.
I don't want proprietary systems - most music type libraries - especially for consumer stuff usually break quite often and have problems if they expand over several disks or you swap disks around. MySQL / MariaDB are open source and robust so no probs there.
Any DBA's out there -- probably simple - 90 secs work for you gurus. !!
Cheers
jimbo