Recording notes from the past couple of days (11/13-11/14).

Custom data import for a client. It was dealing with customer loyalty points. Their data was kinda messed up. Played with replacing phone numbers in queries by pulling data, looping, string manipulation, and then pushing that data back into the queries in memory. Spent time combing the data and started coding the upload page.

Finished up the loyalty points upload page. Ran the whole thing once without it making any database changes just to see if it would work. Got stats, counts, and a list of things that it skipped. Actually did the process for real and sent a message to the client letting them know how it went.

Fixing a bug on the calculate payroll page. The error was some older code that was doing a loop over a query with a grouping. That code used to work fine but doesn't seem compatible with the newer code. Bryan and I were working on this bug. We got stumped for a bit. I was trying things and running a series of tests. He put the errors into ChatGPT (AI or artificial intelligence bot). By the time we were done, we had a working solution. It took both of us to get a working page again. We pushed up code and Bryan sent an email out to Cory and others.