[kronolith] Fwd: Kronolith/Mysql date import problem

Jan Schneider jan@horde.org
Mon, 17 Dec 2001 17:47:45 +0100


Zitat von kwong@nova.edu:

> Here's what I did:
> 1. I created two events through kronolith.  No problem.
> 2. I export all the events to a csv file.  No problem.
> 3. I deleted those two events and then do an import from the
>    same csv file.  No problem.
> 4. I noticed data.php require me to specify the date format (default is
>    mm/dd/yy).  In the kronolith_events table, default seems to be
> "yyyy/mm/dd
>    hh:mm:ss".  So, I pick the closest one yy/mm/dd.  (I also tried to
> modify 
>    the csv file from "2001" to "01", same result).
> 5. When I refresh my calendar, the two events didn't show up in year
> 2001.
>    However, when I looked at the "kronolith_events" table, I noticed
> the
>    event_start and event_end date both listed as "1969-12-31 19:00:00".

You have to select the format of the date fields in the csv file not of the 
mysql database. How should end users know the date format in the backend?

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::