Prestashop 1.6.1.7 import csv half work

[Phoenix ashes]

Hello

sorry for bad english !

 

first i installed prestashop 1.6.1.7

install was ok no error

 

i have a CSV files that inclued 119 lines from my differents manufacturers

The CSV is well formated and work fine.

only the 10 or 12 first line import the pictures

i have an advert in report that says 99, or 102 or 87 pictures can not be loaded.

 

1 import asking to delete previous entry : 119 manufacturer (id, name, description.....) ok

all info are imported but only the 12 first pictures of the list.

 

2 import :asking to delete previous entry :119 manufacturer (id, name, description.....) ok

all info are imported but only the 10 first pictures of the list.

 

3 import : asking to force ID: 119 manufacturer (id, name, description.....) ok

all info are imported but only the 15 first pictures of the list.

 

4 import asking to force ID and asking to leave out the 10 first line of the CSV

result : picture 20 to 30 ok but picture 31 to 119 can not load

 

5 import asking to force ID and asking to leave out the 20 first line of the CSV

result : picture 30 to 40 ok but picture 41 to 119 can not load

 

i have to do that 10 times to have all the picture loaded. It is possible to do it with this small list (119) but i have

6800 products with average 5 pictures to update and dont wanna do import 680 times to have all off them.

 

So like i say CSV is well formated and never give me such problem

all the picture are loaded( after 10 try)  so there is no problem with permission

before update 1.6.1.7 yesterday from older version 1.6.1.4 i never have errors in csv import

The only thing i have changed is the ID on manufacturer list

i tried to change the PHP max_execution_time but nothing changes

 

I need help please ( but please please please dont ask about file permission, format of the csv, or if i push the power button on ) 

 

No error log in PHP console.

 

[Phoenix ashes]

bouhhh somebody have a rope ?

[Phoenix ashes]

ok no one have same bug ?

[rocky]

I guess not if no-one is replying. Is there anything unusual about the images that aren't working? Are they in a different format? Are they larger than the other images that are working?

[Phoenix ashes]

nope, they are working fine if i try more times or begin csv files at an other line for exemple beginning at line 2 give me 10 or 12 pictures, beginning at line 12 give me the next 10 or 12 pictures so they are loading well but no all 119 in one time.

[rocky]

You can try increasing your max_execution_time in your php.ini file. Unfortunately, I don't have any other ideas.

[Phoenix ashes]

yep i allways try it and memory too but nothing change,

i pushed

max_execution_time     from 300 to1500
max_input_time  from 300 to 1500

 

the server response is fast.and the result page on prestashop csv import is quick

i can press 10 time F5 to refresh the page and i will have 10 time a different number of picture loaded or not loaded

 

here you can see my PHP 5.5 config

allow_url_fopen     On
display_errors     On
error_reporting     E_USER_WARNING | E_ERROR | E_WARNING | E_PARSE | E_STRICT | E_COMPILE_WARNING | E_USER_ERROR | E_CORE_ERROR | E_CORE_WARNING | E_RECOVERABLE_ERROR | E_USER_NOTICE | E_COMPILE_ERROR | E_USER_DEPRECATED
file_uploads     On
include_path     .:/usr/lib/php:/usr/local/lib/php
log_errors     On
mail.force_extra_parameters     no value
max_execution_time     1500
max_input_time     1500
memory_limit     512M
open_basedir     no value
post_max_size     512M
session.save_path     /tmp
short_open_tag     On
upload_max_filesize     512M

[rocky]

Did you try asking for your host? It makes no sense for the CSV import to finish, but some of the images to not be imported.

[Phoenix ashes]

Yep no error on his side,
no problem with cpu, disk, memory
No error log, no php error log

 

                                     used           max                   fault
CPU                              0.4%           100%                 0
E./S.                              7.0 KB/s     18000.0 KB/s     0
IOPS                              0                 1024                 0
Proces launched            0                 50                    0
Nb de proces                  0                 100                  0
Use physical memory      59.43M         15.62G          0
Use virtual memory         14.45M         15.62G          0

Edited October 1, 2016 by Phoenix ashes (see edit history)

[system_error86]

Hello guys,

has anyone use the import to upload more than 6000 products?? Is anyone who use cron job to do that? How much time do the server to upload the csv file??? I would like to import every 5 till 10 minutes 6000 products. Has anyone any advice how can I do that?? I have a module for import it takes too long to upload the csv.

Thanks