[Archivesspace_Users_Group] Importing and linking Top Containers via Spreadsheet?

[Hand, Sarit]

Hi,
I am attempting this now and I got the error that I am missing an EAD ID. However, we do not use EAD IDs, plus the instructions do not indicate it is required. IT does clearly state that ONLY the archival object ID is used in the upload.

One issue not addressed, if I want to link/create new multiple top containers to one archival object record.

Not sure what you are missing, consider sending your spreadsheet so someone can look it over. Did you delete any rows you shouldn't have? Did you include the required data for creating new top containers and/or use the correct ID numbers?

Hope someone can help on this. Will be checking JIRA tickets to see if there are any reports on this feature.

Cheers,

[cid:image001.png at 01D9412D.60101220]

Sarit Hand
Digital Archivist
AP Corporate Archives
200 Liberty Street
New York, NY 10281
T 212.621.7035

shand at ap.org<mailto:shand at ap.org>
ap.org<http://www.ap.org>
[cid:image002.png at 01D9412D.60101220]


From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Julie Swierczek
Sent: Monday, February 6, 2023 3:27 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Importing and linking Top Containers via Spreadsheet?


[EXTERNAL]
Has anyone successfully used the ArchivesSpace 3.0+ bulk import of top containers? I have followed the instructions here: https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2457075717/Importing+and+Linking+Top+Containers+via+Spreadsheet<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F2457075717%2FImporting%2Band%2BLinking%2BTop%2BContainers%2Bvia%2BSpreadsheet&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GmuNWpI9Duq5nJOkIHRlCHrilGOf6fuUlKcvJrzR9y8%3D&reserved=0>. I've tried importing as .xslx and .csv, but I always get the same error: "Skipping creation and linking of top containers due to errors."

The instructions page says "A detailed note will appear in the Background Jobs page with the reason for failure", but the error message isn't particularly helpful.

I'm running v.3.3.1. I've tried the usual - using LibreOffice while working with spreadsheets, making sure the cells are formatted as text, etc. I'm wondering if I'm missing some other magic that someone else has figured out? Some of my box numbers include dashes and parentheses - are there any known restrictions on character types in these fields? Or do I need to sacrifice a paper clip under a full moon before running the upload?

Any advice would be greatly appreciated!

Julie

----
Julie C. Swierczek (SWER-check)
Associate Librarian for Collection Description and Imaging
jswierczek at folger.edu<mailto:jswierczek at folger.edu> | She/her/hers
Folger Shakespeare Library | 201 East Capitol Street SE, Washington, D.C. 20003
www.folger.edu<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.folger.edu%2F&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FXbZnnNjN0Nio7YkXA6lLp2MNhPwAXGVBeoYemh6z%2Bw%3D&reserved=0> | Follow us on Facebook<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Ffolgershakespearelibrary&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dxaPP2qK%2Fd%2BcHkBlBsIT0Mlk%2BT%2BnEmNRdHNrHBIYNxs%3D&reserved=0>, Twitter<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Ffolgerlibrary&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=VtKUGBjb5V52SQu8Z0eH2PmT1P0%2FxyGlRA3EVW%2F6JZE%3D&reserved=0>, and Instagram<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Ffolgerlibrary%2F&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rQFuPAlOhEluU1bcnqri8o2d%2F1Vp1CI%2FzLq5lqnlTOY%3D&reserved=0>


The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230215/1628eb0f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1094 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230215/1628eb0f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5548 bytes
Desc: image002.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230215/1628eb0f/attachment-0001.png>