Hi Anastasia
I notices that the same error happened to one of our colleagues (User name FeliciaVachon)
And many of her encounter numbers are messed up
Is there a way to fix it on your end?
Here is a link to all her imports:
Moving this to its own topic since the original one was a year old.
This isn’t something we can update for her on our end. She will need to manually edit the occurrence ID from the Identity section of each encounter or delete and re-import these encounters after correcting the associated spreadsheet.
Make sure she reviews the Parsed Import Table in the Bulk Import workflow because this would have revealed that the wrong occurrence IDs were displayed before she committed the imports.
Here’s a link to Microsoft’s help for methods to get Excel to stop converting numbers in a worksheet. The title says it’s for dates, but these steps work for any other number conversions Excel tries to force: Stop automatically changing numbers to dates - Microsoft Support
Hi Anastasia
we now know how to fix this on import but this is old data that we now noticed has this issue… If I create a table of all current encounter numbers (the problematic ones) and the correspondent real ones, there is no way to do it in a bulk instead of one by one? There are almost 500 there
Thanks
Hi @Yaly
Given the age of the imports and the likelihood that the bulk import workflow back then may not have shown the discrepancy as clearly as it does now, we can make an exception to help clean up these occurrence IDs. Can you please email us a spreadsheet of the current sightings/occurrenceIDs and the corrected IDs to services@wildme.org?
Thank you so much Anastasia!
I will finalize the list and send it once I am able to log in to Flukebook again (exciting to see the new look)
Thanks
1 Like
Hi Anastasia
I sent the file to the email you wrote
Thank you!
1 Like
Hi Anastasia
Any updates?
thanks
I’m so sorry about the delay. The teammate that was helping me with this was out sick for a few days. I’ll see if we can wrap this up this week.
Dear Anastasia
There is no rush at all! All the best to your teammate
Thank you
Thanks for waiting! The occurrence IDs have finally been fixed.
That’s great Anastasia, Thank you!
Where can I see it? cause if I do a search on her encounters from 2020 they still appear in the problematic format
I did a Sighting Search, expanded the Collected Data fields section, and entered one of the new IDs from your spreadsheet and it came up in the results.
Can you link me to the search URL that’s showing the old occurrence IDs?
You are right, I can see the encounter you are referring to but look here
When I do encounter search for the year 2020 I can see all the old, problematic ones and the one you shared… but no other updated ones
Hi @Yaly Can you view these search results? I did a search of Felicia’s sightings and I see the new IDs in this list.
I checked the link you shared and I do see the old IDs in the search table, but when I click through to the encounters themselves, it shows the occurrence ID as “none assigned.”
I’m waiting to hear back from my teammates about the encounters that got the old occurrence ID removed without the new one getting assigned.
OK, these look to be fully corrected now.