ACT! is crap or is Sugar crap? I've setup an install of Sugar and thought it was pretty OK. <br><br><br>ACT! is a closed app, one-way door to hell.<br><br><div class="gmail_quote">On Thu, Feb 25, 2010 at 9:01 AM, Chris Fowler <span dir="ltr"><<a href="mailto:cfowler@outpostsentinel.com">cfowler@outpostsentinel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I'm working on converting ACT! 2007 to Sugar and the schema is driving<br>
me crazy.<br>
<br>
I'm starting to wonder if a rookie designed their database or if I'm the<br>
rookie looking at it.<br>
<br>
a). Foreign keys have different names!<br>
<br>
<a href="http://accounts.id" target="_blank">accounts.id</a> = client.client_id<br>
<br>
WTF! Now I downloaded a java program to map ther database and no<br>
relation ships could be found. I then had the same program map a<br>
database I designed and it found all the relationships.<br>
<br>
b) Primary keys are chars.<br>
<br>
This one I'm not sure I understand. In the user table there is a<br>
primary key that is a char and can be NULL. Again why is this? In my<br>
tables all my primary keys are integers and auto increment. Now I<br>
thought maybe they had an odd key so after I created the standard<br>
database I looked at the admin user and his <a href="http://users.id" target="_blank">users.id</a> is 1. Looks like<br>
an integer to me!<br>
<br>
I did a test insert where I did not specify a key and it was set to<br>
NULL. Apparently when I import users from ACT! I'll need to keep a<br>
counter and increment that counter by 1 and set that as the key.<br>
<br>
I don't know, I'm just ranting, but their database looks like it started<br>
out as and idea and it is now too late to standardize on anything.<br>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>-- <br>James P. Kinney III<br>Actively in pursuit of Life, Liberty and Happiness <br><br>