Hi,
I would like to import some values from a table in SQL to be available in Kepwware server. I would like to know what must be the format of the SQL table.
The format of my table is
- Tagname
- Timestamps
- Tagvalue
When imported in Kepware, it add a itemid for each column, i want 1 itemID by row, where the itemId is the tagname, the value the tagvalue and timestamp is time of the values which could be the crurrent time if not possible to use it.
How could i do that?
I have 250 tags to add to Kepware, example for 1 row
- tagname = 021-ENV:AjoutNutriment_Azote_Ajout.EM
- tagvalue = 210.0
- timestamp = 2023-05-30 07:30:00
I would like to see in Kepware
- ItemID = 021-ENV:AjoutNutriment_Azote_Ajout.EM
- Value = 210.0
- timestamp = 2023-05-30 07:30:00
Thanks
