[Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer

Mon Mar 28 14:09:40 EDT 2022

Hello Olivia,

During our ASpace implementation, Atlas helped us play around with trying to add labels to notes using the spreadsheet. We came to the conclusion that it is not possible.

Would be happy if someone proved me wrong though!
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 Olivia S Solis
Sent: Monday, March 28, 2022 1:38 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer

Hello all,

A couple months ago, I similarly wanted to import a value in the Label field along with the content of a General Note. I tried with a column header of n_odd_label to see if this would work, but it did not. I posted to this group, but did not get a response. The error I got read:
Row 6: ERROR ["Note Type 'odd_label' is not supported"]

Is there a different way to do this?

Thanks,
Olivia

On Mon, Mar 28, 2022 at 12:20 PM Anna Haywood <ahaywood at cca.qc.ca<mailto:ahaywood at cca.qc.ca>> wrote:
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://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F%3Futm_source%3Dfr_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U81UEB5i69rTL4M%2BL8%2BQ9tr4KaKL5Q8Y7viWysbviKk%3D&reserved=0>
Twitter<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.twitter.com%2Fccawire&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=depDhsH8Je%2FrY9LnNALr8Zl4b39Zfxa3tWRdfVH4mJ8%3D&reserved=0> | Instagram<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fcanadiancentreforarchitecture%2F&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=taivbLmE0diFBpoAZHoLT8rx0z7imeGwsjP3UJIrB3A%3D&reserved=0> | Facebook<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fcca.conversation&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=AjfbIeaU4ZjGuc0NPycyz1%2FX4JLot%2FxHjYiBbdVeIl4%3D&reserved=0> | YouTube<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fuser%2FCCAchannel&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=nqN3764nc8JK6qZYHWHP5Sw9PXiSdrne9JP7IyvjswY%3D&reserved=0>

Comment comprendre les liens que nous entretenons avec les processus coloniaux?<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F83986%2Fterritoires-vivants&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=NvwwAkE%2Fcqw%2FAqe9DsaL6%2FYUnSUpjTbZhKyK9mG1dfc%3D&reserved=0>
How can we understand the broader connections we have to settler colonial processes?<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Fen%2F83986%2Fliving-lands&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=4DMQX%2FB%2B0TXAkFGBvNwVu8W8Xj1fWXnijROPFluH30E%3D&reserved=0>

Inscrivez-vous<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F%3Fgo%3Denews%26utm_source%3Dfr_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ytzSdayMw9JkhDXo%2B4wxP0DXyApTRgb703tXOa9nSpo%3D&reserved=0> pour recevoir de nos nouvelles.
Sign up<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Fen%2F%3Fgo%3Denews%26utm_source%3Den_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803591572%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=inKS438tZxEccMZEHtOnYHWyCSbgyEAkocSu27S382s%3D&reserved=0> to get news from us.
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto: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<mailto: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

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803591572%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=MhpEJE1rCwMSpfzHIjyJ4%2BE%2Fu0aUB7Py04H2Ukn6NDY%3D&reserved=0>

--
Olivia Solis, MSIS (she/her)
Metadata Coordinator
Dolph Briscoe Center for American History
The University of Texas at Austin
2300 Red River St. Stop D1100
Austin TX, 78712-1426
(512) 232-8013
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220328/1851b760/attachment.html>