Page 1 of 1

Using Import Export

Posted: Tue May 05, 2009 4:18 pm
by PeterWijn
Hello

After installing the import/export extension (contribution?) i got the following message
when going to to the backup-restore option:

Fatal error: Class 'Controllermodulelayout' not found in C:\wamp\www\system\engine\controller.php on line 54

I'm under the impression that is has something to do with the PEAR part for PHP
Haven't figured that out yet

With regards
Peter Wijn

Re: Using Import Export

Posted: Tue May 05, 2009 5:23 pm
by JNeuhoff
Have you installed the latest version of the Export/Import module on your server?

I don't think this error message has anything to do with the Export/Import.

The layout controller file is now located at
  • catalog/controller/common/layout.php
and not anymore in the
  • catalog/controller/module/layout.php
What version of Opencart are you using? Have you installed other contributions, too?

Re: Using Import Export

Posted: Tue May 05, 2009 10:17 pm
by PeterWijn
Hello

I Installed the latest edition of the impex module last night
I use opencart 1.2.6
I read about the pear-php installation in the instructions
it looks like it is installed although i cant seem to check id it is running
I run the latest WAMP on my local system

There are regular erros about missing *.php or *.tpl files
after searching them in the folders eand copying them to the right place
normally everything works fine.

With regards

Re: Using Import Export

Posted: Wed May 06, 2009 12:11 am
by JNeuhoff
There are regular erros about missing *.php or *.tpl files
after searching them in the folders eand copying them to the right place
normally everything works fine.
If you can't get it to work, try a fresh install of Opencart 1.2.7 and the latest Export/Import module.
If you still get the error messages, tell us exactly what they are, and I can try to get it resolved from there.

Re: Using Import Export

Posted: Wed May 06, 2009 1:43 am
by PeterWijn
Thank you for your quick respons
Will try tonight, keep you posted.

Re: Using Import Export

Posted: Wed May 06, 2009 5:32 am
by PeterWijn
Hello

Reinstalled:
- opencart 1.2.7
- Category Descriptions 126
- go-pear.bat

made an export doc 'mijn_eigen.ods' yesterday evening
today i tried to import 'mijn_eigen.ods'
result:
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 'PK' at line 1
Error No: 1064


the rest is all garbage
the programm itself seem to run properly
looks like the status is now -> rebuild my data

Re: Using Import Export

Posted: Wed May 06, 2009 3:37 pm
by PeterWijn
Hello

Latest update

Seemd to have mist the latest update for the impex module
Installed the latest version an tried
- exporting, resulting in the following error

Warning: require_once(PEAR.php) [function.require-once]: failed to open stream: No such file or directory in C:\wamp\www\admin\Spreadsheet\Excel\Writer.php on line 35

Fatal error: require_once() [function.require]: Failed opening required 'PEAR.php' (include_path='.;C:\php5\pear') in C:\wamp\www\admin\Spreadsheet\Excel\Writer.php on line 35

Looks like the problem is in the hard-coded path for pear.php?

Re: Using Import Export

Posted: Wed May 06, 2009 4:49 pm
by JNeuhoff
You need to install the PEAR library.

Re: Using Import Export

Posted: Thu May 07, 2009 3:58 pm
by PeterWijn
Hello

Having trouble with installing the PEAR thing and some very promissing extensions from Fido-x.
Takes me too much time for now.

Will work with opencart and the categorie description extension.
For the other extensions I will probably have to wait untill they are easier installable or I have more time to look into it.

Thanks for now and.....
I'll be back

Re: Using Import Export

Posted: Sat Jul 25, 2009 5:32 pm
by chulak
When i try to export i get 500 internal server error , can someone help me on how to install pear on windows?..because i get an error when i try to run go-pear.bat "pear unable to load dynamic library php_mssql.dll"
but i install pear using this tutorial http://www.geeksengine.com/article/inst ... html....am i doing wrong? help pls...

Re: Using Import Export

Posted: Sat Jul 25, 2009 7:48 pm
by JNeuhoff
Is there is a reason why your server has to run on Windows?

Most webhosts use Linux and have Pear pre-installed or easy install options for this library from the cPanel.

Re: Using Import Export

Posted: Tue Jul 28, 2009 3:22 am
by kdmp
PeterWijn wrote: Seemd to have mist the latest update for the impex module
what is the impex module?

I am having the same issue where it provides me with a 1064 error with a bunch of other data showing on the screen.

I have verified that my PHP has been packaged with Pear.

Is there a limit on how much can be imported? I have around 1900 products.

Re: Using Import Export

Posted: Tue Jul 28, 2009 4:13 am
by JNeuhoff
Any screenshots? What's the exact error message? URL?

Re: Using Import Export

Posted: Tue Jul 28, 2009 1:10 pm
by kdmp
I think I solved it - I haven't tested, but maybe you could confirm something.

The error message is a MySQL syntax error - 1064. I believe that relates to 'improper' data. I was originally looking at the wrong work sheet, however, I looked on the Options worksheet. If there is a blank 'option (column c) would that generate an error? I noticed that I added an option but I didn't add the option name. I believe that is what the issue is when this syntax error appears.

Re: Using Import Export

Posted: Wed Jul 29, 2009 1:51 am
by chulak
So i cant use eport/import on windows server? or i am doing something wrong? I use Win serv 2008 enterprise and i have to use win and not linux for some reasons...so i cant make this working? Someone can help me with pear? i have latest php $ mysql installed and iis7. Thx!!!

Re: Using Import Export

Posted: Fri Jul 31, 2009 10:55 am
by kdmp
kdmp wrote:The error message is a MySQL syntax error - 1064. I believe that relates to 'improper' data. I was originally looking at the wrong work sheet, however, I looked on the Options worksheet. If there is a blank 'option (column c) would that generate an error? I noticed that I added an option but I didn't add the option name. I believe that is what the issue is when this syntax error appears.
To follow up to my last post - that was it. If you receive a 1064 error that points to a line in your spreadsheet .... you most likely left a blank in a required 'field'.