date parameter

Hi,

 

 

Have you passed the parameter via the DateFormatter?

I am not a MapInfo user, hopefully one will pick up this thread.

 

What is the date format used in MapInfo?

Have you tried the following destination format : %d"/"%m"/"%Y in the DateFormatter?

and on the WRITER Schema you have defined the attribute type as DATE? From the help regarding date formats:

 

 

date

 

 

This is used to store and retrieve date information within a Geodatabase.

 

 

When a date field is read by the Geodatabase reader, it is placed in the FME feature with the form HHMMSS, YYYYMMDD, or YYYYMMDDHHMMSS. The time portion is specified using the 24-hour clock. When writing, the date attribute must also be in one of these three forms. These forms are compatible with all other FME dates.

 

 

When the Geodatabase writer creates a new table, all the fields, except for the object ID field, will be defined as allowing null values.

Hi,

 

 

Although FME treats dates as character strings while translating, the Writer will convert date strings (typically "yyyyMMdd" format) to date values automatically when writing them into Date type field of destination dataset, as far as I know.

 

How did you confirm that the values which have been written into the Date type field were still character strings?

 

 

Takashi

Since I don't have MapInfo unfortunately, cannot confirm that on MapInfo application. But contents of "tab" file (i.e. schema definition of the destination dataset) can be seen with a text editor.

 

This is raw contents of a "tab" file which I wrote with the FME MAPINFO writer. I specified "date" as type of "NewField" when writing, it looks to be distinguished clearly from other Char type fields. How's your "tab"?

 

-----

 

!table

 

!version 300

 

!charset WindowsJapanese

 

 

Definition Table

 

  Type NATIVE Charset "WindowsJapanese"

 

  Fields 6

 

    N03_001 Char (10) ;

 

    N03_002 Char (20) ;

 

    N03_003 Char (20) ;

 

    N03_004 Char (20) ;

 

    N03_007 Char (5) ;

 

    NewField Date ;

 

-----

hmm... I cannot reproduce the issue as same as yours in my environment (FME 2014 build 14235). The writer always creates Date field in "tab" file if I specified "date" type on the writer feature type.

 

It might be better that you contact Safe support with attaching the data and workspace in which the issue can be reproduced.

Hi again all,

 

I think I have found the problem. It appears to be an issue with the 'MITAB' writer. Those familiar will know that there are 2 MapInfo writers - MITAB (open source) and MFAL or just MAPINFO as it now appears in FME2014. The issue only occurs with the MITAB writer.