[GRASS5] v.in.ascii

[Helena Mitasova]

I was indeed running an old version - with 6.1 I get the same error 
with your example, but my data read OK,

(this is unrelated to the memory leak which starts to cause problems 
with 3milion+ points)

Helena
>

GRASS 6.0.cvs (wakestate):~/grasscvs6/grass-6.1.cvs/bin >  echo "1|2|3" 
| ./v.in.ascii out=test4561
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
column: 1  type: integer
column: 2  type: integer
column: 3  type: integer
DBMI-DBF driver error:
Incompatible value type.
Error in db_execute_immediate()

ERROR: Cannot insert values: insert into test4561 values ( 1, '1', '2',
        '3')

GRASS 6.0.cvs (wakestate):~/lgrass > 
~/grasscvs6/grass-6.1.cvs/bin/v.in.ascii -zt nclidcc.ptstestxyz 
out=test61 fs=space z=3
Maximum input row length: 28
Maximum number of columns: 3
Minimum number of columns: 3
Building topology ...
16075 primitives registered
Building areas:  100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids:  100%
Topology was built.
Number of nodes     :   16075
Number of primitives:   16075
Number of points    :   16075
Number of lines     :   0
Number of boundaries:   0
Number of centroids :   0
Number of areas     :   0
Number of isles     :   0
GRASS 6.0.cvs (wakestate):~/lgrass > head nclidcc.ptstestxyz
2091304.41 730008.93 412.05
2091325.21 730001.13 411.08
2091345.45 730003.65 410.18

On Jun 22, 2005, at 12:03 AM, Helena Mitasova wrote:

> Hamish,
>
> I just updated GRASS6 from cvs and for me your example runs:
> (looking at your prompt GRASS:6.1-cvs and mine GRASS 6.0.cvs am I using
> a different version of GRASS? - I will check with Markus tomorrow).
> Can somebody else run the same thing as shown below?
>
> Helena
>
> GRASS 6.0.cvs (wakestate):~/lgrass > echo "1|2|3" | v.in.ascii 
> out=test456
> Maximum input row length: 6
> Maximum number of columns: 3
> Minimum number of columns: 3
> column: 1  type: integer
> column: 2  type: integer
> column: 3  type: integer
> Building topology ...
> 1 primitives registered
> Building areas:  100%
> 0 areas built
> 0 isles built
> Attaching islands:
> Attaching centroids:  100%
> Topology was built.
> Number of nodes     :   1
> Number of primitives:   1
> Number of points    :   1
> Number of lines     :   0
> Number of boundaries:   0
> Number of centroids :   0
> Number of areas     :   0
> Number of isles     :   0
>
> On Jun 21, 2005, at 9:23 PM, Hamish wrote:
>
>>> That v.in.ascii problem is a big one for me -- I suppose it's the 
>>> same
>>> problem I'm having trying to bring in point data. Are there any work
>>> arounds in the mean time?
>>
>>
>> Can you describe again the problem you are seeing?
>>
>> Failure to import more than 50,000 points in 6.0.0? (out of memory)
>> Failure to import more than 3,000,000 points in 6.1-cvs? (out of 
>> memory)
>> Failure to import any points in 6.1-cvs? (see below)
>>
>>
>>
>> Right now, I'm getting this. (fresh & latest CVS, in a new mapset)
>>
>>
>> GRASS:6.1-cvs > echo "1|2|3" | v.in.ascii out=test654
>> Maximum input row length: 6
>> Maximum number of columns: 3
>> Minimum number of columns: 3
>> column: 1  type: integer
>> column: 2  type: integer
>> column: 3  type: integer
>> DBMI-DBF driver error:
>> Incompatible value type.
>> Error in db_execute_immediate()
>>
>> ERROR: Cannot insert values: insert into test654 values ( 1, '1', 
>> '2', '3')
>>
>> GRASS:6.1-cvs > db.connect -p
>> driver:dbf
>> database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
>> schema:(null)
>> group:(null)
>>
>>
>>
>> thanks,
>> Hamish
>>
>> _______________________________________________
>> grass5 mailing list
>> grass5 at grass.itc.it
>> http://grass.itc.it/mailman/listinfo/grass5
>>
> Helena Mitasova
> Dept. of Marine, Earth and Atm. Sciences
> 1125 Jordan Hall, NCSU Box 8208,
> Raleigh NC 27695
> http://skagit.meas.ncsu.edu/~helena/
>
> _______________________________________________
> grass5 mailing list
> grass5 at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5
>
Helena Mitasova
Dept. of Marine, Earth and Atm. Sciences
1125 Jordan Hall, NCSU Box 8208,
Raleigh NC 27695
http://skagit.meas.ncsu.edu/~helena/