Bulk Import from XLSX

[benpireuk]

Hi Sergey,

Before 2.6 i was able to do a bulk import of 20 rows ~5000 lines of data per day from XLSX to keep the system updated with our clients.
Since 2.6 this is timing out even when only uploading 1000 lines. The server i am using hasnt changed since 2.6.

Please help

Ben

[support]

Usually it can be session issue.
Open config/server.php file and find next line

Code: Select all

define('STORE_SESSIONS', 'mysql'); 

remove mysql so it will looks like this

Code: Select all

define('STORE_SESSIONS', ''); 

[benpireuk]

Thanks Sergey,

Unfortunately this did not work. Is there anything else i can try? This is pretty critical for me, is there a way i can return to 2.5 if there isnt a fix? or perhaps another way i can get the data in to update?
thank you

[support]

I did not change code to work with XLSX so I have no idea why you have this issue. You can return to 2.5

In 2.7 lib to work with XLSX will be replace to new one (because current is out of date)

[benpireuk]

Thank you. The only thing i can see changed is the multi level import option available now.

looking forward to 2.7 and hopefully will get me back on track

Will i need to change database to go back to 2.5?

Thank you

[support]

I think you can use 2.6 database.

Yes, multi level import was added but if you did not use it works as previously.

Also multi level import increase server load (if you use it), because each row we have to check several times.

Also check php error log, probably you can find some info there.