2018-09-28, 23:08
Not sure if anyone cares about this... but I thought I might as well post this just in case.
I've been on a mission for a while to make my Kodi music DB more cloud based with the track and album ratings script I previously posted. The next task was to write something that imported my Last.fm play data into Kodi.
I've been using Last.fm for over 10 years now and have a personal history of about 15,000 plays. I wanted to get this synced up with my music DB after I wiped it accidentally during testing.
These instructions are not for normal users, but someone with better Pyton skills than me (its my first attempt) can probably make an Add-on that works more integrated.
Step 1 - export your last.fm music history
I used this site to create a csv of all my plays https://benjaminbenben.com/lastfm-to-csv/
Step 2 - Edit the CSV
We need to add headers to the CSV file, I just added a new text line at the top with
Step 3 - Import into a sqlite db
I then used db browser for sqlite to import the csv into a database.
Save the DB created as lastfm.db and copy it into a folder called "c:\script\databases"
Step 4 - grab your kodi db
I just copied my raw kodi music database to the same folder as above. in this case its MyMusic72.db
Step 5 - run the python script
Copy the python code into a new file called something like "last_fm_import.py" into "c:\script"
Assuming you have a python 2.x environment setup the script should match songs and update the mymusic72 with all your last.fm plays.
https://gist.github.com/zag2me/9b8625100...bc1c580b50
Step 6 - copy back the kodi music db
Simply copy the database back to kodi userdata folder.
The end result is 10 years of song play history in my Kodi
I've been on a mission for a while to make my Kodi music DB more cloud based with the track and album ratings script I previously posted. The next task was to write something that imported my Last.fm play data into Kodi.
I've been using Last.fm for over 10 years now and have a personal history of about 15,000 plays. I wanted to get this synced up with my music DB after I wiped it accidentally during testing.
These instructions are not for normal users, but someone with better Pyton skills than me (its my first attempt) can probably make an Add-on that works more integrated.
Step 1 - export your last.fm music history
I used this site to create a csv of all my plays https://benjaminbenben.com/lastfm-to-csv/
Step 2 - Edit the CSV
We need to add headers to the CSV file, I just added a new text line at the top with
Code:
Artist,Album,Title,DatePlayedStep 3 - Import into a sqlite db
I then used db browser for sqlite to import the csv into a database.
Save the DB created as lastfm.db and copy it into a folder called "c:\script\databases"
Step 4 - grab your kodi db
I just copied my raw kodi music database to the same folder as above. in this case its MyMusic72.db
Step 5 - run the python script
Copy the python code into a new file called something like "last_fm_import.py" into "c:\script"
Assuming you have a python 2.x environment setup the script should match songs and update the mymusic72 with all your last.fm plays.
https://gist.github.com/zag2me/9b8625100...bc1c580b50
Step 6 - copy back the kodi music db
Simply copy the database back to kodi userdata folder.
The end result is 10 years of song play history in my Kodi
