Extract/Export attachments out of Lotus Notes

HCL Domino Domino Forum
1

What we need to do is extract/export the attachments from Lotus Notes including the incident number so that when we import into a SQL Server database the attachments will be insync with the incidents.

Are there any scripts or ideas on how to do something like this?

Thanks

2

Subject: Extract/Export attachments out of Lotus Notes

HelloI was intersted to read this topic as I need to extract attachments from Lous Notes into an Oracle database. However I find that the attachments are always compressed when placed in Oracle.

Do you now how to decode them - I am referring to the ‘Base64’ comment? or do you now a way of extracting them already decoded? It is an interesting problem…

3

Subject: Extract/Export attachments out of Lotus Notes

How are the incidents stored, as text next to the attachment? You could probably do this with DXL by walking the tree and decoding the Base64 encoded attachments.

4

Subject: RE: Extract/Export attachments out of Lotus Notes

Hi,

sorry for not answering before.

The word document is store in several fields in the notes document.

I doubt if decoding an putting all together will work, but I will have a try.

Thanks

5

Subject: Extract/Export attachments out of Lotus Notes

I have some untested code for extracting attachments from a mail file. Let me know if you want it.

6

Subject: RE: Extract/Export attachments out of Lotus Notes

Hi,

sorry I did not answer before (forgot using the notification).

If your code can extract embeddedObject which are not attachment but OLE object I would be very glad if you could post the relevant part.

Right now I can only read attachments.

Thanks for your help

7

Subject: RE: Extract/Export attachments out of Lotus Notes

Here’s one way: file attachments in LCLSX