What is the entire URL out of the browser, exactly where the error occurred?
Can you describe what the issue is you’re experiencing?
The occurrence ID is messed up while uploading, instead of 20220101 I get 2.0220101E7 which is a numeric representation but makes it harder for follow up in the future. I tried changing the format to text, number, general and more in the excel file but it stays the same
Can you provide steps on how to reproduce what you’re experiencing?
If this is a bulk import report, send the spreadsheet to services@wildme.org with the email subject line matching your bug report
Can you try editing the following items in your spreadsheet and then try deleting and reimporting the upload?
Column A is missing the field heading but still has data in it. You’ll need to either delete this column or add the correct field to import it.
Change the Format for the Encounter.occurrenceID field from Numbers to General so that it matches the format type of the rest of the columns in the sheet.
Delete any fields that have no data in them (TissueSample.sampleID, Survey.comments, etc.).
Sometimes if one thing is off in the spreadsheet, it cascades into other strange issues for the rest of the import so I want to make sure we’re covering all bases here.
Let me know if it’s still creating weird Occurrence IDs after following the steps above.
Sorry, I should’ve clarified earlier that committing the import means that we’ll be able to see it and debug it on our end!
It’s interesting that the first two entries from the new import have the encounter ID appear normally, but the rest show up weird. Can you also email me the new spreadsheet to services@wildme.org?
OK, it looks like Excel may be this issue, not Flukebook.
Sometimes when Excel is being funny about cell formatting, it can help to export it as a CSV, then open the CSV file in Excel and then save it as an Excel file again. You should then be able to re-import that file without any formatting issues.
