[Gvsig_english] problem or question regarding join function

[Wolfgang Qual]

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

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