<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Thanks Werner and Richard for your help so far. I will have to pursue this tomorrow as it is late here in Australia. <br><br>I will respond tomorrow.<br><br>Phillip<br><br><br><div><hr id="stopSpelling">From: werner.macho@gmail.com<br>Date: Fri, 15 Jul 2016 14:53:03 +0200<br>Subject: Re: [Qgis-user] Importing CSV files<br>To: phillip.money@hotmail.com<br>CC: richard.mcdonnell@opw.ie; qgis-user@lists.osgeo.org<br><br><div dir="ltr">Find attached the working csv and csvt file - And remember - this csv is now NOT to be loaded with delimited text but rather as a "normal" vector layer.<div><br></div><div>regards</div><div>Werner</div></div><div class="ecxgmail_extra"><br><div class="ecxgmail_quote">On Fri, Jul 15, 2016 at 2:26 PM, Phillip Money <span dir="ltr"><<a href="mailto:phillip.money@hotmail.com" target="_blank">phillip.money@hotmail.com</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr">Richard and Werner.<br><br><font style="font-size:16pt;" size="4">I left the csvt file as </font><font style="font-size:12pt;" size="3"><span style="font-size:12.8px;">"String", "Integer", "Integer", "Integer". I converted the percentages to numbers. </span></font><font style="font-size:16pt;" size="4">It still didn't work. At Richard's suggestion, I converted the csv file to a text file and it worked. I can't understand why it didn't work with a CSV file. I am using QGIS Nodego. Thanks for your help, but I am still stumped about the csv file. <br><span class="ecxHOEnZb"><font color="#888888"><br>Phillip<br></font></span><div class="ecxhm ecxHOEnZb"><br></div></font><div class="ecxhm ecxHOEnZb"><br></div><div><div class="ecxhm ecxHOEnZb"><hr>From: <a href="mailto:werner.macho@gmail.com" target="_blank">werner.macho@gmail.com</a><br>Date: Fri, 15 Jul 2016 14:17:35 +0200<br>Subject: Re: [Qgis-user] Importing CSV files<br>To: <a href="mailto:richard.mcdonnell@opw.ie" target="_blank">richard.mcdonnell@opw.ie</a><br>CC: <a href="mailto:phillip.money@hotmail.com" target="_blank">phillip.money@hotmail.com</a>; <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a></div><div><div class="h5"><br><br><div dir="ltr">Hi Richard,<div><br></div><div>Surely QGIS is able to import it - but you forgot about that sentence in his first post:</div><div><span style="font-size:12.8px;">"I have set up a csvt file with "String", "Integer", "Integer", "Integer" "</span><br></div><div><span style="font-size:12.8px;"><br></span></div><div><span style="font-size:12.8px;">Using a csvt is sometimes very handy - but as already written "86%" is unfortunately no integer ;)</span></div><div><span style="font-size:12.8px;"><br></span></div><div><span style="font-size:12.8px;">regards</span></div><div><span style="font-size:12.8px;">Werner</span></div><div><span style="font-size:12.8px;"><br></span></div></div><div><br><div>On Fri, Jul 15, 2016 at 2:14 PM, Richard McDonnell <span dir="ltr"><<a href="mailto:richard.mcdonnell@opw.ie" target="_blank">richard.mcdonnell@opw.ie</a>></span> wrote:<br><blockquote style="border-left:1px #ccc solid;padding-left:1ex;">
<div>
Phillip,<br>
I have copied out what you sent, paste it into notepad and saved it
as a txt file. I then imported it into QGIS using Add delimited Text
Layer, making sure to select <b>Custom delimiters</b>, and
selecting<b> Semicolon</b>.<br>
One other thing I done was select <b>No geometry.<br>
</b>This has worked perfectly see attribute table below<br>
<br>
<img src="cid:part1.00080202.07000508@opw.ie" alt="" height="220" width="300"><br>
<br>
I hope the above settings work, I am running QGIS 2.14 by the way,
shouldn't make a difference though.<br>
Regards,<br>
<br>
Richard.<br>
<br>
<div>On 15/07/2016 13:03, Phillip Money
wrote:<br>
</div>
<blockquote>
<div dir="ltr">
<div>Richard,<br>
<br>
</div>
I am using Add delimited Text Layer. <br>
<br>
Here is a snippet of the data.<span><br>
<br>
LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander<br>
Albury (C);93%;2%;0%<br>
Armidale Dumaresq (A);88%;6%;0%<br>
Ashfield (A);93%;1%;0%<br>
Auburn (C);93%;1%;0%<br>
Ballina (A);93%;3%;0%<br>
Balranald (A);87%;6%;0%<br>
Bankstown (C);94%;1%;0%<br>
Bathurst Regional (A);91%;4%;0%<br>
<br>
I had the data separated by commas, but changed it to
semi-colons. Neither worked. I also change the date to numerical
format as in .93. That didn't work either. <br>
</span></div><div><div>
<div><br>
<div>On 15 July 2016 at 22:00, Richard
McDonnell <span dir="ltr"><<a href="mailto:richard.mcdonnell@opw.ie" target="_blank">richard.mcdonnell@opw.ie</a>></span>
wrote:<br>
<blockquote style="border-left:1px #ccc solid;padding-left:1ex;">
<div> Phillip,<br>
Can you supply a sample of the data, also what version are
you running of QGIS.<br>
The other thing is are you using <b>Add delimited Text
Layer</b> or are you just loading the CSV directly?<br>
Regards,<br>
<br>
Richard.
<div>
<div><br>
<br>
<div>On 15/07/2016 12:29, Phillip Money wrote:<br>
</div>
</div>
</div>
<blockquote>
<div>
<div>
<div dir="ltr"> I have a CSV file with four columns.
The first column is text, and the succeeding
columns are percentages. I have set up a csvt file
with "String", "Integer", "Integer", "Integer"
When I import the file into QGIS as a delimited
text layer, QGIS strips out all the percentages.
They come in as null values. I have tried a lot of
things, but can't get past this.<br>
<br>
<br>
For example, I have tried converting the
percentages to numbers and bringing them in that
way; same thing happens.<br>
<br>
<br>
I would appreciate any help.<br>
<br>
<br>
Regards<br>
<br>
<br>
Phillip Money<br>
<br>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<span>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</span></blockquote>
<span><font color="#888888"> <br>
<div>-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS
AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: <a target="_blank">01 6476543</a></small></small></div>
<div style="font-family:Arial;font-size:8pt;">
OPW - Ag féachaint don am atá le teacht - Ag caomhnú
ón am atá thart<br>
OPW - Looking to the future - Caring for the past<br>
<a href="http://www.opw.ie/" target="_blank"><img src="http://www.opw.ie/en/media/opw-email-banner.png" height="76" width="494"></a><br>
Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/" target="_blank">http://www.opw.ie/en/disclaimer/</a>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</div></div></blockquote><div><div>
<br>
<div>-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: <a target="_blank">01 6476543</a></small></small></div>
</div></div></div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div></div></div></div> </div></div>
</blockquote></div><br></div></div> </div></body>
</html>