Post by JNeuhoff » Fri Aug 17, 2012 7:46 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by loki52 » Sat Aug 18, 2012 4:31 am

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.

Newbie

Posts

Joined
Thu Aug 02, 2012 12:51 am

Post by JNeuhoff » Sat Aug 18, 2012 4:50 am

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by baldex » Thu Aug 23, 2012 7:06 am

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>

User avatar
Newbie

Posts

Joined
Thu Aug 23, 2012 4:00 am

Post by baldex » Thu Aug 23, 2012 7:09 am

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 ?

User avatar
Newbie

Posts

Joined
Thu Aug 23, 2012 4:00 am

Post by lee420 » Thu Aug 23, 2012 6:01 pm

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

Newbie

Posts

Joined
Tue Apr 10, 2012 7:35 am

Post by JNeuhoff » Thu Aug 23, 2012 8:28 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Thu Aug 23, 2012 8:31 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by mrjave » Thu Aug 23, 2012 8:32 pm

hi all,

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

kind regards,
Jave

Active Member

Posts

Joined
Wed Jun 13, 2012 4:22 pm

Post by JNeuhoff » Thu Aug 23, 2012 8:43 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by cstoner69 » Thu Aug 23, 2012 10:31 pm

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

Newbie

Posts

Joined
Mon Oct 10, 2011 4:43 am

Post by JNeuhoff » Thu Aug 23, 2012 11:17 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by bertjebel » Sun Aug 26, 2012 9:19 am

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

My shops running Opencart Multistore:
Koptelefoon, audio kabels en speakers kopen
Led lampen en verlichting
Alle kabels- audiokabel, computerkabel, stroomkabel
Koptelefoon en In ear oordopjes / oortjes Apple iPhone, Samsung Smartphone
Smartphone hoesjes en oordopjes Apple iPhone en Samsung
Online Aanbiedingen en Sales
Hoesjes, Covers en accessoires Tablet en smartphone


User avatar
Active Member

Posts

Joined
Tue Jun 21, 2011 11:17 am


Post by mickeykhan » Sun Aug 26, 2012 6:10 pm

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..!!!

Newbie

Posts

Joined
Sat Feb 25, 2012 4:21 pm

Post by JNeuhoff » Mon Aug 27, 2012 6:29 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jipsa78 » Thu Aug 30, 2012 9:39 pm

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.

Attachments

modified export.php


Newbie

Posts

Joined
Sun Aug 12, 2012 6:21 pm

Post by JNeuhoff » Thu Aug 30, 2012 10:26 pm

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jipsa78 » Fri Aug 31, 2012 12:59 pm

Thanx, that seems to have solved it!
I had put cptitle in the wrong position, under meta_keywords, before.

Newbie

Posts

Joined
Sun Aug 12, 2012 6:21 pm

Post by jipsa78 » Fri Aug 31, 2012 4:12 pm

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));

Newbie

Posts

Joined
Sun Aug 12, 2012 6:21 pm

Post by JNeuhoff » Fri Aug 31, 2012 9:05 pm

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! :)

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 5 guests