public static function createTempTableByFileNameAndTableName($fileName, $tableName, $firstRowIsHeader = false, $pathToFiles = null, $delimiter = ',', $enclosure = '"')
 {
     assert('is_string($fileName)');
     assert('is_string($tableName)');
     if ($pathToFiles == null) {
         $pathToFiles = Yii::getPathOfAlias('application.modules.import.tests.unit.files');
     }
     $filePath = $pathToFiles . DIRECTORY_SEPARATOR . $fileName;
     // Use this for just those two files, because orginal files will be overwritten
     // For these two files, we make backup
     if ($fileName == 'importTestMacOsLineEndingsCopy.csv' || $fileName == 'importTestWindowsCopy.csv') {
         ImportUploadedFileUtil::convertWindowsAndMacLineEndingsIntoUnixLineEndings($filePath);
     }
     $fileHandle = fopen($filePath, 'r');
     if ($fileHandle !== false) {
         $created = ImportDatabaseUtil::makeDatabaseTableByFileHandleAndTableName($fileHandle, $tableName, $delimiter, $enclosure, $firstRowIsHeader);
         assert('$created');
         return true;
     }
     return false;
 }
 /**
  * Ajax action called from user interface to upload an import file. If a file for this import model is
  * already uploaded, then this will overwrite it.
  * @param string $filesVariableName
  * @param string $id (should be integer, but php type casting doesn't work so well)
  */
 public function actionUploadFile($filesVariableName, $id)
 {
     assert('is_string($filesVariableName)');
     $import = Import::getById((int) $id);
     $importWizardForm = ImportWizardUtil::makeFormByImport($import);
     $importWizardForm->setAttributes($_POST['ImportWizardForm']);
     if (!$importWizardForm->validateRowColumnDelimeterIsNotEmpty()) {
         $fileUploadData = array('error' => Zurmo::t('ImportModule', 'Error: Invalid delimiter'));
     } elseif (!$importWizardForm->validateRowColumnEnclosureIsNotEmpty()) {
         $fileUploadData = array('error' => Zurmo::t('ImportModule', 'Error: Invalid qualifier'));
     } else {
         try {
             $uploadedFile = ImportUploadedFileUtil::getByNameCatchErrorAndEnsureFileIsACSV($filesVariableName);
             assert('$uploadedFile instanceof CUploadedFile');
             ImportUploadedFileUtil::convertWindowsAndMacLineEndingsIntoUnixLineEndings($uploadedFile->getTempName());
             $fileHandle = fopen($uploadedFile->getTempName(), 'r');
             if ($fileHandle !== false) {
                 $tempTableName = $import->getTempTableName();
                 try {
                     $tableCreated = ImportDatabaseUtil::makeDatabaseTableByFileHandleAndTableName($fileHandle, $tempTableName, $importWizardForm->rowColumnDelimiter, $importWizardForm->rowColumnEnclosure, $importWizardForm->firstRowIsHeaderRow);
                     if (!$tableCreated) {
                         throw new FailedFileUploadException(Zurmo::t('ImportModule', 'Failed to create temporary database table from CSV.'));
                     }
                 } catch (BulkInsertFailedException $e) {
                     throw new FailedFileUploadException($e->getMessage());
                 } catch (TooManyColumnsFailedException $e) {
                     throw new FailedFileUploadException($e->getMessage());
                 }
                 $fileUploadData = array('name' => $uploadedFile->getName(), 'type' => $uploadedFile->getType(), 'size' => $uploadedFile->getSize());
                 ImportWizardUtil::setFormByFileUploadDataAndTableName($importWizardForm, $fileUploadData, $tempTableName);
                 ImportWizardUtil::setImportSerializedDataFromForm($importWizardForm, $import);
                 if (!$import->save()) {
                     throw new FailedFileUploadException(Zurmo::t('ImportModule', 'Import model failed to save.'));
                 }
             } else {
                 throw new FailedFileUploadException(Zurmo::t('ImportModule', 'Failed to open the uploaded file.'));
             }
             $fileUploadData['id'] = $import->id;
         } catch (FailedFileUploadException $e) {
             $fileUploadData = array('error' => Zurmo::t('Core', 'Error') . ' ' . $e->getMessage());
             ImportWizardUtil::clearFileAndRelatedDataFromImport($import);
         }
     }
     echo CJSON::encode(array($fileUploadData));
     Yii::app()->end(0, false);
 }