[Tellico-users] Tellico 2.3 upcoming
robby at periapsis.org
Sat Jul 31 23:36:22 UTC 2010
On Friday 30 July 2010, Matthew Soffen wrote:
> I assume you mean the SYLK
file error ? This is documented by Microsoft -
Noted, I'll add a workaround for
> However, A few "issues" with the CSV file that I'm seeing.
1) I believe that the header line should be in "s (i.e. "ID" vs ID)
The LCCN should be in "s too (since it is NOT a number - it IS being
To fix the "SYLK" stuff, Could you change it to "Id" (the file then
opens immediately) ?
> 4) All the text fields SHOULD be quoted.
This is from my books database.
> The 1st book the title seems OK (but the
rest are not quoted). The 2nd
> book does not (and none of the other
books in my CSV are quoted either).
> From my experience with CSV
files, its always best to put quotes around
> ANYTHING that isn't numeric.
Then you'll always be right.
Perhaps..I did attempt to follow RFC
http://tools.ietf.org/html/rfc4180 and double-quotes are optional. I
did notice Tellico is not adding double-quotes when the field value has a
newline, that's certainly a bug. Tellico adds a quote if the value has a
comma or quote in it and if there are double-quotes in the field, they get
repeated. Does it cause problems if the non-numeric fields do not have
More information about the tellico-users