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) »
  • How to import the time with the date?
Pages: [1]

Author Topic: How to import the time with the date?  (Read 816 times)

matthewykk

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.0.5
  • CMS version: Drupal 7.8
  • MySQL version: mySQL 5.1.41
  • PHP version: phpmyadmin 3.2.4
How to import the time with the date?
November 16, 2012, 01:19:10 am
Hi all,

I tried to import the data of "Date and Time" into the Custom Data.  (NOT Activity).

Here is the format: 1/1/2012 19:00:00

The date is succeeded to import in CORRECT format and data.   However, the time is WRONG.  Everytime I got the result is 12:00am.


How can I got the Correct result? 

The current version of my CiviCRM is 4.0.5 .   


Thank you so much!

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: How to import the time with the date?
November 16, 2012, 04:25:29 am
matthewykk :
Can you replicate the same on our demo (http://demo.civicrm.org/)

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

bradb

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.2
  • CMS version: Joomla 2.5
  • MySQL version: 5.1.57-community
  • PHP version: 5.3
Re: How to import the time with the date?
November 16, 2012, 12:21:25 pm
I can't remember the exact format to insert a time into a field. I think if you did a db export of some table in civi that was keeping time records and just used that format, it would work. For example, create an event with a particular start time and then export that table to a csv and you will see the format that it needs to be in.

matthewykk

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.0.5
  • CMS version: Drupal 7.8
  • MySQL version: mySQL 5.1.41
  • PHP version: phpmyadmin 3.2.4
Re: How to import the time with the date?
November 19, 2012, 02:06:24 am
Quote from: bradb on November 16, 2012, 12:21:25 pm
I can't remember the exact format to insert a time into a field. I think if you did a db export of some table in civi that was keeping time records and just used that format, it would work. For example, create an event with a particular start time and then export that table to a csv and you will see the format that it needs to be in.


Thank you for your suggestion. 

I tried your suggestion.  However, it's keep error again.

That's what I Imported:   December 12, 2012 10:30
The result what I see:  December 12,2012 12:00

The time still show 12:00 only.   Didn't show 10:30

 :'(
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • How to import the time with the date?

This forum was archived on 2017-11-26.