Tables required to add Users and User Groups

[ryano]

I have seen several posts about this topic, so please forgive me if some of this is redundant, but I do believe what I am asking for is fairly simple/straightforward. I have contacted Kayako support, and they directed me to post here.

I would like assistance with importing users and usergroups. I have a SugarCRM system that contains all of my client accounts and contacts, and I would like to populate Kayako with that information. I have already setup the custom fields for Kayako 'Users' and for Kayako 'User Groups' so I have a place to PUT the information I am pulling from Sugar.

What I need now is to understand which tables in Kayako, besides swusers and swusergroups, would be involved in creating a legitimate user via a SQL script. I am confident that I could then write the script to add users and usergroups based on this understanding. Unfortunately, there are no triggers stored in the database, so it makes it more difficult to identify the table relationships.

Is there an ERD available anywhere? Or, as a last ditch effort for help, can anyone suggest a tool for MySQL that would be able to do a before and after analysis of a MySQL database to see what tables are affected when a new user/user group is added? Then maybe I could reverse engineer the process by understanding the tables which were affected.

Please, any help would be greatly appreciated. And i promise to post anything I come up with (that works, of course) here for public use.

[supportskins]

An ERD is available in the "help" directory of the software package which you downloaded from Kayako's Members Area although that ERD may not be upto date.

[Bleckfield]

How did you get on with this?

Were looking to utilise kayako, but the way it stores contact information wouldnt work for the way we operate, therefore would need it to out link to something like sugarcrm automatically (so we create the contact in sugar, it populates into kayako, then there is a button on the support ticket page that when pressed it opens up the sugarcrm contact page for the person that created the ticket.) doable?

[ryano]

I've actually just hired a developer to look at the integration of Support Suite and SugarCRM - specifically synchronizing (at least one-way) data from Sugar to Support Suite.

If anything comes of it, I'll be glad to share with the community!