[Qgis-developer] JOIN error

[Ramon Andiñach]

On 19/12/2011, at 6:57, Ramon Andiñach <custard at westnet.com.au> wrote:

> 
> On 19/12/2011, at 03:15 , Agustin Lobo wrote:
> 
>> I use Properties/JOINS to join a dbf table to a vector layer
>> (fields ISO and ISO3 respectively). The Join works, but
>> I get the following error when I  try to save the vector layer as
>> a new shapefile:
>> Export to vector file failed.
>> Error: Feature write errors:
>> Invalid variant type for field X[11]: received void with type
>> Invalid variant type for field X[11]: received void with type
>> (many times repeated)
>> Only 24 of 246 features written.
>> 
>> The new layer is actually written (despite claiming "Export to vector
>> failed") but only those countries with data in the dbf are available
>> 
>> Instead, the old Vector/Data Management Tools/Join Attributes
>> works fine. I suggest having that part of the Vector plugin back, even
>> if redundant, until we reach operational equivalence.
>> 
>> I provide the layer and dbf:
>> https://sites.google.com/site/filestemp2/home/wrld_simpl.zip
>> https://sites.google.com/site/filestemp2/home/owlslive.dbf
>> 
>> I'm using 1.7.3 from ubuntigis-unstable binaries for ubuntu 10.04
>> 
> 
> I can confirm this.
> 
> I also tried removing the X column from the dbf file, but the error moved to the next field with nulls (GMI_CNTRY), which was a string.
> 
> I'm a little puzzled why a null value would be a problem if the file did save successfully.

fwiw, this also fails if you reprocess the owl data as csv (with a csvt). 

And confirmed with some internal datasets.

(that said, I can understand why you would want to save the joined file, but generally I use this as an intermediate step.)

-ramon.