Create UDT from Excel (exported to JSON or XML)

Ignition
1

Hi all,
What would be the best way to create UDTs from Excel, where you export the excel file into xml or JSON file ready to be imported to designer?

2

I’d be shocked if you could make Excel do that. Consider using v8.1’s Apache POI library to script the reading of your excel file and generate appropriate calls to system.tag.configure().

3

Hi @pturmel ,
Not nessecary directly from excel to JSON or XML. Although there is an option to export XML from excel based on schema file you add to excel. the schema is an export from a UDT. but it doesnt work anyway.

asking my question is different way,
What would be the best way to generate big UDT from excel? there must be a script .
I checked this one, ignition-tag-import-master, not much luck with it.

4

Why do you say this? Such a script won't exist until someone is motivated to write it. Like you.

I despise Excel, so it won't be me.

5

I dont want to reinvent the wheel.
I shouldn't be the the first person to create multiple big UDTs with script in this platform. :slight_smile:

6

You aren’t, in general. There are many posts here where users are manipulating XML or json to automate tag operations via imports, along with scripted tag operations. You asked about doing so with Excel. None of those that I can recall. Excel simply isn’t a good platform for complex json/xml entities.

7

Here’s a start:

https://forum.inductiveautomation.com/search?q=generate%20tag%20xml%20import

Huh. There’s even a topic with Excel.