Extract rules
Completing the Definition tab

You can specify properties to extract from any class of an application. You can extract values for properties of many modes, including Single Value, Value List, Value Group; and multiple levels of embedded Pages, Page Lists, and Page Groups. BIX cannot export properties of the Java Object or Java Property modes.

BIX can extract values to an XML file or a Commas Separated Values (CSV) file, or directly into a relational database.

The outputted data includes a timestamp and a batch identifier. These help when you want to compares information from different extracts, or isolate information from a specific extract.

Output Format

Select an output format

• XML — The XML output format supports two levels of extraction:
  • You can extract all properties of a specified class into XML documents. Enable this mode by checking the Get All Properties check box when the XML output type is selected.
  • You can specify a group of properties to extract by clearing the Get All Properties check box. In the tree list of properties that appears, select the properties to extract.
• Comma Separated Values (CSV) — The CSV output format lets you export instances of classes as comma-separated values in a text file. A CSV export typically produces multiple CSV files depending on the complexity of properties selected. For this format you must explicitly select from the tree display the set of properties to export.
• Database Schema — Select this format to export data from the PegaRULES database directly into another relational database, identified to the PRPC system by a Database Name data instance (Data-Admin-DB-Name class). Identify this database on the File Specification tab. The table name you specify must comply with the naming conventions of the target database, and should include no spaces.

Working with the property tree

The extract rule separates available properties into nodes that can expand and collapse. The root node is the Applies To class of the extract rule.

If your output format is XML and you want to extract all the properties in the class, check the Get All Properties check box. Otherwise, click a node to display a gear icon to the right of the node name. Click the gear icon to display the Select Properties form, and select the properties you want to extract.

To filter the properties list, enter a text string in the “Property Name Contains:” field and click Filter. To show all properties again, clear the field and click Filter again.

If you are exporting to CSV, click on any property to display a gear icon and a trash-can icon to its right. Click the gear icon to display a Property Configurations form where you can map the property to a name in the CSV file.

If you are exporting for import into a database, click on any property to display a gear icon and a trash-can icon to its right. Click the gear icon to display a Property Configurations form where you can set the attributes for the property: map to a name in the database schema, provide the data type and the field length. The name needs to comply with the naming conventions of the target database, and should include no spaces.

Use the trash-can icon to remove the node it appears next to.

About Extract rules