CSVTable tag

The <CSVTable> tag specifies the details of a temporary table to be created based on a CSV file supplied by an external system, such as CHAMP.

Attributes

Attribute

Description

name

The name to be used for the temporary table (must be prefixed with a ‘#’ character) that will contain the data from this CSV file.

filename

Optional.  The hard coded name and path for the CSV file to load.  If Filename is specified, there is no need to include a <CSVFile> tag.  If Filename is not specified, there must be a <CSVFile> tag to supply the file location.

Parent Tags

<CSVTables>

Child Tags

Child Tag

Description

<CSVFile>

One <CSVFile> tag is required to specify the name of the CSV file if it has not been hard-coded in the Filename attribute.

<CSVColumn>

One <CSVColumn> tag is required for each column to be read from the CSV file.

Text

None

Relate Topics:
  CSVColumn
  CSVFile
  externalfilterfiles
  externalfilterfile
  SQL
  Where
Created by Atop CHM to web converter,© 2009 all right reserved.