Odoo Help

Welcome!

This community 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.

0

Import data from SugarCRM

By
netagence
on 2/12/13, 6:58 AM 3,723 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.

BEN AMOR FARES
on 2/28/13, 8:39 AM
1

Daniel Reis

--Daniel Reis--
3436
| 6 7 9
Lisbon, 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.

Martin
on 3/14/13, 3:47 PM
0
tlauber
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.

0
BEN AMOR FARES
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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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