<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.il
{mso-style-name:il;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi Carly,<br>
<br>
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.<br>
<br>
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.<br>
<br>
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): <a href="https://github.com/archivesspace-labs/ArchivesSnake">
https://github.com/archivesspace-labs/ArchivesSnake</a> <br>
<br>
Hopefully others will chime in with additional advice.<br>
<br>
Best,<br>
<br>
Lora<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of "Bogen, Carly (Records)" <CBogen@records.nyc.gov><br>
<b>Reply-To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Saturday, November 17, 2018 at 12:13 PM<br>
<b>To: </b>"archivesspace_users_group@lyralists.lyrasis.org" <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>[Archivesspace_Users_Group] Importing Accessions CSVs - linking agents and resources<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span style="color:#222222;background:white">Hi all,</span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222">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?</span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222">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.</span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222">I can't seem to figure out how to make this work.</span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222">Thanks for your help! And sorry for the cross-post – this list seems a bit more active than the Google group.</span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:white"><span style="color:#222222">-Carly</span><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D">____________________________________________________________________</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D">Carly Bogen | Manager, Digital Programs</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D">Department of Records and Information Services (DORIS)
</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D">31 Chambers Street, New York, NY 10007</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D">P: 212-341-6029 | E-mail:
</span></b><b><u><span style="font-size:10.0pt;color:blue"><a href="mailto:cbogen@records.nyc.gov">cbogen@records.nyc.gov</a></span></u></b><o:p></o:p></p>
<p class="MsoNormal"><a href="http://nyc.gov/records"><span style="text-decoration:none"><b><span style="font-size:10.0pt;color:blue"><img border="0" width="72" height="13" style="width:.75in;height:.1354in" id="Picture_x005f_x0020_1" src="cid:image001.jpg@01D495F9.3CC696B0" alt="mailBanner"></span></b></span></a><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D">Follow us on:
</span></b><o:p></o:p></p>
<p class="MsoNormal"><a href="http://facebook.com/nycrecords"><span style="text-decoration:none"><span style="font-size:10.0pt;color:blue"><img border="0" width="8" height="8" style="width:.0833in;height:.0833in" id="Picture_x005f_x0020_4" src="cid:image002.jpg@01D495F9.3CC696B0" alt="acebook"></span></span></a><span style="font-size:10.0pt;color:#1F497D">
</span><a href="http://twitter.com/nycrecords"><span style="text-decoration:none"><span style="font-size:10.0pt;color:blue"><img border="0" width="8" height="8" style="width:.0833in;height:.0833in" id="Picture_x005f_x0020_3" src="cid:image003.png@01D495F9.3CC696B0" alt="witter"></span></span></a><span style="font-size:10.0pt;color:#1F497D"> </span><a href="http://nycrecords.tumblr.com/"><span style="text-decoration:none"><span style="font-size:10.0pt;color:blue"><img border="0" width="8" height="8" style="width:.0833in;height:.0833in" id="Picture_x005f_x0020_2" src="cid:image004.jpg@01D495F9.3CC696B0" alt="umblr"></span></span></a><span style="font-size:10.0pt;color:#1F497D"> </span><a href="http://youtube.com/NYCDeptOfRecords"><span style="text-decoration:none"><span style="font-size:10.0pt;color:blue"><img border="0" width="8" height="8" style="width:.0833in;height:.0833in" id="Picture_x005f_x0020_5" src="cid:image005.jpg@01D495F9.3CC696B0" alt="outube"></span></span></a><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</body>
</html>