Proper record maintenance in marketing component

[Suraj Khurana]

Hello all,

Currently, I noticed some entities related to *marketing* in OFBiz that
doesn't keep proper record of data such as MarketingCampaignPrice,
MarketingCampaignPromo etc.
I think we can introduce fromDate and thruDate in such entities. as this is
good for history maintenance purpose.
Please let me know your thoughts on this.

--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce <http://www.hotwax.co/>  by  HotWax Systems
<http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010
<https://about.me/surajkhurana?promo=email_sig>

[Rishi Solanki]

Suraj,

I would say, MarketingCampaignPrice and MarketingCampaignPromo are the
intersection entities and its parent entities will have the capabilities to
run the things in the date range.

I mean, in business MarketingCampaign will run in specific time window of
hours or may be of few days or few months. Also in general I couldn't think
of case if Marketing Campaign is over then business would require to add
any other price rules or promos with that. After date if same (or better to
say similar) marketing campaign requires new rules/promos then it should
consider as new marketing campaign with new rules/promos.

The current model is capable of handling all the business requirements. But
from the data model point of view maintaining the association history seems
logical to me.

+1 for the adding the date fields in both entities from my side with
concerns shared above. If we could identify business use cases it may be
applicable would be the best way to proceed.

I'm asking to identify business use cases because I know other intersection
entities won't have the from date and thru date. If we add date fields with
these entities then we should consider them as well.

Quickly I can recall few OrderHeaderWorkEffort, MarketingCampaignRole,
PartyRole, OrderRole etc.


--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: [phone]
http://www.hotwaxsystems.com

On Mon, Jul 31, 2017 at 5:20 PM, Suraj Khurana <
[hidden email]> wrote:

> Hello all,
>
> Currently, I noticed some entities related to *marketing* in OFBiz that
> doesn't keep proper record of data such as MarketingCampaignPrice,
> MarketingCampaignPromo etc.
> I think we can introduce fromDate and thruDate in such entities. as this is
> good for history maintenance purpose.
> Please let me know your thoughts on this.
>
> --
> Thanks and Regards,
> *Suraj Khurana* | Sr. Enterprise Software Engineer
> HotWax Commerce <http://www.hotwax.co/>  by  HotWax Systems
> <http://www.hotwaxsystems.com/>
> Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010
> <https://about.me/surajkhurana?promo=email_sig>
>

[Deepak Dixit-3]

+1 Suraj,

Make sense to add fromDate and thruDate these kind of Assoc entity.


Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Tue, Aug 1, 2017 at 11:11 AM, Rishi Solanki <[hidden email]>
wrote:

> Suraj,
>
> I would say, MarketingCampaignPrice and MarketingCampaignPromo are the
> intersection entities and its parent entities will have the capabilities to
> run the things in the date range.
>
> I mean, in business MarketingCampaign will run in specific time window of
> hours or may be of few days or few months. Also in general I couldn't think
> of case if Marketing Campaign is over then business would require to add
> any other price rules or promos with that. After date if same (or better to
> say similar) marketing campaign requires new rules/promos then it should
> consider as new marketing campaign with new rules/promos.
>
> The current model is capable of handling all the business requirements. But
> from the data model point of view maintaining the association history seems
> logical to me.
>
> +1 for the adding the date fields in both entities from my side with
> concerns shared above. If we could identify business use cases it may be
> applicable would be the best way to proceed.
>
> I'm asking to identify business use cases because I know other intersection
> entities won't have the from date and thru date. If we add date fields with
> these entities then we should consider them as well.
>
> Quickly I can recall few OrderHeaderWorkEffort, MarketingCampaignRole,
> PartyRole, OrderRole etc.
>
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxsystems.com
>
> On Mon, Jul 31, 2017 at 5:20 PM, Suraj Khurana <
> [hidden email]> wrote:
>
> > Hello all,
> >
> > Currently, I noticed some entities related to *marketing* in OFBiz that
> > doesn't keep proper record of data such as MarketingCampaignPrice,
> > MarketingCampaignPromo etc.
> > I think we can introduce fromDate and thruDate in such entities. as this
> is
> > good for history maintenance purpose.
> > Please let me know your thoughts on this.
> >
> > --
> > Thanks and Regards,
> > *Suraj Khurana* | Sr. Enterprise Software Engineer
> > HotWax Commerce <http://www.hotwax.co/>  by  HotWax Systems
> > <http://www.hotwaxsystems.com/>
> > Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010
> > <https://about.me/surajkhurana?promo=email_sig>
> >
>

[Suraj Khurana]

Thanks, Rishi, Deepak.

Created a new Jira issue here.

--

Best Regards,

On Fri, Aug 4, 2017 at 11:26 AM, Deepak Dixit <[hidden email]> wrote:

+1 Suraj,

Make sense to add fromDate and thruDate these kind of Assoc entity.


Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Tue, Aug 1, 2017 at 11:11 AM, Rishi Solanki <[hidden email]>
wrote:

> Suraj,
>
> I would say, MarketingCampaignPrice and MarketingCampaignPromo are the
> intersection entities and its parent entities will have the capabilities to
> run the things in the date range.
>
> I mean, in business MarketingCampaign will run in specific time window of
> hours or may be of few days or few months. Also in general I couldn't think
> of case if Marketing Campaign is over then business would require to add
> any other price rules or promos with that. After date if same (or better to
> say similar) marketing campaign requires new rules/promos then it should
> consider as new marketing campaign with new rules/promos.
>
> The current model is capable of handling all the business requirements. But
> from the data model point of view maintaining the association history seems
> logical to me.
>
> +1 for the adding the date fields in both entities from my side with
> concerns shared above. If we could identify business use cases it may be
> applicable would be the best way to proceed.
>
> I'm asking to identify business use cases because I know other intersection
> entities won't have the from date and thru date. If we add date fields with
> these entities then we should consider them as well.
>
> Quickly I can recall few OrderHeaderWorkEffort, MarketingCampaignRole,
> PartyRole, OrderRole etc.
>
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxsystems.com
>
> On Mon, Jul 31, 2017 at 5:20 PM, Suraj Khurana <
> [hidden email]> wrote:
>
> > Hello all,
> >
> > Currently, I noticed some entities related to *marketing* in OFBiz that
> > doesn't keep proper record of data such as MarketingCampaignPrice,
> > MarketingCampaignPromo etc.
> > I think we can introduce fromDate and thruDate in such entities. as this
> is
> > good for history maintenance purpose.
> > Please let me know your thoughts on this.
> >
> > --
> > Thanks and Regards,
> > *Suraj Khurana* | Sr. Enterprise Software Engineer
> > HotWax Commerce <http://www.hotwax.co/>  by  HotWax Systems
> > <http://www.hotwaxsystems.com/>
> > Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010
> > <https://about.me/surajkhurana?promo=email_sig>
> >
>