Payment Editor

I snapped. Heh.

It was about time I grew tired of all the editing I have to do with all the mistakes in posting payments. Every time Agnes calls me to adjust batches of O.R. numbers, I have had to:

1. Load up the SQL front end.
2. Open my database of commands.
3. Open the commands table.
4. Select the second-to-last record for the template.
5. Copy the template's starting O.R.# to the clipboard.
6. Ask Agnes what the starting O.R.# to edit is.
7. Search and replace.
8. Copy the template's ending O.R.# to the clipboard.
9. Ask Agnes what the ending O.R.# to edit is.
10. Search and replace.
11. Copy the template's date of payment to the clipboard.
12. Ask Agnes what the posting date to edit is.
13. Search and replace.
14. Ask Agnes what to edit (teller_id, payment_date, O.R.#'s)
15. If O.R.#'s, switch to the command prompt or load one up.
16. Calculate the difference between correct and wrong starting O.R.#'s.
17. Search and replace.
18. Execute appropriate commands.

Now, with editpay.bat, I have compressed these steps into:

1. Editpay , , ,
2. Execute appropriate commands.

Kewl!!!

Floridablanca server disk full

Last night at around 9pm, Rico texted me and told me that he's getting errors.

I told them to go home because the problem had a simple solution: erase binary logs... and so I did, this morning. I went to the office before 7am and quickly solved the problem.

I also included Michelle to the sudoers, for good measure. So in the future, I can just instruct her over the phone...