Specifications

Importing XML

394 InfoMaker

Example

This example uses a report that includes the columns emp_id, emp_fname,

emp_lname, and dept_id. The template used in this example includes only these

columns. Any other columns in the report remain empty when you import

using this template.

To illustrate how template import works, create a new template that has one

element in the header section, called before_detail_marker. This element

contains a column reference to the

emp_id column.

The Detail Start element, employee, has an attribute, dept_id, whose value is a

control reference to the column

dept_id. It also has three children:

• The emp_id element contains a column reference to the

emp_id column.

• The emp_fname element contains static text.

• The name element has two children, emp_fname and emp_lname, that

contain column references to those columns.

The template exports and imports the

dept_id report column using the attribute

of the employee element. It exports and imports the

emp_id, emp_fname, and

emp_lname columns using the column references in the elements. The

following shows the beginning of the XML exported using this template:

<?xml version="1.0" encoding="UTF-16LE"

standalone="no"?>

<employee_list>

<before_detail_marker>102</before_detail_marker>

<emp_id>102</emp_id>

<emp_fname>static text content</emp_fname>

<name>

<emp_fname>Fran</emp_fname>

<emp_lname>Whitney</emp_lname>