Working with datetime
When encountering a scenario with datetime fields/columns make sure that the datetime format is setup in a way that the output writer will accept the datetime values depending.
Using the DateTimeConverter transformer - here is FME documentation on how it is used.
Esri SDE database
Auto detect FME and ISO format
%m/%d/%Y
ISO (auto format)
Socrata
Auto detect FME and ISO format
ISO (auto format)
Socrata (Legacy)
Auto detect FME and ISO format
%m/%d/%Y
ISO (auto format)
Generally "Allow null/missing/empty values" in the transformer so those values don't get sent to the <Rejected> output port. Unless the FME user wants those values separated in a different output port.
Socrata (Tyler) Writer in FME and Socrata set-up
The setting on the writer for datetime is auto-detected as text. the first time it is published. The publish setting is Replace | Use Existing.
After publishing the dataset the first time, you will have to manually change the date type from Edit > Review and Configure Data.
Change the datetime column from Text to Date & Time through Socrata the click OK > Update.
After that is done, change the FME writer setting to:
From Replace | Use Existing to Replace | Truncate
Last updated