<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">We have been using the plugin routinely. <div class="">We did recently have some problems when we tried it on a very large spreadsheet ( > 2000 rows )</div><div class=""><br class=""></div><div class="">It seemed to me that when the web app appeared to have finished importing the spreadsheet, it was really still processing in the background for a long time. ( hours! ) That made it appear that it didn’t completely work. We then tried to delete and redo again, which caused even more problems. Or It might be that the archival_objects are created but not yet indexed. (*) <br class=""><div>So I would suggest first doing import on a test server, and to wait a long time for the job to complete. </div><div>When we redid it again, on production, waiting overnight for completion, we got everything but a couple of rows. </div><div>We didn’t spend any more time trying to locate the exact error on those rows — we just added the missing values manually. </div><div>So I’m not 100% sure of my diagnosis and description of the problem. </div><div>But even with the manual fixup, it still saved a lot of time on the other 2000 archival objects! </div><div><br class=""></div><div>But if you’re seeing issues with 100+ lines, perhaps we need to implement some post import QA check to verify that everything imported correctly. </div><div><br class=""></div><div>(*) In one case, we tried to delete archival_objects after what appeared to be an unsuccessful import, however after some were deleted, more continued to appear, and the 2nd attempt to import hit errors trying to recreate still existing records. </div><div><br class=""></div><div><br class=""></div><div>— Steve Majewski</div><div><br class=""></div><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 8, 2019, at 6:12 PM, Emily Pyers <<a href="mailto:epyers@slv.vic.gov.au" class="">epyers@slv.vic.gov.au</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">Link to it in GitHub here:<span class="Apple-converted-space"> </span><a href="https://github.com/harvard-library/aspace-import-excel" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">https://github.com/harvard-library/aspace-import-excel</a><o:p class=""></o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class=""><o:p class=""> </o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">We’re really excited about it (the 80% rule!) and have implemented it on our test system (v2.4.0).<span class=""> <span class="Apple-converted-space"> </span></span>We’ve been testing it and<span class="Apple-converted-space"> </span><span class="GramE">it’s</span><span class="Apple-converted-space"> </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 class=""> <span class="Apple-converted-space"> </span></span>Our tech team have reviewed the system logs, but are unable to pinpoint the source of the problem.<o:p class=""></o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class=""><o:p class=""> </o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">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?<o:p class=""></o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class=""><o:p class=""> </o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">I would be so appreciative for any help on this!<o:p class=""></o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class=""><o:p class=""> </o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">Cheers,<o:p class=""></o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class=""><o:p class=""> </o:p></span></font></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><font size="2" face="Century Gothic" class=""><span style="font-size: 11pt; font-family: "Century Gothic", sans-serif;" class="">Emily<span class=""> </span><o:p class=""></o:p></span></font></div></div><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><div style="caret-color: rgb(0, 0, 0); font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-size: 11pt; font-family: "Century Gothic";" class=""><b class="">Emily Pyers | Metadata & Archival Systems Specialist | Collection Development & Description<span class="Apple-converted-space"> </span></b><br class="">In the office Monday, Wednesday - Friday 9.30am-3pm<br class="">State Library Victoria | 328 Swanston Street | Melbourne VIC 3000<span class="Apple-converted-space"> </span><br class="">T +61 3 8664 7368 |<span class="Apple-converted-space"> </span><a href="mailto:epyers@slv.vic.gov.au" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">epyers@slv.vic.gov.au</a><span class="Apple-converted-space"> </span><br class=""><a tabindex="0" href="http://slv.vic.gov.au/" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">slv.vic.gov.au</a></div><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><table style="caret-color: rgb(0, 0, 0); font-family: Helvetica; letter-spacing: normal; orphans: auto; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><tbody class=""><tr class=""><td colspan="3" class=""><a tabindex="0" href="https://www.slv.vic.gov.au/email_campaign" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/signature.jpg?6" class=""></a></td><td class=""> </td></tr><tr class=""><td colspan="3" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/follow-us.png" alt="follow
us" class=""></td></tr><tr class=""><td class=""><table class=""><tbody class=""><tr class=""><td class=""><a tabindex="0" href="http://www.facebook.com/pages/Melbourne-Australia/State-Library-of-Victoria/32256104331" style="color: rgb(149, 79, 114); text-decoration: none;" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/facebook.png" alt="SLV facebook" class=""></a></td><td class=""><a tabindex="0" href="http://twitter.com/Library_Vic" style="color: rgb(149, 79, 114); text-decoration: none;" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/twitter.png" alt="SLV twitter" class=""></a></td><td class=""><a tabindex="0" href="http://www.youtube.com/user/statelibraryvictoria" style="color: rgb(149, 79, 114); text-decoration: none;" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/youtube.png" alt="SLV youtube" class=""></a></td><td class=""><a tabindex="0" href="http://instagram.com/library_vic" style="color: rgb(149, 79, 114); text-decoration: none;" class=""><img src="http://www.slv.vic.gov.au/sites/default/files/email_signature/instagram.png" alt="SLV
instagram" class=""></a></td><td class=""><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;" class=""></td></tr></tbody></table><table class=""><tbody class=""><tr class=""><td class=""></td><td class=""></td></tr></tbody></table></td></tr></tbody></table><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">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. _______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Archivesspace_Users_Group mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div></blockquote></div><br class=""></div></body></html>