[GRASS-dev] v.in.ogr: cnames vs. columns

hi,

just found it in the manual:

https://grass.osgeo.org/grass73/manuals/v.in.ogr.html

in the command itself it's "columns"

v.in.ogr [-flc2tojrewi] input=string [layer=string[,string,...]]
[output=name] [spatial=xmin,ymin,xmax,ymax[,xmin,ymin,xmax,ymax,...]]
[where=sql_query] [min_area=float] [type=string[,string,...]] [snap=float]
[location=name] [columns=name[,name,...]] [encoding=string] [key=string]
[geometry=name] [--overwrite] [--help] [--verbose] [--quiet] [--ui]

in the rest of the manual "cnames"

"v.in.ogr converts '.', '-' and '#' to '_' (underscore) during import. The
-w flag changes capital column names to lowercase characters as a
convenience for SQL usage (lowercase column names avoid the need to quote
them if the attribute table is stored in a SQL DBMS such as PostgreSQL). The
cnames parameter is used to define new column names during import.

The DBF database specification limits column names to 10 characters. If the
default DB is set to DBF and the input data contains longer column/field
names, they will be truncated. If this results in multiple columns with the
same name then v.in.ogr will produce an error. In this case you will either
have to modify the input data or use v.in.ogr's cnames parameter to rename
columns to something unique. (hint: copy and modify the list given with the
error message). Alternatively, change the local DB with db.connect. "

am I right that the manual should be changed?

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/v-in-ogr-cnames-vs-columns-tp5332012.html
Sent from the Grass - Dev mailing list archive at Nabble.com.

Hi Helli,

Using the history link at the end of the manual, I found:

https://trac.osgeo.org/grass/changeset/63602/grass/trunk/vector/v.in.ogr

cnames was renamed to columns in 63602… could you please edit the manual? I’m on phone.

Cheers,
Vero

···

El 21 ago. 2017 6:54 p.m., “Helmut Kudrnovsky” <hellik@web.de> escribió:

hi,

just found it in the manual:

https://grass.osgeo.org/grass73/manuals/v.in.ogr.html

in the command itself it’s “columns”

v.in.ogr [-flc2tojrewi] input=string [layer=string[,string,…]]
[output=name] [spatial=xmin,ymin,xmax,ymax[,xmin,ymin,xmax,ymax,…]]
[where=sql_query] [min_area=float] [type=string[,string,…]] [snap=float]
[location=name] [columns=name[,name,…]] [encoding=string] [key=string]
[geometry=name] [–overwrite] [–help] [–verbose] [–quiet] [–ui]

in the rest of the manual “cnames”

"v.in.ogr converts ‘.’, ‘-’ and ‘#’ to ‘_’ (underscore) during import. The
-w flag changes capital column names to lowercase characters as a
convenience for SQL usage (lowercase column names avoid the need to quote
them if the attribute table is stored in a SQL DBMS such as PostgreSQL). The
cnames parameter is used to define new column names during import.

The DBF database specification limits column names to 10 characters. If the
default DB is set to DBF and the input data contains longer column/field
names, they will be truncated. If this results in multiple columns with the
same name then v.in.ogr will produce an error. In this case you will either
have to modify the input data or use v.in.ogr’s cnames parameter to rename
columns to something unique. (hint: copy and modify the list given with the
error message). Alternatively, change the local DB with db.connect. "

am I right that the manual should be changed?


best regards
Helmut

View this message in context: http://osgeo-org.1560.x6.nabble.com/v-in-ogr-cnames-vs-columns-tp5332012.html
Sent from the Grass - Dev mailing list archive at Nabble.com.


grass-dev mailing list
grass-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-dev

Veronica Andreo wrote

Hi Helli,

Using the history link at the end of the manual, I found:

https://trac.osgeo.org/grass/changeset/63602/grass/trunk/vector/v.in.ogr

cnames was renamed to columns in 63602... could you please edit the
manual?
I'm on phone.

Cheers,
Vero

El 21 ago. 2017 6:54 p.m., "Helmut Kudrnovsky" &lt;

hellik@

&gt; escribió:

hi,

just found it in the manual:

https://grass.osgeo.org/grass73/manuals/v.in.ogr.html

in the command itself it's "columns"

v.in.ogr [-flc2tojrewi] input=string [layer=string[,string,...]]
[output=name] [spatial=xmin,ymin,xmax,ymax[,xmin,ymin,xmax,ymax,...]]
[where=sql_query] [min_area=float] [type=string[,string,...]] [snap=float]
[location=name] [columns=name[,name,...]] [encoding=string] [key=string]
[geometry=name] [--overwrite] [--help] [--verbose] [--quiet] [--ui]

in the rest of the manual "cnames"

"v.in.ogr converts '.', '-' and '#' to '_' (underscore) during import.
The
-w flag changes capital column names to lowercase characters as a
convenience for SQL usage (lowercase column names avoid the need to quote
them if the attribute table is stored in a SQL DBMS such as PostgreSQL).
The
cnames parameter is used to define new column names during import.

The DBF database specification limits column names to 10 characters. If
the
default DB is set to DBF and the input data contains longer column/field
names, they will be truncated. If this results in multiple columns with
the
same name then v.in.ogr will produce an error. In this case you will
either
have to modify the input data or use v.in.ogr's cnames parameter to rename
columns to something unique. (hint: copy and modify the list given with
the
error message). Alternatively, change the local DB with db.connect. "

am I right that the manual should be changed?

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.
nabble.com/v-in-ogr-cnames-vs-columns-tp5332012.html
Sent from the Grass - Dev mailing list archive at Nabble.com.
_______________________________________________
grass-dev mailing list

grass-dev@.osgeo

https://lists.osgeo.org/mailman/listinfo/grass-dev

_______________________________________________
grass-dev mailing list

grass-dev@.osgeo

https://lists.osgeo.org/mailman/listinfo/grass-dev

here on my side only a chance at the end of the week to commit the change.

If anyone able earlier, very welcome.

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/v-in-ogr-cnames-vs-columns-tp5332012p5332047.html
Sent from the Grass - Dev mailing list archive at Nabble.com.

Hi,

2017-08-21 22:12 GMT+02:00 Helmut Kudrnovsky <hellik@web.de>:

here on my side only a chance at the end of the week to commit the change.

If anyone able earlier, very welcome.

done in r71428-30. Ma