Cynthian Version 7 Set-up and brief explanation. 1. Copy your main database to a new directory along with a copy of your secrets.py and refresh.py 2. Copy the following files to the same directory:- Violet Database Update v2.1.py Violet v3.1.5.py Cynthia-V.7.6.2.py Sched7.py (Not strictly necessary. but this is set-up for Cynthia-V.7.6.2.py already) 3. In VS Code amend the files as follows:- Cynthia-V.7.6.2.py:- Swap the asterisk on lines 17 & 18 Violet v3.1.5.py:- Swap the asterisk on lines 20 & 21 Violet Database Update v2.1.py:- Swap the asterisk on lines 16 & 17 AND make sure the database name is set correctly in line 21 4. If you feel brave run Violet Database Update v2.1.py.... It will take a while but should update the display every 100 records amended. 5. Shouldn't really be necessary but I would run Violet v3.1.5.py now. Just to make sure it works correctly..... 6. Run Cynthia-V.7.6.2.py for the first time.... Hopefully it will perform OK and should just pick up your current queue tracks. It will, however create 2 new playlists (fingers crossed) 1) URI/Artist Discrepancies 2) Database Omissions/Discrepancies These names will be preceeded by your database name. (Mine is "Endless") Tracks are kept in here for 7 days before removal for investigation if required There will also be additional tables found in the database 1) Erroneous_Data. Which contains the ID of the new playlists 2) Last_Played_Tracks. Which will contain a list of ALL Last Played Tracks in the database. The last time they were played is included. 3) tmp_played. This is a temporary table that is used to ensure only the real Last played date and time is used in the database (partial playing of tracks caused problems) 4) URI_Change This contains records of autopmatically changed URI's. Where Spotify doesn't play the URI in the queue so Cynthia changes the URI in the database and feed playlist to that played. This table keeps a record of both URI's in case they are wanted to be replaced to the original. That's it for now. Detailed working notes WILL be available after flood testing by Viking Industries