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) »
  • Localized date field when importing
Pages: [1]

Author Topic: Localized date field when importing  (Read 1289 times)

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Localized date field when importing
November 01, 2009, 07:43:19 am
I am trying to import a date field with the Dutch localization. The format of Dutch dates is 'day-month-year', in POSIX '%E-%m-%Y'. This format is default when exporting csv from Excel.

During importing contacts the closest thing is the format 'dd/mm/yyyy'. This means that a user always has to change the format manually to match the format.

However, in http://wiki.civicrm.org/confluence/display/CRMDOC/Import+Errors I found that one of the correct formatting options was '02-05-2007', which is exactly how I would like it to be. Is this a bug, a misunderstanding in the documentation or can I change the formatting to correctly import dates?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Localized date field when importing
November 01, 2009, 07:55:23 am

i fixed the docs to match what import expects

For now u will need to reformat the dates manually

If this is important to you, consider submitting a patch to fix the issue

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Re: Localized date field when importing
November 01, 2009, 08:33:36 am
Ok, Donald, added: http://issues.civicrm.org/jira/browse/CRM-5328

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Localized date field when importing
November 01, 2009, 09:55:52 am

dont see the patch that fixes the issue? in general we do prefer folks also work and submit a patch along with the issue for things that are important to them

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Ed van Leeuwen

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Drupal 7.x
  • MySQL version: MariaDB 10
Re: Localized date field when importing
November 02, 2009, 12:35:35 pm
Ok, will try that.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Localized date field when importing

This forum was archived on 2017-11-26.