[Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer

[Anna Haywood]

Hello Bri,

You can definitely do this. We have added lots of extra columns to our spreadsheet (particularly for notes that weren't already there. You just need to copy the exact same format as the previous columns for the ArchivesSpace field codes found in Row 4. One column has the note contents and the other has the publish yes or no value. The field codes follow the format n_[note type] for note contents and p_[note type] for publish true/false. For the [note type], you must use the exact value (and not the translation) for that note type, found in the ASpace Controlled Value Lists: Note Singlepart Type (note_singlepart_type) or Note Multipart Type (note_multipart_type).

For instance, if you wanted to add columns for the note type Accruals: Add 1 column with the ArchivesSpace field code n_accruals and add 1 column with the ArchivesSpace field code p_accruals.

Best,
Anna




---

Anna Haywood
Archiviste
Archivist

Centre Canadien d'Architecture
Canadian Centre for Architecture
1920, rue Baile, Montr?al, Qu?bec, Canada, H3H 2S6
+1 5149397001x1368
cca.qc.ca<https://www.cca.qc.ca/fr/?utm_source=fr_email_signature&utm_medium=email>
Twitter<https://www.twitter.com/ccawire> | Instagram<https://www.instagram.com/canadiancentreforarchitecture/> | Facebook<https://www.facebook.com/cca.conversation> | YouTube<https://www.youtube.com/user/CCAchannel>

Comment comprendre les liens que nous entretenons avec les processus coloniaux?<https://www.cca.qc.ca/fr/83986/territoires-vivants>
How can we understand the broader connections we have to settler colonial processes?<https://www.cca.qc.ca/en/83986/living-lands>

Inscrivez-vous<https://www.cca.qc.ca/fr/?go=enews&utm_source=fr_email_signature&utm_medium=email> pour recevoir de nos nouvelles.
Sign up<https://www.cca.qc.ca/en/?go=enews&utm_source=en_email_signature&utm_medium=email> to get news from us.
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of McLaughlin, Brianna Jean
Sent: Thursday, March 24, 2022 4:38 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer

Hi everyone,

Does anyone know if it's possible/ advisable to add columns to the spreadsheet template? For example, there are not columns for Note Labels in the spreadsheet even though the fields exist in ArchivesSpace.

Thanks!

Bri McLaughlin, she/her/hers
Visiting Metadata Services Librarian
Indiana University
812-856-3321

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220328/be789140/attachment.html>