500 Error after CSV update

[JPL Archives]

Hi there! I'm wondering if anyone else has encountered this same issue,

I attempted to update existing records via CSV import (selected "Ignore matches and create new records on import"). Per the Manage>Jobs page the import was successful. However, I am unable to view any records in the Fonds that was updated. That is, the Fonds and files appear when I search for them, but clicking into them yields a 500 Internal Server Error.

Appreciate any guidance, and any other tips on updating existing records via CSV!

[Dan Gillean]

Hi there, 

First, any time you encounter a 500 error, the first thing we recommend is to get more information by looking for the full error message in the web server logs. If you don't have access to the server backend, you may need to ask a system administrator to get this. See: 

• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/logging/#web-server-logs
  

Once we have the full error message, we can provide more detailed suggestions. That said....

Choosing "Ignore matches and create new records on import" is not an update to existing records - it's explicitly telling AtoM the opposite. You're telling it that even if all matching criteria are met, ignore the match and treat these as new records. If you want to update existing records in AtoM via a CSV update, then you should likely be using the "Update matches ignoring blank fields in the CSV" option. See: 

• https://www.accesstomemory.org/docs/latest/user-manual/import-export/csv-import/#update-matches-in-place
  

That said, making updates in a single system (i.e. roundtripping - exporting a CSV, making some changes, then importing it as an update) is unfortunately poorly supported at the moment in AtoM. For more background on how the matching logic works currently and why, as well as some workaround options for improving local roundtripping efforts, please see: 

• https://groups.google.com/g/ica-atom-users/c/HMoN4tEuJ10/m/n4e1gqftBQAJ
• Same info, but another version: https://groups.google.com/g/ica-atom-users/c/bCWYFIkLCRs/m/7QTPfLnQAQAJ 

Hopefully that helps future attempts, and with more information we can help you resolve the current 500 error!

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/5455d0c1-b00e-4365-9c00-5a26e26f3ac4n%40googlegroups.com.