search

zdavatz / oddb2xml

oddb2xml, create xml files using refdata, swissmedic and bag xml files
http://www.ywesee.com/Oddb2xml/Index
GNU General Public License v3.0
8 stars 5 forks source link

invalid value for Integer(): "0707387007355" (ArgumentError) #8

Closed col-panic closed 10 years ago

col-panic commented 10 years ago

Aufruf mit Executing /usr/local/bin/oddb2xml -f dat -p zurrose -a nonpharma -e ..

merci

12:54:49 Executing /usr/local/bin/oddb2xml -p zurrose -a nonpharma -e 17:14:12 DE 17:14:12 Pharma products: 15443 17:14:12 NonPharma products: 28884 17:14:12 FR 17:14:12 Pharma products: 15443 17:14:12 NonPharma products: 28884 17:14:12 2014-04-04 17:14:11 +0200: 98 done 17:14:12 Added 53075 via pharmacodes of 136723 items when extracting the transfer.dat from "Zur Rose" 17:14:12 found 773 lines with duplicated ean13 17:14:13 Executing /usr/local/bin/oddb2xml -f dat -p zurrose -a nonpharma -e 17:15:49 /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1091:in %': invalid value for Integer(): "0707387007355" (ArgumentError) 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1091:inblock (2 levels) in build_with_migel_dat' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1066:in each' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1066:ineach_with_index' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1066:in block in build_with_migel_dat' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1065:ineach' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:1065:in build_with_migel_dat' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/builder.rb:57:into_dat' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:139:in block (2 levels) in build' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:127:ineach' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:127:in block in build' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:93:ineach_pair' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:93:in build' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:86:inrun' 17:15:49 from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/bin/oddb2xml:94:in <top (required)>' 17:15:49 from /usr/local/bin/oddb2xml:23:inload' 17:15:49 from /usr/local/bin/oddb2xml:23:in `

' 17:15:49 Added 53075 via pharmacodes of 136723 items when extracting the transfer.dat from "Zur Rose" 17:15:49 found 773 lines with duplicated ean13 17:15:49 Build step 'Execute shell' marked build as failure 17:15:49 Finished: FAILURE

zdavatz commented 10 years ago

Ein XLS File ist neu ein XLSX. Mit der folgenden Option geht es:

oddb2xml -e --skip-download

dann das File swissmedic_orphan.xls

nach

data/downloads

kopieren und nochmals laufen lassen mit

oddb2xml -e --skip-download

zdavatz commented 10 years ago

Wir arbeiten gerade an einer neuen Version, welche mit dem neuen XLSX File umgehen kann.

col-panic commented 10 years ago

Hy,

das bewirkt bei mir

jenkins@srv:/home/artikelstamm/oddb2xml$ /usr/local/bin/oddb2xml -p zurrose -a nonpharma -e --skip-download /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:378:in validate!': OLE2 signature is invalid (Ole::Storage::FormatError) from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:370:ininitialize' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:112:in new' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:112:inload' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:79:in initialize' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:85:innew' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/ruby-ole-1.2.11.7/lib/ole/storage/base.rb:85:in open' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/spreadsheet-0.9.6/lib/spreadsheet/excel/reader.rb:1276:insetup' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/spreadsheet-0.9.6/lib/spreadsheet/excel/reader.rb:134:in read' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/spreadsheet-0.9.6/lib/spreadsheet/excel/workbook.rb:32:inopen' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/spreadsheet-0.9.6/lib/spreadsheet.rb:63:in open' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/spreadsheet-0.9.6/lib/spreadsheet.rb:69:inopen' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/extractor.rb:205:in initialize' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:183:innew' from /home/jenkins/.rvm/gems/ruby-1.9.3-p448/gems/oddb2xml-1.7.8/lib/oddb2xml/cli.rb:183:in `block in download'

merci

Marco Descher Sent with Airmail

Am 08. April 2014 bei 10:24:51, Zeno R.R. Davatz (notifications@github.com) schrieb:

--skip-download

zdavatz commented 10 years ago

genau. Jetzt noch das swissmedic_orphan.xls (gestern per Mail zugestellt) nach data/downloads kopieren und dann sollte es klappen mit

oddb2xml -e --skip-download

[ '-a nonpharma -p zurrose' ist alles im '-e' enthalten ]