[horde] Export of address book

[Jan Schneider]

Zitat von Ralph Ballier <ballier at mail.schule.de>:

> Zitat von Jan Schneider <jan at horde.org>:
>
>> Zitat von Ralph Ballier <ballier at mail.schule.de>:
>>
>>> Hello,
>>>
>>> I tried to export an address book. Unfortunately, a RETURN is in  
>>> the middle of a record. Therefore, there are problems to import  
>>> this CSV file into Excel.
>>>  
>>> Below I added two records. From this four lines have become. I  
>>> clearly marked the wrong RETURNs.
>>>
>>> What can I do?
>>
>> Nothing, it's a valid CSV file, and if Excel cannot import it, it's  
>> badly broken. Try a different application.
>>
>>> "firstname","lastname","middlenames","namePrefix","nameSuffix","name","alias","yomifirstname","yomilastname","birthday","anniversary","spouse","phototype","homeStreet","homePOBox","homeCity","homeProvince","homePostalCode","homeCountry","homeAddress","workStreet","workPOBox","workCity","workProvince","workPostalCode","workCountry","workAddress","otherStreet","otherPOBox","otherCity","otherProvince","otherPostalCode","otherCountry","otherAddress","department","manager","assistant","timezone","email","homePhone","homePhone2","homeFax","workPhone","workPhone2","cellPhone","carPhone","radioPhone","companyPhone","assistPhone","fax","pager","title","role","company","logotype","notes","website","freebusyUrl","pgpPublicKey","smimePublicKey","imaddress","imaddress2","imaddress3"
>>> ,"Name1",,"Frau",,"Miss  
>>> Name1",,,,,,,,,,,,,,,"Walter-Friedrich-Str. 16-18",,"13125  
>>> Berlin",,,"DE","Walter-Friedrich-Str. 16-18[RETURN]
>>> 13125  
>>> Berlin",,,,,"13125",,"13125","03K10",,,,"Name1 at hufeland-schule.berlin",,,,,,,,,,,,,,,"Hufeland-Schule",,,,,,,,,
>>> "Firstname2","Name2",,,,"Firstname2  
>>> Name2",,,,,,,,,,,,,,,"Erich-Weinert-Str.  
>>> 70",,"Berlin",,"10439","DE","Erich-Weinert-Str. 70[RETURN]
>>> Berlin,  
>>> 10439",,,,,,,,,,,,"Firstname2.Name2 at wvk-gemeinschaftsschule.de",,,,,,,,,,,,,,,"Wilhelm-von-Humboldt-Schule",,,,,,,,,
>>>
>>>  
>
> It is not due to Excel. If I open the CSV file with Wordpad or with  
> MS Word, then I see the additional line break.

The linebreak is fine. Not being able to import this linebreak  
correctly is not.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/