• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fakebook Indexes for CSV import
#1
Great that CSV import is available now.
It would be great if we would share our index files to reduce everyone's effort.

I make a start with the "Firehouse Jazzband Fakebook"
https://archive.org/download/fakebook_th...k_text.pdf

edit :
Sorry, the link is wrong. Please use
https://archive.org/download/fakebook_th...kebook.pdf
instead. See my post dated 2016-01-12. Sorry for any inconvenience.
itsme


A fine collection of jazz tunes in a tablet friendly layout

Use at your own risk! I did NOT test it by now! Make backups before testing!

I had to rename the .csv to .csv.txt as the forum refused to upload it with .csv extension
And I also attached the .xls that was the basis for the csv export for reference and further editing.
Notes for the additional columns in the .xls:
"Index" is the index as listed in the fakebook's table of contents, in this case it's the song number
"PDFPage" is the song's first page in the PDF file
"PDFLastPage" is the song's last page in the PDF file
"(calc. LastPage)" and "(calc. PageOrder)" are intermediate, used to calculate PDFLastPage and PageOrder

This is a tricky example as the scanned PDF contains some songs with interchanged pages. This is corrected with PageOrder entries like "106,105". Respect and thanks to Mike that even this could be handled easily in MSP!


Attached Files
.xls   Firehouse Jazz Band - Commercial Dixieland Fake Book_archive.org_MSP.xls (Size: 123.5 KB / Downloads: 40)
.txt   Firehouse Jazz Band - Commercial Dixieland Fake Book_archive.org_MSP.csv.txt (Size: 18.06 KB / Downloads: 96)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 2004
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Messages In This Thread
Fakebook Indexes for CSV import - by itsme - 01-06-2016, 09:23 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-06-2016, 11:19 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-07-2016, 12:46 AM
RE: Fakebook Indexes for CSV import - by BRX - 01-07-2016, 12:54 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-07-2016, 04:21 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-07-2016, 04:28 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-07-2016, 04:34 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-07-2016, 05:02 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-07-2016, 09:28 AM
RE: Fakebook Indexes for CSV import - by BRX - 01-07-2016, 08:19 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-07-2016, 06:40 AM
RE: Fakebook Indexes for CSV import - by sciurius - 02-08-2016, 01:14 AM
RE: Fakebook Indexes for CSV import - by sciurius - 02-28-2016, 12:02 AM
RE: Fakebook Indexes for CSV import - by BRX - 01-07-2016, 08:14 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-07-2016, 08:39 PM
RE: Fakebook Indexes for CSV import - by itsme - 01-12-2016, 10:06 AM
RE: Fakebook Indexes for CSV import - by aspiers - 01-19-2016, 09:42 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-19-2016, 10:57 PM
RE: Fakebook Indexes for CSV import - by aspiers - 01-20-2016, 02:33 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-20-2016, 10:52 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 02:26 AM
RE: Fakebook Indexes for CSV import - by aspiers - 01-21-2016, 03:43 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 04:44 AM
RE: Fakebook Indexes for CSV import - by aspiers - 01-21-2016, 05:08 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 04:49 AM
RE: Fakebook Indexes for CSV import - by aspiers - 01-21-2016, 05:24 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 07:38 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-21-2016, 08:20 AM
RE: Fakebook Indexes for CSV import - by itsme - 01-21-2016, 08:47 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 06:50 PM
RE: Fakebook Indexes for CSV import - by sciurius - 01-21-2016, 06:57 PM
RE: Fakebook Indexes for CSV import - by itsme - 01-21-2016, 08:20 PM
RE: Fakebook Indexes for CSV import - by BRX - 01-22-2016, 02:36 AM
RE: Fakebook Indexes for CSV import - by sciurius - 01-22-2016, 03:44 AM
RE: Fakebook Indexes for CSV import - by itsme - 03-10-2016, 09:36 PM
RE: Fakebook Indexes for CSV import - by sciurius - 03-11-2016, 06:28 AM
RE: Fakebook Indexes for CSV import - by sciurius - 03-29-2016, 12:29 AM
RE: Fakebook Indexes for CSV import - by sciurius - 03-29-2016, 06:31 AM
RE: Fakebook Indexes for CSV import - by itsme - 04-20-2016, 03:42 PM
RE: Fakebook Indexes for CSV import - by itsme - 04-21-2016, 01:30 AM
RE: Fakebook Indexes for CSV import - by itsme - 05-04-2017, 07:25 AM
RE: Fakebook Indexes for CSV import - by itsme - 05-04-2017, 07:43 AM
RE: Fakebook Indexes for CSV import - by itsme - 05-04-2017, 05:36 PM
RE: Fakebook Indexes for CSV import - by itsme - 05-04-2017, 05:48 PM
RE: Fakebook Indexes for CSV import - by itsme - 05-05-2017, 07:09 AM
RE: Fakebook Indexes for CSV import - by chrisss - 05-14-2018, 05:08 AM
RE: Fakebook Indexes for CSV import - by itsme - 05-14-2018, 05:57 AM
RE: Fakebook Indexes for CSV import - by chrisss - 05-15-2018, 01:29 AM
RE: Fakebook Indexes for CSV import - by reggoboy - 03-08-2020, 01:44 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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