laptop and a wrench

Erro

For certain date field formats in an Excel file, the date/time is changed when viewing the data as a published hosted service.

Última Publicação: January 21, 2020 Portal for ArcGIS
Número de ID do Erro BUG-000127923
EnviadoJanuary 14, 2020
Última ModificaçãoJune 5, 2024
Aplica-se àPortal for ArcGIS
Versão encontrada10.7.1
Sistema OperacionalN/A
Versão do Sistema OperacionalN/A
StatusKnown Limit

Informações Adicionais

This bug is a user error. The published service from the excel file shows the date and time values correctly. In the video, the user checked the date field values in the Portal home app Data tab, the date and time shown here in the home app are based on the timezone set on user system or browser settings. To get the correct values in the home app, ensure the system time zone is set correctly. For example, if time is set to PST, the values shown are in PST. The best place to look for the correct values is to go to server rest (https:///server/rest/services/Hosted/test/FeatureServer/0/query) and query the service to see the fields and their values. Here the date and time are shown in an epoch time format. The user needs to use an epoch converter to convert it into to GMT time. Refer to https://www.epochconverter.com/ for more information. The CSV time values correct to the user. The Date field was not recognized by the server because it is an unsupported format. The field type is identified as a string and the values are retained. The user thought this is the expected behavior. Check the field type in the server rest page of the service. This is actually a limitation for CSV format, the date fields are only identified when it is in a certain format, any other format of the date, for example, if it is danish style local format, it is taken as a string field and no conversion is applied while publishing. Documentation for reference: https://enterprise.arcgis.com/en/portal/latest/use/csv-gpx.htm#DATE

Solução Provisória

It works without any issue if the file is converted to CSV instead. Refer to the CSV file, 'testing'.

Etapas para Reproduzir

ID do Erro: BUG-000127923

Software:

  • Portal for ArcGIS

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download