CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import Activities - not a valid date
Pages: [1]

Author Topic: Import Activities - not a valid date  (Read 1095 times)

nickholden

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 1
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7
  • MySQL version: 5.5.32
  • PHP version: 5.4
Import Activities - not a valid date
November 01, 2013, 08:55:57 am
Using CiviCRM 4.4.0 on drupal 7. Trying to import a CSV of activities, I get past step 3 with the correct number of lines due to be imported (in other words the csv file passes the syntax check at that point) but no data is imported.

The post-import check says:

Total Rows   2047   Total rows (activity records) in uploaded file.
Invalid Rows (skipped)   2047   Rows with invalid data in one or more fields. These rows will be skipped (not imported)
Records Imported   0   Rows imported successfully.

Having downloaded the errors, the specific error is "activity_date_time is not a valid date: 30/09/2013"

This is despite having specified that date format in the first screen. Changing the date format in the csv file to yyyy-mm-dd and re-running the import, specifying that date format works OK.

Anyone else found that alternate date formats don't actually import?

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Re: Import Activities - not a valid date
February 11, 2014, 01:17:22 pm
I'm having this issue too with 4.4.4, can't work it out. I've tried various csv formats for Unicode UTF-8, starting with a clean spreadsheet, etc.

endo

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: 4
  • MySQL version: 4
  • PHP version: 4
Re: Import Activities - not a valid date
July 22, 2014, 07:22:27 am
I am also having this issue  with 4.4.4.

I have tried every date format and even tried exporting some activities to see how the date looks and trying that format but still no luck!

Anyone have any work arounds?

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Import Activities - not a valid date
July 22, 2014, 11:56:17 am
Since there are three error reports for this on 4.4.x, it sounds like it is a bug.  Have you checked if it has been reported / fixed in a newer version.  Otherwise might be useful to read http://civicrm.org/bug-reporting and report it
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

punkingee

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: Wordpress
  • MySQL version: ?
  • PHP version: ?
Re: Import Activities - not a valid date
September 09, 2014, 10:04:19 am
I'm having the same problem.  Until there's a fix, can you suggest a workaround?

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Import Activities - not a valid date
September 10, 2014, 12:53:08 am
See my response in http://forum.civicrm.org/index.php/topic,33489.0/topicseen.html
Andy Clark
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import Activities - not a valid date

This forum was archived on 2017-11-26.