Neezio 14 years ago
If you have options or attributes/groups that are not being used by any products at the time you export, this module will delete those options when you import again. There also seems to be an issue with it resetting the sort order for options each time you import back to the system.
badboybackagain 14 years ago
Hi, I am using 1.5.1.3 and have followed the steps as mentioned for the installation. However, I am not able to see the tool/export in user groups permissions...please help...i need this mod
RemarkLima 14 years ago
Superb tool, great work and many thanks for publishing :)
jameswintonellis 14 years ago
Hello and thanks for such a great application. I am using the Advanced Reports + Profit Reporting for OC v1.5.x tool and with this tool it adds a new field called 'cost' to table `product` and table `order_product`. I would like for this field to come down in the export so it can be maintained and then imported. Could you please help me complete this task or at least point me in the right direction?
loukiad 14 years ago
Does anyone has any idea about the problem??
as i mentioned...
i get the following error message when I select import/export:
error during loading:
"http://www.psistis.gr/admin/index.php?route=tool/export&token=563e1adda2c9ab6c725b7bafc8c95c36"
I really want to work with this tool and I don'n know what I've done wrong!!!!!!!!!
gotschai 14 years ago
Hi JNeuhoff,
a great module you made, thank you.
I have done a few changes since I have some extra columns in my tables. Using version 1.4.9.3.
I just have an issue with the cell size limit, as I have many related products, practically they are more than 255 characters long when written in a cell. Also descriptions are more then 255 chars long.
When importing, everything fine, accepts longer cells fine, but when exporting, the cells are truncated to 255chars, so I cannot add data to the table and import back.
Is there a simple way to set not to truncate the data in cells?
Thank you for your answer
loukiad 14 years ago
dear shahram,
thanks a lot for the help. I think I made all the changes now...
I can see now the import/export selection under "system", but when I select it I get the following message:
"http://www.psistis.gr/admin/index.php?route=tool/export&token=563e1adda2c9ab6c725b7bafc8c95c36"
gregor 14 years ago
Pozdravljni,
excellent case for those searching for that:) I'm expecting something else ... but how could export added to the data is what was sold?
In the category of products would be the "click" display all orders for the product ...
and in this ...
<?php echo "<?㼼浸敶獲潩㵮ㄢ〮•湥潣楤杮∽呕ⵆ∸㸿?".">"; ?>'
This was "implanted" in the header of your document!
shahram 14 years ago
Hello Loukiad i think you are stuck at this point
( In file admin/language/english/common find:
$_['text_backup'] = 'Backup / Restore';
Add the folling after the found line:
$_['text_export'] = 'Export / Import'; )
you need to search for " $_['text_backup'] " because there is a lot space between
$_['text_backup'] = 'Backup / Restore';
shahram 14 years ago
Hi there is anyway i can change the import primary key from products id to products model? any help would be appreciated Thank You
loukiad 14 years ago
hello,
I need your help. I've just uploaded the files but I have one problem. At the 3 header files I cannot find the lines you are mentioning in your readme file.
Any suggestions???
Petrache Nicolae 14 years ago
hello. how can i set another separator? i use , in adress of pictures and after the first comma the adress is broken.
for instance it brakes it to data/produse/Tastaturi/Tastatura buna/Tastatura IBM ThinkPad T20,
T21,
T22,
T23,
ID NO. 872639/1.jpg
instead of
data/produse/Tastaturi/Tastatura buna/Tastatura IBM ThinkPad T20, T21,T22, T23, ID NO. 872639/1.jpg thanks
fealldagal 14 years ago
JNeuhoff,
Can you please help with the error below please thank you
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
aals 14 years ago
made my job so much easier. thanks :)
hoyle.a 14 years ago
Can you point me in the right direction? I want to add a couple columns to the import / export tool. I can start hackin away... but would prefer to get some form of advice from you beforehand. Just need to add a could fields in product_option_description etc.... Thanks....
mosesg 14 years ago
Fatal error: Out of memory (allocated 80478208) (tried to allocate 58 bytes) in /home/nels11/public_html/secure/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Fatal Error: Out of memory (allocated 80478208) (tried to allocate 58 bytes) in /home/nels11/public_html/secure/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
since updating open card and then updating the import/export tool I have these issues. I have 64mballocated to this since on dedicated hosting can be allowed this however It still seems to continue to have these errors
moretti 14 years ago
Thank you for completing the module and to say that if you use different language copy:
admin \ language \ your language \ tool \ export.php
Translate into your language ..
embrace all
protector 14 years ago
Hi all!
I got this error, when I exporting:
Error: Incorrect key file for table '/tmp/#sql_7e19_1.MYI'; try to repair it<br />Error No: 126<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status.....
I tried to look for the solution some days on google, with no result!
Maybe you can help me what can be the problem...
AnimatedKidzNZ 14 years ago
Hi there, I am complete novice at this stuff but have installed other extensions with no problems.
I am using opencart 1.5.1.3 and download and installed opencart-1-5-1-x-export-import-3.zip
I followed all the instructions in the readme text file.
Now when I try to export my products I open the xls sheet all I get in it is:
<b>Fatal error</b>: Call to undefined function iconv() in <b>/var/www/html/shop/system/pear/Spreadsheet/Excel/Writer/Worksheet.php</b> on line <b>1566</b><br />
<b>Fatal Error</b>: Call to undefined function iconv() in <b>/var/www/html/shop/system/pear/Spreadsheet/Excel/Writer/Worksheet.php</b> on line <b>1566</b>
I put in some 'dummy' products so it would have something to download but this didn't help.
I need to import all my products from my old website but can't :(
Any help on what I have done wrong would be great!
Thanks,
Asha, Director @ kidsclubhouse
