[Qgis-user] Delimited text issue

[Taimur al said]

Hi,

I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2.

Currently im trying to upload an excel sheet converted to (CSV format) on Qgis, this sheet has over 100 rows but only 20 rows are shown and then after adding these rows to the canvas only 20 points show. I have tried with other excel sheets (CSV) i have tried and worked with in the past with the older version and still only 20 rows show.


May i ask if im doing anything wrong / is there a new way to do it?

Hope to hear from you soon.

Regards,

Taimur Al Said
Wildlife Biologist

[Andreas Neumann]

Hi,

You seem to have an issue in your data around row 20. Probably not
enough delimeters, or an unescaped character within an attribute that
makes QGIS believe that parts of the data belongs to a different,
potentially incompatible, attribute.

Please check your data against mistakes. If you can't find it out
yourself, upload it somewhere to share it and we can have a look.
Without having access to your data and the setting you used (e.g. a
screenshot of your settings), it is impossible to help.

Another potential trouble could be that you have chosen more than one
delimiter and QGIS chokes on that because that other delimiter is part
of your data in a certain attribute.

Andreas

Post by Taimur al said
Hi,
I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2.
Currently im trying to upload an excel sheet converted to (CSV format) on Qgis, this sheet has over 100 rows but only 20 rows are shown and then after adding these rows to the canvas only 20 points show. I have tried with other excel sheets (CSV) i have tried and worked with in the past with the older version and still only 20 rows show.
May i ask if im doing anything wrong / is there a new way to do it?
Hope to hear from you soon.
Regards,
Taimur Al Said
Wildlife Biologist
_______________________________________________
Qgis-user mailing list
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Nicolas Cadieux]

Hi,
Yes that seems to be the problem. Excel has a tendency to add empty delimiters in rows that have been erased. One way of dealing with that is to cut and paste to data you want in a new spreadsheet and then to export that to csv. I don’t think libreoffice has that problem.
Nicolas

Hi,
You seem to have an issue in your data around row 20. Probably not enough delimeters, or an unescaped character within an attribute that makes QGIS believe that parts of the data belongs to a different, potentially incompatible, attribute.
Please check your data against mistakes. If you can't find it out yourself, upload it somewhere to share it and we can have a look. Without having access to your data and the setting you used (e.g. a screenshot of your settings), it is impossible to help.
Another potential trouble could be that you have chosen more than one delimiter and QGIS chokes on that because that other delimiter is part of your data in a certain attribute.
Andreas

Post by Taimur al said
Hi,
I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2.
Currently im trying to upload an excel sheet converted to (CSV format) on Qgis, this sheet has over 100 rows but only 20 rows are shown and then after adding these rows to the canvas only 20 points show. I have tried with other excel sheets (CSV) i have tried and worked with in the past with the older version and still only 20 rows show.
May i ask if im doing anything wrong / is there a new way to do it?
Hope to hear from you soon.
Regards,
Taimur Al Said
Wildlife Biologist
_______________________________________________
Qgis-user mailing list
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

_______________________________________________
Qgis-user mailing list
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user