Hi JNeuhoff,
I got an error while trying to export out my product:
Unable to access External Workbook
What can I do?
Opencart version 1.5.5.1
Thanks!
Provide some more details, such as:groovygiraffe wrote: What can I do?
- other extensions installed
- log entries from server's error_log
- log entries from OpenCart's system/logs/error.txt
- exact copy of the error message you got
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
Details as followed:
- Other extensions: advcustomerreport, omfmobile, pagecache, outofstock disable button, emailtemplate
-No log entries from server's error_log
-Log Entry from Opencart's system: 2013-07-16 4:06:29 - PHP PHPExcel_Exception: Attributes!E2439 -> Unable to access External Workbook in /home/thegroov/public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 307
-Exact copy of error message from Opencart: Attributes!E2439 -> Unable to access External Workbook
See also 'System > Error Logs' for more details.
Actually I was able to export the file out about 6 hours before I got the error.
Appreciate your help!
Thank you so much!
Details as followed:
- Other extensions: advcustomerreport, omfmobile, pagecache, outofstock disable button, emailtemplate
-No log entries from server's error_log
-Log Entry from Opencart's system: 2013-07-16 4:06:29 - PHP PHPExcel_Exception: Attributes!E2439 -> Unable to access External Workbook in /home/thegroov/public_html/system/PHPExcel/Classes/PHPExcel/Cell.php on line 307
-Exact copy of error message from Opencart: Attributes!E2439 -> Unable to access External Workbook
See also 'System > Error Logs' for more details.
Actually I was able to export the file out about 6 hours before I got the error.
Appreciate your help!
Thank you so much!
No idea, never seen this error before. Were you trying to do an Import to OpenCart from your spreadsheet, or an Export from Open~Cart to your spreadsheet?groovygiraffe wrote: -Exact copy of error message from Opencart: Attributes!E2439 -> Unable to access External Workbook
See also 'System > Error Logs' for more details.
Actually I was able to export the file out about 6 hours before I got the error.
Appreciate your help!
Thank you so much!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
The error came when I was trying to export from Opencart. There is no error when I import to Opencart.
Will it be worth the while for you to take a look at my files?
Or, can you let me know how to uninstall this extension? (You think a fresh install will help?)
Please help.. I'm a layman and very stressed over it!
Thank you so much!
The error came when I was trying to export from Opencart. There is no error when I import to Opencart.
Will it be worth the while for you to take a look at my files?
Or, can you let me know how to uninstall this extension? (You think a fresh install will help?)
Please help.. I'm a layman and very stressed over it!
Thank you so much!
Hi,
Thank you for your extension. I find it very useful adding/updating my hundreds of products on my 1.5.5.1 opencart.
Some initial issues and error messages were there, but I solved them all. Now I use this extension exclusively for updating and backup (I used phpmyadmin previously for backup).
One thing I find lacking is the filters. They are not exported/imported. I have to do all the filters manually. Is there any way I can export/import filters too?
Thank you
Thank you for your extension. I find it very useful adding/updating my hundreds of products on my 1.5.5.1 opencart.
Some initial issues and error messages were there, but I solved them all. Now I use this extension exclusively for updating and backup (I used phpmyadmin previously for backup).
One thing I find lacking is the filters. They are not exported/imported. I have to do all the filters manually. Is there any way I can export/import filters too?
Thank you
This looks more like the spreadsheet software issue on the computer.JNeuhoff wrote:No idea, never seen this error before. Were you trying to do an Import to OpenCart from your spreadsheet, or an Export from Open~Cart to your spreadsheet?groovygiraffe wrote: -Exact copy of error message from Opencart: Attributes!E2439 -> Unable to access External Workbook
See also 'System > Error Logs' for more details.
Actually I was able to export the file out about 6 hours before I got the error.
Appreciate your help!
Thank you so much!
i have this problem
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/lelo4me/public_html/system/PHPExcel/Classes/PHPExcel/Shared/OLERead.php on line 314
this is line 314
return ord($data[$pos]) | (ord($data[$pos + 1]) <<
| (ord($data[$pos + 2]) << 16) | $_ord_24;
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/lelo4me/public_html/system/PHPExcel/Classes/PHPExcel/Shared/OLERead.php on line 314
this is line 314
return ord($data[$pos]) | (ord($data[$pos + 1]) <<
| (ord($data[$pos + 2]) << 16) | $_ord_24;Increase your PHP setting memoy_limit which at the moment is only 64M.pennywilerra wrote:i have this problem
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/lelo4me/public_html/system/PHPExcel/Classes/PHPExcel/Shared/OLERead.php on line 314
this is line 314
return ord($data[$pos]) | (ord($data[$pos + 1]) <<
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
waar kan ik dat veranderen?JNeuhoff wrote:Increase your PHP setting memoy_limit which at the moment is only 64M.pennywilerra wrote:i have this problem
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/lelo4me/public_html/system/PHPExcel/Classes/PHPExcel/Shared/OLERead.php on line 314
this is line 314
return ord($data[$pos]) | (ord($data[$pos + 1]) <<
In your admin/php.ini file, e.g.pennywilerra wrote:waar kan ik dat veranderen?JNeuhoff wrote:Increase your PHP setting memoy_limit which at the moment is only 64M.pennywilerra wrote:i have this problem
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/lelo4me/public_html/system/PHPExcel/Classes/PHPExcel/Shared/OLERead.php on line 314
this is line 314
return ord($data[$pos]) | (ord($data[$pos + 1]) <<
Code: Select all
memory_limit = 128M;
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I was wondering if you are able to create a multilanguage option for the import/export.
I can buy a new module, but it doesn;t work as perfectly as yours.
Rather pay you extra for some custom work then buy something i'm totally unfamiliar with.
I can buy a new module, but it doesn;t work as perfectly as yours.
Rather pay you extra for some custom work then buy something i'm totally unfamiliar with.
Hi,
using oc 1.5.5.1 getting import error (export working fine) checked the logs found this error below
Export/Import: Invalid header in the Categories worksheet
Have tried online tool to convert the xlxs file again still have the problem, how can this be fixed?
Thanks
madmonkeyau
using oc 1.5.5.1 getting import error (export working fine) checked the logs found this error below
Export/Import: Invalid header in the Categories worksheet
Have tried online tool to convert the xlxs file again still have the problem, how can this be fixed?
Thanks
madmonkeyau
Do an Export first, and then don't change the heading row in the 'Categories' worksheet.madmonkeyau wrote:Hi,
using oc 1.5.5.1 getting import error (export working fine) checked the logs found this error below
Export/Import: Invalid header in the Categories worksheet
Have tried online tool to convert the xlxs file again still have the problem, how can this be fixed?
Thanks
madmonkeyau
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I will second that.burley wrote:I was wondering if you are able to create a multilanguage option for the import/export.
I can buy a new module, but it doesn;t work as perfectly as yours.
Rather pay you extra for some custom work then buy something i'm totally unfamiliar with.
There has been an import/export multilanguage module based on your extension JNeuhoff, but it probably only supports 1.5.1.3 so I couldn't get it to work properly (I'm using 1.5.4
A multilanguage option would be great!
Thanks for the reply, all that was being edited was the weights of product adding weight and if g or kgJNeuhoff wrote:Do an Export first, and then don't change the heading row in the 'Categories' worksheet.madmonkeyau wrote:Hi,
using oc 1.5.5.1 getting import error (export working fine) checked the logs found this error below
Export/Import: Invalid header in the Categories worksheet
Have tried online tool to convert the xlxs file again still have the problem, how can this be fixed?
Thanks
madmonkeyau
also tried to remove some options for products that will not delete unless edit products manually there is about 20
No headings or anything changed
Have tried again using Open Office 4, and Excel still same problem.
I can export and import the downloaded file but as soon as edited it looks causes the problem what am I doing wrong when saving, only content is edited by added weight values no categories edited
I can export and import the downloaded file but as soon as edited it looks causes the problem what am I doing wrong when saving, only content is edited by added weight values no categories edited
Hi Juergen, no response from you jet on this. Please let me know what you're opinion is on this.ArtbyArjan wrote:I will second that.burley wrote:I was wondering if you are able to create a multilanguage option for the import/export.
I can buy a new module, but it doesn;t work as perfectly as yours.
Rather pay you extra for some custom work then buy something i'm totally unfamiliar with.
There has been an import/export multilanguage module based on your extension JNeuhoff, but it probably only supports 1.5.1.3 so I couldn't get it to work properly (I'm using 1.5.4
A multilanguage option would be great!
I do indeed have 1541 and the extension which is available for 1513 indeed does not work on this version.
Who is online
Users browsing this forum: No registered users and 15 guests
