Read View

Operation Name

Read View

Function overview

Read the data of view.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Required settings
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.
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be managed from "Edit Resource list".
  
View name Required Available Select or enter a view name.
  • If a script variable is specified, [Column definition] is left unconfigured.
Column definition Required - Display the column definition of the view specified in [View name].  
Column definition / Column name Required Available Enter [Column name]
By default, the column name is set to the specified view.		  
Column definition / Type Required Not available Select the type of the column.
By default, the column type is set to the specified view.
  • [string]
  • [datetime]
  • [double]
Column definition / Field Required Not available Specify field name.
  • Can not be edited.
Delimiter Optional Available Enter the delimiter of multiple values.
  • Delimiters of multiple values can be specified freely.
  • The default value is ",", "," is set if omitted.
  • Multiple values can only be retrieved when the type of the field is "text".
Destination to save attachment Required Available Select or enter a directory to save HTML files in rich text and attachments.

Click [Browse] button to activate the file Selectr and Select the directory.
  • The default value is "/tmp".
  • Please specify the absolute path of the DataSpider file system as the file path.
  • Constrained Characters of DataSpider File System cannnot be used, except for the path separator "/"..
  • If a directory which does not exist is specified, an error will occur every time you run the program.
Save each rich text document in a directory Required Available Select whether you save HTML files and attachments in the directory of the same name as a universal ID or not.
  • [Checked]:
    Create a directory of the same name as a universal ID under the directory specified in [Destination to save attachment].
  • [Not Checked]: (default)
    Save under the directory specified in [Destination to save attachment].
  • If it is not checked, of the attachments sharing the same name only one of them will be retrieved.
Key settings
Item name Required/Optional Use of Variables Description Remarks
Key Optional - Specify the key.
Reads data matching the specified key.

Each column can be operated with the following buttons.
  • [Add]:
    Add a column.
  • [Up]:
    Move the order of the selected column upwards by one.
  • [Down]:
    Move the order of the selected column downwards by one.
  • [Delete]:
    Delete the column.
  • For the details about specifying the key, please refer to "for key settings" .
Key / Key name Required Available Enter the [Field name].  
Key / Key value Optional Available Enter the field value.  
Data processing method
Item name Required/Optional Use of Variables Description Remarks
Mass data processing Required Not available Select a data processing method.
  • [Use script settings]: (default)
    Apply mass data processing settings of script property to adapter.
  • [Disable]:
    Mass data processing is not performed.
  • [Enable]:
    Mass data processing is performed.
  
Comment
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.		  

Schema

Input Schema

None.

Output Schema

<?xml version="1.0" encoding="UTF-8" ?>
&lt;table&gt;
  &lt;row&gt;
    <column>UniversalID</column>
    <column>NoteID</column>
    <column>field data</column>
    :
  &lt;/row&gt;
  &lt;row&gt;
    :
  &lt;/row&gt;
</table>

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name Description Remarks
count Returns the number of read data.
  • The value defaults to null.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

For key settings

If you specify [Key], Specify [Column name] at [Key / Key name] and specify value of the field at [Key / Key value].

Operation of Type Conversion

Operations of type conversion when specifying [Type] in [Column definition] are as follows.

[Type] Operation Remarks
[string]
  • Regardless of the type of the field, converts all type String to read.
  
[datetime]
  • The field type "number" if, based on the value read is converted to type Date.
  • Cannot read if field type is "text" and cannot be converted to Double type.
  • Example: If the data read from the field is "1", it is converted to "1970-01-01T09:00:00.001+0900"(If the timezone of the OS is Japanese standard time".
[double]
  • The field type "Date/time", the data is holding the long value read is converted to type Double.
  • Cannot read if field type is "text" and cannot be converted to Double type.
  • Example: If the data read from the field is "1", it is converted to "1970-01-01T09:00:00.001+0900"(If the timezone of the OS is Japanese standard time".

Specification Limits

Main exceptions

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].
LotusNotesException
[STATUS:1028] found the index entry
- The specified view, "" is not found.		 [View name] is not specified. Specify the [View name].
LotusNotesException
[STATUS:1028] found the index entry
- View specified "<view name>" not found.		 View specified in [View name] does not exist. Please specify a existing view in [View name].