Answers.Body: <p>Are you using WPSec or some other security related wordpress plugins? Check:</p>
  
  <p><a href="https://wordpress.org/support/topic/plugin-better-wp-security-client-denied-by-server-configuration" rel="nofollow">https://wordpress.org/support/topic/plugin-better-wp-security-client-denied-by-server-configuration</a></p>
  
  <p>Seems like:</p>
  
  <p>a. CiviCRM is trying to write something to the log file</p>
  
  <p>b. The security plugin traps that and redirects you back to step 1</p>
  
  <p>try disabling the plugins and see if that helps</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T16:58:05.397Z
Answers.Text: Thanks for the idea, but no, we aren't using any extra security plugins. Any other ideas?
Answers.UserDisplayName: Roger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T18:18:49.340Z
Answers.Text: can you disable all WP plugins except for civicrm and try. The error is being issued by some code within your WP + plugin codebase most likely
Answers.UserDisplayName: Donald Lobo
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-14T22:53:16.553Z
Answers.Text: Thanks everyone. the issue was indeed the JetPack plugin - once I disabled the "Notify" piece of that plugin the imports ran smoothly. Anyone know why Notify is causing problems?
Answers.UserDisplayName: Roger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T02:12:11.453Z
Answers.LastActivityDate: 2015-05-14T23:07:21.987Z
Answers.LastEditDate: 2015-05-14T23:07:21.987Z
Answers.UserDisplayName: Donald Lobo
Answers.Body: <p>What you pasted is hard to read, but I <strong>think</strong> there is an issue of mixing of column and semi-column. At least it's a problem I've already experienced: the separator isn't correct and so it concatenates too many columns as if it were a single one</p>
  
  <p>What column separator have you selected? </p>
  
  <p><strong>Administer > Localization > Language, currency, location</strong></p>
  
  <p>(Import / Export Field Separator)</p>
  
  <p>Check that it matches your csv (edit it under notepad to be sure)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T16:57:23.307Z
