tag:blogger.com,1999:blog-6428221195565260149.post1258517303008852375..comments2024-02-17T06:29:58.224-08:00Comments on Drew's Robots: Gencon 2014 scheduler updateellindseyhttp://www.blogger.com/profile/14022730143917245371noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6428221195565260149.post-71698580051864886672016-05-14T19:15:23.898-07:002016-05-14T19:15:23.898-07:00I have an updated copy at https://www.dropbox.com/...I have an updated copy at https://www.dropbox.com/s/ulypjnj53mwbmpx/schedule%20solver%202016.py?dl=0 which seems to work with this year's data.<br /><br />However, I'm a bit surprised anyone is still using this archaic script, since there are far better options available for doing event search available now.ellindseyhttps://www.blogger.com/profile/14022730143917245371noreply@blogger.comtag:blogger.com,1999:blog-6428221195565260149.post-92090626202875268152016-05-14T18:38:05.855-07:002016-05-14T18:38:05.855-07:00Getting this error when trying to use the schedule...Getting this error when trying to use the scheduler for 2016. Any chances of you updating this again? <br /><br />Converting events.xlsx ...<br />Traceback (most recent call last):<br /> File "schedule solver 2014.py", line 2143, in <br /> events = update()<br /> File "schedule solver 2014.py", line 1695, in update<br /> xlsx2csv.convert(outfile, 0)<br /> File "C:\Users\randerson\Documents\Personal\Gencon\xlsx2csv.py", line 220, in convert<br /> of.write(self.options['sheetdelimiter'] + " " + str(s['id']) + " - " + sheetname + self.options['lineterminator'])<br />KeyError: 'lineterminator'roandershttps://www.blogger.com/profile/04393995800418846980noreply@blogger.comtag:blogger.com,1999:blog-6428221195565260149.post-78666993292006669012014-05-13T13:27:42.118-07:002014-05-13T13:27:42.118-07:00I don't know why specifically you'd be get...I don't know why specifically you'd be getting that error if you're using the same xlsx2csv code, since I took the keyword arguments straight from their code, but I've uploaded a new version of the code that omits those arguments (as they don't seem to do anything) and has a few other tweaks. Try downloading it again and trying it.ellindseyhttps://www.blogger.com/profile/14022730143917245371noreply@blogger.comtag:blogger.com,1999:blog-6428221195565260149.post-77087996461904652752014-05-13T13:09:50.148-07:002014-05-13T13:09:50.148-07:00Hi - Found your code and am trying it out. Install...Hi - Found your code and am trying it out. Installed xlsx2csv but still get this error:<br />Traceback (most recent call last):<br /> File "schedule solver 2014.py", line 2138, in <br /> events = update()<br /> File "schedule solver 2014.py", line 1687, in update<br /> xlsx2csv = Xlsx2csv(mydir + '/' + fn, **kwargs)<br />TypeError: __init__() got an unexpected keyword argument 'exclude_sheet_pattern'<br /><br />Any ideas?<br />Thanks!<br />-DAnonymousnoreply@blogger.com