• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CSVFile for "Million Dollar Library"
#1
The Million Dollar Library is a downloadable collection of lead sheets in eleven volumes – ten fakebooks plus an index. You can easily find it with your favorite Internet search engine.

The Million Dollar Library nominally consists of 4597 song titles, but some of the pages are missing (likely lost) so 44 songs are gone and one is incomplete. The collection actually consists of 4552 usable titles.


Attached Files
.zip   million_dollar_library_master_index.zip (Size: 140.45 KB / Downloads: 6)
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply
#2
Great. Thank you for sharing.

I'll rename your threads to "CSVFile ...", see https://zubersoft.com/mobilesheets/forum...p?tid=6667

@Frank: I'd like to get in contact with you. As private messages are disabled, please use the contact data from one of my homepages below. Thanks.

@Mike: would it be an option to allow private messages as soon as a buddy request has been accepted?
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
And here's what Frank wrote into the README in the shared zip:
(Just to make it easier to know what can be expected. If you don't like it here, let me know, then I'll remove it again)

Frank wrote:

These files are plain text files in csv format.  They can be loaded into any word processor, text editor or spreadsheet for examination, editing and searching.

The file named master_index includes all of the songs in volumes 1 through 10 of the Million Dollar Library collection of lead sheets.

The other files (1 through 10) are intended to be imported into a sheet music viewing program like Mobilesheets for Android or Forscore for iPad and Mac.

Note that the files numbered 1 through 10 won’t work well with the Million Dollar Library pdf files as they are originally downloaded. The original files have numerous defects, including missing pages, blank pages, a few sideways pages and even approximately the first half of the pages of the first volume being assembled in reverse page order.

To the the most out of these index files and use them with sheet music reading software, you’ll have to fix up the pdf’s so the pages are in the right order and the blank pages are removed.

However, even if you don’t wish to rearrange the pdf’s, this searchable index is still more convenient and readable than looking up the songs in the index volume.  Just load the master index file into your favorite spreadsheet and you can easily find the volume and page number for any of the included lead sheets.

Frank Cox
April 1, 2022
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
I found this update to vol 1. I don't know if it is usable or not.
https://archive.org/details/Million_doll...7/mode/2up
Dell Latitude 13.5" 2-in-1 Ubuntu/Win 11
Samsung Note Pro SM-P900 12.2 Android 5.0.2
Samsung S7+, Android 12
Reply
#5
Good catch, thank you.
A simplified link is https://archive.org/details/Million_doll...ume_1Re-do

It almost matches, just needs an offset of +1 to "pages"

Million_Dollar_Library_01.csv matches the PDF at archive.org
I changed the book name column to "albums" as that's what I prefer to use and added two lines to access the whole book and the table of contents from MSP.
MSP now jumps to the correct page for each song (I only checked a number of songs, please inform me in case there are errors left). Cropping is still required. This can be easily done within MSP and cannot be imported via CSV

Million_Dollar_Library_01_forCSV.xlsx shows the formula to add the offset


Attached Files
.xlsx   Million_Dollar_Library_01_forCSV.xlsx (Size: 55.99 KB / Downloads: 3)
.csv   Million_Dollar_Library_01.csv (Size: 66.93 KB / Downloads: 1)
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
Volume 1 is the worst for out-of-order pages, but a few of the later volumes have duplicated and missing pages as well.  As I recall, about three volumes are just perfect as they are but the rest need a bit of work to become really useful.

I just ripped them apart with pdfseparate, sorted what was out of order, junked the duplicates and re-assembled the result.
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply
#7
I have re-enabled private messaging. Hopefully users won't get too many spam direct messages from fake accounts. I've only been contacted about that being a problem once, so it's obviously not bothering people too much if it does occur.

Mike
Reply
#8
Could you tell which of the volumes are "just perfect"?
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
#9
Gosh, when I was working on this I had a note of what changed where so I could fix up the individual book index file after modifying the pdf but when I finished polishing it I deleted the note. Confused   Frankly, it never occurred to me that anyone else might want that information though it seems fairly obvious now in hindsight.

However, it should be fairly easy to figure that out -- if the page number of the final song in the csv file matches the actual page in the pdf, then that's probably one of the good ones.  It's some of the middle volumes that were just fine -- 5 through 8 or 9 or something along those lines.  Needless to say I was pretty happy when I came across those ones.  Smile

It took about three weeks of off-and-on fiddling around to fix the pdf's and make the index, but making the index was the biggest part of the job since I had to retype a lot of it.  (And I'll guarantee that some of the page numbers are still wrong since a lot of the 3's, 6's,8's, 9's and 0's got mixed up.)

Fixing the downloaded pdf's to get rid of the duplicates, fix the page order and rotate what's sideways and so forth shouldn't take anyone more than maybe an afternoon or so since you can use those indexes as a guide to what needs to be changed.  And maybe you'll find some more of my incorrect page numbers in the process.  (I do know that all of the volume numbers are correct.)
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
2 Guest(s)


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