maxx Posted January 1, 2012 Share Posted January 1, 2012 Hello all, i already posted this question in the Dutch forum but got no replies. I really hope someone in here can help me. When i want to import with .csv , Prestashop gives me the following message: Column function({for(var a=0;a must be set i use version 1.4.6.2 What am i doing wrong? Link to comment Share on other sites More sharing options...
thx2012 Posted July 11, 2012 Share Posted July 11, 2012 So, what's the solution to this problem? I am also experiencing issue.. Could you please submit your resolution? Thanks! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 11, 2012 Share Posted July 11, 2012 Hi thx, In your config/config.inc.php file, can you please set "display_errors" to "on," try this again and then provide the full content of any error messages you receive? -Mike Link to comment Share on other sites More sharing options...
thx2012 Posted July 16, 2012 Share Posted July 16, 2012 Thanks Mike, I adjusted the config/config.inc.php file as suggested and I still receive error: Column function ({var a=this.indexOf(;if(a!=-1){this.splice(a,1)}return this} must be set Any other suggestions? Thanks for your help!! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 16, 2012 Share Posted July 16, 2012 Thanks Mike, I adjusted the config/config.inc.php file as suggested and I still receive error: Column function ( {var a=this.indexOf( ;if(a!=-1){this.splice(a,1)}return this} must be set Any other suggestions? Thanks for your help!! Have you already compared your CSV files to the sample versions available through the Back Office under Tools > CSV Import? -Mike Link to comment Share on other sites More sharing options...
thx2012 Posted July 16, 2012 Share Posted July 16, 2012 I'm running version 1.4.4.1 and I don't see the option under the Back Office: Tools > CSV Import. I only see box with Fields available. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 16, 2012 Share Posted July 16, 2012 I'm running version 1.4.4.1 and I don't see the option under the Back Office: Tools > CSV Import. I only see box with Fields available. What sort of CSV are you trying to import? Products, Categories, etc. -Mike Link to comment Share on other sites More sharing options...
thx2012 Posted July 16, 2012 Share Posted July 16, 2012 So far, I'm just trying to import products... Prior to my upgrade of 1.4.4.1, I was able to import csv without problem. Now with upgrade, csv import is generating errors. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 16, 2012 Share Posted July 16, 2012 So far, I'm just trying to import products... Prior to my upgrade of 1.4.4.1, I was able to import csv without problem. Now with upgrade, csv import is generating errors. Go ahead and compare your file to the attached sample Products file I've attached below (in .zip format because CSVs cannot be uploaded through this form. Just unzip it) to see if anything may need to be reformatted. products_import.zip -Mike Link to comment Share on other sites More sharing options...
thx2012 Posted July 16, 2012 Share Posted July 16, 2012 Well, the format you provided was different from mine, however the same error still generated. When I attempted to open your file with open office, the format was similar as if I used notepad++ A little confusing to decipher, but none the less, was a successful upload. And even though the back office shows the correct info, once you click on Import CSV data, the Column Function error occurs. Link to comment Share on other sites More sharing options...
thx2012 Posted July 17, 2012 Share Posted July 17, 2012 I went ahead and just downloaded the current version 1.4.8.2 (I now understand the csv format) and installed a fresh copy on a testing domain. However, I'm still receiving the Column function error. Column function ({var a=this.indexOf(;if(a!=-1){this.splice(a,1)}return this} must be set I've used prestashop's default 'products_import.csv' with even the bear minimum fields selected and also tried both ways with the config/config.inc.php 'on/off' from (line 29: @ini_set('display_errors', 'on')). Why would both versions of prestashop behave this way? Any other suggestions? Thanks again for your help! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 17, 2012 Share Posted July 17, 2012 I went ahead and just downloaded the current version 1.4.8.2 (I now understand the csv format) and installed a fresh copy on a testing domain. However, I'm still receiving the Column function error. Column function ({var a=this.indexOf(;if(a!=-1){this.splice(a,1)}return this} must be set I've used prestashop's default 'products_import.csv' with even the bear minimum fields selected and also tried both ways with the config/config.inc.php 'on/off' from (line 29: @ini_set('display_errors', 'on')). Why would both versions of prestashop behave this way? Any other suggestions? Thanks again for your help! Just to make sure I understand you correctly, you still received this error on a fresh installation of v1.4.8.2 and the sample CSV without any edits? -Mike Link to comment Share on other sites More sharing options...
thx2012 Posted July 17, 2012 Share Posted July 17, 2012 (edited) Yes, correct. I'm attaching screen shot of error. Edited July 17, 2012 by thx2012 (see edit history) Link to comment Share on other sites More sharing options...
thx2012 Posted July 17, 2012 Share Posted July 17, 2012 I did another fresh install on a different server and the Column function error is still present. I'm puzzled that no other users have posted for this error. Just to reiterate, I installed v.1.4.8.2 on two different servers/domains, using prestashop's default product_import.csv file and error occurs requesting that the value be set for each column. Any other suggestions? Thanks for your help! Link to comment Share on other sites More sharing options...
Recommended Posts