Multilingual Export/Import for OpenCart 2.x / 3.x / 4.x

Hi,

I installed onto oc 2.2, successfully export and a xlsx file was created. But the file cannot be open, it says the file is wrong format or corrupted. I try open on 3 pc & hp, but still fail to be open. Pls help.

Thks.

Hi JNeuhoff,

I'm having the exact same problem and can't find any solution here yet.
I updated module successfully to latest version on OC 2.2.0.1. and 1.5.6.3. Both exports work find but when I try to import products from 2.0 version to 1.5.6 I get same error as below

Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also 'System > Error Logs' for more details.
No server data has been changed.

Log: Export/Import: Invalid header in the Categories worksheet

Any idea? I use same settings for both stores.

Thanks.

marmax wrote:Hi,
I have installed 2.0.0.0 from sratch, linux server, php 5.5.9
No plugins installed. (only this export/import plugin)

I have exported 3 files, options, categories, products with default plugin parameters to default xlsx file in opencart 1.5.6.4. 'File 'Options' was imported succesfully (although 2 extra checkboxes I found in imported options), while for 'categories' and 'products' I get message:

Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also 'System > Error Logs' for more details.
No server data has been changed.

and in opencart log: Export/Import: Invalid header in the Categories worksheet

I'm afraid I have no eccess to server's error_log (shared server).

The formats are different between your OpenCart versions. Do an Export first from the new OpenCart version, to see its exact format, and then copy and paste to the new spreadsheet file.

Hi,

Please help me. I'm getting this error in my log when I'm trying to add products by import/export extension.

2016-04-19 6:29:36 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/ladycsj6/public_html/system/library/db/mysqli.php on line 19
2016-04-19 6:29:36 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '978' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /home/ladycsj6/public_html/system/library/db/mysqli.php on line 41
2016-04-19 6:29:36 - PHP Notice: Trying to get property of non-object in /home/ladycsj6/public_html/catalog/model/catalog/product.php on line 10


Please let me know to how to fix it.

Hi, i have installed OC 2.2.0.0 and your tolls 2.32 in localhost servr (WAMP)

Export work perfect, but when try import the exported files without any modification show my this message:



( ! ) Fatal error: Call to undefined function isInteger() in C:\wamp64\www\1market\admin\model\tool\export_import.php on line 3977
Call Stack
# Time Memory Function Location
1 0.0005 246440 {main}( ) ...\index.php:0
2 0.0431 1205592 require_once( 'C:\wamp64\www\1market\system\framework.php' ) ...\index.php:26
3 0.1018 1457960 Front->dispatch( ) ...\framework.php:99
4 0.1854 2308936 Front->execute( ) ...\front.php:29
5 0.1854 2308936 Action->execute( ) ...\front.php:34
6 0.1890 2321288 call_user_func_array:{C:\wamp64\www\1market\vqmod\vqcache\vq2-system_storage_modification_system_engine_action.php:44} ( ) ...\vq2-system_storage_modification_system_engine_action.php:44
7 0.1890 2321720 ControllerStartupRouter->index( ) ...\vq2-system_storage_modification_system_engine_action.php:44
8 0.1895 2322744 Action->execute( ) ...\router.php:26
9 0.1937 2571824 call_user_func_array:{C:\wamp64\www\1market\vqmod\vqcache\vq2-system_storage_modification_system_engine_action.php:44} ( ) ...\vq2-system_storage_modification_system_engine_action.php:44
10 0.1937 2572784 ControllerToolExportImport->upload( ) ...\vq2-system_storage_modification_system_engine_action.php:44
11 0.2544 5566320 upload ( ) ...\export_import.php:28
12 0.2544 5566768 Proxy->__call( ) ...\export_import.php:28
13 0.2544 5566816 call_user_func:{C:\wamp64\www\1market\system\engine\proxy.php:13} ( ) ...\proxy.php:13
14 0.2544 5567088 Loader->{closure:C:\wamp64\www\1market\vqmod\vqcache\vq2-system_storage_modification_system_engine_loader.php:129-163}( ) ...\proxy.php:13
15 0.2568 5568272 call_user_func_array:{C:\wamp64\www\1market\vqmod\vqcache\vq2-system_storage_modification_system_engine_loader.php:150} ( ) ...\vq2-system_storage_modification_system_engine_loader.php:150
16 0.2568 5569472 ModelToolExportImport->upload( ) ...\vq2-system_storage_modification_system_engine_loader.php:150
17 1.3167 11343328 ModelToolExportImport->validateUpload( ) ...\export_import.php:5429
18 1.3489 11357072 ModelToolExportImport->validateProductIdColumns( ) ...\export_import.php:5349



WHY????

asusnet wrote:Hi, i have installed OC 2.2.0.0 and your tolls 2.32 in localhost servr (WAMP)

Export work perfect, but when try import the exported files without any modification show my this message:

( ! ) Fatal error: Call to undefined function isInteger() in C:\wamp64\www\1market\admin\model\tool\export_import.php on line 3977

There was a bug, please install the latest version 3.1 of the Export/Import tool.

guessme wrote:Hi,

Please help me. I'm getting this error in my log when I'm trying to add products by import/export extension.

It looks like a corrupted database to me.

