AboutPaski K. Paskaradevan Expertise I have 3 + years in Lotus Notes application development. I am a CLP R5 Application Development. I can answer any question pertaining to application development.
Experience R5 CLP. In addition, I have a bachelors degree in Engineering and a MBA.
Expert: Paski K. Paskaradevan Date: 12/7/2007 Subject: Exporting data from a web form?
Question I have 2000+ responses coming into a folder from a webform that look like this:
________________________________________________
A new web lead has been entered:
FIRST: Fred
LAST: Flintstone
TITLE: President
________________________________________________
I want to be able to export the data from all the emails in this folder to one file that separates the fields in some way, comma, tab, whatever...so I end up with column headings of FIRST, LAST, TITLE and the data from all the emails listed beneath. It is so easy to do this in Outlook, but I just can't figure it out in LotusNotes.
Thanks in advance for any help :-)
Holly
Answer Hi,
You need to write a lotus script agent which will read the email one by one and export it to an excel spread sheet.
If the above detail is in the body of the email, use the Split method to split the content. Then find each value after the repective lable (value after FIRST: will be he first name). See NotesRichTextItem class for more details.
Then populate the spread sheet with these values. Populating the spread sheet from notes code is available in the internet. You have get it and modify it to suit your needs.
If the above values are in separate fields, then the export code is the only one you need to worry about.
This is advanced programming work using lotus script. I am assuming that you are a notes programmer. If not, contact your notes developer.
