Adding Files skips items in a csv import on Omeka Classic

[michaelcarrier]

I am trying to do a csv import to include files. All of the files will come from a museum’s host website. Most of the url’s look like this
“https://files.ingeniumcanada.org/items/coll/54/877/1987-0871-001-aa-cs.jpeg”

This usually leads to all items getting skipped in the end.

And from what I understand, jpeg is an allowed format

So why are these items getting skipped? Not uploading the files, and uploading everything else works like a charm, but trying to import the files as well leads to all of them getting skipped.

[fackrellj]

Hi @michaelcarrier ,

Did you happen to check the box on the import form to indicate the field is a file that should be imported?

If so, there are a couple of things that could be happening if it’s still not imported the images. You might need to check logs or just simply try manually adding an item with media.

[michaelcarrier]

Yes, of course. I check that box.

When I don’t check it, The rest of the data gets imported. If I do check it, it seems to try to import those files, fails, and skips them.

I noticed you tried the url yourself, did you have any luck? (thanks for trying!)

[fackrellj]

Yes, it worked perfectly for me and I just tested on a pretty basic installation of Omeka Classic.

Did you try manually adding the item and uploading the item? I’m wondering if you ImageMagick installed and configured properly in your settings. I feel like this could prevent your images from being imported. If that’s working outside of the CSV import, I wonder if your server might have disabled PHP functions or network calls for retrieving remote URL’s.

[michaelcarrier]

Yes, manually adding the files works just fine. It is unfortunately just not the solution for a plan with many csv string.

I’ll see if we have ImageMagick, or if PHP functions are disabled, (or network calls)

Thanks for the tip

[fackrellj]

Hi @michaelcarrier ,

I’m just curious if you ever got this working and what the problem was or are you still troubleshooting?

[jflatnes]

The most common situation here that’s going to cause skipping is if the URL can’t be loaded. You’ve shared an example URL, but sharing the CSV, or a pared down version of it (even a single row) might be the best way to confirm or narrow down the problem, if the problem lies in the CSV.

In terms of seeing what’s going on yourself in more detail, if you have error logging turned on (see the “Activate Error Logging” section of that link) then CSV Import should log a message when it skips a row and indicate why.

[michaelcarrier]

Thanks for the replies.

It actually works just fine. It just happened to be an issue with the server’s firewall.

All is well. The CSV import works just fine for files.

Cheers