TSTool / Command / ReadTableFromXml

• Overview
• Command Editor
• Command Syntax
• Examples
• Troubleshooting
• See Also

---

Overview

The ReadTableFromXML command reads a table from an XML file. An excerpt from an XML file is shown below. Note the WC:WaterAllocation content, which is data that can be read into a table as a “flat” representation.

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="../styles/detail.xsl"?>
<WC:WaDE xmlns:WC="http://www.exchangenetwork.net/schema/WaDE/0.2">
  …
    <WC:Report>
      <WC:ReportIdentifier>2014</WC:ReportIdentifier>
      <WC:ReportingDate>2015-03-01</WC:ReportingDate>
      <WC:ReportingYear>2014</WC:ReportingYear>
      <WC:ReportName>2014 CODWR WaDE REPORT</WC:ReportName>
      <WC:ReportLink/>
      <WC:YearType>IY</WC:YearType>
      <WC:ReportDetails>
        <WC:WaterAllocation>
          <WC:AllocationIdentifier>0109505-53868.00000-0A</WC:AllocationIdentifier>
          <WC:AllocationOwnerName>SWENSON AR WL FLD</WC:AllocationOwnerName>
          <WC:ApplicationDate>1997-06-26</WC:ApplicationDate>
          <WC:PriorityDate>1997-06-26</WC:PriorityDate>
          <WC:LegalStatusCode>ABSOLUTE</WC:LegalStatusCode>
          <WC:DetailLocation>
            <WC:StateCode>CO</WC:StateCode>
            <WC:ReportingUnitIdentifier>1</WC:ReportingUnitIdentifier>
            <WC:WFSReference/>
          </WC:DetailLocation>
          <WC:AllocationAmount>
            <WC:WaterAllocated>
              <WC:BeneficialUse>
                <WC:BeneficialUseContext>CODWR</WC:BeneficialUseContext>
                <WC:BeneficialUseTypeName>IRRMUNCOMINDRECFISFIRDOMSTKAUG
 </WC:BeneficialUseTypeName>
              </WC:BeneficialUse>
              <WC:AllocatedVolume>
                <WC:AmountNumber>32.000</WC:AmountNumber>
                <WC:AmountUnitsCode>AFY</WC:AmountUnitsCode>
              </WC:AllocatedVolume>
              <WC:FreshSalineIndicator>FRESH</WC:FreshSalineIndicator>
              <WC:TimeFrame>
                <WC:TimeFrameStartName>1/1</WC:TimeFrameStartName>
                <WC:TimeFrameEndName>12/31</WC:TimeFrameEndName>
              </WC:TimeFrame>
            </WC:WaterAllocated>
          </WC:AllocationAmount>
        </WC:WaterAllocation>
...

The command requires an element to be specified to indicate rows, for example WC:WaterAllocation. All intervening elements that do not have child nodes will be added as columns. It is assumed that elements with child nodes are grouping elements and should not themselves be added (because they have no text content). The text content for nodes is added for the row’s data values. Currently all values are added as text. In the future an XSD file may be used to determine column types.

Command Editor

The command is available in the following TSTool menu:

• Commands(Table) / Read Table

The following dialog is used to edit the command and illustrates the command syntax.

ReadTableFromXml Command Editor (see also the full-size image)

Command Syntax

The command syntax is as follows:

ReadTableFromXml(Parameter="Value",...)

Command Parameters

Parameter	Description	Default
InputFile required	The name of the file to read, as an absolute path or relative to the command file location.	None – must be specified.
RowElement	The XML file element that brackets a row’s data.	None – must be specified.
Top required	If specified, the top (first) number of rows specified by the parameter will be returned.	Return all data.
TableID required	Identifier to assign to the table that is read, which allows the table data to be used with other commands.	None – must be specified.

Examples

See the automated tests.

Troubleshooting

See the main TSTool Troubleshooting documentation.

See Also

• WriteTableToDelimitedFile command