Latitude, Longitude in PostalAdress

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

if I remember correctly I know we assigned where the Long and Lat came
from with a enumerated type. This is so you can have more than one
lng/lat per address.
it would seem to me that beyond that the information like you suggest
would not be tied directly to the Postal address entity.

I can see it in say the map interface to each system (yahoo, mapit,
google) which could also be used to store lon/lat.


Jacques Le Roux sent the following on 1/7/2009 10:34 AM:

> Hi,
>
> I'm trying to finally commit our GoePoint entities related modelling.
> For that, I need to introduce the Google Map API key concept (a key
> corresponding to an URL). I previsously suggested general.properties.
> But maybe an entity like the one below would be more convenient in case
> the user would have to deal with more than an handle of URLs
>
>  <entity entity-name="GoogleMapApiKey"
> package-name="org.ofbiz.common.geo"
> default-resource-name="CommonEntityLabels"
>    title="Google Map API key">
>    <field name="UrlId" type="id"></field>
>    <field name="ApiKey" type="long-varchar"></field><!-- As generated
> from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html, note
> that it works for http://localhost !-->
>    <prim-key field="UrlId"/>
>  </entity>
>
> What do you think ?
>
> Thanks
>
> Jacques
>
> From: "Jacques Le Roux" <[hidden email]>
>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>
>> I don't know for Yahoo and other, but I guess it's the same than for
>> Google. You need a key to use their Map API. For Google this
>> key is related to the domain used and allow to use the API only on
>> this domain. So we need to store this information somewhere. I
>> think about general.properties
>>
>> Jacques
>
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJZUHqrP3NbaWWqE4RAv0UAKCrzpxGVDvyY68SzBsJk4o3lJLQSQCghjOS
2CO5V6S50VyldyQbSXOWC/s=
=Y8Xi
-----END PGP SIGNATURE-----

[hans_bakker]

How about using the existing dataresource entity with the
dataresourcetype "URL_RESOURCE" ?

the key can be stored in the DataResourceAttribute .....

On Wed, 2009-01-07 at 19:34 +0100, Jacques Le Roux wrote:

> Hi,
>
> I'm trying to finally commit our GoePoint entities related modelling. For that, I need to introduce the Google Map API key concept
> (a key corresponding to an URL). I previsously suggested general.properties. But maybe an entity like the one below would be more
> convenient in case the user would have to deal with more than an handle of URLs
>
>   <entity entity-name="GoogleMapApiKey" package-name="org.ofbiz.common.geo" default-resource-name="CommonEntityLabels"
>     title="Google Map API key">
>     <field name="UrlId" type="id"></field>
>     <field name="ApiKey" type="long-varchar"></field><!-- As generated from UrlId at
> http://code.google.com/intl/fr/apis/maps/signup.html, note that it works for http://localhost !-->
>     <prim-key field="UrlId"/>
>   </entity>
>
> What do you think ?
>
> Thanks
>
> Jacques
>
> From: "Jacques Le Roux" <[hidden email]>
> > This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
> >
> > I don't know for Yahoo and other, but I guess it's the same than for Google. You need a key to use their Map API. For Google this
> > key is related to the domain used and allow to use the API only on this domain. So we need to store this information somewhere. I
> > think about general.properties
> >
> > Jacques
>

--
Antwebsystems.com: Quality OFBiz services for competitive prices

[David E Jones-3]

That DataResourceType is for data that comes from a URL. When a  
DataResource with that type is rendered it looks at the info string on  
the DataResource to get the URL, and then gets the data from the URL.

I'm not sure if this would apply...

-David


On Jan 7, 2009, at 5:33 PM, Hans Bakker wrote:

> How about using the existing dataresource entity with the
> dataresourcetype "URL_RESOURCE" ?
>
> the key can be stored in the DataResourceAttribute .....
>
> On Wed, 2009-01-07 at 19:34 +0100, Jacques Le Roux wrote:
>> Hi,
>>
>> I'm trying to finally commit our GoePoint entities related  
>> modelling. For that, I need to introduce the Google Map API key  
>> concept
>> (a key corresponding to an URL). I previsously suggested  
>> general.properties. But maybe an entity like the one below would be  
>> more
>> convenient in case the user would have to deal with more than an  
>> handle of URLs
>>
>>  <entity entity-name="GoogleMapApiKey" package-
>> name="org.ofbiz.common.geo" default-resource-
>> name="CommonEntityLabels"
>>    title="Google Map API key">
>>    <field name="UrlId" type="id"></field>
>>    <field name="ApiKey" type="long-varchar"></field><!-- As  
>> generated from UrlId at
>> http://code.google.com/intl/fr/apis/maps/signup.html, note that it  
>> works for http://localhost !-->
>>    <prim-key field="UrlId"/>
>>  </entity>
>>
>> What do you think ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Jacques Le Roux" <[hidden email]>
>>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>>
>>> I don't know for Yahoo and other, but I guess it's the same than  
>>> for Google. You need a key to use their Map API. For Google this
>>> key is related to the domain used and allow to use the API only on  
>>> this domain. So we need to store this information somewhere. I
>>> think about general.properties
>>>
>>> Jacques
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive prices
>

[David E Jones-3]

Jacques,

Could you describe more about this, perhaps where the data comes from  
and how it is used? What other data in the system does it relate to  
and how?

In general for settings that could go into a properties file, or that  
are now in a properties file and are business (not system) related, we  
have talked about putting them in the database. To do so and properly  
organize the data into new fields on new or existing entities the  
basic information above is needed. For the most part they'll probably  
go into generic entities like the preferences, or in big new entities  
with sets of fields for different sets of properties.

Back to this... basically more info would be helpful.

-David


On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:

> Hi,
>
> I'm trying to finally commit our GoePoint entities related  
> modelling. For that, I need to introduce the Google Map API key  
> concept (a key corresponding to an URL). I previsously suggested  
> general.properties. But maybe an entity like the one below would be  
> more convenient in case the user would have to deal with more than  
> an handle of URLs
>
> <entity entity-name="GoogleMapApiKey" package-
> name="org.ofbiz.common.geo" default-resource-name="CommonEntityLabels"
>   title="Google Map API key">
>   <field name="UrlId" type="id"></field>
>   <field name="ApiKey" type="long-varchar"></field><!-- As generated  
> from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html,  
> note that it works for http://localhost !-->
>   <prim-key field="UrlId"/>
> </entity>
>
> What do you think ?
>
> Thanks
>
> Jacques
>
> From: "Jacques Le Roux" <[hidden email]>
>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>
>> I don't know for Yahoo and other, but I guess it's the same than  
>> for Google. You need a key to use their Map API. For Google this
>> key is related to the domain used and allow to use the API only on  
>> this domain. So we need to store this information somewhere. I
>> think about general.properties
>>
>> Jacques
>

