[horde] Export of address book
Ralph Ballier
ballier at mail.schule.de
Fri Oct 14 13:09:45 UTC 2016
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.
More information about the horde
mailing list