Steve Sherwood 21.Aug.16 11:37 PM a Web browser Connector for Text LEI - 8.0 Windows
We need to export Sametime Log data from Domino 8.5.3 to MS SQL Server version 2012 using LEI 8.5.3. Each document has a rich text field which contains formatted text and often inline images.
It is essential that the format is retained and images remain in their original position. I have used a third party product to export the Notes rich text data to html,
then replaced the <img src> in the html ouptut with the file contents encoded as a Base64 string.
LEI Connections are defined for Text and OLE DB. The LEI Direct Transfer Activity works fine for documents containing no or very small images, but with large images
(which can be several hundred Kb in size) an error is reported:
22/08/2016 08:46:24 AM WARNING: Unable to set ChatStart for [Input Record 78], field exceeds record length (32766), Connector 'Sametime Text', Method -Fetch-
This error occurs for every column in every document After the one with the large image(s), suggesting that the very long Base64 string has been 'wrapped' to a new line within the Activity.
The source data is in the format below, using "^" as the field separator, with the Body html exported as the last column. The Base64-encoded string can run for pages if the image is large...
There are Definitely no line feeds/carriage returns in the source data, although I've added some below so that it doesn't all disappear off the right of the screen.
The Field Specifications in the Text Connection document are defined as follows:
ChatId: TYPE TEXT UNTIL "^"
ChatStart: TYPE DATETIME FORMAT "DD/MM/YYYY hh:mm:ss" UNTIL "^"
ChatEnd: TYPE DATETIME FORMAT "DD/MM/YYYY hh:mm:ss" UNTIL "^"
ListParticipants: TYPE TEXT UNTIL "^"
PartyCount: TYPE NUMBER UNTIL "^"
MessageCount: TYPE NUMBER UNTIL "^"
WordCount: TYPE NUMBER UNTIL "^"
BodyHTMLString: TYPE TEXT UNTIL "^"
The corresponding columns in the SQL Server table are:
ChatId: nvarchar(128), not null
ChatStart: datetime, not null
ChatEnd: datetime, not null
ListParticipants: nvarchar(max), null
PartyCount: int, not null
MessageCount: int, not null
WordCount: int, not null
BodyHTMLString: nvarchar(max), null
Questions to the forum are:
1. Can the BodyHTMLString value be defined as something other than Text in the source data in order to overcome what seems to be a character limit?
2. Is nvarchar(max) a data type that LEI recognises? In the Lotus Connectors and Connectivity Guide, it mentions NVARCHAR Text (variable length, bound <= 8000) as a SQL Server data type. What does the 8000 refer to?
3. How has anybody else exported attachments to SQL Server using LEI? Maybe there is a better way of storing the attachments?