• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fakebook Indexes for CSV import
#31
Something that would be nice to agree upon: sub-separators. For example, a song can have multiple composers, keys, signatures, collections, etc..
There's an (informal) advice to use semicolon to separate the fields (because of commas in page ranges), how about an (informal) advice to use a vertical bar to separate subfields? Bonus points for a space-surrounded bar Smile.

Code:
title;pages;keys;composers;year;signatures;collections;source types;genres
Sunday;9;Bb;Chester Conn|Benny Kreuger|Jule Styne;1926;4/4;The Firehouse Jazz Band Fake Book;Sheet Music;Jazz
Bill Bailey, Won't You Please;10-11;F;Hughie Cannon;1902;4/4;The Firehouse Jazz Band Fake Book;Sheet Music;Jazz
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.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
#32
Filename:
We are not the first with the idea of including the filename:
http://www.skrivarna.com/2014/02/automat...books.html
both absolute and relative paths should be possible
and the secondline should contain the column headers
Sub-separators:
separating sub-fields is a great idea, I also vote for a "space surrounded bar" : " | "
PageOrder:
it should be possible to put the content of the PageOrder column directly into MSP
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1709
http://www.moonlightcrisis.de - http://www.basdjo.de - http://www.frankenbaend.de


Reply
#33
I'm considering it just from the perspective of the "datatypist" now.

Currently I'm still ambitious and want to add as much metadata I can retrieve from the displayed song or elsewhere (so composers, tempos, year and so on). I'm sure that will dwindle, but for now I'm hacking it in (10 finger typing).

For such bulk editing I really dislike the "|" for a sub separator. It's just not that accessible for typing and I much prefer the ";" as I wrote about it in another post already referencing Calibre and Mediamonkey for the same handling.

Maybe the parser can be flexible for the subseparators too? Define it in the CSV somehow if it's a "|", a ";" or whatever else? (of course it can't be the same as the field separator).
Reply
#34
You quickly run out of available symbols. If you use semicolon for subfield separator, what would you use for field separator? Note that using a comma may imply you have to quote certain page ranges.
Although I must admit that far most page ranges will not have commas...
And of course there are ways to trick the definition of a subfield char in the file.
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.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
#35
(01-07-2016, 06:40 AM)sciurius Wrote: 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.

Mike, any progress on this one?
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.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
#36
(02-08-2016, 01:14 AM)sciurius Wrote:
(01-07-2016, 06:40 AM)sciurius Wrote: 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.

Mike, any progress on this one?

Ping.
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.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
#37
Is this not fixed? I could have sworn I addressed this bug. If I didn't, I'll make sure it gets fixed ASAP.
Reply
#38
There's a recent post that looks like reporting the same issue:
http://zubersoft.com/mobilesheets/forum/...p?tid=3317
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1709
http://www.moonlightcrisis.de - http://www.basdjo.de - http://www.frankenbaend.de


Reply
#39
The problem definitely exists in 1.4.0.
Johan
http://www.johanvromans.nlhttp://www.howsagoin.nlhttp://www.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
#40
This will finally be fixed in v1.4.3 - sorry I didn't address it sooner.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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