We have a scenario where schools.csv file will be uploaded under schoolsearch folder under the magento root directory. This should update the schools table under magento database. But since migration its not working. We are using a module for this task. But its not working. The following is the content of observer.php
php class Attigo_Schoolsearch_Model_Observer { protected function getfilepath() { Mage::getBaseDir(). DS .'csv'. DS . 'schoolsearch/schools.csv'; } public function schoolDetail() { $row=array(); //$filePath = $this->getfilepath(); $filePath = "/var/www/html/main/schoolsearch/schools.csv"; if (($handle = fopen($filePath, 'r')) !== FALSE) { $i=0; while (($data = fgetcsv($handle, 1000, '\t')) !== FALSE) { if($i==0) { $i++; continue; } if($data != "") { foreach ($data as $school) { // echo $school.''; $row=explode("\t",$school); } $school = Mage::getModel('schoolsearch/schools'); $school->setKundnr($row[0]); $school->setSkola($row[1]); $school->setBadress($row[2]); $school->setBadress1($row[3]); $school->setBpostnummer($row[4]); $school->setBpostort($row[5]); $school->setFakturamottagare($row[6]); $school->setFakturaadress1($row[7]); $school->setFakturaadress2($row[8]); $school->setFpostnr($row[9]); $school->setFpostort($row[10]); $school->setBadressid($row[11]); $school->setFakturaadressid($row[12]); $school->setBcountrycode($row[13]); $school->setFakturacountrycode($row[14]); $school->save(); // print_r($school); // echo $row[13].'->'.$row[14].''; } $i++; } } else { echo "permission denide"; } } public function AddCustomerGroup(Varien_Event_Observer $observer) { $_post = Mage::app()->getFrontController()->getRequest()->getParams(); try { $customer = $observer->getEvent()->getCustomer(); $customer->setData('group_id', $_post['group_id']); // or whatever the group id should be $customer->save(); } catch ( Exception $e ) { echo $e->getMessage; } } } ?>
Can any one help me where it goes wrong?
When you say its not working it gives "permission denied" as per the Observer or you get a 500 error?
Have you tried putting feeback in the code i.e. and echo "Here"; at various stages of your code to follow the path it is taking or to confirm if it is even getting into the functions at all?