topic Re: How to Import Contacts in Webex Meetings and Webex App

How to Import Contacts

KCav45 — Thu, 04 Jun 2020 22:23:00 GMT

I would like to import contacts into Webex Meetings from Google Contacts. Can someone help me with this?

On my Personal Room Home page there is a box with my name on it. The box is located on the top right side of the Home page. When I position the cursor on the box a menu pops-up and the second item is My contacts. When I clicked on My contacts the My Webex Contacts worksheet appeared. On the work sheet there is a line on which it says Import From [Comma or Tab Delimited Files] and a box [Import] I clicked on the box. I page appeared that said, To upload a comma or tab delimited file, select the file to upload, select the type of delimiter your file uses, and select Import.

I went to Google Contacts and selected several contacts, then pressed Export to CSV file. This action created a Microsoft Excel worksheet with one client per line. I went back to the My Webex Contacts and entered the file name and selected the Comma delimiter type, then I pressed Import.

Instaed of importing Contact in My Webev Contacts list it said "Incorrect fie format!" Can someone explain why this happened?

Re: How to Import Contacts

Mike_Brezicky — Fri, 05 Jun 2020 14:08:14 GMT

Webex tty picky on the file format. What I suggest is you Export (create a single contact manually) your current list, and then take the google contacts and add them to this webex exported sheet. This should allow the contact to import without issue.

Re: How to Import Contacts

KCav45 — Mon, 08 Jun 2020 16:36:58 GMT

Hi Mike,

Thank you for replying to my post. I hope you will be patient with me because I would like to become a proficient user of Webex.

The first thing I did was update one contact in My Webex Contacts so I would have one with complete information. Next I tried to export the contact. When I select one contact and exported I got the whole Contact list instead of one contact, but the file did include telephone number and street address I had added.

I am about to export contacts from Google Contacts into the contact list I exported from My Webex Contacts. If I am unable to specify which contacts to export the list will have over 600 contacts instead of 70.

Re: How to Import Contacts

KCav45 — Mon, 08 Jun 2020 19:32:49 GMT

From Webex

on My Webex Contacts work page
on the line View [Personal Contacts] I clicked in the box for Export
a file named Contacts.csv was created in Microsoft Excel
the file had 14 lines one contact per line

From Google Contacts

selected a subgroup named FBCW
scrolled down to the Export command, selected As Google CSV and clicked
a file named Contacts.csv iwas created in Microsoft Excel
the file had 20 lines one contact per line

How do I take the google contacts and add them to this webex exported sheet?

Re: How to Import Contacts

KCav45 — Mon, 08 Jun 2020 19:46:24 GMT

Is there a way to merge the two files in Webex? Or do I have to use commands in Microsoft Excel?

Re: How to Import Contacts

KCav45 — Tue, 09 Jun 2020 19:15:00 GMT

I posted a question on the Excel forum asking how to merge two Excel spreadsheets. This is what they said:

Delete all unnecessary columns from one spreadsheet then make sure ony the same columns exit on the other.
sort so the lines are in the same order on both spreadsheet
Copy and paste individuals from one spreadsheet to the other until they match

Re: How to Import Contacts

rcoulson89 — Mon, 12 Oct 2020 10:06:19 GMT

MAKE SURE.....in Excel you select file format "Comma Seperated Value" .csv. .....Simular options DONT work. CSV UTF-8 / UTF-16 fails with message Incorrect file format. This solved it for me.