I have spreadsheets with Date and Time fields. I assign them to a Reader in FME 2018 and funnel them through AttributeManager. When I check the output that comes out of the Writer, I see that the Date and Time fields have been modified. I have tried to find a setting in the Reader and transformer which would prevent these fields from changing so I don't have to use the DateTimeConverter. Does anyone have suggestions? The only solution I have found is to change the field in Excel to concatenate Date and Time. Then this field stays the same after the AttributeManager transformer. However, some of my spreadsheets don't have a time metric, just date. Thoughts?
Page 1 / 1
Hi @jencinas , need to know the situation more concretely.
Add two Inspectors to the workspace (connect one directly to the reader feature type, connect another to output port of the AttributeManager) and run. Then tell us how the Date and Time values at the two points (i.e. immediately after reading and the AttributeManager output) are shown in the FME Data Inspector.
Hi @Takashi Iijima , I solved the problem. Thank you for the suggestion. I realized my error. I failed to modify settings in the Writer for the Date and Time fields to tell it which formats I wanted. Ultimately, I wanted the date and time formats to remain the same. However, when I read data from these fields through a transformer, the output changes to an FME default unless the author specifies the format wanted such as MM/DD/YYYY for date or 13:30 for time. I am starting to use data inspectors through out my ETLs to troubleshoot now. Joe