Migrating from SugarCRM CE to SuiteCRM

First of all - SuiteCRM is awesome!

On to my questions:

  1. Can I use Advanced Open Portal to link a custom front end site to link to SuiteCRM? I’d prefer to avoid Joomla, as it is troublesome to get the connector to work and so far Ive been unsuccessful. Ive been hand coding REST calls to a SugarCRM install but its a bit messy to say the least. Ideally I want the client to be able to create a business, and from that a client too as well as generate logins etc without logging into SuiteCRM

  2. How easy is it to migrate the database across. Theres a lot of records id like to keep and im curious to see how many referances to sugar have been changed or whether i can do a straight dump into the new database

  3. Back to Advanced Open Portal - I couldnt find the module in there when I looked. I did see advanced open reports when I went into the module Loader, but that was the only one and ive seen no rewferance to it. However i can see referances to it in the install. Am i missing something?

Again, SUPERB release. It is very very good and I want to transfer as soon as because SugarCRM CE is poo compared to SuiteCRM

Hi Nick,

1.) AOP has been developed to work with Joomla, at this present time. Currently, there would need to be a custom portal built to work with a custom front end site and SuiteCRM 7.0.0.
2.) There will be an upgrade path in the coming days which will allow you to upgrade from SugarCRM 6.5.x to SuiteCRM 7.0.0.
3.) Please try a quick repair and rebuild.

Thanks for the comments,

Will.

Thanks Will for the response

With regards to the Joomla portal - Is it limited to Cases, or can I get it to completly intergrate with SuiteCRM, for ex. creating a user on Joomla and SuiteCRM that share logon and roles?

Hi Nick,

No problem. As regards AOP, it only handles cases currently.

Thanks,

Will.

Hmm ok. Then what I shall do is write a complete non-Joomla portal system for it for non Joomla installations. Is this in the pipeline with you guys and if not, would it be worthy of contribution?

Hi Nick,

This is not currently in the pipeline and would be a worthy contribution. The code would need to be production ready, completely open source and published under the GPL3 license.

Thanks,

Will.

I better get working on it then :slight_smile:

Hi Nick,

There is now an upgrade path available which was released to allow you to upgrade to SuiteCRM from SugarCRM.

Please see this topic for more information.

Thanks,

Will.

Hi,

I attempted to migrate from SugarCRM CE 6.5.14 to 7.0.1 using the Upgrade wizard.

It seemed to have upgraded the files, but did not set the file permissions so I fixed that (set to 755). The second thing that it didn’t do was correctly upgrade the database. Is there a script or a set of scripts that I should run for my MySQL instance?

Thanks!

Hi suitemo,

There are no database differences as we are aware from 6.5.14 to 7.0.1. Were you expecting the database to be upgraded/change? If so, what changes were you expecting?

Thanks,

Will.

Hi Will,

The logs below suggest that some tables are missing.

Tue Nov 5 00:55:26 2013 [23559][1][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
FROM acl_actions
INNER JOIN acl_roles_users ON acl_roles_users.user_id = ‘1’ AND acl_roles_users.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )

			UNION

			(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
			FROM acl_actions 
			INNER JOIN securitygroups_users ON securitygroups_users.user_id = '1' AND  securitygroups_users.deleted = 0
			INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
			LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
			WHERE acl_actions.deleted=0  )

			UNION 

			(SELECT acl_actions.*, 0 as access_override, -1 as user_role
			FROM acl_actions
			WHERE acl_actions.deleted = 0 )

			ORDER BY user_role desc, category,name,access_override desc: MySQL error 1146: Table 'sgr_nkonagkhkm.securitygroups_users' doesn't exist

Tue Nov 5 00:55:26 2013 [23559][1][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
FROM acl_actions
INNER JOIN acl_roles_users ON acl_roles_users.user_id = ‘1’ AND acl_roles_users.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )

			UNION

			(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
			FROM acl_actions 
			INNER JOIN securitygroups_users ON securitygroups_users.user_id = '1' AND  securitygroups_users.deleted = 0
			INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
			LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
			WHERE acl_actions.deleted=0  )

			UNION 

			(SELECT acl_actions.*, 0 as access_override, -1 as user_role
			FROM acl_actions
			WHERE acl_actions.deleted = 0 )

			ORDER BY user_role desc, category,name,access_override desc: MySQL error 1146: Table 'sgr_nkonagkhkm.securitygroups_users' doesn't exist

Tue Nov 5 00:55:39 2013 [23696][1][FATAL] Query Failed: SELECT aos_products.id , aos_products.name , aos_products.part_number , aos_products.cost , aos_products.currency_id , aos_products.price , jt0.name aos_product_category_name , aos_products.aos_product_category_id , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,’’),’ ‘,IFNULL(jt1.last_name,’’)))) created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod, aos_products.date_entered , aos_products.assigned_user_id FROM aos_products LEFT JOIN aos_product_categories jt0 ON aos_products.aos_product_category_id = jt0.id AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_products.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where aos_products.deleted=0 ORDER BY aos_products.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘sgr_nkonagkhkm.aos_products’ doesn’t exist
Tue Nov 5 00:55:40 2013 [23696][1][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘sgr_nkonagkhkm.securitygroups_default’ doesn’t exist
Tue Nov 5 00:55:48 2013 [23814][1][FATAL] fp_event_locations_fp_events_1 for fp_event_locations_fp_events_1 failed to load

Tue Nov 5 00:55:48 2013 [23814][1][FATAL] Query Failed: SELECT fp_events.id , fp_events.name , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,’’),’ ‘,IFNULL(jt0.last_name,’’)))) created_by_name , jt0.created_by created_by_name_owner , ‘Users’ created_by_name_mod, fp_events.date_start , fp_events.date_end , fp_events.budget , fp_events.currency_id , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,’’),’ ‘,IFNULL(jt1.last_name,’’)))) assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, fp_events.assigned_user_id FROM fp_events LEFT JOIN users jt0 ON fp_events.created_by=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON fp_events.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where fp_events.deleted=0 ORDER BY fp_events.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘sgr_nkonagkhkm.fp_events’ doesn’t exist

Cheers,
Mauro

Hi Will,

Should I just install SuiteCRM from scratch?

This is an option. Don’t want you to waste your time here in case I really messed something up.

Thanks!

if you have tables missing, assuming nothing else is wrong, you should be able to do a quick repair and rebuild, this should detect any missing from the database and scrolling down to the bottom after the quick repair and rebuild complete and executing the changes needed for the database