ARInput step
The following image shows the ARInput step in the Spoon client:
General tab
The General tab contains three fields:
- Connection—Click the New button to create a new AR System server connection. Click the Edit button to modify an existing connection. You can select an existing connection from the dropdown menu.
- Form Name—Name of the AR System form from which data is extracted.
- Chunk Size—Number of records to be fetched from the AR System server at one time. This number may be specified as a variable. If a variable is specified, the ARInput step will use the variable value at runtime.
Qualification tab
The Qualification tab allows you to provide a qualification string to extract data from an AR System form. If a qualification string is not provided, all data is extracted from the form using a 1=1 qualification. If variables are used in the qualification string, the ARInput step will use the variable values at runtime.
Click the Configure Qualification button to open and configure the qualification.
Qualification tab in the ARInput step
Fields tab
The Fields tab allows you to specify a list of fields to be extracted from an AR System form. The Get Fields button allows you to add all fields from a form to the list.
Fields tab in the ARInput step
Supported data types
Atrium Integrator supports the data types listed in the following table.
Data type | Description |
|---|---|
None | No type |
Number | Java's Double object |
String | Java's String object |
Date | Java's date object |
Boolean | Java's Boolean value |
Integer | Java's Long object |
Bignumber | Java's BigDecimal object |
Serializable | Any Java's object |
Binary | Blob or clob data |
The following table lists the ARInput step data type conversions.
ARInput data type conversions
Complex AR System data types such as Attachment, Currency, and Status History are handled in the same way the AR System Import tool and ODBC driver handle data types. For example, the Currency field is split into its separate parts, such as Date, Type and Value, and each is identified separately in the field list. See Importing-data-into-forms-by-using-Data-Import for more data import information.