For the product with product_id=978 something is wrong. Possible reasons are:
- more than 1 product discount
- more than 1 product special for a given customer group
- more than 1 product reward for a given customer group
- duplicate weight or length classes

Delete this product and then re-create it, this might fix it.

hi there developer and thanks for the great job

i've updated your extension to VER 3.1.2 through delete and install again but it says you are using old one update to ver 3.1 ...

and more importantly im getting the same error:
export_import.php on line 3977

I'm using OC 2.2 default theme

any suggestion?
many thanks in advance

Amin734mo wrote:hi there developer and thanks for the great job

i've updated your extension to VER 3.1.2 through delete and install again but it says you are using old one update to ver 3.1 ...

and more importantly im getting the same error:
export_import.php on line 3977

I'm using OC 2.2 default theme

any suggestion?
many thanks in advance

There is no version 3.1.2.

Also, it looks like you haven't installed version 3.1 correctly. Possible cause might be a wrongly configure FTP Root in your admin system settings.

i tried both files in your website and the one here
please sir see if you can help me
i'm in IRAN where there is no possibility to buy extensions at all so this free extension of yous is my last hope for the hundreds of my products

other OCmods work fine!!! I left the ftp route empty and i can see the files of extension in their correct places

any advice would be very very appreciated
thank you in advance

you may also note this section of my CONFIG.PHP file where there is an added path /STORAGE/
i've added that because of the instructions of my OC 2.2, i think due to the Persian language they added

define('DIR_CACHE', '/home/MYDOMAIN/domains/wikikharid.ir/public_html/system/storage/cache/');
define('DIR_DOWNLOAD', '/home/MYDOMAIN/domains/wikikharid.ir/public_html/system/storage/download/');
define('DIR_UPLOAD', '/home/MYDOMAIN/domains/wikikharid.ir/public_html/system/storage/upload/');
define('DIR_LOGS', '/home/MYDOMAIN/domains/wikikharid.ir/public_html/system/storage/logs/');
define('DIR_MODIFICATION', '/home/MYDOMAIN/domains/wikikharid.ir/public_html/system/storage/modification/')

Update:

after managing to fresh working install without upgrade not and correcting some errors on trailing white spaces
i get back to the error i wrote a post about

it says the following and NO ERROR LOG

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.

it exports fine, detects all types of errors in data sheet (ones i made for test) in error log
but fails to import (even unchanged file) and always the validation error with no error log

Is there any way to use links from images to upload them into the database?
Basically I have a excel file with product info and url to image, anyway for that image to be imported with this tool into my database?
Also, what about generating product_id, is that possible?

dynamok wrote:Is there any way to use links from images to upload them into the database?
Basically I have a excel file with product info and url to image, anyway for that image to be imported with this tool into my database?

I am afraid not. Normally the images would have to be uploaded separately. However, there is nothing to prevent the Export/Import Tool to have whole URLs in the image columns, and you could then use a 3rd party OpenCart extension to use these external product images on the frontend product pages. Just search the OpenCart extensions for such an external image support, I am certain there are some ~VQmod XML scripts for this.

dynamok wrote: Also, what about generating product_id, is that possible?

No, The Export/Import Tool always needs explicit primary IDs, e.g. product_id, category_id etc, depending on what you import.

Amin734mo wrote:Update:

after managing to fresh working install without upgrade not and correcting some errors on trailing white spaces
i get back to the error i wrote a post about

it says the following and NO ERROR LOG

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.

it exports fine, detects all types of errors in data sheet (ones i made for test) in error log
but fails to import (even unchanged file) and always the validation error with no error log

I am simply unable to reproduce your error, and without the exact error messages I can't help you. Send me a PM with your OpenCart and FTP login details, and I can take a quick look at it.

JNeuhoff wrote:

Amin734mo wrote:Update:

after managing to fresh working install without upgrade not and correcting some errors on trailing white spaces
i get back to the error i wrote a post about

it says the following and NO ERROR LOG

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.

it exports fine, detects all types of errors in data sheet (ones i made for test) in error log
but fails to import (even unchanged file) and always the validation error with no error log

I am simply unable to reproduce your error, and without the exact error messages I can't help you. Send me a PM with your OpenCart and FTP login details, and I can take a quick look at it.

thank you Sir
much obliged
i will send those info in minutes

JNeuhoff wrote:

Amin734mo wrote:Update:

after managing to fresh working install without upgrade not and correcting some errors on trailing white spaces
i get back to the error i wrote a post about

it says the following and NO ERROR LOG

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.

it exports fine, detects all types of errors in data sheet (ones i made for test) in error log
but fails to import (even unchanged file) and always the validation error with no error log

I am simply unable to reproduce your error, and without the exact error messages I can't help you. Send me a PM with your OpenCart and FTP login details, and I can take a quick look at it.

i've sent you those details and really appreciate your help

you are awesome JNeuhoff
thank you for your support
you fixed this
THANK YOU

extensions links are not working and the show is a no found , is it possible Another link for extensions

salwa123 wrote:extensions links are not working and the show is a no found , is it possible Another link for extensions

I don't understand your question. The download link at http://www.opencart.com/index.php?route ... sion_id=17 is working just fine.