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

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.
pbo1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

iPinkyCommented:
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
pbo1Author Commented:
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
polarsnowboarderCommented:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

iPinkyCommented:
sorry.. was busy.. I will try to provide something until next Monday...
0
pbo1Author Commented:
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
iPinkyCommented:
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
pbo1Author Commented:
thanks for the update iPinky
0
iPinkyCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
iPinkyCommented:
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
pbo1Author Commented:
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
iPinkyCommented:
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
pbo1Author Commented:
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
iPinkyCommented:
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
pbo1Author Commented:
Thx for solution and sample....I appreciate you sticking with me....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.