#579 Specify date format for import or exporting data

[Erwan Taloc]

Hello

today iTop support only on date format for importing data via the user interface.

Would it be possible to have a way to change this data format via the user interface when loading data like it is with the CLI ?

Moreover, i would be nice to specify this date format as well when using export.php with date parameter.

[Romain Quetiez]

• milestone set to 2.0

[Denis]

• milestone changed from 2.0 to Zanzibar

[mrandret]

It would be nice that the user is warned that the date was transformed into "0000-00-00" so that he can modify his format of date.

[Hipska]

Hello, one of our customers also came up to the conclusion that a date in their import was set to 000-00-00. Could this be fixed please?

[Vincent @ Combodo]

Hello Hipska,
Could you provide a bit more details about this?
Depending on your MySQL version, you can prevent 0000-00-00 date value from being loaded, check MySQL documentation for this.
It is possible that some past and old version of iTop were loading such 0000-00-00 format instead of NULL when no data was provided for a date field, but this is no more the case since quite a while.

It is now possible to specify the date format used during the CSV import phase as well as during a CSV export (date_format parameter), which was the request of this particular ticket.

[Hipska]

It is on a 2.2.1 and the user imported with csv: (and had no errors/warnings)

Purchase date set to 30/11/2015
End of warranty set to 31/12/2019

When he manually updated the object: (not these fields, but some other)

Purchase date set to 2016-03-18 (previous value: 0000-00-00)
End of warranty set to 2016-03-18 (previous value: 0000-00-00)

I indeed saw that in 2.3.1 you can set date format.