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 time parsing fails due to bad characters #24

Open
Arpan-Kreeti opened this issue Oct 27, 2022 · 1 comment
Open

Date time parsing fails due to bad characters #24

Arpan-Kreeti opened this issue Oct 27, 2022 · 1 comment
Labels
fix in next version The fix for this is already made in the next version of the app

Comments

@Arpan-Kreeti
Copy link
Collaborator

The following rows lead to an error like

Error:

%FunctionClauseError{
  args: nil,
  arity: 2,
  clauses: nil,
  function: :fixed_integer_impl,
  kind: nil,
  module: Combine.Parsers.Text
}

Data:

"a080W00001U6ghZQAR","0","SCH-0317-116982","2017-03-22 11:08:42","005d0000001KYMqAAO","2017-03-22 11:08:42","005d0000001KYMqAAO","2017-03-22 11:08:42","0030W00003Kn7kTQAR","0","Master","","","�vora University","masters","","Contemporary Art History","1"

This happens due to a bad character in the data "�vora University".
It fails in the call to Timex.parse(item, pattern) in apps/csv2sql/lib/csv2sql/schema_maker.ex line 209 and 213

@Arpan-Kreeti
Copy link
Collaborator Author

Arpan-Kreeti commented Oct 27, 2022

Note to self: Maybe wrap calls to Timex in try catch to get rid of such issues

@Arp-G Arp-G added the fix in next version The fix for this is already made in the next version of the app label Jan 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
fix in next version The fix for this is already made in the next version of the app
Projects
None yet
Development

No branches or pull requests

2 participants