Are there specific steps to get the "Extract File Attachments" feature to work in a HEI Notes connection?

HCL Domino Domino Forum
,
1

I am using a Direct Transfer activity in HEI to send data from a Notes database to a SQL table. I got the data transfer working but I would like to utilize the "Extract File Attachments" feature but I just cannot get it work. In the Notes connection document under the "Section Options" tab, I have "Include Documents of Other Forms" and "Extract File Attachments (FILE)" selected and the name of the view I am using to get the documents in the "Selected View" field.

I have added a "FILE (varchar(max), null) column to the SQL data I am sending data. I have read that this column is needed to store the name of the files.

I have tried entering a path in the "File Path for File Attachments:" but still does not work with or without a path.

Am I missing some steps or need to use a different activity?

Thanks in advance.

2

Hi Greg,

You may want to use the Virtual Attachments feature.

The Virtual Attachments feature allows you to use HCL Notes® to add attachments to the external system database. File attachments will be stored in the external system rather than in your HCL Domino® application.

You can check the details on how to use it in the documentation below. You can find it in the HEI Activities and User Guide (leidoc.nsf).

Welcome to the HEI documentation (hcltechsw.com)

3

Morning,

Thanks for the reply. Using Virtual Attachments would mean I would need to use a Virtual Fields or Virtual Documents activity, correct? If so, not sure if we want to use that for this instant.

4

Hi,

The option "Extract File Attachments" in Notes connection document is used for saving files on disk.

Please refer Lotus Connector Connectivity Guide in Domino help directory.
Chapter 3 - Transferring Attachments
-------------------

IBM® Lotus® Notes® stores attachment data separately from rich text field data. Currently you can only transfer attachments from Notes to Notes; rich text fields with attachments do not store correctly in the target RDBMS such as DB2® and Oracle®.
To work around this constraint, you can use the Extract File Attachments option in the Lotus Connector for Notes to save attachments to files on disk. You can then use LotusScript® to read the files, store their contents in LCFields, and save the LCFields to binary fields in a RDBMS. This level of scripting requires LotusScript expertise.

-------------------

5

Morning,

Correct and that is what I am looking to do, saving the files on the server but it is not working when I check that option in the Notes Connection document and use a Direct Transfer activity.

6

Looks like I was missing one step. In the Activity mapping, you have to manually add the word "File" at the end of the Source mapping and manually add the column name (ie. "FileLocation") at the end of the Target mapping.