Now available from the contributions section.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I installed the Export/Import module in version 1.4 and set my admin rights in the settings as per the readme file. After that I am lost.
I have no idea how to work this program and do not see an interface within the admin section of opencart. HELP!
I read something about pear. Do I need to install a Pear feature on my server? Which "pear" module am I supposed to install? There are tons of them to choose from.
If you have any other documentation I would really appreciate it. Thank you.
I have no idea how to work this program and do not see an interface within the admin section of opencart. HELP!
I read something about pear. Do I need to install a Pear feature on my server? Which "pear" module am I supposed to install? There are tons of them to choose from.
If you have any other documentation I would really appreciate it. Thank you.
It requires the PHP Pear library with the Excel Writer package.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Excellent contrib, thanx!!!
The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."
Hello,
I have a problem when I upload my edited xls file and try to import it. I then get this error:
Is this because I entered something wrong in the xls, or I forgot to enter something, or is there an other cause?
I have a problem when I upload my edited xls file and try to import it. I then get this error:
Code: Select all
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',1,'2')' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`measurement_class_id`) VALUES (49,865,'LOG-980447-0914','0',6,'product 21',11,'headset/LOG-980447-0914.jpg',1,11.8047,NOW(),NOW(),'2009-02-08',3,1,1,9,1,,,1,'2');Have you forgotten to enter values for the length, width and height in the product worksheet?rebirth wrote: Is this because I entered something wrong in the xls, or I forgot to enter something, or is there an other cause?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello.
When I am trying to Export, I get something like "This page is not found" (http://.../admin/index.php?route=tool/export/download). What's the problem?
When I am trying to Export, I get something like "This page is not found" (http://.../admin/index.php?route=tool/export/download). What's the problem?
Where do I get this PEAR installation?
and, how do I get PEAR.php loaded to my Windows Server.
How do I do this? Is there some easy way to upload this PHP-PEAR library that I need to get this Import/Export Module to work??
Please help with, hopefully some easy instructions.
Thank You
and, how do I get PEAR.php loaded to my Windows Server.
How do I do this? Is there some easy way to upload this PHP-PEAR library that I need to get this Import/Export Module to work??
Please help with, hopefully some easy instructions.
Thank You
Ok, my windows/plesk host says I have PEARS-PHP already installed. I have installed the new version Export/Import 1.4.0 and when I click on the "Export" button with-in the admin-control panel - I get this error:
Fatal error: Class 'PEAR' not found in C:\Inetpub\vhosts\knastore.com\httpdocs\KNASTORE\admin\Spreadsheet\Excel\Writer\Format.php on line 45
Why do I get this error and how can I repair this?? Thanks for any help.
Fatal error: Class 'PEAR' not found in C:\Inetpub\vhosts\knastore.com\httpdocs\KNASTORE\admin\Spreadsheet\Excel\Writer\Format.php on line 45
Why do I get this error and how can I repair this?? Thanks for any help.
What's in your PHP include path? And where exactly on your server machine has your webhost installed the PHP Pear library? You can find this stuff by running the <?php phpinfo(); ?> from a PHP file on your web server.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I'm sorry, I'm not at all up on php. How exactly do I create this file (<?php phpinfo(); ?> ). Do I create a web page and place this code? Then after I ftp upload what do I do with it? I don't think I have any controls to "run" anything directly once it's uploaded to my host-server.
p.s. This is what my host provides: Third-party components update
Plesk 8.6 supports several updated third-party components: PHP 5.2.6, Horde Kronolith 2.1.8, phpMyAdmin 2.11.6, MySQL ODBC connector 3.51.25, and BIND DNS Server 9.4.2-P1. Thanks again.
p.s. This is what my host provides: Third-party components update
Plesk 8.6 supports several updated third-party components: PHP 5.2.6, Horde Kronolith 2.1.8, phpMyAdmin 2.11.6, MySQL ODBC connector 3.51.25, and BIND DNS Server 9.4.2-P1. Thanks again.
Create a file called e.g. test.php, with the following content:
and upload it via FTP to your server at
httpdocs\KNASTORE\admin\test.php
Then open up your test.php in your web browser, and it should show your PHP configuration.
Code: Select all
<?php phpinfo(); ?>httpdocs\KNASTORE\admin\test.php
Then open up your test.php in your web browser, and it should show your PHP configuration.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I assume the '.' (current working directory) refers toOh, I found this!!
.;./includes;./pear
C:\Inetpub\vhosts\knastore.com\httpdocs\KNASTORE\admin
So that explains why it can't find the PEAR.php. Ask your webhost to amend the PHP include path so it can find the PEAR library.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello J,
I got a response back from my host today. Here is the response:
"Hello.
Please check this URL http://mytoddsworld.com/phpinfo.php. You will see the path to “C:\Program Files (x86)\Parallels\Plesk\Additional\Php\PEAR\PEAR.php” library already included to “include_path” value."
Please Note: www.mytoddsworld.com is my main account domain, I have several other websites that I host from my account. The one I am setting up the open cart store for and have the export/import module for is; www.knastore.com/KNASTORE/
Does this help with figuring out my original problem?
Remember, when I run the export from my admin panel I was getting this error:
"Fatal error: Class 'PEAR' not found in C:\Inetpub\vhosts\knastore.com\httpdocs\KNASTORE\admin\Spreadsheet\Excel\Writer\Format.php on line 45"
Thank You so much for examining this for me. (I just don't know what to do, and I really want this export/import module to work)
I got a response back from my host today. Here is the response:
"Hello.
Please check this URL http://mytoddsworld.com/phpinfo.php. You will see the path to “C:\Program Files (x86)\Parallels\Plesk\Additional\Php\PEAR\PEAR.php” library already included to “include_path” value."
Please Note: www.mytoddsworld.com is my main account domain, I have several other websites that I host from my account. The one I am setting up the open cart store for and have the export/import module for is; www.knastore.com/KNASTORE/
Does this help with figuring out my original problem?
Remember, when I run the export from my admin panel I was getting this error:
"Fatal error: Class 'PEAR' not found in C:\Inetpub\vhosts\knastore.com\httpdocs\KNASTORE\admin\Spreadsheet\Excel\Writer\Format.php on line 45"
Thank You so much for examining this for me. (I just don't know what to do, and I really want this export/import module to work)
Who is online
Users browsing this forum: No registered users and 9 guests