[Jacques Le Roux]

Hi David,

Quick answer : these keys are generated by Google Map and used when you want to render a map using Google Map something like
<script
src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese 
keys are system oriented (or at least I guess so), that's why I 1st thought about general.properties. But maybe in some case an user
would like to have this more handy and accessible from DB. I'm not sure though since now properties are cached and it's easy to set
them on the fly. Of course putting them in a property file is easier.The key relates to GeoPoint but only in Google case. I
introduced also these data in CommonTypeData.xml.<DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER" description="Name of GeoPoints
publisher"/>    <DataSource dataSourceId="GEOPT_GOOGLE" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint
supplier"/>    <DataSource dataSourceId="GEOPT_YAHOO" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint
supplier"/>I also created a PartyGeoPointData.xml where dataSourceId is used to know which map rendered (javascript) will be used,
here an example with Google Map<entity-engine-xml>        <GeoType comment="GeoPoint for DemoCustomer"             geoPointId="9000"
dataSourceId="GEOPT_GOOGLE"            latitude="40.297264"            longitude="111.696625"            />
</entity-engine-xml>Thanks

Jacques

From: "David E Jones" <[hidden email]>

>
> Jacques,
>
> Could you describe more about this, perhaps where the data comes from  and how it is used? What other data in the system does it
> relate to  and how?
>
> In general for settings that could go into a properties file, or that  are now in a properties file and are business (not system)
> related, we  have talked about putting them in the database. To do so and properly  organize the data into new fields on new or
> existing entities the  basic information above is needed. For the most part they'll probably  go into generic entities like the
> preferences, or in big new entities  with sets of fields for different sets of properties.
>
> Back to this... basically more info would be helpful.
>
> -David
>
>
> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>
>> Hi,
>>
>> I'm trying to finally commit our GoePoint entities related  modelling. For that, I need to introduce the Google Map API key
>> concept (a key corresponding to an URL). I previsously suggested  general.properties. But maybe an entity like the one below
>> would be  more convenient in case the user would have to deal with more than  an handle of URLs
>>
>> <entity entity-name="GoogleMapApiKey" package- name="org.ofbiz.common.geo" default-resource-name="CommonEntityLabels"
>>   title="Google Map API key">
>>   <field name="UrlId" type="id"></field>
>>   <field name="ApiKey" type="long-varchar"></field><!-- As generated  from UrlId at
>> http://code.google.com/intl/fr/apis/maps/signup.html,  note that it works for http://localhost !-->
>>   <prim-key field="UrlId"/>
>> </entity>
>>
>> What do you think ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Jacques Le Roux" <[hidden email]>
>>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>>
>>> I don't know for Yahoo and other, but I guess it's the same than  for Google. You need a key to use their Map API. For Google
>>> this
>>> key is related to the domain used and allow to use the API only on  this domain. So we need to store this information somewhere.
>>> I
>>> think about general.properties
>>>
>>> Jacques
>>
>

[Jacques Le Roux]

Thanks Hans,

I did not give you enough information.Please see my answer to David.

Jacques

From: "Hans Bakker" <[hidden email]>

> How about using the existing dataresource entity with the
> dataresourcetype "URL_RESOURCE" ?
>
> the key can be stored in the DataResourceAttribute .....
>
> On Wed, 2009-01-07 at 19:34 +0100, Jacques Le Roux wrote:
>> Hi,
>>
>> I'm trying to finally commit our GoePoint entities related modelling. For that, I need to introduce the Google Map API key
>> concept
>> (a key corresponding to an URL). I previsously suggested general.properties. But maybe an entity like the one below would be more
>> convenient in case the user would have to deal with more than an handle of URLs
>>
>>   <entity entity-name="GoogleMapApiKey" package-name="org.ofbiz.common.geo" default-resource-name="CommonEntityLabels"
>>     title="Google Map API key">
>>     <field name="UrlId" type="id"></field>
>>     <field name="ApiKey" type="long-varchar"></field><!-- As generated from UrlId at
>> http://code.google.com/intl/fr/apis/maps/signup.html, note that it works for http://localhost !-->
>>     <prim-key field="UrlId"/>
>>   </entity>
>>
>> What do you think ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Jacques Le Roux" <[hidden email]>
>> > This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>> >
>> > I don't know for Yahoo and other, but I guess it's the same than for Google. You need a key to use their Map API. For Google
>> > this
>> > key is related to the domain used and allow to use the API only on this domain. So we need to store this information somewhere.
>> > I
>> > think about general.properties
>> >
>> > Jacques
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive prices
>

[Jacques Le Roux]

Thanks BJ,

I did not give you enough information.Please see my answer to David.

Jacques

From: "BJ Freeman" <[hidden email]>

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> if I remember correctly I know we assigned where the Long and Lat came
> from with a enumerated type. This is so you can have more than one
> lng/lat per address.
> it would seem to me that beyond that the information like you suggest
> would not be tied directly to the Postal address entity.
>
> I can see it in say the map interface to each system (yahoo, mapit,
> google) which could also be used to store lon/lat.
>
>
> Jacques Le Roux sent the following on 1/7/2009 10:34 AM:
>> Hi,
>>
>> I'm trying to finally commit our GoePoint entities related modelling.
>> For that, I need to introduce the Google Map API key concept (a key
>> corresponding to an URL). I previsously suggested general.properties.
>> But maybe an entity like the one below would be more convenient in case
>> the user would have to deal with more than an handle of URLs
>>
>>  <entity entity-name="GoogleMapApiKey"
>> package-name="org.ofbiz.common.geo"
>> default-resource-name="CommonEntityLabels"
>>    title="Google Map API key">
>>    <field name="UrlId" type="id"></field>
>>    <field name="ApiKey" type="long-varchar"></field><!-- As generated
>> from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html, note
>> that it works for http://localhost !-->
>>    <prim-key field="UrlId"/>
>>  </entity>
>>
>> What do you think ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Jacques Le Roux" <[hidden email]>
>>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>>
>>> I don't know for Yahoo and other, but I guess it's the same than for
>>> Google. You need a key to use their Map API. For Google this
>>> key is related to the domain used and allow to use the API only on
>>> this domain. So we need to store this information somewhere. I
>>> think about general.properties
>>>
>>> Jacques
>>
>>
>>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJZUHqrP3NbaWWqE4RAv0UAKCrzpxGVDvyY68SzBsJk4o3lJLQSQCghjOS
> 2CO5V6S50VyldyQbSXOWC/s=
> =Y8Xi
> -----END PGP SIGNATURE-----
>

