• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CSVFile för "Real Vocal Book"
#1
Hello,
I have have scanned copy of "The Real Vocal Book", and would like to have the songs imported to MSP. 

 I found one csv file on GitHub, which starts:

Quote:A Child is Born,13,
A Fine Romance,15,
A Foggy Day,17,
A Night in Tunisia,19,
Afro Blue,21,
Ain't Misbehavin,25,
Alice in Wonderland,27,


When I use it, only the first page of each tune is used. (Which is a expected behavior)
As a lazy man, I would like to think there is a ready csv-file somewhere, with the correct pages.

Thanks!
Reply
#2
I had to remove the image in your post because there is some kind of problem with embedding images in forum posts (it just shows up as an encoded string). If you can add the image as an attachment with your post, that would be best. Sorry for the inconvenience.

Mike
Reply
#3
The CSV file should look like

title,pages,
A Child is Born,13-14,
A Fine Romance,15-16,
...

My favorite to edit CSV files is LibreOffice Calc. I attached an example with formulas that might help.
Please share your results as soon as you have completed the CSV file


Attached Files
.xls   XLSExample_forDB.xls (Size: 12 KB / Downloads: 23)
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
#4
(06-12-2020, 08:39 AM)itsme Wrote: The CSV file should look like

title,pages,
A Child is Born,13-14,
A Fine Romance,15-16,
...

My favorite to edit CSV files is LibreOffice Calc. I attached an example with formulas that might help.
Please share your results as soon as you have completed the CSV file

Yes, I know, I was hoping someone already had done that  Tongue

Jonas
Reply
#5
(06-12-2020, 02:06 AM)Zubersoft Wrote: I had to remove the image in your post because there is some kind of problem with embedding images in forum posts (it just shows up as an encoded string). If you can add the image as an attachment with your post, that would be best. Sorry for the inconvenience.

Mike
No problem, it was just the first page of the book.

Thanks!
Reply
#6
(06-12-2020, 04:04 PM)johu60 Wrote:
(06-12-2020, 08:39 AM)itsme Wrote: The CSV file should look like

title,pages,
A Child is Born,13-14,
A Fine Romance,15-16,
...

My favorite to edit CSV files is LibreOffice Calc. I attached an example with formulas that might help.
Please share your results as soon as you have completed the CSV file

Yes, I know, I was hoping someone already had done that  Tongue

Jonas

Hi,
Why didn't thought of formulas in Excel?? Thanks for telling me Smile

I have created a csv file for the Real Vocal Book.
The info is:
Title;Pages;Genres;Albums;
A Child is Born;12-13;Jazz;Real Vocal Book;
A Fine Romance;14-15;Jazz;Real Vocal Book;
A Foggy Day;16-17;Jazz;Real Vocal Book;
.
.
.


Attached Files
.csv   realcsv.csv (Size: 10.23 KB / Downloads: 48)
Reply
#7
Thanks for sharing. And thanks for adapting the thread title to "CSVFile ..." for easy finding with the forum's search function.
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
#8
Hey Johu, your csv file page numbers are off by one.  A child is born should start with p13, not p12.  am a noob at using csv files, and when i imported my vocal book pdf with your CSV file it was difficult to delete and cleanup my MS library.  Simply removing the "Real Vocal Book" album from my library didn't remove all the songs created by the csv and the source PDF file.

Does anyone have the correct csv starting with page 13?  Or should I somehow remove page 1 from my source pdf file?
Reply
#9
CSV files have to match the PDF. Scans might be different. Alas we cannot share the matching PDF together with a CSV due to copyright rules.

To remove the wrongly imported songs filter by filename: 
on the "Songs" tab open the dropdown next to "Search:" and select "File Paths"
type a relevant part of the filename into the search field until all songs from your "Real Vocal Book" file (and only those) are shown
rightclick one of them, click "Select All" (the empty checkbox in the small multi-selection box that shows up bottom right)
click "Delete Song"
check "Delete Song Pdf/Image/Text Files" to remove not only the songs from your library but also the file

To adapt the downloaded CSV file to your PDF:
open the CSV in LibreOffice Calc (my favourite, there are other programs out there you could use)
use a formula to apply +1 or -1 to the page numbers
use CSV import again

or use https://www.zubersoft.com/mobilesheets/f...-8374.html
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:
1 Guest(s)


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