Share via


Multi-Tiered Data Record Formats

More complex forms of the ListSheet HTC make use of two- and three-tiered XML structures for their data. Essentially, these alternate structures allow nested record elements to two and three levels, respectively. Both of these alternate structures are shown below.

The following table shows how the ListSheet HTC makes use of the two- and three-tiered XML structures for the various types of ListSheet HTCs. Since there are two types of column elements in the metadata for the ListSheet HTC (child elements of the columns and subobject elements, respectively), the following table qualifies instances of the column element with the appropriate parent element in parentheses.

Types of ListSheet HTC Data Mapping
Flat List Uses the one-tiered XML structure for data, as described above.
Two-level Homogeneous Grouped List The dataid element names contained in the second-level record elements in the XML data should correspond to the value of the id2 attribute for the column (columns) elements in the XML metadata.

There should not be a third level in the data XML structure, and the id3 attribute of the metadata column (columns) element is not used.

In this case the metadata subobject element should not be used.

Three-level Homogeneous Grouped List The dataid element names contained in the second-level and third-level record elements in the XML data should correspond to the values of the id2 and id3 attributes for the column (columns) elements, respectively, in the XML metadata.

In this case the metadata subobject element should not be used.

List-style Heterogeneous Grouped List

and

Properties-style Heterogeneous Grouped List

The dataid element names contained in the second-level record elements in the XML data should correspond to the value of the id attribute for the column (subobject) elements in the XML metadata.

There should not be a third level in the data XML structure, and the id2 and id3 attribute of the column (columns) element is not used.

Copyright © 2005 Microsoft Corporation.
All rights reserved.