opendataeditor icon indicating copy to clipboard operation
opendataeditor copied to clipboard

Date format changed at xlsx

Open elivivas opened this issue 1 year ago • 0 comments

Overview

-I upload a file in xlsx

OPEN DATA EDITOR-Plans estrateÌgics Barcelona Eixos-ODS modificado con info.xlsx

-and the same as url

https://docs.google.com/spreadsheets/d/1tcLbrMGDEdWQzxyLJoq4zb20OSC6nWi-/edit?pli=1&gid=368550936#gid=368550936

-In the xlsx file ODE detects an error in the date. The original file has the logical date format in spanish: 1/1/2030 (day/month/year).

original

-I go to ERRORS REPORT and I see that it has changed the date format to year/month and has also added time, which is not in the original format.

TIPO DE ERROR
  • I go to the metadata/ SCHEMA/FIELDS and I notice that in the field it identifies it as YEARMONTH.
field
  • On the other hand, in the same dataset uploaded by URL from google spreadsheet it does not detect any error.
URL
  • I change the field to DATE at xlsx file and the error disappears, but in fact, it is not the original format that I need.
Captura de pantalla 2024-10-22 a las 18 23 03

elivivas avatar Oct 22 '24 19:10 elivivas