Page 4 of 9

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Fri Aug 17, 2012 7:46 pm
by JNeuhoff
emilman wrote:Hi! I tried your application and it works perfect! Now I wonder if it would be able to work with multistore instalation. I'd be grateful if you explain a bit more about it, or, if you have already done that, please give me a link. Thanks in advance!
Multi store is already supported, look the for store_ids columns in the worksheets where you specify multiple store ids, seperated by commas.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Sat Aug 18, 2012 4:31 am
by loki52
What php-pear packages should be installed in order for this extension to work? I think that's where the problem is. As I said before, I can export to excel format perfectly. The problem comes in when I have to import the changes. When I click upload after choosing the edited file, it uploads to the server but there is no processing that takes place. Our office server is running ubuntu 12.04 and its pretty much got the basic php modules installed. So I'm wondering if there is a specific plugin or addon that has to be installed for it to parse the file and make the changes. My php.ini settings are fine and my .htaccess settings are fine as well.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Sat Aug 18, 2012 4:50 am
by JNeuhoff
loki52 wrote:What php-pear packages should be installed in order for this extension to work? I think that's where the problem is. As I said before, I can export to excel format perfectly. The problem comes in when I have to import the changes. When I click upload after choosing the edited file, it uploads to the server but there is no processing that takes place. Our office server is running ubuntu 12.04 and its pretty much got the basic php modules installed. So I'm wondering if there is a specific plugin or addon that has to be installed for it to parse the file and make the changes. My php.ini settings are fine and my .htaccess settings are fine as well.
Check your server's error_log or OpenCart's system/logs/error.txt for any error messages.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 7:06 am
by baldex
hi

i'm getting a error in the sheet
you know whate the problem is?

Code: Select all

<b>Notice</b>: Error: Unknown column 'p.ean' in 'field list'<br />Error No: 1054<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.ean,  p.jan,  p.isbn,  p.mpn,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   pd.tag,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in <b>/home/green/domains/greenenergyholland.com/public_html/system/database/mysql.php</b> on line <b>49</b>

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 7:09 am
by baldex
hi there i cant fix this problem

<b>Notice</b>: Error: Unknown column 'p.ean' in 'field list'<br />Error No: 1054<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.tag, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=2 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>/home/green/domains/greenenergyholland.com/public_html/system/database/mysql.php</b> on line <b>49</b>

you know how to fix it ?

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 6:01 pm
by lee420
Hi,
Would you be able to make this tool support for extra product fields. Some fields are in new tables and some in existing tables. If so how much would it cost?

Thanks

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 8:28 pm
by JNeuhoff
baldex wrote:hi there i cant fix this problem

<b>Notice</b>: Error: Unknown column 'p.ean' in 'field list'<br />Error No: 1054<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.tag, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=2 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>/home/green/domains/greenenergyholland.com/public_html/system/database/mysql.php</b> on line <b>49</b>

you know how to fix it ?
You are using a non-matching version of the Export/Import tool, e.g. the one for 1.5.4.x on an older OpenCart version.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 8:31 pm
by JNeuhoff
lee420 wrote:Hi,
Would you be able to make this tool support for extra product fields. Some fields are in new tables and some in existing tables. If so how much would it cost?

Thanks
Send me your exact details of the additional fields and tables you wish to be added, using our Contact Us page, and I can work out a quote.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 8:32 pm
by mrjave
hi all,

can this be altered to input information of custom tabs/table?

kind regards,
Jave

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 8:43 pm
by JNeuhoff
mrjave wrote:hi all,

can this be altered to input information of custom tabs/table?

kind regards,
Jave
What exactly to you want to be added to the Export/Import tool? Contact us with more details.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 10:31 pm
by cstoner69
Hi

I have used the tool before and it was great. However after a fresh install (15 times) when i try to open in excel i get the message the "The file you are trying to open "backup-catergories" is in a different format than specified by the file extension"

I click yes to proceed and the spreadsheet opens with one worksheet tab at the bottom, no data and no heading just a blank spreadsheet. Any ideas would be great.

Thx in advance

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 23, 2012 11:17 pm
by JNeuhoff
cstoner69 wrote:Hi

I have used the tool before and it was great. However after a fresh install (15 times) when i try to open in excel i get the message the "The file you are trying to open "backup-catergories" is in a different format than specified by the file extension"

