• 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: 13)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 21H1
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: 23)
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 21H1
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-2022 MyBB Group.