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
Search found 20 matches
- Wed Sep 12, 2007 10:09 pm
- Forum: Using OpenEMM
- Topic: Direct population of emails via MySQL ODBC and SQL Server?
- Replies: 10
- Views: 15401
- Tue Aug 21, 2007 1:08 pm
- Forum: Using OpenEMM
- Topic: Direct population of emails via MySQL ODBC and SQL Server?
- Replies: 10
- Views: 15401
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...
- Tue Aug 21, 2007 1:02 pm
- Forum: Using OpenEMM
- Topic: Performance of e-mail sending
- Replies: 21
- Views: 41632
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...
- Wed Aug 08, 2007 8:32 pm
- Forum: Using OpenEMM
- Topic: Performance of e-mail sending
- Replies: 21
- Views: 41632
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 ...
- Mon Jul 30, 2007 3:48 pm
- Forum: Suggestions
- Topic: Test emails should have TEST: prepended to Subject
- Replies: 5
- Views: 14875
- Wed Jul 25, 2007 2:23 pm
- Forum: Development
- Topic: Compiling the source code
- Replies: 5
- Views: 29966
- Tue Jul 24, 2007 2:58 pm
- Forum: Development
- Topic: Compiling the source code
- Replies: 5
- Views: 29966
- Tue Jul 24, 2007 2:54 pm
- Forum: Suggestions
- Topic: SURVEY: What do you use OpenEMM for?
- Replies: 8
- Views: 24512
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...
- Wed Jul 18, 2007 9:17 pm
- Forum: Suggestions
- Topic: Test emails should have TEST: prepended to Subject
- Replies: 5
- Views: 14875
- Wed Jul 18, 2007 6:28 pm
- Forum: Using OpenEMM
- Topic: Direct population of emails via MySQL ODBC and SQL Server?
- Replies: 10
- Views: 15401
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-...
- Wed Jul 18, 2007 6:20 pm
- Forum: Using OpenEMM
- Topic: Performance of e-mail sending
- Replies: 21
- Views: 41632
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. ...
- Fri Jul 13, 2007 8:51 pm
- Forum: Suggestions
- Topic: Test emails should have TEST: prepended to Subject
- Replies: 5
- Views: 14875
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 n...
- Wed Jul 11, 2007 6:57 pm
- Forum: Suggestions
- Topic: Test emails should have TEST: prepended to Subject
- Replies: 5
- Views: 14875
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 t...
- Wed Jul 11, 2007 3:48 am
- Forum: Using OpenEMM
- Topic: Performance of e-mail sending
- Replies: 21
- Views: 41632
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...
- Wed Jun 27, 2007 3:00 pm
- Forum: Installation & Upgrades
- Topic: Mail Delivery (won't send normal emails)
- Replies: 6
- Views: 11488