Evacuate archives

Do not evacuate

The old archive files are deleted.

Attention

If the value 0 is entered in the property Keep archives, no archive is evacuated. The only existing archive is the current one.

dBase IV
If the number of the archives, that want to be evacuated is reached, the oldest archives are stored in a dBase IV-format (DBF).

ASCII
If the number of the archives, that want to be evacuated is reached, the oldest archives are stored in an ASCII-format (DBF).
The storing is done in CSV-format.
In Unicode: - active: The evacuated .txt-files are created in unicode-format.

SQL Datenbank
If the number of the archives, that want to be evacuated is reached, the oldest archives are stored in the SQL-Server.
The evacuation into an SQL-data base has the advantage that the archive files can be used in trends and reports in zenon.
In order to save the data of an archive in an SQL database select the ring buffer setting SQL database in the dialog Save and select the desired OLE-DB datasource.

Info

See the Microsoft documentation for more detailed information.

SQL databaseOn the contrary to dBase, ASCII or XML archives evacuated into a SQL database are automatically reloaded when necessary (e.g. for ETM).
The button "..." opens the Microsoft Dialog for selecting the OLE DB Provider and the definition of the connection.

Format of the data table <Project name>_<shortcut>

Column	Type	Meaning
VARIABLE	int[4]	numerical variable ID
CALCULATION	int[4]	Type of data reduction in following archives: 1'..sum 2'..average 3'..minimum 4'..maximum
TIMESTAMP_S	int[4]	Time stamp in UNIX time format
TIMESTAMP_MS	int[4]	Milliseconds for the time stamp
VALUE	float[8]	Value
STATUS	int[4]	Status flag of the value (zenon Status)
GUID	char[36]	Contains the project GUID of the variable from another project or is ZERO if in the own project.
STRVALUE:	varchar	varchar; the length depends on the longest string variable to be archived. For numerical variables this field has the value ZERO.

The name of the cross reference table <Project name>_VARIBALES is combined from the project name and the shortcut of the archive. The two parts are connected with an underscore character. So if the project name is "ARV_IN_DB" ant the archive term is "A1", the table name will be "ARV_IN_DB_A1".

Format of the cross reference table

Column	Type	Meaning
VARIABLE	int[4]	numerical variable ID
NAME	varchar[128]	Name of the variable
GUID	char[36]	char 36; takes the project GUID of the variable from another project or is ZERO if in the own project.

The name of the cross reference table is combined from the project name and the suffix "VARIABLES". The two parts are connected with an underscore character. So if the project name is "ARV_IN_DB", the table name will be "ARV_IN_DB_VARIABLES".

The columns GUID and STRVALUE either have to be added to the SQL database by hand, or they are added from the Editor. In the Editor you have to switch to the to the property page "Save" in all concerned archives. There you open the connection string to the database and confirm the dialog. After closing the dialog the according changes in the database are performed.

Attention

If these changes are not performed, no archive data will be evacuated to the SQL database.