OPC UA Labview Reading items and properties from excel sheet or text file?

Hello Guys,
I am a masters student at a German university now working on a research project and we are using OPC UA labview toolkit. I am new with using OPC UA in Labview so I am not sure to what extent are the capabilities OPC UA labview are similar to that defined by the OPC foundation. I hope I can get some tips and help on some issues.

Normally through labview we can create an OPC UA server and add folders/ Items/Properties to create the data structure. But this is done manually by adding the vi for each folder and item and connecting them. This is reasonable if we have two or three items or properties in the data structure. But if we have for example 40 items, then it would get messy. So i am thinking of a way to read the data from an excel sheet or text doc and automatically create the data structure in the OPC UA server. Offcourse, the data in the excel sheet should be arranged in a special way so that we can create the node paths easily and define the characteristics( read/write, datatype) of each node automatically. so far i was able to create the OPC UA server but I am stuck on how to transform the data from the excel file to the OPC UA server.
please find attached the VI i have so far.
Any help would be highly appreciated.
THank you.
BEst Regards,
Elias

Anzeige