Class: Importer

Inherits:
Object
  • Object
show all
Defined in:
lib/iron/import/importer.rb,
lib/iron/import/row.rb,
lib/iron/import/error.rb,
lib/iron/import/column.rb,
lib/iron/import/csv_reader.rb,
lib/iron/import/xls_reader.rb,
lib/iron/import/data_reader.rb,
lib/iron/import/html_reader.rb,
lib/iron/import/xlsx_reader.rb,
lib/iron/import/excel_reader.rb,
lib/iron/import/custom_reader.rb

Overview

Implements the entry-point for our importing system. To use, construct an importer using the builder syntax (examples below), then run one or more files or streams through the import system.

Constructing a simple importer:

importer = Importer.build do
  column :order_number
  column :date
  column :amount
end

To use this importer simply call:

if importer.import('/path/to/file.xls')
  importer.process do |row|
    puts "Order #{row[:order_number]: #{row[:amount]} on #{row[:date]}"
  end
end

A more realistic and complex example follows:

Importer.build do
  # Define our columns and their settings
  column :order_number do
    optional!
    header /order (\#|num.*|id)/i
    type :int
  end
  column :po_number do
    optional!
    type :string
    validate do |num|
      num.match(/[a-z0-9]{12}/i)
    end
  end
  column :date do
    type :date
  end
  column :amount do
    type :cents
  end
  virtual_column :tax do
    calculate do |row|
      row[:amount] * 0.05
    end
  end

  # When you have optional columns, you can validate that you have enough of them
  # using a custom block returning true if the found columns are good enough to 
  # continue.
  validate_columns do |cols|
    # Require either an order # or a PO # column
    keys = cols.collect(&:key)
    keys.include?(:order_number) || keys.include?(:po_number)
  end

  # Filter out any rows missing an order number
  filter do |row|
    !row[:order_number].nil? || !row[:po_number].nil?
  end

  # Use row-level validation to validate using
  # any or all column values for that row, to allow complex validation
  # scenarios that depend on the full context.
  validate_rows do |row|
    # Ensure PO Numbers are only valid starting in 2017
    add_error 'Invalid order - PO Num from before 2017' unless (row[:date] > Date.parse('2017-01-01') || row[:po_number].nil?)
  end

end.import('/path/to/file.csv', format: :csv) do |row|
  # Process each row as basically a hash of :column_key => value,
  # only called on import success
  Order.create(row.to_hash)

end.on_error do
  # If we have any errors, do something
  raise error_summary

end.on_success do
  # No errors, do this
  puts "Imported successfully!"
end

Defined Under Namespace

Classes: Column, CsvReader, CustomReader, Data, DataReader, Error, ExcelReader, HtmlReader, Row, XlsReader, XlsxReader

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(options = {}) ⇒ Importer

Ye standard constructor!



131
132
133
134
135
136
137
138
139
140
 
# File 'lib/iron/import/importer.rb', line 131

def initialize(options = {})
  @scopes = {}
  @encoding = 'UTF-8'
  @headerless = false

  @filter = nil
  @columns = []
  
  reset
end

Instance Attribute Details

#columns ⇒ Object (readonly)

Array of defined columns



98
99
100
 
# File 'lib/iron/import/importer.rb', line 98

def columns
  @columns
end

#custom_reader ⇒ Object (readonly)

Custom reader, if one has been defined using #on_file or #on_stream



100
101
102
 
# File 'lib/iron/import/importer.rb', line 100

def custom_reader
  @custom_reader
end

#data ⇒ Object (readonly)

Import data



104
105
106
 
# File 'lib/iron/import/importer.rb', line 104

def data
  @data
end

#format ⇒ Object (readonly)

Set to the format selected during past import



102
103
104
 
# File 'lib/iron/import/importer.rb', line 102

def format
  @format
end

#missing_headers ⇒ Object (readonly)

Missing headers post-import



106
107
108
 
# File 'lib/iron/import/importer.rb', line 106

def missing_headers
  @missing_headers
end

Class Method Details

.build(options = {}, &block) ⇒ Object

Create a new importer! See #build for details on what to do in the block.



124
125
126
127
128
 
# File 'lib/iron/import/importer.rb', line 124

def self.build(options = {}, &block)
  importer = Importer.new(options)
  importer.build(&block)
  importer
end

Instance Method Details

#add_error(msg, context = {}) ⇒ Object

Add an error to our error list. Will result in a failed import.



661
662
663
 
# File 'lib/iron/import/importer.rb', line 661

def add_error(msg, context = {})
  @data.errors << Error.new(msg, context)
end

#add_exception(ex, context = {}) ⇒ Object 



665
666
667
668
669
 
# File 'lib/iron/import/importer.rb', line 665

def add_exception(ex, context = {})
  line = ex.backtrace.first.extract(/[a-z0-9_\-\.]+\:[0-9]+\:/i)
  msg = [line, ex.to_s].list_join(' ')
  @data.errors << Error.new(msg, context)
end

#add_row(line, raw_data) ⇒ Object

Add a new row to our stash, parsing/filtering/validating as we go!



580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
 
# File 'lib/iron/import/importer.rb', line 580

def add_row(line, raw_data)
  # Gracefully handle custom parsers that return nil for a row's data
  raw_data ||= []
  # Add the row
  row = Row.new(self, line)
  
  # Parse out the values
  values = {}
  @columns.each do |col|
    if col.present? && !col.virtual?
      index = col.data.index
      raw_val = raw_data[index]
      # Otherwise use our standard parser
      val = @reader.parse_value(raw_val, col.type)
      if col.parses?
        # Use custom parser if this row has one
        val = col.parse_value(row, val)
      end
      values[col.key] = val
    end
  end

  # Set the values
  row.set_values(values)
  
  if !row.has_errors?
    # Filter if needed
    return nil if @filter && !@filter.call(row)

    # Calculate virtual columns' values
    @columns.each do |col|
      if col.virtual?
        row.values[col.key] = col.calculate_value(row)
      end
    end

    # Validate values if any column has a custom validator
    @columns.each do |col|
      if col.present? && col.validates?
        val = values[col.key]
        col.validate_value(row, val)
      end
    end
  
    # If we have a row validator, call it on the full row
    if @row_validator && !row.has_errors?
      valid = false
      had_error = Error.with_context(@importer, row, nil, nil) do
        valid = DslProxy.exec(self, row, &@row_validator)
      end
      if !had_error && valid.is_a?(FalseClass)
        add_error("Invalid row: #{row.to_hash.inspect}", :row => row)
      end
    end
  end

  # We is good
  @data.rows << row
  row
end

#build(&block) ⇒ Object

Call to define the importer’s column configuration and other setup options.

The following builder options are available:

importer = Importer.build do
  # Don't try to look for a header using column definitions, there is no header
  headerless!

  # Manually set the start row for data, defaults to nil
  # indicating that the data rows start immediatly following the header, or
  # at the first row if #headerless!.
  start_row 4

  # Define a filter that will skip unneeded rows.  The filter command takes
  # a block that receives the parsed (but not validated!) row data as an 
  # associative hash of :col_key => <parsed value>, and returns 
  # true to keep the row or false to exclude it.
  filter_rows do |row|
    row[:id].to_i > 5000
  end

  # If you need to process a type of input that isn't built in, define
  # a custom reader with #on_file or #on_stream
  on_file do |path|
    ... read file at path, return array of each row's raw column values ...
  end

  # Got a multi-block format like Excel or HTML?  You can optionally limit 
  # searching by setting a scope or scopes to search:
  scope :xls, 'Sheet 2'
  # Or set a bunch of scopes in one go:
  scopes :html => ['div > table.data', 'table.aux-data'],
         :xls => [2, 'Orders']

  # Of course, the main thing you're going to do is to define columns.  See the
  # Column class' notes for options when defining a column.  Note that
  # you can define columns using either hash-style:
  column :id, :type => :integer
  # or builder-style:
  column :name do
    header /company\s*name/i
    type :string
  end
end



186
187
188
189
 
# File 'lib/iron/import/importer.rb', line 186

def build(&block)
  DslProxy.exec(self, &block) if block
  self
end

#column(key, options_hash = {}, &block) ⇒ Object

Add a new column definition to our list, allows customizing the new column with a builder block. See Importer::Column docs for options. In lieu of a builder mode, you can pass the same values as key => value pairs in the options hash to this method, so:

column(:foo) do
  type :string
  parse do |val|
    val.to_s.upcase
  end
end

Is equivalent to:

column(:foo, :type => :string, :parse => lambda {|val| val.to_s.upcase})

Use whichever you prefer!



208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
 
# File 'lib/iron/import/importer.rb', line 208

def column(key, options_hash = {}, &block)
  # Find existing column with key to allow re-opening an existing definition
  key = key.to_sym
  col = @columns.detect {|c| c.key == key }
  unless col
    # if none found, add a new one
    col = Column.new(self, key, options_hash)
    @columns << col
  end
  
  # Customize if needed
  DslProxy::exec(col, &block) if block
  
  col
end

#error_summary ⇒ Object

Returns a human-readable summary of the errors present on the importer, or nil if no errors are present



673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
 
# File 'lib/iron/import/importer.rb', line 673

def error_summary
  # Simple case
  return nil unless has_errors?

  # Group by error text - we often get the same error dozens of times
  list = {}
  @data.errors.each do |err|
    errs = list[err.text] || []
    errs << err
    list[err.text] = errs
  end
  
  # Build summary & return
  list.values.collect do |errs|
    err = errs.first
    if errs.count == 1
      err.summary
    else
      summary = [err.column.to_s, err.text].list_join(': ')
      errs.count.to_s + ' x ' + summary
    end
  end.list_join(', ')
end

#errors ⇒ Object

Array of error messages collected during an import/process run



650
651
652
 
# File 'lib/iron/import/importer.rb', line 650

def errors
  @data.errors
end

#filter_rows(*args, &block) ⇒ Object

Alias for #filter



118
 
# File 'lib/iron/import/importer.rb', line 118

def filter_rows(*args, &block); filter(*args, &block); end

#find_header(raw_rows) ⇒ Object

Process the raw values for the first rows in a sheet, and attempt to build a map of the column layout, and detect the first row of real data



503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
 
# File 'lib/iron/import/importer.rb', line 503

def find_header(raw_rows)
  if headerless?
    # Use implicit or explicit column position when told to not look for a header
    next_index = 0
    @columns.each do |col|
      unless col.position.nil?
        next_index = col.fixed_index
      end
      col.data.index = next_index
      next_index += 1
    end
    @data.start_row = @start_row || 1
    @missing_headers = []
    return true
    
  else
    # Match by testing
    missing = []
    raw_rows.each_with_index do |row, i|
      # Um, have data?
      next unless row
      
      # Set up for this iteration
      remaining = @columns.select {|c| !c.virtual? }
  
      # Step through this row's raw values, and look for a matching header for all columns
      row.each_with_index do |val, i|
        val = val.to_s
        col = remaining.detect {|c| c.match_header?(val, i) }
        if col
          remaining -= [col]
          col.data.index = i
          col.data.header_text = val
        end
      end
      # Reset remaining cols
      remaining.each do |col| 
        col.data.index = nil
        col.data.header_text = nil
      end

      # Have we found them all, or at least a valid sub-set?
      header_found = remaining.empty?
      unless header_found
        if found_columns.any? && remaining.all?(&:optional?)
          if @column_validator
            # Run custom column validator
            valid = false
            had_error = Error.with_context(@importer, nil, nil, nil) do
              valid = DslProxy.exec(self, found_columns, &@column_validator)
            end
            header_found = !had_error && valid
          else
            # No validator... do we have any found columns at all???
            header_found = @columns.any?(&:present?)
          end
        end
      end
      if header_found
        # Found all columns, have a map, update our start row to be the next line and return!
        @data.start_row = @start_row || i+2
        @missing_headers = []
        return true
      else
        # Didn't find 'em all, remember this set of missing ones for reporting later
        remaining.select! {|col| !col.optional? }
        missing = remaining if missing.empty? || missing.count > remaining.count
      end
    end
    
    # If we get here, we're hosed
    @missing_headers = missing.collect(&:key) if @missing_headers.empty? || @missing_headers.count > missing.count
    false
  end
end

#found_columns ⇒ Object 



645
646
647
 
# File 'lib/iron/import/importer.rb', line 645

def found_columns
  @columns.select(&:present?).sort_by(&:index)
end

#has_errors? ⇒ Boolean

When true, one or more errors have been recorded during this import/process cycle.

Returns:

  • (Boolean) 


656
657
658
 
# File 'lib/iron/import/importer.rb', line 656

def has_errors?
  @data.errors.any?
end

#import(path_or_stream, options = {}, &block) ⇒ Object

First call to a freshly #build’d importer, this will read the file/stream/path supplied, validate the required values, run custom validations… basically pre-parse and massage the supplied data. It will return true on success, or false if one or more errors were encountered and the import failed.

You may supply various options for the import using the options hash. Supported options include:

format: one of :auto, :csv, :html, :xls, :xlsx, defaults to :auto, forces treating the supplied
        source as the specified format, or attempts to auto-detect if set to :auto
scope: specify the search scope for the data/format, overriding any scope set with #scope
encoding: source encoding override, defaults to guessing based on input

Generally, you should be able to throw a path or stream at it and it should work. The options exist to allow overriding in cases where the automated heuristics have failed and the input type is known by the caller.

If you’re trying to import from a raw string, use Importer#import_string instead.

After #import has completed successfully, you can process the resulting data using #process or extract the raw data by calling #to_a to get an array of row hashes

Note that as of version 0.7.0, there is a more compact operation mode enabled by passing a block to this call:

importer.import(...) do |row|
  # Process each row here
end

In this mode, the block is called with each row as in #process, conditionally on no errors. In addition, when a block is passed, true/false is not returned (as the block is already conditionally called). Instead, it will return the importer to allow chaining to #on_error or other calls.



332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
 
# File 'lib/iron/import/importer.rb', line 332

def import(path_or_stream, options = {}, &block)
  # Clear all our load-time state, including all rows, header locations... you name it
  reset
  
  # Get the reader for this format
  default = @custom_reader ? :custom : :auto
  @format = options.delete(:format) { default }
  if @format == :custom
    # Custom format selected, use our internal custom reader
    @reader = @custom_reader
    
  elsif @format && @format != :auto
    # Explicit format requested
    @reader = DataReader::for_format(self, @format)
    
  else
    # Auto select
    @reader = DataReader::for_source(self, path_or_stream)
    @format = @reader.format if @reader
  end

  # Verify we got one
  unless @reader
    add_error("Unable to find format handler for format :#{format} on import of #{path_or_stream.class.name} source - aborting")
    return
  end
  
  # What scopes (if any) should we limit our searching to?
  scopes = options.delete(:scope) { @scopes[@format] }
  if scopes && !scopes.is_a?(Array)
    scopes = [scopes]
  end

  # Read in the data!
  loaded = false
  @reader.load(path_or_stream, scopes) do |raw_rows|
    # Find our column layout, start of data, etc
    if find_header(raw_rows)
      # Now, run all the data and add it as a Row instance
      raw_rows.each_with_index do |raw, index|
        row_num = index + 1
        if row_num >= @data.start_row
          add_row(row_num, raw)
        end
      end
      # We've found a workable sheet/table/whatever, stop looking
      loaded = true
      true
      
    else
      # This sheet/table/whatever didn't have the needed header, try
      # the next one (if any)
      false
    end
  end
  
  # Verify that we found a working set of rows
  unless loaded
    # If we have any missing headers, note that fact
    if @missing_headers && @missing_headers.count > 0
      add_error("Unable to locate required column header for column(s): " + @missing_headers.collect{|c| ":#{c}"}.list_join(', '))
    else 
      add_error("Unable to locate required column headers!")
    end
  end
  
  # If we're here with no errors, we rule!
  success = !has_errors?
  
  if block
    # New way, if block is passed, process it on success
    process(&block) if success
    self
  else
    # Old way, return result
    success
  end
end

#import_string(string, options = {}, &block) ⇒ Object

Use this form of import for the common case of having a raw CSV or HTML string.



412
413
414
415
416
417
418
419
420
421
422
423
424
425
 
# File 'lib/iron/import/importer.rb', line 412

def import_string(string, options = {}, &block)
  # Get a format here if needed
  if options[:format].nil? || options[:format] == :auto
    if @custom_reader
      format = :custom
    else
      format = string.include?('<table') && string.include?('</tr>') ? :html : :csv
    end
    options[:format] = format
  end
  
  # Do the import, converting the string to a stream
  import(StringIO.new(string), options, &block)
end

#on_error(&block) ⇒ Object

Call with a block to process error handling tasks. Block will only execute if an error (read, validate, exception, etc.) has occurred during the just-completed #import.

Your block can access the #error_summary or the #errors array to do whatever logging, reporting etc. is desired.



448
449
450
451
452
453
454
455
456
457
458
459
460
 
# File 'lib/iron/import/importer.rb', line 448

def on_error(&block)
  raise 'Invalid block passed to Importer#on_error: block may accept 0, 1 or 2 arguments' if block.arity > 2
  
  if has_errors?
    case block.arity
    when 0 then DslProxy.exec(self, &block)
    when 1 then DslProxy.exec(self, errors, &block)
    when 2 then DslProxy.exec(self, errors, error_summary, &block)
    end
  end
  
  self
end

#on_file(&block) ⇒ Object

Define a custom file reader to implement your own parsing. Pass a block accepting a file path, and returning an array of arrays (rows of raw column values). Use #add_error(msg) to add a reading error.

Adding a custom file/stream parser will change the importer’s default format to :custom, though you can override it when calling #import as usual.

Only one of #on_file or #on_stream needs to be implemented - the importer will cross convert as needed!

Example:

on_file do |path|
  # Read a file line by line
  File.readlines(path).collect do |line|
    # Each line has colon-separated values, so split 'em up
    line.split(/\s*:\s*/)
  end
end



275
276
277
278
 
# File 'lib/iron/import/importer.rb', line 275

def on_file(&block)
  @custom_reader = CustomReader.new(self) unless @custom_reader
  @custom_reader.set_reader(:file, block)
end

#on_stream(&block) ⇒ Object

Just like #on_file, but for streams. Pass a block accepting a stream, and returning an array of arrays (rows of raw column values). Use #add_error(msg) to add a reading error.

Example:

on_stream do |stream|
  # Stream contains rows separated by a | char
  stream.readlines('|').collect do |line|
    # Each line has 3 fields of 10 characters each
    [line[0...10], line[10...20], line[20...30]]
  end
end



294
295
296
297
 
# File 'lib/iron/import/importer.rb', line 294

def on_stream(&block)
  @custom_reader = CustomReader.new(self) unless @custom_reader
  @custom_reader.set_reader(:stream, block)
end

#on_success(&block) ⇒ Object

Call with a block to process any post-import tasks. Block will only execute if an import has been run with no errors.

Your block can access the #rows to do whatever logging, reporting etc. is desired.



467
468
469
470
471
472
473
474
475
476
477
478
 
# File 'lib/iron/import/importer.rb', line 467

def on_success(&block)
  raise 'Invalid block passed to Importer#on_succes: block may accept 0 or 1arguments' if block.arity > 1
  
  if @data.rows.any? && !has_errors?
    case block.arity
    when 0 then DslProxy.exec(self, &block)
    when 1 then DslProxy.exec(self, @data.rows, &block)
    end
  end
  
  self
end

#process(&block) ⇒ Object

Call with a block accepting a single Importer::Row with contents that look like :column_key => <parsed value>. Any filtered rows will not be present. If you want to register an error, simply raise “some text” or call #add_error and it will be added to the importer’s error list for display to the user, logging, or whatever.



432
433
434
435
436
437
438
439
440
 
# File 'lib/iron/import/importer.rb', line 432

def process(&block)
  @data.rows.each do |row|
    begin
      DslProxy.exec(self, row, &block)
    rescue Exception => e
      add_exception(e, :row => row)
    end
  end
end

#rows ⇒ Object 



641
642
643
 
# File 'lib/iron/import/importer.rb', line 641

def rows
  @data.rows
end

#scope(format, *scopes) ⇒ Object

Limit the search scope for a single format (:xls, :xlsx, :html, :custom) to the given value or values - the meaning and format of scopes is determined by that format’s data reader.



232
233
234
 
# File 'lib/iron/import/importer.rb', line 232

def scope(format, *scopes)
  @scopes[format] = scopes.flatten
end

#scopes(map = :__read__) ⇒ Object

Limit the search scope for more than one format at a time. For example, if you support both XLS and XLSX formats (and why wouldn’t you?) then you could tell the importer to look only at the sheets named “Orders” and “Legacy Orders” like so:

scopes :xls => ['Orders', 'Legacy Orders'],
       :xlsx => ['Orders', 'Legacy Orders']



244
245
246
247
248
249
250
251
252
 
# File 'lib/iron/import/importer.rb', line 244

def scopes(map = :__read__)
  if map == :__read__
    return @scopes
  else
    map.each_pair do |format, scope|
      scope(format, scope)
    end
  end
end

#to_a ⇒ Object

After calling #import, you can dump the final values for each row as an array of hashes. Useful in debugging! For general processing, use #process or the block form of #import instead.



700
701
702
 
# File 'lib/iron/import/importer.rb', line 700

def to_a
  @data.rows.collect(&:values)
end

#validate_columns(&block) ⇒ Object

Call with a block accepting an array of Column objects and returning true if the columns in the array should constitute a valid header row. Intended for use with optional columns to define multiple supported column sets, or conditionally required secondary columns. Columns will be passed in in the order detected, so you can use ordering to help determine which columns are required if that helps.



486
487
488
489
 
# File 'lib/iron/import/importer.rb', line 486

def validate_columns(&block)
  raise 'Invalid block passed to Importer#validate_columns: block should accept a single argument' if block.arity != 1
  @column_validator = block
end

#validate_rows(&block) ⇒ Object

Call with a block accepting a single Row instance. Just like Column#validate, you can fail by returning false, calling #add_error(msg) or by raising an exception. The intent of this method of validation is to allow using the full row context to validate



495
496
497
498
 
# File 'lib/iron/import/importer.rb', line 495

def validate_rows(&block)
  raise 'Invalid block passed to Importer#validate_columns: block should accept a single Row argument' if block.arity != 1
  @row_validator = block
end

#virtual_column(key, options_hash = {}, &block) ⇒ Object 



224
225
226
227
 
# File 'lib/iron/import/importer.rb', line 224

def virtual_column(key, options_hash = {}, &block)
  options_hash[:virtual] = true
  column(key, options_hash, &block)
end