Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

arcgis sink: transform vales for esriFieldTypeDate field automatically to timeinstamp from DateTime #2339

Closed
AlvaroVega opened this issue Feb 1, 2024 · 4 comments

Comments

@AlvaroVega
Copy link
Member

AlvaroVega commented Feb 1, 2024

No description provided.

@danielvillalbamota
Copy link
Collaborator

According to Arcgis documentation esriFieldTypeDate uses miliseconds to store timestamp from epoch.

@AlvaroVega
Copy link
Member Author

From cygnus documentation about arcgis sink: https://github.com/telefonicaid/fiware-cygnus/blob/master/doc/cygnus-ngsi/flume_extensions_catalogue/ngsi_arcgis_featuretable_sink.md#about-arcgis-data-types

esriFieldTypeDate

From https://doc.arcgis.com/en/data-pipelines/latest/process/output-feature-layer.htm

... Date fields are stored in feature layers using the format milliseconds from epoch and the coordinated universal time (UTC) time zone. The values will be displayed differently depending on where you are viewing the data. For example, querying the feature service REST end point will return values in milliseconds from epoch, such as 1667411518878....

So, to persist a esriFieldTypeDate field in the Feature Layer, cygnus has to receive an attribute "Number" from the CB with the milliseconds from epoch.

@fgalan
Copy link
Member

fgalan commented Feb 6, 2024

Fixed in PR #2341

@danielvillalbamota please close this issue after successfully testing (or provide extra feedback in negative case)

@danielvillalbamota
Copy link
Collaborator

It works.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants