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.
| Reader Format | Input type | Output (CSV/Excel) | Output (Socrata) |
|---|---|---|---|
Esri SDE database | Auto detect FME and ISO format |
| ISO (auto format) |
Socrata | Auto detect FME and ISO format | ISO (auto format) | |
Socrata (Legacy) | Auto detect FME and ISO format |
| 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