Unable to import points from CSV by any method

[kylie-m]

No longer able to import points using a CSV file, which previously worked.

Trying to upload a CSV file, the following error message appears: “There are errors in the dataset that needs to be fixed before you can upload.”

It is possible to upload points using the paste CSV function, either from Spatial or starting from ALA Sandbox and moving across to SP.

---

update 25/11/22 I'm aware this is a deprecated feature now, but believe it was still meant to work using the 'paste CSV' function, and/or by using ALA Sandbox. I found that the upload stopped at 25% for all 4 methods.

Given that our users find this feature useful in their work, could we please aim to fix so that at least one of the methods to import points from CSV works?

Raised by user: https://support.ehelp.edu.au/a/tickets/156585

[kylie-m]

Raised by a second user: https://support.ehelp.edu.au/a/tickets/162977

[timhicks-ala]

Additionally raised in https://support.ehelp.edu.au/a/tickets/166570

[timhicks-ala]

Some investigation. It appears impossible to use the Import -> Points tool in Spatial, which means it's impossible to run AOO/EOO analysis on uploaded data. Neither uploading a file and pasting CSV data works as in both cases, the process fails at 25%.

Strangely, if you then try and run an AOO/EOO and "Use imported points", the failed uploads will appear in the list. Note that a test CSV with four records in it shows as having 5 occurrences - possibly it's counting the header row as a record here:

In either case, the AOO/EOO fails, stating no occurrences were found in the defined area, despite the area having been left as the default World:

If I attempt to paste just the four lines of CSV with records in them, ignoring the header row, it still fails, but at 50% instead of 25%, and the list of imported points shows an entry with 4 records in it:

So:

• The process to upload points to Spatial is failing, affecting at least AOO/EOO and any other tools that rely on it
• Despite failing, it still records the upload as successful, in terms of adding that upload to a list of points available
• That list is unusable for some reason

[sat01a]

Assigned to @adam-collins

[adam-collins]

SOLR was down. Also CSV import is working again for me in Chrome. Pasting data still works.

[sat01a]

Closing the issue. @adam-collins confirmed it works