[Archivesspace_Users_Group] Digital Object CSV & Overlay

[Noah Huffman]

Carolyn, Chris,

Mostly a weird dream, but I’ve seen examples of some scripts that interact with the API to allow batch editing of records with CSV.

Here is one simple example that will batch add a repository processing note to archival objects based on the object’s ref_id.  The input file is a two-column TSV (ref_id | repository processing note text) : https://github.com/noahgh221/archivesspace-duke-scripts/blob/master/duke_archival_object_metadata_adder.py

You could easily swap out repository processing notes with any other metadata field you want to update.

This script is almost entirely based on another script that some folks at the Bentley (U. Michigan) wrote, which batch creates Digital Objects and links them as instances of existing archival objects based on CSV input: https://github.com/djpillen/bentley_scripts/blob/master/update_archival_object.py

Chris, this last one replicates functionality of the BatchDO plugin that Nathan Stevens wrote for AT: http://archiviststoolkit.org/node/246

-Noah


From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Runyon, Carolyn
Sent: Tuesday, April 26, 2016 9:00 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Digital Object CSV & Overlay

Even if it’s a weird dream, I think it’s worth pursuing! Batching editing records with a CSV export/import option is a solid idea that could be really useful beyond digital objects. Being able to batch edit some top level metadata for accession, resources, etc. would also be incredibly useful.

Carolyn

Carolyn Runyon
Assistant Head of Collection Services and Director of Special Collections
University of Tennessee at Chattanooga Library
615 McCallie Ave., Chattanooga, TN  37403
Carolyn-Runyon at utc.edu<mailto:Carolyn-Runyon at utc.edu>, (423) 425-4503
Dept. 6456, LIB 439D

On Apr 25, 2016, at 12:21 PM, Chris Fitzpatrick <Chris.Fitzpatrick at lyrasis.org<mailto:Chris.Fitzpatrick at lyrasis.org>> wrote:


There was some talk ( like since forever?) about a spreadsheet plugin that would do this? Or maybe does do this?

If I recall, it was based on something someone made for AT. It would create a CSV export of object ids and their associated URLs and allow people to update the URLs and put it back in?

Did someone make this or was it a weird dream i had?

Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.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 Brian Hoffman <brianjhoffman at gmail.com<mailto:brianjhoffman at gmail.com>>
Sent: Monday, April 25, 2016 6:17 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Digital Object CSV & Overlay

No. I believe as of now you need to write your own code if you want to automate this.


On Apr 25, 2016, at 11:10 AM, Suda, Phillip J <psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>> wrote:

Good morning,

If you import Digital Object information via CSV, can/will this update/overlay existing records?

We would like to update file version information for Digital Objects post-migration (as a lot of Digital Objects were not linked, etc.).

Thank you,

Phil

Phillip Suda
Systems Librarian
Howard-Tilton Memorial Library
Tulane University
psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
504-865-5607

_______________________________________________
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

_______________________________________________
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160426/1bcb96c3/attachment.html>