• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CSVFile for "Busk it! Country"
#1
Busk it! Country


Attached Files
.csv   Busk it! Country.csv (Size: 10.22 KB / Downloads: 9)
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply
#2
"Pages" in CSV files for MSP should contain the page range to work correctly in case of multi page songs.
e.g.
Achy Breaky Heart;20;BuskItCountry|leadsheet;country
should be
Achy Breaky Heart;20-21;BuskItCountry|leadsheet;country
or
Achy Breaky Heart;20,21;BuskItCountry|leadsheet;country

I have an incomplete PDF of this fakebook and attach my CSV. It might be helpful.


Attached Files
.csv   BuskItCountry_incomplete.csv (Size: 3.84 KB / Downloads: 2)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#3
I've just started the process of getting my music into Mobilesheets so I'm creating CVS files based largely on some quick ocr (or the occasional lucky find of a text-based table of contents) and a bit of math and some thought.  Smile

While it's nice to have multi-page songs specified in the csv, it's also straightforward to add the second (third, fourth...) page to the song properties after it's been imported.  I generally want to crop the images a bit before I put them into use so adding any additional pages isn't much of a hardship at that point anyway.

I'm really just creating these csv files for my own use and thought I would share them here for anyone else who might find them useful.  If you'd prefer not to have "incomplete" csv's where the second page of a multi-page song isn't specifically accounted for like this, I can stop.
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply
#4
Please don't take me wrong, I really appreciate what you're doing. I just want to share my experience and try to help.
In case only the start page is available, e.g. when you start with a bookmarks export or an OCRed table of contents it's not too difficult to calculate a correct "pages" column. It might be much easier than completing the pages in MSP.
I add an XLS with an example. I sort by PDFPage (the start page), calculate PDFLastPage, combine them in calc. PageOrder and use "copy content" to fill "Pages". There might be easier ways, but it works for me.


Attached Files
.xls   XLSExample_forDB.xls (Size: 21 KB / Downloads: 2)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#5
You've certainly got a much more elaborate system going there than I do.  I just start with anything that looks like a table of contents and load that into vim where I can clean it up and make a csv file out of it, then load that into (in my case) libreoffice and create a column for offsets, export the result and call it a day.

I started out with the objective of making a searchable index for the Million Dollar Library.  A week or so after I started the project I suddenly realized that getting that index into Mobilesheets would be the perfect way to use it.  Now I might as well keep going and get the rest of my music into it.
If you're a zombie and you know it, bite your friend!
We got both kinds of music: Country AND Western
Reply
#6
A completed and updated CSV. Pages column fixed and Keys added.
And a bookmarks file that can be used with jPDFBookmarks


Attached Files
.csv   BuskItCountry.csv (Size: 9.13 KB / Downloads: 12)
.txt   BuskItCountry_bookmarks.txt (Size: 6.01 KB / Downloads: 5)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply




Users browsing this thread:
2 Guest(s)


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