_x000D_
Anyone with this error..
I don't know if this is the correct way to fix this but here's what I did:
find all: "_x000D_"
replace all with: "<br>"
save as xls
Fixed..
Anyone with this error..
I don't know if this is the correct way to fix this but here's what I did:
find all: "_x000D_"
replace all with: "<br>"
save as xls
Fixed..
I have just installed this wonderful tool on my opencart version 1.5.5.1 but unfortunately get this error when I try to download.
Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/share/pear:/usr/share/php') in /home1/mywebsite/public_html/admin/model/tool/export.php on line 2469
Not sure how to proceed, any help out there ?
EDIT !
Oooops silly me !
I forgot to put the system files in the PHPExcel folder, that was the problem.
Happily downloading now !
Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/share/pear:/usr/share/php') in /home1/mywebsite/public_html/admin/model/tool/export.php on line 2469
Not sure how to proceed, any help out there ?
EDIT !
Oooops silly me !
I forgot to put the system files in the PHPExcel folder, that was the problem.
Happily downloading now !
Yes, you can. But bear in mind that formats of the worksheets are different between 1.5.6 and 1.4.9 versions of the Export/Import tool, so you'd have to copy and paste the old spreadsheet columns to the corresponding new ones first before Import.knight_47 wrote:Can I use this to export products from 1.4.9 and then reimport them into a 1.5.6 OpenCart installation?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi I'm new to OpenCart so don't be mean
Just started using this very useful tool and it has worked fine the first few times. Only now when i try to export the Spreadsheet, i receive an internal server error (500), and the opencart error log is blank. Do you know how i can fix this?
Thanks
Just started using this very useful tool and it has worked fine the first few times. Only now when i try to export the Spreadsheet, i receive an internal server error (500), and the opencart error log is blank. Do you know how i can fix this?
Thanks
Welcome to OpenCart! To answer your question, first thing to do is to inspect the server's error_log (ask webhost for it), and OpenCart's system/logs/error.txt. It could be a timeout issue, but this is just a guess without seeing the log entries.TobyTheFox wrote:Hi I'm new to OpenCart so don't be mean
Just started using this very useful tool and it has worked fine the first few times. Only now when i try to export the Spreadsheet, i receive an internal server error (500), and the opencart error log is blank. Do you know how i can fix this?
Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Installed Export/Import tool today (opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-9.zip). when trying to export I get the error:
When I have changed the settings an click "Update Settings" nothing happens. The changes will not be saved.
Code: Select all
Option value 'svart --> L' is defined multiple times within its option!
In the Settings-tab please activate the following:
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
Sorry, wrote this at the wrong place..... I did not see the OC version 1.4.9thbr02 wrote:Installed Export/Import tool today (opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-9.zip). when trying to export I get the error:When I have changed the settings an click "Update Settings" nothing happens. The changes will not be saved.Code: Select all
Option value 'svart --> L' is defined multiple times within its option! In the Settings-tab please activate the following: Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
I am unable to reproduce your problem. If you send me a PM with your OpenCart and FTP login details I am happy to take a look at it.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
This doesn't help for version 2.26. I asked couple times the developer through their website where to insert that line in the code, but with no answer.JNeuhoff wrote:In file admin/model/tool/export.php, in function
populateProductsWorksheet, after the line containing
$storeIds = $this->getStoreIdsForProducts( $database );
add this:
$database->query( "SET SQL_BIG_SELECTS=1" );
Can anybody help? I have opencart 1.5.6.4, the tool worked initially, when there was less than 500 products, Now I have 800 and the error appeared.
We are attempting to migrate our data from OC 1.4.9. to 3.0.3.2. I need the Import Export tool but I cannot find the link to the version for 1.4.9.x anywhere. Does anyone have an archival version? Unfortunately archive.org was less than helpful (only had 1.3.x and below), and the extension isn't available for versions prior to 1.5 on the marketplace.
Hello, I have updated the extension import/export tool with the steps you indicate on the website https://www.mhccorp.com/export-import-4 only after the update it continues to indicate : Note: You are using an old version of the Export/Import Tool, please upgrade to the new version 4.13! the website runs on Opencart 3.0.3.2
do you have an idea where it goes wrong?
do you have an idea where it goes wrong?
Please read the docs at https://www.opencart.com/index.php?rout ... sion_id=17 :kootenkinkel wrote: ↑Tue Apr 11, 2023 7:28 pmHello, I have updated the extension import/export tool with the steps you indicate on the website https://www.mhccorp.com/export-import-4 only after the update it continues to indicate : Note: You are using an old version of the Export/Import Tool, please upgrade to the new version 4.13! the website runs on Opencart 3.0.3.2
do you have an idea where it goes wrong?
Requirements and Limitations
Use version 4.13 of the Export/Import tool for systems with PHP Version 7.3 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 74 guests