batch import from excel

Baldrick

I haven't yet found a way to import a very simple excel (eg object id, title, description, notes).

Anyone knows how to directly import it without any extra schema descriptions ?

It seems like a really simple task, but I did not find a solution in the documentation (or in the chat)...

VaclavCerny

Hello,

you shoul read about import mappings ( https://manual.collectiveaccess.org/import/mappings.html )

Usually its much simpler than it looks.

Here you can see one import mapping i have made recently with relevant data. It will not work on your installation, because you have different metadata attributes, values and types.

https://zidovskemuzeum-my.sharepoint.com/:f:/g/personal/vaclav_cerny_jewishmuseum_cz/ErdB-4LxLcNPo54TOaOJbI4BjOujNpn64Mw2064ae6Ekcg?e=HFMwos

I usualy debug my mapping on testserver from console ( import mapping && import data using mapping && display log ) using something like

support/bin/caUtils load-import-mapping -f /mnt/mappings/mapping.xlsx && support/bin/caUtils import-data -m mapping_name -s /mnt/importdata/data.xlsx -f xlsx -d DEBUG -l /tmp && cat /tmp/log_2022-05-24.txt

Baldrick

Thanks VaclavCerny I wil give it a try!