[Archivesspace_Users_Group] MARC XML import

Tue Jan 24 13:14:01 EST 2023

Hi Sarah,

Following up on Brian’s suggestion that your 008 looks short—depending on how your MARC-XML is being created, you may want to make sure that the blanks aren’t being collapsed by some sort of whitespace normalization setting. I know I’ve run into this with oXygen before.

Hope this helps,

Regine

Regine Heberlein (she/her)
Library IT Data Analyst
609-258-6156
heberlei at princeton.edu<mailto:heberlei at princeton.edu>

**My working day may not be your working day. Please do not feel obliged to reply to this email outside of your normal working hours.**

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of "Newhouse, Sarah" <snewhouse at sciencehistory.org>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Tuesday, January 24, 2023 at 12:32 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] MARC XML import

Aha! Thank you. I’ll investigate 008 with our cataloging librarians.

__________________________________

Sarah Newhouse   (she, her, hers)
Digital Preservation Archivist
Othmer Library of Chemical History
t. +1.215.873.8249

Science History Institute
Chemistry • Engineering • Life Sciences
315 Chestnut Street • Philadelphia, PA 19106 • U.S.A.
Learn about the scientific discoveries that changed our world at sciencehistory.org/learn<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sciencehistory.org%2Flearn&data=05%7C01%7Cheberlei%40princeton.edu%7C6d2c84b6ab324b96040208dafe30d1e6%7C2ff601167431425db5af077d7791bda4%7C0%7C0%7C638101783624829131%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=IezoHWBx2gb2LQVsCl0wXdsjfE2JD7yZwQtAqfY5dJI%3D&reserved=0>
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Brian Harrington
Sent: Tuesday, January 24, 2023 11:13 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] MARC XML import

Hi Sarah,

  1.  The MARCXML importer gets the language from 008/35-37.  I’m not sure what happened to it, but the 008 in your record looks short.  Looking at the code, if the language positions are blank the language is set to undefined.  But that would only work if there are actual blanks in those positions.
  2.  Underneath the error messages, you can see a representation of the JSON record that ASpace is trying to load.  If you look at “notes”=>, the first one (position 0) has an empty "subnotes"=>[{"jsonmodel_type"=>"note_text"}].  You can see this is an odd note with a label of “Publication date”.  In this case, ASpace is trying to create a date note from the 260$c, which is blank in your case, so the it creates a bad note.  However, it’s only trying to create that note because it can’t get the date from the 008.  ASpace only recognizes 008 dates if 008/06 is an i, k, or s, and you have a q there.  It probably should recognize the q, but the quick fix would be to change that to an i or an s.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harrington at lyrasis.org<mailto:brian.harrington at lyrasis.org>

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 Newhouse, Sarah <snewhouse at sciencehistory.org<mailto:snewhouse at sciencehistory.org>>
Date: Monday, January 23, 2023 at 5:05 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] MARC XML import
Hi all,

I would really appreciate another set of eyes on these two errors I’m getting while testing ingest of MARC XML (resource records) from our library catalog into 3.2:

  1.  lang_materials/0/language_and_script/language : Property is required but was missing
I’ve tried a few different things here and can’t pinpoint the problem. There isn’t a MARC field that maps to this ASpace field in the most recent import map<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1jU6MYF7UI7a-UKdd5XhYCV6W1UyrMMCzYDFlgb8iNW8%2Fedit%23gid%3D1527709562&data=05%7C01%7Cheberlei%40princeton.edu%7C6d2c84b6ab324b96040208dafe30d1e6%7C2ff601167431425db5af077d7791bda4%7C0%7C0%7C638101783624829131%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=VamRLTWcYiAumBGh1onvAT%2B43KdyFfNosb1wn1l6iAQ%3D&reserved=0> (unless I’m misreading it, which is entirely possible – it’s been a long day), but native ASpace resource records exported as MARCXML will import back in with language and script data, so I can tell there is a MARC field that maps to this. Based on MARC XML from resource records created in ASpace, I tried adding language info in 040$a or 041$b, but neither resulted in a successful import, just the same error message. Is there a MARC field I’m missing in the import map and/or the ASpace-generated MARC? The Help Center<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F917405730%2FLanguages%2BSub-Record%2Bas%2Bof%2Bv2.7.0&data=05%7C01%7Cheberlei%40princeton.edu%7C6d2c84b6ab324b96040208dafe30d1e6%7C2ff601167431425db5af077d7791bda4%7C0%7C0%7C638101783624829131%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=bMjCBZC%2BXbexQUHTatdgXfoTJVvdka%2FOeUkJQVmnqCI%3D&reserved=0> does say this field can be imported as MARC XML, but doesn’t say how.
  2.  notes/0/subnotes/0/content : Property is required but was missing

I see that other folks have encountered this error with an index number to point them to the note that’s missing content, but lacking one here I’m not sure where to start. And looking at my sample files with my fallible human eyes I don’t see any empty fields. Has anyone run into this before? Is this just pointing at my missing language field?

If there’s a resource or guide I’ve missed – especially for interpreting import job errors -- please point me to it! MARC XML is attached (with the added 040 and 041 fields) in case it’s helpful.

Thank you!

__________________________________

Sarah Newhouse   (she, her, hers)
Digital Preservation Archivist
Othmer Library of Chemical History
t. +1.215.873.8249

Science History Institute
Chemistry • Engineering • Life Sciences
315 Chestnut Street • Philadelphia, PA 19106 • U.S.A.
Learn about the scientific discoveries that changed our world at sciencehistory.org/learn<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sciencehistory.org%2Flearn&data=05%7C01%7Cheberlei%40princeton.edu%7C6d2c84b6ab324b96040208dafe30d1e6%7C2ff601167431425db5af077d7791bda4%7C0%7C0%7C638101783624829131%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=IezoHWBx2gb2LQVsCl0wXdsjfE2JD7yZwQtAqfY5dJI%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230124/d8f59293/attachment-0001.html>