Bug 193970 - Export Amarok collection to defined format
Summary: Export Amarok collection to defined format
Status: RESOLVED FIXED
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: unspecified
Platform: Debian testing Linux
: NOR wishlist
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-25 01:51 UTC by Nicolas Dietrich
Modified: 2025-01-04 12:10 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Dietrich 2009-05-25 01:51:27 UTC
Version:            (using KDE 4.2.3)
OS:                Linux
Installed from:    Debian testing/unstable Packages

Motivation: Dump data and be sure it can easily be read and imported later on (or parsed by another tool).

Ideally, data dump usually shouldn't be needed, as the preferred way for most "stable" user is automatic collection upgrade on software upgrade.

Still this has sometimes not been practicable (or didn't exist), especially when trying out early adopter versions a lot.
Like that, some users like me have stopped using the collection db extensively, as the point might come, where I'd eventually clean out .kde/**/amarok(|rc), as I don't know what all these ''rc''s are for. Even if I'd just leave collection.db where it is I'm not sure if this is causing any problems as the DB format changed.

While playing with the software, I thought that somehow it's a pity that I lost all those (though not many) ratings and labels I entered some day.

Thus, it'd be of great use to be able to dump the DB to a (yet to be defined) format.

Importing from this format would be the logical next step, though there need to be some mechanism for handling duplicates.


Oh. I just notice there is an "import collection" tool builtin nowadays, which probably performs all the black magic.

Still I think adding the ability to export to a flat file (json or something) is useful, especially if this format is properly defined somewhere. 

This doesn't need to be able to export everything which is stored, but a defined set of attributes.
Comment 1 Harry Skelton 2009-09-08 08:11:08 UTC
Flat files are the most recoverable and can be maintained with other programs.  I too vote for a "fix" to flat files.
Comment 2 Tuomas Nurmi 2025-01-04 12:10:16 UTC
Just noting 15 years later:
https://community.kde.org/Amarok/Community/MySQL#Migrating_from_MySQL_Embedded_to_MySQL_Server and https://discuss.kde.org/t/access-amaroks-database/19403 provide a working path for dumping & restoring database. There are also tools to import various database formats in Amarok GUI, so this request is covered.