# Import Data from File

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