JustAnotherEngineer (Customer) asked a question.

Convert Productivity extended .CSV modbus addresses to Ignition JSON for import

I'm not sure if this is the proper place to post this but I thought it might be useful for somebody

 

I've created the attached script that can be used in Ignition that will read the Productivity extended CSV file and create a formatted JSON file that can be imported into Ignition as a UDT with all the tags that have modbus addresses.

 

The script will work out of the box to read the .csv and create a json file but for it to be useful you will need to modify it giving the (structure_name) a name useful to you and the (dev_name) will need to match you device name in Ignition's Device Connections

 

It does not have all the array data types mapped and will not import anything that's not mapped but it's easy enough to add them if you need to.

 

It will not import tags that have invalid characters in Ignition.

 

Tags with spaces in the name will have them replaced with "-"

 

Any structures or tags with "_" will be placed in folders with the root name.

 

The easiest way to use it is paste the script into a button and run it

It will ask you for the source .csv file and where you'd like to save the json.

 

Once the json file is created you can import it as a UDT in ignition then create tags from the UTD instance.

 

Obviously it can be modified to suit your needs and formatting preferences.