Nov-08-2023, 10:58 PM
(This post was last modified: Nov-08-2023, 10:58 PM by deanhystad.)
In your example which is the "support ticket file" and which is the "already opened ticket file"?
"opened tickets" sounds like it should be a database. Your ping results should open a ticket for a register that is down, and repairing a register should close the ticket. You can tell the database to only open the ticket if there is no open ticket for the register.
A file can stand in as a database, but it is a clunky substitute. You could read in your list of open tickets (do you need the store number?) and save as a set. Before opening a ticket, check if the register number is in the open ticket set. You could do this with pandas using the "isin()" function. The set of registers with open tickets would be the "values" for the function.
https://pandas.pydata.org/pandas-docs/st....isin.html
"opened tickets" sounds like it should be a database. Your ping results should open a ticket for a register that is down, and repairing a register should close the ticket. You can tell the database to only open the ticket if there is no open ticket for the register.
A file can stand in as a database, but it is a clunky substitute. You could read in your list of open tickets (do you need the store number?) and save as a set. Before opening a ticket, check if the register number is in the open ticket set. You could do this with pandas using the "isin()" function. The set of registers with open tickets would be the "values" for the function.
https://pandas.pydata.org/pandas-docs/st....isin.html