Page 1 of 1

Bulk upload companies & contacts-Solved

Posted: 19 Jan 2017, 14:58
by vvon66
Hello - Is there any way to bulk upload companies and contacts from an excel sheet or CSV file? I read through all of the documentation I could find and didn't see it mentioned. Any help is appreciated. Thank you!

Re: Bulk upload companies & contacts

Posted: 19 Jan 2017, 15:14
by RussH
Yep absolutely - just go to Settings, Administration, Import.

Re: Bulk upload companies & contacts

Posted: 19 Jan 2017, 15:34
by vvon66
Great! I just found it. Another question...

I have a huge file of companies and contact names. Should I import the list as companies or contacts? If I import as companies, will it also import the contacts to that company? I only have one contact per company name on this list.

Thank you!

Re: Bulk upload companies & contacts

Posted: 19 Jan 2017, 16:03
by vvon66
I played around and realized it was best to add as contacts.

Opencats will automatically add the company name if there is no company already in the system. If you have a company in your import list without a contact name, it will add them as "nobody" but still add the company. Then when you get a contact name, you can update that profile.

I hope this helps someone in the future :)

Re: Bulk upload companies & contacts

Posted: 19 Jan 2017, 16:04
by cptr13
It'll help the documentation. ;) thank you!

Re: Bulk upload companies & contacts

Posted: 19 Jan 2017, 17:23
by vvon66
cptr13 wrote:It'll help the documentation. ;) thank you!
Anything else I find, I will be sure to add it!