I'm working on a similar project. We have daily newsletters that are sent from our University Relations group. These are saved in an Exchange mailbox on a regular basis.
I created a page that uses cfx_imap4 to pull these messages, save the attachments to a folder, then saves the actual email message as an HTML file. I chose to save the messages as HTML files rather than insert them into a DB table so I can use the Verity search engine and not have to worry about all of the DB interaction required. (On the next version of my intranet, I may change my mind, however.) This simple process works great, however, I'm rebuilding it to make it more-efficient thanks to Paul. I will retract my earlier comments about the performance issues. After talking to Paul, we determined that our Exchange server is getting hammered big-time. In addition, that Exchange is not optimized for IMAP, but rather for MAPI clients such as Outlook. I duplicated this issue using an IMAP client and the download times were slow as well. So, I cannot fault the cfx_imap4 tag for this. So, that said, what is your mail server? If it is Exchange, you probably will have some issues unless you have a dedicated Exchange server for your application. ;^) Since you are importing the messages into another data store, does performance matter "that much"? My mailbox contains about 350 email messages. It takes about 3-4 minutes to pull those messages, save the images, then save the message. A few of these files are greater than 1MB. The majority are 50KB or less. I'd be glad to share any other information that I can. I also agree that Paul provides excellent support for this product. M!ke -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 4:51 PM To: CF-Talk Subject: RE: CFX_IMAP4 ... or .. ? Have been playing with it today, can report back it's easy to install and Paul has been great on support with the questions I had after trying it out. I'm interested in it's scaleability on large imap folders, if anyone has some numbers it would help greatly. My plan is to use imap to import the mail into ms sql and offer it as an on line archive on a project I'm working on for a client. Thanks Paul, great product (and a bargain!) Jenny -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 16 November 2005 23:10 To: CF-Talk Subject: RE: CFX_IMAP4 ... or .. ? I'm talking several hundred messages, all Word-generated HTML with images contained within. The messages themselves can be pretty large with all the sloppy Word crap in them. Honestly, I really haven't tried it on smaller mailboxes/messages yet. Haven't had the need, actually. But, this thing is pretty damn powerful. Paul Vernon is great with his support, too. M!ke -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 5:00 PM To: CF-Talk Subject: RE: CFX_IMAP4 ... or .. ? Hi Mike, Thanks for the feedback ... at what point did you notice it was getting slow, how many messages? I'm thinking I can avoid a large imap folder by pulling everything off at regular intervals and pushing the messages into ms sql, but would be good to know at what point it's necessary to do so. Thanks, Jenny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
