Alternatives to editing tags in the Flexy's web interface – HMS Support Portal

When importing or updating a large number of tags, it is easier to make these changes outside of the Flexy's web interface. Alternatives available include:

A tool that automatically formats tags from a PLC registers file
An Excel macro available on the Ewon TechForum
Using FTP to manually retrieve and edit the tag file

Using FTP is also helpful for backing up or restoring tag lists.

APPLICABLE PRODUCTS

Ewon Flexy line

PRE-REQUISITES

Ewon Flexy connected via LAN or VPN
For the Flexy Tag generator:
- A registers file from the PLC (instructions included in the Flexy Tag generator webpage)
- FTP client like FileZilla
For the Excel macro:
- An Ewon TechForum account
- Microsoft Excel
For manual editing or backups:
- FTP client like FileZilla
- Spreadsheet software like Excel (if editing tags)

LIMITATIONS

There are some cases in which the Ewon is not able to reconcile the uploaded var_lst.csv and the existing tags on the device. These limitations apply whether using the Excel macro or manually editing the tag list and transferring it via FTP. Some limitations include:

Renaming tags
Removing tags

When adding a new tag, it's important to use a new ID for it. The ID must be unused by other tags in the spreadsheet or on the Ewon itself.

FLEXY TAG GENERATOR

Open the Flexy Tag generator
Upload the config file from the PLC with tags to be polled
- The "Step 1" section includes tutorials on how to download this file from various PLC software
  
  Fig 1. preview of tag configuration after importing ABLogix file from Studio 5000
Review the tag list in the Preview section
Download the tag list .csv
Proceed to Restore Tags for instructions on uploading, or view the "Need help on how to proceed?" tutorial video linked below the export button.

EXCEL MACRO

Download the Excel macro
Open the macro and click Enable Content to allow it to execute its code
Ensure there is a good connection to the Ewon, either directly to the Ewon's LAN or connected through eCatcher and the Ewon's VPN
Enter the Flexy's IP address in cell L1, replacing the default IP address

Fig 2. set the value in the red box to the Ewon's IP address
Click "Import From Ewon", then enter the Ewon's local username and password (default adm/adm)
The Flexy's tags will populate the spreadsheet. Edit the tag values as desired
- If a value isn't a number, it must be enclosed in quotes
Click "Send To Ewon", once again entering the Ewon's local username and password
Refresh the Ewon's tags page to verify the changes were applied correctly

DOWNLOAD TAGS

Ensure there is a good connection to the Ewon, either directly to the Ewon's LAN or connected through eCatcher and the Ewon's VPN
Log into the Ewon using an FTP client and the following details:
- Hostname: the Ewon's LAN IP address
- Username: Ewon's local admin account user (default adm)
- Password: Ewon's local admin account pass (default adm)
- Port: can usually be left blank if still set to default on the Ewon (default 21)
Scroll down through files listed on the right to var_lst.csv
- var_lst.csv and var_lst.txt are the same file, but the .csv will likely have a file association with spreadsheet software
  
  Fig 3. viewing files on the Flexy through FTP
Drag the file to the desired folder on one's machine in the left panel

EDIT TAGS

Because some regions represent decimals with commas, the tag file on a Flexy is in fact semicolon delimited, not comma delimited. Depending on a computer's settings, it may be necessary to change the file's delimiters to open it within a spreadsheet program. For that reason, it is recommended to save a backup of this .csv in case there are any mistakes in editing it.

To change the delimiters:

Save a backup of var_lst.csv somewhere safe
Open the file within a text editor like Notepad or Notepad++
Find and replace all semicolons with commas
- Note: ensure this is only done if the Flexy's data has no commas in it already
  
  Fig 4. finding and replacing semicolons in Notepad++
Open the file in a spreadsheet editor and make the desired changes, then save
Once again, open the file within a text editor like Notepad or Notepad++
Find and replace all commas with semicolons

RESTORE TAGS

Reconnect to the Ewon using an FTP client
Drag the newly edited var_lst.csv from the computer to the Flexy's root directory
When prompted, accept overwriting the existing var_lst.csv
Log into the Flexy's web interface and verify the tag changes were properly imported

If tags from a new IO Server were added, navigate to Tags -> IO Servers -> IO Servers List and select the IO Server in question, then configure and enable a topic to begin polling data.

If there is an error importing tags, it will be logged with a description similar to "varId-Import config error at line (Line: X)". If this happens, ensure the delimiters were reconverted to semicolons and no columns were added or deleted. In this event it's probably best to start over from a copy of the backup of var_lst.csv.