[ale] Zimbra - OT SugarCRM

[Lightner, Jeff]

Sorry - as noted the only involvement I've had so far was the DNS record.   Whether they allow SQL queries from here to there or are using them if they do I couldn't say.

Here there are certain things they think we don't need to know until they break at which point it suddenly becomes a  "Linux issue" and becomes our problem.   Our first VMWare server was like that.   It had only MS Windows guests so we weren't involved on the install or virtual setups until a simple reboot didn't fix whatever issue they were having 2 years after install at which point the MS team said it was "Linux" server that we needed to address.   The irony of having to ask MS Admins for root password on a Linux system seemed lost on them.   We've also run into it for other systems/appliances with embedded Linux run by Telecom and Network groups but usually those at least were more along the lines of assisting them than suddenly taking ownership.



-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Chris Fowler
Sent: Wednesday, August 13, 2014 3:36 PM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Zimbra - OT SugarCRM

On 08/11/2014 08:36 AM, Lightner, Jeff wrote:
> Back in January we apparently began using a company for SugarCRM instead of ACT!:
>
> www.atcoresystems - number on their site is 770-466-0722
>
> they gave us a hosted Ubuntu system and we had to point our CRM domain to that.  I do NOT have to administer either the Ubuntu or the Sugar CRM even though my team does all the UNIX/Linux here.
>

Do you have SQL access?  I have some programs written in Perl that allows me to generate reports, assign accounts, etc.

I assign accounts via Perl.  I provide it the user and the account. It will comb the database looking for calls, meetings, notes, etc. Anything that has to do with the account and then assign it to the user.  It then sends out an email to the user telling them they have been assigned that account.

When the sales guys send me leads from shows in XLS format I run a program I wrote that uses SQL access to create leads, emails, etc from that list.

Most of my interactions with Sugar is outside of the web interface.


_______________________________________________
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

Athena(r), Created for the Cause(tm)
Making a Difference in the Fight Against Breast Cancer

__________________________________________________________
CONFIDENTIALITY NOTICE: This e-mail may contain privileged

or confidential information and is for the sole use of the intended

recipient(s). If you are not the intended recipient, any disclosure,

copying, distribution, or use of the contents of this information

is prohibited and may be unlawful. If you have received this electronic

transmission in error, please reply immediately to the sender that

you have received the message in error, and delete it. Thank you