OpenEMM Technical Support Forum

yeah my post is a bit confusing :oops: ich muss es wohl auf deutsch probieren: Das eigentlich Problem ist folgendes: Wenn man den Status, also ob ein Empfänger Aktiv, Opt-Out-Admin oder Opt-Out-Empfänger ist, von einer externen Applikation steuern will, ist dies momentan ohne manuelles Eingreifen ni...

Hello Folks In my expirience, some endusers like to manage their customers (and the responding email addresses) only in their own software-solution. Theyre used to the system they have and want to control the target groups and also the status by their own software. The workflow is like this: - custo...

Hello Folks... Im not 100% sure how datasource_id works. Is it correct, that datasource_id raises with every import (beginning with 1). And that every customer entered through an action has the datasource_id 0 ? Thx 4 Help, didnt find information in the FAQs nor in the WIKI... EDIT: Just found http:...

Just a small error i fixed in 6.1: File: src/jsp/fckeditor-2.6.4.1/editor/filemanager/browser/emm/browser.jsp Line: 65 <img src="images/spacer.gif" id="theimage" border="1"> has to be: <img src="images/spacer.gif" name="theimage" border="1"...

I updated again some new Recipients, with quite "ugly" data (strange characters in it, e.g. backslashes). I found out that the same error in 6.1 is present. It seems that the developers actually changed some lines in the code, but still there occurring errors. Here is what i found out and ...

Thanks netactive, you helped me a lot! Also had the same problem, made me nuts!!

So a reminder to the developers:
Probably would be a good idea to make actionbased-mailings free of mailinglists...

however, keep up the good work with openemm!

Ohh... thats sad
I just figured it out myself and then I see you already posted the solution here...

Anyway, I made it with the org.apache.commons.lang.StringEscapeUtils and this also works as expected...

Thx 4 the fast answer!

Ok I figured out that the same error exists on the demo account. The first Time the import works, but the second time the same error occours again. (Probably when the UPDATE-SQL-Query is build, then therse no escaping. With the INSERT-Query it works...) The Problem doesnt occurs when in the recipie...

Have you checked the Log-Files?

Probably you should post the last Lines of youre openemm.log here in the forum...

Yes I know that the single quote causes the error, but like ive written above:

"The strange thing is, that on the official demo-account of openemm, the import works..."

Hello Folks, following Problem: When I import recipients with a .csv i get an mysql-syntax-error. In the .csv there are singlequotes (') in the names of the recipients. It seems, that these quotes are causing the problem. The strange thing is, that on the official demo-account of openemm, the import...