Hi @Justin
Thanks for your patience! A few quick notes on your spreadsheet:
- Three of your file names have parentheses. These are considered special characters. If it’s not A-Z, a-z, 0-9, space, or period, it’s a special character and may not play nice when uploaded.
- The field
Encounter.submitterIDshould be your IoT username. Without it, the system doesn’t realize who to assign these encounters to and won’t let you edit them. - I don’t think this is creating issues in this instance, but I’m listing it here as a best practice: we recommend removing any unused fields from your spreadsheet before uploading it. The system will occasionally detect an empty field and then ignore the data in other similar fields.
I recently pinned a Bulk Import Cheat Sheet to the Community that covers the most frequent issues we see with spreadsheets.
As far as next steps, we can reset your bulk import, so we’re starting from a clean slate while not affecting any of your past manually-entered encounters. After that, you can submit your updated spreadsheet with the above points corrected (feel free to email it to us for review before you submit it for upload). If any issues crop up after that new upload, we should be able to quickly pinpoint a fix.
Let us know if that works for you and I’ll let you know when we’ve reset the import and you can start preparing your submission again!