[UPDATED] Export/Import tool for OpenCart 1.4.9

You need to specify all the product options, products, and categories in your spreadsheet. During an Import, it always first deletes all the old options, products, and categories before uploading the data from the spreadsheet.

Thanks for your reply. I have filled in the details as best I can, but maybe im missing something. I thought I had specified the product options. Here is a test xls, could you have a quick scan to see what I've missed I cant seem to find errors that could cause this not to update the product options.
The thing is .. this the original export, so I thought that the options should be right.

Im lost. Is there a user guide anywhere please?

http://www.bleujenflorist.com/flower-sh ... ucts-8.xls

I have come across the same error

The filename /tmp/phpIgz6Uy is not readable

I import the file (about 1350k) (doing this for the last few weeks more times a day because it is offline and we are testing and finetuning)
I export the file (about 1000k) (it is smaller then when imported)
I open it in excel 2007 EDIT NOTHING and save it again (as an XLS or as an 97/2003xls not XLSX as that will not function) now it is only 786k

How is this possible ?
I think it has something to do with how it was exported originally as it has shrunk about 30%
I also suspect that the server where it runs right now is slow or has hickups because sometimes it takes way to long for such a small file to import or export.

[edit]

I just tested it with another file with an older list of products
import 1843kb
export 1839kb but when opening in excel it gives the error that has unreadable contect

SoulV wrote:Thanks for your reply. I have filled in the details as best I can, but maybe im missing something. I thought I had specified the product options. Here is a test xls, could you have a quick scan to see what I've missed I cant seem to find errors that could cause this not to update the product options.
The thing is .. this the original export, so I thought that the options should be right.

Im lost. Is there a user guide anywhere please?

http://www.bleujenflorist.com/flower-sh ... ucts-8.xls

I can import your XLS file just fine. Are you sure you are using the latest Export/Import module? Get it from http://www.mhccorp.com/opencart/export-import-tool

trapson wrote:I have come across the same error

The filename /tmp/phpIgz6Uy is not readable

I import the file (about 1350k) (doing this for the last few weeks more times a day because it is offline and we are testing and finetuning)
I export the file (about 1000k) (it is smaller then when imported)
I open it in excel 2007 EDIT NOTHING and save it again (as an XLS or as an 97/2003xls not XLSX as that will not function) now it is only 786k

How is this possible ?
I think it has something to do with how it was exported originally as it has shrunk about 30%
I also suspect that the server where it runs right now is slow or has hickups because sometimes it takes way to long for such a small file to import or export.

[edit]

I just tested it with another file with an older list of products
import 1843kb
export 1839kb but when opening in excel it gives the error that has unreadable contect

Excel 2007 might use shared string constants in its XLS making it smaller. Try the latest Export/Import tool:
http://www.mhccorp.com/opencart/export-import-tool

JNeuhoff wrote: Excel 2007 might use shared string constants in its XLS making it smaller. Try the latest Export/Import tool:
http://www.mhccorp.com/opencart/export-import-tool

Can this be installed over the old version (that particular shiop with the problem has 1.4.8 where to one without a problem has the latest and has 1.4.9 of opencart)

Is there a way to make this work without the very high memory_limit setting ?
Maybe a row by row insert or so ?

Thanks for your replies.

I have uploaded the new import/export version. But it still mucks up the options.

See here: they are not showing now. (look at 'sizes') Normally this shows 3 options. They will reapewar if i go to that product and save again.

Strange!!!!


http://www.bleujenflorist.com/flower-sh ... uct_id=114

SoulV wrote:Thanks for your replies.

I have uploaded the new import/export version. But it still mucks up the options.

See here: they are not showing now. (look at 'sizes') Normally this shows 3 options. They will reapewar if i go to that product and save again.

Strange!!!!


http://www.bleujenflorist.com/flower-sh ... uct_id=114

There must be something else wrong. I am unable to reproduce the your error when importing your XLS file to my Opencart 1.4.9.3 test server. Send me a PM with your FTP and Opencart admin details, and I can take a look at it.

trapson wrote:

JNeuhoff wrote: Excel 2007 might use shared string constants in its XLS making it smaller. Try the latest Export/Import tool:
http://www.mhccorp.com/opencart/export-import-tool

Can this be installed over the old version (that particular shiop with the problem has 1.4.8 where to one without a problem has the latest and has 1.4.9 of opencart)

Is there a way to make this work without the very high memory_limit setting ?
Maybe a row by row insert or so ?

Only the Export/Import release for the latest Opencart version 1.4.9.x uses a newer PHPExcel package in which some issues, like the usage of shared string values in the XLS file, have been fixed. I won't have time at the moment to port it back to 1.4.8.

JNeuhoff wrote:

trapson wrote:

JNeuhoff wrote: Excel 2007 might use shared string constants in its XLS making it smaller. Try the latest Export/Import tool:
http://www.mhccorp.com/opencart/export-import-tool

Can this be installed over the old version (that particular shiop with the problem has 1.4.8 where to one without a problem has the latest and has 1.4.9 of opencart)

Is there a way to make this work without the very high memory_limit setting ?
Maybe a row by row insert or so ?

