[Qgis-user] Delimited text issue

[Taimur al said]

Dear all,

Thank you Nicolas and Andreas.

I have tried many tests cutting and pasting to a new sheet and saving the excel sheet as CSV files but still only 20 rows are showing. I think the sheet is fine but seems there is a problem with some settings on my QGIS. Is there any specific settings you would like me share with you?

I also took a few screen shots of the excel sheet and on Qgis

Much appreciated and thank you with regards,

Taimur Al Said

Taimur Al Said

On Dec 4, 2018, at 10:54 AM, Taimur al said <taimur_a_alsaid at hotmail.com<mailto:taimur_a_alsaid at hotmail.com>> wrote:

Dear all,

Thank you Nicolas and Andreas.

I have tried many tests cutting and pasting to a new sheet and saving the excel sheet as CSV files but still only 20 rows are showing. I think the sheet is fine but seems there is a problem with some settings on my QGIS. Is there any specific settings you would like me share with you?

I also took a few screen shots of the excel sheet and on Qgis

Much appreciated and thank you with regards,

Taimur Al Said
________________________________
From: Nicolas Cadieux <nicolas.cadieux at archeotec.ca<mailto:nicolas.cadieux at archeotec.ca>>
Sent: Monday, December 3, 2018 8:47 PM
To: Andreas Neumann
Cc: Taimur al said; qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Delimited text issue

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


Le 3 déc. 2018 à 06:47, Andreas Neumann <a.neumann at carto.net<mailto:a.neumann at carto.net>> a écrit :


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

On 2018-12-03 12:07, Taimur al said wrote:


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
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


_______________________________________________
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
<Screenshot (1).png>
<Screenshot (4).png>
<Screenshot (5).png>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181204/b66968dd/attachment.html>