
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>

<p>Hi Tonino,</p>

<p>Can you try to provide a .csvt file along with the .csv file? It should have the same name with a different extension. See also http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</p>

<p>Andreas</p>

<p>On 2015-07-29 10:18, CONTI Tonino wrote:</p>

<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->

<div style="font-size: x-small; font-family: Tahoma; color: #000000; direction: ltr;">

<div dir="ltr" align="left"><span style="color: #000080; font-family: Tahoma;"><span id="result_box"><span style="font-size: medium;"><span class="hps"><span style="color: #000000;">Dear</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">all</span></span></span><span style="font-size: medium;"><span style="color: #000000;"><span>,</span><br /></span><span class="hps"><span style="color: #000000;">Can anyone tell me</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">how to</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">prevent</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">qgis</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">automatically convert</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">a csv file</span></span><span style="color: #000000;"> from </span><span class="hps"><span style="color: #000000;">text</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">field</span></span><span style="color: #000000;"> to </span><span class="hps"><span style="color: #000000;">numeric format</span></span><span style="color: #000000;"> </span><span class="hps atn"><span style="color: #000000;">(</span></span><span><span style="color: #000000;">double)</span></span></span><span style="font-size: medium;"><span style="color: #000000;"><span>.</span><br /></span><span class="hps"><span style="color: #000000;">I have a</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">csv file</span></span><span style="color: #000000;"> </span><span class="hps alt-edited"><span style="color: #000000;">where</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">a</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">field contains</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">texts</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">starting with</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">zero</span></span><span style="color: #000000;"> </span><span class="hps atn"><span style="color: #000000;">(</span></span><span><span style="color: #000000;">example</span></span><span><span style="color: #000000;">:</span></span><span style="color: #000000;"> </span><span class="hps atn"><span style="color: #000000;">"</span></span><span><span style="color: #000000;">0420050000000009</span></span><span><span style="color: #000000;">"</span></span><span><span style="color: #000000;">,</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">with</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">the quotes)</span></span></span><span style="font-size: medium;"><span style="color: #000000;"><span>.</span><br /></span><span class="hps"><span style="color: #000000;">When I add</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">to my project</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">file</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">as</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">"layer</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">delimited text</span></span><span><span style="color: #000000;">,"</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">I see</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">the data properly</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">in the preview</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">but</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">when the layer is</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">added</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">in this field</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">is not imported</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">the leading zero</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">recognizing</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">the format</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">as numeric</span></span></span><span style="font-size: medium;"><span style="color: #000000;"><span>.</span><br /></span><span class="hps"><span style="color: #000000;">I need</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">that the string</span></span><span style="color: #000000;"> </span><span class="hps atn"><span style="color: #000000;">"</span></span><span><span style="color: #000000;">0420050000000009</span></span><span><span style="color: #000000;">"</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">remains</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">unchanged</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">as it represents</span></span><span style="color: #000000;"> </span><span class="hps"><span style="color: #000000;">a unique identifier</span></span></span><span style="color: #000000;"><span style="font-size: medium;"><span>.</span><br /></span></span><span style="color: #000000;"><span style="font-size: medium;"><span class="hps">can you help me?</span><br /></span></span><span style="font-size: medium;"><span style="color: #000000;"><span class="hps">Thank You</span><br /></span><span class="hps"><span style="color: #000000;">Tonino</span></span></span></span></span></div>

<div id="gt-edit" dir="ltr" style="display: none;" align="center"> </div>

<div dir="ltr" align="center"><span style="color: #000080; font-family: Tahoma; font-size: small;"><span style="font-size: xx-small;"></span></span> </div>

<div dir="ltr" align="center"><span style="color: #000080; font-family: Tahoma; font-size: small;"><span style="font-size: xx-small;"></span></span> </div>

<div dir="ltr" align="center"><span style="color: #000080; font-family: Tahoma; font-size: small;"><span style="font-size: xx-small;"></span></span> </div>

<div dir="ltr" align="center"><span style="color: #000080; font-family: Tahoma; font-size: small;"><span style="font-size: xx-small;"></span></span> </div>

<div dir="ltr" align="center"><span style="color: #000080; font-family: Tahoma; font-size: small;"><em><span style="font-size: xx-small;">Dott.</span>Tonino Conti</em></span></div>

<div align="center"><span style="font-family: tahoma; font-size: xx-small;"><em>Comune di Jesi</em></span></div>

<div align="center"><span style="font-family: tahoma; font-size: xx-small;"><em>Sistema Informativo Territoriale</em></span></div>

<div align="center"><em><span style="font-family: tahoma; font-size: xx-small;"> Tel 0731538312 - fax 0731538513</span></em></div>

<div align="center"><em><span style="font-family: tahoma; font-size: xx-small;"><a href="mailto:t.conti@comune.jesi.an.it">t.conti@comune.jesi.an.it</a></span></em></div>

<div align="center"><em><span style="font-family: tahoma; font-size: xx-small;"><a href="http://www.comune.jesi.an.it/sit">www.comune.jesi.an.it/sit</a></span></em></div>

</div>

<!-- html ignored --><br />

<div class="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 /><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>

</blockquote>

<p> </p>

<div> </div>

</body></html>