archivesspace / archivesspace

ArchivesSpace, the archives management tool
http://archivesspace.org/
Other
355 stars 227 forks source link

Bulk import via spreadsheet fails when not using EN locale #2337

Open dvhassel opened 3 years ago

dvhassel commented 3 years ago

When using the bulk-import-template with eg a French locale, the import fails. The importer can't find the archival_record_levels:

ERREUR Introuvable: 'Series' ne figure pas dans la liste archival_record_level; Manquant valide niveau Description
ERREUR Introuvable: 'Sub-Series' ne figure pas dans la liste archival_record_level; Manquant valide niveau Description
ERREUR Introuvable: 'Item' ne figure pas dans la liste archival_record_level; Manquant valide niveau Description

Expected Behavior

The import template works regardless the locale used

Current Behavior

The import fails when not using the EN locale

Possible Solution

Modify the archival_record_levels in the XSL or CSV to the (in my case) French translations:

Better would be to modify the template and have the controlled value lists use the Values instead of the Translations (use 'item' instead of Item/Pièce, 'subseries' instead of Sub-Series/Sous-série, ...

Steps to Reproduce (for bugs)

  1. Change the locale to FR
  2. Prepare the bulk import XSL
  3. Try to import

Context

Your Environment

rvdb commented 5 months ago

It's been some time since this issue had been reported; I don't know if it has been addressed in the mean time (I'm just reporting from a user perspective). Yet, testing with ArchivesSpace-4.3.1, I'm observing different (and I think better) behaviour. The CSV importer now seems to accept either:

I've tested with different standard ArchivesSpace languages, and behaviour seems consistent.

Important: it's the language configured in the config file that's being used for the controlled value label lookups, regardless of which language has been set in the application.

This definitely looks like an improvement to me: both keys and labels are accepted (if the values can be found in the locale set in the config file).