[GRASS-user] OGR Import Error for shapes with Fieldtype DATE

[Dave Kent]

Horst:
I had the same problem.  It seems to be a new data check in grass.  I  
imported a shape file  successfully about a year ago and it worked.   
I tried about 6 weeks ago and it did not.

I worked around  it by opening the ESRI dbf file in EXCEL and  
changing the field format to numeric and saving.  This seemed to work.

Dave


On Jun 30, 2006, at 2:32 AM, Düster Horst wrote:

> I try to import the attched shape with v.in.ogr but the process  
> breakes with
> the following error message:
>
> v.in.ogr dsn=/gis_data/natpol.shp output=test min_area=0.0001 snap=-1
> Projection of input dataset and current location appear to match.
> Proceeding with import...
> Layer: natpol
>
> Column type not supported (NEW_DATE)
>
> Column type not supported (ARCHIVE_DA)
> DBMI-DBF driver error:
> Incompatible value type.
> Error in db_execute_immediate()
>
>
> The reason of this error seems to be the fields NEW_DATE and  
> ARCHIVE_DA.
> These two fields are of type DATE. The same problem appears with  
> the ogr
> Import functionality og QGIS 0.8. Datatype DATE is an approved type  
> for ESRI
> Shapefiles.
>
> Is it a known bug? Does exists a suitable workaround?
>
> ---------------------------------------------
>
> Dr. Horst Düster
> GIS-Koordinator, Stv. Amtschef
>
> Kanton Solothurn
> Amt für Geoinformation
> Abteilung SO!GIS® Koordination
> Rötistrasse 4
> CH-4501 Solothurn
>
> Tel.: ++41 (0)32 627 25 32
> Fax: ++41 (0)32 627 22 14
>
> horst.duester at bd.so.ch
> www.sogis.so.ch
>
>
> _______________________________________________
> grassuser mailing list
> grassuser at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser