[Tellico-users] Tellico 2.3 upcoming
Matthew Soffen
sirgeek at mrsucko.org
Tue Aug 3 12:50:27 UTC 2010
> 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?
Not sure. I'll have to look at that.
Matt
-----------------------------------------
This email was sent using SquirrelMail.
"Webmail for nuts!"
http://squirrelmail.org/
More information about the tellico-users
mailing list