• 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: 30)
.txt   Firehouse Jazz Band - Commercial Dixieland Fake Book_archive.org_MSP.csv.txt (Size: 18.06 KB / Downloads: 69)
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
#2
A great initiative!

When importing such a fake book I feel a desparate need to be able to assign all the imported songs to a specific category, setlist and/or source.
Preferrably a separate database but that's being worked on...
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#3
On second thought, it is very easy to use the pagerange info from the csv to split the pdf into individual songs.
Mike: What is most efficient: A single big file and a lot of pageranges, or a lot of small pdf documents?
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#4
Great post. I was considering to open a thread myself or to revive the old discussion in

http://zubersoft.com/mobilesheets/forum/...p?tid=1936 with aspiers index project. So thanks for being quicker.

I suggest we could use this thread for questions, suggestions etc. as well.

Mike,

what happens if a song/pdf is already imported and is now newly imported with a cvs?

For instance I already have the Firehouse Fake Book in MS and now I import it again for the single titles with itsme's cvs?

Is it possible to update already imported songs/single titles with an updated cvs and running the import again?
Will the old metadata be overwritten completely or is there (or will be) an option to update only empty fields? For instance when you added new metadata for composers in the cvs but the rest stays the same?

What happens if you happen to have double entries in multiple field names (for instance for composers and lyricist). Is there a conflict or does MS simple allow only one entry?

And once back to the delimiter question. I'm not sure if semicolons were actually the "preferered" delimiters for columns in our discussion. There was consent they are preferable to commas.

I've already written why I prefer tabs as column delimiters and semicolons for multiple items. Ultimately it's your choice which is most practicable to use and program. But I think one big concern should be, that one should be able to save a csv or text directly from Excel without the need to edit it again.

Maybe I'm overlooking something, but I don't see an option in Excel to save a semicolon delimited file (a tabbed one though).
Reply
#5
@Sciurius: the list of supported meta data fields is here:
http://zubersoft.com/mobilesheets/forum/...p?tid=3192
source types, collections and setlists are in the list
This is one of the reasons why I attached also the .xls file: you can easily  edit into it what you want and it allows some automated formatting for whatever you want to do with it.
Splitting the PDF is just one possibility. Splitting also leads to the task to rename the resulting files.
I import my xls indexes into a database. This allows searching for a specific song over all my fakebooks. And I export an xls containing only those fakebooks that are currently on my tablet.
I skipped the idea of importing all songs of all fakebooks into MSP. I leave the fakebooks intact as big PDFs, copy those fakeboks that seem useful to the tablet and import just those songs into MSP that I really plan to use.
I was not facing any performance issues so far with this method.
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
#6
@BRX: Semicolons as delimiters was the result of the discussion and is implemented in 1.3.2
I already recommended in another post to use LibreOffice Calc. It allows selecting from a number of common delimiters. LibreOffice is free and runs as portable version from a USB stick.

Good idea to involve aspiers. We already discussed extending his collection with some more useful columns, now we should know which columns in what format are required.
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
#7
I just sent a private message to aspiers
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
#8
There are a few errors in the page ranges.
Song I'm Gettin' Sentimental (F) has page 386A, this should be 558.
Song I'm Gettin' Sentimental (Bb) has page 386B, this should be 559.
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#9
Some strange things happen...

I've added some fields to the csv: collections, genres and source types. I then imported it into MSPro.
The (new) collection contains all the imported songs. Good.
When I select one of the imported songs from the songs list (long press), and press "edit song" I see the Fields tab, that has all the metadata except for collections. At the Files tab, the PDF and page range is shown.
Back to the main screen.
When I select the collection, and then select (long press) a song, and press "edit song" I see no files. At the Fields tab, there are no fields.

Exit MSPro, restart.
All songs are still there, but the collection is now empty.


Attached Files
.txt   firehouse_csv.txt (Size: 44.45 KB / Downloads: 7)
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#10
(01-07-2016, 05:02 AM)sciurius Wrote: There are a few errors in the page ranges.
Song I'm Gettin' Sentimental (F) has page 386A, this should be 558.
Song I'm Gettin' Sentimental (Bb) has page 386B, this should be 559.

you're right, thanks for letting me know
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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