Hey guys, I want to ask for your opinion on this issue,
I have a list of 1200 fault integers and their fault detail(usually nothing more than 20-30 characters each). I get the fault integer as a tag from the PLC and I can display it just fine BUT i’m trying to figure out the best way to match that integer to my list and display what fault that integer refers to.
Should I try to read from the excel file and match the integer to a cell and grab the corresponding cell or should I insert that list into a DB table and use a query to find what the fault string is? Is it there any other options that I haven’t looked at that might come handy?
This list of 1200 faults is only for one Press line and there are 6 more so I want to find the best way to tackle this issue since I will have to do the same for the other 6 lines. Thanks in advance for your ideas.