DBF Import/Export

Previous chapterNext chapter Show allShow all    Hide allHide all

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 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 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.