Many times, you will need to work with external csv’s files. This simple script will help you on import and export them, and other stuff.

• Create a new file called csvworker.php under <MageRoot>/shell/
• If you will not pass the filename through parameter, remember to change method “getFileName()”.
  
  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127

  <?php require_once 'abstract.php'; ini_set('display_errors', 1); class Offset101_Shell_CSVScript extends Mage_Shell_Abstract {     const UPLOAD_DIR = 'path/to/read/files/';     const FIELD_1 = 'Column one';     const FIELD_2 = 'Column two';     /**      * Run the process      */     public function run()     {         if ($this->getArg('action') == 'read') $this->readCSVFile();         if ($this->getArg('action') == 'write') $this->writeCSVFile();     }     private function readCSVFile(){         $csvObject = new Varien_File_Csv();         $fileName = $this->getFileName();         if ($this->getArg('formatted')){             echo "Reading formatted\n";             $csvRows = $csvObject->getData($fileName);             $csvRows = $this->getFormattedData($csvRows);             foreach ($csvRows as $row) {                 echo $row[self::FIELD_1] .  " " . $row[self::FIELD_2]."\n";             }         }else{             echo "Reading NON formatted\n";             $csvRows = $csvObject->getData($fileName);             foreach ($csvRows as $row) {                 echo $row[0]. " ".$row[1]."\n";             }         }     }     private function writeCSVFile(){         $fileName = $this->getFileName();         $destinationCsvFile = fopen($fileName, "w"); // You can use "w+" for read and write.         fputcsv($destinationCsvFile, array(self::FIELD_1,self::FIELD_2));         fputcsv($destinationCsvFile, array("Value Column1 Row 1","Value Column2 Row 1"));         fputcsv($destinationCsvFile, array("Value Column1 Row 2","Value Column2 Row 2"));         fclose($destinationCsvFile);     }     private function getFileName(){         if ($fileName = $this->getArg('filename'))             return Mage::getBaseDir() . $fileName;         else             return Mage::getBaseDir() . '/var/<filename>.csv';     }     /**      * Get csv header      *      * @param $rows      * @return array      */     private function getHeader($rows)     {         $header = array();         foreach ($rows[0] as $k => $row) {             $header[$k] = $row;         }         return $header;     }     /**      * Return csv formatted data      *      * Associative array with header csv columns as identifiers.      *      * @param $csv      * @return array      */     private function getFormattedData($csv)     {         $header = $this->getHeader($csv);         $data = array();         foreach ($csv as $k => $row) {             if ($k == 0) continue;             foreach ($header as $i => $column) {                 $data[$k][$column] = $row[$i];             }         }         return $data;     }     /**      * Retrieve Usage Help Message      */     public function usageHelp()     {         return <<<USAGE Usage:  php -f csvworker.php -- [options]   --filename <file to process>            Show Indexer(s) Status   --action <read or write>        In order to perform read or write process                        --formatted               Shows a formatted csv using known columns   help                                    This help USAGE;     } } $shell = new Offset101_Shell_CSVScript(); $shell->run();

• Then, you can call the script on your console, doing the following (under shell forlder):
  
  1 2 3 4 5 6 7 8 9 10 11 12 13 14

  # To get HELP php -f csvworker.php help # Read NON Formated php -f csvworker.php -- -action read # Read Formated php -f csvworker.php -- -action read -formatted # Write NON Formated php -f csvworker.php -- -action write # Write Formated php -f csvworker.php -- -action write -formatted

Note: if you just want to save a csv with a content of an array, you can do so, with the following command:

1 2	$csvObject = new Varien_File_Csv(); $csvObject->saveData(Mage::getBaseDir() . '/var/<filename>.csv, $content);