Import format for historic data (MDA Server 1.2+)
Intruduction
MDA Server version 1.2 introduces a feature to import historic measurement data.
Data must be provided as Excel files which conform to one of the formats specified below.
We recommend to use Excel formulas or macros to create xls-files that are dedicated for import in MDA and are stored separatly from the original historic data. Avoid using linkage to other files, which might be refreshed by mistake. The file name should be self-explanatory and unique within the MDA import files of an organisation, i.e. Department_YYYY.xls.
Import Formats
Basics
Only the first sheet of an .xls (or .xlsx) file is imported.
For the actual import, it is possible to specify a number of head rows that are ignored, allowing to keep internal meta information in the file.
Imported measurement data are associated with the name of the import file (like a one-time measurement tour) and can be updated as a whole later on. This is why it is important to keep the import files!
All "field name" must comply with the field names of measurement profiles!
Empty data cells are ignored. But, a value of "0" is interpreted as actual measurement value, after all there are measurements where 0 is a possible real world value (i.e. air temperature, deviations, ...).
Import Format 1: List, 1 value per row
Column | Content | Remarks |
|---|---|---|
A | ID of measurement point |
|
B | Timestamp | Date, or date and time. Excel must understand it as timestamp. |
C, D | 1st field name, 2nd measurement value | The field name must match the measurement profile (=Column in data search and exports) |
E, F | 1st field name, 2nd measurement value | |
... | ... | ... |
Import Format 2: Matrix, Multipl timestamps in row 1, multiple values per row
Zeile | Spalte | Inhalt | Anmerkungen |
|---|---|---|---|
1 | A, B | empty | gets ignored |
1 | C | 1st timestamp | Each timestamp (date or date and time) applies to all measurement value in this column |
1 | D | 2nd timestamp | |
1 | ... | further timestamps | |
2 ... | A | ID of measurement point |
|
2 ... | B | Feldnamen | Der Feldnamen muss dem Feldnamen im Messprofil entsprechen |
2 ... | C | Measurement value 1 | Measurement value with timestamp 1 |
2 ... | D | Measurement value 2 | Measurement value with timestamp 2 |
2 ... | ... | Further measurement values | Measurement value with timestamp ac. row 1 of this column |
Import parameters
For the actual import, some meta information must be specified:
Format 1 or Format 2
Number of header rows to ignore
Time zone of time stamps
© 2013 ITEG IT-Engineers GmbH, Innsbruck, Austria