You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2008/06/30 09:58:40 UTC

Rrelate a duplicated order with the original one [was Re: Latitude, Longitude in PostalAdress]

Thanks Jacopo,

You made my day !

Jacques

From: "Jacopo Cappellato" <ja...@gmail.com>
> Hi Jacques,
>
> On Jun 28, 2008, at 10:31 PM, Jacques Le Roux wrote:
>
>> This makes sense indeed Roland. I vote for since I will certainly  need to add some other data. This is why I thought about 
>> extend- entity in 1st place.
>> I can't see any related entities yet, but this could maybe happen in  future. Waiting for other opinions...
>>
>> Another point I'm interested in : is there a mean/field to relate a  duplicated order with the original one ?
>>
>
> You may consider the OrderItemAssoc entity (adding a new type in the  OrderItemAssocType entity).
>
> Jacopo
>
>
>> Jacques
>>
>> From: "RolandH" <ro...@redvision.de>
>>> Hi Jacques,
>>>
>>> why not a new entity, which can be connected to PostalAddress and  maybe in the future others?
>>> Another questions comes to mind here: more than one Entity may be  at the same LatLong point.
>>> And you're able to save additional data inside the new entity:
>>> datasource (may be intersting when using more than one geocoder:  google, yahoo)
>>> valid from/until
>>>
>>> just another 2 cents,
>>> Roland
>>>
>>> Jacques Le Roux wrote:
>>>> Hi Rob,
>>>>
>>>> I tested with some commercial addresses I will need to locate  (here in France) :  results are not good enough... Morevover the 
>>>> company I will do that for is already using (lat., long.). So I  will really need them. So my question to the community remains 
>>>> :  PostalAddress or extend-entity ?
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>> Jacques
>>>>
>>>> From: "Jacques Le Roux" <ja...@les7arts.com>
>>>>> Thanks Rob,
>>>>>
>>>>> This is an interesting information, I'm just discovering Google  Map API and related...
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Rob Schapper" <ro...@hotwaxmedia.com>
>>>>>> Jacques,
>>>>>>
>>>>>> Wouldn't it make more sense to use the google geocode methods to  get  the lat/long from an address rather then store that 
>>>>>> info in  ofbiz?
>>>>>>
>>>>>> Rob
>>>>>>
>>>>>> On Jun 27, 2008, at 3:59 PM, Jacques Le Roux wrote:
>>>>>>
>>>>>>> Hi Chris,
>>>>>>>
>>>>>>> It was a long time :o), thanks for comments
>>>>>>>
>>>>>>> I need them to use with Google Map. To do something like 
>>>>>>> http://code.google.com/apis/maps/documentation/examples/marker-simple.html
>>>>>>> you can see there map.setCenter(new GLatLng(37.4419,  -122.1419), 13);
>>>>>>>
>>>>>>> Hopefully I will be able to do something general enough to be   reusable (should not be too hard, the tough part is already 
>>>>>>> done by
>>>>>>> Google)
>>>>>>>
>>>>>>> Jacques
>>>>>>>
>>>>>>> From: "Chris Howe" <cj...@yahoo.com>
>>>>>>>> I wasn't going to comment on this because I don't think I have  the  time available to see the discussion through to the 
>>>>>>>> end,  but
>>>>>>>> after reading David's "Data Model Changes Post", I'll toss my  two  cents about this.
>>>>>>>>
>>>>>>>> What are you wanting to ultimately do with Lat/Long?  From my   experience with GeoServer earlier this year, storing 
>>>>>>>> Lat/Long  values
>>>>>>>> is rather inconvenient when doing computations and placing  points  (and polygons) on Maps.  It was much more convenient 
>>>>>>>> to store
>>>>>>>> these points in the manner prescribed by postgis and using  the  methods that are provided in those kinds of packages. 
>>>>>>>> Also, as far
>>>>>>>> as data modeling, it's somewhat innacurate (although depending  on  your application, possibly within acceptable bounds) to 
>>>>>>>> refer to
>>>>>>>> an address as a point that has the specificity you'd be  assigning.
>>>>>>>>
>>>>>>>> Jacques Le Roux <ja...@les7arts.com> wrote: Hi,
>>>>>>>>
>>>>>>>> I will need to add Latitude and Longitude fields in  PostalAdress.  Could this be a change commited ?
>>>>>>>> I will also need to add a type PHONE_HOTLINE in   ContactMechPurposeType.
>>>>>>>>
>>>>>>>> Else, of course I will use
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>
>