How to import sizable CSV files? It may be necessary to import files of tens of thousands of lines and several MB into an ERP or into your e-commerce. The time needed in this case could be excessive and especially in online applications this can cause either a server time out or a browser block.

Forcing us to start over. In the case of PrestaShop, using PrestaXLS we can filter our CSV and resume from the last imported product, but in the case of large files this operation also becomes very difficult. Without prejudice to the use of specific modules that use ajax for import. A simple option is to split the CSV into several parts ...

In this case we can use Simple Text Splitter, a software that allows you to divide text files (CSV files are nothing more than text files) into several parts. This is an opensorce software and you can download it from here: http://sourceforge.net/projects/simpletextsplit/files/

Author: Loris Modena

SENIOR DEVELOPER

For Ind Loris Modena , owner of Arte e Informatica , he began working in the IT sector in 1989 as a system engineer in charge of the maintenance and installation of IT systems. He started programming for the web in 1997 dealing with CGI programming in PERL and then moving on to programming in PHP and JavaScript. In this period he approaches the Open source world and the management of Linux servers.

Product added to wishlist