OpenEMM Technical Support Forum

Hi Pheelix. Thanks for the suggestion. When I first click "Recipients-Overview", it takes 30 seconds for the screen to appear. It displays the first 50 recipients. I can get the same list directly from MySQL with the query "select * from customer_1_tbl limit 50" in less than one ...

Hi. It now takes about 30 seconds to display the Recipients Overview page, regardless of the selection criteria. We have 2.5 million recipients. How can we speed up this display? Thanks. John

Hi,
When I run an unsubscribe action, I want to call a web service on another server. (We have another system that needs to be notified when a customer unsubscribes.) How can I do that?
Thanks, John.

Hello, I created a date-based mailing and I set the appropriate dyn_target_tbl.target_sql to the following where clause: date(created) >= date_sub(current_date, interval 7 day) and customer_id not in (select customer_id from mailtrack_tbl where mailing_id in (37,59,62,63)) As a stand-alone query thi...

Hi, Within the html content section of a newsletter, we include the following link. <a href="https://store.mycompany.com/store/Upgrade.do?username=[agnEMAIL]&slk=n_62_freetrial"> OpenEmm does NOT replace that url with a trackable link. I'm assuming that's because of the embedded agnEMA...

Hi, I'm loading 500,000 records into OpenEMM using SOAP addSubscriber and setBinding. When I start up my loader program it inserts about 20,000 records per hour. Then it gradually runs slower and slower until after 10 hours it can only insert two or three records per minute. Then finally any attempt...

Hi Jehu, The 500 error I was getting with my own SOAP client was good news. That meant I was successfully connected to the SOAP server. I eventually figured out that even though I was getting the 500 error I was also getting a response with detailed error messages about syntax errors in the xml I wa...

When I do an unsubscribe with no MAILINGLIST parameter, how does it decide which mailing list to unsubscribe?

(It seems to be working OK, but I don't know why. I use multiple mailing lists, and the unsubscribe seems to unsubscribe the correct one.)

Thanks
John

Thank you. That fixed it.

Hi, I'm using webservices to insert subscribers. I make two calls: addSubscriber and setSubscriberBinding. The add works fine, and the setbinding takes 7 or 8 seconds for each record. The customer_1_binding_tbl has just over 1 million records. I can select individual records by customer_id instantly...

User-defined profile fields added to the customer table can be one of three types: Numeric, Alpha, or Date. The Date type is MySql type "Date" which does not include time. This prevents us from storing the time. When updating the customer table via web services using the addSubscriber meth...

Target group specifications are saved in the dyn_target_tbl table. When you follow the instructions in the OpenEMM documentation, section 5.3.2 Date Functions, regarding current_timestamp, the value OpenEMM puts into the target_sql column is invalid SQL and does not work. The work around is to manua...

Hi, We want to send emails based on the time of day the user registered for our service. For this I need a profile field with type timestamp. When I create my own profile fields, the types offered are numeric, alpha, and Date, but not timestamp. I want to: 1) alter the MySql customer_1_tbl changing ...

Nevermind. I got it working.
Thanks.

Yes it works!
Thanks very much.
John