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

Problem with using Excel file #13

Open
kitenetter opened this issue Jan 6, 2025 · 1 comment
Open

Problem with using Excel file #13

kitenetter opened this issue Jan 6, 2025 · 1 comment
Assignees

Comments

@kitenetter
Copy link
Collaborator

I uploaded a set of records from a .xlsx file, and got some unhelpful results on the validation page:

image

I save the file as csv, and in that format it was successfully validated:

image

Files uploaded:

Record Cleaner example files.zip

@JimBacon
Copy link
Member

JimBacon commented Jan 6, 2025

Thanks Martin.
Those sorts of error messages come from the input validation library and are a bit out of my hand.
What they are saying is that a date string was expected and something else was received.
I daresay that will be have something to do with Excel storing dates as floating point numbers internally.
That theory would explain why the CSV file worked perfectly okay.
We should look at improving this experience.

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

2 participants