• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to use "Generate Song List" to create CSV files
#1
You can use "Generate Song List" to create CSV files within MSP

1.) specify the CSV file format
  • go to "Settings > Library Settings > Generate Song List Format" and tap on "Title Format"
  • specify the Fields you want to export
    • re-import into MSP requires at least "TITLE" and "Page Order"
      ("Page Order" can be selected from the list that you open with the "..." button in the "Fields" section)
    • add additional Fields as you like
  • replace the blank that separates the fields by default with a separator that is valid for CSV files (semicolon, tab, comma)
    • semicolon just can be edited in the format line (the easiest choice)
    • "Tab" can be selected from the list that you open with the "..." button in the "Separators" section
      (It's a bit tricky as there is no visual difference between tab and blank. I recommend removing the blank first, than inserting the tab)
    • if you want to use comma as separator and any of the exported fields contains a comma in its text content (which is quite probable for title or composers), you have to enclose that field in double quotes
    • Note: the format line is just text. It can be edited as you like.
  • copy / paste the format line to a text file
    You will need it later as column titles in Step 3.)
    Further more you can copy it back into the dialog.
    This is useful for backup reasons or to keep different song list formats to re-use them later.

2.) export the desired group as CSV
  • go to "Setlists", "Albums", "Collections", "Artists", ...
    (in my library I use a separate "Albums" entry for every fakebook)
  • select the group you want to export by long pressing it in the list
    (don't open it, the check box has to be checked in the list of groups)
  • select "Generate Song List" in the menu to right
  • select "Save to File"
  • specifiy path and filename
    for MSPs CSV import the extension has to be .CSV
    on Android the CSV must have the same name as the according PDF (MyFakebook.csv belongs to MyFakebook.pdf) and has to be stored in the same folder
3.) add column titles to the CSV file
  • navigate to the saved CSV file and open it with a text editor
  • copy / paste the format line from the "Generate Song List Format" settings dialog into the CSV file
  • make sure that the format line is the very first line and the song list starts with the second line, no blank line in between
4.) check your newly generated .CSV file and share it with the MSP forum community ;-)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 2004
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Messages In This Thread
How to use "Generate Song List" to create CSV files - by itsme - 02-03-2019, 03:31 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.