Define importers that load tabular data from spreadsheets or CSV files into any ActiveRecord-like ORM.
Add this line to your application's Gemfile:
And then execute:
Or install it yourself as:
$ gem install active_importer
Define classes that you instruct on how to import data into data models.
class EmployeeImporter < ActiveImporter::Base imports Employee column 'First name', :first_name column 'Last name', :last_name column 'Department', :department do |department_name| Department.find_by(name: department_name) end end
The importer defines what data model it imports data into, and how columns in the data source map to fields in the model. Also, by providing a block, the source value can be processed before being stored, as shown with the 'Department' column in the example above.
Once defined, importers can be invoked to import a given data file.
The data file is expected to contain columns with titles corresponding to the columns declared. Any extra columns are ignored. Any errors while processing the data file does not interrupt the whole process. Instead, errors are notified via some callbacks defined in the importer (see below).
For mote detailed information about the different aspects of importing data with
active_importer, refer to the following sections in the wiki.
- Custom data processing
- Helper methods
- File extension and supported formats
- Passing custom parameters
- Events and callbacks
- Selecting the model instance to import into (Update instead of create)
- Error handling
- Selecting the sheet to get data from
- Skipping rows
Contributions are welcome! Take a look at our contributions guide for details.