Migrate all playlists from old banshee.db to new one

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Migrate all playlists from old banshee.db to new one

7even
Hi all,

I have a new OS installation and am too lazy to recreate all my playlists manually.
In banshee.db I can see some tables that clearly are related to playlists.

My assumptions:
- CorePlaylists defines static playlists
- CoreSmartPlaylists defines dynamic playlists
- CorePlaylistEntries stores the tracks of the static playlists
- CoreSmartPlaylistEntries cache the tracks for the dynamic playlists
- It seems too complicated to migrate the static playlist's contents, cause the track ids differ for sure
- But there should be no problem to migrate the dynamic playlists without the cached entries
- Can s. o. tell me what the CoreSmartPlaylists.PrimarySourceID is about? This seems to be the only foreign type in this table...

Any additional advices?

Thanks!
Nicolas
Reply | Threaded
Open this post in threaded view
|

Re: Migrate all playlists from old banshee.db to new one

chrisperro

Hello Nicolas,

CoreSmartPlaylists.PrimarySourceID refers to coreprimarysources.PrimarySourceID. A Primary source refers to a source of media : music, video, etc. You can see in coreprimarysources that the default Banshee music library has PrimarySourceID = 1.

If you rebuild your music DB, you can try to recreate your static playlists by using a copy of your original coretracks table by matching your tracks TrackID on their Uri, if they kept some common part in their path. I did this in the past and it worked well!

Regards,

Christian


Le 2016-08-18 à 15:36, 7even a écrit :
Hi all,

I have a new OS installation and am too lazy to recreate all my playlists
manually.
In banshee.db I can see some tables that clearly are related to playlists.

My assumptions:
- CorePlaylists defines static playlists
- CoreSmartPlaylists defines dynamic playlists
- CorePlaylistEntries stores the tracks of the static playlists
- CoreSmartPlaylistEntries cache the tracks for the dynamic playlists
- It seems too complicated to migrate the static playlist's contents, cause
the track ids differ for sure
- But there should be no problem to migrate the dynamic playlists without
the cached entries
- Can s. o. tell me what the CoreSmartPlaylists.PrimarySourceID is about?
This seems to be the only foreign type in this table...

Any additional advices?

Thanks!
Nicolas



-----
http://www.nskcomputing.de | http://www.site7even.de | http://x4fun.site7even.de
--
View this message in context: http://banshee-media-player.2283330.n4.nabble.com/Migrate-all-playlists-from-old-banshee-db-to-new-one-tp4652502.html
Sent from the Banshee Media Player mailing list archive at Nabble.com.
_______________________________________________
banshee-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/banshee-list  (unsubscribe here)


_______________________________________________
banshee-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/banshee-list  (unsubscribe here)