No entry in County leads to error

[Amelie]

Hello! My data set includes locations in various Canadian provinces. Some entries don’t contain a county name, as some provinces do not use this administrative unit. This generates an error message during data validation. We can also see in the GeoTree that Manitoba province as no child. What these cells should contain to avoid the error message?

Note: Manitoba uses divison number instead of county. I tried to validate with a divison number in the cell but got the same error.

[markp]

Hi Amelie,

I don’t believe that the error you are experiencing has to do with there not being a county, rather that there is an attempt to save differing information to the same accession. If after reading the below you want to use these fields, I can help explain how to resolve the error.

It looks like the fields that you are using for the country and state are Address Of Record, which has description “This is the address when the legal action took place.” Is this the intended table? Or rather, are these the locations in which the occurrence was collected? I only ask because I notice you have locality remarks as Winnipeg, which is in Manitoba, and then your county is defined in Geography > County.

[Grant]

Hi @Amelie,

To add to @markp’s message–

Based on the error in your data set, it looks like the issue may be with the Accession you are attempting to create rather than the Address of Record that is likely linked to that Accession.

('Accession must have unique accessionnumber in division', ['table': 'Accession', 'localizationKey':'childFieldNotUnique",'fieldName': 'accessionnumber', 'fieldData':
{'accessionnumber':"}, 'parentField': 'division', 'parentData: {'division: 'Division object (2)), 'conflicting: [14141]})

Sometimes errors in the WorkBench are shown on the incorrect cells if there is another issue in the same row. It is likely that you are either trying to add a new Accession with an accession number that already exists in the database or trying to match to an existing Accession but a detail of the Accession (or its relationships to tables like Address of Record) make it distinct.

Is this the case?

[Amelie]

You were right, Country and State weren’t mapped correctly. I used the automapper and didn’t notice that detail. Now that they are mapped in Collecting event as is County, no errors were found. What confused me was that only lines where no County was entered returned an error message. Thank you very much!