Roo appears to be more fully featured than Spreadsheet, and it supports XLSX files whereas the latter does not. Other than that it seems to be a drop-in replacement.
Made row validation optional on ExcelParser.
I was running into issues where it's no big deal for my script to be smart enough to skip invalid rows but the whole ETL job would barf because one row was missing a field. putting :validate => false in the parser options will skip row-level validation.
Added SQLite3 to the insert_update_database destination. It works.
The changes to engine.rb are for ActiveRecord 3.2.x, which will not allow mass-assignment unless expressly enabled on the model. This change seemed easier than modifying the model class ETL::Execution::Job since I didn't know what might break if I change that class around.
thbar
commented
11 years ago
:validate => falsein the parser options will skip row-level validation.insert_update_databasedestination. It works.engine.rbare for ActiveRecord 3.2.x, which will not allow mass-assignment unless expressly enabled on the model. This change seemed easier than modifying the model classETL::Execution::Jobsince I didn't know what might break if I change that class around.