[Archivesspace_Users_Group] Import error with Accession CSV Template

Wed Apr 1 15:04:08 EDT 2015

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> [mailto: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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Kerr, Susan <sukerr at davidson.edu<mailto: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> [mailto: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<mailto: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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Kerr, Susan <sukerr at davidson.edu<mailto:sukerr at davidson.edu>>
Sent: Tuesday, March 31, 2015 8:08 PM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto: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<mailto:sukerr at davidson.edu>

DAVIDSON COLLEGE LIBRARY
209 RIDGE RD
BOX 7200
DAVIDSON, NC 28035-7200

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150401/d9f21910/attachment.html>