Re: [WebERP-developers] Stock Categories Properties issues

[Pak R. <pak...@gm...>]

Hi Phil:

After checking and thinking for few days, it seems ugly to keep these
dimensions in porperties, as we don't have any bullet proof way to compare
them and be sure we transfer the data to the correct one. names can change,
users can forget to update all the names for 1 same property between
categoreies, etc...

Seems too risky for me.

I coded the 3 dimesions as fields in stockmaster. If you agree, I can
commit it to SVN.

Regards,
Ricard


2013/11/1 Phil Daintree <ph...@lo...>

>  No I don't think so we will have to check for the same label as you
> suggest... unless anyone else has any smart ideas?
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 01/11/13 19:09, Pak Ricard wrote:
>
> Hi Phil:
>
>  The detail t solve then is: How we detect if a category property "is the
> same" as another category property in another category? The table
> definition has a stkcatpropid but it's auto_incrment, so we can't use it as
> key. Label is the best candidate if it's used as a code, so in all
> categories, label should be exactly the same.
>
>  is there any other way to solve it?
>
> Regards,
> Ricard
>
>
> 2013/11/1 Phil Daintree <ph...@lo...>
>
>>  Well I think you are right we probably should have implemented weight
>> and volume as category properties as they are not really relevant to some
>> items particularly service items. To deal with changing stock categories
>> correctly I think the correct way is to copy the category properties across
>> if they are not already set up against the new category and then the item
>> category properties can come across correctly too then to the new category
>> item properties.
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>
>>  On 01/11/13 17:23, Pak Ricard wrote:
>>
>>  Hi all:
>>
>>  We are facing a problem with Stock categories properties and would like
>> to ind a good solution for everybody as now we keep the dimensions of
>> stockid as a property in table stockcatproperties.
>>
>>  Problem comes when an item changes stock category (quite often in our
>> case), as we loose the data stored in stockcatproperties (because the
>> stockcatproperties are linked with categoryid).
>>
>>  A solution comes rewriting all stockcatproperties, so if
>> stockcatproperties.label is equal in the new categoryid assigned to the
>> stockid, then we copy all the values to the new stkcatpropid
>>
>>  Another solution can be adding the field size into stockmaster. All
>> physical items have a size (by definition). Services, software, etc no, but
>> also do not have net weight, volume, etc and we kkep this info in
>> stockmaster anyway.
>>
>>  I think the most logical and universal solution is this second one, as
>> the first one will have problems if label is not written exactly the same
>> way, etc etc.
>>
>>  Does everybody agree or there's any other option I'm missing here?
>>
>> Regards,
>> Ricard
>>
>>
>>  ------------------------------------------------------------------------------
>> Android is increasing in popularity, but the open development platform that
>> developers love is also attractive to malware creators. Download this white
>> paper to learn more about secure code signing practices that can help keep
>> Android apps secure.http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
>>
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Android is increasing in popularity, but the open development platform
>> that
>> developers love is also attractive to malware creators. Download this
>> white
>> paper to learn more about secure code signing practices that can help keep
>> Android apps secure.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> Android is increasing in popularity, but the open development platform that
> developers love is also attractive to malware creators. Download this white
> paper to learn more about secure code signing practices that can help keep
> Android apps secure.http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Android is increasing in popularity, but the open development platform that
> developers love is also attractive to malware creators. Download this white
> paper to learn more about secure code signing practices that can help keep
> Android apps secure.
> http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>