Solved

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

Posted on 2015-02-12
3
197 Views
Last Modified: 2015-02-15
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
Comment
Question by:GArlove
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 40607489
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
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 40607492
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
 

Author Closing Comment

by:GArlove
ID: 40611389
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question