Post by JNeuhoff » Sat Apr 15, 2017 4:54 am

bryanling wrote:
Sat Apr 15, 2017 12:41 am
Hi JNeuhoff, would you mind to share this ? Or I need to buy it ? Thank you.
Please send me a PM, modifications chargeable for a small fee.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by mtjhost » Sat Apr 15, 2017 11:23 pm

So how if someone can integer the Filezilla module in the admin itself and when I click on the Filezilla it have permanent settings from admin and connect the Filezilla to the root.

Can anyone think it is a great idea and can be implement to make the life easy.

New member

Posts

Joined
Wed Apr 30, 2014 12:37 am

Post by dedoboss » Tue Apr 18, 2017 9:44 pm

Hello Everybody
Everything worked well during installation
but I have nothing regarding this extension in System > Users > User Group > Edit Administrator

So I have this error:
Permission Denied! Home Permission Denied!
You do not have permission to access this page, please refer to your system administrator.

how can I do?

thank you very much
ciao ciao

New member

Posts

Joined
Fri Sep 30, 2011 3:26 pm

Post by JNeuhoff » Tue Apr 18, 2017 9:56 pm

dedoboss wrote:
Tue Apr 18, 2017 9:44 pm
Hello Everybody
Everything worked well during installation
but I have nothing regarding this extension in System > Users > User Group > Edit Administrator

So I have this error:
Permission Denied! Home Permission Denied!
You do not have permission to access this page, please refer to your system administrator.

how can I do?

thank you very much
ciao ciao
You have most likely not followed the install instructions from the 'readme.txt'. In particular, it looks like your files were uploaded to the wrong place, due to mis-configured FTP settings, e.g. FTP root, for your OpenCart extension installer. See http://docs.opencart.com/extension/installer/ for more details.

The good news is that the upcoming new OpenCart 3.0.0.0 won't be using FTP any more for the extension installer, many users seem to have problems with the current OpenCart 2.3.0.2 installer configuration. I hope that in the future simple one-click installs will become the norm.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by equineupholstery » Wed Apr 19, 2017 7:08 pm

Hi,

I've installed on opencart 2.3.0.2 and I'm having some problems when trying to upload products:

The error I get is below, 2 things stand out to me but I'm not sure how to fix
1. I'm using a MySQL database, not a MariaDB
2. There's a double comma as a delimiter between the data for location and mpn (no commas are in the data itself)

Any pointers would be greatly appreciated!

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''A590',11,'',1,380,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','0','1')' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (50,1000,'A590','','','','','A590','default',,'A590',11,'',1,380,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','0','1');


Posts

Joined
Wed Apr 19, 2017 6:35 pm

Post by JNeuhoff » Wed Apr 19, 2017 11:25 pm

Missing stock_status_id, usually one of the following numeric values:
5 = Out Of Stock
6 = 2-3 Days
7 = In Stock
8 = Pre-Order

User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by peter.axet » Mon May 01, 2017 9:08 pm

opencart 2.3.0.2 export import 3.11

I don´t know. Some Help me ? Thanks

On local XAMP is OK, but on my domain error.

log file:
Could not close zip file php://output.

2017-05-01 14:53:04 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/ri020900:/usr/share/pear) in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 178
2017-05-01 14:53:04 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/home/ri020900:/usr/share/pear) in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 190
2017-05-01 14:53:04 - PHP PHPExcel_Writer_Exception: Could not close zip file php://output. in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 389

Newbie

Posts

Joined
Mon May 01, 2017 8:56 pm

User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by z2i » Tue May 02, 2017 12:11 am

It seems like exported files are wrong with PHP 7.
On PHP 5 everything works well.

z2i
Newbie

Posts

Joined
Thu Dec 15, 2016 6:06 pm

Post by JNeuhoff » Tue May 02, 2017 1:19 am

z2i wrote:
Tue May 02, 2017 12:11 am
It seems like exported files are wrong with PHP 7.
On PHP 5 everything works well.
Send me a PM withn your OpenCart and FTP login details, and I can take a quick look at your site.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TBit » Fri May 05, 2017 10:49 pm

Hello,

I have a problem. I exported the Products from my old OpenCart V.1.5.1.3 and tried to import them in the new V.2.3.0.2 and I am getting this Message

Code: Select all

2017-05-05 16:39:27 - Export/Import: Invalid header in the Products worksheet
2017-05-05 16:39:27 - Export/Import: Invalid header in the ProductAttributes worksheet
2017-05-05 16:40:32 - Export/Import: Invalid header in the Products worksheet
I have to mention that I am using JooCart it's a Jooma & OpenCart Integration
If I open up both worksheest from the new version as example and the old one, I can see there are diffrences in the columns and how many columns there are available I think thats the point but how should I fix it?

Thanks

Newbie

Posts

Joined
Fri May 05, 2017 10:46 pm

Post by JNeuhoff » Fri May 05, 2017 11:09 pm

The formats of the worksheets will be slightly different between OpenCart versions. Therefore its best to do an Export first from the new OpenCart-based site and then use the resulting spreadsheet to copy and paste the old data to the new one.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TBit » Fri May 05, 2017 11:14 pm

JNeuhoff wrote:
Fri May 05, 2017 11:09 pm
The formats of the worksheets will be slightly different between OpenCart versions. Therefore its best to do an Export first from the new OpenCart-based site and then use the resulting spreadsheet to copy and paste the old data to the new one.
Is there an easy way to do it with microsoft excel? never did something like this before

Newbie

Posts

Joined
Fri May 05, 2017 10:46 pm

Post by JNeuhoff » Fri May 05, 2017 11:29 pm

This has nothing to do MS Excel. You need to install the new OpenCart, and a matching Export/Import tool. Then do an Export to see the new spreadsheet format which differs from older OpenCart versions.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by panaceya » Sun May 07, 2017 9:18 pm

Hi!

I have clean installed Opencart 2.3.0.2 and this extension version 3.11. And have one question and one trouble:

1. Why you add OpenCartWorks after install this extension?
2. Export not worked - new items not adding (but success message showed)

https://youtu.be/30xTILSKK7c

Newbie

Posts

Joined
Sun May 07, 2017 9:11 pm

Post by TBit » Mon May 08, 2017 4:00 pm

JNeuhoff wrote:
Fri May 05, 2017 11:29 pm
This has nothing to do MS Excel. You need to install the new OpenCart, and a matching Export/Import tool. Then do an Export to see the new spreadsheet format which differs from older OpenCart versions.
I understand that and I exported it in the new Opencart to see the diffrence but how can I make the old spreasheet look like the new one so I can Import it back to the new one?

Thanks

Newbie

Posts

Joined
Fri May 05, 2017 10:46 pm

Post by bvv311077 » Tue May 16, 2017 8:34 pm

Hi!
After removal of the module are not added to products.

Error:PHP Notice: Undefined index: product_id in /var/www/magazin/data/www/smarket74.ru/system/storage/modification/admin/view/template/catalog/product_form.tpl on line 136

What to do?

Newbie

Posts

Joined
Tue May 16, 2017 8:11 pm

Post by alexlim » Thu May 25, 2017 10:26 am

Error problem,

When I import my product it show this error message " Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed. "

Attachments


Newbie

Posts

Joined
Thu May 25, 2017 10:23 am

Post by kazihaha » Thu May 25, 2017 1:32 pm

I got errot php://output. Please help me.
OC 2.2.0.0

https://sieuthithietbivanphong.com


New member

Posts

Joined
Wed Sep 23, 2015 2:13 pm

Post by JNeuhoff » Thu May 25, 2017 5:58 pm

Can't help you, you are not providing enough details.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 37 guests