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 a cuistom date format yyyy
Pages: [1]

Author Topic: Import a cuistom date format yyyy  (Read 920 times)

lakshr@ion.ac.uk

  • Guest
Import a cuistom date format yyyy
November 01, 2010, 08:55:33 am
I have a custom data Grad Year which should hold a year in YYYY(2009) format.

I have to import Grad Year for around 1000 contacts and am using the Import Contacts. What date format would I use to import a YYYY field? yyyymmdd comes back with an error.

L

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Import a cuistom date format yyyy
November 02, 2010, 07:42:59 am
yyyy?

m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

lakshr@ion.ac.uk

  • Guest
Re: Import a cuistom date format yyyy
November 02, 2010, 07:56:43 am
yyyy is not an option in Date Format under Import Contacts.

I tried yyyy-mm-dd or yyyymmdd and it came back with an error.

When I change the date in CSV from 2010 to 20100101 (so to yyyymmdd) the import gets through but the data in the custom field is 1970 and not 2010 as is to be expected.
The same is the case when  I change the CSV value to 2010-01-01.

I have attached the CSV file I am importing and screenshot of the custom data

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Import a cuistom date format yyyy
November 02, 2010, 09:22:06 am
Sorry, it's a low caffeine day here, for some reason I understood you're asking about custom field format, my bad. :-)
Can you please try to reproduce this effect on demo (http://demo.civicrm.org/) and if it happens there as well, file an issue (http://issues.civicrm.org/)?

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

lakshr@ion.ac.uk

  • Guest
Re: Import a cuistom date format yyyy
November 02, 2010, 11:11:36 am
Thanks....I have tested it on the demo site and it still updates as 1970...I have created an issue as suggested.

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

This forum was archived on 2017-11-26.