import cancellation

[ElsaZakhia]

Dear all,

I'd like to know if it is possible to cancel a csv import or if there is a kind of prevalidation?

Thank you for your helpful answers,

Elsa

  Elsa Zakhia
   Archives de la Bibliothèque Orientale

   Tél :– Mobile : 00 961 3 081 706

   B.P. 17-5208 Mar Mikhael - Beyrouth 1104 2020 – Liban

  www.bo.usj.edu.lb  -

[Johan Pieterse]

Hi Elsa

No easy way

Restart mysql or php8.3 servise

service mysql restart

service php8.3-fpm restart

Johan

--
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 visit https://groups.google.com/d/msgid/ica-atom-users/c90b9b78-9b7c-4c36-b0ce-adf9127abfc2n%40googlegroups.com.

Johan Pieterse
082 337-1406

[Johan Pieterse]

But it could break the database

Johan Pieterse
082 337-1406

[Dan Gillean]

Hi Elsa, 

Johan is right, there is currently no great way to cancel an in-progress import without potentially causing data corruption (i.e. incomplete rows in your database that can lead to unexpected problems). However, you also asked about pre-validation.

AtoM does have a CSV validation service that is supported both as a separate test, and as a setting you can apply to run automatically before every CSV import. You can also run either from the command-line or  via the user interface. See: 

• https://www.accesstomemory.org/docs/latest/user-manual/import-export/csv-validation/

For adding it to CSV import attempts in the UI automatically, see this administrative setting: 

• https://www.accesstomemory.org/docs/latest/user-manual/administer/settings/#csv-validator-settings

NOTE: It is a bit hard to use the Strict mode, because warnings are generated for many valid events - for example, if your import will be creating a new repository record or a new authority record, that triggers a warning (just to ensure this is intentional). To avoid such warnings blocking your import, using Permissive mode allows for warnings but will cancel the import if any errors are detected. Additionally, if the import does proceed, warnings are still visible in the job details log. 

Cheers, 

Dan Gillean, MAS, MLIS
Business & User Experience Analyst
Artefactual Systems, Inc.
604-527-2056

he / him

--