Only the Export/Import release for the latest Opencart version 1.4.9.x uses a newer PHPExcel package in which some issues, like the usage of shared string values in the XLS file, have been fixed. I won't have time at the moment to port it back to 1.4.8.

i updated the shop to the latest version. Also the shop is moved to another server
but i still notice slowdown because of the excel is becoming bigger and bigger. IS this because the memory limit is to low ? and is it possible to change this (or upload in pieces or so ?)

There are some obvious PHP settings in your admin/php.ini whose values could be increased, such as the memory_limit.

Dear JNeuhoff,

I am trying out your creation right now and it is the first time I am using it. I am trying to "export" an test XLS file from my opencart to see how it looks like. But I get an error message in my browser. Please see attached *.txt file.

I would appreciate a fast reply.

Best Regards!
Richard

Preiss wrote:Dear JNeuhoff,

I am trying out your creation right now and it is the first time I am using it. I am trying to "export" an test XLS file from my opencart to see how it looks like. But I get an error message in my browser. Please see attached *.txt file.

I would appreciate a fast reply.

Best Regards!
Richard

Your web host has implemented an overly restrictive security policy. You may want to comment out the offensive line in admin/model/tool/export.php and try it again.

is there no chance to import more then 1 language with this import tool?

JNeuhoff wrote:

Preiss wrote:Dear JNeuhoff,

I am trying out your creation right now and it is the first time I am using it. I am trying to "export" an test XLS file from my opencart to see how it looks like. But I get an error message in my browser. Please see attached *.txt file.

I would appreciate a fast reply.

Best Regards!
Richard

Your web host has implemented an overly restrictive security policy. You may want to comment out the offensive line in admin/model/tool/export.php and try it again.

I have tried to comment out the line and get the same error message.

Regards
Rickard

No worries, I have found out that my web host does not support "set_time_limit". Is it possible to solve this in another way?

Best Regards
Richard

Preiss wrote:No worries, I have found out that my web host does not support "set_time_limit". Is it possible to solve this in another way?

Best Regards
Richard

Yes. Don't use it. Chances are it won't be needed. Comment out the line in admin/model/export.php .

Hi JNeuhoff,

Thanks for this excellent contribution. I'm using your latest 1-4-9-x-23-export-import tool with OC 1.4.9.3. It exports ok, but import returns error:

Fatal Error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /var/www/vhosts/domain.com/httpdocs/admin/model/tool/export.php(1171): PHPExcel_Reader_Excel5->load('/tmp/phpOJGNy6') #3 /var/www/vhosts/domain.com/httpdocs/admin/controller/tool/export.php(13): ModelToolExport->upload('/tmp/phpOJGNy6') #4 [internal function]: ControllerToolExport->index() #5 /var/www/vhosts/domain.com/httpdocs/system/engine/front.php(47): call_user_func_array(Array, Array) #6 /var/www/vhosts/domain.com/httpdocs/system/engine/front.php(29): Front->execute(Object(Action)) #7 /va in /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91

gjesus wrote:Hi JNeuhoff,

Thanks for this excellent contribution. I'm using your latest 1-4-9-x-23-export-import tool with OC 1.4.9.3. It exports ok, but import returns error:

Fatal Error: Uncaught exception 'Exception' with message 'Unknown codepage: 0' in /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php:91 Stack trace: #0 /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(1042): PHPExcel_Shared_CodePage::NumberToName(0) #1 /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Reader/Excel5.php(517): PHPExcel_Reader_Excel5->_readSummaryInformation() #2 /var/www/vhosts/domain.com/httpdocs/admin/model/tool/export.php(1171): PHPExcel_Reader_Excel5->load('/tmp/phpOJGNy6') #3 /var/www/vhosts/domain.com/httpdocs/admin/controller/tool/export.php(13): ModelToolExport->upload('/tmp/phpOJGNy6') #4 [internal function]: ControllerToolExport->index() #5 /var/www/vhosts/domain.com/httpdocs/system/engine/front.php(47): call_user_func_array(Array, Array) #6 /var/www/vhosts/domain.com/httpdocs/system/engine/front.php(29): Front->execute(Object(Action)) #7 /va in /var/www/vhosts/domain.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Shared/CodePage.php on line 91

I am unable to reproduce your error, nobody ever reported such an error. Looks like you must be using some strange characters or an unusual codepage. Send me a PM with a sample XLS file which has caused your Import error so that I can take a closer look at it.

Hi JNeuhoff,
I'm using your great Import /Export tool with OC 1.3.2. I know it is an old version but I would like to discuss with you a general topic, I assume.
It is almost well known that PHPExcelReader and (maybe) PHPExcel libraries are quite memory consuming, causing some limits in handling big excel files (but not su huge actually...) with some thousands of records.
For sure, in my case, I'm experiencing issues trying to import an Excel sheet with "only" 4500 articles... It appears, I think not only to me, a real limit of the tool.

For last days I've been investigating with hosting providers about the memory limits of their hosts and they all say and agree that a script consuming more than 64MB of memory is really too much "hungry".

Now, some questions:
1) With respect to old 1.3.2 tool, did you experienced better performances using updated versions of scripts/library? Is 1.4.9 version less memory consuming?
2) Are we sure there are no ways to optimize and reduce memory usage?

thanks in advance for your really precious work,

Max