[Jacques Le Roux]

Sorry it was not supposed to be so unredeable :(

Quick answer : these keys are generated by Google Map and used when you want to render a map using Google Map something like
<script src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;
key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ

They are system oriented (or at least I guess so), that's why I 1st thought about general.properties. But maybe in some case an user
would like to have this more handy and accessible from DB. I'm not sure though since now properties are cached and it's easy to set
them on the fly. Of course putting them in a property file is easier.

A key relates to GeoPoint but only in Google case. I  introduced also these data in CommonTypeData.xml.

<DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER" description="Name of GeoPoints publisher"/>
    <DataSource dataSourceId="GEOPT_GOOGLE" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint supplier"/>
    <DataSource dataSourceId="GEOPT_YAHOO" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint supplier"/>

I also created a PartyGeoPointData.xml where dataSourceId is used to know which map rendered (javascript) will be used,
here an example with Google Map

<entity-engine-xml>

    <GeoType comment="GeoPoint for DemoCustomer"
            geoPointId="9000"
            dataSourceId="GEOPT_GOOGLE"
            latitude="40.297264"
            longitude="111.696625"
            />
</entity-engine-xml>

Jacques

From: "Jacques Le Roux" <[hidden email]>

> Hi David,
>
> Quick answer : these keys are generated by Google Map and used when you want to render a map using Google Map something like
> <script
> src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese 
> keys are system oriented (or at least I guess so), that's why I 1st thought about general.properties. But maybe in some case an
> user would like to have this more handy and accessible from DB. I'm not sure though since now properties are cached and it's easy
> to set them on the fly. Of course putting them in a property file is easier.The key relates to GeoPoint but only in Google case. I
> introduced also these data in CommonTypeData.xml.<DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER" description="Name of
> GeoPoints publisher"/>    <DataSource dataSourceId="GEOPT_GOOGLE" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as
> GeoPoint supplier"/>    <DataSource dataSourceId="GEOPT_YAHOO" dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint
> supplier"/>I also created a PartyGeoPointData.xml where dataSourceId is used to know which map rendered (javascript) will be used,
> here an example with Google Map<entity-engine-xml>        <GeoType comment="GeoPoint for DemoCustomer"
> geoPointId="9000" dataSourceId="GEOPT_GOOGLE"            latitude="40.297264"            longitude="111.696625"            />
> </entity-engine-xml>Thanks
>
> Jacques
>
> From: "David E Jones" <[hidden email]>
>>
>> Jacques,
>>
>> Could you describe more about this, perhaps where the data comes from  and how it is used? What other data in the system does it
>> relate to  and how?
>>
>> In general for settings that could go into a properties file, or that  are now in a properties file and are business (not system)
>> related, we  have talked about putting them in the database. To do so and properly  organize the data into new fields on new or
>> existing entities the  basic information above is needed. For the most part they'll probably  go into generic entities like the
>> preferences, or in big new entities  with sets of fields for different sets of properties.
>>
>> Back to this... basically more info would be helpful.
>>
>> -David
>>
>>
>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>
>>> Hi,
>>>
>>> I'm trying to finally commit our GoePoint entities related  modelling. For that, I need to introduce the Google Map API key
>>> concept (a key corresponding to an URL). I previsously suggested  general.properties. But maybe an entity like the one below
>>> would be  more convenient in case the user would have to deal with more than  an handle of URLs
>>>
>>> <entity entity-name="GoogleMapApiKey" package- name="org.ofbiz.common.geo" default-resource-name="CommonEntityLabels"
>>>   title="Google Map API key">
>>>   <field name="UrlId" type="id"></field>
>>>   <field name="ApiKey" type="long-varchar"></field><!-- As generated  from UrlId at
>>> http://code.google.com/intl/fr/apis/maps/signup.html,  note that it works for http://localhost !-->
>>>   <prim-key field="UrlId"/>
>>> </entity>
>>>
>>> What do you think ?
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>> From: "Jacques Le Roux" <[hidden email]>
>>>> This is related to https://issues.apache.org/jira/browse/OFBIZ-1923
>>>>
>>>> I don't know for Yahoo and other, but I guess it's the same than  for Google. You need a key to use their Map API. For Google
>>>> this
>>>> key is related to the domain used and allow to use the API only on  this domain. So we need to store this information
>>>> somewhere. I
>>>> think about general.properties
>>>>
>>>> Jacques
>>>
>>
>

[David E Jones-3]

Sounds like it might as well go into a properties file for now, and  
later on as more are migrated when we design a suitable data model for  
a larger number of properties we can move it over with the others.

It's a lot like things in payment.properties and other similar files.

-David


On Jan 7, 2009, at 10:43 PM, Jacques Le Roux wrote:

> Sorry it was not supposed to be so unredeable :(
>
> Quick answer : these keys are generated by Google Map and used when  
> you want to render a map using Google Map something like
> <script src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;
> key=ABQIAAAA-O3c-
> Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ
>
> They are system oriented (or at least I guess so), that's why I 1st  
> thought about general.properties. But maybe in some case an user
> would like to have this more handy and accessible from DB. I'm not  
> sure though since now properties are cached and it's easy to set
> them on the fly. Of course putting them in a property file is easier.
>
> A key relates to GeoPoint but only in Google case. I  introduced  
> also these data in CommonTypeData.xml.
>
> <DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER"  
> description="Name of GeoPoints publisher"/>
>   <DataSource dataSourceId="GEOPT_GOOGLE"  
> dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint  
> supplier"/>
>   <DataSource dataSourceId="GEOPT_YAHOO"  
> dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint  
> supplier"/>
>
> I also created a PartyGeoPointData.xml where dataSourceId is used to  
> know which map rendered (javascript) will be used,
> here an example with Google Map
>
> <entity-engine-xml>
>
>   <GeoType comment="GeoPoint for DemoCustomer"
>           geoPointId="9000"
>           dataSourceId="GEOPT_GOOGLE"
>           latitude="40.297264"
>           longitude="111.696625"
>           />
> </entity-engine-xml>
>
> Jacques
>
> From: "Jacques Le Roux" <[hidden email]>
>> Hi David,
>>
>> Quick answer : these keys are generated by Google Map and used when  
>> you want to render a map using Google Map something like
>> <script src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese 
>>  keys are system oriented (or at least I guess so), that's why I  
>> 1st thought about general.properties. But maybe in some case an  
>> user would like to have this more handy and accessible from DB. I'm  
>> not sure though since now properties are cached and it's easy to  
>> set them on the fly. Of course putting them in a property file is  
>> easier.The key relates to GeoPoint but only in Google case. I  
>> introduced also these data in CommonTypeData.xml.<DataSourceType  
>> dataSourceTypeId="GEOPOINT_SUPPLIER" description="Name of GeoPoints  
>> publisher"/>    <DataSource dataSourceId="GEOPT_GOOGLE"  
>> dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as  
>> GeoPoint supplier"/>    <DataSource dataSourceId="GEOPT_YAHOO"  
>> dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint  
>> supplier"/>I also created a PartyGeoPointData.xml where  
>> dataSourceId is used to know which map rendered (javascript) will  
>> be used, here an example with Google Map<entity-engine-xml>        
>> <GeoType comment="GeoPoint for DemoCustomer" geoPointId="9000"  
>> dataSourceId="GEOPT_GOOGLE"            
>> latitude="40.297264"            longitude="111.696625"            /
>> > </entity-engine-xml>Thanks
>>
>> Jacques
>>
>> From: "David E Jones" <[hidden email]>
>>>
>>> Jacques,
>>>
>>> Could you describe more about this, perhaps where the data comes  
>>> from  and how it is used? What other data in the system does it  
>>> relate to  and how?
>>>
>>> In general for settings that could go into a properties file, or  
>>> that  are now in a properties file and are business (not system)  
>>> related, we  have talked about putting them in the database. To do  
>>> so and properly  organize the data into new fields on new or  
>>> existing entities the  basic information above is needed. For the  
>>> most part they'll probably  go into generic entities like the  
>>> preferences, or in big new entities  with sets of fields for  
>>> different sets of properties.
>>>
>>> Back to this... basically more info would be helpful.
>>>
>>> -David
>>>
>>>
>>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>>
>>>> Hi,
>>>>
>>>> I'm trying to finally commit our GoePoint entities related  
>>>> modelling. For that, I need to introduce the Google Map API key  
>>>> concept (a key corresponding to an URL). I previsously suggested  
>>>> general.properties. But maybe an entity like the one below would  
>>>> be  more convenient in case the user would have to deal with more  
>>>> than  an handle of URLs
>>>>
>>>> <entity entity-name="GoogleMapApiKey" package-  
>>>> name="org.ofbiz.common.geo" default-resource-
>>>> name="CommonEntityLabels"
>>>>  title="Google Map API key">
>>>>  <field name="UrlId" type="id"></field>
>>>>  <field name="ApiKey" type="long-varchar"></field><!-- As  
>>>> generated  from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html 
>>>> ,  note that it works for http://localhost !-->
>>>>  <prim-key field="UrlId"/>
>>>> </entity>
>>>>
>>>> What do you think ?
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>> This is related to https://issues.apache.org/jira/browse/ 
>>>>> OFBIZ-1923
>>>>>
>>>>> I don't know for Yahoo and other, but I guess it's the same  
>>>>> than  for Google. You need a key to use their Map API. For  
>>>>> Google this
>>>>> key is related to the domain used and allow to use the API only  
>>>>> on  this domain. So we need to store this information somewhere. I
>>>>> think about general.properties
>>>>>
>>>>> Jacques
>>>>
>>>
>

[Jacques Le Roux]

I put a patch ready to be commited in https://issues.apache.org/jira/browse/OFBIZ-1923.
I will not be much available these next days, but I hope to commit it this week and to expand later (for Postal Addresses,
Facilites, Containers, and Fixed Assets)

Jacques

From: "David E Jones" <[hidden email]>

>
> Sounds like it might as well go into a properties file for now, and  later on as more are migrated when we design a suitable data
> model for  a larger number of properties we can move it over with the others.
>
> It's a lot like things in payment.properties and other similar files.
>
> -David
>
>
> On Jan 7, 2009, at 10:43 PM, Jacques Le Roux wrote:
>
>> Sorry it was not supposed to be so unredeable :(
>>
>> Quick answer : these keys are generated by Google Map and used when  you want to render a map using Google Map something like
>> <script src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;
>> key=ABQIAAAA-O3c- Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ
>>
>> They are system oriented (or at least I guess so), that's why I 1st  thought about general.properties. But maybe in some case an
>> user
>> would like to have this more handy and accessible from DB. I'm not  sure though since now properties are cached and it's easy to
>> set
>> them on the fly. Of course putting them in a property file is easier.
>>
>> A key relates to GeoPoint but only in Google case. I  introduced  also these data in CommonTypeData.xml.
>>
>> <DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER"  description="Name of GeoPoints publisher"/>
>>   <DataSource dataSourceId="GEOPT_GOOGLE"  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint  supplier"/>
>>   <DataSource dataSourceId="GEOPT_YAHOO"  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint  supplier"/>
>>
>> I also created a PartyGeoPointData.xml where dataSourceId is used to  know which map rendered (javascript) will be used,
>> here an example with Google Map
>>
>> <entity-engine-xml>
>>
>>   <GeoType comment="GeoPoint for DemoCustomer"
>>           geoPointId="9000"
>>           dataSourceId="GEOPT_GOOGLE"
>>           latitude="40.297264"
>>           longitude="111.696625"
>>           />
>> </entity-engine-xml>
>>
>> Jacques
>>
>> From: "Jacques Le Roux" <[hidden email]>
>>> Hi David,
>>>
>>> Quick answer : these keys are generated by Google Map and used when  you want to render a map using Google Map something like
>>> <script
>>> src=http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese 
>>> keys are system oriented (or at least I guess so), that's why I  1st thought about general.properties. But maybe in some case an
>>> user would like to have this more handy and accessible from DB. I'm  not sure though since now properties are cached and it's
>>> easy to  set them on the fly. Of course putting them in a property file is  easier.The key relates to GeoPoint but only in
>>> Google case. I  introduced also these data in CommonTypeData.xml.<DataSourceType  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>> description="Name of GeoPoints  publisher"/>    <DataSource dataSourceId="GEOPT_GOOGLE"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>> description="Google as  GeoPoint supplier"/>    <DataSource dataSourceId="GEOPT_YAHOO"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>> description="Yahoo as GeoPoint  supplier"/>I also created a PartyGeoPointData.xml where  dataSourceId is used to know which map
>>> rendered (javascript) will  be used, here an example with Google Map<entity-engine-xml>         <GeoType comment="GeoPoint for
>>> DemoCustomer" geoPointId="9000"  dataSourceId="GEOPT_GOOGLE"             latitude="40.297264"            longitude="111.696625"
>>> /
>>> > </entity-engine-xml>Thanks
>>>
>>> Jacques
>>>
>>> From: "David E Jones" <[hidden email]>
>>>>
>>>> Jacques,
>>>>
>>>> Could you describe more about this, perhaps where the data comes  from  and how it is used? What other data in the system does
>>>> it  relate to  and how?
>>>>
>>>> In general for settings that could go into a properties file, or  that  are now in a properties file and are business (not
>>>> system)  related, we  have talked about putting them in the database. To do  so and properly  organize the data into new fields
>>>> on new or  existing entities the  basic information above is needed. For the  most part they'll probably  go into generic
>>>> entities like the  preferences, or in big new entities  with sets of fields for  different sets of properties.
>>>>
>>>> Back to this... basically more info would be helpful.
>>>>
>>>> -David
>>>>
>>>>
>>>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I'm trying to finally commit our GoePoint entities related   modelling. For that, I need to introduce the Google Map API key
>>>>> concept (a key corresponding to an URL). I previsously suggested   general.properties. But maybe an entity like the one below
>>>>> would  be  more convenient in case the user would have to deal with more  than  an handle of URLs
>>>>>
>>>>> <entity entity-name="GoogleMapApiKey" package-  name="org.ofbiz.common.geo" default-resource- name="CommonEntityLabels"
>>>>>  title="Google Map API key">
>>>>>  <field name="UrlId" type="id"></field>
>>>>>  <field name="ApiKey" type="long-varchar"></field><!-- As  generated  from UrlId at
>>>>> http://code.google.com/intl/fr/apis/maps/signup.html ,  note that it works for http://localhost !-->
>>>>>  <prim-key field="UrlId"/>
>>>>> </entity>
>>>>>
>>>>> What do you think ?
>>>>>
>>>>> Thanks
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>>> This is related to https://issues.apache.org/jira/browse/ OFBIZ-1923
>>>>>>
>>>>>> I don't know for Yahoo and other, but I guess it's the same  than  for Google. You need a key to use their Map API. For
>>>>>> Google this
>>>>>> key is related to the domain used and allow to use the API only  on  this domain. So we need to store this information
>>>>>> somewhere. I
>>>>>> think about general.properties
>>>>>>
>>>>>> Jacques
>>>>>
>>>>
>>
>

[guo weizhan]

Jacques ,

It's very useful, we have try do this before.

Thank you!


2009/1/11, Jacques Le Roux <[hidden email]>:

>
> I put a patch ready to be commited in
> https://issues.apache.org/jira/browse/OFBIZ-1923.
> I will not be much available these next days, but I hope to commit it this
> week and to expand later (for Postal Addresses, Facilites, Containers, and
> Fixed Assets)
>
> Jacques
>
> From: "David E Jones" <[hidden email]>
>
>>
>> Sounds like it might as well go into a properties file for now, and  later
>> on as more are migrated when we design a suitable data model for  a larger
>> number of properties we can move it over with the others.
>>
>> It's a lot like things in payment.properties and other similar files.
>>
>> -David
>>
>>
>> On Jan 7, 2009, at 10:43 PM, Jacques Le Roux wrote:
>>
>> Sorry it was not supposed to be so unredeable :(
>>>
>>> Quick answer : these keys are generated by Google Map and used when  you
>>> want to render a map using Google Map something like
>>> <script src=http://maps.google.com/maps?file=api&amp;v=2.73&amp<http://maps.google.com/maps?file=api&v=2.73&amp>
>>> ;
>>> key=ABQIAAAA-O3c-
>>> Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ
>>>
>>> They are system oriented (or at least I guess so), that's why I 1st
>>>  thought about general.properties. But maybe in some case an user
>>> would like to have this more handy and accessible from DB. I'm not  sure
>>> though since now properties are cached and it's easy to set
>>> them on the fly. Of course putting them in a property file is easier.
>>>
>>> A key relates to GeoPoint but only in Google case. I  introduced  also
>>> these data in CommonTypeData.xml.
>>>
>>> <DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER"  description="Name
>>> of GeoPoints publisher"/>
>>>  <DataSource dataSourceId="GEOPT_GOOGLE"
>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint
>>>  supplier"/>
>>>  <DataSource dataSourceId="GEOPT_YAHOO"
>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint
>>>  supplier"/>
>>>
>>> I also created a PartyGeoPointData.xml where dataSourceId is used to
>>>  know which map rendered (javascript) will be used,
>>> here an example with Google Map
>>>
>>> <entity-engine-xml>
>>>
>>>  <GeoType comment="GeoPoint for DemoCustomer"
>>>          geoPointId="9000"
>>>          dataSourceId="GEOPT_GOOGLE"
>>>          latitude="40.297264"
>>>          longitude="111.696625"
>>>          />
>>> </entity-engine-xml>
>>>
>>> Jacques
>>>
>>> From: "Jacques Le Roux" <[hidden email]>
>>>
>>>> Hi David,
>>>>
>>>> Quick answer : these keys are generated by Google Map and used when  you
>>>> want to render a map using Google Map something like
>>>> <script src=
>>>> http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese<http://maps.google.com/maps?file=api&v=2.73&key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese>keys are system oriented (or at least I guess so), that's why I  1st thought
>>>> about general.properties. But maybe in some case an user would like to have
>>>> this more handy and accessible from DB. I'm  not sure though since now
>>>> properties are cached and it's easy to  set them on the fly. Of course
>>>> putting them in a property file is  easier.The key relates to GeoPoint but
>>>> only in Google case. I  introduced also these data in
>>>> CommonTypeData.xml.<DataSourceType  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>> description="Name of GeoPoints  publisher"/>    <DataSource
>>>> dataSourceId="GEOPT_GOOGLE"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>> description="Google as  GeoPoint supplier"/>    <DataSource
>>>> dataSourceId="GEOPT_YAHOO"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>> description="Yahoo as GeoPoint  supplier"/>I also created a
>>>> PartyGeoPointData.xml where  dataSourceId is used to know which map rendered
>>>> (javascript) will  be used, here an example with Google
>>>> Map<entity-engine-xml>         <GeoType comment="GeoPoint for DemoCustomer"
>>>> geoPointId="9000"  dataSourceId="GEOPT_GOOGLE"
>>>> latitude="40.297264"            longitude="111.696625" /
>>>> > </entity-engine-xml>Thanks
>>>>
>>>> Jacques
>>>>
>>>> From: "David E Jones" <[hidden email]>
>>>>
>>>>>
>>>>> Jacques,
>>>>>
>>>>> Could you describe more about this, perhaps where the data comes  from
>>>>>  and how it is used? What other data in the system does it  relate to  and
>>>>> how?
>>>>>
>>>>> In general for settings that could go into a properties file, or  that
>>>>>  are now in a properties file and are business (not system)  related, we
>>>>>  have talked about putting them in the database. To do  so and properly
>>>>>  organize the data into new fields on new or  existing entities the  basic
>>>>> information above is needed. For the  most part they'll probably  go into
>>>>> generic entities like the  preferences, or in big new entities  with sets of
>>>>> fields for  different sets of properties.
>>>>>
>>>>> Back to this... basically more info would be helpful.
>>>>>
>>>>> -David
>>>>>
>>>>>
>>>>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>>>>
>>>>> Hi,
>>>>>>
>>>>>> I'm trying to finally commit our GoePoint entities related
>>>>>> modelling. For that, I need to introduce the Google Map API key concept (a
>>>>>> key corresponding to an URL). I previsously suggested   general.properties.
>>>>>> But maybe an entity like the one below would  be  more convenient in case
>>>>>> the user would have to deal with more  than  an handle of URLs
>>>>>>
>>>>>> <entity entity-name="GoogleMapApiKey" package-
>>>>>>  name="org.ofbiz.common.geo" default-resource- name="CommonEntityLabels"
>>>>>>  title="Google Map API key">
>>>>>>  <field name="UrlId" type="id"></field>
>>>>>>  <field name="ApiKey" type="long-varchar"></field><!-- As  generated
>>>>>>  from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html ,
>>>>>>  note that it works for http://localhost !-->
>>>>>>  <prim-key field="UrlId"/>
>>>>>> </entity>
>>>>>>
>>>>>> What do you think ?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>>>
>>>>>>> This is related to https://issues.apache.org/jira/browse/ OFBIZ-1923
>>>>>>>
>>>>>>> I don't know for Yahoo and other, but I guess it's the same  than
>>>>>>>  for Google. You need a key to use their Map API. For Google this
>>>>>>> key is related to the domain used and allow to use the API only  on
>>>>>>>  this domain. So we need to store this information somewhere. I
>>>>>>> think about general.properties
>>>>>>>
>>>>>>> Jacques
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>
>>
>

[jacques.le.roux-2]

Hi Guo,

So I suppose you did test it and did not ran into any errors, great !

I will enhance and hopefully commit all this week

Thanks for feedback

Jacques

From: "guo weizhan" <[hidden email]>

> Jacques ,
>
> It's very useful, we have try do this before.
>
> Thank you!
>
>
> 2009/1/11, Jacques Le Roux <[hidden email]>:
>>
>> I put a patch ready to be commited in
>> https://issues.apache.org/jira/browse/OFBIZ-1923.
>> I will not be much available these next days, but I hope to commit it this
>> week and to expand later (for Postal Addresses, Facilites, Containers, and
>> Fixed Assets)
>>
>> Jacques
>>
>> From: "David E Jones" <[hidden email]>
>>
>>>
>>> Sounds like it might as well go into a properties file for now, and  later
>>> on as more are migrated when we design a suitable data model for  a larger
>>> number of properties we can move it over with the others.
>>>
>>> It's a lot like things in payment.properties and other similar files.
>>>
>>> -David
>>>
>>>
>>> On Jan 7, 2009, at 10:43 PM, Jacques Le Roux wrote:
>>>
>>> Sorry it was not supposed to be so unredeable :(
>>>>
>>>> Quick answer : these keys are generated by Google Map and used when  you
>>>> want to render a map using Google Map something like
>>>> <script  
>>>> src=http://maps.google.com/maps?file=api&amp;v=2.73&amp<http://maps.google.com/maps?file=api&v=2.73&amp>
>>>> ;
>>>> key=ABQIAAAA-O3c-
>>>> Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ
>>>>
>>>> They are system oriented (or at least I guess so), that's why I 1st
>>>>  thought about general.properties. But maybe in some case an user
>>>> would like to have this more handy and accessible from DB. I'm not  sure
>>>> though since now properties are cached and it's easy to set
>>>> them on the fly. Of course putting them in a property file is easier.
>>>>
>>>> A key relates to GeoPoint but only in Google case. I  introduced  also
>>>> these data in CommonTypeData.xml.
>>>>
>>>> <DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER"  description="Name
>>>> of GeoPoints publisher"/>
>>>>  <DataSource dataSourceId="GEOPT_GOOGLE"
>>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint
>>>>  supplier"/>
>>>>  <DataSource dataSourceId="GEOPT_YAHOO"
>>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint
>>>>  supplier"/>
>>>>
>>>> I also created a PartyGeoPointData.xml where dataSourceId is used to
>>>>  know which map rendered (javascript) will be used,
>>>> here an example with Google Map
>>>>
>>>> <entity-engine-xml>
>>>>
>>>>  <GeoType comment="GeoPoint for DemoCustomer"
>>>>          geoPointId="9000"
>>>>          dataSourceId="GEOPT_GOOGLE"
>>>>          latitude="40.297264"
>>>>          longitude="111.696625"
>>>>          />
>>>> </entity-engine-xml>
>>>>
>>>> Jacques
>>>>
>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>
>>>>> Hi David,
>>>>>
>>>>> Quick answer : these keys are generated by Google Map and used when  you
>>>>> want to render a map using Google Map something like
>>>>> <script src=
>>>>> http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese<http://maps.google.com/maps?file=api&v=2.73&key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese>keys are system oriented (or at least I guess so), that's why I  1st  
>>>>> thought
>>>>> about general.properties. But maybe in some case an user would  
>>>>> like to have
>>>>> this more handy and accessible from DB. I'm  not sure though since now
>>>>> properties are cached and it's easy to  set them on the fly. Of course
>>>>> putting them in a property file is  easier.The key relates to  
>>>>> GeoPoint but
>>>>> only in Google case. I  introduced also these data in
>>>>> CommonTypeData.xml.<DataSourceType  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>> description="Name of GeoPoints  publisher"/>    <DataSource
>>>>> dataSourceId="GEOPT_GOOGLE"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>> description="Google as  GeoPoint supplier"/>    <DataSource
>>>>> dataSourceId="GEOPT_YAHOO"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>> description="Yahoo as GeoPoint  supplier"/>I also created a
>>>>> PartyGeoPointData.xml where  dataSourceId is used to know which  
>>>>> map rendered
>>>>> (javascript) will  be used, here an example with Google
>>>>> Map<entity-engine-xml>         <GeoType comment="GeoPoint for  
>>>>> DemoCustomer"
>>>>> geoPointId="9000"  dataSourceId="GEOPT_GOOGLE"
>>>>> latitude="40.297264"            longitude="111.696625" /
>>>>> > </entity-engine-xml>Thanks
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "David E Jones" <[hidden email]>
>>>>>
>>>>>>
>>>>>> Jacques,
>>>>>>
>>>>>> Could you describe more about this, perhaps where the data comes  from
>>>>>>  and how it is used? What other data in the system does it  
>>>>>> relate to  and
>>>>>> how?
>>>>>>
>>>>>> In general for settings that could go into a properties file, or  that
>>>>>>  are now in a properties file and are business (not system)  related, we
>>>>>>  have talked about putting them in the database. To do  so and properly
>>>>>>  organize the data into new fields on new or  existing entities  
>>>>>> the  basic
>>>>>> information above is needed. For the  most part they'll  
>>>>>> probably  go into
>>>>>> generic entities like the  preferences, or in big new entities  
>>>>>> with sets of
>>>>>> fields for  different sets of properties.
>>>>>>
>>>>>> Back to this... basically more info would be helpful.
>>>>>>
>>>>>> -David
>>>>>>
>>>>>>
>>>>>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>>>>>
>>>>>> Hi,
>>>>>>>
>>>>>>> I'm trying to finally commit our GoePoint entities related
>>>>>>> modelling. For that, I need to introduce the Google Map API  
>>>>>>> key concept (a
>>>>>>> key corresponding to an URL). I previsously suggested    
>>>>>>> general.properties.
>>>>>>> But maybe an entity like the one below would  be  more  
>>>>>>> convenient in case
>>>>>>> the user would have to deal with more  than  an handle of URLs
>>>>>>>
>>>>>>> <entity entity-name="GoogleMapApiKey" package-
>>>>>>>  name="org.ofbiz.common.geo" default-resource-  
>>>>>>> name="CommonEntityLabels"
>>>>>>>  title="Google Map API key">
>>>>>>>  <field name="UrlId" type="id"></field>
>>>>>>>  <field name="ApiKey" type="long-varchar"></field><!-- As  generated
>>>>>>>  from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html ,
>>>>>>>  note that it works for http://localhost !-->
>>>>>>>  <prim-key field="UrlId"/>
>>>>>>> </entity>
>>>>>>>
>>>>>>> What do you think ?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> Jacques
>>>>>>>
>>>>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>>>>
>>>>>>>> This is related to https://issues.apache.org/jira/browse/ OFBIZ-1923
>>>>>>>>
>>>>>>>> I don't know for Yahoo and other, but I guess it's the same  than
>>>>>>>>  for Google. You need a key to use their Map API. For Google this
>>>>>>>> key is related to the domain used and allow to use the API only  on
>>>>>>>>  this domain. So we need to store this information somewhere. I
>>>>>>>> think about general.properties
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>
>>>
>>
>

[Jacques Le Roux]

Commited in r735404
Look for Geolocation for DemoCustomer in Party.
I will extend later as mentionned below.

Jacques

From: <[hidden email]>

> Hi Guo,
>
> So I suppose you did test it and did not ran into any errors, great !
>
> I will enhance and hopefully commit all this week
>
> Thanks for feedback
>
> Jacques
>
> From: "guo weizhan" <[hidden email]>
>> Jacques ,
>>
>> It's very useful, we have try do this before.
>>
>> Thank you!
>>
>>
>> 2009/1/11, Jacques Le Roux <[hidden email]>:
>>>
>>> I put a patch ready to be commited in
>>> https://issues.apache.org/jira/browse/OFBIZ-1923.
>>> I will not be much available these next days, but I hope to commit it this
>>> week and to expand later (for Postal Addresses, Facilites, Containers, and
>>> Fixed Assets)
>>>
>>> Jacques
>>>
>>> From: "David E Jones" <[hidden email]>
>>>
>>>>
>>>> Sounds like it might as well go into a properties file for now, and  later
>>>> on as more are migrated when we design a suitable data model for  a larger
>>>> number of properties we can move it over with the others.
>>>>
>>>> It's a lot like things in payment.properties and other similar files.
>>>>
>>>> -David
>>>>
>>>>
>>>> On Jan 7, 2009, at 10:43 PM, Jacques Le Roux wrote:
>>>>
>>>> Sorry it was not supposed to be so unredeable :(
>>>>>
>>>>> Quick answer : these keys are generated by Google Map and used when  you
>>>>> want to render a map using Google Map something like
>>>>> <script  src=http://maps.google.com/maps?file=api&amp;v=2.73&amp<http://maps.google.com/maps?file=api&v=2.73&amp>
>>>>> ;
>>>>> key=ABQIAAAA-O3c-
>>>>> Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ
>>>>>
>>>>> They are system oriented (or at least I guess so), that's why I 1st
>>>>>  thought about general.properties. But maybe in some case an user
>>>>> would like to have this more handy and accessible from DB. I'm not  sure
>>>>> though since now properties are cached and it's easy to set
>>>>> them on the fly. Of course putting them in a property file is easier.
>>>>>
>>>>> A key relates to GeoPoint but only in Google case. I  introduced  also
>>>>> these data in CommonTypeData.xml.
>>>>>
>>>>> <DataSourceType dataSourceTypeId="GEOPOINT_SUPPLIER"  description="Name
>>>>> of GeoPoints publisher"/>
>>>>>  <DataSource dataSourceId="GEOPT_GOOGLE"
>>>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Google as GeoPoint
>>>>>  supplier"/>
>>>>>  <DataSource dataSourceId="GEOPT_YAHOO"
>>>>>  dataSourceTypeId="GEOPOINT_SUPPLIER" description="Yahoo as GeoPoint
>>>>>  supplier"/>
>>>>>
>>>>> I also created a PartyGeoPointData.xml where dataSourceId is used to
>>>>>  know which map rendered (javascript) will be used,
>>>>> here an example with Google Map
>>>>>
>>>>> <entity-engine-xml>
>>>>>
>>>>>  <GeoType comment="GeoPoint for DemoCustomer"
>>>>>          geoPointId="9000"
>>>>>          dataSourceId="GEOPT_GOOGLE"
>>>>>          latitude="40.297264"
>>>>>          longitude="111.696625"
>>>>>          />
>>>>> </entity-engine-xml>
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>>
>>>>>> Hi David,
>>>>>>
>>>>>> Quick answer : these keys are generated by Google Map and used when  you
>>>>>> want to render a map using Google Map something like
>>>>>> <script src=
>>>>>> http://maps.google.com/maps?file=api&amp;v=2.73&amp;key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese<http://maps.google.com/maps?file=api&v=2.73&key=ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQThese>keys
>>>>>> are system oriented (or at least I guess so), that's why I  1st  thought
>>>>>> about general.properties. But maybe in some case an user would  like to have
>>>>>> this more handy and accessible from DB. I'm  not sure though since now
>>>>>> properties are cached and it's easy to  set them on the fly. Of course
>>>>>> putting them in a property file is  easier.The key relates to  GeoPoint but
>>>>>> only in Google case. I  introduced also these data in
>>>>>> CommonTypeData.xml.<DataSourceType  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>>> description="Name of GeoPoints  publisher"/>    <DataSource
>>>>>> dataSourceId="GEOPT_GOOGLE"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>>> description="Google as  GeoPoint supplier"/>    <DataSource
>>>>>> dataSourceId="GEOPT_YAHOO"  dataSourceTypeId="GEOPOINT_SUPPLIER"
>>>>>> description="Yahoo as GeoPoint  supplier"/>I also created a
>>>>>> PartyGeoPointData.xml where  dataSourceId is used to know which  map rendered
>>>>>> (javascript) will  be used, here an example with Google
>>>>>> Map<entity-engine-xml>         <GeoType comment="GeoPoint for  DemoCustomer"
>>>>>> geoPointId="9000"  dataSourceId="GEOPT_GOOGLE"
>>>>>> latitude="40.297264"            longitude="111.696625" /
>>>>>> > </entity-engine-xml>Thanks
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>> From: "David E Jones" <[hidden email]>
>>>>>>
>>>>>>>
>>>>>>> Jacques,
>>>>>>>
>>>>>>> Could you describe more about this, perhaps where the data comes  from
>>>>>>>  and how it is used? What other data in the system does it   relate to  and
>>>>>>> how?
>>>>>>>
>>>>>>> In general for settings that could go into a properties file, or  that
>>>>>>>  are now in a properties file and are business (not system)  related, we
>>>>>>>  have talked about putting them in the database. To do  so and properly
>>>>>>>  organize the data into new fields on new or  existing entities  the  basic
>>>>>>> information above is needed. For the  most part they'll  probably  go into
>>>>>>> generic entities like the  preferences, or in big new entities   with sets of
>>>>>>> fields for  different sets of properties.
>>>>>>>
>>>>>>> Back to this... basically more info would be helpful.
>>>>>>>
>>>>>>> -David
>>>>>>>
>>>>>>>
>>>>>>> On Jan 7, 2009, at 10:34 AM, Jacques Le Roux wrote:
>>>>>>>
>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I'm trying to finally commit our GoePoint entities related
>>>>>>>> modelling. For that, I need to introduce the Google Map API  key concept (a
>>>>>>>> key corresponding to an URL). I previsously suggested    general.properties.
>>>>>>>> But maybe an entity like the one below would  be  more  convenient in case
>>>>>>>> the user would have to deal with more  than  an handle of URLs
>>>>>>>>
>>>>>>>> <entity entity-name="GoogleMapApiKey" package-
>>>>>>>>  name="org.ofbiz.common.geo" default-resource-  name="CommonEntityLabels"
>>>>>>>>  title="Google Map API key">
>>>>>>>>  <field name="UrlId" type="id"></field>
>>>>>>>>  <field name="ApiKey" type="long-varchar"></field><!-- As  generated
>>>>>>>>  from UrlId at http://code.google.com/intl/fr/apis/maps/signup.html ,
>>>>>>>>  note that it works for http://localhost !-->
>>>>>>>>  <prim-key field="UrlId"/>
>>>>>>>> </entity>
>>>>>>>>
>>>>>>>> What do you think ?
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>> From: "Jacques Le Roux" <[hidden email]>
>>>>>>>>
>>>>>>>>> This is related to https://issues.apache.org/jira/browse/ OFBIZ-1923
>>>>>>>>>
>>>>>>>>> I don't know for Yahoo and other, but I guess it's the same  than
>>>>>>>>>  for Google. You need a key to use their Map API. For Google this
>>>>>>>>> key is related to the domain used and allow to use the API only  on
>>>>>>>>>  this domain. So we need to store this information somewhere. I
>>>>>>>>> think about general.properties
>>>>>>>>>
>>>>>>>>> Jacques
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>
>>
>