mark 14 years ago
Hi ,
just installed this mod, copied all files to server as stated in readme file including xml file, using latest vqmod, when i go to set the permissions i see no export / import line to click and when i try to run module it says permission denied , have i done something wrong , we are using oc version 1.5.1.3
viviclothes 14 years ago
ps: it is working for importing and exporting.
viviclothes 14 years ago
Hi all,
I have modified this module for MULTILANGUAGE support!
If you have installed more then 1 language in your opencart this tool will just export an excel sheet and tables for all those languages. Including SEO, meta data and EVERYTHING you need. Sinds the developer never finish this tool with MULTILANGUAGE we did it our self. If you have interest drop us an email at: info[at]optimal-ict.nl
bassphunk 14 years ago
Hello and thanks for great application. Export is ok, but import is problem.
I am running 1.5.1.3
Fatal error: Maximum execution time of 7 seconds exceeded in /home/mydomain.cz/mydomain.cz/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 559
php.ini
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 512M;
max_execution_time = 480000;
upload_max_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;
Can anyone please help with this?
jece 14 years ago
@Marrek:
Hi, did you solve this? How?
thnx
jece 14 years ago
@hopskipjump:
I have the problem the other way around.
Did you solve this?
ngalligan@live.ie 14 years ago
This extension works great, however it does not export the option images, and so deletes them all on the import, this is a big issue if you have options with images for each product, after import they need to be all set up again, the other problem is that on import it deletes everything, if for any reason this import fails then all products, categories and options are removed from the database, is there any way to sort out the option images and possibly make the import not delete everything but add changed and new data
dave88008 14 years ago
@MrTech: thanks, that helps. It's not there on my install so even tho I swear I followed the install steps exactly, a gremlin probably got in and messed it up. : )
jameswintonellis 14 years ago
If anyone is interested I have learned how to add fields to this extension. For example I am using "Advanced Products Purchased Report (with product options) + Profit Reporting for OC v1.5.x" and it adds a column to the "product" table in OC. This extension does not dynamically detect the new field so I went into the export.php script and added the fields. It is not an easy task but it can be done if you ever have this requirement.
Boysano 14 years ago
@Boysano: @dave880088 RESOLVED: I figured out why the admin area breaks after upload of folders. My siteground host has a policy that disables and folders or files when their permissions are above (more relaxed) than 755. Thus, 755 permission for admin folder makes it work again, if it is 777 or 775 it will give "Internal Server Error"
Boysano 14 years ago
@dave88008:
I also am using Opencart (1.5.1.3 latest with latest import/export) for the first time and had the same problem where the admin area to my website is not working and i get 404 error, I still havent installed VQMOD and will try that next, otherwise I followed the readme to the letter up to the point where I had to access my admin area and realised its not working and showing "Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request."
Method was to upload the zip to my siteground host, and unzipped it, then I moved the folders to the correct spots. Probably either over write some important file or i must install vqmod - i hope.
Will let you know, if anyone can help please let me know? Front end is still working.
MrTech 14 years ago
@dave88008 On my admin menu it's under System -> Export/Import (which is the last menu item at the bottom).
If it's not there I'm thinking you skipped a step in the readme or don't have vqmod installed. When something doesn't work for me, I delete all installation files from the server and start over from scratch.
dave88008 14 years ago
@dave88008: I got it installed but there's no "Export" button or link anywhere I can find. Would appreciate it if someone could tell me where it's supposed to be so I can use it or know the module is not installed properly. Thanks
dave88008 14 years ago
I'd love to use this but when I followed the instructions...
"1) Upload the folders 'admin', 'system', 'vqmod' and their files
from the 'upload' directory to your OpenCart root directory."
It overwrote the existing folders and broke access to the admin area. (I restored the install to previous day and was able to get back into the app)
I'm obviously too thick to 'get' exactly how to install this module.
I just started setting up Opencart so maybe there's a generic tutorial on installing modules?
Thanks in advance if you can point me in the right direction.
chrisnewbee 14 years ago
I was working great before i moved host.
Now I get this error when i click Export:
Warning: set_time_limit(): Cannot set time limit due to system policy in /admin/controller/tool/export.php on line 76
Im not sure was the problem is... please help. OC 1.5.1.3
aha56 14 years ago
Brilliant. Works great for me (only on localhost though -might have some fun trying to make it work on the shared server later). Thanks a bunch though, very smart!
akssiv2007 14 years ago
Notice: Error: MySQL server has gone away
Error No: 2006
DELETE FROM `product_image` in /home/peacockw/public_html/uc/system/database/mysql.php on line 49
it was working fine before but now i get this error .
after going through this post
http://forum.opencart.com/viewtopic.php?f=112&t=18211&p=90525#p90525
I asked my hosts to change the settings now my current settings are
memory_limit 128M
post_max_size 8M
upload_max_filesize 999M
but still the same problem.
Any solution.
riteshd 14 years ago
kaise hoooooooooooooo
unsound 14 years ago
Thank you so much! much appraciate...
siteadvice 14 years ago
Those people getting the "Fatal error: Call to undefined method PHPExcel_Reader_CSV..." error - I suspect that's from a non-standard character set.
You might try running the Export command first to create an Excel document and then compare it with the one you're trying to import.
(I don't have anything to do with the making of this extension, so please don't ask me for further info!)
