[Gvsig_english] problem or question regarding join function

[César Martínez Izquierdo]

Wolfgang Qual escribió:
> Hi Cesar,
> thanks for the reply. I will try this. I was not aware that tables can be 
> already exported to a new dbf file. I did not find this option. Would 
> appreciate, if you could explain this to me...
> 
> Best,
> Wolfgang

Hello Wolfrang,

this is a new feature developed for the Castilla y León regional 
government, but we have already merged it in gvSIG 1.9. It is available 
since last build (1232).

However, it seems to have a bug which fails to export tables which 
contain JOINs. As I said, we'll try to fix it as soon as possible.

Regards,

  César


> Am Dienstag 12 Mai 2009 13:39:50 schrieb César Martínez Izquierdo:
>> Wolfgang Qual escribió:
>>> Hi again,
>>> attached the logfile. Maybe helpful...
>>>
>>> Best,
>>> Wolfgang
>> Hello Wolfrang, I can't see any error in the log :-(
>>
>> By the way, I thing the right steps to achieve what you want are:
>> 1- In the shapefile, add 'x' and 'y' fields with the field calculator
>> 2- Join the dbf with physicians with the dbf of addresss, using the
>> physicians dbf as 'source' table in the join process
>> 3- Export the resulting joining table to DBF
>> 4- Load the DBF as an event theme
>>
>> I've tried to do a similar test in my PC, but I got an error in step 3.
>> It is a bug, which will be solved ASAP.
>> Did you get the error in the same step?
>>
>> Regards,
>>
>>    César
>>
>>> Am Montag 27 April 2009 09:54:09 schrieb Wolfgang Qual:
>>>> Hi list,
>>>> I just did the same thing with ArcView 3.2 - it worked. It seems as if
>>>> gvSIG does not allow to create an x/y theme from a table that contains
>>>> table-joins. I really hope that this will be possible soon. For us in
>>>> the Department, assigning coordinates to addresses is a very important
>>>> task which is done really frequently. How do you deal with this? Any
>>>> ideas for alternatives? (sigh)
>>>>
>>>> Best,
>>>> Wolfgang
>>>>
>>>> ps: some more details to my last post:
>>>> the point-address file contains about 200.000 elements, each address is
>>>> unique.
>>>> The other file is a list of all physicians in my town. Of course,
>>>> addresses are not unique in this file (more than one physician in one
>>>> house). What I have to do now is to create a map of those physicians.
>>>> Therefore, the coordinates of the point shapefile need to be assigned to
>>>> the list in order to create a x/y theme (also called event-theme). Both
>>>> columns that are used for the join contain string-values.
>>>>
>>>> ----8<----
>>>>
>>>> Am Freitag 24 April 2009 15:25:26 schrieb Wolfgang Qual:
>>>>> Hi list,
>>>>> I have a point shapefile that contains quite some addresses and
>>>>> corresponding coordinates and a big file (dbf) that contains some
>>>>> points of interest and their addresses.
>>>>> As the second file contains several elements that have the same
>>>>> address, I would like to join the address layer attribute table to that
>>>>> table (in order to add the coordinate-information to the poi-layer and
>>>>> create a x/y-theme out of it).
>>>>> The join seems to work, but gvSIG will not allow me to create a
>>>>> x/y-theme (it calculates something but does not display the layer or:
>>>>> the layer is marked in the legend with a little cross, marking it as
>>>>> corrupt/broken). Isn't it possible to use a table with joined-to
>>>>> information as a source for an x/y-theme? Did anyone have the same
>>>>> problem already? And: how to solve this issue?
>>>>> Any comments are apprecitated very much.
>>>>> Best,
>>>>> Wolfgang
>>>>> _______________________________________________
>>>>> Gvsig_internacional mailing list
>>>>> Gvsig_internacional at runas.cap.gva.es
>>>>> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>>> _______________________________________________
>>>> Gvsig_internacional mailing list
>>>> Gvsig_internacional at runas.cap.gva.es
>>>> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Gvsig_internacional mailing list
>>> Gvsig_internacional at runas.cap.gva.es
>>> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
> 
> 
> 
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
> 


-- 
César Martínez Izquierdo
Equipo de desarrollo gvSIG
http://www.gvsig.org/web/

IVER T.I.
C/ Lérida, 20
46009 Valencia - Spain
http://www.iver.es