function import($filehandle, $group)
 {
     $csvtable = new Csvtable($filehandle);
     $requiredcolumns = array('INCIDENT TITLE', 'INCIDENT DATE');
     foreach ($requiredcolumns as $requiredcolumn) {
         if (!$csvtable->hasColumn($requiredcolumn)) {
             $this->errors[] = 'CSV file is missing required column "' . $requiredcolumn . '"';
         }
     }
     if (count($this->errors)) {
         return false;
     }
     $category_ids_temp = ORM::factory('category')->select_list('category_title', 'id');
     // so we can assign category id to incidents, based on category title
     $group_category_ids_temp = ORM::factory('simplegroups_category')->where("simplegroups_groups_id", $group->id)->select_list('category_title', 'id');
     // so we can assign category id to incidents, based on category title
     //make trim and capitalize the categories so they will match if the case is different.
     $this->category_ids = array();
     foreach ($category_ids_temp as $cat => $id) {
         $this->category_ids[strtoupper(trim($cat))] = $id;
     }
     $this->group_category_ids = array();
     foreach ($group_category_ids_temp as $cat => $id) {
         $this->group_category_ids[strtoupper(trim($cat))] = $id;
     }
     $this->incident_ids = ORM::factory('incident')->select_list('id', 'id');
     // so we can check if incident already exists in database
     $this->time = date("Y-m-d H:i:s", time());
     $rows = $csvtable->getRows();
     $this->totalrows = count($rows);
     $this->rownumber = 0;
     foreach ($rows as $row) {
         $this->rownumber++;
         if (isset($row['#']) and isset($this->incident_ids[$row['#']])) {
             $this->notices[] = 'Incident with id #' . $row['#'] . ' already exists.';
         } else {
             if ($this->importreport($row, $group)) {
                 $this->importedrows++;
             } else {
                 $this->rollback();
                 return false;
             }
         }
     }
     // loop through CSV rows
     return true;
 }
Esempio n. 2
0
 /**
  * Function to import CSV file referenced by the file handle
  * @param string $filehandle
  * @return bool
  */
 function import($filehandle)
 {
     $csvtable = new Csvtable($filehandle);
     // Set the required columns of the CSV file
     $requiredcolumns = array('INCIDENT TITLE', 'INCIDENT DATE');
     foreach ($requiredcolumns as $requiredcolumn) {
         // If the CSV file is missing any required column, return an error
         if (!$csvtable->hasColumn($requiredcolumn)) {
             $this->errors[] = 'CSV file is missing required column "' . $requiredcolumn . '"';
         }
     }
     if (count($this->errors)) {
         return false;
     }
     // So we can assign category id to incidents, based on category title
     $this->category_ids = ORM::factory('category')->select_list('category_title', 'id');
     //Since we capitalize the category names from the CSV file, we should also capitlize the
     //category titles here so we get case insensative behavior. For some reason users don't
     //always captilize the cateogry names as they enter them in
     $temp_cat = array();
     foreach ($this->category_ids as $key => $value) {
         $temp_cat[strtoupper($key)] = $value;
     }
     $this->category_ids = $temp_cat;
     // So we can check if incident already exists in database
     $this->incident_ids = ORM::factory('incident')->select_list('id', 'id');
     $this->time = date("Y-m-d H:i:s", time());
     $rows = $csvtable->getRows();
     $this->totalrows = count($rows);
     $this->rownumber = 0;
     // Loop through CSV rows
     foreach ($rows as $row) {
         $this->rownumber++;
         if (isset($row['#']) and isset($this->incident_ids[$row['#']])) {
             $this->notices[] = 'Incident with id #' . $row['#'] . ' already exists.';
         } else {
             if ($this->importreport($row)) {
                 $this->importedrows++;
             } else {
                 $this->rollback();
                 return false;
             }
         }
     }
     return true;
 }
Esempio n. 3
0
 /**
  * Function to import CSV file referenced by the file handle
  * @param string $filehandle
  * @return bool 
  */
 function import($filehandle)
 {
     $csvtable = new Csvtable($filehandle);
     // Set the required columns of the CSV file
     $requiredcolumns = array('INCIDENT TITLE', 'INCIDENT DATE');
     foreach ($requiredcolumns as $requiredcolumn) {
         // If the CSV file is missing any required column, return an error
         if (!$csvtable->hasColumn($requiredcolumn)) {
             $this->errors[] = 'CSV file is missing required column "' . $requiredcolumn . '"';
         }
     }
     if (count($this->errors)) {
         return false;
     }
     // So we can assign category id to incidents, based on category title
     $this->category_ids = ORM::factory('category')->select_list('category_title', 'id');
     // So we can check if incident already exists in database
     $this->incident_ids = ORM::factory('incident')->select_list('id', 'id');
     $this->time = date("Y-m-d H:i:s", time());
     $rows = $csvtable->getRows();
     $this->totalrows = count($rows);
     $this->rownumber = 0;
     // Loop through CSV rows
     foreach ($rows as $row) {
         $this->rownumber++;
         if (isset($row['#']) and isset($this->incident_ids[$row['#']])) {
             $this->notices[] = 'Incident with id #' . $row['#'] . ' already exists.';
         } else {
             if ($this->importreport($row)) {
                 $this->importedrows++;
             } else {
                 $this->rollback();
                 return false;
             }
         }
     }
     return true;
 }
