Importing SugarCRM 10.0.6 data

kbrill · 21 April 2023 18:53

I have a SugarCRM 10.0.6 database and I was wondering how hard it would be to get that data in SuiteCRM. There are a few custom modules and custom fields of course. I dont care at all about the custom code or anything and I dont not intend to add or update data, I just need to see the data on a screen again and be related properly.

pgr · 21 April 2023 19:03

Hi, welcome to the Community?

Are you a developer? There are many ways to go about this, but I would recommend a PHP import script (as a “custom entry-point”), it will let you manipulate things via the objects (Beans) which is better, to tie up all the relationships and the security groups.

See an example here (this one loads from a CSV)

gist.github.com

https://gist.github.com/pgorod/3ce7868a290df0ef4f8c9de74f12a6cd

Import_script.php

<?php
//xdebug_break();
if (!defined('sugarEntry') || !sugarEntry) die ('Not a Valid Entry Point!');


$date= new DateTime();
//chdir('/opt/bitnami/apps/suitecrm/htdocs/');
echo 'School Importer started at ';
echo $date->format('r').'<br>';
echo '-------------------------------------------------------------------------------------------------------------------------------------<br>';

This file has been truncated. show original

kbrill · 21 April 2023 20:39

I am less worried about the actual import than I am about setting up the custom fields and relationships and the custom modules. I don’t know how far apart sweet CRM and SugarCRM have drifted in those regards.

pgr · 22 April 2023 09:35

I don’t think they diverged much in that regard. By inserting the data with the Beans functions, you are assured that it goes in with the correct structure.

But even if you try a database import, I think most of it should work well. Not a full import, but a careful import, checking each table and its relationships.

The basic mechanisms for custom fields and relationships are mostly the same.

EDIT: just to add - for custom modules, it might have diverged more, I don’t know. but even there, if you create the modules in SuiteCRM to get the structure right, then you should be able to import the data more or less directly.