Create a Business Object (XML) File

Use this task to create a Business Object (XML) file. The Business Object (XML) Tab displays when you choose Business Objects (XML) for the format of the converted file.

To create a Business Objects (XML) file:
  1. Click the Business Object (XML) tab of the Convert Request Editor.
  2. Click the down arrow to select the desired Start Table.
  3. Right-click a table and select Add Joined Table to display the Select Join Table dialog, which allows you to join one or more tables to the Start Table (or any additional table, once joined).
  4. On the Select Join Table dialog, select the desired tables and then click OK.
  5. If more than one relationship between the two tables exists, the Select a Join Relationship dialog is displayed. Select the desired relationship and click OK.
  6. Right-click a table name and select Modify Column List to select the columns to be included in the file.
  7. Click the Run button to run the Convert Request and create the Business Object (XML) File.
Select the table in the Source File (Extract or Archive File) to use as the basis for converting data. Click the down arrow to select a table name from those in the Source File. Once you have selected the Start Table, it is shown as the first entry in Joined Tables.

Lists the tables in the Source File to be included in the Business Object (XML) file. To add additional tables, right-click the name of a table in the list and select Add Joined Table, which opens the Select Join Table dialog, allowing you to join related tables to the list.

After you select the tables to be included in the Business Object (XML) file, you must specify the columns in the selected tables to be included in the file. Right-click the name of a joined table and select Modify Column List to open the Column and Order Specification dialog. For more information, see Column and Order Specification Dialog - Business Object (CSV) File.

To expand a table in the list, click the Plus icon . The expanded list shows the parent and child tables. To condense the list of tables, click the Minus icon. Expanding or condensing the table list does not affect whether a table is included in the Business Object (XML) file.

To remove an existing table, right-click the table name and select Remove Joined Table.