I’m trying to migrate my contacts from Microsoft Outlook (Classic) to KAddressBook (Kubuntu 24.04; current) and am having several issues that I’m hoping someone can help with.
From a practical perspective, there are two ways to get data out of Microsoft Outlook: a CSV export or a PST export. Of those, KAddressBook only supports CSV so that’s what I’m working with.
I’m having several issues, but the biggest one right now relates to phone numbers. Some contacts in the CSV file have home and work, phone and fax numbers.
If I map Home Fax to Home Fax, I get Home Fax assigned to TEL;TYPE=FAX,HOME. Great.
If I map Home Phone to Home Phone, I get Home Phone assigned to TEL;TYPE=HOME. Great.
If I map Home Fax to Home Fax AND Home Phone to Home Phone, I get Home Phone assigned to TEL;TYPE=FAX,HOME, and the Home Fax number is lost.
The same happens with Work Phone and Fax.
I have a similar, but slightly different issue with contacts that have multiple work and/or home numbers. If I map Business Phone and Business Phone 2 to Work Phone, only the Business Phone 2 number is imported; the Business Phone number is lost.
I have also tried using a converter to convert the CSV file to a vCard file. I’ve tried several converters and none have been particularly successful. The converter packaged with Evolution groupware creates a vCard file that successfully handles the issue above that I’m having with CSV files, but it creates other issues. The point here is that the vCard import resolves the fax/voice and multiple voice number issues that I’m having with CSV, so it seems like the issue is related to the CSV import mechanism of KAddressBook.
I’m not sure at this point if I’m doing something wrong, or if this is being caused by a bug in the CSV Import. Any suggestions you can offer would be appreciated.