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!
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
(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!
[
attachment=1787]
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.
some more corrections and refinements