[Qgis-user] Import of Large CSV File

[b.j.kobben at utwente.nl]

simple test is also to check if the file can be imported in Excel or OpenOffice spreadsheet...


--
Barend Köbben


On 16/04/2019, 14:11, "Qgis-user on behalf of Nicolas Cadieux" <qgis-user-bounces at lists.osgeo.org<mailto:qgis-user-bounces at lists.osgeo.org> on behalf of nicolas.cadieux at archeotec.ca<mailto:nicolas.cadieux at archeotec.ca>> wrote:

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<mailto: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<mailto: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/c6054c14/attachment.html>