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

[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: <https://trac.osgeo.org/grass/ticket/3396#comment:3>
GRASS GIS <https://grass.osgeo.org>