SpotifyBingoCardGenerator
v1.0.0
Create cards to play a Music Bingo.
The data source is a comma delimited CSV-file with three columns:
Song title
Artist
Name of the person that chose the song (can be empty)
The Greatest Show,Hugh Jackman - The Greatest Showman Ensemble,Vik
Rode rozen in de sneeuw,Marva,Omer
Macarena,Los Del Rio,For each person that selected a song, a card will be generated containing all the songs selected by the person and random songs until the card is full. The own songs are marked in grey, and the other songs show the name of person that chose the song (if available).
Export the playlist and add the persons names as described below
Update the filename in the Application class
Create a playlist in Spotify
Select the playlist in https://watsonbox.github.io/exportify/ and click "Export"
Copy the CSV file to /src/main/resources
Open the file with a spreadsheet editor, and only keep the song and artist column
Add a column with the name of the person who selected the song, not all songs need a name
Search and replace all commas
