CSV Import library for Products

Guerra · February 15th, 2009, 09:17 AM

Hi, i have problems with this operation. After the file is chosen and imported, we get on .../admin/products/import - But there is nothing displayed

There are no errors - simply pure screen

Any idea?

myerman · March 16th, 2009, 09:59 AM

Can you provide more details? Perhaps a code dump of where you are going? or maybe a look at the data structure you are trying to pull in?

deanf7 · March 20th, 2009, 04:56 PM

I'm having the same issue, but several things I've discovered:

If your following the book

Code:

function importCsv()

should read when you load the library:

Code:

$this->load->library('CSVReader);

not

Code:

$this->load->library('CSVreader');

Then if you look in the CSVReader class you'll see the method is called parse_file not parseFile so the return statment should be

Code:

return $this->csvreader->parse_file($path)

not

Code:

return $this->csvreader->parseFile($path)

myerman · March 21st, 2009, 10:35 AM

In the code for CSVReader, I have:

Code:

class CSVReader {
    
    var $fields;            /** columns names retrieved after parsing */
    var $separator = ',';    /** separator used to explode each line */
    
 
    function parseText($p_Text) {
        $lines = explode("\n", $p_Text);
        return $this->parseLines($lines);
    }
    

    function parseFile($p_Filepath) {
        $lines = file($p_Filepath);
        return $this->parseLines($lines);
    }
    
 
    function parseLines($p_CSVLines) {    
        $content = FALSE;
        foreach( $p_CSVLines as $line_num => $line ) {
            if( $line != '' ) { // skip empty lines
                $elements = split($this->separator, $line);
                
                if( !is_array($content) ) { // the first line contains fields names
                    $this->_fields = $elements;
                    $content = array();
                } else {
                    $item = array();
                    foreach( $this->_fields as $id => $field ) {
                        $item[$field] = $elements[$id];
                    }
                    $content[] = $item;
                }
            }
        }
        return $content;
    }
}

There's a parseFile() method in the class. Now here's the function in the MOrders model:

Code:

 function importCsv(){
 	
	$config['upload_path'] = './csv/';
	$config['allowed_types'] = 'csv';
	$config['max_size'] = '2000';
	$config['remove_spaces'] = true;
	$config['overwrite'] = true;
	$this->load->library('upload', $config);
  	$this->load->library('CSVReader'); 
  	
	if(!$this->upload->do_upload('csvfile')){
		$this->upload->display_errors();
		exit();
	}
	$csv = $this->upload->data();
	$path = $csv['full_path'];
	
	return $this->csvreader->parseFile($path);
 }

In the model, I call the library properly "CSVReader" and the method too "parseFile($path)".

In the book, on page 199, I call the library improperly as "CSVreader". I'm not sure how it happened, but it happened. Sorry about that -- the code is correct, the example has the typo.

Now I'm wondering where the parse_file() thing came from, I can't find it anywhere.

psetyo · April 28th, 2009, 06:26 AM

I'm having the same problem, after hours of bugs fixing and googling , i found this :
http://codeigniter.com/forums/viewthread/86033/#554404

I think the problem related to bug in FF3, because I got the following error :
Array( [error] => The filetype you are attempting to upload is not allowed.)
and parsing the upload data, i get :

Array( [dataup] => Array ( [file_name] => products_export.csv [file_type] => \"text/x-comma-separated-values\" [file_path] => D:/wwwroot/CodeIgniter/claudia/tmp/ [full_path] => D:/wwwroot/CodeIgniter/claudia/tmp/products_export.csv [raw_name] => products_export [orig_name] => [file_ext] => .csv [file_size] => 2.96 [is_image] => [image_width] => [image_height] => [image_type] => [image_size_str] => ))

Notice in : [file_type] => \"text/x-comma-separated-values\"

Try to test your code in internet explorer..
thx..

www.paulussetyo.com

psetyo · April 28th, 2009, 06:30 AM

Quote:

Originally Posted by myerman

In the code for CSVReader, I have:
Now I'm wondering where the parse_file() thing came from, I can't find it anywhere.

If you download the latest CSVReader, the function should be : parse_file() not parsefile()

Thx

blackhorse66 · June 16th, 2009, 07:12 PM

I think the empty page error due to that no "csv" folder was created in the CI root. That "csv" folder we need to create by ourselves, it is not included in the download. And you need to make that folder writable.

shiroamada · August 5th, 2009, 09:55 PM

I am using FF 3.5.2, I also having the same problem, which is FF display
"The filetype you are attempting to upload is not allowed"

What I done is in config/mimes.php
I added one more array value, '\"text/x-comma-separated-values\"'

Code:

'csv'    =>    array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', '\"text/x-comma-separated-values\"'),

Then its work in FF 3.5.2, hope my reply can help you all.