Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name on the script canvas. | |
Input data | Required | Not available | Select the component on the script canvas. |
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Destination | Required | Not available | Select Global Resources.
Refer to "Global Resource Properties" for global resource settings .
|
|
Form name | Required | Available | Select or enter a form name. |
|
Field definition | Required | - | Display the field definition of the form which is specified in [Form name]. | |
Field definition / Field name | Required | Available | Enter the field name of form.
By default, the field name in the specified form is set. |
|
Field definition / Type name | Required | Not available | Select the type of the field.
By default, the field type in the specified form is set.
|
|
Update mode | Required | Not available | Select how to update data.
|
|
Validity verification | Optional | Not available | Select whether to use an expression computed field formula and field design.
|
|
Delimiter | Optional | Available | Enter the delimiter of multiple values. |
|
Use update key | Required | Not available | Select whether [Key] is used as an update key when specifying [Insert/Update] or [Delete] in [Update method].
|
|
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Update with null when null value is input | Optional | Not available | Select the data input is null if the operation contains the value.
|
|
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Key | Optional | - | Specify the key.
If the field data specified as a key matches to data within the document, update or delete the document. Each column can be operated with the following buttons.
|
|
Key / Key name | Required | Available | Enter the name of the field. |
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Comment | Optional | Not available | You can write a short description of this adapter. The description will be reflected in the specifications. |
<?xml version="1.0" encoding="UTF-8" ?> <table> <row> <column>UniversalID</column> <column>NoteID</column> <column>field data</column> : </row> <row> : </row> </table>
Component variable name | Description | Remarks |
---|---|---|
count | Returns the total number of documents written data. |
|
insert_count | Returns the number of documents inserted. |
|
update_count | Returns the number of documents updated. |
|
delete_count | Returns the number of documents updated. |
|
message_category | Stroes the category to which corresponding message code belongs to, when an error occurs. |
|
message_code | Stores its corresponding message code of occured error. |
|
message_level | Stores the severity of the corresponding message code of the occured error. |
|
error_type | Stores the type of the occured error. |
|
error_message | Stores the error message for the occured error. |
|
error_trace | Stores stack trace of the occurred error. |
|
[Type} | Operation | Remarks |
---|---|---|
[string] | Writes the input data is converted to type String. |
|
[datetime] | Writes the input data is converted to type Date. |
|
[double] | Writes the input data is converted to type Double. |
|
Input data | [Insert/Update] Action | [Delete] Action |
---|---|---|
"Universal ID" exists | Searches using "Universal ID" as key, updates the matching Notes documents. Error occurs if no match exists."Note ID" or key value specified in [Key] is ignored. | Searches using "Universal ID" as key, deletes the matching Notes documents. Error occurs if no match exists."Note ID" or key value specified in [Key] is ignored. |
"Universal ID" does not exist, "Note ID" exists | Searches using "Note ID" as key, updates the matching Notes documents. Error occurs if no match exists. Key value specified in [Key] is ignored. | Searches using "Note ID" as key, deletes the matching Notes documents. Error occurs if no match exists. Key value specified in [Key] is ignored. |
Neither "Universal ID" nor "Note ID" exist | Searches using field specified in [Key] as key, updates the matching Notes documents. Inserts input data if no match exists.Error occurs if an non-exist key is specified. | Searches using field specified in [Key] as key, deletes the matching Notes documents. Do not delete when no match existsError occurs if an non-exist key is specified. |
Neither "Universal ID" nor "Note ID" exist, and [Key] is not set | Searches using "field data" as key, deletes the matching Notes documents. Inserts input data if no match exists.
"Data field" that contains a null case, it is considered illegal as a key in an error. |
Searches using "field data" as key, deletes the matching Notes documents. Do not delete when no match exists.
"Data field" that contains a null case, it is considered illegal as a key in an error. |
Input data | [Insert/Update] Action | [Delete] Action |
---|---|---|
"Universal ID" exists | Searches using "Universal ID" as key, updates the matching Notes documents. Error occurs if no match exists. "Note ID" will be ignored. | Searches using "Universal ID" as key, deletes the matching Notes documents. Error occurs if no match exists. "Note ID" will be ignored. |
"Universal ID" does not exist | Searches using "Note ID" as key, updates the matching Notes documents. Error occurs if no match exists. | Searches using "Note ID" as key, deletes the matching Notes documents. Error occurs if no match exists. |
Neither "Universal ID" nor "Note ID" exist | Searches using "field data" as key, deletes the matching Notes documents. Inserts input data if no match exists.
"Data field" that contains a null case, it is considered illegal as a key in an error. |
Searches using "field data" as key, deletes the matching Notes documents. Do not delete when no match exists.
"Data field" that contains a null case, it is considered illegal as a key in an error. |
[Update mode] | Operation | Results when input data is null | Results when input data is empty character |
---|---|---|---|
[Insert] | Insert | Insert null | Insert null |
[Insert/Update] | Insert | Insert null | Insert null |
Update | Depends on the settings of the [Update with null when null value is input] | None |
Field value before updating the document |
---|
123,abc |
Field values of the updated document |
---|
abc,aiu,123 |
Key | Location | Description | Remarks | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
notes.compat.220 | $DATASPIDER_HOME/server/plugin/data_processing/share/classes/
lotusnotescommon.properties |
|
|
Exception name | Cause | Solution |
---|---|---|
ResourceNotFoundException Resource definition could not be found.Name: [] |
[Destination] is not specified. | Specify [Destination]. |
ResourceNotFoundException Resource definition could not be found.Name: [<name of Global Resources>] |
Resource definition specified in [Destination] does not exist. | Check the global resource specified in [Destination] |
InputDataNotFoundException | [Input data] is not specified. | Specify [Input data] or draw a data flow. |
InvalidPropertyConfigurationException [<Property name>] is not specified. |
[<Property name>] is not specified. | Specify the [<Property name>]. |
LotusNotesException The UniversalID "(<Universal ID>)" is invalid. |
No document matching the "Universal ID" in the input data during operation [Insert/Update] or [Delete]. | Please check input data. |
LotusNotesException no document in the database file "<Note ID>". |
No document matching the "Notes ID" in the input data during operation [Insert/Update] or [Delete]. | Please check input data. |
LotusNotesException The column "<key name>" in input data is not found. |
[Insert/Update] or [Delete] during processing, [Key name] field does not exist in the specified. | Please confirm [Key name]. |
LotusNotesException Cannot use the empty column "<field name>" as update key. |
[Insert/Update] or [Delete] during processing, has been used as a key <field name> contains data from the null. | Please check input data. |