Esempio n. 4
0
 /**
  * Function to import CSV file referenced by the file handle
  * @param string $filehandle
  * @return bool 
  */
 function import($file)
 {
     // Get contents of CSV file
     $data = file_get_contents($file);
     // Replace carriage return character
     $replacedata = preg_replace("/\r\n/", "\n", $data);
     // Replace file content
     file_put_contents($file, $replacedata);
     if ($filehandle = fopen($_FILES['uploadfile']['tmp_name'], 'r')) {
         $csvtable = new Csvtable($filehandle);
         // Set the required columns of the CSV file
         $requiredcolumns = array('INCIDENT TITLE', 'INCIDENT DATE');
         foreach ($requiredcolumns as $requiredcolumn) {
             // If the CSV file is missing any required column, return an error
             if (!$csvtable->hasColumn($requiredcolumn)) {
                 $this->errors[] = Kohana::lang('import.csv.required_column') . '"' . $requiredcolumn . '"';
             }
         }
         if (count($this->errors)) {
             return false;
         }
         // So we can assign category id to incidents, based on category title
         $this->existing_categories = ORM::factory('category')->select_list('category_title', 'id');
         //Since we capitalize the category names from the CSV file, we should also capitlize the
         //category titles here so we get case insensative behavior. For some reason users don't
         //always captilize the cateogry names as they enter them in
         $temp_cat = array();
         foreach ($this->existing_categories as $title => $id) {
             $temp_cat[utf8::strtoupper($title)] = $id;
         }
         $this->existing_categories = $temp_cat;
         // So we can check if incident already exists in database
         $this->incident_ids = ORM::factory('incident')->select_list('id', 'id');
         $this->time = date("Y-m-d H:i:s", time());
         $rows = $csvtable->getRows();
         $this->totalreports = count($rows);
         $this->rownumber = 0;
         // Loop through CSV rows
         foreach ($rows as $row) {
             $this->rownumber++;
             if (isset($row['#']) and isset($this->incident_ids[$row['#']])) {
                 $this->notices[] = Kohana::lang('import.incident_exists') . $row['#'];
             } else {
                 if ($this->import_report($row)) {
                     $this->importedreports++;
                 } else {
                     $this->rollback();
                     return false;
                 }
             }
         }
     } else {
         $this->errors[] = Kohana::lang('ui_admin.file_open_error');
     }
     // If we have errors, return FALSE, else TRUE
     return count($this->errors) === 0;
 }
Esempio n. 5
0
 /**
  * Function to import CSV file referenced by the file handle
  * @param string $filehandle
  * @return bool 
  */
 function import($file)
 {
     // Get contents of CSV file
     $data = file_get_contents($file);
     // Normalize new lines, replace ANY unicode new line with \n (should cover Mac OS9, Unix, Windows, etc)
     $replacedata = preg_replace('/\\R/u', "\n", mb_convert_encoding($data, 'UTF-8'));
     // Check for preg error, and fall back to original data
     if (preg_last_error() !== PREG_NO_ERROR) {
         $replacedata = $data;
     }
     // Replace file content
     file_put_contents($file, $replacedata);
     if ($filehandle = fopen($_FILES['uploadfile']['tmp_name'], 'r')) {
         $csvtable = new Csvtable($filehandle);
         // Set the required columns of the CSV file
         $requiredcolumns = array('INCIDENT TITLE', 'INCIDENT DATE');
         foreach ($requiredcolumns as $requiredcolumn) {
             // If the CSV file is missing any required column, return an error
             if (!$csvtable->hasColumn($requiredcolumn)) {
                 $this->errors[] = Kohana::lang('import.csv.required_column') . '"' . $requiredcolumn . '"';
             }
         }
         if (count($this->errors)) {
             return false;
         }
         // So we can assign category id to incidents, based on category title
         $this->existing_categories = ORM::factory('category')->select_list('category_title', 'id');
         //Since we capitalize the category names from the CSV file, we should also capitlize the
         //category titles here so we get case insensative behavior. For some reason users don't
         //always captilize the cateogry names as they enter them in
         $temp_cat = array();
         foreach ($this->existing_categories as $title => $id) {
             $temp_cat[utf8::strtoupper($title)] = $id;
             // Add translated titles too
             $langs = Category_Lang_Model::category_langs($id);
             if (isset($langs[$id])) {
                 foreach ($langs[$id] as $l) {
                     $temp_cat[utf8::strtoupper($l['category_title'])] = $id;
                 }
             }
         }
         $this->existing_categories = $temp_cat;
         // So we can check if incident already exists in database
         $this->incident_ids = ORM::factory('incident')->select_list('id', 'id');
         $this->time = date("Y-m-d H:i:s", time());
         $rows = $csvtable->getRows();
         $this->totalreports = count($rows);
         $this->rownumber = 0;
         // Loop through CSV rows
         foreach ($rows as $row) {
             $this->rownumber++;
             if (isset($row['#']) and isset($this->incident_ids[$row['#']])) {
                 $this->notices[] = Kohana::lang('import.incident_exists') . $row['#'];
             } else {
                 if ($this->import_report($row)) {
                     $this->importedreports++;
                 } else {
                     $this->rollback();
                     return false;
                 }
             }
         }
     } else {
         $this->errors[] = Kohana::lang('ui_admin.file_open_error');
     }
     // If we have errors, return FALSE, else TRUE
     return count($this->errors) === 0;
 }