Page 1 of 13
[RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Fri Aug 17, 2012 9:22 pm
by JNeuhoff
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):
- Improved validation and error/exception handler
- Multi-lingual support
- Incremental Import
Re: [RELEASTED] Export/Import tool for OpenCart 1.5.4.x
Posted: Tue Aug 21, 2012 11:45 pm
by burley
Great work!!
Does this mean that multilangual is also supported with the 1.5.3.x versions? Or just with the 1.5.4 version?
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Fri Aug 24, 2012 1:35 am
by moneycarlo
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"
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Fri Aug 24, 2012 2:33 am
by burley
my bad, read it the wrong way
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Aug 29, 2012 11:07 pm
by ralphstirrat
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?
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Aug 29, 2012 11:21 pm
by JNeuhoff
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?
You haven't fully the readme.txt instructions. In particular, you also need to install
VQmod.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Aug 29, 2012 11:33 pm
by ralphstirrat
I did install vqmod but I don't think it's installed correctly now as there's nothing in the vqcache folder. Sorry.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Aug 29, 2012 11:40 pm
by burley
Perhaps you should also install vqmod manager, it makes live a whole lot easier.
http://www.opencart.com/index.php?route ... load_id=27
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Aug 29, 2012 11:41 pm
by ralphstirrat
I had an old version of vqmod (216) I was using, I updated it to 217 and all fine now thank you.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Sep 10, 2012 1:36 am
by adida
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,
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Sep 10, 2012 5:37 pm
by JNeuhoff
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,
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.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Sep 10, 2012 5:59 pm
by adida
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.
Hey, you are right. It is working now. Thanx a lot.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Sep 12, 2012 4:17 pm
by davski13
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.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Sep 24, 2012 7:36 pm
by Chris_AXA
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!
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Sep 24, 2012 11:56 pm
by Chris_AXA
Oeps double post!
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Tue Sep 25, 2012 10:40 pm
by JNeuhoff
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!
The changes need to go into the admin/model/export.php, in the following methods:
storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Wed Oct 03, 2012 9:43 pm
by burley
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!
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Thu Oct 04, 2012 9:06 pm
by Chris_AXA
JNeuhoff wrote:
The changes need to go into the admin/model/export.php, in the following methods:
storeProductsIntoDatabase
uploadProducts
validateProducts
populateProductsWorksheet
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.
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.
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Sun Oct 07, 2012 1:12 pm
by christianlebe
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?
Re: [RELEASED] Export/Import tool for OpenCart 1.5.4.x
Posted: Mon Oct 08, 2012 11:58 pm
by JNeuhoff
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?
You are using a wrong, non-matching version of the Export/Import tool for your OpenCart 1.5.4.1.