[Qgis-user] Importing CSV files

[Werner Macho]

Hi Richard,

Surely QGIS is able to import it - but you forgot about that sentence in
his first post:
"I have set up a csvt file with "String", "Integer", "Integer", "Integer" "

Using a csvt is sometimes very handy - but as already written "86%" is
unfortunately no integer ;)

regards
Werner


On Fri, Jul 15, 2016 at 2:14 PM, Richard McDonnell <richard.mcdonnell at opw.ie
> wrote:

> Phillip,
> 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 *Custom delimiters*, and selecting* Semicolon*.
> One other thing I done was select
> *No geometry. *This has worked perfectly see attribute table below
>
>
>
> I hope the above settings work, I am running QGIS 2.14 by the way,
> shouldn't make a difference though.
> Regards,
>
> Richard.
>
> On 15/07/2016 13:03, Phillip Money wrote:
>
> Richard,
>
> I am using Add delimited Text Layer.
>
> Here is a snippet of the data.
>
> LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander
> Albury (C);93%;2%;0%
> Armidale Dumaresq (A);88%;6%;0%
> Ashfield (A);93%;1%;0%
> Auburn (C);93%;1%;0%
> Ballina (A);93%;3%;0%
> Balranald (A);87%;6%;0%
> Bankstown (C);94%;1%;0%
> Bathurst Regional (A);91%;4%;0%
>
> 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.
>
> On 15 July 2016 at 22:00, Richard McDonnell <richard.mcdonnell at opw.ie>
> wrote:
>
>> Phillip,
>> Can you supply a sample of the data, also what version are you running of
>> QGIS.
>> The other thing is are you using *Add delimited Text Layer* or are you
>> just loading the CSV directly?
>> Regards,
>>
>> Richard.
>>
>>
>> On 15/07/2016 12:29, Phillip Money wrote:
>>
>> 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.
>>
>>
>> For example, I have tried converting the percentages to numbers and
>> bringing them in that way; same thing happens.
>>
>>
>> I would appreciate any help.
>>
>>
>> Regards
>>
>>
>> Phillip Money
>>
>>
>>
>>
>> _______________________________________________
>> Qgis-user mailing listQgis-user at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>> --
>> *Richard McDonnell*
>> *GIS Specialist PgD GIS AssocSCSI*
>> *OPW FRM Data Management*
>> *52 Stephens Green, Dublin 2.*
>> TEL: 01 6476543
>> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
>> OPW - Looking to the future - Caring for the past
>> <http://www.opw.ie/>
>> Email Disclaimer: http://www.opw.ie/en/disclaimer/
>>
>
>
> --
> *Richard McDonnell*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160715/33388073/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dhgiajjg.png
Type: image/png
Size: 53450 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160715/33388073/attachment.png>