I click yes to proceed and the spreadsheet opens with one worksheet tab at the bottom, no data and no heading just a blank spreadsheet. Any ideas would be great.

Thx in advance
Too little details, unable to reproduce your error.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Sun Aug 26, 2012 9:19 am
by bertjebel
Hello,

I have a question. Is it possible to just export categories or products or ..

I ask because my memory is set at 512M and post is set at 32M but it seems that my stores are way to big for such a load. What to do when i just want categories with shop id and descriptions (thats what i need to edit the most ofline). If i have a edit hint I probably can change the script myself.

Thanks in advance.

Regards

PLEASE HELP..! Export/Import tool OpenCart 1.5.3.x By JNeuho

Posted: Sun Aug 26, 2012 6:10 pm
by mickeykhan
Hi
I'm using opencart 1.5.3.1, I have downloaded this module and tried to import 348 products using the instructions given, I managed to import 128 products only rest of the items never imported, when I tried re-importing again I am getting this error repeatedly "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!". I have checked the entire file I didn't see any problem. Am I missing something?

PLEASE HELP..!!!

Re: PLEASE HELP..! Export/Import tool OpenCart 1.5.3.x By JN

Posted: Mon Aug 27, 2012 6:29 pm
by JNeuhoff
mickeykhan wrote:Hi
I'm using opencart 1.5.3.1, I have downloaded this module and tried to import 348 products using the instructions given, I managed to import 128 products only rest of the items never imported, when I tried re-importing again I am getting this error repeatedly "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!". I have checked the entire file I didn't see any problem. Am I missing something?

PLEASE HELP..!!!
Unable to reproduce your error, too few details.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 30, 2012 9:39 pm
by jipsa78
Hi,

First of all: great job on this extension!

I am now trying to get it to work with the Custom Page Titles extension (url: http://www.opencart.com/index.php?route ... on_id=7867), which I want to use for SEO purposes.
The Custom Page Titles extension adds these new fields to the database:

ALTER TABLE art1_category_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_information_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_product_description ADD column cptitle VARCHAR(255) NOT NULL;

It also contains a vQmod file that adds the custom page title fields to admin.

Because the export/import tool doesn't know these new database fields, any custom page title I make is deleted on import of an xls file. To solve this I've tried to add the new fields to your admin/model/tool/export.php file.
As a result I am now able to export the xls file with the new fields and correct content.
However when I import the xls file again it empties the database and doesn't populate it with new data.

I have tried hard to find the cause of this, but with my limited php knowledge I haven't succeeded.
Could you take a look at the attached php file?
You can find my entries with a search for 'cptitle'.
Would be very much appreciated :-)

I am running OpenCart 1.5.3.1 with opencart-1-5-2-x-export-import-10
Works fine without the custom page titles alteration.

My OpenCart error log shows no errors.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Thu Aug 30, 2012 10:26 pm
by JNeuhoff
In the uploadProducts, put the 2 lines

Code: Select all

			$cptitle = $this->getCell($data,$i,$j++);
			$cptitle = htmlentities( $cptitle, ENT_QUOTES, $this->detect_encoding($cptitle) );
immediately after the line

Code: Select all

			$name = $this->getCell($data,$i,$j++);
			$name = htmlentities( $name, ENT_QUOTES, $this->detect_encoding($name) );
The same is true for the uploadCategories.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Fri Aug 31, 2012 12:59 pm
by jipsa78
Thanx, that seems to have solved it!
I had put cptitle in the wrong position, under meta_keywords, before.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Fri Aug 31, 2012 4:12 pm
by jipsa78
There's one more edit needed.
Because of the added column in the xls file the function storeAdditionalImagesIntoDatabase is now getting the image information from the meta_keywords column.
To solve this find:

$imageNames = trim($this->getCell($data,$i,31));

And change it to:

$imageNames = trim($this->getCell($data,$i,32));

Re: [RELEASED] Export/Import tool for OpenCart 1.5.3.x

Posted: Fri Aug 31, 2012 9:05 pm
by JNeuhoff
jipsa78 wrote:There's one more edit needed.
Because of the added column in the xls file the function storeAdditionalImagesIntoDatabase is now getting the image information from the meta_keywords column.
To solve this find:

$imageNames = trim($this->getCell($data,$i,31));

And change it to:

$imageNames = trim($this->getCell($data,$i,32));
Well spotted! :)