}
/**
- * Process the form submission.
- *
- * @param array $params
- * @param string $db
- * @param \CRM_Core_Form $form
+ * Initialize the datasource, based on the submitted values stored in the user job.
*
* @throws \API_Exception
* @throws \CRM_Core_Exception
*/
- public function postProcess(&$params, &$db, &$form) {
- $file = $params['uploadFile']['name'];
- $firstRowIsColumnHeader = $params['skipColumnHeader'] ?? FALSE;
+ public function initialize(): void {
$result = self::_CsvToTable(
- $file,
- $firstRowIsColumnHeader,
- NULL,
- CRM_Utils_Array::value('fieldSeparator', $params, ',')
+ $this->getSubmittedValue('uploadFile')['name'],
+ $this->getSubmittedValue('skipColumnHeader'),
+ $this->getSubmittedValue('fieldSeparator') ?? ','
);
+ $this->addTrackingFieldsToTable($result['import_table_name']);
- $form->set('originalColHeader', CRM_Utils_Array::value('column_headers', $result));
- $form->set('importTableName', $result['import_table_name']);
$this->updateUserJobMetadata('DataSource', [
'table_name' => $result['import_table_name'],
- 'column_headers' => $firstRowIsColumnHeader ? $result['column_headers'] : [],
+ 'column_headers' => $this->getSubmittedValue('skipColumnHeader') ? $result['column_headers'] : [],
'number_of_columns' => $result['number_of_columns'],
]);
}
* File name to load.
* @param bool $headers
* Whether the first row contains headers.
- * @param string $tableName
- * Name of table from which data imported.
* @param string $fieldSeparator
* Character that separates the various columns in the file.
*
private static function _CsvToTable(
$file,
$headers = FALSE,
- $tableName = NULL,
$fieldSeparator = ','
) {
$result = [];
}
}
- if ($tableName) {
- CRM_Core_DAO::executeQuery("DROP TABLE IF EXISTS $tableName");
- }
$table = CRM_Utils_SQL_TempTable::build()->setDurable();
$tableName = $table->getName();
CRM_Core_DAO::executeQuery("DROP TABLE IF EXISTS $tableName");