Data model question: shipment_route_segment -> vehicle link

[Deyan Tsvetanov]

Hi there,  

I have a question regarding the ofbiz data model.

There is a relationship "shipped_using" between shipment_route_segment
and fixed_asset ( vehicle ) in "The Book".

However in the ofbiz data model there isn't any vehicle relationship
between from either shipment_route_segment or
shipment_package_route_segment.

My question is: what is the rationale ? Is that a miss or a hit ? :)
A bug or a feature ?

Thanks in advance,
Deyan

[Deyan Tsvetanov]

P.S.
I'm sorry , forgot to include the details ...

"The book" - pages 178 - 181 ( Shipment Routing and Shipment Vehicle ).




On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:

> Hi there,  
>
> I have a question regarding the ofbiz data model.
>
> There is a relationship "shipped_using" between shipment_route_segment
> and fixed_asset ( vehicle ) in "The Book".
>
> However in the ofbiz data model there isn't any vehicle relationship
> between from either shipment_route_segment or
> shipment_package_route_segment.
>
> My question is: what is the rationale ? Is that a miss or a hit ? :)
> A bug or a feature ?
>
> Thanks in advance,
> Deyan
>
>

[BJ Freeman]

you will notice on page 179 that a vehicle is a sub type of Fixed
Assets. so if the enterprise owns the vehicle, the Fixed asset is
assigned to the ship using.
otherwise it is shipvia using a carrier ship method
look on page 217 fixed asset assignments.



Deyan Tsvetanov sent the following on 5/11/2009 1:46 PM:

> P.S.
> I'm sorry , forgot to include the details ...
>
> "The book" - pages 178 - 181 ( Shipment Routing and Shipment Vehicle ).
>
>
>
>
> On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:
>> Hi there,  
>>
>> I have a question regarding the ofbiz data model.
>>
>> There is a relationship "shipped_using" between shipment_route_segment
>> and fixed_asset ( vehicle ) in "The Book".
>>
>> However in the ofbiz data model there isn't any vehicle relationship
>> between from either shipment_route_segment or
>> shipment_package_route_segment.
>>
>> My question is: what is the rationale ? Is that a miss or a hit ? :)
>> A bug or a feature ?
>>
>> Thanks in advance,
>> Deyan
>>
>>
>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

[BJ Freeman]

as a side note the book says the reason for a vehicle entity it to track
in its location. Since an asset also needs to be tracked for it location
that is why ofbiz uses the asset.
few months ago some added entities were connected to the assets for give
 lon/lat so the tracking is also done thru the asset entity.

BJ Freeman sent the following on 5/11/2009 3:29 PM:

> you will notice on page 179 that a vehicle is a sub type of Fixed
> Assets. so if the enterprise owns the vehicle, the Fixed asset is
> assigned to the ship using.
> otherwise it is shipvia using a carrier ship method
> look on page 217 fixed asset assignments.
>
>
>
> Deyan Tsvetanov sent the following on 5/11/2009 1:46 PM:
>> P.S.
>> I'm sorry , forgot to include the details ...
>>
>> "The book" - pages 178 - 181 ( Shipment Routing and Shipment Vehicle ).
>>
>>
>>
>>
>> On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:
>>> Hi there,  
>>>
>>> I have a question regarding the ofbiz data model.
>>>
>>> There is a relationship "shipped_using" between shipment_route_segment
>>> and fixed_asset ( vehicle ) in "The Book".
>>>
>>> However in the ofbiz data model there isn't any vehicle relationship
>>> between from either shipment_route_segment or
>>> shipment_package_route_segment.
>>>
>>> My question is: what is the rationale ? Is that a miss or a hit ? :)
>>> A bug or a feature ?
>>>
>>> Thanks in advance,
>>> Deyan
>>>
>>>
>>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

[Deyan Tsvetanov]

Yes, I agree - what you are writing here is what is written in the book.
However I am looking at the OFBiz database tables and I can not find any
relationship between a shipment route segment ( or a package route
segment ) and a fixed asset.

And my question is: what is the reason that such relationship is missing
in the OFBiz data model ? Is it on purpose ?

Just FYI  -  some background for my problem :
What I am trying to achieve is exactly what's written in The Book:

   The relationship to VEHICLE would usually be tracked in circumstances
where the enterprise maintains its own fleet. If the enterprise uses
external car-
riers, the enterprise would probably not need this relationship within
its data
model. Could more than one vehicle be used in a particular SHIPMENT
ROUTE
SEGMENT? For instance, could truck #100 be used and then truck #120 take
 over the route at midpoint? This data model will define this
circumstance as
two shipment route segments; therefore, each route would have one and
only
one vehicle.


I have an enterprise that maintains its own fleet. Therefore I want to
know which exact vehicle ( fixed asset ) is  carrying the shipment.
What the enterprise  also does is handling the packages from one vehicle
to another - the drivers meet somewhere and exchange shipments.
The vehicles also have GPS devices so I do update the GeoPoint entities
to track their geographical location.
So I'm missing the link between a shipment_route_segment ( or a
package_route_segment  - it's even more logical ) and a fixed asset
( vehicle ).

Thanks,
Deyan

On Mon, 2009-05-11 at 15:29 -0700, BJ
Freeman wrote:

