This function adds the file data to the values array

Parameters

$values: The default values array -contains all constants

$line: An array of values for the current line

$field2column: An array mapping values fields to line columns

Return value

Supplemented values array

Related topics

File

tripal_bulk_loader/includes/tripal_bulk_loader.loader.inc, line 878

Handles the actual loading of data.

Code

function tripal_bulk_loader_add_spreadsheetdata_to_values($values, $line, $field2column) {
  foreach ($values as $field => $value) {
    if (is_array($value)) {
      continue;
    }

    $column = $field2column[$field] - 1;
    if ($column < 0) {
      continue;
    }

    if (preg_match('/\S+/', $line[$column])) {
      $values[$field] = $line[$column];
    }
    else {
      unset($values[$field]);
    }
  }

  return $values;
}