[Tellico-users] Tellico 2.3 upcoming

[Robby Stephenson]

On Friday 30 July 2010, Matthew Soffen wrote:
> I assume you mean the SYLK
file error ? This is documented by Microsoft -
>
http://support.microsoft.com/kb/323626/

Noted, I'll add a workaround for
that.

> 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)
> 2)
The LCCN should be in "s too (since it is NOT a number - it IS being
> 3)
To fix the "SYLK" stuff, Could you change it to  "Id" (the file then
>
opens immediately) ?

Yes

> 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
4180
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
quotes?

Robby