Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: problem with import items  (Read 6993 times)

Offline flyn

  • Full Member
  • ***
  • Posts: 142
  • Karma: +8/-0
    • View Profile
problem with import items
« on: June 30, 2014, 08:32:42 AM »
I am using AbanteCart 1.1.9 on a new site. I have setup the database, admin and demo store. Everything is working.

I went ahead and exported to a .csv (comma delimited) the products from the demo store, manipulated the file by changing the values in the appropriate columns with the ones from the products I need to import and saved it.

When I go to import it says Data is empty or corrupted.
Total loaded: 0

I did put in test mode to play it safe

I also have it imported as the same format (comma delimited .csv). For our mobile site I had to import products and it worked

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: problem with import items
« Reply #1 on: June 30, 2014, 11:00:22 AM »
This issue was reported before. It happens only on some Windows OS.
We are sill trying to find the source of the problem.

What OS and version do you use?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline flyn

  • Full Member
  • ***
  • Posts: 142
  • Karma: +8/-0
    • View Profile
Re: problem with import items
« Reply #2 on: June 30, 2014, 11:24:46 AM »
I use Windows 7 Pro Sp-1 64-bit.

AbanteCart is 1.1.9

Offline flyn

  • Full Member
  • ***
  • Posts: 142
  • Karma: +8/-0
    • View Profile
Re: problem with import items
« Reply #3 on: June 30, 2014, 05:59:22 PM »
I am writing this for those that still have this problem. My issue is resolved. I used Firefox as my main browser and I could not import but a few minutes ago I decided to try IE and it worked. So if one browser is giving you a problem try another just in case.

I have IE 11 for Windows 7

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: problem with import items
« Reply #4 on: June 30, 2014, 09:12:18 PM »
Interesting point. Thank you for sharing.
We still want to resolve this. Update is coming.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: problem with import items
« Reply #5 on: July 02, 2014, 09:31:09 AM »
This problem was identified, fixed and tested.

Issue: Some browsers in Windows send files with unknown file format or stream.

Solution is below:
In file public_html/admin/controller/pages/tool/import_export.php
Locate line:
Code: [Select]
if ( in_array($file['type'], array('text/csv','application/vnd.ms-excel','text/plain')) ) {Replace with:
Code: [Select]
if ( in_array($file['type'], array('text/csv','application/vnd.ms-excel','text/plain','application/octet-stream')) ) {
Git:
https://github.com/abantecart/abantecart-src/commit/a12c6e9bdb92e418a81c52a65454c51d2daf012f
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline natdroid

  • Full Member
  • ***
  • Posts: 113
  • Karma: +36/-3
    • View Profile
Re: problem with import items
« Reply #6 on: July 02, 2014, 10:14:04 AM »
more reason to use Linux instead of Windows

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: problem with import items
« Reply #7 on: July 02, 2014, 12:39:08 PM »
more reason to use Linux instead of Windows
Totally agree. Mac OS is good as well.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

 

Powered by SMFPacks Social Login Mod