Complete set of Demo Data

[Emad Radwan]

Hi There,

I'm new to OfBiz and hope you help me. For better understanding of the system I need a more completed set of data that coverts all tables as the one provided with the seed data leaves a lot of tables blank. I understand that the model is based on Silverston's books and I really enjoy reading it but still many tables and their purpose are not mentioned there. Thanks in advance. All ideas are welcome.

Regards,

Emsd

[Suraj Khurana-2]

Hello Emad,

Welcome to the OFBiz community. I hope you have tested it by loading demo
data as well. Sometimes, it also helps in clarifying doubts and
understanding seed data requirements.
Also, if required, you can share exact tables that you are looking for
details, so that ML can answer you with respect to the requirements.

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan <[hidden email]> wrote:

> Hi There,
>
> I'm new to OfBiz and hope you help me. For better understanding of the
> system I need a more completed set of data that coverts all tables as the
> one provided with the seed data leaves a lot of tables blank. I understand
> that the model is based on Silverston's books and I really enjoy reading it
> but still many tables and their purpose are not mentioned there. Thanks in
> advance. All ideas are welcome.
>
> Regards,
>
> Emsd
>

[Emad Radwan]

Hi Suraj,

Thanks for replying. As a start, having some data for the following tables would really help:

Party_Attribute
PartyTypeAttr
Party_Classification
Party_Classification_Group

I went thru the Silverston's volume 2 book on the data patterns and was expecting that should be a pattern on 'dynamic attributes' that are utilized in many places in Ofbiz or in volume 1 while discussing Products but couldn't find, and sadly to say that almost all similar table demo data are empty.

Regards,

Emad.

On 2020/10/19 05:38:57, Suraj Khurana <[hidden email]> wrote:

> Hello Emad,
>
> Welcome to the OFBiz community. I hope you have tested it by loading demo
> data as well. Sometimes, it also helps in clarifying doubts and
> understanding seed data requirements.
> Also, if required, you can share exact tables that you are looking for
> details, so that ML can answer you with respect to the requirements.
>
> HTH.
> --
> Best Regards,
> Suraj Khurana
> Senior Technical Consultant
>
>
> On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan <[hidden email]> wrote:
>
> > Hi There,
> >
> > I'm new to OfBiz and hope you help me. For better understanding of the
> > system I need a more completed set of data that coverts all tables as the
> > one provided with the seed data leaves a lot of tables blank. I understand
> > that the model is based on Silverston's books and I really enjoy reading it
> > but still many tables and their purpose are not mentioned there. Thanks in
> > advance. All ideas are welcome.
> >
> > Regards,
> >
> > Emsd
> >
>

[Pritam Kute]

Hello Emad,

To answer your question, yes, all entities are not used in actual OFBiz
implementations but they are kept there to allow the developers to add
custom logic without the need of creating new entities as much as possible.
This is the beauty of the data model that is shipped OOTB with OFBiz.

Attribute entities in general data modelling terms are used to define the
property of an object or an element. The same is the use of Attribute
entity in the OFBiz. So, here, you can define the custom
properties/features of the party which cannot be modelled (ethically :)) in
other entities, they are put into PartyAttribute entity. You can find
Attribute entity in each data model in OFBiz such as OrderAttribute,
ProductAttribute, PartyAttribute etc. PartyTypeAttr is used in
conjunction with PartyAttribute to restrict PartyAttrubutes for based on
partyTypeId.

PartyClassification and PartyClassificationGroup entities are mostly used
in custom logics to classify the parties in groups. We can take an example
of a website which asks the user about the genre of music user likes. We
can add PartyClassificationGroups as an individual genre of music and
relate the party with the genre they like in PartyClassification entity.

Hope this helps.

Kind Regards,
--
Pritam Kute


On Wed, Oct 21, 2020 at 4:06 PM Emad Radwan <[hidden email]> wrote:

> Hi Suraj,
>
> Thanks for replying. As a start, having some data for the following tables
> would really help:
>
> Party_Attribute
> PartyTypeAttr
> Party_Classification
> Party_Classification_Group
>
> I went thru the Silverston's volume 2 book on the data patterns and was
> expecting that should be a pattern on 'dynamic attributes' that are
> utilized in many places in Ofbiz or in volume 1 while discussing Products
> but couldn't find, and sadly to say that almost all similar table demo data
> are empty.
>
> Regards,
>
> Emad.
>
> On 2020/10/19 05:38:57, Suraj Khurana <[hidden email]> wrote:
> > Hello Emad,
> >
> > Welcome to the OFBiz community. I hope you have tested it by loading demo
> > data as well. Sometimes, it also helps in clarifying doubts and
> > understanding seed data requirements.
> > Also, if required, you can share exact tables that you are looking for
> > details, so that ML can answer you with respect to the requirements.
> >
> > HTH.
> > --
> > Best Regards,
> > Suraj Khurana
> > Senior Technical Consultant
> >
> >
> > On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan <[hidden email]>
> wrote:
> >
> > > Hi There,
> > >
> > > I'm new to OfBiz and hope you help me. For better understanding of the
> > > system I need a more completed set of data that coverts all tables as
> the
> > > one provided with the seed data leaves a lot of tables blank. I
> understand
> > > that the model is based on Silverston's books and I really enjoy
> reading it
> > > but still many tables and their purpose are not mentioned there.
> Thanks in
> > > advance. All ideas are welcome.
> > >
> > > Regards,
> > >
> > > Emsd
> > >
> >
>

[Suraj Khurana-2]

Hello Emad,

Please see my comments below:

On Wed, Oct 21, 2020 at 4:06 PM Emad Radwan <[hidden email]> wrote:

> Hi Suraj,
>
> Thanks for replying. As a start, having some data for the following tables
> would really help:
>
> PartyAttribute
>

