What is the entire URL out of the browser, exactly where the error occurred?
Can you describe what the issue is you’re experiencing?
When I try to do a bulk import I get these kinds of messages
“# Your bulk import may not be ready for viewing yet, or task ID 4082c863-1c4e-40bc-9f5b-a0f15bfb9a99 may be invalid.
Try refreshing this page if you arrived on this page from an import that you just kicked off.”
Can you provide steps on how to reproduce what you’re experiencing?
I try to do the bulk import and when I want to proceed, I click on “Commit these results.” on the last page a pop-up shows the next message “Start full import? This process may take a long time. Do not close this browser window if you continue.”
When I say OK then this error happens.
I was able to upload the spreadsheet normally. The only change I made was to remove the media asset data because without the matching images, I couldn’t submit the import. I used Brave as my browser.
Which browser did you use when you uploaded the import? Do you mind trying again with a different browser to see if that helps?
But I changed the LocationID from “Andújar-Cardeña” to “Región Sierra Morena, Andújar-Cardeña” and worked. I think that before used to work with just “Andújar-Cardeña”, and in the encounters appeared as: “Región Sierra Morena → Andújar-Cardeña” but I am not sure. Examaple
On the other hand the user in the bulk import, the user field is empty when I think it needs to be fulfilled with the submitterID, isn’t it?
Because “Andújar-Cardeña” is nested underneath “Región Sierra Morena” in the Location ID list, it will display the hierarchy on the encounter page as “Región Sierra Morena → Andújar-Cardeña.” When you enter “Región Sierra Morena, Andújar-Cardeña” instead, you end up creating a new, unlisted location ID and your encounters will only be matched against the others in your bulk import. You were fine to leave the location ID alone, but something weird is happening because apparently anytime we update the original spreadsheet and upload the changed one (me testing with changing the media assets and you testing with the location ID) it just works. I think something’s going on with the original file, because re-saving it after making any change seems to make it work. Can you try deleting the columns that don’t have any metadata from the spreadsheet (MarkedIndividual.individualID, Encounter.occurrenceID, etc.) and see if that helps?
It should display your name here. Thanks for letting me know. I did verify with a test import that even though it doesn’t show it on the bulk import table, it does still assign the uploaded encounters to you:
I generated the spreadsheet with Python, I have tried to regenerate it with different libraries but I am reproducing the issue, when there are blue, the Bulk Import doesn’t work.
It is strange.
I think that is supposed to be able to do the bulk import with blue squares, isn’t it?
I sent you also the images, so you can reproduce the problem with the blue squares.
Thanks!!
Antón
The blue cells should still allow the import to go through. Those are just meant to show that there was no data listed under a field and it will be ignored.
Do you mind sending me the image for 4b8a3a4e6e4047e69025c57f3f102233.jpg? It’s the only one missing from the set you shared with me.
Thank you! Oddly, with all the photos and the original spreadsheet you sent, I didn’t have any issues with it accepting the import. It also didn’t have any blue cells in the preview.
Sometimes bulk import doesn’t like something about an Excel format, whether it’s a cell type or something else that’s not about the data you’ve entered. In the past, I’ve suggested to users to save the file as a .csv and then convert it back to .xlsx. That tends to strip away anything that it may have disliked about cell formats.
I think using the workaround to re-save the same file as we did before will be your best way forward for now since I’m not able to consistently reproduce the original issue.
Quick update: I talked to Jason and he confirmed that he gets the same error message when using a separate tool to generate an Excel file and that the workaround is to open the file in Excel, save it again as is, and then reimport.
Knowing this, it sounds like the act of me saving the attachment from the email behaved as that resave action which is why I couldn’t replicate it.
