csv format for import
csv format for import
We use a xcell spreadsheet (which can be saved as csv file) with different columns like a column for lyrics, column for cross reference info, col for author (txt), col for song no. etc. What should the column headings and column order be for successful importation of songs? Be as specific and complete in terms of all possible fields.
The supported fields are:
LYRICS, LYRICS2, TITLE, AUTHOR, COPYRIGHT, CCLINR, PRIKEY, KEY
The first row must contain the headings in *uppercase*. The order is not important.
PRIKEY or KEY should contain the key. You can use any of the two, but not both.
LYRICS contains the text of the song. If the LYRICS column of a song is empty, SongBeamer will look at the LYRICS2 column if it exists. Lines that contain chords must start with a ".". A line that does not contain chords must not start with a ".".
Separate columns with a ";" or a ",". Use the " as the escape character if the text of a column contains a comma, semicolon or line break.
All headings except for LYRICS are optional. If there is no title, SongBeamer will use the first line of the text as title.
LYRICS, LYRICS2, TITLE, AUTHOR, COPYRIGHT, CCLINR, PRIKEY, KEY
The first row must contain the headings in *uppercase*. The order is not important.
PRIKEY or KEY should contain the key. You can use any of the two, but not both.
LYRICS contains the text of the song. If the LYRICS column of a song is empty, SongBeamer will look at the LYRICS2 column if it exists. Lines that contain chords must start with a ".". A line that does not contain chords must not start with a ".".
Separate columns with a ";" or a ",". Use the " as the escape character if the text of a column contains a comma, semicolon or line break.
All headings except for LYRICS are optional. If there is no title, SongBeamer will use the first line of the text as title.
It is excluding the "", but your row would usually start with a " so that you can have line breaks in the song. You could skip the " if your song has only one line, and does not contain a comma or semicolon.
There is no export function at this time. The SongReport plugin from our homepage can export a table with the songs to Excel, but that does not include the text of the songs.
There is no export function at this time. The SongReport plugin from our homepage can export a table with the songs to Excel, but that does not include the text of the songs.
We have created a special version of SongBeamer which can export the songs to the csv format as well. You can use it to create a sample csv file.
http://www.songbeamer.com/bin/SongBeame ... _Forum.exe
This version also fixes a few issues with reading the csv files correctly.
http://www.songbeamer.com/bin/SongBeame ... _Forum.exe
This version also fixes a few issues with reading the csv files correctly.