[GRASS5] v.in.garmin

[Hamish]

> I tried the same command sequence you suggested (on a UTM zone 32 
> location, import of GPS_points (track|route|waypoint) works 
> fine), this is an excerpt of the error printout: 
>  
> --------------------- 
>  
> DBMI-DBF driver error: 
> Incompatible value type. 
> Error in db_execute_immediate() 
>  
> ERROR: Error while executing: "INSERT INTO t1_trk VALUES (135, 
> '03/27/2005 
>        11:31:52', 49,0000000, 9,0000000, '03/27/2005 11:33:00', 
> 49,0000000, 
>        9,0000000) 
>        " 
> DBMI-DBF driver error: 
> Incompatible value type. 
> Error in db_execute_immediate() 


ahh ok, I see the problem.

49,0000000

Awk is using the comma as a decimal place instead of a period, and so
the third column is read as 000000 not 9.0000.


see these threads, same problem but with r.fillnulls.

http://thread.gmane.org/gmane.comp.gis.grass.devel/6864
http://thread.gmane.org/gmane.comp.gis.grass.devel/6966


In r.fillnulls we could get away with replacing awk, in v.in.garmin we
really need it.

try adding

LC_ALL=C

to the start of the script or just in front of each awk command.



Hamish