DBF Import/Export

Additionally to the XML import there are other import possibilities for the variables:

Import possibilities	Description
From DBF - file	Variables can be imported from a dBase file. The format of the file is described in the chapter File structure.
Export DBF – file.	Variables can be exported to a dBase file. The format of the file is described in the chapter File structure.
From S7 - project	Variables can be imported directly from a S7 project. An adoption of Win CC names of S7 technologic sight is possible. zenon or WinCC- or Combined names can be selected. For WinCC names it is possible, to select technologic steps and specify a separator.
From TwinCAT - project	Variables can be imported directly from a TwinCAT project.

For these import possibilities the corresponding drivers have to be created in the project before.

Info

The S7 import does not support structures. Structure information from the S7 project is resolved and imported as a flat list. Also other drivers offer the possibility to browse through the variable list of the PLC program (e.g. OPC, Codesys, B&R, ...).

Attention

During Import S7 - project... the S7 Simantic Manager must not be opened, i.e. it must not open the S7 project which should be loaded because the program has exclusive access to certain files.

Thus the import mechanism fails. For example no Stations are displayed.

File structure of the dBase export file

For variable import and export, the dBaseIV file must have the following structure and contents:

Description	Type	Field size	Comment
KANALNAME	Char	128	Variable name
KANAL_R	C	128	Original name of variable, that will be replaced by the enry under "KANALNAME". (Field/Column has to be set manually)
KANAL_D	Log	1	With entry 1 the variable is deleted(column has to be created by hand)
TAGNR	C	128	Identification
EINHEIT	C	11	Technical unit
DATENART	C	3	Data type (e.g. bit, byte, word, ...) For more detailled information please call our Support
KANALTYP	C	3	Memory area in the PLC (e.g. marker area, data area, ...) For more detailled information please call our Support
HWKANAL	Num	3	Bus address
BAUSTEIN	N	3	Datablock address (only for variables from the data area of the PLC)
ADRESSE	N	5	Offset
BITADR	N	2	For bit variables: bit address For byte variables: 0=lower, 8=higher byte For string variables: Length of string (max. 63 characters)
ARRAYSIZE	N	16	Number of variables in the array for index variables ATTENTION: Only the first variable is fully available. All others are only available for VBA or the Recipegroup Manager
LES_SCHR	L	1	Write-Read-Authorization 0: Not allowed to set value. 1: Allowed to set value.
MIT_ZEIT	L	1	time stamp in zenon (only if supported by the driver)
OBJEKT	N	2	Driver specific ID number of the primitiveobject includes KANALTYP and DATENART For more detailled information please call our Support
SIGMIN	float	16	Non-linearized signal - minimum (signal resolution)
SIGMAX	F	16	Non-linearized signal - maximum (signal resolution)
ANZMIN	F	16	Technical value - minimum (measuring range)
ANZMAX	F	16	Technical value - maximum (measuring range)
ANZKOMMA	N	1	Number of decimal places for the display of the values (measuring range)
UPDATERATE	F	19	Update rate for mathematics variables (in sec, one decimal possible) not used for all other variables
MEMTIEFE	N	7	Only for compatibility reasons
HDRATE	F	19	HD update rate for historical values (in sec, one decimal possible)
HDTIEFE	N	7	HD entry depth for historical values (number)
NACHSORT	L	1	HD data as postsorted values
DRRATE	F	19	Updating to the output (for zenon DDE server, in [s], one decimal possible)
HYST_PLUS	F	16	Positve hysteresis, from measuring range
HYST_MINUS	F	16	Negative hysteresis, from measuring range
PRIOR	N	16	Priority of the variable
REAMATRIZE	C	32	Allocated reaction matrix
ERSATZWERT	F	16	Substitute value, from measuring range
SOLLMIN	F	16	Minimum for set value actions, from measuring range
SOLLMAX	F	16	Maximum for set value actions, from measuring range
VOMSTANDBY	L	1	Get value from standby server; the value of the variable is not requested from the server but from the standby-server in redundant networks
RESOURCE	C	128	Resources label free string for export and display in lists
ADJWVBA	L	1	non linaer value adaption 0: non linear value adaption is used 1: non linear value adaption is not used
ADJZENON	C	128	Linked VBA macro for reading the variable value for non-linear value adjustment
ADJWVBA	C	128	Linked VBA macro for writing the variable value for non-linear value adjustment
ZWREMA	N	16	Linked counter REMA
MAXGRAD	N	16	Gradient overflow for counter REMA

The length of the fields "KANALNAME", "KANAL_R", "TAGNR" and "RESOURCE" can be limited via the entry MAX_LAENGE in the PROJECT.INI.

Limit value definition for limit value 1 to limit value 4 or condition 1 to condition 4:

Description	Type	Field size	Comment
AKTIV1	L	1	Limit value active (per limit value available)
GRENZWERT1	F	20	Technical value or ID number of a linked variable for a dynamic limit (see VARIABLEx) (if VARIABLEx is "1" and here "-1", the existing variable linkage is not overwritten
SCHWWERT1	F	16	Threshold value for limit
HYSTERESE1	F	14	Hysteresis in %
BLINKEN1	L	1	Set blink attribute
BTB1	L	1	Logging in CEL
ALARM1	L	1	Alarm
DRUCKEN1	L	1	Printer output (for CEL or Alarm)
QUITTIER1	L	1	Must be acknowledged
LOESCHE1	L	1	Must be deleted
VARIABLE1	L	1	Dyn. limit value linking the limit is defined by an absolute value (see field GRENZWERTx).
FUNC1	L	1	Function linking
ASK_FUNC1	L	1	With interrogation before execution
FUNC_NR1	N	10	ID number of the linked function (if "-1" is entered here, the existing function is not overwritten during import)
A_GRUPPE1	N	10	Alarm group
A_KLASSE1	N	10	Alarm class
MIN_MAX1	C	3	Minimum, Maximum
FARBE1	N	10	Colour as Windows coding
GRENZTXT1	C	66	Limit value text
A_DELAY1	N	10	Time delay
INVISIBLE1	L	1	Invisible

Expressions in the column "Comment" refer to the expressions used in the dialogboxes for the definition of variables. For more information, see chapter Variable definition.