How to import Lotus Notes Address book into the Sugar Address book

[nabors@lrnelson.com]

Operating system type and version: Ubuntu Linux 7.04
Sugar Suite version: Sugar Professional 5.0.0.e Build 3276
Webserver type and version: Apache 2.2.3
PHP version: 5.2.1
MySQL server version: 5.0.38

I'm currently doing an evaluation of Sugar Professional and I can not figure out how to import into the SugarCRM Address Book all my addresses from my Lotus Notes Address book. I have exported all my addresses from Lotus Notes as a .csv file but haven't found how to import.
Any information would be greatly appreciated.

[kuske]

In the Contacts/Leads/accounts module there should be an import shortcut.
If not, the admin must give you the right to import.

[nabors@lrnelson.com]

Kuske-

Thank you for the reply, but I'm not trying to add them to the Contacts. I would like to put them in the SugarCRM Address Book under the Emails tab. Can I not do this or is there a work around by putting them in the Contacts tab?

[JVWay]

The address book draws from users and contacts. I don't know what happens to the address book entry if a contact is deleted.

[kuske]

Kuske-

Thank you for the reply, but I'm not trying to add them to the Contacts. I would like to put them in the SugarCRM Address Book under the Emails tab. Can I not do this or is there a work around by putting them in the Contacts tab?

Puah, hard job, give me some time to think, perhaps 1 day? :-)

[nabors@lrnelson.com]

Is there a way to have the contact only viewable to the person that added the contact, or is this viewable by everyone on the system?

[kuske]

You can set a profile for all users that they can only see their own contacts.

... even in the CE edition ...

[nabors@lrnelson.com]

I will work on this today and see how far I can get. I guess I was just confused by the Address Book under the Emails tabs and assumed it should show all in that instead of under contacts.
I appreciate the feedback.

[JohnCarini]

There is a 3rd part product called the Lotus Notes Connector that does integration between Lotus Notes and SugarCRM. You can find it here - http://www.ienterprises.com/lotus-no...rm-integration

In the interest of full disclosure - I work for the company that developed the integration - iEnterprises, Inc.

[rtroth]

I have done this.

What I did was I used Crystal Reports to create a report of the database in question and exported it to a Tab Delimited file. I opened the tabbed file in Excel and trimmed the unnecessary fields, and then ran through the import module in the Contacts module.

Worked fine and I did it on 15000 contacts.