junyinglim/transcriptresolver

transcriptresolver's Issues

change in institutionCode values

We changed CIS to UCIS in the bnhm_id field -- yes, not good, we changed the (semi) unique identifiers.

I think there will need to be a hack added somewhere (in transcriptPrepare.py and maybe elsewhere) so that bnhm_ids that start with CIS are changed to UCIS.

Meanwhile, I easily changed those values in the load file once I put it in Excel.

But when records were checked to see if they had been databased, they would not have been found even if they had been databased.....

non-California counties in California

According to my memory the TranscriptResolver is checking for valid California counties, right? The bulk loader found some invalid ones:

Error .... Specimens Worksheet, Row 1095: State is California but Hidalgo County is not an approved California county.

Error .... Specimens Worksheet, Row 3744: State is California but Wabasha County is not an approved California county.

Error .... Specimens Worksheet, Row 4860: State is California but Douglas County is not an approved California county.

Error .... Specimens Worksheet, Row 6490: State is California but Wabasha County is not an approved California county.

Error .... Specimens Worksheet, Row 7621: State is California but Clay County is not an approved California county.

Error .... Specimens Worksheet, Row 8193: State is California but Navajo County is not an approved California county.

Error .... Specimens Worksheet, Row 9416: State is California but Utah County is not an approved California county.

Error .... Specimens Worksheet, Row 17636: State is California but Bonner County is not an approved California county.

Error .... Specimens Worksheet, Row 20264: State is California but Monroe County is not an approved California county.

Error .... Specimens Worksheet, Row 22108: State is California but New York County is not an approved California county.

Error .... Specimens Worksheet, Row 24671: State is California but El Paso County is not an approved California county.

Error .... Specimens Worksheet, Row 24709: State is California but Pima County is not an approved California county.

Error .... Specimens Worksheet, Row 25580: State is California but Rio Arriba County is not an approved California county.

Error .... Specimens Worksheet, Row 26183: State is California but Washoe County is not an approved California county.

Error .... Specimens Worksheet, Row 26971: State is California but Ransom County is not an approved California county.

Error .... Specimens Worksheet, Row 27170: State is California but Ransom County is not an approved California county.

Error .... Specimens Worksheet, Row 27707: State is California but Pierce County is not an approved California county.

Error .... Specimens Worksheet, Row 29818: State is California but Pima County is not an approved California county.

Error .... Specimens Worksheet, Row 32934: State is California but Chaves County is not an approved California county.

Error .... Specimens Worksheet, Row 33408: State is California but Davis County is not an approved California county.

Error .... Specimens Worksheet, Row 33919: State is California but Eddy County is not an approved California county.

Error .... Specimens Worksheet, Row 35082: State is California but Philadelphia County is not an approved California county.

Error .... Specimens Worksheet, Row 36460: State is California but Hidalgo County is not an approved California county.

Error .... Specimens Worksheet, Row 37412: State is California but Ransom County is not an approved California county.

Error .... Specimens Worksheet, Row 37985: State is California but Lyon County is not an approved California county.

Error .... Specimens Worksheet, Row 38735: State is California but Liberty County is not an approved California county.

Error .... Specimens Worksheet, Row 39860: State is California but Maui County is not an approved California county.

Error .... Specimens Worksheet, Row 40287: State is California but Richland County is not an approved California county.

Error .... Specimens Worksheet, Row 40578: State is California but Hidalgo County is not an approved California county.

duplicate records

I'm getting errors on some records appearing twice in the load file. Here are some example:

Error .... Specimens Worksheet, Row 2895: bnhm_id "EMEC533611" was already used on Row 1872
Error .... Specimens Worksheet, Row 6533: bnhm_id "EMEC528658" was already used on Row 1935
Error .... Specimens Worksheet, Row 7483: bnhm_id "EMEC544886" was already used on Row 985
Error .... Specimens Worksheet, Row 8077: bnhm_id "EMEC528637" was already used on Row 2491
Error .... Specimens Worksheet, Row 9661: bnhm_id "EMEC533992" was already used on Row 3195
Error .... Specimens Worksheet, Row 11743: bnhm_id "EMEC530196" was already used on Row 5521
Error .... Specimens Worksheet, Row 12772: bnhm_id "EMEC515825" was already used on Row 9351

date issue

Also getting some date errors (this is the complete list):

Error .... Specimens Worksheet, Row 3336: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 4510: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 7625: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 23360: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 24990: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 26274: Day Collected entered with no Month Collected.

Error .... Specimens Worksheet, Row 39653: Day Collected entered with no Month Collected.

holdingInstitution changes

We'll have to change 3 or 4 of the holdingInstitution values in essig_inst.csv.
Will post details when I have everything straight.