getFilePath()); $source_config = $source->getConfigFor($this); $parser = new ParserCSV(); $delimiter = $source_config['delimiter'] == 'TAB' ? "\t" : $source_config['delimiter']; $parser->setDelimiter($delimiter); $header = $this->parseHeader($parser, $iterator); if (!header) { return; } $parser->setColumnNames($header); // Populate batch. $batch->setItems($this->parseItems($parser, $iterator)); } /** * Get first line and use it for column names, convert them to lower case. * Be aware that the $parser and iterator objects can be modified in this * function since they are passed in by reference * * @param ParserCSV $parser * @param ParserCSVIterator $iterator * @return * An array of lower-cased column names to use as keys for the parsed items. */ protected function parseHeader(ParserCSV $parser, ParserCSVIterator $iterator) { $parser->setLineLimit(1); $rows = $parser->parse($iterator); if (!count($rows)) { return FALSE; } $header = array_shift($rows); foreach ($header as $i => $title) { $header[$i] = trim(drupal_strtolower($title)); } return $header; } /** * Parse all of the items from the CSV. * * @param ParserCSV $parser * @param ParserCSVIterator $iterator * @return * An array of rows of the CSV keyed by the column names previously set */ protected function parseItems(ParserCSV $parser, ParserCSVIterator $iterator) { // Set line limit to 0 and start byte to last position and parse rest. $parser->setLineLimit(0); $parser->setStartByte($parser->lastLinePos()); $rows = $parser->parse($iterator); return $rows; } /** * Override parent::getMappingSources(). */ public function getMappingSources() { return FALSE; } /** * Override parent::getSourceElement() to use only lower keys. */ public function getSourceElement(FeedsImportBatch $batch, $element_key) { return parent::getSourceElement($batch, drupal_strtolower($element_key)); } /** * Define defaults. */ public function sourceDefaults() { return array( 'delimiter' => $this->config['delimiter'], ); } /** * Source form. * * Show mapping configuration as a guidance for import form users. */ public function sourceForm($source_config) { $form = array(); $form['#weight'] = -10; $mappings = feeds_importer($this->id)->processor->config['mappings']; $sources = $uniques = array(); foreach ($mappings as $mapping) { $sources[] = check_plain($mapping['source']); if ($mapping['unique']) { $uniques[] = check_plain($mapping['source']); } } $items = array( t('Import !csv_files with one or more of these columns: !columns.', array('!csv_files' => l(t('CSV files'), 'http://en.wikipedia.org/wiki/Comma-separated_values'), '!columns' => implode(', ', $sources))), format_plural(count($uniques), t('Column !column is mandatory and considered unique: only one item per !column value will be created.', array('!column' => implode(', ', $uniques))), t('Columns !columns are mandatory and values in these columns are considered unique: only one entry per value in one of these column will be created.', array('!columns' => implode(', ', $uniques)))), ); $form['help']['#value'] = '
'. theme('item_list', array('items' => $items)) .'
'; $form['delimiter'] = array( '#type' => 'select', '#title' => t('Delimiter'), '#description' => t('The character that delimits fields in the CSV file.'), '#options' => array( ',' => ',', ';' => ';', 'TAB' => 'TAB', ), '#default_value' => isset($source_config['delimiter']) ? $source_config['delimiter'] : ',', ); return $form; } /** * Define default configuration. */ public function configDefaults() { return array('delimiter' => ','); } /** * Build configuration form. */ public function configForm(&$form_state) { $form = array(); $form['delimiter'] = array( '#type' => 'select', '#title' => t('Default delimiter'), '#description' => t('Default field delimiter.'), '#options' => array( ',' => ',', ';' => ';', 'TAB' => 'TAB', ), '#default_value' => $this->config['delimiter'], ); return $form; } }