<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 09/05/2013 03:11 PM, silverio abati
wrote:<br>
</div>
<blockquote
cite="mid:CA+jvUu0AQZFixB1AUtfZaLi3uNw3_j=daVsA5Re=HysRzuySUA@mail.gmail.com"
type="cite">
<div dir="ltr"><span
style="font-family:arial,sans-serif;font-size:13px">hello
List,</span>
<div style="font-family:arial,sans-serif;font-size:13px">I have
a little problem to import a layer with the function
"delimited text layer":</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">I have
the coordinates (e.g. 41°44'51'' Lat, 14°18'13'' Long) and I
know the coordinate reference system: WGS84 UTM33N, EPSG:
32633.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">the
problem is that I don't know which font I have to use in the
database (e.g. excel) so QGIS can read them in correct mode
(at the end of the import process QGIS says me the fields for
coordinates are no valid).</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
</div>
</blockquote>
Nothing to do with the font. The lon/lat values *must* be in decimal
degrees: DD.dddddd<br>
In excel separate the degrees, minutes, seconds into three
different columns. Then, in a fourth column put in the formula:
"degree_column + (minutes_column/60) + (seconds_column/3600). Same
for the longitude values.<br>
Now you must convert those formulas to numbers. Use in Excel "Copy",
then "Paste Special" to copy the formulas to numbers.<br>
<br>
Now, when you input the delimited text file, point to those
(numeric) columns that hold the decimal degree values for the X and
Y columns, and it should work fine.<br>
<br>
<blockquote
cite="mid:CA+jvUu0AQZFixB1AUtfZaLi3uNw3_j=daVsA5Re=HysRzuySUA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div style="font-family:arial,sans-serif;font-size:13px">I
tried:</div>
<div style="font-family:arial,sans-serif;font-size:13px">41°44'51''<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">414451</div>
<div style="font-family:arial,sans-serif;font-size:13px">41.44.51</div>
<div style="font-family:arial,sans-serif;font-size:13px">but
they don't work</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">thank
you very much</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">
BEST,</div>
<div style="font-family:arial,sans-serif;font-size:13px">silverio</div>
</div>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></pre>
</body>
</html>