Import Data from File
Import formats of different data sources such as sensor data, fault memory data and maintenance data
It is possible to define an input stream for SysWatch. In the case of a sensor file and in the case of a diagnostic file, the relevant information can be uploaded into SysWatch. The file must be a CSV file with a semicolon as a separator. Alternatively, the parser also checks for tab delimitation.
Two different file formats can be imported, which are automatically differentiated from one another:
Variante 1: [AnlagenCode]_Beliebiger-Text_V1.csv
Timestamp | ParameterCode | Value |
01.01.2018 00:00:00.000 | ParameterCode 1 | 108 |
01.01.2018 00:00:00.000 | ParameterCode 2 | 5 |
01.01.2018 00:01:00.000 | ParameterCode 1 | 102 |
Variante 2: [AnlagenCode]_Beliebiger-Text_V2.csv
Timestamp | ParameterCode 1 | ParameterCode 2 | … |
01.01.2018 00:00:00.000 | 108 | 5 | |
01.01.2018 00:01:00.000 | 102 | 7 | |
01.01.2018 00:02:00.000 | 110 | 8 | |
1. The minimum information for analyzes with diagnostic data can be found under "Essential fields".
2. "Descriptive fields" can be set automatically during the parsing process or afterwards by the user (IMPORTANT: The event code must be unique).
3. The "environment data" and "operating counter" are also used here as additional status descriptions, but are not automatically included in the structure by default.
DateStart Datum Kommt
DateEnd Datum Geht
EventID Eindeutiger Ereignis-Code
EventText Definitionsbeschreibung des Ereigniscodes
SystemID System-Code
SubSystemID SubSystem-Code
ComponentID Component-Code
SubComponent ID SubComponent-Code
DiagnosisType Diagnose Typ (Protocol, Warning, Error)
Prio Priorität (Zusätzlicher Integer)
DuringOperation Markierung, ob die Aufzeichnung im Betrieb statt fand (true/false)
Sensor-Snapshots
GPS-Koordinaten
Beispiel:
DateStart | DateEnd | EventID | SystemID | DiagnosisType | … |
01.01.2018 00:00:00 | 01.01.2018 00:01:00 | 71F0 | ZSG1 | Protocol | |
01.01.2018 00:00:00 | 01.01.2018 00:01:00 | 719A | Energieanlage | Warning | |