• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fakebook Indexes for CSV import
#27
I have a number of index files in Excel XLS format that I would like to share as soon as the format is clear and I find the time to make necessary adaptions.
Back in the good old pen/paper/binder time I came across the first fakebooks as PDFs. I kept (and still keep) them on the PC and printed single songs for my ring binders. It soon was clear that finding songs is essential. So I started building a database. Some TOCs I could find in the internet some are scanned and OCR'ed. Proof reading, completing and correcting was and still is a time consuming task, a never-ending story.
I keep an XLS file per fakebook for later reference and imported them into an Access database. With MSP the PDFs became much more usable. So I was motivated to invest time in completing the indexes.
I was involved in lengthy disussions in this forum about keeping big fakebook PDFs or splitting them. To keep my library clear I copy useful fakebooks to the tablet (one big PDF per book) but import only those songs that I really want to play. For every book I import the fakebook's TOC pages as one song, the whole book as a second "song". And I export from my database the indexes of only those fakebooks that are on the tablet as one big XLS song index. This way I have some hundreds of songs in a well-maintained library and several thousands at hand that I can use within minutes. I can jump to the respective page in the fakebook via MSP's "go to page" or add a song to the library by copying an existing song in MSP and copy/paste the meta data from the XLS. That works fine so far regarding fakebooks and I will keep that workflow. Songs that are permanently in my repertoire are individual one file per song, fine-tuned and exported as PDF from Finale, MuseScore, WinWord... or ChordPro. But that's another topic.
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


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:
2 Guest(s)


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