[Qgis-user] R: Re: R: Re: Add table excel and categorize

[labiancamarilena at libero.it]

Excuse me.
I forgot. I'm reading an manual, what about GRASS to load this data?
Thanks. 

>----Messaggio originale----
>Da: labiancamarilena at libero.it
>Data: 12/11/2013 19.00
>A: <bernd.vogelgesang at gmx.de>, <qgis-user at lists.osgeo.org>
>Ogg: R: Re: R: Re: [Qgis-user] Add  table excel and categorize
>
>
>Hi,
>thanks a lot.
>I've solved the problem.
>CSV is indeed recognized as a string but I downloaded Quantum 2.0 and with 
>some tricks, the system allows to graduate values .
>When I import CSV use " Custom delimiters " in this way successfully it 
loads 
>the file.
>Thank you very much!
>
>>----Messaggio originale----
>>Da: bernd.vogelgesang at gmx.de
>>Data: 12/11/2013 16.35
>>A: "labiancamarilena at libero.it"<labiancamarilena at libero.it>, <qgis-
user at lists.
>osgeo.org>
>>Ogg: Re: R: Re: [Qgis-user] Add  table excel and categorize
>>
>>Am 12.11.2013 16:01, schrieb labiancamarilena at libero.it:
>>> Hi,
>>> yes the file is a csv (which has numeric values).
>>Check the csv properties within QGIS -> Fields Tab: See if your fields 
>>are really interpreted as integer/real values and NOT string!
>>Cause when this is string, the values can't show up for classification.
>>
>>When you use 2.0 (at least), you might have better luck importing the 
>>csv through Layers -> Add delimited text file instead of drag-and-drop 
>>into the ToC.
>>There QGIS tries to guess the field type.
>>
>>This might fail as well, cause your original excel sheet might have 
>>wrong data. A very popular bug are spaces in front or behind your numbers.
>>You should search and delete them there.
>>
>>There is also the possibility to create an affiliated csvt-file (see 
>>http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-
>for-use-in-qgis/), 
>>in which you define the field type for the csv. But this is a very 
>>tiresome work when you have lots of fields.
>>
>>
>>So, lots of speculations from my side. But we'll see ...
>>
>>Cheers
>>Bernd
>>
>>
>>
>>> The layer to add this csv is a shapefile (its table of attributes contains
>>> cod, name, lenghts of municipalities).
>>> I joined them and infact the table of attributes shows the name of
>>> municipalities, lenghts...and corresponding values.
>>> I saved it (ESRI Shapefile) and when I select the "Style" to graduate the
>>> values, the column shows only the cod. of municipalities, shape leng and 
>area.
>>> Can you help me?
>>> Thanks a lot
>>>
>>>> ----Messaggio originale----
>>>> Da: bernd.vogelgesang at gmx.de
>>>> Data: 11/11/2013 21.45
>>>> A: <qgis-user at lists.osgeo.org>, "labiancamarilena at libero.it"
>>> <labiancamarilena at libero.it>
>>>> Ogg: Re: [Qgis-user] Add  table excel and categorize
>>>>
>>>> Hi,
>>>>
>>>> 1.
>>>> adding a csv is not the same like loading a shape. So you can't edit it.
>>>> Loading as dbf should give you write permissions (OpenOffice/Libre Office
>>>> still offer dbf support, while new Excel versions don't)
>>>>
>>>> 2.
>>>> I assume you joined the csv to an existing layer? In QGIS 2.0, the joined
>>>> columns are presented for classification, in 1.8 you will (i think) have
>>>> to make the join permanent by saving the joined layer to a new one. Then,
>>>> all attributes are editable as well.
>>>>
>>>> Hope I answered your questions
>>>>
>>>> Bernd
>>>>
>>>> Am 11.11.2013, 19:53 Uhr, schrieb labiancamarilena at libero.it
>>>> <labiancamarilena at libero.it>:
>>>>
>>>>> Dear all members of list,
>>>>> I have to add a table in excel that contains indices calculated for each
>>>>> municipality.
>>>>>
>>>>> I turned the sheet from excel to csv and added to the table of
>>>>> attributes as usual, but I have two problems:
>>>>>
>>>>> 1.
>>>>> Some data (indexes) when combined (the table  with common code and other
>>>>> attributes)
>>>>> appear with the word
>>>>> "null", I can add them manually? When I try to add them by editing the
>>>>> appropriate line, but the program does not save the changes.
>>>>>
>>>>> 2.
>>>>> When I want to customize the style,
>>>>> ie I want to categorize the classified data (they are many) and I do not
>>>>> know how to reduce or customize intervals. When I try the option
>>>>> graduated the values ​​joined (indices) to the table (municipalities) do
>>>>> not appear in the column.Thanks.
>>>>>
>>>>>
>>>>>
>>>>
>>>> -- 
>>>> Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374
>>>>
>>>
>>
>>
>
>