Occurrence ID is blank in search results table even tho it exists in the encounter record

Hi Maureen,

I believe this results when an Encounter points at a Sigthing, but the Sighting does not contain it. I do believe this logic hole was previously plugged, and a review of the current code suggests this should not be happening now.

I have prepared a quick, custom list of affected Encounters on your platform:

https://africancarnivore.wildbook.org/appadmin/occurrenceEncounterBidirectionalReferentialIntegrityCheck2.jsp

Can you please confirm that the listed Encounters should be associated with the listed Sightings? If so, I can enact the fix needed to make the associations. But since this does affect data, I would like your approval first.

Thanks,
Jason

@ACWadmin1 just checking in about this one.
No rush (we have plenty to do :sweat_smile:)!
-M

Good thing you checked in! I completely missed this one. I’ll review asap and get back to you. thanks for the nudge!

Maureen

Hi Maureen,

I have connected these Encounters and Occurrences. We have a clean bill of health in the check:

https://africancarnivore.wildbook.org/appadmin/occurrenceEncounterBidirectionalReferentialIntegrityCheck2.jsp

Regarding the submitter info, this is a second issue on this ticket, and I’d like to close it to reflect the original has been addressed.

My recommendation for the missing submitter is to review the bulk import spreadsheet for the bulk import:

ACW_cheetah_raw3_upload EF_Final.xlsx

https://africancarnivore.wildbook.org/imports.jsp?taskId=c61afbe6-1c0a-49ef-88f5-ea10c1164246

and verify that the Submitter contact info was specified. If it was, bulk import delete and reimport is likely to solve the issue as a lot of development has gone into bulk import since August when this import happened. If the issue persists, I would recommend a new ticket to address this issue.

Thanks,
Jason

1 Like

Hi @jason - I checked the spreadsheet and the submitter ID was specified but not the submitter full name or the submitter email. I’m guessing that, even tho’ this info is already in the system from previous uploads & user profile set up, and despite the fact that the bulk import review page always says it won’t import the submitter full name field bec it’s already in the system, that this is the reason these sightings don’t have submitter info in the contact section of the encounters?

To delete the bulk import and re-import the spreadsheet only (with the additional contact fields added) - I see how that would work but will we lose all of the ID’s that have already been assigned in this batch?

thanks
Maureen

I checked the spreadsheet and the submitter ID was specified but not the submitter full name or the submitter email.

Submitter email address (Encounter.submitterX.emailAddress or photographer email address, etc.) is the minimum field we need to create a new User and add it to the array of submitter, photographers, etc. Without that, I see why you’re seeing what you’re seeing. The importer would not have created the submitter if the email address is not specified on that Encounter row. Encounter.submitterX and Encounter.submitterID are not linked in the code in any way.

To delete the bulk import and re-import the spreadsheet only (with the additional contact fields added) - I see how that would work but will we lose all of the ID’s that have already been assigned in this batch?

Correct, you would lose curation work.

I think the best solution here is to fill these fields in manually if curation work has already been done on the data. There is not an easy solution on our side.

Thanks,
Jason

Okay thanks. Another lesson learned!

cheers
M