Loading Action Scripts From Flat Files

Action Scripts read rows from the specified flat file. Each flat file row defines an action to be performed in Data Relationship Management. Each row is read and the appropriate actions are performed sequentially. A status message is returned for each row. Details are displayed in the Return Value column.

To load an Action Script from a flat file:

1. On the Home page, select Script.

2. From Source Type select File.

3. Click Browse and select the flat file to use for the Action Script.

4. Select from these options:

   • Column Order––Use the arrows to customize the order of the six required columns from the flat file.

   • Character Encoding––Select one of the encoding options.

   • Delimiter––Select the column delimiter that is used in the flat file.

   • Strip Quoted Strings––Select to remove quotation marks.

   • Property References By Label––Select to use property labels instead of names.

     Caution:

     If you reference a property that does not have a unique label, the system will require additional information in order to select the appropriate property when the script is being loaded.

   • Defaults––Click to reset all options to the default settings.

5. Click Load.

6. When the load completes, review the script actions and parameter values. You can:

   • Click to modify a row.

   • Select Script, then Substitute Versions to change a version. Select the version to be replaced and the version to replace it with and click OK.

   • Click a column header to sort rows alphabetically.

     Note:

     The script is still processed in the order in which it was loaded. This order is indicated by the Order column.

   • Click to filter one or more columns.

   • Click to switch between displaying properties by label or by name.

7. Select the check box in the Process column next to each row to be run.

   Note:

   From the Script menu, use Select All to process all actions. You can select a subset of actions from a script and only process those actions.

8. Click to run the Action Script.

   The results of each script action are displayed in the Status and Result Value columns . The script and the results can be saved to a file using the Download option on the Script menu. See Downloading Action Script Results.

Downloading Action Script Results

You can download the action script results to the following file types:

• Action Script File (TSV)

• Comma-separated file (CSV)

• Tab-separated file (TSV)

• Portable Document Format (PDF)

• Rich Text Document (RTF)

• Spreadsheet (XLS)

Action script results can be filtered before downloading. For example, you can filter the Status field using "Failure" to show only lines that failed to load.

To download action script results:

1. From Script, select Download, then select a file type.

2. Click Save.

3. Browse to the directory where you want to download the document, enter a name for the document, and click Save.