Am 12.11.2013 19:03, schrieb labiancamaril...@libero.it:
Excuse me.
I forgot. I'm reading an manual, what about GRASS to load this data?
Thanks.
Boohaa. Never faced something less intuitive like GRASS handles data
(Think that's something for the pros). But when you manage to do so
successfully, the better.
I think the normal way to import as text delimited file should do it, or
use the before-mentioned option to save your xls as dbf and just drag
and drop.
P.S. Reading manuals is veeery good (I never do that ;) )
----Messaggio originale----
Da: labiancamaril...@libero.it
Data: 12/11/2013 19.00
A: <bernd.vogelges...@gmx.de>, <qgis-user@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.vogelges...@gmx.de
Data: 12/11/2013 16.35
A: "labiancamaril...@libero.it"<labiancamaril...@libero.it>, <qgis-
user@lists.
osgeo.org>
Ogg: Re: R: Re: [Qgis-user] Add table excel and categorize
Am 12.11.2013 16:01, schrieb labiancamaril...@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.vogelges...@gmx.de
Data: 11/11/2013 21.45
A: <qgis-user@lists.osgeo.org>, "labiancamaril...@libero.it"
<labiancamaril...@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 labiancamaril...@libero.it
<labiancamaril...@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
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
