Error importing CSV categories file

[lixotuka]

Hi,

I'm trying to import a CSV with categories that imports without errors in Prestashop 1.6.0.13, but I get the following Error message in TB 1.0.3:

Errors occurred: Technical error: Unexpected response returned by server. Import stopped.

[lixotuka]

How can I know if it's 100% compatible?

The import works fine in PS 1.6.0.13

[lixotuka]

Hi mdekker,

I have checked and it's fully compatible. Also Prestashop 1.6 & 1.7 work perfectly and import without errors.

Any idea?

[lixotuka]

It is a normal CSV with categories. I've been using it for a long time on Prestashop.

Can I send it to your email for you to review?

[lixotuka]

Email sent. Thanks!!

[lixotuka]

Thank you mdekker! I didn't need to import twice. I imported with FORCE ID and it worked well (no problems with images and parent categories). So FORCE ID was the problem.

The whole CSV is imported but I get this error: Some errors were detected. Please check the details: The confirmation email couldn't be sent, but the import is successful. Yay!

Thank you again!!

[lixotuka]

@mdekker said in Error importing CSV categories file:

your server is unable to connect to the outside world and the CSV contains external images that need to be downloaded

I think that the images are on my server

[Occam]

Anyway, you should see to the import controller, @mdekker. A developer named gabdara posted a commit on Github last Friday. This fixes a bug in all PrestaShop 1.6 and 1.7 and thirty bees releases, which came along with a totally rewritten AdminImportController.php since 1.6.
It occurs when trying a product csv import without option force ids, but with an id column in the csv file. Check the function categoryImportOne. You will find here the same bug for categories. Without fix!

[lixotuka]

Anyone know how to solve this confirmation email error?

Some errors were detected. Please check the details: The confirmation email couldn’t be sent, but the import is successful. Yay!

[Traumflug]

@Occam

A developer named gabdara posted a commit on Github last Friday.

Thanks. I just applied this patch to 30bz and pushed it to a new branch import. Totally untested, it might even contain syntax errors.

For your convenience and if you don't run off a Git clone, here's the patched file (replace the one in controllers/admin/):

01503312519447AdminImportController.php

Let us know how it works :-)

[alwayspaws]

@lixotuka said in Error importing CSV categories file:

Anyone know how to solve this confirmation email error?

Some errors were detected. Please check the details: The confirmation email couldn’t be sent, but the import is successful. Yay!

I just unselect the confirmation email because the resulting display on the screen shows if the import was successful. If you see "errors were detected" just scroll down the screen inside the results. Usually, it reports a missing image.

[lixotuka]

The import is done correctly. I know that I can unselect "Send notification email". However, I would like to know how to solve that to get the email.

[alwayspaws]

We all want to know this, but it's a minor issue compared to other features we're updating and adding, etc. BTW, if that's your only issue, come and help me add 10,000 more items to my site!

[lixotuka]

@alwayspaws said in Error importing CSV categories file:

We all want to know this, but it's a minor issue compared to other features we're updating and adding, etc. BTW, if that's your only issue, come and help me add 10,000 more items to my site!

Solving an issue, however small, helps to improve TB.