MobileSheets Forums

Full Version: CSVFile for "Kingston Irish Tunebook"
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Kingston Irish Slow Session Tune Book
Revision 1.1
Sponsored by The Harp of Tara Branch of the Association of Irish Musicians, Comhaltas Ceoltóirí Éireann (CCE)

More than 500 traditional Irish tunes and a lot of background information about Irish music and session tradition

https://www.harpoftara.com/music.html
Thank you, this is brilliant! Note to everybody else that there is an earlier edition of the Kingston book floating around, you need to the the version linked to in the post and it will load perfectly.
Thanks for your nice words.
I checked the link again and found it should be https://www.harpoftara.com/music (not ...music.html as written above) 
Have fun & keep swinging
(01-30-2019, 06:21 AM)itsme Wrote: [ -> ]Kingston Irish Slow Session Tune Book
Revision 1.1
Sponsored by The Harp of Tara Branch of the Association of Irish Musicians, Comhaltas Ceoltóirí Éireann (CCE)

More than 500 traditional Irish tunes and a lot of background information about Irish music and session tradition

https://www.harpoftara.com/music.html

I am curious why there is a CSV file and an XLS file.  I now know that mobilesheets can import using a CSV file; is the XLS file for importing into some other software, perhaps?
The CSV is for MobileSheets. Good to know: if a column name is unknown (MobileSheets doesn't have a database field for it) MobileSheets just ignores the column. This allows to keep additional columns in a CSV file. I often do that with the starting PDF page of a song (in my files I call it PDFPage, Sciurius calls it startpage in his tools). The starting page is helpful to step through a fakebook page by page to colllect additional info. When done you can easily sort back to alfabetical, that's what I prefer to select single songs for import.

I maintain an additional database outside of MobileSheets that contains also books and songs that I don't import into MobileSheets. I collect data to create CSV, PDF bookmarks and an import file for my private database in an XLS or XLSX file per book. I usually keep this XLS file for later reference and share in the forum together with CSV and bookmarks file, just in case it might be useful for somebody else. E.g. "Kingston Irish Tunebook" is organised in chapters by style like Jig, Air ... and songs are numbered by chapter. I first collected these chapters and page numbers and then calculated "pages" from that, to save some effort. That might be different for other books.
(03-04-2026, 06:12 PM)itsme Wrote: [ -> ]The CSV is for MobileSheets. Good to know: if a column name is unknown (MobileSheets doesn't have a database field for it) MobileSheets just ignores the column. This allows to keep additional columns in a CSV file. I often do that with the starting PDF page of a song (in my files I call it PDFPage, Sciurius calls it startpage in his tools). The starting page is helpful to step through a fakebook page by page to colllect additional info. When done you can easily sort back to alfabetical, that's what I prefer to select single songs for import.

I maintain an additional database outside of MobileSheets that contains also books and songs that I don't import into MobileSheets. I collect data to create CSV, PDF bookmarks and an import file for my private database in an XLS or XLSX file per book. I usually keep this XLS file for later reference and share in the forum together with CSV and bookmarks file, just in case it might be useful for somebody else. E.g. "Kingston Irish Tunebook" is organised in chapters by style like Jig, Air ... and songs are numbered by chapter. I first collected these chapters and page numbers and then calculated "pages" from that, to save some effort. That might be different for other books.

Understood.  Thanks for explaining the extra column, and for sharing all that extra work in your XLS files!