[Archivesspace_Users_Group] NEW Import error with Accession CSV Template

Wed Apr 1 16:27:52 EDT 2015

Hi Susan,
Are you getting an error or is it just staying in queue and never loading?
-Maura

On Wed, Apr 1, 2015 at 4:24 PM, Kerr, Susan <sukerr at davidson.edu> wrote:

>  After this initial test, I have discovered that I am only able to import
> ONE file successfully. To get a 2nd file imported, I must stop the
> application and restart the server.  Then the file which failed imports
> successfully.
>
>
>
> Is there some setting that I need to add to allow multiple imports?
>
>
>
> Susan
>
>
>
> ------------------------------------
> Susan Kerr
> Systems Librarian
> 704-894-2424, 704-894-2625 (fax)
> sukerr at davidson.edu
>
>
>
> DAVIDSON COLLEGE LIBRARY
>
> 209 RIDGE RD
>
> BOX 7200
>
> DAVIDSON, NC 28035-7200
>
>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Kerr,
> Susan
> *Sent:* Wednesday, April 01, 2015 3:04 PM
> *To:* Archivesspace Users Group
> *Subject:* Re: [Archivesspace_Users_Group] Import error with Accession
> CSV Template
>
>
>
> Further experimenting, I found that if I created a user account in
> ArchivesSpace for the aspace db user, that user *was* able to import a
> file.
>
> So, I added another line to the config.rb file copying and replacing the
> user and password with my credentials which are also a valid server user.
>
> AppConfig[:db_url] =
> "jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=aspace123&useUnicode=true&characterEncoding=UTF-8"
>
>
>
>
> I am now able to load a file.
>
> I had not understood this requirement for importing.
>
>
>
> Thanks,
>
>
>
> Susan
>
> ------------------------------------
> Susan Kerr
> Systems Librarian
> 704-894-2424, 704-894-2625 (fax)
> sukerr at davidson.edu
>
>
>
> DAVIDSON COLLEGE LIBRARY
>
> 209 RIDGE RD
>
> BOX 7200
>
> DAVIDSON, NC 28035-7200
>
>
>
>
>
>
>
> *From:* Kerr, Susan
> *Sent:* Wednesday, April 01, 2015 8:47 AM
> *To:* 'Archivesspace Users Group'
> *Subject:* RE: [Archivesspace_Users_Group] Import error with Accession
> CSV Template
>
>
>
> Sadly, I am not experienced enough to interpret your question.
>
>
>
> This is a test WAMP environment on my computer where I have admin rights
> and can delete files in the folder.
>
>
>
> The user account on the server in this case is “aspace” with ALL
> privileges, Grant YES.  When I try to edit this, I see that there are no
> Table-specific privileges.
>
> This is from my config.rb file and is the only not-commented line in that
> file:
>
>
>
> AppConfig[:db_url] =
> "jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=aspace123&useUnicode=true&characterEncoding=UTF-8"
>
>
>
>
> The user logged into ArchiveSpace is my personal account and I am an
> administrator.
>
>
>
> Baby steps.
>
>
>
> Thanks,
>
> Susan
>
>
>
>
>
>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [
> mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org
> <archivesspace_users_group-bounces at lyralists.lyrasis.org>] *On Behalf Of *Chris
> Fitzpatrick
> *Sent:* Tuesday, March 31, 2015 5:50 PM
> *To:* Archivesspace Users Group
> *Subject:* Re: [Archivesspace_Users_Group] Import error with Accession
> CSV Template
>
>
>
> Hi,
>
>
>
> What I am seeing is that the job completed, but the last step ( removing
> the import file ) is running into a permission problem.
>
>
>
> Not sure about what your deployment method is, but does the use running
> the application have delete permissions in the application's data
> directory?
>
>
>
> b,chris.
>
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat  | Phone: 918.236.6048
> http://archivesspace.org/
>     ------------------------------
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Kerr, Susan <sukerr at davidson.edu>
> *Sent:* Tuesday, March 31, 2015 10:34 PM
> *To:* Archivesspace Users Group
> *Subject:* Re: [Archivesspace_Users_Group] Import error with Accession
> CSV Template
>
>
>
> Log file is attached.
>
> Thanks,
>
> Susan
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [
> mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org
> <archivesspace_users_group-bounces at lyralists.lyrasis.org>] *On Behalf Of *Chris
> Fitzpatrick
> *Sent:* Tuesday, March 31, 2015 3:27 PM
> *To:* archivesspace_users_group at lyralists.lyrasis.org
> *Subject:* Re: [Archivesspace_Users_Group] Import error with Accession
> CSV Template
>
>
>
> Hi Susan,
>
>
>
> What does the archivesspace.out log file say?
>
>
>
> b,chris.
>
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat  | Phone: 918.236.6048
> http://archivesspace.org/
>     ------------------------------
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Kerr, Susan <sukerr at davidson.edu>
> *Sent:* Tuesday, March 31, 2015 8:08 PM
> *To:* archivesspace_users_group at lyralists.lyrasis.org
> *Subject:* [Archivesspace_Users_Group] Import error with Accession CSV
> Template
>
>
>
> I am trying to use the  http://www.archivesspace.org/importexport
> Accession CSV Template with some very basic information for a test
> accession.
>
>
>
> System details: ArchivesSpace version 1.1.2; Windows Apache MySQL PHP
> (WAMP)
>
>
>
> Most of my experiments resulted in this error
>
>
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  IMPORT ERROR
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> Error: #
>
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>
>
> When I removed all but the three elements required of an accession: title,
> accession_number, accession date, I get this error:
>
>
>
> ==================================================
>
> testAccImport.csv
>
> ==================================================
>
> 1. STARTED: Reading JSON records
>
> 1. DONE: Reading JSON records
>
> 2. STARTED: Validating records and checking links
>
> 2. DONE: Validating records and checking links
>
> 3. STARTED: Evaluating record relationships
>
> 3. DONE: Evaluating record relationships
>
> 4. STARTED: Saving records: cycle 1
>
> Created:
> /repositories/import/accessions/import_24b4c82f-7f39-475d-aabd-5d58e4dbe696
>
> 4. DONE: Saving records: cycle 1
>
> 5. STARTED: Cleaning up
>
> 5. DONE: Cleaning up
>
>
>
>
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  IMPORT ERROR
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> Error: #
>
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> !!!!!!!!!!!!!!!!!
>
>
>
> This is the test import file.
>
>
>
>
> accession_title,accession_number_1,accession_number_2,accession_number_3,accession_number_4,accession_accession_date,accession_access_restrictions,accession_access_restrictions_note,accession_acquisition_type,accession_condition_description,accession_content_description,accession_disposition,accession_general_note,accession_inventory,accession_provenance,accession_publish,accession_resource_type,accession_restrictions_apply,accession_retention_rule,accession_use_restrictions,accession_use_restrictions_note,accession_cataloged_note,accession_processing_hours_total,accession_processing_plan,accession_processing_priority,accession_processing_status,accession_processing_started_date,accession_processing_total_extent,accession_processing_total_extent_type,accession_processors,accession_rights_determined,date_1_label,date_1_expression,date_1_begin,date_1_end,date_1_type,date_2_label,date_2_expression,date_2_begin,date_2_end,date_2_type,extent_type,extent_container_summary,extent_number,accession_acknowledgement_sent,accession_acknowledgement_sent_date,accession_agreement_received,accession_agreement_received_date,accession_agreement_sent,accession_agreement_sent_date,accession_cataloged,accession_cataloged_date,accession_processed,accession_processed_date,user_defined_boolean_t,user_defined_boolean_2,user_defined_boolean_3,user_defined_integer_1,user_defined_integer_2,user_defined_integer_3,user_defined_real_1,user_defined_real_2,user_defined_real_3,user_defined_string_1,user_defined_string_2,user_defined_string_3,user_defined_string_4,user_defined_text_1,user_defined_text_2,user_defined_text_3,user_defined_text_4,user_defined_text_5,user_defined_date_1,user_defined_date_2,user_defined_date_3,user_defined_enum_1,user_defined_enum_2,user_defined_enum_3,user_defined_enum_4,agent_role,agent_type,agent_contact_address_1,agent_contact_address_2,agent_contact_address_3,agent_contact_city,agent_contact_country,agent_contact_email,agent_contact_fax,agent_contact_name,agent_contact_post_code,agent_contact_region,agent_contact_salutation,agent_contact_telephone,agent_contact_telephone_ext,agent_name_authority_id,agent_name_dates,agent_name_fuller_form,agent_name_name_order,agent_name_number,agent_name_prefix,agent_name_primary_name,agent_name_qualifier,agent_name_rest_of_name,agent_name_rules,agent_name_sort_name,agent_name_source,agent_name_subordinate_name_1,agent_name_subordinate_name_2,agent_name_suffix,agent_name_description_note,agent_name_description_citation,subject_source,subject_term,subject_term_type
>
>
> 29-Mar-94,1994-001,,,,1994-03-29,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
>
>
>
> I have also tried to import a file that had successfully imported in a
> Linux environment and get the error with no results.
>
>
>
> I would appreciate any help in solving this problem
>
>
>
> Thanks,
>
> Susan
>
>
>
> ------------------------------------
> Susan Kerr
> Systems Librarian
> 704-894-2424, 704-894-2625 (fax)
> sukerr at davidson.edu
>
>
>
> DAVIDSON COLLEGE LIBRARY
>
> 209 RIDGE RD
>
> BOX 7200
>
> DAVIDSON, NC 28035-7200
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>

-- 
Maura Carbone
Digital Initiatives Librarian
Brandeis University
Library and Technology Services
(781) 736-4659
415 South Street, (MS 017/P.O. Box 549110)
Waltham, MA 02454-9110
email: mauraa at brandeis.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150401/20cf52e7/attachment.html>