The last Column mapping in the above table is to be mapped with an Output data transformation as shown below.

The body of the 'Data Transformation', 'Transform Outlook Calendar Duration' should have the following script:

IF (Duration = 1440) THEN
Location = "1"


Note the field 'Location' is just being used as a dummy field here. Users could make use of any field in place of the Location field as long as it is not needed in the target.
Note: 1440 = 24 hrs * 60 mins.

In general, when working with different data sources, the semantics of the content in one may not match with the other. In such cases, use the Data Transformation object as illustrated above and supply the required transformations.

Connectivity Issues
Lotus Domino:
1.        Ensure the Notes Client on the machine can connect to the Notes Domino Server used in the Content Integrator.
2.        If (1) fails, make sure "Hosts" (\drivers\etc\hosts) file contains a reference to Notes Domino Server
3.        Make sure Notes client directory is in the system path
4.        Make sure that Notes.INI is first in the path is the one intended to.
5.        Ensure that the Notes ID used by the Content Integrator has at least "designer" access on the Notes db source.
1.        Ensure the browser client from the Content Integration machine can access the source SharePoint site in question
2.        Ensure the domain account used for connecting to the SharePoint site indeed has access to the site and the list.
3.        If you are processing attachments (/Document Library) make sure  to use a shared directory accessible from the SharePoint machine and the Content Integrator machine.
4.        Install the SharePoint Plug-in (Refer to the documentation  on this topic)
Lotus Quickr:
1.        Follow the same steps as "Lotus Domino" section
2.        The Notes ID used here should have "Administrator" level access to the Quickr Place.
Domino Document Manager:
1.        Connects either using "Notes" or "Http" protocols.
2.        If using "Notes" protocol, follow the same steps as "Lotus Domino" section
1.        Make sure the Outlook client can connect to the Exchange server
2.        The Profile used should have access to the server/pst/public-folder in question

Creating New System(Job) Catalog and Log
Stop all Content Integrator processes (eg. Composer/Server Manager & Content Integrator Engine).

Content Integrator supports Access & Microsoft SQL Server for the system/job catalog & log. To create a new job catalog/log, do the following :

Microsoft Access
  • Create a empty database from Microsoft access (eg. JOBCATALOG.mdb)
  • Launch the Composer. Goto menu | view | options.
  • Choose the connection type as Access.
  • Browse to the blank database created earlier & choose the database.
  • Click OK & Click OK.

Composer will create the necessary tables for capturing the job definition and log information in the blank database. Close the Composer. Make a physical copy of the JOBCATALOG.mdb and call it JOBLOG.mdb.

Launch the Server Manager. Start the Content Integrator Engine ( Right click on Server | Service | Start )

Right click on server | Click properties .
  • Click System catalog tab. Choose type as Access.
  • Browse to the JOBCATALOG.mdb choose it Click OK & Click OK.
  • Click on the Log tab. Choose type as Access.
  • Browse to the JOBLOG.mdb, choose it Click OK & Click OK.
  • Click OK for the server properties tab.
  • This will prompt asking for a re-start of server. Choose Yes.

SQL Server
  • Create a empty database from Microsoft SQL Server Enterprise manager (eg. JOBCATALOG)
  • Launch the Composer. Goto menu | view | options.
  • Choose the connection type as SQL Server.
  • Enter the schema name as dbo. Database name as JOBCATALOG, specify user name & password.
  • Click OK

Launch the Server Manager. Start the Content Integrator Engine ( Right click on Server | Service | Start )

Right click on server | Click properties .
  • Click System catalog tab. Choose type as SQL Server.
  • Enter the schema name as dbo. Database name as JOBCATALOG, specify user name & password.
  • Click on the Log tab. Choose type as SQL Server.
  • Enter the schema name as dbo. Database name as JOBCATALOG, specify user name & password.
  • Click OK for the server properties tab.
  • This will prompt asking for a re-start of server. Choose Yes.

Information: Composer looks up the file called rasyscat.ini from the Content Integrator program folder to re-create the job catalog schema.

Diagnostic Information, Tools, Programs

External Tools and Dependencies:
1.        Notes Program directory should be in "System Path" on the Content Integrator machine
2.        .Net Framework 2.0 runtime should be installed
In case of a Crash:
1.        Send Notes nsd Log files (\IBM_TECHNICAL_SUPPORT)
2.        Send Snap shot of memory/handles utilization
3.        Send Content Integrator Log file/Log snapshot of the job(s) that were executing when the crash occurs.
4.        System catalog or at the minimum a "Print" of the Job.
Common Culprits:
1.        Locate resource hogs. Launch the Task Manager and monitor the memory, CPU, threads & resource handle counts to locate resource hogging processes.
2.        Check for low disk space on all the server nodes involved in the data integration task
3.        Look for agents/external backup/restore and other house-keeping/administrative jobs that are concurrently running with Content Integrator tasks
4.        Check the space allocation for System catalog and log db of the Content Integrator

