Odoo Help


Import data from SugarCRM

on 2/12/13, 6:58 AM 4,927 views

Hi As we currently use SugarCRM (and have custom-developped modules that import data from other sources), we'll need to import clients data if we are to switch to OpenERP for CRM usage, both when we start, and periodically for updating fresh data from our external provider. First of all is it possible to do so without SugarCRM at all after initial import, ie direct import to OpenERP's crm module from our external MySQL source, and how ? Else how can that SugarCRM -> OpenERP import work ? Can the online version support a serious volume of many thousands of clients and prospects ? Best regards.

Hello: you can import from csv files.

Dhafer Ben Amor
on 2/28/13, 8:39 AM

Daniel Reis

--Daniel Reis--
| 7 8 9
Linda-a-Velha, Portugal
--Daniel Reis--

Author of the "Odoo Development Essentials" book.

Applications Manager at Securitas Portugal

Github: https://github.com/dreispt

Twitter; @reis_pt

Daniel Reis
On 2/28/13, 9:14 AM

This king of data migration might be best achieved using Kettle / Pentaho Data Integration. You'll need to learn about ETL, but I assure you it's really worth it.

Additionaly, there is a SugarCRM plugin avalibale that "allows you to access all data available in SugarCRM modules." (Though couldn't find a download link, sorry.)

Caution. There are problems with the Kettle module for OpenERP V7.

on 3/14/13, 3:47 PM
Dhafer Ben Amor
On 2/28/13, 8:42 AM

Hello: you can import from csv files. The official repository module don't content SugarCRM Import. But he is in the extra addons.

So you can't install him in the online version proposed by openerp.

On 3/4/13, 8:23 AM

You could build a simple data migration job with Talend Open Studio. That's relatively simple and you are in control of the whole process. Done this with vTiger contacts and organisations.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 2/12/13, 6:58 AM
Seen: 4927 times
Last updated: 3/16/15, 8:10 AM