Appboard/2.4/builder/data sources/file: Difference between revisions
imported>Jason.nicholls |
imported>Jason.nicholls |
||
| Line 20: | Line 20: | ||
| Only applicable to the CSV Directory data adapter and defines the set of files AppBoard will look for in the defined directory, e.g. <tt>*.csv</tt> | | Only applicable to the CSV Directory data adapter and defines the set of files AppBoard will look for in the defined directory, e.g. <tt>*.csv</tt> | ||
|- | |- | ||
| | |''File Path'' | ||
| Only applicable to the CSV File data adapter and defines the specific path and filename of the file to be read. | | Only applicable to the CSV File data adapter and defines the specific path and filename of the file to be read. | ||
|- | |- | ||
| | |''Data Delimiter'' | ||
| | | Defines the field separator which is comma by default, but can be set to semi-colons, spaces, or tabs. | ||
|- | |- | ||
| | |''Contains Header Line'' | ||
| | | Defines whether the file contains a header line, which should be the first row in the file. If no header is present the first row will also be used to define the field names. | ||
|- | |- | ||
| | |''Header Meta Delimiter'' | ||
| | | | ||
|- | |- | ||
| | |''String Boundaries'' | ||
| | | For files that contain strings which could potentially include the data delimiter character the fields need to be further grouped by quotes so the parser doesn't incorrectly split the field. Typically this should be set to ''Delimited by Quotes'' even in the case quotes aren't used as this still behaves as expected. Setting this to ''Not Delimited'' will specifically ignore quotes and split on every data delimiter found. | ||
|} | |} | ||
Revision as of 07:47, 19 September 2013
File based data adapters allow AppBoard to consume data from any files the server process has permissions to read, including network mounted filesystems.
The Shell Command adapter is a special case where AppBoard actually executes the specified command and then captures the response.
CSV File & Directory
Configuration Options:
| Option | Description |
|---|---|
| Directory | Only applicable to the CSV Directory data adapter and defines the path containing the files to be read. |
| File Extension | Only applicable to the CSV Directory data adapter and defines the set of files AppBoard will look for in the defined directory, e.g. *.csv |
| File Path | Only applicable to the CSV File data adapter and defines the specific path and filename of the file to be read. |
| Data Delimiter | Defines the field separator which is comma by default, but can be set to semi-colons, spaces, or tabs. |
| Contains Header Line | Defines whether the file contains a header line, which should be the first row in the file. If no header is present the first row will also be used to define the field names. |
| Header Meta Delimiter | |
| String Boundaries | For files that contain strings which could potentially include the data delimiter character the fields need to be further grouped by quotes so the parser doesn't incorrectly split the field. Typically this should be set to Delimited by Quotes even in the case quotes aren't used as this still behaves as expected. Setting this to Not Delimited will specifically ignore quotes and split on every data delimiter found. |
