gsheets error: Unknown pattern "d/m/yyyy".

[harishanumula]

It is getting parsed properly in the google sheets, even showing a calendar dropdown in sheets, but getting this error when importing in superset. @betodealmeida

[betodealmeida]

Thanks, @harishanumula! I'll do a quick fix to include the pattern. I'm currently working on a branch (https://github.com/betodealmeida/shillelagh/tree/icu) that will handle any pattern, but it's going to take some time.

[harishanumula]

Thanks @betodealmeida, please add all the date formats possible with date. like (mm/dd/yyyy), (dd/mm/yy), (dd/mm/yyyy)

[RhysDavis]

+1 to this!

[jesse042811]

Hey @betodealmeida - I am facing a similar issue with my dashboard.

Unknown pattern "yyyy-mm-dd".

[betodealmeida]

Thanks @jesse042811 — working on it right now, I should have a fix in the next few days.

[samlopezic]

Hi @betodealmeida thanks for looking into this. Adding my error.

Unknown pattern "dd-mm-yyyy"

Working on a Google Sheet with dates formated for Chile.

[jesse042811]

Any update on this bug? @betodealmeida

[betodealmeida]

@jesse042811 not yet, working on it tonight.

Can you share a spreadsheet where the problem happens so I can test?

[jesse042811]

I am thinking you mean screenshot and I will provide more information later tonight.

…

On Mon, Aug 30, 2021 at 11:05 AM Beto Dealmeida ***@***.***> wrote: @jesse042811 <https://github.com/jesse042811> not yet, working on it tonight. Can you share a spreadsheet where the problem happens so I can test? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#95 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AQYJ3JSDERMCZKBQ6ZZR5TDT7PB43ANCNFSM5BGFIO3A> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[betodealmeida]

@jesse042811 no, I really meant spreadsheet — a link to a spreadsheet where the date is formatted as "yyyy-mm-dd", so I can test the solution. It can have just 1 column and bogus data. I'll also create one to test, but I might overlook something, so if someone has a link that I can test it would be better.

[samlopezic]

Hi @betodealmeida , here is a spreeadsheet with pattern "dd-mm-yyyy"

https://docs.google.com/spreadsheets/d/1yL0dMFQpQTxXXMWEOcj8GRc90NBUz4aKVOfeMUCk2SM/edit?usp=sharing

Thanks

[betodealmeida]

@harishanumula @RhysDavis @jesse042811 @samlopezic I just released 1.0.4, with a full parser/formatter that should support any patterns. I tested with the patterns that you provided and also with the sheet that @samlopezic linked, and everything worked successfully.

Sorry for the delay, but I wanted to write a robust solution that should handle custom formats, not just the most popular ones. Let me know if you have any other problems!

[jesse042811]

@betodealmeida
Still not working for me, here is a spreadsheet from a project with a similar format. https://docs.google.com/spreadsheets/d/1Azlmysl62rK6a3fW2Tc287Egxoo3QvIMKhJ-u8eAMjc/edit#gid=0

[betodealmeida]

@jesse042811 can you share the spreadsheet with roberto@dealmeida.net? I'll take a look.

[betodealmeida]

Closing since I talked with @jesse042811 and the problem they're seeing is with an older version.