Import and Export Variables Data

Save imported variables as
Microsoft®
Excel®
spreadsheets (.xls) or comma-separated values (.csv).
  • Export variables to manage simple and complex variables data including adding, removing, and modifying variables.
  • Import variables data files into controllers and programs in the same project or in other projects.
    TIP:
    • AADvance-Trusted SIS Workstation software®
      uses the default values for missing data when importing a variables data file missing any columns.
    • Make sure imported variables match their corresponding definitions in the project when importing variables.
Specify a location to save exported files when exporting variables. Export an empty file as a template to develop the contents of variables data files (*.xls or *.csv) in a respective editor like
Microsoft
Excel
or Notepad.
A variables data file includes a header row, a mapping row, a version number, and the variables data. The header row displays the names of the data columns. The column names of the header row are the various variable properties. The mapping row displays the internal names of data columns in brackets used for processing. An automatically generated version number indicates the version of the import/export feature. The individual variable data is placed in the respective columns.
cam_ixv_aadvance
This table shows the syntax used in the variables data files for the variable properties and the associated internal names:
Variable Property
Internal Name
Description
Name
(Name)
Name of the variable. Variable name are limited to 128 characters beginning with a letter or single underscore character followed by letters, digits, and single underscore characters. The last character for a variable name must be a letter or digit; variable names cannot end with an underscore character. Names cannot be reserved words, defined words, or data types (elementary, structures, or arrays). Names must be unique.
Data Type
(DataType)
Data type of the variable
Dimension
(Dimension)
Number of elements defined for an array
String Size
(StringSize)
The maximum character length for string-type variables.
Initial Value
(InitialValue)
Value held by a variable when the virtual machine starts executing the controller
Direction
(Direction)
For the local variables of a program organization unit (POU), indicates whether the variable is internal, an input, or an output. For controller variables, indicates whether the variable is internal, an input, an output, a system variable, or an I/O channel.
Attribute
(Attribute)
Read and write access rights
Comment
(Comment)
User-defined free-format text for variables and array elements. Each array element of the same type can have a different comment.
Alias
(Alias)
Any name
Wiring
(Wiring)
The I/O channel wired to the variable
During variable import, the raw and engineering values of analog I/O channels reset:
When imported variables are not wired, the raw values are: 0 for low, and 1 for high. The engineering values are: 0 for low, and 1 for high.
When imported variables are wired, the raw values are: 1024 for low, and 5120 for high. The engineering values are: 0 for low, and 100 for high.
Address
(UserAddress)
User-defined address of the variable
Retained
(IsRetained)
The virtual machine saves the value of the variable at each cycle. Limitations:
  • Do not use the
    Retained
    property for safety-related settings.
  • Do not set the
    Retained
    property on wired T9K_xx_FULL structures.
Retained Flags
(RetainFlags)
Enables retaining specific elements of a variable and indicates whether to use the initial value of a variable or the value previously retained on the target.
Groups
(Groups)
Variable group containing the variables listed in alphabetical order
OPC Write
(AllowOPCWrite)
An external client can write to the variable
Message True
(MsgTrue)
Message defined for the TRUE value message
Message False
(MsgFalse)
Message defined for the FALSE value message
Base Address
(ModBusBaseAddress)
For Modbus communications, the base address of the variable
Type
(ModBusType)
For Modbus communications, indicates one of these variable types:
  • When the data type is BOOL and the type is True, the variable type is Coils.
  • When the data type is BOOL and the type is False, the variable type is Discrete Inputs.
  • When the data type is DINT and the type is True, the variable type is Holding Registers.
  • When the data type is DINT and the type is False, the variable type is Input Registers.
Write Protected
(ModBusWriteProtected)
For Modbus Communications for Coils and Holding Registers, indicates whether data can be copied from the Modbus master to the slave device.
Reference Variable
(SOERefVar)
For the SOE service, the referenced variable of any elementary data type.
Falling Edge Level
(SOEFallingLevel)
Te SOE service detects a fall from TRUE to FALSE.
Rising Edge Level
(SOERisingLevel)
The SOE service detects a rise from FALSE to TRUE.
Filter Time
(SOEFilterTime)
For the SOE service, the minimum time lapse between two events.
CIP Kind
(CIPKind)
For CIP communications, indicates whether the variable is a producer or consumer.
Producer Name
(CIPProducerName)
When the CIP variable is a consumer, indicates the CIP producer from which the consumer receives data.
Path To Producer
(CIPCPathToProducer)
When the CIP variable is a consumer, indicates the path to the producer.
Consumer Remote Tag
(CIPRemoteTag)
When the CIP variable is a consumer, indicates the remote tag name of the producer variable communicating with the consumer variable.
RPI (ms)
(CIPCRPI)
When the CIP variable is a consumer, indicates the frequency in milliseconds that the remote controller offers the variable to the AADvance controller.
Producer Remote Tag
(CIPPRemoteTag)
When the CIP variable is a producer, indicates the remote tag name of the consumer variable communicating with the producer variable.
Max Number of Connections
(CIPPMaxConnections)
When the CIP variable is a producer, the maximum number of simultaneous consumer variables.
To Controller
(SNCPToController)
For the SNCP producer binding variable, the corresponding controller name for each consumer variable.
For multiple consumer variables, controller names are separated by a comma. For example:
Controller2,Controller2,Controller3
.
From Controller
(SNCPFromController)
For the SNCP consumer binding variable, the name of the controller producing the variable binding group.
From Symbol
(SNCPFromSymbol)
For the SNCP consumer binding variable, the name of the producer variable.
Error Value
(SNCPErrorValue)
For the SNCP consumer binding variable, the value defined for the error behavior. When no value is specified for the error behavior, the binding uses the last value.
Update Value
(SNCPUpdateValue)
For the SNCP consumer binding variable, the value defined for the update behavior. When no value is specified for the update behavior, the binding uses the last value.
A progress bar shows advancement of import and export operations. Use the progress bar to cancel import and export operations.
  • For import operations, the process stops after importing the last variable in progress.
  • For export operations, the process does not produce an exported variables file.
    Task
    Procedure
    Import variables
    1. In the
      Application View
      , right-click the destination receiving the
      Local Variables
      or
      Controller Variables
      , and then click
      Import Variables
      ....
    2. From the
      Import Variables
      dialog box, select the file type containing the variables, locate the file, and then click
      Open
      .
    Export variables
    1. In the
      Application View
      , right-click the
      Local Variables
      or
      Controller Variables
      containing the variables to export, and then click
      Export Variables
      ....
    2. From the
      Export Variables
      dialog box, specify a name and locate the destination in which to store the file containing the exported variables, select the file type and then click
      Save
      .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal