Where is the relation between email addresses and the email address owner stored?

[rtedbyers]

I have been trying to follow through on information Abazander and André Lopes kindly provided. However, I have been struggling because I have only passing acquaintance with PHP, Up until now, I have never written production code in PHP. Rather, I have written only simple scripts to, e.g. download financial data from yahoo or send emails. However, there is always more than one way to do things.

Consequently, I have been looking at the sugar CRM schema and it seems to me to be relatively simple.

From what I see, I can write code for a daemon in perl, that lives on the server (the code I was examining produces javascript living on the client) and queries the database to determine what meetings or tasks need reminders to be emailed, and it is easy also to determine who the meeting participants are or who is to complete a given task. I found the table with email addresses. What I haveen't found is the table that tells me which email address belongs to which user/lead/contact. So where is that relation stored?

Thanks

Ted

[andopes]

The table is email_addr_bean_rel

Actually the query you may want to write is:

SELECT a.id, a.name, ea.email_address FROM accounts AS a
INNER JOIN email_addr_bean_rel AS eabr ON a.id = eabr.bean_id AND eabr.bean_module = 'Accounts' AND eabr.deleted = 0
INNER JOIN email_addresses AS ea ON eabr.email_address_id = ea.id AND ea.deleted = 0
WHERE a.deleted = 0

Regards

[rtedbyers]

Thanks Andrei,

The thing that threw me was the use of the string 'been',

In any event, with this information, I can write a perl script that forms a daemon that checks every few minutes for meetings or tasks that warrant sending email reminders. That daemon would live on the server, and thus ends up having no interaction with the Sugar client code. It would operate strictly off the database.

Thus, I can leave the existing reminder code unchanged (so the popup appears if the user in logged on) and they also get an email regardless of whether or not they're logged on. One way or another, they get a reminder that is almost certain to get their attention.

I don't know if it is blasphemy to use Perl with Sugar, but as long as it works ...

Thanks again

Ted

[andopes]

Thanks Andrei,

The thing that threw me was the use of the string 'been',

In any event, with this information, I can write a perl script that forms a daemon that checks every few minutes for meetings or tasks that warrant sending email reminders. That daemon would live on the server, and thus ends up having no interaction with the Sugar client code. It would operate strictly off the database.

Thus, I can leave the existing reminder code unchanged (so the popup appears if the user in logged on) and they also get an email regardless of whether or not they're logged on. One way or another, they get a reminder that is almost certain to get their attention.

I don't know if it is blasphemy to use Perl with Sugar, but as long as it works ...

Thanks again

Ted

Hi Ted

Not a big deal accessing sugar through Perl.
By the way I played Perl for a long time before starting working on SugarCRM. That is definitely a powerful language, specially regarding regular expression.

Kind regards