Microsoft Exchange or Microsoft Outlook Date value conversion to local time or GMT
SUMMARY:   Exchange/Outlook Date value conversion to local time or GMT
PROBLEM: The Date/Time value is converted toGMT when it is read from/written into Exchange/Outlook. SOLUTION: All the date/time values are read out and written into Exchange/Outlook without any localization. Now you can expect GMT/UTC time values coming form Exchange/Outlook. If an external system inserts a time value into Exchange, you can expect to get back the same time value without any localization from Content Integrator.

However, if you want the Content Integrator to "Localize" the date/time value,  then add the following registry key-value using REGEDT32:

\\Software\CASAHL Technology, Inc.\ecKnowledge\Server

Create a key named "ExchangeOptions"

For the above key, add a value named "TZ_LOCALIZE" of data type REG_DWORD with Hex value of 1.

One you restart "Content Integrator" after making this change, the change will take effect.

Fixing the Exchange Public folder connection error

Error Message: "Microsoft Exchange Server Information Store The client operation failed - Not found."

Problem: When a user tries to save a connection object to a Microsoft Exchange Public folder, the above error message pops up.

Soltuion: This problem occurs when a user tries to save an Exchange/Outlook connection to a public folder. The image below shows that the field "Folder" starts with the string "Public Root\".

You can fix the problem by deleting the text "Public Root\" from the field Folder"; then saving the connection object.

General Job error troubleshooting

Job troubleshooting:
1.        To identify which specific document/record is causing an error, you will have to enable the key logging in the Job definition. Go: Composer, Select the Job, Open Properties, Open Execution Control Tab, Enable "Write Key values of each insert/update/delete to log for auditing". Re-run the job.
2.        Send the System Catalog which contains the job definition.
3.        Increase the Error threshold number in the job definition. (Execution Control--> Error Handling Options --> Max number of non-critical errors)

Get rid of the extra Command window

When making a connection to Lotus QuickPlace or Quickr, an additional cmd window appears which displays MIME conversion and other debug/trace messages. You can avoid this window from popping up by entering the following instruction in the Notes.ini file.


Be sure to have one blank line underneath if this is the last line of notes.ini. The explanation can be found here:

How do I split a Lotus Notes field into two, or combine two fields into one

Splitting/combining fields on the Notes side can be done by creating a data transformation object for the Replication job.

For example, to add (concatenate) two values together (eg FIRSTNAME + LASTNAME so you get FULLNAME) you will need to replicate FIRSTNAME and LASTNAME over to the Quickr Place, then use a data tranformation object to concatenate the fields into a third field (For Example FULLNAME field). The following should be used as an Output data transformation.

On the Data Transformation script page, check the "Native Script" radio button and specify the following Notes formula in the text box provided:

FIELD Fullname:= FirstName + " "+ Lastname

This could be accomplished via VB Script as well.

FullName = Firstname + " "+ Lastname

It is true that the Lotus Quickr Content Integrator doesn't know about fields that aren't mapped on the Replication job -- therefore you will have to create a FULLNAME field for both sides -- so all three FIRSTNAME, LASTNAME, and FULLNAME are in the job mapping.

How to map permission fields

Content Integrator exposes the following fields which capture Quickr permissions.   $Readers & $Authors

$Readers & $Authors accepts user information in the the Notes canonical format. They can also be provided as semi-colon separated values. Setting these fields for documents that are replicated to Quickr will enforce document level security (i.e "Restrict Readers" & "Add Authors" options for Quickr documents).

When users from non-Domino based external systems (like Exchange & Sharpeoint) are to be migrated, a data transformation can be employed to transform the active directory user to a Notes canonical format.

How to migrate DocLinks

Domino Team Rooms to Quickr

Document links are converted to http urls when they are published to Quickr.
  • Document links within the same database on the same form are resolved by Content Integrator when you specify the following options in the Job properties | Column Mapping | Rich Text Tab | Url resolution set to Absolute URL & map UNID from the Team Room form to DocLinkUNID field on the Quickr side.
  • o Having the above settings lets the Content Integrator engine know that it need to resolve document links to urls.
  • o The job must be run at least twice for content integrator engine to resolve the links.
  • Document links which point to external databases are not resolved by the Content Integrator.

