Search found 20 matches

by tgilbert328
Wed Sep 12, 2007 10:09 pm
Forum: Using OpenEMM
Topic: Direct population of emails via MySQL ODBC and SQL Server?
Replies: 10
Views: 8995

My colleague msafar-ali has documented his steps to automatic population and I added it to the Wiki as requested (albeit later than I had said).

I butchered the formating but the guts of it is there.

http://www.openemm.org/wiki/DatabasePopulation

Tim
by tgilbert328
Tue Aug 21, 2007 1:08 pm
Forum: Using OpenEMM
Topic: Direct population of emails via MySQL ODBC and SQL Server?
Replies: 10
Views: 8995

My colleague has successfully built a DTS package in SQL Server 2000 which inserts, updates and deletes (not really deletes, actually we admin opt-out to preserve the statistics) the various tables in the openemm database. He will document the process and the lessons learnt for the community in this...
by tgilbert328
Tue Aug 21, 2007 1:02 pm
Forum: Using OpenEMM
Topic: Performance of e-mail sending
Replies: 21
Views: 29997

WARNING: My post above about reducing the time-outs did in fact result in a problem with at least one particular user receiving many copies of the same email. It turned out that the mail server was timing out AFTER the final stages of sending resulting in multiple attempts each reported as a time ou...
by tgilbert328
Wed Aug 08, 2007 8:32 pm
Forum: Using OpenEMM
Topic: Performance of e-mail sending
Replies: 21
Views: 29997

Performance tips for Sendmail

Before I begin, I suggest that you purchase O’Reilly’s sendmail 3rd editon by Bryan Costales and read chapter 6 from cover to cover. It is there were I learned this tip, and there are likely many other important tips in there that I did not implement or understand. Firstly, I found an important ...
by tgilbert328
Mon Jul 30, 2007 3:48 pm
Forum: Suggestions
Topic: Test emails should have TEST: prepended to Subject
Replies: 5
Views: 11417

Ok. Thanks!

Tim
by tgilbert328
Wed Jul 25, 2007 2:23 pm
Forum: Development
Topic: Compiling the source code
Replies: 5
Views: 16075

Thank you! I will give it a shot and let you know.
by tgilbert328
Tue Jul 24, 2007 2:58 pm
Forum: Development
Topic: Compiling the source code
Replies: 5
Views: 16075

Could I get your help in compiling a java class? I am useless in java and even though I installed ant, I am having a lot of trouble getting a compile of a single .java file.

If your able, let me know and we can chat offline.

Tim
by tgilbert328
Tue Jul 24, 2007 2:54 pm
Forum: Suggestions
Topic: SURVEY: What do you use OpenEMM for?
Replies: 8
Views: 19532

Newletters

My company uses this product as a replacement for a monthly service fee to a market leading email marketing company. We have several newsletters which we send out a few times per week. In total we send about 1 million emails per month to about 50,000 subscribers. We decided to bring the service in h...
by tgilbert328
Wed Jul 18, 2007 9:17 pm
Forum: Suggestions
Topic: Test emails should have TEST: prepended to Subject
Replies: 5
Views: 11417

Well, I found the file, its MailWriterMeta.java, and I believe the change needs to be made when it creates the XML file, something like whats below in the method public void startBlock () throws Exception { .. .. .. .. buf.append (" </description>\n\n"); buf.append (" <general>\n"); if (data.isTestM...
by tgilbert328
Wed Jul 18, 2007 6:28 pm
Forum: Using OpenEMM
Topic: Direct population of emails via MySQL ODBC and SQL Server?
Replies: 10
Views: 8995

Direct population of emails via MySQL ODBC and SQL Server?

My company maintains our email lists (with opt-in/opt-out etc) in a different location (both physically and architecture) . We are experimenting with populating the MySQL database tables directly, rather than using the Import feature. The challenge is that we have many different newsletters and opt-...
by tgilbert328
Wed Jul 18, 2007 6:20 pm
Forum: Using OpenEMM
Topic: Performance of e-mail sending
Replies: 21
Views: 29997

Final results

I am not sure how typical this is, but for the record, here is the specs on my machine. Its an single core 2.0 Ghz Pentium IV with 2 Gb of RAM running OpenSUSE 10.2. I have one network card connected. In my last three jobs of about 50,000 each, I have achieved an average of ~10,000 emails per hour. ...
by tgilbert328
Fri Jul 13, 2007 8:51 pm
Forum: Suggestions
Topic: Test emails should have TEST: prepended to Subject
Replies: 5
Views: 11417

Exchange is overidding the envelope

Interesting. When I read your note, I checked the message envelope and sure enough, the envelope says "Testmail", see here: To: Testmail <tim.gilbert@XXXXX.XXX> Subject: TEST: Test Email However, using Outlook and MS Exchange, the TO: does not say Testmail rather it has converted my smtp name to my ...
by tgilbert328
Wed Jul 11, 2007 6:57 pm
Forum: Suggestions
Topic: Test emails should have TEST: prepended to Subject
Replies: 5
Views: 11417

Test emails should have TEST: prepended to Subject

One of the problems that i have now is that when I sent out test emails to my testers (18 in all), there is nothing in the email to make it clear this is a TEST rather than the actual mailing. When I sent a Mailing to Test Recipients, the word "TEST: " should be added to the beginning of the subject...
by tgilbert328
Wed Jul 11, 2007 3:48 am
Forum: Using OpenEMM
Topic: Performance of e-mail sending
Replies: 21
Views: 29997

Update

I have spent quite a bit of time using OpenEMM over the past number of weeks, and I have also found that it can be quite slow in sending messages. It seems to get jammed up on the deferred emails. This is what I did to improve performance: 1) I added more RAM to the machine. The more ram the more in...