Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For import of CSV format, some configuration is required, as a Table Layout needs to be defined to control which columns of the CSV file contain location ID, parameter ID and date / time information. The table layouts to use are to be configured in the explorer.xml config file, as in the following example:

Code Block
</interactiveExportFormats>
<temporaryImportFormats>
	<temporaryImportFormat>
        <name>General CSV</name>
        <table>
            <dateTimeColumn pattern="dd-MM-yy HH:mm"/>
            <locationColumn name="Location"/>
            <parameterColumn name="Parameter"/>
            <valueColumn name="Value"/>
        </table>
	</temporaryImportFormat>
</temporaryImportFormats>
<explorerTasks>

For the CSV import the General Csv parser is used, so it may be possible to copy the table definition from an existing CSV import configuration. Multiple table definitions can be configured, each with a given name, then the user will be prompted to select a table definition to use for the import.

...