I have a question regarding leading zeros in text fields. We have models like 0022 or 0800. These values changed to 22 or 800 after exporting. It's trouble for us to edit every model cell before import because we have hundreds of models like this.
How it may be fixed?
Thanks!
It's a known issue in the PHPExcel for which I hope to get a fix done soon.arthur.kh wrote:Hi!
I have a question regarding leading zeros in text fields. We have models like 0022 or 0800. These values changed to 22 or 800 after exporting. It's trouble for us to edit every model cell before import because we have hundreds of models like this.
How it may be fixed?
Thanks!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have try to Install this Extension version 2.21.
But I have a problem.
I have Upload the whole folders 'admin', 'system' and 'vqmod'
I have upload directory to my OpenCart main directory.
But when I check into the System > Users > User Group > Top Administrator, there are not 'tool/export_import' in the 'Access' and 'Modify'. So, i still can't get the Permission for This tools. Please Help.
Could be an file access rights issue on an unusual web host configuration, or you may have simply uploaded the files to the wrong place.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for your extension. I have some questions on it.
1. Does the extension support for multi-language in Multi-Store?
2. Does the extension support for multi SEO keyword per multi-language?
3. Does the extension support for multi Meta Keyword/Description per multi-language?
Thanks a lots.
Best regards
SK Chan
1) Yes (see column store_ids)
2) No, standard OpenCart doesn't do multi-lingual SEO keywords
3) Yes
As regards: There are 3rd party extensions for OpenCart to add support for multi-lingual SEO keyword, we can offer one as well for a charge and then add support for to the Export/Import tool.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I installed this extension today (had a different one before) and getting this message:
Note: You are using an old version of the Export/Import Tool, please upgrade to the new version 2.24!
I followed the link, downloaded the correct (same) version again, uploaded it again and I am still seeing the same message and cannot export.
I am using 1.5.6 opencart version and php 5.4
Thank you,
Lukasz
Uploaded spreadsheet file has validation errors!
See also 'System > Error Logs' for more details.
No server data has been changed.
Export/Import: Missing product_ids in worksheet 'Products
can u let me know what is the product id which i can use for products
I used opencart 1.5.3.1.
I installed the Export / Import Tool success.
when using the Export / Import Tool results product_tag table and column tag only allows 33 characters, I can change it?
table product in the database, I added 3 column opencart default than and when i using the Export / Import lost data in 3 column new. Please guide me edit code added 3 column new in source Export / Import Tool .
Please help me email: hoangsang68@gmail.com
Thanks a lot
I am unable to reproduce your error.rohanro881 wrote:Hi, I am getting undefined offset 0, while exporting products, I have increased memory to 256mb. My website runs on opencart Version 2.1.0.1, i have successfully installed your multilingual 2.0.x Export/import tool. kindly help me to solve this issue. I dont get any errors, while exporting Categories,Option definitions,Attribute definitions,Filter definitions .
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
anhsang wrote:Hello,
I used opencart 1.5.3.1.
I installed the Export / Import Tool success.
when using the Export / Import Tool results product_tag table and column tag only allows 33 characters, I can change it?
table product in the database, I added 3 column opencart default than and when i using the Export / Import lost data in 3 column new. Please guide me edit code added 3 column new in source Export / Import Tool .
The product_tag.tag field is defined as 32 characters.anhsang wrote:Hello,
I used opencart 1.5.3.1.
I installed the Export / Import Tool success.
when using the Export / Import Tool results product_tag table and column tag only allows 33 characters, I can change it?
table product in the database, I added 3 column opencart default than and when i using the Export / Import lost data in 3 column new. Please guide me edit code added 3 column new in source Export / Import Tool .
Please help me email: hoangsang68@gmail.com
Thanks a lot
As regards support for your additional products columns: You need to modify the admin/model/tool/export_import.php, in the following methods:
storeProductIntoDatabase
uploadProducts
validateProducts
getProductDescriptions
getProducts
populateProductsWorksheet
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hello JNeuhoff,JNeuhoff wrote:anhsang wrote:Hello,
I used opencart 1.5.3.1.
I installed the Export / Import Tool success.
when using the Export / Import Tool results product_tag table and column tag only allows 33 characters, I can change it?
table product in the database, I added 3 column opencart default than and when i using the Export / Import lost data in 3 column new. Please guide me edit code added 3 column new in source Export / Import Tool .The product_tag.tag field is defined as 32 characters.anhsang wrote:Hello,
I used opencart 1.5.3.1.
I installed the Export / Import Tool success.
when using the Export / Import Tool results product_tag table and column tag only allows 33 characters, I can change it?
table product in the database, I added 3 column opencart default than and when i using the Export / Import lost data in 3 column new. Please guide me edit code added 3 column new in source Export / Import Tool .
Please help me email: hoangsang68@gmail.com
Thanks a lot
As regards support for your additional products columns: You need to modify the admin/model/tool/export_import.php, in the following methods:
storeProductIntoDatabase
uploadProducts
validateProducts
getProductDescriptions
getProducts
populateProductsWorksheet
Thank you so much.
I edited success.
I edited code insert tag in product_tag ok:
$tag_sang_tach = explode(',', $tag);
$this->db->query( $sql );
foreach ($tag_sang_tach as $tag_insert) {
$sql = "INSERT INTO `".DB_PREFIX."product_tag` (`product_id`,`language_id`,`tag`) VALUES ";
$sql .= "($product_id, $language_id, '$tag_insert')";
$this->db->query($sql);
}
Please help:
Tab Export Please select the data range you want to export:By id range , By batches
I see two options are not flexible.
You can write options such as: Export by the manufacturer,Export by catalog, or " Export by select one or some product option".
Look forward to the new update.
Thank o lot
Sang
Uploaded spreadsheet file has validation errors
Opencart v.1.5.6.4
AmazingCart is an application for your Online Store. AmazingCart has deep integration with popular e-Commerce systems such as: WordPress (WooCommerce), Magento, Opencart and PrestaShop. Our app allows your clients to buy products from their mobile devices.
First of all, you should upgrade to 3.8. As regards validation errors: Have you done the obvious to look into OpenCart's error.log for more details about the validation errors?Roman Shevchenko wrote:Hi! I also have problem with this extention. I use Export/Import Tool version 2.24
Uploaded spreadsheet file has validation errors
Opencart v.1.5.6.4
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I installed this tool on OpenCart 1.5.3.1, I export the categories or the products but the resulting excel file is corrupted and cannot be opened in MS Excel. What can I do??
Thank you very much!
I am using the latest version of this mod, along with OC 1.5.4. I am getting the following errors when i try to export:
Code: Select all
2017-05-19 23:39:19 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (C:\CustomerData;D:\CustomerData;C:\PHPUploadData;C:\temp\phpupload;C:\Program Files\SWsoft\PEM\sysvhosts\elFinder) in C:\CustomerData\webspaces\webspace_00129445\wwwroot\opencart\system\PHPExcel\Classes\PHPExcel\Writer\Excel2007.php on line 190
2017-05-19 23:39:19 - PHP Warning: ZipArchive::open(): open_basedir restriction in effect. File(php://output) is not within the allowed path(s): (C:\CustomerData;D:\CustomerData;C:\PHPUploadData;C:\temp\phpupload;C:\Program Files\SWsoft\PEM\sysvhosts\elFinder) in C:\CustomerData\webspaces\webspace_00129445\wwwroot\opencart\system\PHPExcel\Classes\PHPExcel\Writer\Excel2007.php on line 232
2017-05-19 23:39:19 - PHP Warning: ZipArchive::open(): open_basedir restriction in effect. File(php://output) is not within the allowed path(s): (C:\CustomerData;D:\CustomerData;C:\PHPUploadData;C:\temp\phpupload;C:\Program Files\SWsoft\PEM\sysvhosts\elFinder) in C:\CustomerData\webspaces\webspace_00129445\wwwroot\opencart\system\PHPExcel\Classes\PHPExcel\Writer\Excel2007.php on line 233
2017-05-19 23:39:19 - PHP PHPExcel_Writer_Exception: Could not open php://output for writing. in C:\CustomerData\webspaces\webspace_00129445\wwwroot\opencart\system\PHPExcel\Classes\PHPExcel\Writer\Excel2007.php on line 234
My question is, where do i create this 'temp' folder, and do I have to edit the mod or any opencart files also to implement the fix they have suggested?The open_basedir restriction on shared hosting is in place for security reasons and cannot be lifted. It looks like part of the issue here is that the domain is trying to access content in locations outside the httpdocs folder. It looks like it's trying to use the server owned temp folder to write to.
I advise creating a temp folder inside the root folder for the domain or the httpdocs folder and call it from there instead. Once it's using a temp folder that exists inside your file structure it should be able to function.
Also, you should use a proper Linux host, not a cheap shared Windows system.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 7 guests