How to work with Sub-forms & Computed Sub-forms

Problem: You do not see the fields contained in computed subforms on your Lotus Notes form in Column Mapping screen.

Solution: On both the Content Integrator server and composer computers, you must add a statement in the NOTES.INI file to define the computed subforms used by the main form specified in replication job. Make sure to restart the composer for the changes to take effect. The syntax for this definition is:



formname = the name of the Main form (required)

subform1 = the name of the first subform (required)

subform2 thru subform-n = the names of additional subforms (optional)

Note: Commas are required if there is more than one subform. Brackets are shown here to indicate an optional item; do not include brackets in this statement in NOTES.INI.

For example:



Account is the name of the Main Form, and Checking, Saving, and CD are the names of the subforms used in the Account form.

If the Subform has a space and/or special character in the name, then put the space and/or special character in the Notes.ini as well.

For example:
$RA_Account=$Checking Account"Account" is the main form. "$Checking Account" is the subform.
Make sure to have or add a blank line at the end of your notes.ini!! Notes will ignore the last entry in it's .ini if there is no at the end!

Computed Sub-forms:

Fields from computed sub-forms in some customized team room do not show up during column mapping.

To work around this issue, user would need design access to the customized Domino Team Toom. User can then modify the design of the main form to include the design elements from the computed sub-form by copying the elements from the sub form into the main Form.

NNotes.Dll not found

If you see the error message that says NNOTES.DLL can not be found, the solution is to add the Notes installation directory to the system PATH, as in ...PATH=c:\lotus\notes;

Security requirements for working with Domino stack

1.        When Content Integrator is used for Domino Team Room and Quickr integration:
  • The Notes ID used for connecting to both these data sources should be certified to work with both Domino servers. In some cases this may necessitate cross-certification among the two Domino Servers.
  • The Notes ID should have Designer access to the source Team Room database and target Team room/Place.
  • For jobs involving Domino.Doc, the connectivity should ideally be via http rather than Notes protocol. The minimum access level needed here is "Reader"

Working with Folder Hierarchies

Content Integrator exposes a set of special folder fields which can be mapped, when mapped, these fields create folders on Quickr.

Sub Folder Level 1 , Sub Folder Level 2   & FOLDERPATH fields are virtual fields (they do not physically exist in the place) available for mapping. For ex.

External Data source(Domino/Exhange/Sharepoint) Quickr
Project Sub Folder Level 1 Category Sub Folder Level 2

Assume Project has a value "Project A" and Category has a value " Category 1". A folder hierarchy is created like so

   "Sub Folder Level 1"\Sub Folder Level 2"

   in this case a folder hierarchy of "Project A\Category 1" is created and the document from the external system is published into the sub folder called "Category 1" under "Project A".

When Sub Folder Level fields are used, Content Integrator cannot synchronize the data between the source & target.

In case of Sharepoint document libraries FOLDERPATH can be mapped to FOLDERPATH on Quickr & in the job properties set the option to process documents recursively in the Column mapping | Attachment tab. In this scenario Content Integrator can keep the the source & target synchronized.

Working with RichText and Attachments

Content Integrator works with Rich Text & Attachments in the following manner:
  • Domino Team Rooms to Quickr
  • Notes Rich Text (in Domino team Rooms) is converted to HTML/MIME when the document is published to Quickr.
  • Attachments are detached to a specified staging folder (specified in Job properties | Column Mapping | Rich text tab | Staging folder) before they are published into Quickr.
  • Exchange/Outlook to Quickr
  • Microsoft RTF is converted to HTML/MIME when the document is published to Quickr. Content integrator depends on Microsoft Word object model to convert Rich text to HTML in this scenario. As a result Microsoft Word needs to be installed on the Content Integrator workstation.
  • Attachments are detached to a specified staging folder before they are published to Quickr.
  • Rich Text in fields can also be published to Quickr as files. (map the field called PR_RTF_COMPRESSED from Outlook/Exchange to the field called $RTF_To_Attachment (this is virtual field exposed by Content Integrator, it does not phsically exist) on Quickr.
  • Sharepoint to Quickr
  • Sharepoint stores rich text as XHTML. This is converted to HTML/MIME by Content Integrator before publishing to Quickr.
  • Attachments are detached to a specified folder before publishing to Quickr. In this scenario the staging folder needs to be a Windows Share (see also Content Integrator - Sharepoint plugin requirements).
  • Lotus Document Manager(Domino.Doc) to Quickr
  • Attachments are detached to a specified folder before publishing to Quickr.