ARInput step
The ARInput step allows data to be extracted from a BMC Remedy AR System form. It also:
- Uses its connection input parameters to create an AR System server connection. The connection is created once and reused as needed.
- Substitutes chunk size and qualifications with real values, if variables are used.
- Uses the GetListEntryWithFields (GLEWF) call on the form by providing the field IDs of the user-selected fields and fetches data with the user-provided chunk size.
- Converts each entry to an Atrium Integrator row format and sends it to the next step. Supported conversions are from standard AR System data types to data types supported by Atrium Integrator. Data types are listed below.
ARInput step in the Spoon client
General tab
The General tab contains three fields:
Connection — Click the New button to create a new BMC Remedy 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 BMC Remedy 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 following data types:
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 ARInput step data type conversions include:
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-BMC-Remedy-AR-System-forms for more data import information.