Hi All,
Help appreciated before i start. I have a database that is receiving warranty claims into it from email. Some of our retailers use html within their emails and this causes problems displaying at our end. I wanted to strip the formatting from the email so i was left with plain text and the attachment. I can get the text into another field using the simple @Text(Body) but the attachment remains in the main body field with the extra formatting. If i do not display the body field in the document the attachments are displayed at the bottom of the screen below the line but will only allow myself and my manager edit access when double clicked on and not the warranty staff who will be processing the claim. I have given the warranty staff manager access to the db but still no luck.
Thanks
Darren
Subject: What exactly are you trying to do?
I’m a bit confused, but will try to help. You mention that you are trying to get text out of a body field. Is the body field a Rich Text field? If so, I recommend getting the text as “getunformattedText” via lotusscript. If HTML still remains, you can do a ReplaceSubString to remove or replace values. Also, if the embedded attachments only exist in the body field and not in “$FILE” values on the document, you could extract them out of the Body field if you want to get a handle on the actual attachment without putting the document into edit mode. If you could give a narrative of the way you’d like things to work and how they work, perhaps I can provide a best approach.
Subject: Response
Thanks for your help.
I can strip the text into a separate field called BodyText which is of text design. That parts fine. The problem i have is that the warranty claim attachment still resides in the Body field which is rich text. If i do not put a body field on the document but let the incoming email create it. That attachment will display at the bottom of the notes document under a line separator but will not allow the warranty staff to edit the document, only open. It will however allow me to edit the document in the same way by double clicking on it. I have given the standard user manager access of the database but it will still only allow the standard user to open and not edit, so i can’t find the difference that is allowing me to edit the document and not them.
Basically i want to strip the html data link and images from incoming emails as this causes problem internally with the way we display and process warranty claim internally.
Thanks
Darren
Subject: Are Attachments Only In Body?
Are your attachments only in the Body field or are they also specified as $FILE fields? You can view this from the document properties box. If your attachments exist as $FILE as well, you can reference them without needing the body field, but if they are only in the body, you’ll need to strip them out. I have code for that. In any case, access to the document is based not on any rich text field but on 1. Form properties under the Security tab (key icon), then 2. based on an authors field in the document. If this doc is being created via a mail-in document process, I’d recommend putting an authors field on the form just to make sure the value for authors gets created properly. A simple authors field with “*” would allow everyone with author access to the db to edit this document. Check your document properties. You probably have an authors field on these documents but only your name is listed in it because it was created by you since you were the signer. Let me know if I can assist further.