It is basically used to save any attributes related to Party, not defined
in its PartyType table, exactly like a key value pair having attrName and
attrValue. attrRDesciption is optionally used in case we need to add some
additional information.


> PartyTypeAttr
>

We have a PartyType entity, I am sure you have checked available types
there, widely used types are PERSON and PARTY_GROUP, so data model provides
us flexibility here to define attributes specific to Party types, so that
they can be further drilled down and used as per custom needs.


> PartyClassification
>

It is used to classify Parties, one e-commerce example use case for quick
understanding is, if we can have promotions running for some special
customers, they all can be added into certain party classification and
promotion rules can be defined for that classification.


> PartyClassificationGroup
>

If in any case we have 'n' number of classifications available for parties
and we want to group them based on certain characteristics / user defined
rules, we have this entity to accommodate the purpose. Promotion engine
also supports classification groups, so the same e-comm example fits here
as well.


>
> I went thru the Silverston's volume 2 book on the data patterns and was
> expecting that should be a pattern on 'dynamic attributes' that are
> utilized in many places in Ofbiz or in volume 1 while discussing Products
> but couldn't find, and sadly to say that almost all similar table demo data
> are empty.
>
>
This confluence page might also be helpful to you, while you explore OFBiz
data model.
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams

HTH
--
Best Regards,
Suraj Khurana
Senior Technical Consultant

> On 2020/10/19 05:38:57, Suraj Khurana <[hidden email]> wrote:
> > Hello Emad,
> >
> > Welcome to the OFBiz community. I hope you have tested it by loading demo
> > data as well. Sometimes, it also helps in clarifying doubts and
> > understanding seed data requirements.
> > Also, if required, you can share exact tables that you are looking for
> > details, so that ML can answer you with respect to the requirements.
> >
> > HTH.
> > --
> > Best Regards,
> > Suraj Khurana
> > Senior Technical Consultant
> >
> >
> > On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan <[hidden email]>
> wrote:
> >
> > > Hi There,
> > >
> > > I'm new to OfBiz and hope you help me. For better understanding of the
> > > system I need a more completed set of data that coverts all tables as
> the
> > > one provided with the seed data leaves a lot of tables blank. I
> understand
> > > that the model is based on Silverston's books and I really enjoy
> reading it
> > > but still many tables and their purpose are not mentioned there.
> Thanks in
> > > advance. All ideas are welcome.
> > >
> > > Regards,
> > >
> > > Emsd
> > >
> >
>

[Emad Radwan]

Many thanks Pritam and Suraj for the valuable info.

On Wed, Oct 21, 2020 at 7:45 PM Suraj Khurana <[hidden email]>
wrote:

> Hello Emad,
>
> Please see my comments below:
>
> On Wed, Oct 21, 2020 at 4:06 PM Emad Radwan <[hidden email]> wrote:
>
> > Hi Suraj,
> >
> > Thanks for replying. As a start, having some data for the following
> tables
> > would really help:
> >
> > PartyAttribute
> >
>
> It is basically used to save any attributes related to Party, not defined
> in its PartyType table, exactly like a key value pair having attrName and
> attrValue. attrRDesciption is optionally used in case we need to add some
> additional information.
>
>
> > PartyTypeAttr
> >
>
> We have a PartyType entity, I am sure you have checked available types
> there, widely used types are PERSON and PARTY_GROUP, so data model provides
> us flexibility here to define attributes specific to Party types, so that
> they can be further drilled down and used as per custom needs.
>
>
> > PartyClassification
> >
>
> It is used to classify Parties, one e-commerce example use case for quick
> understanding is, if we can have promotions running for some special
> customers, they all can be added into certain party classification and
> promotion rules can be defined for that classification.
>
>
> > PartyClassificationGroup
> >
>
> If in any case we have 'n' number of classifications available for parties
> and we want to group them based on certain characteristics / user defined
> rules, we have this entity to accommodate the purpose. Promotion engine
> also supports classification groups, so the same e-comm example fits here
> as well.
>
>
> >
> > I went thru the Silverston's volume 2 book on the data patterns and was
> > expecting that should be a pattern on 'dynamic attributes' that are
> > utilized in many places in Ofbiz or in volume 1 while discussing Products
> > but couldn't find, and sadly to say that almost all similar table demo
> data
> > are empty.
> >
> >
> This confluence page might also be helpful to you, while you explore OFBiz
> data model.
> https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
>
> HTH
> --
> Best Regards,
> Suraj Khurana
> Senior Technical Consultant
>
>
> > On 2020/10/19 05:38:57, Suraj Khurana <[hidden email]> wrote:
> > > Hello Emad,
> > >
> > > Welcome to the OFBiz community. I hope you have tested it by loading
> demo
> > > data as well. Sometimes, it also helps in clarifying doubts and
> > > understanding seed data requirements.
> > > Also, if required, you can share exact tables that you are looking for
> > > details, so that ML can answer you with respect to the requirements.
> > >
> > > HTH.
> > > --
> > > Best Regards,
> > > Suraj Khurana
> > > Senior Technical Consultant
> > >
> > >
> > > On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan <[hidden email]>
> > wrote:
> > >
> > > > Hi There,
> > > >
> > > > I'm new to OfBiz and hope you help me. For better understanding of
> the
> > > > system I need a more completed set of data that coverts all tables as
> > the
> > > > one provided with the seed data leaves a lot of tables blank. I
> > understand
> > > > that the model is based on Silverston's books and I really enjoy
> > reading it
> > > > but still many tables and their purpose are not mentioned there.
> > Thanks in
> > > > advance. All ideas are welcome.
> > > >
> > > > Regards,
> > > >
> > > > Emsd
> > > >
> > >
> >
>