Post by arthur.kh » Mon Mar 09, 2015 5:23 am

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!

Newbie

Posts

Joined
Mon Mar 09, 2015 5:20 am

Post by JNeuhoff » Wed Mar 11, 2015 1:10 am

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!
It's a known issue in the PHPExcel for which I hope to get a fix done soon.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by najip » Wed Mar 11, 2015 9:06 pm

Hi!

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'.
Screenshot.png

Screenshot.png (31.39 KiB) Viewed 7612 times

So, i still can't get the Permission for This tools.
export import screenshoot.png

Permission Denied - export import screenshoot.png (18.64 KiB) Viewed 7612 times

Please Help.

Newbie

Posts

Joined
Fri Feb 20, 2015 5:25 pm
Location - Indonesia

Post by JNeuhoff » Wed Mar 11, 2015 10:59 pm

Sorry, I am unable unable to reproduce your error.

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by kinuschan » Sat Mar 21, 2015 9:12 pm

Dear JNeuhoff,

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

Newbie

Posts

Joined
Sat Mar 21, 2015 9:02 pm

Post by JNeuhoff » Wed Mar 25, 2015 12:04 am

To answer your questions:

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by StaffMotoInter » Wed Mar 25, 2015 12:28 am

hi,

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


Posts

Joined
Wed Mar 25, 2015 12:26 am

Post by zzzxxccvvv » Wed Mar 25, 2015 8:45 pm

Hello,

Is it possible that you add import/export of download links in future?

Thanks

Newbie

Posts

Joined
Fri Oct 24, 2014 12:23 am

Post by mshahzad » Sun Apr 05, 2015 1:57 am

categories added succefully but when i add products excell sheet following error
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

Newbie

Posts

Joined
Sat Apr 04, 2015 6:58 pm

Post by rohanro881 » Fri Feb 19, 2016 8:37 pm

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 .

Newbie

Posts

Joined
Fri Feb 19, 2016 8:01 pm

Post by anhsang » Tue Feb 23, 2016 9:25 am

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

Newbie

Posts

Joined
Tue Feb 23, 2016 9:23 am

Post by JNeuhoff » Wed Feb 24, 2016 2:32 am

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 .
I am unable to reproduce your error.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Wed Feb 24, 2016 2:40 am

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 .
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
The product_tag.tag field is defined as 32 characters.

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by anhsang » Thu Feb 25, 2016 4:15 pm

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 .
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
The product_tag.tag field is defined as 32 characters.

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
Hello JNeuhoff,
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

Newbie

Posts

Joined
Tue Feb 23, 2016 9:23 am

Post by info@kosmebox.com » Tue Mar 01, 2016 8:12 pm

Hi, I'm now using Opencart v.1.5.6.4 and currently using Export/Import supporting only one language. If I install your extension, will the data be crashed or the quantity displayed incorrectly? Appreciate your kind instruction.


Posts

Joined
Thu Feb 11, 2016 1:09 am

Post by Roman Shevchenko » Mon Dec 12, 2016 11:09 pm

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

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.



Posts

Joined
Mon Dec 12, 2016 10:42 pm
Location - Warsaw, Poland

Post by JNeuhoff » Thu Dec 15, 2016 12:50 am

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
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?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by dionisis84 » Thu Jan 12, 2017 1:31 am

Hello,
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!

Newbie

Posts

Joined
Thu Jan 12, 2017 1:28 am

Post by gartheman » Sat May 20, 2017 7:51 am

Hi,

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
I requested from my hosting provider to make changes to resolve the errors, but they responded:
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.
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?

New member

Posts

Joined
Tue Feb 16, 2010 5:12 pm

Post by JNeuhoff » Sun May 21, 2017 2:32 am

Perhaps this helps: viewtopic.php?f=119&t=137643

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 28 guests