[horde] Re: [turba] Re: Problems with importing CSV and TSV

[Alan W. Rateliff, II]

> -----Original Message-----
> From: turba-bounces at lists.horde.org 
> [mailto:turba-bounces at lists.horde.org] On Behalf Of Jan Schneider
> Sent: Friday, March 25, 2005 6:32 AM
> To: turba at lists.horde.org
> Subject: [turba] Re: Problems with importing CSV and TSV
 
> Try using Horde and Turba from CVS HEAD, where CSV imports have been 
> improved a lot.

Will give that a shot today.

> > This is more of an Outlook problem.  When exporting the 
> contact's full name,
> > Outlook quotes it.  These quotes are accepted as literals 
> by Turba and made
> > part of the field.  Example,
> > "Rateliff II, Alan" \t alan2 at rateliff.net \t .......
> > The name field includes the quotes, and the 
> first-name/last-name separation
> > of Turba breaks.
> 
> Yeah, this is rather an Outlook problem. It doesn't make much 
> sense to 
> quote fields in TSV data. The problem is that neither CSV nor TSV are 
> defined anywhere as a standard, so there is a lot of room for 
> interpretation. Not very helpful for data exchange compatibility.

Outlook is a PITA in regards to exporting.  For instance, exporting the
"E-Mail" fields gives you a string of something like "email at domain.com SMTP
email at domain.com" and some other junk.  You have to expand E-Mail, then
select E-Mail Address.  Very frustrating, especially when trying to convey
this to some of our customers.  But most of them use Outlook, and this is a
wanted feature, sooo... In the end we will wind up making a page of screen
shots covering the process.

Thanks.

-- 
       Alan W. Rateliff, II        :       RATELIFF.NET
 Independent Technology Consultant :    alan2 at rateliff.net
      (Office) 850/350-0260        :  (Mobile) 850/559-0100
-------------------------------------------------------------
[System Administration][IT Consulting][Computer Sales/Repair]