[horde] Export of address book
Jan Schneider
jan at horde.org
Fri Oct 14 13:19:55 UTC 2016
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/
More information about the horde
mailing list