Continuing the discussion from CSV Import error messages:
With the enabling of the EXEC function, CSV Import now operates as expected without throwing errors. However, I have not been able to import files via public URL. I seek guidance and help.
Context
CSV Import does successfully import all records in my .csv file, demonstrated by many attempts where the URL field is not indicated as a “file” field. In these attempts, all records are imported properly, including the URL field which imports as a line of text.
However, when I checkbox “file” for the URL field, in every attempt job fails. The Status tab job list displays “Import Error” with zero items imported or skipped.
I have confirmed that the URL in the field does point to a permanent, publicly visible location, by first pasting into my browser address bar and next typing it into the address bar of a completely stand-alone computer.
But… here’s the twist my desired URL points to files in a subdomain created in my primary Reclaim server instance which hosts Omeka. As a test, I created a new .csv file with a URL field pointing to a similar subdomain in another Reclaim server instance, which I also manage. This test worked normally, uploading the file from this other subdomain. So the problem is not CSV Import, but likely with permissions or certificates. It is confounding that the URL can be shown to be permanent and public, but CSV Import fails anyway.
Here’s another twist: when I run CSV Import on my secondary Omeka instance, pointing to the primary Reclaim subdomain, it works fine. So: it is not CSV Import or file permissions, but something about how the subdomain is provisioned. Importing from a similar subdomain on the secondary instance works fine too. Why is the behavior different?
Request
I have verified that my CSV file and the URLs in the file comply with all requirements in the documentation. But, there is different function in one subdomain.
- How can I get more detail about “Import Error” thrown by CSV Import?
- What settings or other actions can I take to get CSV Import to operate normally to import from valid public URLs?
- What do I need to change on my Reclaim sub-domain?