What is the proper format of the music database file?

To use your own music database instead of the default database you must upload a file to the server containing your list of songs. The file can be in either Excel or Text Format.

You can use one of these programs to generate the file:

Text Format File

Your music database file should be:

  • Comma-delimited: commas separate values
  • Double-quote qualified: values enclosed by the " symbol
  • Named music.txt or music.csv

Excel Format File

Your music database file should be:

  • Named music.xls

Database Field Order

  1. Artist - required
  2. Song - required
  3. Album - optional
  4. Genre - optional
  5. Track # / ID - optional

Field Order/Requirement Note

If want to use the Genre field and don't have any data for the Album field, you must include a blank value for the Album. This also applies to the Track field. If you want to use the track field you must have values for the Album and Genre.

Sample Contents of Text File

Fields You Want To Include

Sample Entries

Artist, Song "Rolling Stones","Satisfaction"
"Michael Jackson","Billie Jean"
Artist, Song, Album "Rolling Stones","Satisfaction","Greatest Hits"
"Michael Jackson","Billie Jean","Thriller"
Artist, Song, Genre "Rolling Stones","Satisfaction","","Greatest Hits"
"Michael Jackson","Billie Jean","","80's Dance"
Artists, Song, Album, Genre "Rolling Stones","Satisfaction","Greatest Hits","Classic Rock"
"Michael Jackson","Billie Jean","Thriller","80's Dance"
Artists, Song, Album, Genre, Track

"Rolling Stones","Satisfaction","Greatest Hits","Classic Rock","3"
"Michael Jackson","Billie Jean","Thriller","80's Dance","6"