Wednesday, March 25, 2020

Writing Java

Not much activity here because I have been writing a Java program to convert the spreadsheet of horror into SQL commands to create the needed database.  The program is done, but running it finds inconsistencies in my data: misspelling an abbreviation; inconsistent cause codes (ALTERCATION where my standard is QUAR for quarrel; swappin cause and category (LYNCH is a cause; always in the category public).  It is slow work.

1 comment:

DaveS said...

Data inconsistency - the hobgoblin of free form input. Good luck and patience!