Notes Script to Forward Attachments but not body
The company I work for uses notes 6.5 soon to upgrade to 8.0
for one large customer we receive email orders via a third party service provider called ARIBA.
The emails have a large amount of very formated text that is copy of the order document.
They also have an htm attachment. whole email typically is between 30 and 80 kb and the htm attachments are always about one third the size of the body.
Notes takes about 3-4 minutes to open one of these emails meanwhile your computer is locked up.
3 different companies involved three different IT departments. Every one point the finger elsewhere.
The HTM attachment opens instantly and is clean. Therefore I am trying to find a notes script that will allow me to filter the incoming email looking the the body text for site ID number then based on that forward just the attachment with some default body text and the original emails subject line.
I can find plenty of script examples to strip off attachments but I want to know if its possible to do the exact opposite.
However if anyone knows why Notes might be taking so long to open an email I am open to understand why I have this problem in the first place. Send these emails to any other mail client ans they open no problem.
I am sorry I cannot attach and example of the email as confidentiality prohits me form doing so.
Any help would be much appreciated
Regards to all
David
PS while I can survive in a world of VB code I know nothing about notes scripting
for one large customer we receive email orders via a third party service provider called ARIBA.
The emails have a large amount of very formated text that is copy of the order document.
They also have an htm attachment. whole email typically is between 30 and 80 kb and the htm attachments are always about one third the size of the body.
Notes takes about 3-4 minutes to open one of these emails meanwhile your computer is locked up.
3 different companies involved three different IT departments. Every one point the finger elsewhere.
The HTM attachment opens instantly and is clean. Therefore I am trying to find a notes script that will allow me to filter the incoming email looking the the body text for site ID number then based on that forward just the attachment with some default body text and the original emails subject line.
I can find plenty of script examples to strip off attachments but I want to know if its possible to do the exact opposite.
However if anyone knows why Notes might be taking so long to open an email I am open to understand why I have this problem in the first place. Send these emails to any other mail client ans they open no problem.
I am sorry I cannot attach and example of the email as confidentiality prohits me form doing so.
Any help would be much appreciated
Regards to all
David
PS while I can survive in a world of VB code I know nothing about notes scripting
ASKER
reply to Sjef
It doesn't matter which user receives these emails and I have tested it in notes 6.5 and the latest notes version, this had been run on various user PC's all with the same result, the email itself, that is the body of the email takes 3 minutes just to open, the htm attachment can be opened instantly once the email has loaded. So even to view the email in the preview pane takes 3 min for the preview pane to show the body.
I had our IT department turn off keep senders format, to "prefers rich text" When this is done the email comes in as two identical HTM attachments, both have no problem opening but now there is no body text to run sorting rules on so this solution doesn't work except to suggest that its something in the body text that is giving Notes a heart attack.
The ARIBA folk blame the corporation X who is issuing the purchase orders via their Ariba network ( our customer, Corporation X say its must be a server side problem at my company. And much to my joy our IT department says ARIBA and corp X are both full of ***#! if it wasn't for the problems it is causing our customer service department who can't keep waiting 3 minutes for an email to load it would be funny.
I have routed the same exact emails to my own gmail, and apple mail accounts where they open perfectly, the body text loads with no issues.
This is why I am looking at what scripting might be able to do.
Any thoughts or suggestions would be very welcome.
Thank you for you comments so far
It doesn't matter which user receives these emails and I have tested it in notes 6.5 and the latest notes version, this had been run on various user PC's all with the same result, the email itself, that is the body of the email takes 3 minutes just to open, the htm attachment can be opened instantly once the email has loaded. So even to view the email in the preview pane takes 3 min for the preview pane to show the body.
I had our IT department turn off keep senders format, to "prefers rich text" When this is done the email comes in as two identical HTM attachments, both have no problem opening but now there is no body text to run sorting rules on so this solution doesn't work except to suggest that its something in the body text that is giving Notes a heart attack.
The ARIBA folk blame the corporation X who is issuing the purchase orders via their Ariba network ( our customer, Corporation X say its must be a server side problem at my company. And much to my joy our IT department says ARIBA and corp X are both full of ***#! if it wasn't for the problems it is causing our customer service department who can't keep waiting 3 minutes for an email to load it would be funny.
I have routed the same exact emails to my own gmail, and apple mail accounts where they open perfectly, the body text loads with no issues.
This is why I am looking at what scripting might be able to do.
Any thoughts or suggestions would be very welcome.
Thank you for you comments so far
I'd like to pursue the investigation a little further, if you're interested. And er, I may be full of xxxx too, for I too am inclined to believe that it is the server. Other possibility: the mail is an HTML-mail, there are many images in the mail, the images are not in the mail itself but have to be downloaded. We'll see...
You could do a simple test: make a replica of the mail database on your local workstation, open the newly created replica, time how long it takes to open the mail, and do it once again (the first time all kinds of views may have to be indexed, so that wouldn't be fair). How long does it take the second time to open the mail??
You could do a simple test: make a replica of the mail database on your local workstation, open the newly created replica, time how long it takes to open the mail, and do it once again (the first time all kinds of views may have to be indexed, so that wouldn't be fair). How long does it take the second time to open the mail??
ASKER
Ok,
More facts first our IT department is never wrong (Even when they are dead wrong)
Joking aside.
In our company we all run lotus notes on a local copy that replicates every 10 - 15 min.
If I open these emails up on the server directly the open quickly ans none have presented an issue
If I open these problem emails up on the local replica then I encounter the 3 min plus load time the first time I open the email but then not again during that notes session. ie close the mail reopen it and it comes up instantly
If I close notes then reopen notes I get the same 3 min plus load time on the problem emails even though they had been opened before
if it helps in the DOC Properties the following is in the body field for a typical problematic email and yes it appears that it is getting some of the logo s and stuff from the internet.
Field Name: Body
Data Type: MIME Part
Data Length: 105 bytes
Seq Num: 2
Dup Item ID: 0
Field Flags: SIGN SEAL
"Content-Type: multipart/mixed;
boundary="----=_Part_187_8
"
Field Name: Body
Data Type: MIME Part
Data Length: 14207 bytes
Seq Num: 2
Dup Item ID: 1
Field Flags: SIGN SEAL
"------=_Part_187_8390573.
Content-Transfer-Encoding:
Content-type: text/html; charset=UTF-8
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html dir=LTR>
<head>
<meta http-equiv="imagetoolbar" content="no"/>
<Base href="https://service.ariba.com">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/ariba.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/widgets.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/i18n.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/p/Ariba/StyleSheet.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/p/Ariba/asni18n.css">
<title>
Ariba Supplier Network
</title>
</head>
<body hasRefreshRegions=false>
<table align=center cellspacing=0 cellpadding=0 width="95%">
<tr>
<td valign=top align=left colspan=4><br/><i>This purchase order was delivered by Ariba Supplier Network. For more information about Ariba and Ariba Supplier Network, visit http://www.ariba.com.</i><br/><br/></td>
</tr>
<tr>
<td valign=top align=left colspan=2>
<img src="https://service.ariba.com//an/logos/AN01002712981.gif">
</td>
</tr>
<tr>
<td colspan=2 align=left valign=top>
<h3>
Purchase Order</h3>
<span style="font-size:110%;font
12386468 </span>
</td>
</tr>
<tr>
<td colspan=4 valign=top align=left>
<span class=tableText>
<br/>
Order submitted on:Thursday 22 Apr 2010 5:07 AM GMT-05:00<br/>
Received by Ariba Supplier Network on:Thursday 22 Apr 2010 2:02 AM GMT-05:00<br/>
</span>
</td>
</tr>
<tr>
<td align=left valign=top ..."
Field Name: Body
Data Type: MIME Part
Data Length: 207 bytes
Seq Num: 2
Dup Item ID: 2
Field Flags: SIGN SEAL
"
------=_Part_187_8390573.1
Content-Transfer-Encoding:
Content-type: text/html; charset=UTF-8
Content-Disposition: attachment; filename="12386468.htm"
12386468.htm"
Field Name: Body
Data Type: MIME Part
Data Length: 66 bytes
Seq Num: 2
Dup Item ID: 3
Field Flags: SIGN SEAL
"
------=_Part_187_8390573.1
"
More facts first our IT department is never wrong (Even when they are dead wrong)
Joking aside.
In our company we all run lotus notes on a local copy that replicates every 10 - 15 min.
If I open these emails up on the server directly the open quickly ans none have presented an issue
If I open these problem emails up on the local replica then I encounter the 3 min plus load time the first time I open the email but then not again during that notes session. ie close the mail reopen it and it comes up instantly
If I close notes then reopen notes I get the same 3 min plus load time on the problem emails even though they had been opened before
if it helps in the DOC Properties the following is in the body field for a typical problematic email and yes it appears that it is getting some of the logo s and stuff from the internet.
Field Name: Body
Data Type: MIME Part
Data Length: 105 bytes
Seq Num: 2
Dup Item ID: 0
Field Flags: SIGN SEAL
"Content-Type: multipart/mixed;
boundary="----=_Part_187_8
"
Field Name: Body
Data Type: MIME Part
Data Length: 14207 bytes
Seq Num: 2
Dup Item ID: 1
Field Flags: SIGN SEAL
"------=_Part_187_8390573.
Content-Transfer-Encoding:
Content-type: text/html; charset=UTF-8
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html dir=LTR>
<head>
<meta http-equiv="imagetoolbar" content="no"/>
<Base href="https://service.ariba.com">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/ariba.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/widgets.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/ariba/branding/i18n.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/p/Ariba/StyleSheet.css">
<link rel=stylesheet type="text/css" href="https://service.ariba.com/an/p/Ariba/asni18n.css">
<title>
Ariba Supplier Network
</title>
</head>
<body hasRefreshRegions=false>
<table align=center cellspacing=0 cellpadding=0 width="95%">
<tr>
<td valign=top align=left colspan=4><br/><i>This purchase order was delivered by Ariba Supplier Network. For more information about Ariba and Ariba Supplier Network, visit http://www.ariba.com.</i><br/><br/></td>
</tr>
<tr>
<td valign=top align=left colspan=2>
<img src="https://service.ariba.com//an/logos/AN01002712981.gif">
</td>
</tr>
<tr>
<td colspan=2 align=left valign=top>
<h3>
Purchase Order</h3>
<span style="font-size:110%;font
12386468 </span>
</td>
</tr>
<tr>
<td colspan=4 valign=top align=left>
<span class=tableText>
<br/>
Order submitted on:Thursday 22 Apr 2010 5:07 AM GMT-05:00<br/>
Received by Ariba Supplier Network on:Thursday 22 Apr 2010 2:02 AM GMT-05:00<br/>
</span>
</td>
</tr>
<tr>
<td align=left valign=top ..."
Field Name: Body
Data Type: MIME Part
Data Length: 207 bytes
Seq Num: 2
Dup Item ID: 2
Field Flags: SIGN SEAL
"
------=_Part_187_8390573.1
Content-Transfer-Encoding:
Content-type: text/html; charset=UTF-8
Content-Disposition: attachment; filename="12386468.htm"
12386468.htm"
Field Name: Body
Data Type: MIME Part
Data Length: 66 bytes
Seq Num: 2
Dup Item ID: 3
Field Flags: SIGN SEAL
"
------=_Part_187_8390573.1
"
That's all very valuable information (except for the first line, admins live in a different world, one in which IT generates the money...), I'd really would have liked to have seen that right at the start. You'd have spared me the full-of-xxxx feeling, for it is now clear that the server isn't to blame, nor the network.
Now, the mail is indeed an HTML mail, and there are 5 additional files that need to be opened, for a total of give or take 210K. Which isn't exactly a show stopper.
Can you tell me what the settings in the Notes client are for the browser? To find them, you need to open the current Location document (most likely called Office), I hope you know how to open that document. Inside, you find the browser settings. Can you set it to plain MS Internet Explorer, so not inside Notes or any other alternative. Then close and restart your Notes client. Now try to open your local mail again.
Btw, to see the HTML-details of a mail much easier, you can open it and then click on View/Show/Source...
Now, the mail is indeed an HTML mail, and there are 5 additional files that need to be opened, for a total of give or take 210K. Which isn't exactly a show stopper.
Can you tell me what the settings in the Notes client are for the browser? To find them, you need to open the current Location document (most likely called Office), I hope you know how to open that document. Inside, you find the browser settings. Can you set it to plain MS Internet Explorer, so not inside Notes or any other alternative. Then close and restart your Notes client. Now try to open your local mail again.
Btw, to see the HTML-details of a mail much easier, you can open it and then click on View/Show/Source...
ASKER
Dear Sjef
I made the change your recommended but it made no difference, but since you had me fishing in the location preferences I went looking to see how the proxy server was set up. Since internet access via our notes is not our domino server experts priority it seems he put in the 1080 as the port for the proxy's but not the relevant IP address or the exceptions. Once I made the proxy settings match our Explorer server setting the problems seem to have vanished.
I have restarted notes several time and opened all the emails that have caused problems several time and no problems.
Does this change make sense to you too? Notes is somewhat of a mystery to me as it had 100's of setting everywhere.
Assuming this is the solutions I thank you very much for all your help and for saving me from having to think about scripts .
If you agree that this is a solution I will go ahead and submit the points to you.
Very best Regards
David
I made the change your recommended but it made no difference, but since you had me fishing in the location preferences I went looking to see how the proxy server was set up. Since internet access via our notes is not our domino server experts priority it seems he put in the 1080 as the port for the proxy's but not the relevant IP address or the exceptions. Once I made the proxy settings match our Explorer server setting the problems seem to have vanished.
I have restarted notes several time and opened all the emails that have caused problems several time and no problems.
Does this change make sense to you too? Notes is somewhat of a mystery to me as it had 100's of setting everywhere.
Assuming this is the solutions I thank you very much for all your help and for saving me from having to think about scripts .
If you agree that this is a solution I will go ahead and submit the points to you.
Very best Regards
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or does it already take 3 minutes just to open the mail? If that's the case, does it take a long time to open ANY mail?
Did you try to separate the problem from PC and person? Meaning: did you use a different PC under your name to open the same mail? Did you try to open the same mail under a different name?
Oh, and forwarding the attachments is possible, but it's a coding job I dislike a little, so I leave that to someone else.