Customer Email Marketing Report yielding 0 records

Hello All,

I'm, not sure if comments posted in Users > Shared Resources get distributed to anyone (?) and so I'm asking here.

I found this recent report template that among other things generates a list of those customers that have provided us with email addresses.  That's exactly what I need... in fact it could be simpler.  Unfortunately this template does not yield any records when run on our system.

I assume from the submission date that this report works with the 1.7.1 database but I'm wondering if we've done something in our implementation of the default email address function such that this report doesn't pick up the email addresses.  I previously modified our 1.7 code and recompiled in accordance with the code change in Jira-1520 "When a new customer is created, add an email contact as well as a phone and location contact".

I'm wondering if there is an email tag generated that was called one thing in the code, and another in the SQL query.  If so, it doesn't jump out at me.  Can someone suggest a SQL query fix for the report or recommend another report template that will provide a email addresses, either as a printed report or for export?

Thanks,

 

Sam Longiaru

Kamloops, Canada

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Customer Email Marketing Report yielding 0 records

Sam - have a look at the last post in http://www.openvpms.org/forum/generating-active-client-period-list - grab that and have a play.

 

Regards, Tim G

 

Syndicate content