Configuring the CSV adapter

Adapter type: bmc-ao-adapter-csv-actor_<version>

Default adapter name: CSVAdapter

The Properties field in the adapter configuration of Grid Manager is a required field. If the default values are acceptable for all elements, you can enter a configuration node, <config/>, in the Properties field. When you set a configuration node, the adapter uses the default values for all the elements.

BMC recommends that you do not include unused elements in the adapter configuration because they might cause the adapter to enter a fault state.

To configure the CSV actor adapter

  1. Log on to the BMC Atrium Orchestrator Grid Manager.
  2. Access the adapters page, by clicking the Manage tab; then click the Adapters tab.
  3. In the Adapters in Repository list, select the check box corresponding for the type of adapter to be added.
    The adapter type use the following naming convention: ro-adapter- adapter type. For example, the adapter type for the IMAP adapter would be ro-adapter-imap.
  4. Click Add to Grid to include the adapter in the Adapters on Grid list.
  5.   Click Configure corresponding to the newly added adapter.
  6. On the Add an Adapter Configuration page, perform the following substeps to configure the adapter using the form view or jump to step 7 to configure the adapter using the XML view:
    1.   Enter a name for the adapter.
    2.   Enter a description for the adapter.
    3. Under Properties, enter or select values for the configuration elements. 

      The configuration elements for each adapter are described in that adapter's section. Include all required elements indicated with an asterisk (*).
    4. (Optional) Click Switch to XML View and use the following steps to specify elements and attributes that are not in the form view.

      Note

      Switching to the XML view to specify those elements and attributes not included in the form means that you cannot thereafter use the form for modifying that configuration. This step is not required for base adapters that can be fully configured using the form.

  7. On the Warning message that appears, click Switch View.
  8. In the Properties text box, use XML format to enter the configuration elements and attributes not available as fields in the form view.
  9. Click OK.
  10.   ( optional ) Configure the adapter in the XML view using the following substeps:
    1. Enter a name and a description for the adapter.
    2. Click Switch to XML View.
    3. On the Warning message that appears, click Switch View.
    4. Copy the configuration elements and attributes from the appropriate adapter configuration section into the Properties text box, and then click OK.

      If the default value for an optional element is acceptable, omit the element. Do not include empty elements.

    5. On the Warning message that appears, click Save

      This saves the adapter configuration with settings in the XML view permanently. The newly configured adapter is now listed in the Adapters on Grid list. 

The following table describes the elements of an actor adapter configuration that you can specify using the form view, XML view, or both. You cannot use the form view to configure elements and attributes that do not have an entry in the "UI label" column. To configure such elements and attributes, you have to switch to XML view.

Node elements for configuring the actor adapter

UI LabelElementDescriptionRequired
Delimiter<delimiter>

Specifies a character that is used to indicate the end of one field and the beginning of the next

Default value: (,)

No
Text Qualifier<text-qualifier>

Specifies a character that differentiates field data from a delimiter

Each field's data is between the text qualifier. For example, the field data contains a comma and a comma is used as a record delimiter, then text qualifier must be used to distinguish between the comma’s in the data and the comma’s used to delimit fields.

Default value: (")

No
Read Headers<read-headers>

Specifies whether to read the first row in the data as column headers

Valid values: true, false (default)

No
Maximum Rows<maximum-rows>

Specifies the maximum number of rows to be read from the CSV file

Zero indicates that all rows in the file will be read.

Default value: 0

No
Charset<charset>Specifies the supporting CharSet 

CharSet is also called Character set that includes identifiers describing a series of universal characters.
No

The following figure describes a sample XML configuration for the CSV adapter.

Sample XML configuration for the CSV adapter

<config>
  <delimiter>,</delimiter>
  <text-qualifier>"</text-qualifier>
  <read-headers>false</read-headers>
  <maximum-rows>0</maximum-rows>
</config>


This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments