<div dir="ltr">Agustín<div><br></div><div>Thanks for the tip. I did try placing the lat and long fields as columns 1 and 2 with no success. It is very strange.</div><div><br></div><div>I guess I will have to get the DMS converted to D.D and go from there.</div><div><br></div><div>Best regards</div><div>Peter</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Sep 26, 2021 at 10:11 PM Agustín Diez Castillo <<a href="mailto:Agustin.Diez@uv.es">Agustin.Diez@uv.es</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto">Hi,<div>Are latitude and longitude among the first fields? I will try with them in field 2 and field 3, let field 1 for ID if you wish so. In this way, you can be sure if the problem is in another field or just in one of them.</div><div>This trick helped me in te past to see where was the problems. Nicolas’ suggestion will be the correct way to go (if you’re in Windows), but the other could help to see what it’s going on.<br><div dir="ltr">Best</div><div dir="ltr">Agustín </div><div dir="ltr"><br><blockquote type="cite">On 26 Sep 2021, at 17:39, Nicolas Cadieux <<a href="mailto:njacadieux.gitlab@gmail.com" target="_blank">njacadieux.gitlab@gmail.com</a>> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr">Hi,<div><br><div>I have never used DMS, but rather Degrees in Decimals so perhaps that is the problem. Make sure what is currently imported is actually in the correct place in DMS.</div><div><br></div><div>Normally, problems with csv is related to empty field or extra separators. Look at the file in notepad or notepad ++ and eliminate to problematic characters to make sure columns are Perfectly aligned. This can be hard to find if the separator is a space character.<br><br><div dir="ltr">Nicolas Cadieux<div><a href="https://gitlab.com/njacadieux" target="_blank">https://gitlab.com/njacadieux</a></div></div><div dir="ltr"><br><blockquote type="cite">Le 26 sept. 2021 à 16:48, Peter Devanney <<a href="mailto:peter@devanney.ca" target="_blank">peter@devanney.ca</a>> a écrit :<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr">Hello<div><br></div><div>I have an issue I have never run into before.</div><div><br></div><div>I am adding a delimited text (CSV) layer and only some of the records appear on the map. 36/118 records show. The rest do not show but are still in the attribute table.</div><div><br></div><div>When I run add geometry attributes or do an export to .shp I only see the 36 records that showed up on the map.</div><div><br></div><div>All records look identical in the source CSV. I cannot see any difference that would explain why one record imported successfully with geometry attributes and the others didn't.</div><div><br></div><div>The CSV file has separate Lat and Long columns with coordinates in DMS</div><div><table border="0" cellpadding="0" cellspacing="0" width="304" style="border-collapse:collapse;width:228pt">
<colgroup><col width="197" style="width:148pt">
<col width="107" style="width:80pt">
</colgroup><tbody><tr height="21" style="height:16pt">
<td height="21" width="197" style="height:16pt;width:148pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:12pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Latitude</td>
<td width="107" style="width:80pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:12pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Longitude</td>
</tr>
<tr height="21" style="height:16pt">
<td height="21" style="height:16pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:12pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">N45 45 56.1</td>
<td style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:12pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">W075 27 51.3</td>
</tr>
</tbody></table></div><div><br></div><div>I am running 3.16.8 on OS X Big Sur 11.5.2<br></div><div><br></div><div>Scratching my head as to why some records import ok and the others do not, even though all show up in the attribute table.</div><div><br></div><div>thanks</div><div><br></div><div>Peter Devanney</div></div>
<span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a></span><br><span>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br><span>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br></div></blockquote></div></div><span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a></span><br><span>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br><span>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br></div></blockquote></div></div></blockquote></div>