[Archivesspace_Users_Group] Importing complex digital objects by CSV

[Kendall Aughenbaugh]

Hi there,

I'm attempting to import digital object components by the digital objects CSV job, using the template from archivesspace (with some additions from using other templates and mapping documents). I'm getting the following error message:

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
IMPORT ERROR
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


Trace:["C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/digital_object_converter.rb:248:in `block in configure'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/lib/record_proxy.rb:103:in `block in spawn'", "org/jruby/RubyArray.java:1821:in `each'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/lib/record_proxy.rb:102:in `spawn'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/lib/csv_converter.rb:77:in `block in parse_row'", "org/jruby/RubyArray.java:2621:in `map!'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/lib/csv_converter.rb:77:in `parse_row'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/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'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/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'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/converters/lib/csv_converter.rb:51:in `run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:44:in `block in run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:40:in `block in run'", "org/jruby/RubyArray.java:1821:in `each'", "org/jruby/RubyEnumerable.java:1258:in `each_with_index'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:36:in `block in run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:210:in `block in open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:101:in `block in transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204:in `_transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179:in `block in transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270:in `synchronize'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145:in `transaction'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:100:in `transaction'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:207:in `block in open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:204:in `open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/model/db.rb:542:in `block in DB'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:32:in `run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/background_job_queue.rb:126:in `run_pending_job'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-4964134346918072857/webapp/WEB-INF/app/lib/background_job_queue.rb:169:in `block in start_background_thread'"]
Errors: #<RuntimeError: Components must be preceded by their top-level digital object in the CSV>
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I've watched just about every video on the help site, but I haven't found anything that really addresses complex DOs other than saying they're able to be added by the csv (but not how). Other documentation I've been able to find says that the digital object to which the components will be attached must already be in ASpace. Mine are, and I have those digital object IDs in the "digital_object_id" column of my csv. The last bit of the error message is leading me to believe that I have to create the parent AND component digital object simultaneously by CSV? Which is correct?

If it's the latter, and I have to import the parent and component DOs at the same time, am I able to attach the parent digital objects to the archival objects with the Bulk Update Spreadsheet plug-in?

I really, really want to get this sorted out today. It'll make my whole week feel so worth it and productive.

Thank you all so much!

Kendall


Kendall Aughenbaugh
Digital Services Archivist
202.243.3912
kaughenbaugh at hillwoodmuseum.org<mailto:kaughenbaugh at hillwoodmuseum.org>

Hillwood Estate, Museum & Gardens
4155 Linnean Ave NW
Washington, DC 20008
www.hillwoodmuseum.org<http://www.hillwoodmuseum.org/>

Special Exhibition
[Special Exhibitions]<https://www.hillwoodmuseum.org/exhibitions>
Through January 14, 2024

Follow us on Facebook<https://www.facebook.com/HillwoodMuseum> and Instagram<https://www.facebook.com/HillwoodMuseum>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230714/8c364afa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FA-36-ASC_ASCDepartmentRecords_Stephanie-Brown-Series_complex-DO-import.csv
Type: text/csv
Size: 88573 bytes
Desc: FA-36-ASC_ASCDepartmentRecords_Stephanie-Brown-Series_complex-DO-import.csv
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230714/8c364afa/attachment.csv>