Import Source Schema definition - Front End

[Patowhiz]

Below is a sketch of the component with anticipated controls for creating an import data source schema that will be used to interpret tabular files when users import them.

A tabular import data source has the following characteristics:

1. May include a station column.
2. May include an element column. The element column could be one or multiple. If it's a single column then it's position is expected and may also define the elements to pick. If it's multiple elements columns, then it is expected you specify the column position for each element and the equivalent element id.
3. May include a period column. If it includes a period column, then specify the column position. If it does not include a period column then specify the default period.
4. May include an elevation column.
5. Must include a value column.
6. May include a flag column.
7. User should define UTC time difference. Default is 0.
8. User should specify whether values are scaled.
9. User should specify the first rows to be skipped - text box.
10. Users should specify the delimiters - drop down with delimiters.
11. Users should specify the datetime column(s) and the format when applicable.
12. May include a hour column depending on the period and date time specification.

This link contains multiple sheets with sample formats.

Item 9 to 11 are not yet in the sketch.