https://bugs.kde.org/show_bug.cgi?id=519886

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REPORTED                    |RESOLVED
         Resolution|---                         |DOWNSTREAM

--- Comment #1 from [email protected] ---
... just in case of interest for others: in principle it is possible to
migrate/merge the audiotube library. This is what I did:
1) collect all your sql libraries from the various installations (distro or
computers). Name is library.sqlite.
2) I'm lazy so installed a GUI app to handle the library.sqlite database(s),
and export/import as csv the tables
2) libraries may be under $HOME/.var/app/org.kde.audiotube/data/KDE/audiotube
or under .local/share/KDE/audiotube, depending if you installed from flatpak or
distro package
3) extract (exporting as csv) from all the library the table "songs" (naturally
using differents names or path for the exported csv)
4) merge all the "songs" csv. I used libreoffice, importing the csv one by one
in calc. cut&paste in a new sheet. Use the merge capability present in
libreoffice calc.
5) export the sheet (result of all the imported csv merged) to a new csv. 
6) import the new csv into one the library.sqlite that now becomes the
reference library
7) repeat the same process for other tables of interest. I did for
"favourites", and "playlists"

once you have the reference library.sqlite as you like, copy the file into your
other installation. In my case for example I copied the library.sqlite, from my
desktop to my tablet.

If you are familiar with sql language you could in principle use it to obtain
the same result I guess. It would be a much more elegant solution then the
tedious one I used, but I just wanted to use a completely "GUI" approach (...
I've lost my db programmer skills many many years ago ... sigh)

Have fun!

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to