Post by KGal » Mon Jan 18, 2010 3:15 pm

Thanks! very much

New member

Posts

Joined
Sun Jan 03, 2010 1:28 pm
Location - Australia

Post by reedmeier@gmail.com » Tue Jan 19, 2010 6:23 am

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.


Posts

Joined
Wed Jan 13, 2010 11:41 pm

User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by rph » Wed Jan 20, 2010 6:20 am

Thanks! Very much appreciated, as always!

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by Miguelito » Wed Jan 20, 2010 6:27 am

Excellent contrib, thanx!!!

The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."


Active Member

Posts

Joined
Sun Jan 10, 2010 10:11 pm

Post by rebirth » Thu Jan 21, 2010 5:56 am

Hello,

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');
Is this because I entered something wrong in the xls, or I forgot to enter something, or is there an other cause?

New member

Posts

Joined
Fri Jan 15, 2010 4:36 pm
Location - .be

Post by JNeuhoff » Thu Jan 21, 2010 6:57 am

rebirth wrote: Is this because I entered something wrong in the xls, or I forgot to enter something, or is there an other cause?
Have you forgotten to enter values for the length, width and height in the product worksheet?

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by rebirth » Thu Jan 21, 2010 3:19 pm

no, you are correct, I did not enter those. I didn't know those are obligated. Will try it again with them. Thank you for the fast response.

New member

Posts

Joined
Fri Jan 15, 2010 4:36 pm
Location - .be

Post by Nick.Shebanov » Sun Jan 24, 2010 10:57 pm

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?

Newbie

Posts

Joined
Sun Jan 24, 2010 10:54 pm

Post by Nick.Shebanov » Sun Jan 24, 2010 11:03 pm

Sorry, the problem was as usual in administation rights. Thank you for great tool!

Newbie

Posts

Joined
Sun Jan 24, 2010 10:54 pm

Post by tcecil » Tue Jan 26, 2010 12:07 pm

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

New member

Posts

Joined
Tue Jan 26, 2010 9:13 am
Location - FLORIDA

Post by tcecil » Tue Jan 26, 2010 11:10 pm

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.

New member

Posts

Joined
Tue Jan 26, 2010 9:13 am
Location - FLORIDA

Post by JNeuhoff » Tue Jan 26, 2010 11:38 pm

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tcecil » Wed Jan 27, 2010 12:11 am

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.

New member

Posts

Joined
Tue Jan 26, 2010 9:13 am
Location - FLORIDA

Post by JNeuhoff » Wed Jan 27, 2010 12:24 am

Create a file called e.g. test.php, with the following content:

Code: Select all

<?php phpinfo(); ?>
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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tcecil » Wed Jan 27, 2010 12:31 am

J,
That worked very easy. It pulled up a whole php spec chart. Now, what am I looking for with-in this chart? It's a lot of information!


Oh, I found this!!

.;./includes;./pear

New member

Posts

Joined
Tue Jan 26, 2010 9:13 am
Location - FLORIDA

Post by JNeuhoff » Wed Jan 27, 2010 1:06 am

Oh, I found this!!

.;./includes;./pear
I assume the '.' (current working directory) refers to
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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by tcecil » Wed Jan 27, 2010 9:03 pm

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)

New member

Posts

Joined
Tue Jan 26, 2010 9:13 am
Location - FLORIDA
Who is online

Users browsing this forum: No registered users and 5 guests