Thank you! That is it. We have added a lot of validation to the spreadsheet, so redoing that every update would take a lot of work. But we can certainly do a diff for any column header changes. Thank you everyone for all your help!
-Olivia On Wed, Oct 26, 2022 at 1:07 PM Valerie Addonizio <vaddoni...@atlas-sys.com> wrote: > Hi Olivia! > > > > Are you on the most recent version of ArchivesSpace and have you > refreshened your import spreadsheet with the most recent template? > https://github.com/archivesspace/archivesspace/tree/master/templates or > accessible from inside ASpace from Gear Menu --> Bulk Import Templates. > > > > Using that version linked above, I would use Column D, *res_uri*, which > takes the URI that you already identified at the top of the resource > record, something similar to /repositories/2/resources/42. I find that > column much more user friendly. > > > > I am not sure that you strictly need *the* most recent version of AS for > that template to work, but I would consider updating your templates every > time you update ASpace itself. > > > > -Valerie > > > > > > *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org < > archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of *Olivia > S Solis > *Sent:* Wednesday, October 26, 2022 11:40 AM > *To:* Archivesspace Users Group < > archivesspace_users_group@lyralists.lyrasis.org> > *Subject:* Re: [Archivesspace_Users_Group] collection_id/Resource > Identifier in import spreadsheet > > > > Well, we definitely have successfully used the EAD ID field value to link > via column C in the spreadsheet importer for a long time. We have a > specific use case where we want to add lines of inventory to a resource > before we assign the EAD ID. Our EAD ID and the value of what is in > Identifier are not the same. I'm having trouble figuring out in what form > the plugin wants info in column B. :( > > > > On Wed, Oct 26, 2022 at 10:24 AM Lisa Calahan <lcala...@umn.edu> wrote: > > I wonder if the identifier needs to match the data in the EAD ID field > within the Finding Aid Data subrecord? I had an issue with that before and > it solved my problem, but I'm not using the Harvard spreadsheet. > > > > Might be worth a try, though? > > Lisa > > > > On Wed, Oct 26, 2022 at 8:58 AM Olivia S Solis <livso...@utexas.edu> > wrote: > > Our identifier is all in the first box. We have an autoincrement system > that works just there. Would the dashes cause problems? > > > > On Wed, Oct 26, 2022 at 8:54 AM Leah Tams <leah.t...@duke.edu> wrote: > > Hi Olivia, > > > > I wonder if the identifier should actually appear with periods, rather > than hyphens, between the elements? That is how we input them in our import > spreadsheet at Duke. They appear as RL-12345 in ASpace, but in the > spreadsheet we have to put RL.12345. I don’t have access to our database, > though, so I’m not sure what they look like on that end. > > > > Best, > > Leah > > > > *she/her/hers* > > MSLS in Archives & Records Management > > Accessions Coordinator > > Rubenstein Rare Book & Manuscript Library > > Duke University > > leah.t...@duke.edu | leahtams.org <http://www.leahtams.org/> > > > > *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org < > archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of *Olivia > S Solis > *Sent:* Wednesday, October 26, 2022 9:43 AM > *To:* Archivesspace Users Group < > archivesspace_users_group@lyralists.lyrasis.org> > *Subject:* [Archivesspace_Users_Group] collection_id/Resource Identifier > in import spreadsheet > > > > Hello all, > > > > We have been using the spreadsheet importer for bulk adding archival > objects for years, using the EAD ID column to link to the correct resource. > We had a situation pop up where we may not have that number assigned yet, > but we want to upload part of the inventory. I tried using column B > (collection_id/Resource identifier) to link to the right resource. > > > > I don't know what I am doing wrong, but I can't get the AOs to get created > with column B. The documentation in the original Harvard spreadsheet (which > we still use a version of because of a lot of customization added) defined > the field like so: "The Resource "Identifier", aka collection-level > unit_id, OR, could be internal resource record number from URL." > > > > I keep getting the following error: Row 6: ERROR Row 6 will not be > processed due to errors: This row is missing BOTH an EAD ID and URI > > I tried the Identifier field: > > [image: Screen Shot 2022-10-26 at 8.34.36 AM.png] > > I tried it as it appears in the database: "camh-arc-004438", null,null,null > > I tried the path given in the URI: > > [image: Screen Shot 2022-10-26 at 8.34.50 AM.png] > > And I tried just the numeric ID, in the case above 4398. > > > > What am I doing wrong here? I can't think of many other identifiers that > are unique to the record. > > > > Thanks, > > Olivia > > > > -- > > 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 > > _______________________________________________ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > >> This message is from an external sender. Learn more about why this << > >> matters at https://links.utexas.edu/rtyclf. << > > > > > -- > > 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 > > _______________________________________________ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > > > > > -- > > Pronouns: she/they > > Head of Archival Processing > University of Minnesota Libraries > Archives and Special Collections <https://www.lib.umn.edu/special> > Elmer L. Andersen Library > > > > *I acknowledge that the University of Minnesota is located > <https://editions.lib.umn.edu/openrivers/article/where-we-stand/>on the > traditional, ancestral and contemporary lands of Indigenous people > <https://mcae.umn.edu/sites/mcae.dl.umn.edu/files/styles/panopoly_image_original/public/media/dakhota_thomakhoche.jpg?itok=SoL5V45r> > and > was built with money from slaveholders > <https://www.jbhe.com/2019/11/the-university-of-minnesotas-historical-ties-to-slavery/>. > * > > _______________________________________________ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > >> This message is from an external sender. Learn more about why this << > >> matters at https://links.utexas.edu/rtyclf. << > > > > > -- > > 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 > _______________________________________________ > Archivesspace_Users_Group mailing list > Archivesspace_Users_Group@lyralists.lyrasis.org > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > >> This message is from an external sender. Learn more about why this << > >> matters at https://links.utexas.edu/rtyclf. << > -- 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
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group