[ale] SugarCRM Schema

[Dustin Puryear]

We used ACT! a long time ago and migrated to SugarCRM Pro. We paid someone to do the conversion for us. I wouldn't even want to know the PITA that Chris is experiencing.

 

ACT! is a great tool, but every version became slower to the point of being unusable, at least for us. We're very happy with SugarCRM Pro. It is much more functional, especially for automation and workflow, than the free Community Edition version (SugarCRM CE).

 

The only caveat is that using the SugarCRM web-based frontend can be a serious pain, but it's still better than ACT!.

 

---
Puryear IT, LLC - Baton Rouge, LA - http://www.puryear-it.com/
Active Directory Integration : Web & Enterprise Single Sign-On
Identity and Access Management : Linux/UNIX technologies

Download our free ebook "Best Practices for Linux and UNIX Servers"
http://www.puryear-it.com/pubs/linux-unix-best-practices/

 

From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Jim Kinney
Sent: Thursday, February 25, 2010 9:56 AM
To: Atlanta Linux Enthusiasts - Yes! We run Linux!
Subject: Re: [ale] SugarCRM Schema

 

ACT! is crap or is Sugar crap? I've setup an install of Sugar and thought it was pretty OK. 


ACT! is a closed app, one-way door to hell.

On Thu, Feb 25, 2010 at 9:01 AM, Chris Fowler <cfowler at outpostsentinel.com> wrote:

I'm working on converting ACT! 2007 to Sugar and the schema is driving
me crazy.

I'm starting to wonder if a rookie designed their database or if I'm the
rookie looking at it.

a).  Foreign keys have different names!

accounts.id = client.client_id

WTF!  Now I downloaded a java program to map ther database and no
relation ships could be found.  I then had the same program map a
database I designed and it found all the relationships.

b)  Primary keys are chars.

This one I'm not sure I understand.  In the user table there is a
primary key that is a char and can be NULL.  Again why is this?  In my
tables all my primary keys are integers and auto increment.  Now I
thought maybe they had an odd key so after I created the standard
database I looked at the admin user and his users.id is 1.  Looks like
an integer to me!

I did a test insert where I did not specify a key and it was set to
NULL.  Apparently when I import users from ACT! I'll need to keep a
counter and increment that counter by 1 and set that as the key.

I don't know, I'm just ranting, but their database looks like it started
out as and idea and it is now too late to standardize on anything.

_______________________________________________
Ale mailing list
Ale at ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo




-- 
-- 
James P. Kinney III
Actively in pursuit of Life, Liberty and Happiness         

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20100225/d338331a/attachment-0001.html