Export and Import error

[fmbug]

Dear All,

 

I am facing a problem which i had never thought before.

 

Actually I have a FileMaker database. After that I made a project using PHP-MySql, which the same functionality and interface which is there in FileMaker. Now I want to export the FileMaker data and import it into PHP-MySql.... Each and every data is exported and imported successfully but the problem is only with Date and TimeStamp data. Exporting is successful, while importing it is giving something like 0000-00-00 00:00:00...

 

Please help me n suggest me to overcome it.

 

Thanks in advance...

[Claus Lavendt]

Hi

The problem is for sure that MySQL has different date/time format than Filemaker.

Your data must be in the correct format, before you can import into MySQL.

[doughemi]

See this custom function to convert the FM timestamp to a MySQL DATETIME string.

[fmbug]

Thanks 2 both of you. It is completed.