• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CSVFile for Real Little Classical Fake Book
#5
Didn't you already try to import it into MSP?
At first sight:
good work, pretty complete information entered
but:
it won't work
- column headers are missing
- MSP needs "Pages" in one column e.g. 21-22 (instead of first page, last page in two columns)

It was easy to fix it, see attachments.
In the XLSX you can see the formula that I used to calculate "Pages"
I created the CSV using tab as separator, so that no quotes are required for "composers".
Semicolons are also fine or, as in your original version, using comma as separator and including all strings that contain a comma in quotes.

I was not sure where you want the content of the 4th column (e.g. "Scenes from Childhood") to be stored, so I used "custom2". It's easy to change that as you like.


Attached Files
.xlsx   RealLittleClassicalFakeBook_coldxground.xlsx (Size: 41.49 KB / Downloads: 1)
.csv   RealLittleClassicalFakeBook_coldxground_corrected.csv (Size: 45.43 KB / Downloads: 4)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Messages In This Thread
RE: CSVFile for Real Little Classical Fake Book? - by itsme - 01-18-2022, 03:08 AM



Users browsing this thread:
2 Guest(s)


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