AIMP Forum

English pages => Questions => Topic started by: mandal on January 18, 2019, 17:29:48

Title: Database
Post by: mandal on January 18, 2019, 17:29:48
First want to say that AIMP is looking great, and have a lot of functionality. I'm pretty sure most will be happy with it.

I come from foobar2000 through many years. Playing music everyday, since working with computer many hours a day needs lots of music :) Through the years i have collected approx. 100.000 mp3, waw, flac, sid etc files. In foobar I have playcount and rating for most of those files. This means MANY hours have been used just on rating the songs. I use rating and playcount to sort and find music I want to play. I'm pretty sure many with a large collection have same way of doing it.

I like what I see in AIMP, and would like to convert :) BUT, I want my ratings and playcount transferred from foobar.

There's no plugin to do a thing like that, so can you tell me what database you use for local.adb, then I might be able to code a thing myself to transfer the values?

Thanks.
Title: Re: Database
Post by: Artem on January 18, 2019, 19:52:47
Have you any information about the Foobar2000 DB structure?
Title: Re: Database
Post by: mandal on January 18, 2019, 22:24:03
There's a plugin called foo_sqlite, that gives SQL access to the internal media library. Link to plugin:
https://www.foobar2000.org/components/view/foo_sqlite


Here's some talk from the author and examples:
https://hydrogenaud.io/index.php/topic,112381.0.html


Check this image on this page that shows playcount is available at least.
http://www.palm-internet.eu/foobar2000/components/foo_sqlite/PreferencesDialog.html

So we can SQL the result (filename, playcount and rating) and find same filename in AIMP and update playcount and rating. Should be possible.
Title: Re: Database
Post by: mandal on January 22, 2019, 14:14:52
I see you have a tracklist export option. Maybe you could implement a simple Tracklist update, for ratings and playcount where filename is equal. Probably ok for other fields too.

The input file would contain:

"FileName","PlayCount","Rating"

Which would update playcount and rating where filename is equal. Then we could use for example the SQL plugin described above to extract values from foobar2000.

What do you think?
Title: Re: Database
Post by: Artem on January 23, 2019, 19:48:48
The input file would contain:

"FileName","PlayCount","Rating"

Which would update playcount and rating where filename is equal. Then we could use for example the SQL plugin described above to extract values from foobar2000.

I think I will implement this ability soon. It easier than create an imported from foobar's DB
Title: Re: Database
Post by: mandal on January 24, 2019, 15:02:53
Well, that would indeed help many :)

If you do that, I would like to know how I can donate some money to you. Do you have a payable version of the android app? Then I would buy that.