• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MobileSheetsPro 1.3.1 and MobileSheetsPro Companion 2.2.3 Released
#31
Just for my clarification, 

Quote:Fields that need to contain the separator character should be quoted using double quotes (ASCII 34). If a quoted fields need to contain quotes itself, see RFC 4180.
If I save from Excel to CVS would the quoting be automated?
I don't have to "quote" commas myself in the field if I want to use commas for multiple field data like composer (or if it is used in a title)?
Reply
#32
I don't know (neither do I want to know) Excel, but quoting should be handled by the exporter, and never manually added to the field data.
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup tablet).
Samsung A3 (SM-A320FG), Android 7.0 (emergency).
Reply
#33
[quote pid='13484' dateline='1451811153']
CSV Format

In order to use CSV files, it's expected that either a PDF with the exact same name as the CSV is present in the same directory or the first line of the CSV has a path to a valid PDF file. Then the fields to populate must come next. Two columns are required: title and pages. Other supported column names includes:
  • artists
  • albums
  • genres
  • composers
  • source types
  • custom groups
  • keys
  • signatures
  • custom
  • custom2
  • tempos
  • difficulty
  • duration
  • rating
  • years
  • sort title
  • audio files
  • keywords
  • setlists
  • collections
If a column is listed (other than title and pages) that you don't to populate for a song, you can leave it blank. All columns must be comma-delimited. Each value must be delimited using the | character. So, the following example could be used:

title,pages,composers,tempos
SongA,1-3,ComposerA|ComposerB,120
SongB,4-5,,

Neither composer or tempo is listed for the second song. When the CSV is imported, both songs will be listed and can be created at once if desired.

Mike
[/quote]

Can you list multiple titles for the same song? For example, 
Alleluia! Alleluia!|Hymn to Joy
would result in two songs being created with different titles using the same pages, composers, etc?
SmarTab StreaMachine 13.3", Android 4.4.4, AirTurn PED
Reply
#34
Currently you cannot split titles like that to create multiple songs from the same line in the CSV. If that is something that would be useful to people, I can certainly look into adding that.
Reply
#35
Nah, don't worry about it, it is just as easy to create a new line with the 2nd title and refer to the same page set.
SmarTab StreaMachine 13.3", Android 4.4.4, AirTurn PED
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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