• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CSVFile for Real Little Classical Fake Book
#1
Hi, does anyone has a CSV index for “The Real Little Classical Fake Book” by Hal Leonard? I’ve searched through with little luck. 

I want to ask before I make my own from scratch. 

Cheers!
Reply
#2
Not a complete CSV file, but a good starter.
I have a version of the "Real Little Classical Fake Book" with PDF bookmarks.
I exported the bookmarks into a CSV file and added column headers.
"Title" and "PDFPage" are from the bookmarks. "PDFPage" is not an MSP database field so it will be ignored by MSP's CSV import.
MSP uses column "Pages". It is currently a copy of "PDFPage". "Pages" has to be corrected for songs with more than one page. I did that for 20-21 and 22-23 as an example, there's still more to do.

If you take the effort to complete the CSV please share the result. Thank you.
The title entries also have some room for improvement and adding the composers would be helpful.
More info to copy/paste might be here:
http://www.michaelsattler.de/realbooks/c...-book.html
https://www.sheetmusicplus.com/title/the...ic/2888778
https://www.halleonard.com/product/24002...nd-edition


Attached Files
.csv   RealLittleClassicalFakeBook.csv (Size: 35.86 KB / Downloads: 5)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 21H1
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#3
I hope it's OK for you that I changed the thread title to "CSVFile for ..."
see https://zubersoft.com/mobilesheets/forum...p?tid=6667
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 21H1
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#4
(01-17-2022, 08:05 PM)itsme Wrote: Not a complete CSV file, but a good starter.
I have a version of the "Real Little Classical Fake Book" with PDF bookmarks.
I exported the bookmarks into a CSV file and added column headers.
"Title" and "PDFPage" are from the bookmarks. "PDFPage" is not an MSP database field so it will be ignored by MSP's CSV import.
MSP uses column "Pages". It is currently a copy of "PDFPage". "Pages" has to be corrected for songs with more than one page. I did that for 20-21 and 22-23 as an example, there's still more to do.

If you take the effort to complete the CSV please share the result. Thank you.
The title entries also have some room for improvement and adding the composers would be helpful.
More info to copy/paste might be here:
http://www.michaelsattler.de/realbooks/c...-book.html
https://www.sheetmusicplus.com/title/the...ic/2888778
https://www.halleonard.com/product/24002...nd-edition

I actually since created my own.  Let me know how it works!

.csv   Real Little Classical Fake Book.csv (Size: 48.21 KB / Downloads: 5)
Reply
#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: 0)
.csv   RealLittleClassicalFakeBook_coldxground_corrected.csv (Size: 45.43 KB / Downloads: 2)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 21H1
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#6
some more corrections and refinements


Attached Files
.csv   RealLittleClassicalFakeBook_HL.csv (Size: 50.32 KB / Downloads: 9)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 21H1
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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