;)
;)
;)
My company has decided to dump Sugar in favour of Centric.
Has anyone migrated data from Sugar (MySQL) to Centric (PGSQL)?
I would like to start a project to develop an XSLT library for doing this from Sugar version 4.5.0x.
--
Greg
Discuss Data Import and Export
Import/convert data to Centric from Sugar
You need to be logged in to post messages
Import/convert data to Centric from Sugar
3/5/2007 2:06 PM EST
By Greg Kelemen
1.
3/5/2007
4:04 PM
EST
Hello Greg,
Great topic.
I've got a few thoughts about this and can provide some pointers for leveraging some existing Centric CRM capabilities.
When installing Centric CRM 4.1, the installation process asks if you have a database backup to restore from (on the database configuration page).
1. The database backup file is a simple XML file that contains the objects to be imported.
2. From this XML file, the database can be restored to any supported database: MySQL, PostgreSQL, etc. It doesn't matter what the source database or system was.
3. The XML file has indicators for maintaining referential integrity -- so every association is maintained during the import.
4. The backup file can also be run in the source code version from the command-line.
The current limitation is that the existing restore capability expects all Centric CRM application configuration data as well (lookup lists, constants, permissions, etc.) in addition to the record data. It would be nice to have a generalized importer with knowledge about various exported data. If the backup file doesn't have all of the configuration data, then the restore process can use the defaults that Centric CRM uses.
This is just one of the methods for importing data into Centric CRM. There is also an HTTP-XML API which allows for external apps to send data to Centric CRM.
Do you want more information on the current XML restore file?
2.
3/6/2007
7:45 AM
EST
By Greg Kelemen
Matt, thanks for the explanation. We're still operating with Sugar. It is important to come up with a reliable way to migrate all data (currently our MySQL db is over 100MB).
It might even be something that people could use as a general import tool for any kind of data like emails, trouble tickets, documents, etc.
Send me the XML restore file info. How do we make this into a community project?
3.
3/7/2007
4:18 PM
EST
Greg, a new project has been created for which you can proceed with. Let's move this discussion there and see how things go...
Import data from other CRMs Project:
http://www.centriccrm.com/ProjectManagement.do?command=ProjectCenter&pid=121
To learn more about starting your own project, or for information about managing a project, review Community Sponsored Projects:
http://www.centriccrm.com/ProjectManagement.do?command=ProjectCenter&pid=122
3 results found