• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fakebook Indexes for CSV import
#48
I needed to import a book of songs and, although my initial thought was to split into separate pdfs, I decided to play around with the CSV import mechanism (just to see how it worked)

Although I've managed to get it to work, the documentation could be improved to make it more obvious. Some of the points below are solely to aid others using this mechanism for the first time.

  1. The PDF and CSV need to be present in the same folder when importing - you can't just import the CSV. Files need to have the same name (apart from the extension)
  2. You can't do import via the Companion program (shame)
  3. In my first try ( the PDF book already  loaded on the tablet), it appeared that MSP was processing both files as I moved sequentially through the pages to check the cropping (as shown by the page/total pages indicator)
  4. There didn't seem to be a way to create/use a collection
     Note for new users: you can specify this in the first line of the CSV file e.g. "title;pages;collections;")
  5. There appears to be an issue removing the songbook so that it can be replaced - deleting it  from the Songs tab doesn't delete the songs that referenced it. Although one can use a filter (quite hard to find) on the Songs tab to identify songs with a common string in their name, there is no "Select All" option to mark them for deletion; it is a pain to mark each song individually.
    In the end I used the Companion program to delete the songs (sort on the collection field and use standard window operations to delete multiple songs)
  6. Looks like if one wants to update the CSV, one will have to effectively remove the songbook and associated songs before reimporting (not fully investigated as had already spent enough time)
  7. When importing the CSV, I had a truncated window showing the entries available for selection (the "outline" box was chopped on the right side of the dialog even though there was plenty of room to display it). The box did show "Select None" (or similar) but I'm sure that when I first attempt  there was a "Select All" on the right of the dialog box. Without a "Select All", I had to manually select each song (for a small number of songs this is ok but if it was a large book!). I tried several times to see if I could get a full dialog but failed (I suppose I should have seen what happened if I had closed/restarted MSP). 
Ideally, it would be nice if someone could create a PDF extraction tool that would take the CSV and PDF and create separate songs. This would allow users to use the same CSV irrespective of how they intended to load the files. 
I'm sure someone is going to tell me that they have such a tool (I think there is something earlier in this thread but I'm ideally looking for something pretty easy to use - not because I'm thick but because I'm not likely to use it extensively and don't want to keep relearning how to use it).

Still a great program

Cheers
Geoff
Samsung Galaxy Tab A6
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 Geoff Bacon - 04-30-2017, 08:18 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-2022 MyBB Group.