• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fakebook Indexes for CSV import
#51
I don't really have a choice on Windows due to the way file permissions work. In order to have permission to access the PDF, the user has to pick it from the Microsoft file chooser. Otherwise my app will be denied access to read the file. I probably should add code to warn the user if they pick a file that doesn't match the CSV name, and require confirmation.

Mike
Reply
#52
How strange is this! That's a difference between Win10 Mobile and the "normal" Win10, right?
Would it be possible to set a default filename (determined by the CSV filename) for the PDF?
A useful additional plausibility check would be verifying that all "pages" entries in the CSV really exist in the PDF.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#53
How about

Code:
PickMultipleFilesAsync()
?

https://docs.microsoft.com/en-us/uwp/api...openpicker
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#54
@itsme
Thanks for the response

Quote:I always add the title of an imported songbook to "Albums" so filtering by album is a snap. As soon as all songs of an album / songbook are selected by a filter "select all" can be done by selecting one of them via long press. Then all songs can be checked in the little box at the bottom right.
I had a collection with only 3 songs in it so I added a common word to their Albums field and applied a filter for this word when displaying the songs tab. A long press displays the check boxes but there is no "little box at the bottom right" so I am unable to "select all" (this is using Android version 1.8.0).

Cheers
Geoff
Samsung Galaxy Tab A6
Reply
#55
I also use 1.8.0. The "Select alll" button is there and works fine, both on Android and on Win10.
Here's how it looks like. I could not find it in the manual, so I don't know the correct term to name it.


Attached Files Thumbnail(s)
   
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#56
@Itsme
Thanks for the screen shot

I have found that this box only becomes visible when the  "Library Settings| Show Floating Toolbar" is ticked.

As I would prefer not to see it by default, I'll have to remember to enable it on the odd occasion that I want to use it (I would prefer to see it as either as an option on the extra items menu or alternatively automatically pop up if any song is checked).

Many thanks for your help
Geoff
Samsung Galaxy Tab A6
Reply
#57
Has anyone done an index for this Lasse Collin book, available here -
http://cjam.lassecollin.se/neworleansjambook.pdf

I started one (which is attached here) by scraping the titles off a website page.

The PDF has bookmarks, but the song title strings are not user-friendly.  I'd like to get the page numbers out of the PDF bookmarks and combine them with the user-friendly song titles in the attached CSV.

I don't have the ability to extract the bookmarks from the PDF.  Wondering if someone who can do that, would be willing to do it and post the bookmarks as a text or CSV file here.

thanks,
Chris 

(PS for mods- I tried to attach an .ods file (LibreOffice spreadsheet) but the forum said that filetype was not allowed.)
Reply
#58
You can save the spreadsheet with LibreOffice in XLS format. XLS can be uploaded to the forum.

Find attached the bookmarks. It's in JPdfBookmarks format. You can try if it really helps.
The New Orleans Jambook contains mostly one song per page. Using the autofilll feature for spreadsheets could also create reasonable results for "pages". I guess that proofreading and correcting the autofilled pages could also be fast and easy.


Attached Files
.txt   NewOrleansJamBook_LasseCollin_bookmarks.txt (Size: 126.7 KB / Downloads: 2)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#59
Thanks very much for sending along the bookmarks - it has indeed helped a lot, partly because the songs in the PDF are different than those in my 'screen scrape' and it was much quicker to merge the bookmarks list with the screen scrape, than it would have been to go thru the PDF itself page by page.  I still have some work to do to clean it up and I'll post it when I think it's more-or-less ready.

Thx on LibreOffice xls as well.  I was aware of that, and just thought it might make sense to allow ods on the forum since that's the native LO format and LO allows CSV export with semi-colon delimiters while excel does not (to my knowledge).  (I'm also just generally inclined to support things like LO which offer alternatives to things like MSFT (Apple, Google, Facebook, Amazon, etc) which have already accumulated so much market power as to be sometimes difficult ... )

All that said, again thanks very much for your several very helpful things over the last couple days!
best - Chris
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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