[Archivesspace_Users_Group] Importing Accessions CSVs - linking agents and resources

[Lora Woodford]

Hi Carly,

The current accessions CSV import is limited to the columns that exist in the csv template, and, as such, does not support the type of workflow you describe.  Rightly or wrongly, it definitely assumes that you are using the CSV importer to import wholly new records and new linked/associated records (in the case of subjects and agents, at least).  It does not support importing classifications and links to related resources.

I’ve done very little with the csv imports so I’m not sure how difficult it would be to extend the functionality to accomplish what you want, but would encourage anyone to chime in here with advice if you have done so (or attempted to do so and scrapped the idea!).  Given the fact that I haven’t seen any examples of folks doing this work (correct me if I’m wrong!), I suspect it is rather tricky.

There are many more examples out there of folks associating existing linked records to one another using the ArchivesSpace API.  A great resource to start learning how this project might be accomplished using the API is the ArchivesSnake repository in GitHub (a readme begins after you scroll past that list of files):  https://github.com/archivesspace-labs/ArchivesSnake

 Hopefully others will chime in with additional advice.

Best,

Lora

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of "Bogen, Carly (Records)" <CBogen at records.nyc.gov>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Saturday, November 17, 2018 at 12:13 PM
To: "archivesspace_users_group at lyralists.lyrasis.org" <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Importing Accessions CSVs - linking agents and resources

Hi all,

Is there a way to use the accessions CSV import to link the new accession being created to agents, resources and classifications that already exist in the repository?

We'd like to be able to add an existing agent uid to a field in the spreadsheet, include a role, and have that automatically link. Same for resources and classifications, only without the role.

I can't seem to figure out how to make this work.

Thanks for your help! And sorry for the cross-post – this list seems a bit more active than the Google group.

-Carly
____________________________________________________________________
Carly Bogen | Manager, Digital Programs
Department of Records and Information Services (DORIS)
31 Chambers Street, New York, NY 10007
P: 212-341-6029  | E-mail: cbogen at records.nyc.gov<mailto:cbogen at records.nyc.gov>
[mailBanner]<http://nyc.gov/records>
Follow us on:
[acebook]<http://facebook.com/nycrecords>  [witter] <http://twitter.com/nycrecords>   [umblr] <http://nycrecords.tumblr.com/>    [outube] <http://youtube.com/NYCDeptOfRecords>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1072 bytes
Desc: image001.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 660 bytes
Desc: image002.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 354 bytes
Desc: image003.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 661 bytes
Desc: image004.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 673 bytes
Desc: image005.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181217/1db541e8/attachment-0003.jpg>