How to add geo location to customer data?

[arini.rusda]

Hi,
Is anyone know how to add geo location to contact/account postal address?? because i can't find any screen to add/change the geo point for the postal address.

Thanks,
Arini

[Mike Z]

The only way I found to do some of this (besides hacking the sql) is webtools:

https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAndGeoPoint&partyId=Company&fromDate=2009-01-09%2000:00:00.0&geoPointId=9000&enableEdit=true

For 'Company', you can't change geoPointId=9000, but you can change lat/long.

You can add more GeoPoints through WebTools.

https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=GeoPoint

The only way I found to change the 9000 for 'Company' is through sql
(party_geo_point).  WebTools does not seem to allow this.

The tables associated with this seem to be:

geo_point, party_geo_point


On 6/11/11, arini.rusda <[hidden email]> wrote:

> Hi,
> Is anyone know how to add geo location to contact/account postal address??
> because i can't find any screen to add/change the geo point for the postal
> address.
>
> Thanks,
> Arini
>
> -----
> Best Regards,
> Arini Rusda
> Informatics Department, Sepuluh Nopember Institute of Technology
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/How-to-add-geo-location-to-customer-data-tp3590159p3590159.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[BJ Freeman]

look at the postaladdress
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PostalAddress&contactMechId=9000

at the bottom is a xml
you can edit it and re-import through webtools.

https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=GeoPoint&geoPointId=9000

will show you all the relationships for a Geopoint.


also so a search through the java, xml and groovy files for GeoPoint to
see how it is programmatic determined for an postal address.


=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/control/automation?forumId=SUPPLYCHAIN>

Specialtymarket.com <http://www.specialtymarket.cos>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
arini.rusda sent the following on 6/11/2011 1:39 AM:

> Hi,
> Is anyone know how to add geo location to contact/account postal address??
> because i can't find any screen to add/change the geo point for the postal
> address.
>
> Thanks,
> Arini
>
> -----
> Best Regards,
> Arini Rusda
> Informatics Department, Sepuluh Nopember Institute of Technology
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-add-geo-location-to-customer-data-tp3590159p3590159.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[arini.rusda]

Hi, Guys
thanks for the reply.

I understand the relationship between the party postal_address and the party_geo_point.

so CMIIW, beside from webtools, there's no particular screen in party/SFA component (like editcontachmech.ftl for editing party_contact_mech) to add geo_point to a postal_address of a party?

i'm wondering, is there some functionality when we're inputing some data of a party's postal address, ofbiz querying it to google and retrieve the lat/long details for the postal address we've entry?

Thanks in advance

[BJ Freeman]

so your looking for functionality like this
https://demo-trunk.ofbiz.apache.org/partymgr/control/PartyGeoLocation?partyId=DemoCustomer

I modified this to receive tracking info from GPS for moving assets and
parties.
the code needs work in the trunk to associate the GEO stuff with an
address and a ontact mech I put in for moving location.
You will need a data inputed from say a mailing walking route to be able
to associated every address in the USA with Geo.
there are some services that do this for Europe as well. not sure about
Asia.


=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/control/automation?forumId=SUPPLYCHAIN>

Specialtymarket.com <http://www.specialtymarket.cos>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
arini.rusda sent the following on 6/14/2011 2:31 AM:

> Hi, Guys
> thanks for the reply.
>
> I understand the relationship between the party postal_address and the
> party_geo_point.
>
> so CMIIW, beside from webtools, there's no particular screen in party/SFA
> component (like editcontachmech.ftl for editing party_contact_mech) to add
> geo_point to a postal_address of a party?
>
> i'm wondering, is there some functionality when we're inputing some data of
> a party's postal address, ofbiz querying it to google and retrieve the
> lat/long details for the postal address we've entry?
>
> Thanks in advance
>
>
> -----
> Best Regards,
> Arini Rusda
> Informatics Department, Sepuluh Nopember Institute of Technology
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-add-geo-location-to-customer-data-tp3590159p3596074.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[arini.rusda]

Thanks for the reply.

yes, i'm looking for a functionality like that but a little more advanced. i want it when i entry some full address,  the system automatically get the geo point from google geocode API or something like that then put it in the party contact mech, so i don't have to entry the geo point manually for every postal address. Guess i need to do something to the code for that then. Thanks