OpenEMM Support

Thanks Ma,

As I have posted in the bugtracker, I tried the updated .class file but no luck so far - but thanks for the quick response to this, I'm sure the problem will be fixed shortly.

Hi,

We seemed to be on top of things with 5.4 and had managed to send out a couple of mailings, but having 'upgraded' to 5.5.0, target groups and mailings based on date ranges seem to be broken again - for example, I have a database of around 80000 animals with date ranges from 1999 to the current ...

Bump?

Thanks for the clarification.

ma wrote:Sorry, you can use data base fields in the subject line but not for email address fields (yet).

Thanks - I wondered!

I managed to get 1967 emails out last night - our first real mailing!!

Ma,

I seem to be able to customise any header field EXCEPT the Sender Email - if I try and use a database field in it, I get the following error in maillog:

Apr 28 21:26:26 scalix sendmail[14890]: 3a27T58cb00000001: SYSERR(root): readqf: ./qf3a27T58cb00000001: line 1: bad line "- u
nset -"
Apr 28 ...

Am I doomed not to get this software to send a mailing!?

Our first live run has failed - we can sent to test recipients but not to our database - no emails are ever generated (sticks on 0 out of 1679).

I have looked at the logs and we have an SQL error:

SELECT cust.customer_id, bind.user_type ...

Referring back to a previous posting, if I put a date field in a template, it shows as YYYY-MM-DD in the preview BUT when mailed it is received as YYYY-MM-DD HH:MM:SS

Is anyone else having this problem and is there a fix?

Thanks

Can I bump the issue of conditional text modules as this would be extremely useful - for example, we plan to send vaccination reminders to pet owners and if we could do something like the following it would save having to run more than one template/mailing:

[IF agnDB column="species","CANINE ...

Hi, I have a date field I am using in a mailshot, which I am inserting as:

[agnDB column="vacdate"]

Trouble is this appears in the mailing with a midnight time - eg: 2008-05-05 00:00:00.

Two things:

1) Can I format the tag within the template to make it not include the HH:MM:SS

2) Can I ask ...

Well, I am still struggling to make OpenEmm work reliably and wanted to manually add a test recipient, but after submitting the form the user is not added to the database.

If I edit a record the changes *are* saved.

Any ideas?

Thanks

Thanks - I have added this to the wiki

ma wrote:Your installation ran out of database connections. Try to increase the connection pool via the file emm.properties and restart OpenEMM.

Thanks for the quick reply. I have found the file but no specific 'pool' related variable - is this the right one: "jdbc.maxCount=5"??

L3K

Hi,

I have seen this error mentioned with older versions of OpenEMM, but I am having it with 5.4.0 importing csv files. I receive a batch of about 7 files to be imported one at a time (I have tried one big file and it generates errors) and generally I get a 'pool exhausted' error after 3 imports ...

Any interest in this - we'd certainly find it extremely useful.