[Tellico-users] CSV Output file has issues

[Matthew Soffen (tellico)]

Afternoon All,

I'm currently trying to import an exported copy of my Book Collection (all
1800+ books) for use on my Cell Phone.

When I tried to import the exported CSV file it choked.

I noticed then that nothing is quoted.

For example, This is one title/etc. for the book:
Daughter of the Blood (Black Jewels, Book 1)

Guess what happens ?  The title gets split on the , in  the Series/# part.

Can we add " around all text fields in the DB ?

This would change the output line from :
Daughter of the Blood (Black Jewels, Book 1),,Bishop,
Anne,,Paperback,,,Roc
Trade,,,2007,0-451-46148-7,,384,,English,,,,,,,,,,,e472d59ead49407192d5b75df7bebb17.jpeg,Seven
hundred years ago, a Black Widow witch saw an ancient prophecy come to
life in her web of dreams and visions. Now the Dark Kingdom readies itself
for the arrival of its Queen, a Witch who will wield more power than even
the High Lord of Hell himself. But she is still young, still open to
influence-and corruption. <br/><br/> Whoever controls the Queen controls
the darkness. Three men-sworn enemies-know this. And they know the power
that hides behind the blue eyes of an innocent young girl. And so begins a
ruthless game of politics and intrigue, magic and betrayal, where the
weapons are hate and love-and the prize could be terrible beyond
imagining...,235,2012-01-03,2012-01-03,http://www.amazon.com/Daughter-Blood-Black-Jewels-Book/dp/0451461487%3FSubscriptionId%3D1SPKN5BEBSD5QFJMAB82%26tag%3Dtellico-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0451461487

to:

"Daughter of the Blood (Black Jewels, Book 1)",",Bishop, Anne"
,,"Paperback",,,"Roc
Trade",,,2007,"0-451-46148-7",,384,,"English",,,,,,,,,,,,"e472d59ead49407192d5b75df7bebb17.jpeg","Seven
hundred years ago, a Black Widow witch saw an ancient prophecy come to
life in her web of dreams and visions. Now the Dark Kingdom readies itself
for the arrival of its Queen, a Witch who will wield more power than even
the High Lord of Hell himself. But she is still young, still open to
influence-and corruption. <br/><br/> Whoever controls the Queen controls
the darkness. Three men-sworn enemies-know this. And they know the power
that hides behind the blue eyes of an innocent young girl. And so begins a
ruthless game of politics and intrigue, magic and betrayal, where the
weapons are hate and love-and the prize could be terrible beyond
imagining...",235,"2012-01-03","2012-01-03","http://www.amazon.com/Daughter-Blood-Black-Jewels-Book/dp/0451461487%3FSubscriptionId%3D1SPKN5BEBSD5QFJMAB82%26tag%3Dtellico-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0451461487"

I've been working with CSV style files for 15 years now and the general
rules of thumb are
1) Replace " in the text with ""
2) Quote All Text Fields
3) If you use the field as a number, don't quote it. If its used as text
(like an ISBN), then quote it.

What do you think ? (Or even quote around the # fields too, because that
generally doesn't cause issues).

Matt


-----------------------------------------
This email was sent using SquirrelMail.
   "Webmail for nuts!"
http://squirrelmail.org/