[Archivesspace_Users_Group] NEW Import error with Accession CSV Template

Thu Apr 2 03:18:32 EDT 2015

Hi Susan,

Yes, I think you have some file level permissions issues. The final step of the import job is to clean up and delete the import file from disk, which the log you sent indicated it could not do. What are the file permissions in the data/shared 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: Wednesday, April 1, 2015 10:29 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] NEW Import error with Accession CSV Template

It processes then fails with the permissions error when cleaning up.  When I restart the server and the application it processes completely.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Maura Carbone
Sent: Wednesday, April 01, 2015 4:28 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] NEW Import error with Accession CSV Template

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<mailto: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<tel:704-894-2424>, 704-894-2625<tel: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

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<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<tel:704-894-2424>, 704-894-2625<tel: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

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<tel: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<tel: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<tel:704-894-2424>, 704-894-2625<tel: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

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto: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<mailto:mauraa at brandeis.edu>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150402/1615e406/attachment.html>