Skip to main content
2 of 2
added 465 characters in body

Installer script to insert data from excel

I am creating a module for Magento. For this I need already inserted data in table. For this I need to write sql/module_setup/mysql4-install-0.1.0.php installer script to insert data from excel or csv to table.

my installer script is like this to create table

$installer = $this;

$installer->startSetup();


$installer->run("

CREATE TABLE `{$this->getTable('module_setup_data')}` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `code` varchar(255),
  `code_type` varchar(255),
  PRIMARY KEY  (`id`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    ");

$installer->endSetup();

Please guide me how to write sql/module_setup/mysql4-install-0.1.0.php installer script to insert query from excel or csv.