Hello all,
I have a table with client transaction information and a check box to mark whether it has been sent to a different department for processing. Once processed, the other department sends me a csv file with all the transactions it has processed successfully (some don't get processed due to errors). This csv file contains a unique identifier for each transaction. For now, I've been manually checking off each successful transaction but I'd like to be able to do it automatically. Can someone provide code to read the csv file line by line and update my table accordingly? Thank you.
Sleepy
I have a table with client transaction information and a check box to mark whether it has been sent to a different department for processing. Once processed, the other department sends me a csv file with all the transactions it has processed successfully (some don't get processed due to errors). This csv file contains a unique identifier for each transaction. For now, I've been manually checking off each successful transaction but I'd like to be able to do it automatically. Can someone provide code to read the csv file line by line and update my table accordingly? Thank you.
Sleepy