Hello.
I'm using Open Cart version: opencart_v1.5.4.1
and Open Import / Export version: opencart-1-5-0-x-export-import-6
I tried first exporting my products and got the following error:
Notice: Error: Table 'database_products.product_tag' doesn't exist
Error No: 1146
The database with all the products is called database_products. Any help to solve this error is appreciated.
Thank you in advance
@JNeuhoff,
Would love it if you could add a way to allow users to import / export additional fields/settings in the database.
I have installed an extension that tweaks the Out of Stock Status in OC so that for certain products I can show 1-10 days on availability and this can be selected per product. When I export and then import again using your tool it unfortunately overwrite all the settings to "In Stock".
Really love to solve it as I used your tool regularly to update my prices and it was such a time saver!
Would love it if you could add a way to allow users to import / export additional fields/settings in the database.
I have installed an extension that tweaks the Out of Stock Status in OC so that for certain products I can show 1-10 days on availability and this can be selected per product. When I export and then import again using your tool it unfortunately overwrite all the settings to "In Stock".
Really love to solve it as I used your tool regularly to update my prices and it was such a time saver!
Hello mister Neuhoff,
Would the multi lingual support solve the fact that the current export not put the english text in regards to catagories in the excel sheet?
Kind regards,
Ted
Would the multi lingual support solve the fact that the current export not put the english text in regards to catagories in the excel sheet?
Kind regards,
Ted
JNeuhoff wrote:The Export/Import tool is now available for OpenCart 1.5.4.
Still on our to-do-list for future releases (just need some time to get it all done, was quite busy lately):
- Improved validation and error/exception handler
- Multi-lingual support
- Incremental Import
Hey, I'm looking through the full history of this thread, and wondering... almost every request is about not being able to upload enough products... or taking too long, etc. This is, functionally (product and time limits notwithstanding) by far the best import/export tool out there... for people with fewer than 10,000 products.
I would like to see a CSV, non-excel version of this tool that operates about twenty times faster (it would--and you know it would) and handles an unlimited amount of products.
To head off your next question: were I capable of doing this myself, it would have already been done
I would pay over $100 (edit: far more than $100) for a tool that operates the same way as your current tool, but with speed and efficiency of CSV. There is obviously a huge need for it. What do I need to do--put a petition together
You rock, sir! Crossing my fingers over here...
I would like to see a CSV, non-excel version of this tool that operates about twenty times faster (it would--and you know it would) and handles an unlimited amount of products.
To head off your next question: were I capable of doing this myself, it would have already been done
I would pay over $100 (edit: far more than $100) for a tool that operates the same way as your current tool, but with speed and efficiency of CSV. There is obviously a huge need for it. What do I need to do--put a petition together
You rock, sir! Crossing my fingers over here...
Hello, not sure if anyone else has tried this with success or has a guide.
i have additional database entries that i want to include in the import/export. mainly on the product.
examples:
i have cost of product that i would like to add a column on the upload,
also would LOVE it to also include this (got this module and works well, however have to manually update the group prices):
http://www.opencart.com/index.php?route ... on_id=7556
any chances of being shown or advised how to do this?
many thanks
Danny
i have additional database entries that i want to include in the import/export. mainly on the product.
examples:
i have cost of product that i would like to add a column on the upload,
also would LOVE it to also include this (got this module and works well, however have to manually update the group prices):
http://www.opencart.com/index.php?route ... on_id=7556
any chances of being shown or advised how to do this?
many thanks
Danny
When I import my list of 7300 items i get the memory error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/cld/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 967
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/cld/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 967
I've even tried putting only 40 products and when i upload that i still get this Memory error???
What can I do to fix this?
UPDATE:
For some reason I am now able to import 5800 products without errors...
If I try to add more to the import list I get the Fatal error again...
Is there a way to raise the limit on this? I also have additional information to add to the spread sheet like additional images, etc. But I've managed to upload just the basic information for the products which allows me to now upload 5800 items. But I have more with more information I will need to add to the file, which will make it even bigger, which in my case as it is now, I won't be able to upload 5800 it will be less due to adding more information to the spreadsheet.
Any help would be great.
Ken
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/cld/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 967
Fatal Error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5 bytes) in /home/cld/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 967
I've even tried putting only 40 products and when i upload that i still get this Memory error???
What can I do to fix this?
UPDATE:
For some reason I am now able to import 5800 products without errors...
If I try to add more to the import list I get the Fatal error again...
Is there a way to raise the limit on this? I also have additional information to add to the spread sheet like additional images, etc. But I've managed to upload just the basic information for the products which allows me to now upload 5800 items. But I have more with more information I will need to add to the file, which will make it even bigger, which in my case as it is now, I won't be able to upload 5800 it will be less due to adding more information to the spreadsheet.
Any help would be great.
Ken
I'm having similair problems as Ken. Although i don't have nearly the same amount of products, I do have a lot of options (3000+ lines).
When importing on my localhost I keep getting some form of timeout error, I already changed the values with the Xampp control panel. But it keeps showing up in some form or way. Any ideas on how to solve this? It would be greatly appreciated!!
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
Fatal Error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
When importing on my localhost I keep getting some form of timeout error, I already changed the values with the Xampp control panel. But it keeps showing up in some form or way. Any ideas on how to solve this? It would be greatly appreciated!!
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
Fatal Error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
You'd probably need to specify a higher value in your XAMPP's admin/.htaccess file, e.g.burley wrote:I'm having similair problems as Ken. Although i don't have nearly the same amount of products, I do have a lot of options (3000+ lines).
When importing on my localhost I keep getting some form of timeout error, I already changed the values with the Xampp control panel. But it keeps showing up in some form or way. Any ideas on how to solve this? It would be greatly appreciated!!
Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
Fatal Error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\1541lf\admin\model\tool\export.php on line 1457
Code: Select all
php_value max_execution_time 300
Code: Select all
max_execution_time = 300;
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Great tool - use it all the time.
Just upgraded OC to 1.5.5.1 and Export/import tool to the latest available - 1.5.4.x
The Customer Group field on the Discounts tab is not exporting - all cells in this column are blank in the exported file.
Two questions:
(1) If I use this file to import other changes, will I lose my existing Customer Group data in Discounts by overwriting with null values?
(2) Is there an update on the way to address this?
Just upgraded OC to 1.5.5.1 and Export/import tool to the latest available - 1.5.4.x
The Customer Group field on the Discounts tab is not exporting - all cells in this column are blank in the exported file.
Two questions:
(1) If I use this file to import other changes, will I lose my existing Customer Group data in Discounts by overwriting with null values?
(2) Is there an update on the way to address this?
I am still working on an improved Export/Import tool for 1.5.5.x. Among other immediate things, it will need to incorporate the repairCategories() call, it will have an improved error handler, and the usage of ODS instead of XLS as the default format, so as to be able to support proper UTF-8. The latter is required for a future multi-lingual version.virusys wrote:Great tool - use it all the time.
Just upgraded OC to 1.5.5.1 and Export/import tool to the latest available - 1.5.4.x
The Customer Group field on the Discounts tab is not exporting - all cells in this column are blank in the exported file.
Two questions:
(1) If I use this file to import other changes, will I lose my existing Customer Group data in Discounts by overwriting with null values?
(2) Is there an update on the way to address this?
At some stage I'd also like to implement the incremental Import, and make it more extension friendly for custom fields.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi all,
I am running 1.5.4.1 and get this error while trying to import a cvs/url:
PHP Notice: Error: Table 'xxx_ocar222.oc_product_tag' doesn't exist<br />Error No: 1146<br />TRUNCATE TABLE oc_product_tag in /home/xxx/public_html/xxx.com/system/database/mysql.php on line 49
J. Neuhoff, someone else, any one any idea?
I am not so technical so hope it is not difficult to solve this issue?
Rgds,
Sabine
I am running 1.5.4.1 and get this error while trying to import a cvs/url:
PHP Notice: Error: Table 'xxx_ocar222.oc_product_tag' doesn't exist<br />Error No: 1146<br />TRUNCATE TABLE oc_product_tag in /home/xxx/public_html/xxx.com/system/database/mysql.php on line 49
J. Neuhoff, someone else, any one any idea?
I am not so technical so hope it is not difficult to solve this issue?
Rgds,
Sabine
I think you are using the wrong version of the Export/Import tool, e.g. the 1.5.3.x version on a 1.5.4.x OpenCart.sabine2909 wrote:Hi all,
I am running 1.5.4.1 and get this error while trying to import a cvs/url:
PHP Notice: Error: Table 'xxx_ocar222.oc_product_tag' doesn't exist<br />Error No: 1146<br />TRUNCATE TABLE oc_product_tag in /home/xxx/public_html/xxx.com/system/database/mysql.php on line 49
J. Neuhoff, someone else, any one any idea?
I am not so technical so hope it is not difficult to solve this issue?
Rgds,
Sabine
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 11408 bytes) in /home/content/24/10452124/html/system/library/image.php on line 34
Вот то что я получаю сейчас после работы с тулзой. Это проблемы хостера? Реально это решать как-то?
This is what I got after one-day of uploading via Export/Import. Is this my hosting (godaddy) or is it just dumb me?
is there any way of handling this issue?
Thanx
Вот то что я получаю сейчас после работы с тулзой. Это проблемы хостера? Реально это решать как-то?
This is what I got after one-day of uploading via Export/Import. Is this my hosting (godaddy) or is it just dumb me?
is there any way of handling this issue?
Thanx
From what I know this is related to your hosting company. I've had the same problem with several hosting company's.
Sometimes they are willing to allow a highe buffer, but most of the times they don't.
As a solution/work around I now have a copy of my shop running on a localhost. After importing the changes with this mod I just make an export from my Dbase with phpmyadmin and import that in the Dbase of the live shop again using phpmyadmin.
Sometimes they are willing to allow a highe buffer, but most of the times they don't.
As a solution/work around I now have a copy of my shop running on a localhost. After importing the changes with this mod I just make an export from my Dbase with phpmyadmin and import that in the Dbase of the live shop again using phpmyadmin.
So can you write a guide of how to add a custom field correctly now. As its driving me mad!JNeuhoff wrote: At some stage I'd also like to implement the incremental Import, and make it more extension friendly for custom fields.
I dont want to screw anything up so would rather have a decent explanation of how to add a field.
thnaks
Having the following problem. Importing/exporting locally goes perfect till my file hits 8000 KB. When i choose the file it selects it but when i hit the Import button then it resets and it ssays no file is choosen.
How to solve this?
How to solve this?
Hey peeps,
Having an issue when trying to import my xls file.
"Notice: Error: Table 'db440950175.OCFISHcategory_path' doesn't exist
Error No: 1146
DELETE FROM `OCFISHcategory_path` in /homepages/25/d384992159/htdocs/Hobbies-UK Shop Folders/Fishing/system/database/mysql.php on line 50"
Im using v1.5.5.1, Both of OC and the Extension.
Any help will be appricated. Thanks
Ben
Having an issue when trying to import my xls file.
"Notice: Error: Table 'db440950175.OCFISHcategory_path' doesn't exist
Error No: 1146
DELETE FROM `OCFISHcategory_path` in /homepages/25/d384992159/htdocs/Hobbies-UK Shop Folders/Fishing/system/database/mysql.php on line 50"
Im using v1.5.5.1, Both of OC and the Extension.
Any help will be appricated. Thanks
Ben
Anthony1632 wrote:Having the following problem. Importing/exporting locally goes perfect till my file hits 8000 KB. When i choose the file it selects it but when i hit the Import button then it resets and it ssays no file is choosen.
How to solve this?
Solved it! A developper build me an incremental import for this extension and it works like a charm now. It didn't took that long time and it solves a lot of hasles for memory- and file limits.
Who is online
Users browsing this forum: No registered users and 4 guests
