OpenEMM Technical Support Forum

For the last 2 days I'm trying to get a basic 6.2. OpenEMM install to work on Ubuntu 10.04. WebApps work - but no emails are generated or send to test users or others. There are NO errors in any log files and the only strange thing I'm doing is that my DB and OpenEMM install are on different servers...

I've used OpenEMM on Ubuntu /mysql up to about 3 years ago (can't remember the version) and gave up because we couldn't get transactional emails to work. Can anyone let me know if this feature is available in current versions. So just to confirm what I want to do: - Create email template "Hi [N...

Thanks ma and I tried that but when I do that and look for press the statistics button the result is zero which may be valid because at the exact time I press "statistics" I guess no-one has a record with creation_date = current_timestamp So how does that logic work? When is this check made?

Hi, I'm still struggling in getting this to work using mysql. It must be me being very stuppid somewhere. The problem is that date based target groups don't appear to work. From looking at the database it appears to me that the content of the database field: dyn_target_tbl.target_sql is used to crea...

Hi Ma; Current_timestamp should do the trick. Are you suggesting I can put any "SQL" in the expression field? E.g.

date_add(now(),interval -1 hour)

Is valid (ish) mysql for an hour ago. Would that work?

Thanks

Leon

Ma; I still can't get my "sysdate -1" to work. It seems to loose it when I type it into the form... Do I have to do this directly into the database?

thanks again.

leon

"Only sysdate" OK - I can remember that list

I tried to create the target definition for creation_date = sysdate -1 but the form seems to ignore the -1 bit. Instead I get a column: YYYYMMDD etc. Is that OK or am I still messing things up?

Is there a document which lists things like the "sysdate" options?

Where do I start looking? Happy to have a got at it...

Hi Ma; again thanks. I don't use any forms or links (I think...) as we collect emails from our database and register them through the webservices. None of the users every see an OpenEMM webpage. Does that mean I can not use the first 2 options? Also is there an "systime -1 hour" option as ...

Hi Ma, Thanks for your reply and I think your question about "triggers" is the issue I am struggling with. The simple thing I want to do is: - I "bind" a recipient to a mailing list using the Webservices - An hour later - I want to send them a "welcome" email Having rea...

Hi, I seem to have encountered a problem using OpenEMM 5.5.1 which I have difficultly getting my head around. What I want to do is send users, then they are subscribed to a new mailing list by setting a binding (I use webservices to do this) and Welcome email. What I have configured to do this is: a...

If you use the above webservice but specify "A" as the sendGroup - no emails are delivered. This may sound like a strange scenario but we are using OpenEMM to deal with mailings which are generated dynamically and this feature would allow us to capture the first "x" email so we a...

The process of generating an email through a webservice would suggest the following steps: 1) Copy a template to a mailing 2) Create a Mailing List to for this mailing 3) Assign Recipients to the Mailing List 4) Insert Content 5) Send the mailing All of this can currently be done through the existin...

Hi, I also would like to confirm as per another post on this forum that this call doesn't work in 5.5.1. It throws a soap exeption: $params = array ( 'username' => (string) $this->loginCredential['login'], 'password' => (string) $this->loginCredential['password'], 'mailingID' => (int) $mailing_id, '...