Rubyzip error causing havoc in my logs

Question

Essentially my log files look something like this right now:

Invalid date/time in zip entry
Invalid date/time in zip entry
Invalid date/time in zip entry
Invalid date/time in zip entry
Invalid date/time in zip entry
Invalid date/time in zip entry
...

Now under some investigation, I've found that this is due to Rubyzip and also due to when I seem to open a file in the following way...

require 'roo'

#Define files to read with location specify

today_file=(File.dirname(__FILE__) + '/output/today-report.xlsx')

yesterday_file=(File.dirname(__FILE__) + '/output/yesterday-report.xlsx')

lm_file=(File.dirname(__FILE__) + '/output/lm-report.xlsx')

#Define initial variables
txls = Roo::Excelx.new(today_file)
yxls = Roo::Excelx.new(yesterday_file)
lmxls = Roo::Excelx.new(lm_file)

Essentially this code is using a Ruby library called 'Roo' to open up some spreadsheets. All the code does is specify the current folder/specific file and then open using Roo.

I've rewritten these lines a few different ways to try and stop Rubyzip being as irritating but to no avail. Does anybody have any clue as to what is wrong here?

Thanks.

Who's fork of Roo are you using? – Anthony Jan 08 '15 at 13:06 — Anthony, Jan 08 '15 at 13:06
Using roo 1.13.2 at the moment from master branch in git. – Matt Visser Jan 08 '15 at 14:25 — Matt Visser, Jan 08 '15 at 14:25
Which github? [this one](https://github.com/roo-rb/roo) ? – Anthony Jan 08 '15 at 14:28 — Anthony, Jan 08 '15 at 14:28
Bang on yeah. Should have linked myself, apologies! – Matt Visser Jan 08 '15 at 14:30 — Matt Visser, Jan 08 '15 at 14:30

score 1 · Accepted Answer · answered Dec 22 '16 at 11:16

1

Even better answer... add this to your ruby job

Zip.warn_invalid_date = false

answered Dec 22 '16 at 11:16

Matt Visser

102
8

Rubyzip error causing havoc in my logs

1 Answers1