File format options
Spinitron can import three different types of data:
- A table of disks — Spinitron adds the imported data to your database's Artists, Disks, and Labels tables. Songs are not imported. No playlists are generated. Artist and disk name fields are required while others are optional.
- A table of songs on disks — in addition to importing disks as above, Spinitron also adds songs to your Songs table but does not put them into playlists. Artist, disk and song name fields are required while others are optional.
- Playlist data — Spinitron additionally puts the songs into playlists. Artist, disk and song name fields are required while others are optional.
When importing disks or songs on disks, Spinitron does not duplicate artist, disk or label entries already in the database, instead it updates matching entries with new information in the import file. This is also true for songs when importing "A table of songs on disks" since the songs do not belong in any playlists. However, when importing playlist data or playlists themselves, Spinitron creates a new song entry for every song in the import file because it tracks every spin of a song in playlists separately.
Different computer programs have different ideas about CSV/TSV file format. Spinitron's format options allow compatibility with these variations in the CSV and TSV file formats. This option allows Spinitron to read CSV or TSV files.
- CSV files, by definition, use commas to separate columns in the file.
- TSV (Tab Separated Values) files are quite common too—iTunes exports playlists in TSV, for example.
Spinitron uses UTF-8 encoding internally but your file may be encoded differently. Spinitron can convert to UTF-8 from some other common encodings (ASCII, UTF-16, ISO Latin 1 aka ISO-8859-1 and WinLanin1 aka Windows-1252).
If you don't know your file's encoding, you can safely use trial and error: look for blank rows, characters that aren't displayed right, especially non-English and other non-ASCII characters, or general gobbledygook. If something looks wrong, try a different encoding and click the Refresh display button.