Still on our to-do-list for future releases (just need some time to get it all done, was quite busy lately):
- Improved validation and error/exception handler
- Multi-lingual support
- Incremental Import
The Export/Import tool is now available for OpenCart 1.5.4.
Still on our to-do-list for future releases (just need some time to get it all done, was quite busy lately):
Still on our to-do-list for future releases (just need some time to get it all done, was quite busy lately):
Last edited by JNeuhoff on Thu Aug 23, 2012 6:57 pm, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
i think he's saying he's planning on adding multi-lingual support in a future version. Those bullet points appear to be for a future version...his current "road map" 
Hi
I've just installed this but the menu isn't there? Is appears in 'user group' ok and I ticked it but nothing? I've installed it several times on different versions. I could add it manually I guess?
I've just installed this but the menu isn't there? Is appears in 'user group' ok and I ticked it but nothing? I've installed it several times on different versions. I could add it manually I guess?
You haven't fully the readme.txt instructions. In particular, you also need to install VQmod.ralphstirrat wrote:Hi
I've just installed this but the menu isn't there? Is appears in 'user group' ok and I ticked it but nothing? I've installed it several times on different versions. I could add it manually I guess?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I did install vqmod but I don't think it's installed correctly now as there's nothing in the vqcache folder. Sorry.
Perhaps you should also install vqmod manager, it makes live a whole lot easier.
http://www.opencart.com/index.php?route ... load_id=27
http://www.opencart.com/index.php?route ... load_id=27
I had an old version of vqmod (216) I was using, I updated it to 217 and all fine now thank you.
I installed this plugin on oc 1.5.4 and got this when trying to export:
and so on.
Question: what does it mean? Is the server not very good for the extention?
Thanx,
-Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /usr/home/minskpok/domains/mysite.com/public_html/oc/admin/controller/tool/export.php on line 75ÐÏࡱá;þÿ ÊþÿÿÿËÌÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ » ÌAB°=¼%r8X"1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈArial¤ ######0.00¥##0.00¦@àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À à
and so on.
Question: what does it mean? Is the server not very good for the extention?
Thanx,
Your web server is set with an overly restrictive security configuration. Just comment out the line 75 in file admin/controller/tool/export.php, and chances it will work.adida wrote:I installed this plugin on oc 1.5.4 and got this when trying to export:
-Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /usr/home/minskpok/domains/mysite.com/public_html/oc/admin/controller/tool/export.php on line 75ÐÏࡱá;þÿ ÊþÿÿÿËÌÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ » ÌAB°=¼%r8X"1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈArial¤ ######0.00¥##0.00¦@àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À à
and so on.
Question: what does it mean? Is the server not very good for the extention?
Thanx,
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Is this release any more efficient than Opencart 1-5-2? That version worked fine until I hit the 1000 product mark (1MB Excel doc size) whereupon I started to get the dreaded " Fatal error: Allowed memory size of 99614720 bytes exhausted (tried to allocate 79 bytes) in blah blah..." messages.
Thanks for the tool. I have it up and running fine on 1 of my clients website. I would like some help with adding some extra info to the xls file.
I have a mod installed that has added 5 extra fields to each of the products in the products table in the database. Import/Export works fine but of course it leaves those fields blank. It would be very nice if I could populate those through the xls file as well.
I realize I have to modify the model\tool\export.php by adding the fields that I want to import/export. However my php knowledge is rather limited so I could use some assistance. If you (or anybody else here) could tell me the exact spots where I need add the code for the extra fields I think I could modify the file myself. Thanks in advance!
I have a mod installed that has added 5 extra fields to each of the products in the products table in the database. Import/Export works fine but of course it leaves those fields blank. It would be very nice if I could populate those through the xls file as well.
I realize I have to modify the model\tool\export.php by adding the fields that I want to import/export. However my php knowledge is rather limited so I could use some assistance. If you (or anybody else here) could tell me the exact spots where I need add the code for the extra fields I think I could modify the file myself. Thanks in advance!
The changes need to go into the admin/model/export.php, in the following methods:Chris_AXA wrote:Thanks for the tool. I have it up and running fine on 1 of my clients website. I would like some help with adding some extra info to the xls file.
I have a mod installed that has added 5 extra fields to each of the products in the products table in the database. Import/Export works fine but of course it leaves those fields blank. It would be very nice if I could populate those through the xls file as well.
I realize I have to modify the model\tool\export.php by adding the fields that I want to import/export. However my php knowledge is rather limited so I could use some assistance. If you (or anybody else here) could tell me the exact spots where I need add the code for the extra fields I think I could modify the file myself. Thanks in advance!
storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi Juergen, would it be possible (perhaps even for the next release) to add the abbility to ex/import custom selectable fields from producttables?
I've got severall other modifications installed which also add productdata to the database, which is productspecific and when having quite a lot of products this would be a huge addition.
Curious to your reply!
I've got severall other modifications installed which also add productdata to the database, which is productspecific and when having quite a lot of products this would be a huge addition.
Curious to your reply!
Ok finally got around to working on it. I added the 5 extra values in the places you specified. I was able to successfully export the .xls with the 5 added columns.JNeuhoff wrote: The changes need to go into the admin/model/export.php, in the following methods:
storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet
However when I tried to import the .xls back again I got the following error.
Notice: Error: Column count doesn't match value count at row 1
Error No: 1136
INSERT INTO `product`
Is there some value (column count) that I need to change?
EDIT: Never mind I got it working! I forgot to add the values to the $sql in storeProductsIntoDatabase.
Thanx again for your help and free extention.
Hi guys,
JNeuhoff thanks for the great module.
I have installed this in OC 1.5.4.1
However, I've got the following error message: Table 'clebe_nuvogue.product_tag' doesn't exist<br
Should I create product_tag table by myself?
JNeuhoff thanks for the great module.
I have installed this in OC 1.5.4.1
However, I've got the following error message: Table 'clebe_nuvogue.product_tag' doesn't exist<br
Should I create product_tag table by myself?
You are using a wrong, non-matching version of the Export/Import tool for your OpenCart 1.5.4.1.christianlebe wrote:Hi guys,
JNeuhoff thanks for the great module.
I have installed this in OC 1.5.4.1
However, I've got the following error message: Table 'clebe_nuvogue.product_tag' doesn't exist<br
Should I create product_tag table by myself?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 18 guests