Answers.Text: Thanks for the suggestion, but nope - I'm using commas and have confirmed there are no extra comments in the small file I've been testing with. :-(
Answers.UserDisplayName: Roger
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T09:07:16.110Z
Answers.LastActivityDate: 2015-05-13T09:07:16.110Z
Answers.UserDisplayName: Xavier
Body: <p>I hope someone can answer this!
  I've tried 30 various date formats, rearranged columns, and every time I do a membership import it fAils. No errors are presented, I'm just returned to "Upload Data (step 1 of 4)" from step 3... I never see step 4 (summary).
  In "plugins/files/civicrm/upload" folder I see a file "sqlImport.errors" which shows an error not recognizing the date formate for the membership start and end </p>
  
  <p>But I've tried every format and none work. :(.</p>
  
  <p>Each time one membership record (1 row) imports, and then if fails! Every time.</p>
  
  <p>The first 2,5 lines of sqlImport.errors says:</p>
  
  <p>Line Number","Reason","External Identifier (match to contact)","Membership Type Id","Email (match to contact)","Membership Start Date","Membership Expiration Date"
  "2","Invalid value for field(s) : Start Date; End date","33","Adult","wfsdfoks@telus.net","06/01/2013","06/01/2014"
  "3","Invalid value for field(s) : Start Date; End date","34","Youth","helsdfng@rebalasdftouch.com","06/01/2013","06/01/2015"</p>
  
  <p>I've tried different formats of dates (yyyy-mm-dd, mm/dd/yy, mm/dd/yyyy, dd/mm/yyyy) and selected the appropriate format from Step 1 in the import page.</p>
  
  <p>Every time it's the same:
  - I get to Step 3, and click "Submit"
  - 1 (one, only) row get imported (correctly) and then
  - I'm taken back to Step 1 - No error, complaint, nothing.</p>
  
  <p>In my server's error log I see:</p>
  
  <p>...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/custom/delete-this-OcxGgONTcR 
  ... client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/upload/delete-this-Zj1bvAyuTv
  ...client denied by server configuration: /home/civicthe/public_html/wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.fee2178658acc8deae2211eadc328c3b.log</p>
  
  <p>FYI, after each fail (1 row imports) I delete the top row from the .csv file and try again, and again 1 row imports, so it can't be the .csv file.</p>
  
  <p>Can anyone help? This is driving me bonkers.  Why does it fail if the next time I run the </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-13T01:49:32.657Z
Comments.Text: The extra punctuation and allcaps are a turn-off. You'll have more success getting volunteer feedback with polite, civil language in your post.
Comments.UserDisplayName: Joe Murray
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-13T16:53:11.730Z
Comments.Text: hehe thanks Joe. Mama said always chill out before posting questions to frustrating situations... I should have calmed down first.
Comments.UserDisplayName: Roger
Tags: <civimember><import>
Title: When importing memberships, I get "Error: Invalid value for field(s) : Start Date; End date"
ThreadText: # When importing memberships, I get "Error: Invalid value for field(s) : Start Date; End date"
  
  (Asked by: username_0 on 2015-05-12)
  
  I hope someone can answer this!
  I've tried 30 various date formats, rearranged columns, and every time I do a membership import it fAils. No errors are presented, I'm just returned to "Upload Data (step 1 of 4)" from step 3... I never see step 4 (summary).
  In "plugins/files/civicrm/upload" folder I see a file "sqlImport.errors" which shows an error not recognizing the date formate for the membership start and end
  
  But I've tried every format and none work. :(.
  
  Each time one membership record (1 row) imports, and then if fails! Every time.
  
  The first 2,5 lines of sqlImport.errors says:
  
  Line Number","Reason","External Identifier (match to contact)","Membership Type Id","Email (match to contact)","Membership Start Date","Membership Expiration Date"
  "2","Invalid value for field(s) : Start Date; End date","33","Adult","wfsdfoks@telus.net","06/01/2013","06/01/2014"
  "3","Invalid value for field(s) : Start Date; End date","34","Youth","helsdfng@rebalasdftouch.com","06/01/2013","06/01/2015"
  
  I've tried different formats of dates (yyyy-mm-dd, mm/dd/yy, mm/dd/yyyy, dd/mm/yyyy) and selected the appropriate format from Step 1 in the import page.
  
  Every time it's the same:
  - I get to Step 3, and click "Submit"
  - 1 (one, only) row get imported (correctly) and then
  - I'm taken back to Step 1 - No error, complaint, nothing.
  
  In my server's error log I see:
  
  ...client denied by server configuration: /home/civicthe/public\_html/wp-content/plugins/files/civicrm/custom/delete-this-OcxGgONTcR
  ... client denied by server configuration: /home/civicthe/public\_html/wp-content/plugins/files/civicrm/upload/delete-this-Zj1bvAyuTv
  ...client denied by server configuration: /home/civicthe/public\_html/wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.fee2178658acc8deae2211eadc328c3b.log
  
  FYI, after each fail (1 row imports) I delete the top row from the .csv file and try again, and again 1 row imports, so it can't be the .csv file.
  
  Can anyone help? This is driving me bonkers. Why does it fail if the next time I run the
  
  **Tags:** civimember, import
  
  > **Comments:**
  > **username_1**: The extra punctuation and allcaps are a turn-off. You'll have more success getting volunteer feedback with polite, civil language in your post.  
  > **username_0**: hehe thanks Joe. Mama said always chill out before posting questions to frustrating situations... I should have calmed down first.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2015-05-13. Score: 1 | Accepted answer
  
  Are you using WPSec or some other security related wordpress plugins? Check:
  
  <https://wordpress.org/support/topic/plugin-better-wp-security-client-denied-by-server-configuration>
  
  Seems like:
  
  a. CiviCRM is trying to write something to the log file
  
  b. The security plugin traps that and redirects you back to step 1
  
  try disabling the plugins and see if that helps
  
  > **Comments:**
  > **username_0**: Thanks for the idea, but no, we aren't using any extra security plugins. Any other ideas?  
  > **username_2**: can you disable all WP plugins except for civicrm and try. The error is being issued by some code within your WP + plugin codebase most likely  
  > **username_0**: Thanks everyone. the issue was indeed the JetPack plugin - once I disabled the "Notify" piece of that plugin the imports ran smoothly. Anyone know why Notify is causing problems?  
  
  ---
  
  ### Answer by username_3 on 2015-05-13. Score: 0
  
  What you pasted is hard to read, but I **think** there is an issue of mixing of column and semi-column. At least it's a problem I've already experienced: the separator isn't correct and so it concatenates too many columns as if it were a single one
  
  What column separator have you selected?
  
  **Administer > Localization > Language, currency, location**
  
  (Import / Export Field Separator)
  
  Check that it matches your csv (edit it under notepad to be sure)
  
  > **Comments:**
  > **username_0**: Thanks for the suggestion, but nope - I'm using commas and have confirmed there are no extra comments in the small file I've been testing with. :-(  
  
  ---
  
  