E-mail Marketing Campaign and SugarCRM V 4

**nmos** · 2005-12-21, 09:27 PM

OK. I searched everywhere and I did not find an answer. This may be a very stupid question but here it goes...

I am trying to create a new e-mail marketing campain. This is what I have done so far...

- Create the campain
- Create the target list
- Create the e-mail marketing template

When completing the e-mail marketing data there is one field for the mailbox (Use Mailbox). The dropdown is currently empty. I have not been able to find where this account needs to be setup. I have tried the following:

- Made sure that the user e-mail information is correct.
- Created incoming mail account and successfully tested it (It actually took me a while since you actually have to choose an action when creating the account. Otherwise it will not work).

I have gone through all the screens and I do not seem to find where else you can define this.

Any help will really be appreciated.

Thanks.

**sugarchris** · 2005-12-21, 10:01 PM

That dropdown gets populated when you create an inbound email mailbox and set the "Possilbe Actions" to bounce handling. This allows the reporting engine to get the bounces, click throughs, and other details, as well as the Return Name, Return Address for the campaign itself.

I know its not intuitive, but once it is all setup, man, does that bit of code shine! The developer who coded the updated Email Marketing module created some REALLY cool/informative screens.

**nmos** · 2005-12-22, 12:51 PM

Chris,

Thank you very much. Now I can see the mailbox and finish sending. I just have a different problem now. I click on the Send e-mail and the messages are created in the queue. Although my cron job is running properly (I know because I am receiving e-mail) and the task to run the mass -email campaigns is running every hour those e-mails won't go out. They are still in the queue.

This is the status of one of them in the queue:

Test NMos xxxxxxxx@xxxxxxx.com Test E-mail 2005-12-21 11:00 1 checked

(The e-mail address has been changed obviously).

I can send messages to anybody using compose e-mail and I have tested the e-mail settings and I get the INBOX message. My account is a POP3 one.

Thanks.

**nmos** · 2005-12-22, 01:42 PM

OK. Further to my previous note I just found in the log the following message:

[21016] Fatal SugarCRM - MySQL Error 1048: Column 'execute_time' cannot be null.

**nmos** · 2005-12-22, 07:46 PM

I ran from the command line emailmandelivery.php with vervose = true and this is what I got:

Could not open input file.

It seems to be a permissions issue since the e-mails are in queue. I have been trying to find the location where these e-mails are stored with no luck.

Help please....

**sugarchris** · 2005-12-22, 07:56 PM

Originally Posted by nmos

I ran from the command line emailmandelivery.php with vervose = true and this is what I got:

Could not open input file.

It seems to be a permissions issue since the e-mails are in queue. I have been trying to find the location where these e-mails are stored with no luck.

Help please....

We have moved the EmailmanDelivery code to schedulers - one point of entry means tighter security for your instance. That file is deprecated and only serves to support older installs that haven't gotten the Schedulers worked out.

Do you have a Scheduler job of type "runMassMailCampaign" set up to run?

If your instance is a fresh install, that job should be there by default, set to run once an hour, 2am - 6am every day.

If not, try adding it. Make sure its interval is a slow one (if you set it to run every minute, you'll probably hose your system!). I recommend 1 hour.

**nmos** · 2005-12-22, 08:27 PM

Chris,

I have such scheduler running (for the time being every 5 minutes to be able to test. Once everything works I will change it to an hour as recommended by you.). I am sure my cron job is running properly (I get incoming mail).

Why do I get that message when running the script from the command line with vervose True

Could not open input file

???

**Molnar** · 2005-12-28, 02:30 PM

hi nmos,

Could you resolve the problem? I have same problem like yours.

Laszlo

**nmos** · 2005-12-29, 03:04 PM

Well. Actually I did. To make sure everything was OK I recompiled PHP as recommened in the other forums, changed my General Settings account and it began working. I am sure my General Settings were working properly. My account was info@my-domain.com so I am noy sure of the word info is reserved or something (i does not make any sense) but as soon as I changed that it began working.

Hope this helps.