So I have an excel file with 60 or so error codes and associated messages. What would be the best way to read the error code value and get the associated description for display on my vision screen?
Partial list for illustration
In a script, either parse the excel file directly or export it as CSV, and then parse it , and store the data in a database table. Then load that data from the DB table into a dataset tag and use that tag to use lookup in an expression or look through the dataset in a script.
Storing it in a DB table makes sure the data will exist in a decently permanent place instead of relying on a global tag to save the data through a gateway restart. You probably aren't hitting the upper limit on the amount of data you can store in a tag, but its a good habit to have.
2 Likes
If you're going to go the database route (which I would recommend) then add in a column for the machine name. Then you can add every error code for every machine is in the one table.
3 Likes
Machine id*
2 Likes