tree species audit very unstable when adding and editing new cases

[jsfried]

The 4FRI project (Arizona when loading the attached Plot CN list and choosing 41901 as the EVALID to load) has 15 species that are not found in the translation table. Doing a check all and adding those to the tree species table adds 15 records, some of which have partial data showing (e.g., common name, but not fvs_input_species) and some of which have no data (on common name or fvs input species via either numeric or letter coding). Not sure why there are these differences. placing the cursor on each line and clicking edit brings up the dialog that populated everything except for the common_name, which is apparently required:

One can type those in, and work through the list but I found the program unstable (crashed with an exception error several times before I could work through the whole list so I saved often). Then sometimes I could not save, as it would throw this error:

I am not a fan of this buggy workflow. It will not be uncommon that there are rarely found species that are not in the tree_species table and this becomes a real impediment for someone trying to get a project up and running. Another approach we might consider would be to allow a user to choose that any missing species be added as 298 OS if the FIA SPCD is <300 (softwood/hardwood threshold) and 998 OH if >= 300.