function _verifyDB()
 {
     $state = $this->_getState();
     // Uploads the file
     Citruscart::load('CitruscartFile', 'library.file');
     $upload = new CitruscartFile();
     // we have to upload the file
     if ($state->uploaded_file == '') {
         // handle upload creates upload object properties
         $success = $upload->handleUpload('file');
         if ($success) {
             if (strtolower($upload->getExtension()) != 'csv') {
                 $this->setError(JText::_('COM_CITRUSCART_THIS_IS_NOT_A_CSV_FILE'));
                 return false;
             }
             // Move the file to let us reuse it
             $upload->setDirectory(JFactory::getConfig()->get('tmp_path', JPATH_SITE . DS . 'tmp'));
             $success = $upload->upload();
             if (!$success) {
                 $this->setError($upload->getError());
                 return false;
             }
             $upload->file_path = $upload->getFullPath();
         } else {
             $this->setError(JText::_('COM_CITRUSCART_COULD_NOT_UPLOAD_CSV_FILE' . $upload->getError()));
             return false;
         }
     } else {
         $upload->full_path = $upload->file_path = $state->uploaded_file;
         $upload->proper_name = CitruscartFile::getProperName($state->uploaded_file);
         $success = true;
     }
     if ($success) {
         // Get the file content
         $upload->fileToText();
         $content = $upload->fileastext;
         // Set the uploaded file as the file to use during the real import
         $this->_uploaded_file = $upload->getFullPath();
         $rows = explode("\n", $content);
         if (!count($rows)) {
             $this->setError('No Rows in this file');
             return false;
         }
         $records = array();
         if ($state->skip_first) {
             $header = array_shift($rows);
             $header = explode($state->field_separator, $header);
         } else {
             $header = $this->_keys;
         }
         $records[] = $header;
         // Get the records
         foreach ($rows as $row) {
             // Get the columns
             $fields = explode($state->field_separator, $row);
             if ($fields) {
                 // Map them using an associative array
                 $fields = $this->_mapFields($fields);
                 // explore possible multiple subfields
                 // Categories
                 $fields['product_categories'] = explode($state->subfield_separator, $fields['product_categories']);
                 // Images
                 $fields['product_images'] = explode($state->subfield_separator, $fields['product_images']);
                 // Attributes
                 $attributes = explode($state->subfield_separator, $fields['product_attributes']);
                 // Explode the Attribute options!
                 $real_attributes = array();
                 foreach ($attributes as $attribute) {
                     // size:s|m|l|sx
                     $att = explode(":", $attribute);
                     $att_name = $att[0];
                     $att_options = array();
                     if (!empty($att[1])) {
                         $att_options = explode("|", $att[1]);
                     }
                     $real_attributes[$att_name] = $att_options;
                 }
                 // Assign the parsed version!
                 $fields['product_attributes'] = $real_attributes;
                 $records[] = $fields;
             }
         }
         return $records;
     } else {
         $this->setError(JText::_('COM_CITRUSCART_COULD_NOT_UPLOAD_CSV_FILE' . $upload->getError()));
         return false;
     }
     return false;
 }
 function _verifyDB()
 {
     $state = $this->_getState();
     // Uploads the file
     Citruscart::load('CitruscartFile', 'library.file');
     $upload = new CitruscartFile();
     $zip_images_upload = new CitruscartFile();
     $zip_files_upload = new CitruscartFile();
     // we have to upload the file
     if ($state->uploaded_file == '') {
         // handle upload creates upload object properties
         $success = $upload->handleUpload('file');
         $zip_images_success = $zip_images_upload->handleUpload('images_zip_file');
         $zip_files_success = $zip_files_upload->handleUpload('files_zip_file');
         if ($success) {
             if (strtolower($upload->getExtension()) != 'xml') {
                 $this->setError(JText::_('COM_CITRUSCART_THIS_IS_NOT_AN_XML_FILE'));
                 return false;
             }
             // Move the file to let us reuse it
             $upload->setDirectory($this->_temp_dir);
             $success = $upload->upload();
             if (!$success) {
                 $this->setError($upload->getError());
                 return false;
             }
             $upload->file_path = $upload->getFullPath();
             // Now for the zips
             // Check if it's a supported archive
             if ($zip_images_success) {
                 $allowed_archives = array('zip', 'tar', 'tgz', 'gz', 'gzip', 'tbz2', 'bz2', 'bzip2');
                 if (!in_array(strtolower($zip_images_upload->getExtension()), $allowed_archives)) {
                     $this->setError(JText::_('COM_CITRUSCART_THIS_IS_NOT_A_SUPPORTED_ARCHIVE_FILE'));
                     return false;
                 }
                 // Move the file to let us reuse it
                 $zip_images_upload->setDirectory($this->_temp_dir);
                 $success = $zip_images_upload->upload();
                 if (!$success) {
                     $this->setError($zip_images_upload->getError());
                     return false;
                 }
                 $zip_images_upload->file_path = $zip_images_upload->getFullPath();
             }
             if ($zip_files_success) {
                 $allowed_archives = array('zip', 'tar', 'tgz', 'gz', 'gzip', 'tbz2', 'bz2', 'bzip2');
                 if (!in_array(strtolower($zip_files_upload->getExtension()), $allowed_archives)) {
                     $this->setError(JText::_('COM_CITRUSCART_THIS_IS_NOT_A_SUPPORTED_ARCHIVE_FILE'));
                     return false;
                 }
                 // Move the file to let us reuse it
                 $zip_files_upload->setDirectory($this->_temp_dir);
                 $success = $zip_files_upload->upload();
                 if (!$success) {
                     $this->setError($zip_files_upload->getError());
                     return false;
                 }
                 $zip_files_upload->file_path = $zip_files_upload->getFullPath();
             }
         } else {
             $this->setError(JText::_('COM_CITRUSCART_COULD_NOT_UPLOAD_XML_FILE' . $upload->getError()));
             return false;
         }
     } else {
         $upload->full_path = $upload->file_path = $state->uploaded_file;
         $upload->proper_name = CitruscartFile::getProperName($state->uploaded_file);
         if ($state->uploaded_images_zip_file) {
             $zip_images_upload->full_path = $zip_images_upload->file_path = $state->uploaded_images_zip_file;
             $zip_images_upload->proper_name = CitruscartFile::getProperName($state->uploaded_images_zip_file);
         }
         if ($state->uploaded_files_zip_file) {
             $zip_files_upload->full_path = $zip_files_upload->file_path = $state->uploaded_files_zip_file;
             $zip_files_upload->proper_name = CitruscartFile::getProperName($state->uploaded_files_zip_file);
         }
         $success = true;
     }
     if ($success) {
         // Get the file content
         $upload->fileToText();
         $content = $upload->fileastext;
         // Set the uploaded file as the file to use during the real import
         $this->_uploaded_file = $upload->getFullPath();
         $this->_uploaded_images_zip_file = $zip_images_upload->getFullPath();
         $this->_uploaded_files_zip_file = $zip_files_upload->getFullPath();
         $xml = simplexml_load_string($content);
         $products = $xml->children();
         if (!count($products)) {
             $this->setError('No Products in this file');
             return false;
         }
         return $products;
     } else {
         $this->setError(JText::_('COM_CITRUSCART_COULD_NOT_UPLOAD_CSV_FILE' . $upload->getError()));
         return false;
     }
     return false;
 }
 /**
  *
  * Method to upload and verify file if uploaded
  * @return boolean
  */
 function _verifyFile()
 {
     $state = $this->_getState();
     $success = false;
     // Uploads the file
     Citruscart::load('CitruscartFile', 'library.file');
     $upload = new CitruscartFile();
     // we have to upload the file
     if ($state->uploaded_file == '') {
         // handle upload creates upload object properties
         $success = $upload->handleUpload('file');
         if ($success) {
             if (strtolower($upload->getExtension()) != 'sql') {
                 $this->setError(JText::_('COM_CITRUSCART_THIS_IS_NOT_AN_SQL_FILE'));
                 return false;
             }
             // Move the file to let us reuse it
             $upload->setDirectory(JFactory::getConfig()->get('tmp_path', JPATH_SITE . '/tmp'));
             $success = $upload->upload();
             if (!$success) {
                 $this->setError($upload->getError());
                 return false;
             }
             $upload->file_path = $upload->getFullPath();
         } else {
             $this->setError(JText::_('COM_CITRUSCART_COULD_NOT_UPLOAD_SQL_FILE' . $upload->getError()));
             $success = false;
         }
     } else {
         $upload->full_path = $upload->file_path = $state->uploaded_file;
         $upload->proper_name = CitruscartFile::getProperName($state->uploaded_file);
         $success = true;
     }
     if ($success) {
         // Set the uploaded file as the file to use during the real import
         $this->_uploaded_file = $upload->getFullPath();
         $this->_uploaded_filename = str_replace(".sql", "", $upload->physicalname);
     }
     return $success;
 }