Personal Contacts Import - Field Population Issue

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Acknowledged
I imported my contacts from a CSV file from a file that originated from our company's QuickBooks file which was exported to Excel. I changed all of the field names to agree with the contact fields in RingCentral. I then imported successfully (or so it appeared) with no error messages. However, the "Business Address, Business Address2 and Email" fields did not populated under my personal contacts. Any suggestions as to why or what I am doing incorrectly? Thanks!
Photo of Richie

Richie

  • 184 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Mike

Mike, Official Rep

  • 94,378 Points 50k badge 2x thumb
It's a little hard to say, but here's what I would suggest trying.  Instead of editing the column headings in the Quickbooks file,  export the customer list from RingCentral, then copy/paste the data in the colums from the QuickBooks file into the RC exported file. Then import that updated file.  This will assure there are no errors in the column headings and everything maps over correctly.

Let us know if you still have problems.

Mike
Photo of Richie

Richie

  • 184 Points 100 badge 2x thumb
Yessssssssss...crazy customer support couldn't articulate this to me.  Fantastic answer.
Photo of Richie

Richie

  • 184 Points 100 badge 2x thumb
Oh, one more item...can I delete all of my contacts in one fell swoop prior to importing my correctly mapped RC exported file.
Photo of Mike

Mike, Official Rep

  • 94,198 Points 50k badge 2x thumb
Yes... If you go to Personal > Edit Contacts, and then scroll down you'll see a Delete All Contacts button.
Photo of Richie

Richie

  • 184 Points 100 badge 2x thumb
You're the best!
Photo of Gene Holbert

Gene Holbert

  • 60 Points
how do I transfer file to rc file phone number wont pop up

Photo of Jessica - Community Moderator

Jessica - Community Moderator, Official Rep

  • 9,720 Points 5k badge 2x thumb
Hey Gene, 

Can you clarify what you mean?