Have Inbound Mail go to ASCII File instead of Inbox

[keithatuprr]

I am working on a project where I would like an inbound piece of mail go directly to an ASCII file instead of an inbound mailbox. From there, I plan to import the file into an Oracle database. Obviously I would like the mail file to go directly to the database, but that's probably not an option. Do any of you know how I can make either of these things happen? Thanks so much!

 

[Roverfish]

This is a pretty interesting one...

What I would do is to set up a mail-in database (let's call it Info) that email would be directed to (its email address would be info@company.com). Copy the design from the mail template over to Info and modify the Memo form used for email. Strip out all the non-essential fields, leaving only those you intend to port over to the database. From this point, it's simply a matter of creating an agent that runs through the modified Memo documents and outputs to a flat file. Or you can play with one of the enterprise integration solutions like LEI, DECS, or NotesSQL and try loading the database that way (be warned that NotesSQL 3.0 appears to have issues with Win2K).

Hope this helps. "One fish, two fish,
Red fish, blue fish."