Search found 34 matches

by timr
Mon Dec 17, 2018 2:35 pm
Forum: Bounce Management
Topic: bav.conf-local file
Replies: 0
Views: 444

bav.conf-local file

I'm having a problem getting the aliases read in the bav.conf-local file mentioned in the Install guide and wondered if anyone knew what I was missing. Here's what I did and I'm using the Windows version. 1. created a file in openemm/conf/bav called bav.conf-local 2. Added an entry to bav.conf-local...
by timr
Fri Jan 27, 2017 10:24 pm
Forum: Using OpenEMM
Topic: Targeted Email
Replies: 0
Views: 3439

Targeted Email

I think I'm trying to do something that can't be done with OpenEMM but thought I would check with some of the experts on this board before I gave up. Here's what I'm trying to do: 1. Create a new mailing list. 2. Create a filter/target of 1 day after creation or change date. 3. Add some addresses to...
by timr
Tue Sep 27, 2016 2:23 pm
Forum: Installation & Upgrades
Topic: OpenEMM 2015 Windows Version and Remote MySql
Replies: 0
Views: 2320

OpenEMM 2015 Windows Version and Remote MySql

Hi I have used OpenEMM 2013 on a Windows 2008 server box with a remote MySQL database for the past 3 years with no problems. However, I can not get OpenEMM 2015 R2 (or R1 for that matter) to connect to the same remote MySQL. In OpenEMM 2011, the database connection was in emm.properties. Per Mashoff...
by timr
Wed May 06, 2015 7:22 pm
Forum: Bugs, bug fixes & releases
Topic: Openemm 2015 RC2 - Remote MySQL
Replies: 2
Views: 6765

Re: Openemm 2015 RC2 - Remote MySQL

I'm having the same problem with OpenEMM 2015 Windows version. I changed the two URL values in context.xml to the same value as in 2013-emm.properties and I still get "Failed to connect to database" when I run start.bat. Are there any other files that have to be changed to allow access to a remote M...
by timr
Fri Feb 27, 2015 4:27 pm
Forum: Bugs, bug fixes & releases
Topic: 2015 Windows version
Replies: 1
Views: 5291

2015 Windows version

Will there be a Windows version of OpenEMM 2015? And if so, when will it be released?
by timr
Fri Aug 22, 2014 6:54 pm
Forum: Using OpenEMM
Topic: RESOLVED: Total Clicks per URL from Multiple emails
Replies: 0
Views: 2124

RESOLVED: Total Clicks per URL from Multiple emails

Looks like I had the wrong column in the GROUP BY. When I GROUP BY full_url, it returns the counts I need. select distinct(a.full_url), count(*) as num from rdir_log_tbl b join rdir_url_tbl a on b.url_id=a.url_id where b.mailing_id in (453,454) group by a.full_url order by a.full_url desc I'm trying...
by timr
Thu Jul 10, 2014 3:04 pm
Forum: Using OpenEMM
Topic: Unsubscribe link not working?
Replies: 1
Views: 2729

Re: Unsubscribe link not working?

Are you running OpenEMM on a different port than 8080? This is the URL for my Unsub link and it works perfectly. This is the URL I use.

http://www.{company].com:8080/form.do?agnCI=1&agnFN=UnsubQuery&agnUID=##AGNUID##

The only difference in your unsub URL and mine is the :8080 after the .com.
by timr
Wed Jul 09, 2014 5:14 pm
Forum: Using OpenEMM
Topic: Move addresses to another mailing list.
Replies: 1
Views: 2336

Move addresses to another mailing list.

I need to move some email addresses to another mailing list. I've looked at the database schema and it looks like all I have to do is update the mailing list id in customer_1_binding_tbl. This is what I'm trying to do. Email addresses on Mailing list named A (mailing list id =1) Move the addresses t...
by timr
Wed Aug 21, 2013 2:19 pm
Forum: Usability
Topic: Show Subscriber List Regardless of Status
Replies: 3
Views: 12761

Re: Show Subscriber List Regardless of Status

Oops. When I posted this, I was referring to OpenEMM 2011, which I'm still using for production. I have OpenEMM 2013 installed on a testing server and when I view a recipient in OpenEMM 2013, all lists are expanded. Even though lists the recipient has never belonged to are also expanded, this is a l...
by timr
Fri Jul 12, 2013 6:32 pm
Forum: Usability
Topic: Show Subscriber List Regardless of Status
Replies: 3
Views: 12761

Show Subscriber List Regardless of Status

Currently, when I view an email address, the list that the address is subscribed to is shown expanded with the status for that subscriber (opt in by admin, opt in by subscriber, IP address of subscriber etc.). However, if that address has unsubscribed or hard bounced, none of the lists are expanded ...
by timr
Wed Jun 26, 2013 4:18 pm
Forum: Development
Topic: Using tags in forms
Replies: 2
Views: 6690

Re: Using tags in forms

You may have already figured this out since it has been over 3 years but just in case you haven't. agnEMAIL is used to display the email address in an email. To display email address in a form, use $customerData.Email in the form to display the recipient email address. I use this to display the reci...
by timr
Wed Feb 20, 2013 2:22 pm
Forum: Bugs, bug fixes & releases
Topic: Can't view emails with OpenEMM2013 for Windows
Replies: 12
Views: 8843

Re: Can't view emails with OpenEMM2013 for Windows

I found the problem and everything is working now. It turns out that "dynamic_template" in mailing_tbl was set to NULL instead of Zero. Once I updated the mailing_tbl and set "dynamic_template" to 0, it works. Not sure how this happened because the update_openemm-2011-2013.sql script has a line to a...
by timr
Wed Feb 13, 2013 2:49 pm
Forum: Bugs, bug fixes & releases
Topic: Can't view emails with OpenEMM2013 for Windows
Replies: 12
Views: 8843

Re: Can't view emails with OpenEMM2013

I followed the Windows Install Guide exactly and get the errors detailed in my previous post plus this error when I try to create a new mailing. An error occurred Cause: org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity inst...
by timr
Tue Feb 12, 2013 6:18 pm
Forum: Bugs, bug fixes & releases
Topic: Can't view emails with OpenEMM2013 for Windows
Replies: 12
Views: 8843

Re: Can't view emails with OpenEMM2013

I'm aware of that and didn't use the online update. These are the steps I took. Been using OpenEMM 2011 since shortly after it was released with no problems. UPGRADE to 2013 Steps 1. Renamed current folder to OpenEMMOLD. 2. Downloaded OpenEMM 2013 for Windows. 3. Unzipped and copied folders to c:/Op...
by timr
Tue Feb 12, 2013 3:20 pm
Forum: Bugs, bug fixes & releases
Topic: Can't view emails with OpenEMM2013 for Windows
Replies: 12
Views: 8843

Re: Can't view emails with OpenEMM2013

After working on this for a week, it looks like the Windows version of OpenEMM is only available as a new install and not an upgrade. If I upgrade OpenEMM 2011 to OpenEMM 2013 and apply the update_openemm-2011-2013.sql script located in USR_SHARE to the database, I can log in but not view any curren...