Music database problem-suggestion

[Mizo_Mizo]

Hello everyone, I've been using MM since about 18 months so far. I'm not a programmer, but I'm interested in tweaks and improvements for almost everything I have in my computer. And this includes MM.
First of all, I want to apologise if this is not the right place for this kind of suggestion-request, but is the one that seemed correct to me.

Secondly, I'm going to explain my idea.
I'm sure that many of you have thought about this before, and possibly already have the answer to my question.
Some time ago, I decided to create a database in MS Access to store my music data. In order to achieve this, I had to
1) Check and correct the mp3 files' tags. (which is more or less done)
2)Decide the database structure. (which is the following:)
My MS Access database has got five tables: Albums, Artists, Artists_Website, Style, and Format. I introduce info in the tables through forms, which are: Artists, Style, Format, *Albums (embedded into Artists form) and *Artists_Website (embedded into Artists form). Thus, I only need to open the Artists form, and from there introduce any info I want: Artist ID, artist name, origin, artist style, years active, website(s), and description of this website (whether it is their Youtube channel, official page, etc.), current members, former members, and info about their albums: album ID, album name, publishing year, artist ID, album format (whether it's an EP, LP, promo CD, double CD, etc.)

Okay, this being said, the problem is that I could do all this manually, looking at my files, tags, and searching the Web, and introducing the data one by one, but I think there MUST be a way of doing this - or something similar - automatically. I found a couple of programmes (Music Collector, and Music Label 2010), but they don't really satisfy what I want. And after that I thought there could be some way of exporting MM's database, or converting it, I don't know... I also thought of some foobar2000 feature or script, but I don't really know where to start.

This is my problem, so any help is welcome; and for you developers, if some of you wants to take the challenge of creating a script that can do this, the idea is all yours...
Thank you all for your attention.
Cheers!

[trixmoto]

If you use MM then all the data is stored in an SQLite database - what do you gain by exporting some of this data into an MSSQL database?

[Mizo_Mizo]

Yeah, but what I would like to do is access that data, introduce new data in the DB and maybe edit/modify/view it. What I understand from what you say is that if I do any modification, such as adding a new album, or a new artist, or modifying metadata from existing songs, when MM rescans that folder, changes will be added to MM's SQLite database, right?
So, knowing this, what I would like to do is, as I said, acces that database locally (not through the Internet, I mean, that could be another project...), maybe print some certain info, etc.
I don't know if you understand me, it's not easy to explain, what I mean is having access to the database, but not through MM, and using MS Access seems to me the easiest possibility, because it's the software I'm accustomed to. However, if there's any other way of doing what I say, I shouldn't refuse taking a look at it...
Thank you!

[trixmoto]

Well my "Backup Playlists" script has over the years both exported from an MSSQL database (.mmdb) to create a new one with a subset of data, and the same for an SQLite database (.db). I'm sure these could be amalgamated to export from MM's SQLite database and create a new MSSQL database with a subset of data. I imagine it would be hardcoded to take the tables that you want and create them as certain other tables, creating all the links, etc. It could have a proper GUI settings screen that allowed you to select tables from the current database and rename them in the new database though.

[Lowlander]

I would be interested in that, getting data from MM to SQL Server.

[Mizo_Mizo]

Well my "Backup Playlists" script has over the years both exported from an MSSQL database (.mmdb) to create a new one with a subset of data, and the same for an SQLite database (.db). I'm sure these could be amalgamated to export from MM's SQLite database and create a new MSSQL database with a subset of data. I imagine it would be hardcoded to take the tables that you want and create them as certain other tables, creating all the links, etc. It could have a proper GUI settings screen that allowed you to select tables from the current database and rename them in the new database though.

Sorry for taking so long in replying, I had a busy week.
Then, do you mean you could create a script for this issue, using your "Backup playlists" script as a starting point?

[trixmoto]

Yes, I think all the code for a simple script is in there, it just needs reformatting to do this specific task. A fuller script with a GUI would probably be much better though, but would obviously take a lot more time. I've put it on my list, but I don't get as much time as I'd like for scripting these days, so I don't know when I'll get round to it. I'm trying to tidy up my existing scripts before I start on any new ones.

[Lowlander]

Ok, I've subscribed to the topic to get notified on any updates on this.

[Mizo_Mizo]

All right trixmoto, thank you for your help. If you ever carry out this idea, please let me know. However, I think I'm going to try something by myself (accessing the DB file through some other software).If I get some results, I'll post them here. Anyway, thanks for interesting in my thread, and sorry for taking so long in replying. I don't really get so much time for this.
And you, Lowlander, if you're interested or script something in relation with this, please let me know as well.
Thank you, cheers!

[Lowlander]

I'd just like to get data from MediaMonkey into a SQLServer database, anything that can get me there would be welcome.

[trixmoto]

It's still on my list, I'll get round to it one day!

[ZvezdanD]

having access to the database, but not through MM, and using MS Access seems to me the easiest possibility, because it's the software I'm accustomed to. However, if there's any other way of doing what I say, I shouldn't refuse taking a look at it...

You could consider a possibility to downgrade MediaMonkey since old program v2.x had database in MS Jet (Access) format. There is also programs which could convert SQLite database to MS Jet format, but they are all commercial, AFAIK.