[Archivesspace_small_archives_users_group] Accession Importer TroubleShooting

[Caitlin Rizzo]

Hello Helpful List, 

I am having some some troubles using the accession importer to upload a small group of accessions. I believe the issues are happening upon conversion of an .xsl to a .csv file. I have tried just about everything I can think of, including converting special characters and unconverting them as well as changing the .csv formats, etc. I am wondering if anyone here has had a similar issue and has any advice. 

Just as a quick note, I am getting the following error: Trace:["/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/accession_converter.rb:212:in `block in configure'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/record_proxy.rb:118:in `block in on_discharge'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/record_proxy.rb:123:in `block in discharge'", "org/jruby/RubyArray.java:1809:in `each'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/record_proxy.rb:123:in `discharge'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/record_proxy.rb:23:in `discharge_proxy'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/csv_converter.rb:80:in `block in parse_row'", "org/jruby/RubyArray.java:1809:in `each'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/csv_converter.rb:80:in `parse_row'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/csv_converter.rb:62:in `block in run'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1764:in `each'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/csv_converter.rb:52:in `block in run'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1289:in `open'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/converters/lib/csv_converter.rb:51:in `run'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:44:in `block in run'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:40:in `block in run'", "org/jruby/RubyArray.java:1809:in `each'", "org/jruby/RubyEnumerable.java:1258:in `each_with_index'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:36:in `block in run'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:198:in `block in open'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:89:in `block in transaction'", "/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204:in `_transaction'", "/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179:in `block in transaction'", "/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'", "/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270:in `synchronize'", "/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145:in `transaction'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:88:in `transaction'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:195:in `block in open'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:192:in `open'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:520:in `block in DB'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:32:in `run'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:126:in `run_pending_job'", "/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:169:in `block in start_background_thread'"] Errors: #<NoMethodError: undefined method `names' for nil:NilClass> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 

Thanks to anyone with suggestions! 

Best, 
Caitlin 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_small_archives_users_group/attachments/20210827/01fb9656/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace_Accession_Ingest.xls
Type: application/vnd.ms-excel
Size: 571904 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_small_archives_users_group/attachments/20210827/01fb9656/attachment-0002.xls>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace_Accession_IngestNoSpecial.xls
Type: application/vnd.ms-excel
Size: 570368 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_small_archives_users_group/attachments/20210827/01fb9656/attachment-0003.xls>