No announcement yet.

How the variables can be exported from / imported to Automation Studio?

  • Filter
  • Time
  • Show
Clear All
new posts

  • How the variables can be exported from / imported to Automation Studio?

    Export and import variables in Automation Studio (AS) is one the most used action when communication between AS and external environmental in real time asked.

    Export Variables in AS environment:

    We have to follow the down listed steps:
    1 – Open "Variable Manager" dialogue by F12 or Tools à Variable Manager,
    2 – Click on the "Options" icon on the top menu,
    3 – In "Configure Variable Manager" window Sections "Columns in the list of variables" à selection and transfer "Exported" from Available variable in the left window to selected variable on the right window, confirm and close "Configure Variable Manager" dialogue.
    Now "Exported" column can be seen on the "Variable Manager" dialogue.
    4 – Click on the radio box front of every variable selected to be exported,
    5 – Once all the variables are selected to be exported, click on the "Export Variable(s)" icon on the top menu,
    Note: This icon will be activated if one variable at least selected to be exported,
    6 – From the this window, one of the exported format of the variable information should be chosen, the best and most convivial format is CSV’s format which can also be read and open by Excel suite MSOffice applications (the same for XML format). By default the data on the row are separated by comma in CSV’s format, do Next,
    7 –On this window, separator for exported variables format can be chosen customized, do Next,
    8 – Time and Date can be chosen on this window, do Next,
    9 – The available information to be exported for the variables should be chosen on this variable. Any information selected and transferred from left to right sub-window will appear on the exported file. By default, "Name" and "Type" are two selected information. For example : "Name","Type","Alias","Value"
    10 – Finally, a file name and destination folder should be chosen.

    Import Variables in AS environment:

    1 – In this case, AS can import the variables’’ information from two different format, CSV or XML. Again CSV format is more convivial and easy to manipulate and the format is well known by Excel.
    Note: there is some rule which should be respected while an imported file is written such as:
    If an exported file is opened by notepad, As import/export format can be obviously seen.

    a) Every variable is enclosed by quotation mark and separated by comma, e.g. "Variable1",
    b) The information name on the first row should start with capital letter and the rest is lower case, e.g. "Name","Type","Alias","Description",…
    c) The information on the "Type" column (variable’s type) Should be always capital, e.g. "BOOL","LREAL","INT",…

    2 – On the following windows, The imported File Language, separators, Time and Date should be chosen,
    3 – Finally, on the last window, the imported file should be selected.