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

Parsing Domain Name From URL In PHP

To get Domain name from the url, we can use parse_url() php function. This would filter the domain name from the given url. $domain = str_ireplace ( 'www.' , '' , parse_url ( $url , PHP_URL_HOST )); This would return the google.com for both http://google.com and http://www.google.com
Post a Comment
Read more

Is covid virus really airborne?

  If airborne transmission is a significant factor in the pandemic, especially in crowded spaces with poor ventilation, the consequences for containment will be significant. How did the experts reach this conclusion? Reviewing existing research, the six experts from the UK, US and Canada identified 10 streams of evidence that collectively support the hypothesis that SARS-CoV-2 primarily transmits through the airborne route. 1. Super-spreading events account for substantial SARS-CoV-2 transmission. Indeed, the authors wrote, such events may be the  pandemic ’s primary drivers. Detailed analyses of human behaviours and other variables in concerts, cruise ships etc have shown patterns “consistent with airborne spread of SARS-CoV-2 that cannot be adequately explained by droplets or fomites”, they wrote. 2. Long-range transmission of SARS-CoV-2 between people in adjacent rooms has been documented in quarantine hotels, but never in each other’s presence. 3. Asymptomatic or pre-sympt...
Post a Comment
Read more