<div dir="ltr"><div dir="ltr">Hi Emily,<div><br></div><div>We have been using the plugin (We're using 2.4.1 of ASpace and 2.1.13 of the Harvard plugin.), and as with for others, it is working great!! Thank you Harvard, so much. The largest inventory we did was for a record with approximately 3500 lines of inventory. I worked great, taking about 50 minutes to complete the job, but that would probably depend on your system specs.</div><div><br></div><div>We made some modifications to the spreadsheet to suit our needs and uploaded the Excel spreadsheet as a Google Sheets doc, which processors make copies from. I am sharing below:</div><div><a href="https://docs.google.com/spreadsheets/d/1-hCN-1OZDctrRnWO8Hg_3SXbtPATTT9l6Z8CueWVPKQ/edit?usp=sharing" target="_blank">https://docs.google.com/spreadsheets/d/1-hCN-1OZDctrRnWO8Hg_3SXbtPATTT9l6Z8CueWVPKQ/edit?usp=sharing</a><br></div><div><br></div><div>Some of the changes:</div><div><ul><li>I added data validation so that processors can only enter kosher dates for begin and end dates.</li><li>Same for our EAD ID column, which requires a certain syntax.</li><li>You can only upload 1 date record through the spreadsheet, but you can add any column you want. We added a column for processors to keep track of their dates should they want more than one date record per archival object. They go back in the GUI and manually add dates not uploaded through the spreadsheet.</li><li>We keep track of container profiles and locations for top containers. We added columns for those so processors can document those and go back and add them through top container/bulk updates in the GUI.</li><li>Added values in dropdown menus for the columns (container profiles, instance type, etc.).</li></ul>One other thing we've found in our ongoing experiments with the plugin is that it is easy to make mistakes that ASpace would normally catch in the GUI if you just use the spreadsheet. (e.g. you might forget to enter the date type.. ASpace/the plugin will reject the date). Yes, the plugin will throw you an error, but it is much better to catch the mistakes up front. I am working on a workflow for checking for varied possible mistakes using Google Sheets filter views, which can be saved and copied over to the spreadsheets processors use. Those checks are described <a href="https://docs.google.com/spreadsheets/d/1-hCN-1OZDctrRnWO8Hg_3SXbtPATTT9l6Z8CueWVPKQ/edit?usp=sharing">here</a>, but disclaimer: this is very drafty! I'm not done with container checks and the things we need to check for grows. But I think filters are a good way to check that you've got all the required info to make an archival object record or subrecord within that archival object.</div><div><br></div><div>A few other things. If you go Google Sheets (which I believe Harvard would discourage) and download as xslx, make sure all your columns are in Text (vs. auto or number mode) in your Sheets template. In fact, I feel it is risky to write in Google Sheets and open in Excel because it might (e.g.) mess with your dates and transform them to a syntax ASpace will reject ... mess with other formatted text.</div><div><br></div><div>We sometimes have boxes reserved for oversize or restricted materials and these boxes already exist in ASpace as top containers. Processors sometimes add materials to them and need to refer to those top containers in their inventories. The barcode column is how you link to the existing top container record using the spreadsheet/plugin. But we are having problems doing that with barcodes that are strings of numbers, though not with anything that includes both numbers and letters works fine. This is also because we implemented this <a href="https://github.com/archivesspace/archivesspace/blob/master/common/config/config-defaults.rb#L81" class="gmail-m_-5854170695822880266OWAAutoLink" id="gmail-m_-5854170695822880266LPlnk478910" target="_blank" style="font-family:Calibri,Helvetica,sans-serif,EmojiFont,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">config fix</a> (see also <a href="http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2018-February/005664.html">here</a>). We don't totally understand the issue, but the linkage is not made when we have the config fix turned on. It does when we don't.</div><div><br></div><div>At any rate, thank you again, Harvard! I strongly recommend your plugin.</div><div><br></div><div>Best,</div><div>Olivia</div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Jan 8, 2019 at 5:53 PM Peale, Anne <<a href="mailto:aep3@williams.edu" target="_blank">aep3@williams.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Emily,<div><br></div><div>We installed the plugin about a year ago and it's been working brilliantly. We have loaded several very large files (up to c. 1500 items), and the process is a little slow but it does complete. </div><div><br></div><div>However, we have also noticed that when we use the plugin in our sandbox environment, it is much less tolerant of large sets of items and can only cope with short lists. I'm not the administrator for ASpace at Williams and don't know much about the way our server is set up, but I wonder if the problem has something to do with server capacity and if the plugin will actually work fine when you try to load to your main ASpace system. If you'd like more information, I can ask our administrator for details.</div><div><br></div><div>The plugin has been an absolute joy to work with, especially for importing legacy finding aids. We've also had good luck having student assistants enter data into a google form or sheet, then proofreading before importing -- much smoother than trying to proofread additions made directly by rapid data entry.</div><div><br></div><div>All best,</div><div>Anne</div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Jan 8, 2019 at 6:12 PM Emily Pyers <<a href="mailto:epyers@slv.vic.gov.au" target="_blank">epyers@slv.vic.gov.au</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-AU">
<div class="gmail-m_-1768617897033877597gmail-m_4609599296875371528gmail-m_-2159917327530758644WordSection1">
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">Link to it in GitHub here:
<a href="https://github.com/harvard-library/aspace-import-excel" target="_blank">https://github.com/harvard-library/aspace-import-excel</a><u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">We’re really excited about it (the 80% rule!) and have implemented it on our test system (v2.4.0).<span>
</span>We’ve been testing it and <span class="gmail-m_-1768617897033877597gmail-m_4609599296875371528gmail-m_-2159917327530758644GramE">it’s</span> mostly working fine, until we attempt to load spreadsheets that have more than around 100 lines. Attempts to load spreadsheets over this size are resulting in job timeouts and overall system slowdowns,
and we’ve tested pretty thoroughly – it doesn’t seem to be an issue with the data.<span>
</span>Our tech team have reviewed the system logs, but are unable to pinpoint the source of the problem.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">I was hoping someone out there might be able to confirm that a) they have successfully used the plugin to load spreadsheets greater
than 100 lines (since this seems to be a point of scepticism for some of our internal stakeholders), and that b) if you might be able to point us towards any potential areas of investigation?<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">I would be so appreciative for any help on this!<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">Cheers,<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="2" face="Century Gothic"><span style="font-size:11pt;font-family:"Century Gothic",sans-serif">Emily<span>
</span><u></u><u></u></span></font></p>
</div>
<br>
<div style="font-size:11pt;font-family:"Century Gothic""><b>Emily Pyers | Metadata & Archival Systems Specialist | Collection Development & Description
</b><br>
In the office Monday, Wednesday - Friday 9.30am-3pm<br>
State Library Victoria | 328 Swanston Street | Melbourne VIC 3000 <br>
T +61 3 8664 7368 | <a href="mailto:epyers@slv.vic.gov.au" target="_blank">epyers@slv.vic.gov.au</a> <br>
<a href="http://slv.vic.gov.au" target="_blank">slv.vic.gov.au</a></div>
<br>
<br>
<table>
<tbody>
<tr>
<td colspan="3"><a href="https://www.slv.vic.gov.au/email_campaign" target="_blank"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/signature.jpg?6"></a></td>
<td> </td>
</tr>
<tr>
<td colspan="3"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/follow-us.png" alt="follow
us"></td>
</tr>
<tr>
<td>
<table>
<tbody>
<tr>
<td><a style="text-decoration:none" href="http://www.facebook.com/pages/Melbourne-Australia/State-Library-of-Victoria/32256104331" target="_blank"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/facebook.png" alt="SLV facebook"></a></td>
<td><a style="text-decoration:none" href="http://twitter.com/Library_Vic" target="_blank"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/twitter.png" alt="SLV twitter"></a></td>
<td><a style="text-decoration:none" href="http://www.youtube.com/user/statelibraryvictoria" target="_blank"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/youtube.png" alt="SLV youtube"></a></td>
<td><a style="text-decoration:none" href="http://instagram.com/library_vic" target="_blank"><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/instagram.png" alt="SLV
instagram"></a></td>
<td><img src="https://www.slv.vic.gov.au/sites/default/files/email_signature/racv-logo-small.png" alt="RACV logo" style="display: block; max-width: 100%; height: auto; width: 170px; padding-left: 40px;"></td>
</tr>
</tbody>
</table>
<table>
<tbody>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
This message and any attachment is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, please delete all copies of the message and its attachments and notify the sender immediately. Thank you.
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail-m_-1768617897033877597gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.8px"><font color="#000000">Olivia Solis, MSIS</font></div><div style="font-size:12.8px"><font color="#000000">Metadata Coordinator</font></div><div style="font-size:12.8px"><font color="#000000">Dolph Briscoe Center for American History</font></div><div style="font-size:12.8px"><font color="#000000">The University of Texas at Austin</font></div><div style="font-size:12.8px"><font color="#000000">2300 Red River St. Stop D1100</font></div><div style="font-size:12.8px"><font color="#000000">Austin TX, 78712-1426</font></div><div style="color:rgb(136,136,136);font-size:12.8px"><span style="color:rgb(0,0,0);font-size:12.8px">(512) 232-8013</span></div></div></div></div></div></div></div>