|
| ColumnNames | | A list of column names, separated by commas. For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| ColumnNamesInFirstRow | | Set to "true" if the first row of data contains the names of the data columns.
Valid descriptions in the first row will override default column names. |
| CsvDelimiter | | The symbol used to separate items in a line of a CSV file.
Supports any character or the following special escape sequences:
\t = Tab
\v = Vertical tab
\r = Carriage return
\n = Line feed
The default is a comma. |
| CsvFile | | (Required) The location of the CSV file. This may be a local path, such as:
D:\Data\records.csv
It may also be the full URL to a CSV file on the Internet, such as:
http://www.example.com/data/records.csv |
| DateColumns | | A comma-delimited list of columns that should be displayed as dates.
Column names should match those used in the datalayer: either the default names (Column1, Column2), or names defined in a row of the source data, or custom names defined in the Column Names attribute. |
| ID | | The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| MaxRows | | The maximum number of rows to retrieve from the data source. |
| TextQualifier | | If given, then values having this symbol at the beginning and end are treated as text:
1) the text qualifier symbol is removed from the beginning and end
2) if the text qualifier symbol is doubled within the value, it is replaced with a single text qualifier symbol
example using single quote as text qualifier:
144, 12/18/2004, 'Lee''s House of Kebab', '719 High Street'
144 12/18/2004 Lee's House of Kebab 719 High Street
The default is a quote mark ("). |