artemanufrij / playmymusic

An elementary OS app
http://anufrij.org/melody
95 stars 26 forks source link

Import playlist #159

Closed shawn1thompson closed 4 years ago

shawn1thompson commented 5 years ago

I am moving away from Google Play Music and have exported all my playlists to CSV files. Is there a way to import these into Melody? Thanks.

artemanufrij commented 5 years ago

Could you send me an example?

shawn1thompson commented 5 years ago

artist,album,title,duration,playcount,rating,ratinginterpretation "Amerigo Gazaway","Single","Summertime","2:41","1","0","not-rated" "Amerigo Gazaway","The Cool Out Corner (Summer Mixtape)","The Cool Out Corner (Summer Mixtape)","1:09:34","2","1","thumbs-down" "","","The Magnificent DJ Jazzy Jeff - Summertime Mixtape Vol 7 (DJ Jazzy Jeff & Mick).m4a","1:07:33","","0","not-rated" "","","MICK - DJ Jazzy Jeff & MICK Summertime Vol 8.m4a","1:08:21","","0","not-rated" "","","The Magnificent DJ Jazzy Jeff - Summertime Mixtape Vol 9.m4a","1:15:20","","0","not-rated"

summertime.txt

I renamed the attachment to txt as it wouldn't let me upload csv.

artemanufrij commented 5 years ago

Have you all the tracks on your local machine?

shawn1thompson commented 5 years ago

Yes

Shawn Thompson shawn.thompson@politicalphilosopher.xyz "Each one teach one"

-------- Original Message -------- On Nov 17, 2018, 10:23 AM, Artem Anufrij wrote:

Have you all the tracks on your local machine?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

shawn1thompson commented 5 years ago

Where are playlists stored?

artemanufrij commented 5 years ago

in a database

artemanufrij commented 5 years ago

~/.cache/com.github.artemanufrij.playmymusic/database

shawn1thompson commented 5 years ago

I've installed DB Browser for SQLite. If you can, could you point me in the right direction for importing directly into the DB? I have some DB experience, but not a lot. Thanks. I can document what I do as well as any difficulties I encounter if it helps.