> you will notice on page 179 that a vehicle is a sub type of Fixed
> Assets. so if the enterprise owns the vehicle, the Fixed asset is
> assigned to the ship using.
> otherwise it is shipvia using a carrier ship method
> look on page 217 fixed asset assignments.
>
>
>
> Deyan Tsvetanov sent the following on 5/11/2009 1:46 PM:
> > P.S.
> > I'm sorry , forgot to include the details ...
> >
> > "The book" - pages 178 - 181 ( Shipment Routing and Shipment Vehicle ).
> >
> >
> >
> >
> > On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:
> >> Hi there,  
> >>
> >> I have a question regarding the ofbiz data model.
> >>
> >> There is a relationship "shipped_using" between shipment_route_segment
> >> and fixed_asset ( vehicle ) in "The Book".
> >>
> >> However in the ofbiz data model there isn't any vehicle relationship
> >> between from either shipment_route_segment or
> >> shipment_package_route_segment.
> >>
> >> My question is: what is the rationale ? Is that a miss or a hit ? :)
> >> A bug or a feature ?
> >>
> >> Thanks in advance,
> >> Deyan
> >>
> >>
> >
> >
>

[David E Jones-3]

Thanks for your interest and persistence on this Deyan.

Please consider that not every business concept has been modeled and  
implemented in OFBiz and that as time goes on and more and more  
organizations use OFBiz for more and more requirements there is more  
and more implemented in the project.

If this is something you're building and you want to collaborate with  
the community to get it refined and into the project you've started  
out exactly how you should!

It's a great first step to do a sort of "gap analysis" between what  
you need and what is already in the project. Based on that it sounds  
like you have identified a gap so the next step is to design something  
to fill that gap (and it looks like what you've written has already  
started that).

As for how to model it, I agree we need some sort of relationship  
between ShipmentRouteSegment and FixedAsset, and this could be a one-
to-many relationship between a ShipmentRouteSegment and a vehicle  
FixedAsset. However, in order to meet more general needs we may want  
to allow for modeling of multiple vehicles for a specific route  
segment of a shipment. This may not be an issue in the organization  
you are working for, but in some cases a single large shipment that  
does all move together will be split across multiple vehicles (could  
be a convoy of trucks, or could be rail cars... and for rail cars they  
all move together but chances are you'll want to track each car as a  
separate vehicle asset).

Anyway, it's great to have you involved with this and I hope to see  
more from you in the near future.

-David


On May 12, 2009, at 3:15 AM, Deyan Tsvetanov wrote:

> Yes, I agree - what you are writing here is what is written in the  
> book.
> However I am looking at the OFBiz database tables and I can not find  
> any
> relationship between a shipment route segment ( or a package route
> segment ) and a fixed asset.
>
> And my question is: what is the reason that such relationship is  
> missing
> in the OFBiz data model ? Is it on purpose ?
>
> Just FYI  -  some background for my problem :
> What I am trying to achieve is exactly what's written in The Book:
>
>   The relationship to VEHICLE would usually be tracked in  
> circumstances
> where the enterprise maintains its own fleet. If the enterprise uses
> external car-
> riers, the enterprise would probably not need this relationship within
> its data
> model. Could more than one vehicle be used in a particular SHIPMENT
> ROUTE
> SEGMENT? For instance, could truck #100 be used and then truck #120  
> take
> over the route at midpoint? This data model will define this
> circumstance as
> two shipment route segments; therefore, each route would have one and
> only
> one vehicle.
>
>
> I have an enterprise that maintains its own fleet. Therefore I want to
> know which exact vehicle ( fixed asset ) is  carrying the shipment.
> What the enterprise  also does is handling the packages from one  
> vehicle
> to another - the drivers meet somewhere and exchange shipments.
> The vehicles also have GPS devices so I do update the GeoPoint  
> entities
> to track their geographical location.
> So I'm missing the link between a shipment_route_segment ( or a
> package_route_segment  - it's even more logical ) and a fixed asset
> ( vehicle ).
>
> Thanks,
> Deyan
>
> On Mon, 2009-05-11 at 15:29 -0700, BJ
> Freeman wrote:
>
>> you will notice on page 179 that a vehicle is a sub type of Fixed
>> Assets. so if the enterprise owns the vehicle, the Fixed asset is
>> assigned to the ship using.
>> otherwise it is shipvia using a carrier ship method
>> look on page 217 fixed asset assignments.
>>
>>
>>
>> Deyan Tsvetanov sent the following on 5/11/2009 1:46 PM:
>>> P.S.
>>> I'm sorry , forgot to include the details ...
>>>
>>> "The book" - pages 178 - 181 ( Shipment Routing and Shipment  
>>> Vehicle ).
>>>
>>>
>>>
>>>
>>> On Mon, 2009-05-11 at 23:32 +0300, Deyan Tsvetanov wrote:
>>>> Hi there,
>>>>
>>>> I have a question regarding the ofbiz data model.
>>>>
>>>> There is a relationship "shipped_using" between  
>>>> shipment_route_segment
>>>> and fixed_asset ( vehicle ) in "The Book".
>>>>
>>>> However in the ofbiz data model there isn't any vehicle  
>>>> relationship
>>>> between from either shipment_route_segment or
>>>> shipment_package_route_segment.
>>>>
>>>> My question is: what is the rationale ? Is that a miss or a  
>>>> hit ? :)
>>>> A bug or a feature ?
>>>>
>>>> Thanks in advance,
>>>> Deyan
>>>>
>>>>
>>>
>>>
>>