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

Date format changed at xlsx #610

Open
elivivas opened this issue Oct 22, 2024 · 0 comments
Open

Date format changed at xlsx #610

elivivas opened this issue Oct 22, 2024 · 0 comments

Comments

@elivivas
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Backlog
Development

No branches or pull requests

1 participant