<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Further experimenting, I found that if I created a user account in ArchivesSpace for the aspace db user, that user
<i>was</i> able to import a file. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=aspace123&useUnicode=true&characterEncoding=UTF-8"
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I am now able to load a file.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I had not understood this requirement for importing.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Susan<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">------------------------------------</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">Susan Kerr</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">Systems Librarian</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">704-894-2424, 704-894-2625 (fax)</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">sukerr@davidson.edu</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">DAVIDSON COLLEGE LIBRARY<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">209 RIDGE RD<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">BOX 7200<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1F497D">DAVIDSON, NC 28035-7200<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Kerr, Susan
<br>
<b>Sent:</b> Wednesday, April 01, 2015 8:47 AM<br>
<b>To:</b> 'Archivesspace Users Group'<br>
<b>Subject:</b> RE: [Archivesspace_Users_Group] Import error with Accession CSV Template<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Sadly, I am not experienced enough to interpret your question.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This is a test WAMP environment on my computer where I have admin rights and can delete files in the folder.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This is from my config.rb file and is the only not-commented line in that file:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=aspace123&useUnicode=true&characterEncoding=UTF-8"
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The user logged into ArchiveSpace is my personal account and I am an administrator.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Baby steps.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Susan<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Tuesday, March 31, 2015 5:50 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Import error with Accession CSV Template<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi,
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">What I am seeing is that the job completed, but the last step ( removing the import file ) is running into a permission problem.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Not sure about what your deployment method is, but does the use running the application have delete permissions in the application's data directory?
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a href="http://archivesspace.org/">http://archivesspace.org/</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:#212121">
<hr size="3" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal" style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Kerr, Susan <<a href="mailto:sukerr@davidson.edu">sukerr@davidson.edu</a>><br>
<b>Sent:</b> Tuesday, March 31, 2015 10:34 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Import error with Accession CSV Template</span><span style="font-family:"Calibri",sans-serif;color:#212121">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-family:"Calibri",sans-serif;color:#212121"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Log file is attached.</span><span style="color:#212121"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,</span><span style="color:#212121"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Susan</span><span style="color:#212121"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:#212121"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Tuesday, March 31, 2015 3:27 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Import error with Accession CSV Template</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="background:white"><span style="color:#212121"> <o:p></o:p></span></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi Susan,</span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">What does the archivesspace.out log file say?</span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
</span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:#212121"><o:p></o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a href="http://archivesspace.org/" id="LPNoLP">http://archivesspace.org/</a></span><span style="color:#212121"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:#212121">
<hr size="3" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal" style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Kerr, Susan <<a href="mailto:sukerr@davidson.edu">sukerr@davidson.edu</a>><br>
<b>Sent:</b> Tuesday, March 31, 2015 8:08 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Import error with Accession CSV Template</span><span style="font-family:"Calibri",sans-serif;color:#212121">
</span><span style="color:#212121"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">I am trying to use the
<a href="http://www.archivesspace.org/importexport">http://www.archivesspace.org/importexport</a> Accession CSV Template with some very basic information for a test accession.
</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">System details: ArchivesSpace version 1.1.2; Windows Apache MySQL PHP (WAMP)</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Most of my experiments resulted in this error</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! IMPORT ERROR !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Error: #</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">When I removed all but the three elements required of an accession: title, accession_number, accession date, I get this error:</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">==================================================</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">testAccImport.csv</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">==================================================</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">1. STARTED: Reading JSON records</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">1. DONE: Reading JSON records</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">2. STARTED: Validating records and checking links</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">2. DONE: Validating records and checking links</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">3. STARTED: Evaluating record relationships</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">3. DONE: Evaluating record relationships</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">4. STARTED: Saving records: cycle 1</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Created: /repositories/import/accessions/import_24b4c82f-7f39-475d-aabd-5d58e4dbe696</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">4. DONE: Saving records: cycle 1</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">5. STARTED: Cleaning up</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">5. DONE: Cleaning up</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! IMPORT ERROR !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Error: #</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">!!!!!!!!!!!!!!!!!</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">This is the test import file.</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">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</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">29-Mar-94,1994-001,,,,1994-03-29,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">I have also tried to import a file that had successfully imported in a Linux environment and get the error with no results.</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">I would appreciate any help in solving this problem</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Thanks,</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">Susan</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Calibri",sans-serif;color:#212121">------------------------------------</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">Susan Kerr</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">Systems Librarian</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">704-894-2424, 704-894-2625 (fax)</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
<br>
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121"><a href="mailto:sukerr@davidson.edu">sukerr@davidson.edu</a></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121">
</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">DAVIDSON COLLEGE LIBRARY</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">209 RIDGE RD</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">BOX 7200</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121">DAVIDSON, NC 28035-7200</span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#212121"> </span><span style="color:#212121"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>