Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Lotus Domino - populate document fields from contents of an inbound email

Hi all,

We have developed a simple support tracking system that my company has been using for some time now however I have been asked if we can have users initiate a support via an email .
i.e. A user would send an email to a specific address .
An agent or similar would pick up this new email creating a new support call document , using the send by, subject line and email body to populate certain fields in the document and then save it.

I'm fairly new Domino development and I was after at least at a high level how one would approach achieving this in Domino.
We are using Domino v 8.5

thanks
0
GArlove
Asked:
GArlove
  • 2
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
The good news: you can set up ANY Notes database to receive mail. In fact, Domino/Notes is ideal for this kind of application, for you can handle the mails directly in the application. No external mail listeners required.

The recipe:
- create a MailIn document, in the Domino Directory database (names.nsf)
- it enables the router to find your database (might need a Router restart on the server)
- when you send the new addrss a mail, it arrives in the form of a document with Form="Memo"
- build a view (called Inbox) with Memo documents
- then create an agent that is triggered on When mail has arrived
- the agent will be triggered up to 30 minutes after reception of the mail (can be altered if necessary)
- (there is the possibility to use a Before mail arrives trigger, better not use it, it runs real-time and can hold up the server)
- the agent should visit the Inbox and handle all incoming mails, one by one
- the easiest would be if it removes the documents from the Inbox once they have been handled
- or use a 2nd view, with a different Select statement, and add a field Processed to the mail that's handled
- the code can pick up the sender, the subject, and the body
- things to think of: attachments, large documents, spam, irrelevant or wrongly addressed mails
- you could even move all mails, once handled, to a separate database
- or receive them in a separate db that you set up as a mail db, with an agent that moves specific mails to your db

You see, plenty of possibilities !
0
 
Sjef BosmanGroupware ConsultantCommented:
Ah, I forgot the bad news... Can't think of any right now... ;-) Well, it might take a while to fine-tune the agent and the text recognition part, but once that's done, it'll work forever.
0
 
GArloveAuthor Commented:
Thanks Sjef,

This is what I was after .
Now that I know the steps at a high level I will research the individual components and see if I can get it going .

cheers
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now