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.

Sensor data

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

Fault memory data

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.

Fields

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

Maintenance data