<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
<div style="direction: ltr;">
<blockquote type="cite">
<div dir="ltr">
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">Dear all,</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><br>
</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">Thank you Nicolas and Andreas. </span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><br>
</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">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? </span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><br>
</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">I also took a few screen shots of the excel sheet and on Qgis </span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><br>
</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">Much appreciated and thank you with regards,</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);"><br>
</span></font></div>
<div><font color="#000000"><span style="caret-color: rgb(0, 0, 0); background-color: rgba(255, 255, 255, 0);">Taimur Al Said </span></font></div>
</div>
</blockquote>
</div>
<br>
<div id="AppleMailSignature" dir="ltr">Taimur Al Said</div>
<div dir="ltr"><br>
On Dec 4, 2018, at 10:54 AM, Taimur al said <<a href="mailto:taimur_a_alsaid@hotmail.com">taimur_a_alsaid@hotmail.com</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Dear all,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you Nicolas and Andreas. </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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? </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I also took a few screen shots of the excel sheet and on Qgis </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Much appreciated and thank you with regards,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Taimur Al Said </div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br>
<b>Sent:</b> Monday, December 3, 2018 8:47 PM<br>
<b>To:</b> Andreas Neumann<br>
<b>Cc:</b> Taimur al said; <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [Qgis-user] Delimited text issue</font>
<div> </div>
</div>
<div dir="auto">
<div></div>
<div>Hi,</div>
<div>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.</div>
<div>Nicolas</div>
<div><br>
</div>
<div><br>
Le 3 déc. 2018 à 06:47, Andreas Neumann <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>> a écrit :<br>
<br>
</div>
<blockquote type="cite">
<div>
<p>Hi,</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>Andreas</p>
<p>On 2018-12-03 12:07, Taimur al said wrote:</p>
<blockquote type="cite" style="padding:0 0.4em; border-left:#1010ff 2px solid; margin:0">
<div dir="ltr"> </div>
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
Hi,</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2. </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
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.</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
May i ask if im doing anything wrong / is there a new way to do it?</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
Hope to hear from you soon.</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
Regards,</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
Taimur Al Said</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:#000000">
Wildlife Biologist </div>
</div>
<br>
<div class="x_pre" style="margin:0; padding:0; font-family:monospace">_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br>
</p>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>Qgis-user mailing list</span><br>
<span><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a></span><br>
<span>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br>
<span>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></div>
</blockquote>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div dir="ltr"><Screenshot (1).png></div>
</blockquote>
<blockquote type="cite">
<div dir="ltr"><Screenshot (4).png></div>
</blockquote>
<blockquote type="cite">
<div dir="ltr"><Screenshot (5).png></div>
</blockquote>
</body>
</html>