App Manager allows you to export and import configuration using an Excel spreadsheet.
Importing and Exporting spreadsheets
To access the Excel Export and Import functions, view the “Properties” of any app or object within the App Manager site:
...
| Info |
|---|
Hint: You can also Ctrl + Click on the item in the navigation tree to immediately open the Properties. |
Export to Excel
This button will download a spreadsheet containing objects under the item that you are viewing. For instance, if you opened the properties for an App (Edge ACM, AUTOSOL MQTT, etc.) it will export all of the objects under the application. If you opened the properties for an Object (a folder, a tag group, etc.), it will export that object and it’s children. This will export a file of type .xlsx with each individual sheet representing an object type.
Import from Excel
To import configuration from an Excel spreadsheet, click the “Choose Files” button and browse to the .xlsx file you wish to import. Once loaded, clickthe “Import from Excel” button to complete the import process.
Editing configuration data in an Excel spreadsheet
The Excel configuration can vary in complexity based on object type. Most data types are easy to understand but some configuration items can be complex data structures that have to be represented in certain formats in excel. Most are straightforward and the Import process will convert the “value” from the sheet into the datatype required.
...
There are, however, more complex data formats that are also supported in the Excel spreadsheet.
Arrays
Arrays are lists of values. The values can vary in type from integers, to strings, etc. In the example below, we are importing a Publish Schedule including it’s name and list of Publisher Groups an array of “Publish Groups IDs” into the Publish Schedule property “groupids”. This can be visualized as a table of data with one column containing the name of the schedule, one representing the position within the array, and the third column, “groupids”, contains the ID of the individual publish groups. In this sheet, the “Name” is repeated multiple on each row to signify the same schedule.
...
| Info |
|---|
The “position” in the array must always start at 0 and be entered in the spreadsheet in numerical order. As many entries can be added to the array as necessary. |
Objects and Arrays of Objects
Objects are key-value pair structures that can contain one or more keys and values of any type. Using the Tag object again as an example, we want to import a tag and its “triggerconditions” property which contains an array of trigger conditions which each have their own property values. In the table below, we have two Tags named ROCTag and ModbusTab which each have two separate trigger conditions.
...