Skip to main content

Custom Import function in magento

Open the file app\code\local\mainModule\moduleName\Block\Adminhtml\moduleName.php

Add or replace 

public function __construct()
{

 $this->_controller = "adminhtml_myoffer";
$this->_blockGroup = "myoffer";
$this->_headerText = Mage::helper("myoffer")->__("Myoffer Manager");
$this->_addButtonLabel = Mage::helper("myoffer")->__("Add New Item");
$this->_addButton('testbutton', array(
            'label'     => Mage::helper('Sales')->__('Import'),
            'onclick'   => 'jsfunction(this.id)',
            'class'     => 'go'
        ), 0, 100, 'header', 'header');
parent::__construct();

}

And add a java script on same page

<script>
function jsfunction(){
window.open("http://localhost/ankur/yourPageName.php",'_blank','width=335,height=330,resizable=1');
}
</script>

in yourPageName.php

<?php
error_reporting(0);
// Your database connection here

 $sql='';
if(isset($_POST["Import"]))
{
$filename=$_FILES["file_product"]["tmp_name"];
$type=$_FILES["file_product"]["type"];
//print_r($_FILES);

  if($_FILES["file_product"]["size"] > 0)
  {
   
  $file = fopen($filename, "r");
  while (($emapData = fgetcsv($file, 50000, ",")) !== FALSE)
  {
   if($emapData[0]!="")
      {
// print_r($emapData);die;
$id=mysql_escape_string(trim($emapData[0]));
       $id1=strlen($id);
       $coupon=mysql_escape_string(trim($emapData[3]));
       $coupon1=strlen($coupon);
       $value=mysql_escape_string(trim($emapData[4]));
       $value1=strlen($value);
       $status=mysql_escape_string(trim($emapData[5]));
       $status1=strlen($status);
              $sql=rtrim($sql,',');
/* $sql ="insert into table name (phone_no, firstname, lastname,email, address1, address2, city, state, zip) values ('".mysql_escape_string(trim($emapData[1]))."','".mysql_escape_string(trim($emapData[2]))."','".mysql_escape_string(trim($emapData[3]))."','".mysql_escape_string(trim($emapData[4]))."','".mysql_escape_string(trim($emapData[5]))."','".mysql_escape_string(trim($emapData[6]))."','".mysql_escape_string(trim($emapData[7]))."','".mysql_escape_string(trim($emapData[8]))."','".mysql_escape_string(trim($emapData[9]))."')"; */
$sql ="UPDATE tablenameSET coupon='".$coupon."', value='".$value."', status='".$status."' WHERE myoffer_id='".$id."';";

     mysql_query($sql) or mysql_error(1);
     
      }     
  }

  fclose($file);
  echo "CSV File has been successfully Imported";
  
  }
 else
 echo "Invalid File:Please Upload CSV File";
}

 ?>

 <html>
<form method="post" enctype="multipart/form-data">

 <input type="file" name="file_product" />

 <input type="submit" name="Import" />
</form>
  

 </html>

thats all.

Thanks.

Comments

Post a Comment

Popular posts from this blog

Magento Form Validators

Magento Javascript Validation Classes There are many more validation classes you can assign and I list them here as a reference. For more information on this please use Google, experiment with the code or contact me via my email or the contact form. validate-select Please select an option required-entry This is a required field validate-number Please enter a valid number in this field validate-digits Please use numbers only in this field. please avoid spaces or other characters such as dots or commas validate-alpha Please use letters only (a-z or A-Z) in this field. validate-code Please use only letters (a-z), numbers (0-9) or underscore(_) in this field, first character should be a letter. validate-alphanum Please use only letters (a-z or A-Z) or numbers (0-9) only in this field. No spaces or other characters are allowed validate-street Please use only letters (a-z or A-Z) or numbers (0-9) or spaces and # only in this field validate-phoneStrict
Post a Comment
Read more

How to create Guest Wishlist For Magento

Add to wishlist without customer login Add three tables CREATE TABLE `wishlist` ( `wishlist_id` INT(11) NOT NULL AUTO_INCREMENT, `customer_id` INT(11) NULL DEFAULT NULL, `shared` INT(11) NULL DEFAULT NULL, `sharing_code` VARCHAR(50) NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, `cookie` VARCHAR(255) NULL DEFAULT NULL, PRIMARY KEY (`wishlist_id`) ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=0 ; CREATE TABLE `wishlist_item` ( `wishlist_item_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Wishlist item ID', `wishlist_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Wishlist ID', `product_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Product ID', `store_id` SMALLINT(5) UNSIGNED NULL DEFAULT NULL COMMENT 'Store ID', `added_at` TIMESTAMP NULL DEFAULT NULL COMMENT 'Add date and time', `description` TEXT NULL COMMENT '
Post a Comment
Read more