[Qgis-user] Import of Large CSV File

[Nicolas Cadieux]

Hi,

If Even’s solution does not work, the file is probably problematic. You probably have missing or corrupted line.  I have seen crashes were comma separated lines are mixed with space separated lines, or with files or different row length. Did the file work in the past?

Solution would would be to look at each line and count the field with a python script.  I  could help if the file is really important.  If it was downloaded, try downloading the file again.  What are the symptoms? Crashes?  Can’t see all the line?  These are points I imagine?

Nicolas


> Le 16 avr. 2019 à 04:06, Grant Boxer <boxerg at iinet.net.au> a écrit :
> 
> I have a 2.5 GB csv file which contains 9 fields and 17,167,595 records. QGIS does not seem to be able to import this using the “Delimited Text” option. Any suggestions?
>  
> Regards Grant
>  
> Grant Boxer
> Perth, Western Australia
>  
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190416/e60b3a52/attachment.html>