Spotify changed their APIs and deprecated "libspotify" a few years ago. This left us along with many others with no access to our playlists.
This can be fixed with a good work-around!
It is still a slightly manual process, but quite possible to automate.
To use our playlists again, we need to add the Spotify track entries back into the MPS4's database.
They are in a special format that the enclosed excel workbook prepares for a "simple" cut & paste operation.
This write-up is still pretty complex, so I would appreciate any input to make it clearer.
Requirements and preparations:
- SQLite.exe; download it and install on your normal computer, not the MPS4; https://www.sqlite.org/index.html
- Enable access to the database folder on the MPS4: C:\Documents and Settings\All Users\Application Data\Autonomic Controls\Data.
Change the security settings for this folder and "share" it and add user group "everyone" (=your network only!) with read & write access. Thereby you can update the database remotely and avoid installing SQLite on the MPS4 (don't know if it is even possible!).
This may be the trickiest part where we need detailed experience from someone with an untouched MPS4. The MCS SW could be blocking changes made to folders. Power cycling most likely necessary.
- Login and download your own playlists as CSV files: https://rawgit.com/delight-im/export...exportify.html
- Open the enclosed Excel Workbook. It is macro enabled and probably only works on Windows. It is virus free, trust me!
0. Open Nuvo web app or iOS app.
1. Add 1 track in the app's Radio/Spotify/ menu (top tracks). This creates a Queue.
- Let it start playing, then press pause.
2. Open the relevant media Queue database
- Launch SQLite
- Open the last modified queue database in the folder above. It looks like "[email protected]
- Open the "Mixed" table.
- Copy the "url" cell from the top track item and paste it in B5 in the Excel sheet.
- Save the sheet to update your set-up
3. Harvest your playlist
- Download a specific playlist from https://rawgit.com/delight-im/export...exportify.html
. It will be called *.csv
- Open the Playlist tool and press the Macro button to open the file
Alternative manual process if the macro fails.
* Open the CSV file in excel. Copy all the cells from A2 down (i.e. column A without headers).
* Optional: There is a little issue with excel destroying unicode characters. If extensive, first open CSV-file with Notepad and then save CSV back in UTF-8 format.
* Paste data into the sheet starting at Cell B23 in "Spotify Playlist Tools".
* Select the Data tab. Choose "Text-to-columns". Delimit with a comma ",". Finish. --> your data fills out the input area.
* Careful to not overwrite the output fields (computed database entries)!
4. Update the media queue database
- Press "insert multiple rows" (icon) in the SQLite "Mixed" table menu .
- Copy the "computed database" table in Excel (cells N:V)
- Paste starting on row 2 (ID2).
- Press Ctrl-Return/Enter to commit (=save).
- Exit SQLite.
5. Select Queue in the app.
- Erase the first track entry if you don't like it
6. Save Queue as a new Nuvo Playlist.
7. Clear the queue and then select the new playlist as usual (it can take a little while to appear)
8. Press play all
- make sure that your Spotify playlists are fresh. Some tracks seem to fail, possibly due to being obsolete or changed.
- a few tracks only play for a period of the song. I can not explain this.
- cover art does not work. The same (non-functionning) data is used for all cover art. I have not figured out how to inject the correct cover art links per track.
- for the second playlist, clear the queue and jump directly to step 3. Change cell N23 to a 1.
Good luck and please give detailed feedback so that we can improve this important method before it gets automated.
(please do not quote the entire write-up as I will edit it)