Re: Providing missing DOB in your results JSON

[Luis J. Iáñez]

-Dave +Software

First, Felix, thanks so much for your response.  As you're about to check, your reply enlightened me on what is going on here.

Funnily, it was *me* who produced the results JSON for River Hill Fall 2015 in the same computer I'm using now, as Felix had a problem with the scramble match and we were in a hurry because of the WR.

@Software, you don't have all the picture in this email, but the idea is that John Michaelson (read below) was not the only competitor with a DOB = "0002-11-30" in the database.  Seems that I spotted a bug.  I have documented it in https://github.com/cubing/wca-workbook-assistant/issues/111

Regards,

- Luis


On 14/01/2016 20:46, Felix Lee wrote:

Hi Luis,

Thanks for the notice. However, I recall clearly putting in this date when I submitted the XLSX file, and I double checked that 0000-00-00 is indeed the date that I put in the file that I sent to the results team. Perhaps I don't understand happened? Was I not supposed to do this?

Best,

Felix

On Thu, Jan 14, 2016 at 10:47 AM, Luis J. Iáñez <lu...@twisttheweb.com> wrote:

Dear Dave and Felix,

Just a quickie to let you know that cleaning up our database we found that some weird, fake DOB got filtered to our beloved database from a results JSON file coming from you:

From Felix - River Hill Fall 2015:

id	subId	name	countryId	gender	year	month	day	comments
2015MICH10	1	John Michaelson	USA	m	2	11	30

From Dave - Toronto Open Fall 2015:

id	subId	name	countryId	gender	year	month	day	comments
2015DIMA03	1	Owen DiManno	Canada	m	1900	1	1
2015WETT03	1	Jimmy Wettlaufer	Canada	m	1900	1	1

Just wanted to be sure that you're aware of the correct procedure when you have missing DOBs:  the system expects 0000-00-00 as DOB, and since Cubecomps doesn't allow these dates, you have to manually edit the XLSX file previous to processing it with the WCA Workbook Assistant.  All this, needless to say, if all your efforts in order to get those dates from the competitors is of no use.

Thank you! :)

- Luis

--
You received this message because you are subscribed to the Google Groups "WCA Results" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wca-results...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.