subject:"Re\: \[GRASS\-dev\] \[GRASS GIS\] #3396\: db.in.ogr fails with .dbf files created with Visual Foxpro"

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2019-05-10 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  closed
  Priority:  minor|  Milestone:  7.2.4
 Component:  Database |Version:  7.2.1
Resolution:  wontfix  |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-
Changes (by martinl):

 * status:  new => closed
 * resolution:   => wontfix


-- 
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2017-08-11 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  minor|  Milestone:
 Component:  Database |Version:  7.2.1
Resolution:   |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-

Comment (by maitl):

 Ok, I see that both tables can be imported on a different machine.


 I found several ogrinfo binaries from my machine.
 {{{
 # "C:\Program Files\GDAL\ogrinfo"  --version
 GDAL 1.11.1, released 2014/09/24
 }}}
 {{{
 # "C:\Program Files\GRASS GIS 7.2.1\extrabin\ogrinfo" --version
 GDAL 2.1.3, released 2017/20/01
 }}}
 {{{
 #c:\osgeo4w\bin\ogrinfo --version
 GDAL 1.11.2, released 2015/02/10
 }}}
 All can read the problematic table_VFP_import_fail.dbf and print the file
 content with -sql switch.

 The output from all these ogrinfo exemplars is attached
 (ogrinfo_of_dbf_tables.zip) . There are differences on field types as
 interpreted by different ogrinfo versions, but this is probably not
 important.

 The output of ogrinfo from  problematic table contains additional rows
 with
 {{{
 _NullFlags: String (2.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 : String (0.0)
 }}}

--
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2017-08-11 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  minor|  Milestone:
 Component:  Database |Version:  7.2.1
Resolution:   |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-
Changes (by maitl):

 * Attachment "ogrinfo_of_dbf_tables.zip" added.


--
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2017-08-11 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  minor|  Milestone:
 Component:  Database |Version:  7.2.1
Resolution:   |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-

Comment (by mlennert):

 Replying to [ticket:3396 maitl]:
 > Import of .dbf table created with Visual Foxpro ends with "ERROR: Input
 DSN  not found or not readable" . The problem is probably
 related to the .dbf file header where file structure is described
 (https://msdn.microsoft.com/en-us/library/aa975386(v=vs.71).aspx).
 >
 > When  I converted the problematic table in Visual Foxpro environment to
 Foxpro 2.x format (command COPY TO mytable_fox26x TYPE FOX2X), then
 dbf.in.ogr works.

 I cannot reproduce with GRASS 7.2.1 and GDAL 2.2.1:


 {{{
 > db.in.ogr table_VFP_import_fail.dbf out=test
 Imported table  with 5 rows
 > db.in.ogr table_FOX2x_import_ok.dbf out=test2
 Imported table  with 5 rows
 > db.select table=test
 X|Y|PE|ME_MREG|M1HB|M1KU|M1KS|M1LV|M1LM|M1MA|M1TL|M2|JRK|MID|xNullFlags
 373094|6464908|13|47|0|0|0|0|0|47|0|0|150818|483611848311|
 374195|6462403|11|230|23|12|115|0|0|80|0|0|150818|1345853648111|
 374489|6464662|13|184|0|0|4|0|0|180|0|0|270634|907614648111|
 375069|6463314|13|182|0|0|0|0|0|182|0|0|150818|483611048311|
 375288|6472475|13|103|0|0|0|0|0|103|0|0|270634|1016537148111|
 > db.select table=test2
 X|Y|PE|ME_MREG|M1HB|M1KU|M1KS|M1LV|M1LM|M1MA|M1TL|M2|JRK|MID
 373094|6464908|13|47|0|0|0|0|0|47|0|0|150818|483611848311
 374195|6462403|11|230|23|12|115|0|0|80|0|0|150818|1345853648111
 374489|6464662|13|184|0|0|4|0|0|180|0|0|270634|907614648111
 375069|6463314|13|182|0|0|0|0|0|182|0|0|150818|483611048311
 375288|6472475|13|103|0|0|0|0|0|103|0|0|270634|1016537148111
 }}}

 I also don't think that this would be an issue with the GRASS GIS dbf
 driver as db.in.ogr uses ogr to read the file. So if there is an issue it
 is probably with your version of GDAL.

 What do

 ogrinfo table_VFP_import_fail.dbf
 and
 ogrinfo table_VFP_import_fail.dbf table_VFP_import_fail

 give you ?

 What version of GDAL do you have installed.

--
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2017-08-11 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  minor|  Milestone:
 Component:  Database |Version:  7.2.1
Resolution:   |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-

Comment (by martinl):

 Since DBF driver is obsolete in GRASS 7 and will be probably removed in
 GRASS 8 I think that reported issue will not fixed. Could you suggest
 changes in manual? Ideally as attached patch. Thanks.

--
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

2017-08-11 Thread GRASS GIS

#3396: db.in.ogr fails with .dbf files created with Visual Foxpro
--+-
  Reporter:  maitl|  Owner:  grass-dev@…
  Type:  defect   | Status:  new
  Priority:  minor|  Milestone:
 Component:  Database |Version:  7.2.1
Resolution:   |   Keywords:
   CPU:  Unspecified  |   Platform:  MSWindows 7
--+-
Changes (by maitl):

 * Attachment "dbf_tables_for testing.zip" added.

 Two tables for testing

--
Ticket URL: 
GRASS GIS 

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

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

Re: [GRASS-dev] [GRASS GIS] #3396: db.in.ogr fails with .dbf files created with Visual Foxpro

6 matches

Site Navigation

Mail list logo

Footer information