Import Google Contacts: "Wrong CSV file, required columns are not found: Mobile"

[Peter Richardson]

Hi all,

I'm trying to import contacts in 3CX from Google but when uploading the CSV file that I downloaded from Google Contacts, I get the error:

Wrong CSV file, required columns are not found: Mobile

I tried downloading as "Google CSV" and also tried "Outlook CSV" but I get the same error both times. Is there anything I can do?

 

[SSJ]

Hi,

Have you seen https://www.3cx.com/community/threads/import-csv-contact-files.50838/ ?
Could be the same comma vs semicolon issue.

If so, open the CSV in Notepad, and replace all semicolons with commas.

 

[Peter Richardson]

No, there are no semi-colons in the Google Contacts CSV file.

 

[YiannisH_3CX]

Hello @Peter Richardson

Please manually create a contact in 3CX and export it so you have the correct columns and format. Then adjust your file to match the PBX format otherwise import will not work.

 

[Peter Richardson]

Thanks @YiannisH_3CX

I followed your instructions and it worked. However, I have another client with a huge contacts list, and to edit it would take hours (the middle names need to be moved to the surname, lots of the fields need to be renamed, it's quite a process, especially for something that is only static and would have to be done on a regular basis because the contacts are not synchronised with the Google Contacts automatically. Is there an easier way? Is it possible to sync Google Contacts with 3CX? It seems strange that there's no integration. People would not want to have to maintain 2 sets of contacts lists, so what else can we do?

 

[leejor]

Could you not import it into an Excel file, add any necessity columns and re-arrange/edit as needed, then export as a CSV file?