Solved

Within Lotus Notes how do I automatically loop thru my inbox and remove attachments

Posted on 2010-09-02
14
515 Views
Last Modified: 2013-12-18
I want to be able to automatically loop thru my inbox hourly within lotus notes and do the following:
Remove any attachments (could be multiple attachments in an email) and place on a shared drive
Place the email into my "Done" folder

I have Lotus Notes 6.5 and I also have Notes developer.  However, if someone does not have Notes developer will I be able to set up this automatic job on there machine.  Note I only want to have 3 PC's run this auto job, but 2 PC's do not have Notes Developer.
0
Comment
Question by:pbo1
  • 7
  • 6
14 Comments
 
LVL 5

Expert Comment

by:iPinky
ID: 33594776
well... as I would not really fiddle around with the mail template I would create another db.
in that db you could setup profiles for each user which needs this functionality. in those profiles you would set the username/replicaid and path of the db/shared drive/folder location in which you want to extract the attachments. (could be for each user into a separate directory

you would then create a simple agent (which unrestricted access, as it accesses other dbs) which loops through those profiles and does the following for each profile:
get the mail db (via replica id most probably)
get the view ($Inbox) or another view, loop through the documents
check if the documents cohere to the criteria to remove the attachments (check sender/subject maybe)
then get the attachments, put them to the shared drive (which would mean the domino server would need to have this connection too!) and remove them from the mail
mark the mail (maybe in the subject) so that the user can see the the attachments have been removed and put a "placeholder" with the filename in the part of the document where the attachment had been removed

this is simply an overview of the concept.. from your question I assume you don't really have much experience in such things..

just let me know.. I could supply you with a sample db which does it (by middle of next week you could have it)
0
 

Author Comment

by:pbo1
ID: 33595917
if you could provide a sample db that would be great...note I am pretty proficient in Ms. Access so I  coulld run the code from Ms. Access..i just thought it might be simpler to do from within notes but I have little experience in notes
0
 

Expert Comment

by:polarsnowboarder
ID: 33687023
It would be easiest to use an Agent that loops through the documents and then uses a NotesRichTextNavigator to remove the attached elements. Use the GetFirstElement and GetNextElement methods.
0
 
LVL 5

Expert Comment

by:iPinky
ID: 33689699
sorry.. was busy.. I will try to provide something until next Monday...
0
 

Author Comment

by:pbo1
ID: 33691880
Thanks iPinky..in the interim I am trying to review some basic Notes Agent Code in order to be more familiar with what you provide
0
 
LVL 5

Expert Comment

by:iPinky
ID: 33739582
Hi.. short update.. I am working on the demo.. almost finished.. but it needs some tweeks..

sorry again for the delay.. but I was kept hold up the past few days, stay tuned!
0
 

Author Comment

by:pbo1
ID: 33741250
thanks for the update iPinky
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 5

Accepted Solution

by:
iPinky earned 500 total points
ID: 33741484
so.. finally I have the proposed solution ready..

only drawback: it doesn't work for MIME mails...

but you could talk to your Admin, he can setup inbound emails to be automatically converted into Notes RT items:
http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.help.domino.admin.doc/DOC/H_CONFIGURING_HOW_DOMINO_CONVERTS_INBOUND_MIME_MESSAGES_TO_NOTES_RICH_TEXT_STEPS.html
AttachmentMover.zip
0
 
LVL 5

Expert Comment

by:iPinky
ID: 33741761
what I forgot: short introduction:
the db has 3 main parts:
user profiles (which can be imported from a names.nsf or manually created)
logs
keywords

in the keywords section you have the two needed keywords already, just set them up the way you need/like it

the user profile section lists relevant info for the db how to find users mailboxes and how to find and where to store attachments

the most important agent is the "RemoveAttachments". I would schedule it to run on any server. It wil go through all user profiles (I hope you don't have too many otherwise some tweaking would be required) and sees if their mail is on the same server as where the agent currently runs, if so the mail db is being processed and a log is being written

as formula for emails to be processed you could use something like:
@contains( @uppercase( subject ); "ATTACHMENT" )

this would only remove the attachments from mails which contain "attachment" in the subject field
0
 

Author Comment

by:pbo1
ID: 33750619
Thanks iPinky,
If I am only interested in running the agent on my email inbox and a group inbox how would I tweak the above...Also, what do you consider a MIME email..
0
 
LVL 5

Expert Comment

by:iPinky
ID: 33778575
Hi pbo1

just create profiles which point to the group mailbox and to your mailbox and run the agent.

The agent you could then maybe run on demand as opposed to run on server

0
 

Author Comment

by:pbo1
ID: 33872997
I'm not quite sure how to create a profile...I probably need to take a basic Notes class relative to agents/profilles...any suggestions ?
0
 
LVL 5

Expert Comment

by:iPinky
ID: 33873766
just look at the sample db it's all in there... and if you read my instructions again thoroughly you will figure it out...in the db you even have a button called "New User Profile".. it's all setup. ready to go
0
 

Author Closing Comment

by:pbo1
ID: 33881387
Thx for solution and sample....I appreciate you sticking with me....
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Synchronize IBM notes Internet Password with AD 9 367
Lotus Domino 9.0 install on same pc with 8.5.3 9 129
Using @Prompt in a Queryclose Event 14 83
@Mailsend 3 41
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now