Question regarding Catalog management in Ofbiz

[Scott Gray-2]

I believe I've said all I felt the need to say, you are of course free to proceed however you wish.

Regards
Scott

On 1/05/2010, at 1:28 AM, Ruth Hoffman wrote:

> Scott:
>
> First, this mailing list is not about you posting your "beliefs" as regards OFBiz or anything else. This mailing list is suppose to be for the dissemination of facts concerning OFBIz.
>
> Second, What does charging a minimal fee have to do with this discussion?
>
> Third, and most importantly, I am contributing to OFBiz. I just don't have an employer such as HotWax paying my way. That is why I have to charge for these materials. I need to recoup the very real costs of items (such as server hosting) other than my time.
>
> Regards,
> Ruth
> ----------------------------------------------------
> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
> [hidden email]
>
>
> Scott Gray wrote:
>> It's 1am here and I'm not working, I'm contributing to OFBiz and my request had nothing to do with my employer.
>>
>> Let's not forget that the material you're advertising isn't free.
>>
>> I don't have a problem with advertising but this is a discussion forum and I don't believe that your advertising emails do anything to further the discussion.  How about saying something useful and then including your one liner?
>>
>> Regards
>> Scott
>>
>> On 1/05/2010, at 12:56 AM, Ruth Hoffman wrote:
>>
>>  
>>> Thank you Heidi.
>>> FYI, unlike the HotWax sponsored blogs and tutorials, there is nothing on my site that advertises anything but how to get more information about OFBiz.
>>> Regards,
>>> Ruth
>>> ----------------------------------------------------
>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>> [hidden email]
>>>
>>> Info Olagos wrote:
>>>    
>>>> Hello all,
>>>>
>>>> However, i find it a good thing to publish regularly the url from
>>>> www.myofbiz.com .
>>>>
>>>> The documentation of ofbiz is a really difficult one to find exactly what
>>>> you need.
>>>>
>>>> And at this url you immediately know where to find the information.
>>>>
>>>> Regards,
>>>> Heidi
>>>>
>>>> 2010/4/30 Scott Gray <[hidden email]>
>>>>
>>>>      
>>>>> Hi Ruth,
>>>>>
>>>>> This is bordering on spam and starting to get annoying, would you mind
>>>>> trying to contribute to the discussion before starting in with the
>>>>> advertising?
>>>>>
>>>>> Thanks
>>>>> Scott
>>>>>
>>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>>
>>>>>          
>>>>>> Hello List:
>>>>>> If anyone is interested in a more in-depth treatment of the Catalog
>>>>>>              
>>>>> Manager, products, catalogs and categories, please see my book: "Getting
>>>>> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of
>>>>> this at: http://www.myofbiz.com
>>>>>          
>>>>>> Regards,
>>>>>> Ruth
>>>>>> ----------------------------------------------------
>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>>>> [hidden email]
>>>>>>
>>>>>> Paul Abernathy wrote:
>>>>>>              
>>>>>>> BJ,
>>>>>>>
>>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I couldn't
>>>>>>>                  
>>>>> help noticing this discussion because I wanted to do the same thing - set up
>>>>> a hierarchy of categories for products.  I was just going through the
>>>>> business setup guide located at
>>>>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories.  I have a couple
>>>>> of questions:
>>>>>          
>>>>>>> -Can a category be used in more than one Catalog?
>>>>>>> -Can a category have more than one parent?  It looks like the answer is
>>>>>>>                  
>>>>> "no" but just making sure.
>>>>>          
>>>>>>> thanks,
>>>>>>>
>>>>>>> Paul
>>>>>>>
>>>>>>> BJ Freeman wrote:
>>>>>>>                  
>>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>>> I run in the real world over 100,000 products.
>>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>>> I use automated updating from my suppliers to keep thing up-to-date.
>>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>>> availability is as often as 15 min.
>>>>>>>> The average Cpu usage during these operations is about 15% of a 1.6ghz
>>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>>> about 75% when the scheduled services and large imports (1 gig data)
>>>>>>>>                      
>>>>> are
>>>>>          
>>>>>>>> happening.
>>>>>>>>
>>>>>>>>
>>>>>>>> =========================
>>>>>>>> BJ Freeman
>>>>>>>> http://bjfreeman.elance.com
>>>>>>>> Strategic Power Office with Supplier Automation <
>>>>>>>>                      
>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>          
>>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>>
>>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>>
>>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>> Linkedin
>>>>>>>> <
>>>>>>>>                      
>>>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
>>>>>          
>>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>>
>>>>>>>>                      
>>>>>>>>> Hello,
>>>>>>>>>
>>>>>>>>> Thank you for your quick response. Regarding your question about real
>>>>>>>>>                          
>>>>> world
>>>>>          
>>>>>>>>> applications:
>>>>>>>>> Ecommerce:
>>>>>>>>> http://www.rockauto.com/
>>>>>>>>> http://allegro.pl/
>>>>>>>>>
>>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>>> In a PLM industry it's also very common to have a couple of milions of
>>>>>>>>> objects (consider the complexity of a train or a plain for example).
>>>>>>>>>
>>>>>>>>> The point of my post was not a fix, but the implementation of  the
>>>>>>>>>                          
>>>>> find root
>>>>>          
>>>>>>>>> category method.
>>>>>>>>> I think that you should avoid such a code. You have got great database
>>>>>>>>>                          
>>>>> layer
>>>>>          
>>>>>>>>> (great possibility to improve performance)  so it would be great to
>>>>>>>>>                          
>>>>> utilize
>>>>>          
>>>>>>>>> it as much as it's possible.
>>>>>>>>> I really like Ofbiz application thats why I try to give you my input.
>>>>>>>>>
>>>>>>>>> Once again thank you for the response and for the link you send me. I
>>>>>>>>>                          
>>>>> will
>>>>>          
>>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Micha³ Cukierman
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>>> [hidden email]> napisa³:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                          
>>>>>>>>>> For instanc
>>>>>>>>>>
>>>>>>>>>>                              
>>>>>>>>                      
>>>>>>>                  
>>>>>          
>>>>      
>>
>>  

[Scott Gray-2]

I made it up.

http://people.apache.org/~coar/mlists.html#ofbiz.apache.org

Regards
Scott

On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:

>
>
> Scott Gray wrote:
>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>
>>  
>>> Hi Scott:
>>> How so?
>>>    
>>
>> How so what?
>>
>>  
>>> I have useful information concerning how OFBiz works and I want to share that with all interested parties.
>>>    
>>
>> Every time you send this out, over 500 people have to deal with an email that contains no information other than a link to a paid product.  Hardly in keeping with the spirit of an open source mailing list.  Like I said, share some knowledge and then advertise, that way everybody benefits.
>>  
> Really? 500? Where did you come up with that number?
>>  
>>> Are you now the OFBiz information censor?
>>>    
>>
>> Hardly, I'm just a fellow user of this mailing list voicing my concern.
>>
>>  
>>> Regards,
>>> Ruth
>>> ----------------------------------------------------
>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>> [hidden email]
>>>
>>> Scott Gray wrote:
>>>    
>>>> Hi Ruth,
>>>>
>>>> This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising?
>>>>
>>>> Thanks
>>>> Scott
>>>>
>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>
>>>>      
>>>>> Hello List:
>>>>> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com
>>>>>
>>>>> Regards,
>>>>> Ruth
>>>>> ----------------------------------------------------
>>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>>> [hidden email]
>>>>>
>>>>> Paul Abernathy wrote:
>>>>>          
>>>>>> BJ,
>>>>>>
>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products.  I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories.  I have a couple of questions:
>>>>>>
>>>>>> -Can a category be used in more than one Catalog?
>>>>>> -Can a category have more than one parent?  It looks like the answer is "no" but just making sure.
>>>>>>
>>>>>> thanks,
>>>>>>
>>>>>> Paul
>>>>>>
>>>>>> BJ Freeman wrote:
>>>>>>              
>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>> I run in the real world over 100,000 products.
>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>> I use automated updating from my suppliers to keep thing up-to-date.
>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>> availability is as often as 15 min.
>>>>>>> The average Cpu usage during these operations is about 15% of a 1.6ghz
>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>> about 75% when the scheduled services and large imports (1 gig data) are
>>>>>>> happening.
>>>>>>>
>>>>>>>
>>>>>>> =========================
>>>>>>> BJ Freeman
>>>>>>> http://bjfreeman.elance.com
>>>>>>> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>
>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>
>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>> Linkedin
>>>>>>> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>
>>>>>>>                  
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> Thank you for your quick response. Regarding your question about real world
>>>>>>>> applications:
>>>>>>>> Ecommerce:
>>>>>>>> http://www.rockauto.com/
>>>>>>>> http://allegro.pl/
>>>>>>>>
>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>> In a PLM industry it's also very common to have a couple of milions of
>>>>>>>> objects (consider the complexity of a train or a plain for example).
>>>>>>>>
>>>>>>>> The point of my post was not a fix, but the implementation of  the find root
>>>>>>>> category method.
>>>>>>>> I think that you should avoid such a code. You have got great database layer
>>>>>>>> (great possibility to improve performance)  so it would be great to utilize
>>>>>>>> it as much as it's possible.
>>>>>>>> I really like Ofbiz application thats why I try to give you my input.
>>>>>>>>
>>>>>>>> Once again thank you for the response and for the link you send me. I will
>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Micha³ Cukierman
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>> [hidden email]> napisa³:
>>>>>>>>
>>>>>>>>                        
>>>>>>>>> For instanc
>>>>>>>>>                                
>>>>>>>                    
>>>>>>              
>>>>      
>>
>>  

[Heidi Dehaes - Olagos]

Hello,

I think it is a must that we have also the information available from
www.myofbiz.com. For me it is very useful and not commercial if you let only
pay a little bit to pay the hosting costs.

The quality of the material is very high and a must for every ofbiz user.

So i don't see why this information may not be made public as there are also
the ofbiz books listed under the "books" title at the front page of
ofbiz.apache.org .

I hope for the knowledge of every ofbiz user that these
www.myofbiz.comuserguides still maintain available in the future.

Regards,
Heidi



2010/4/30 Scott Gray <[hidden email]>

> I made it up.
>
> http://people.apache.org/~coar/mlists.html#ofbiz.apache.org
>
> Regards
> Scott
>
> On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:
>
> >
> >
> > Scott Gray wrote:
> >> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
> >>
> >>
> >>> Hi Scott:
> >>> How so?
> >>>
> >>
> >> How so what?
> >>
> >>
> >>> I have useful information concerning how OFBiz works and I want to
> share that with all interested parties.
> >>>
> >>
> >> Every time you send this out, over 500 people have to deal with an email
> that contains no information other than a link to a paid product.  Hardly in
> keeping with the spirit of an open source mailing list.  Like I said, share
> some knowledge and then advertise, that way everybody benefits.
> >>
> > Really? 500? Where did you come up with that number?
> >>
> >>> Are you now the OFBiz information censor?
> >>>
> >>
> >> Hardly, I'm just a fellow user of this mailing list voicing my concern.
> >>
> >>
> >>> Regards,
> >>> Ruth
> >>> ----------------------------------------------------
> >>> Find me on the web at http://www.myofbiz.com or Google keyword
> "myofbiz"
> >>> [hidden email]
> >>>
> >>> Scott Gray wrote:
> >>>
> >>>> Hi Ruth,
> >>>>
> >>>> This is bordering on spam and starting to get annoying, would you mind
> trying to contribute to the discussion before starting in with the
> advertising?
> >>>>
> >>>> Thanks
> >>>> Scott
> >>>>
> >>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
> >>>>
> >>>>
> >>>>> Hello List:
> >>>>> If anyone is interested in a more in-depth treatment of the Catalog
> Manager, products, catalogs and categories, please see my book: "Getting
> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of
> this at: http://www.myofbiz.com
> >>>>>
> >>>>> Regards,
> >>>>> Ruth
> >>>>> ----------------------------------------------------
> >>>>> Find me on the web at http://www.myofbiz.com or Google keyword
> "myofbiz"
> >>>>> [hidden email]
> >>>>>
> >>>>> Paul Abernathy wrote:
> >>>>>
> >>>>>> BJ,
> >>>>>>
> >>>>>> I also am new to ofbiz and am trying to learn how to use it.  I
> couldn't help noticing this discussion because I wanted to do the same thing
> - set up a hierarchy of categories for products.  I was just going through
> the business setup guide located at
> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories.  I have a couple
> of questions:
> >>>>>>
> >>>>>> -Can a category be used in more than one Catalog?
> >>>>>> -Can a category have more than one parent?  It looks like the answer
> is "no" but just making sure.
> >>>>>>
> >>>>>> thanks,
> >>>>>>
> >>>>>> Paul
> >>>>>>
> >>>>>> BJ Freeman wrote:
> >>>>>>
> >>>>>>> are you sure you are not referring to 1 million products.
> >>>>>>> I run in the real world over 100,000 products.
> >>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
> >>>>>>> if your see 1,000,000 categories that way then it is feasible.
> >>>>>>> I use automated updating from my suppliers to keep thing
> up-to-date.
> >>>>>>> these updates happen every 24 for prices new and obsolete products.
> >>>>>>> availability is as often as 15 min.
> >>>>>>> The average Cpu usage during these operations is about 15% of a
> 1.6ghz
> >>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
> >>>>>>> about 75% when the scheduled services and large imports (1 gig
> data) are
> >>>>>>> happening.
> >>>>>>>
> >>>>>>>
> >>>>>>> =========================
> >>>>>>> BJ Freeman
> >>>>>>> http://bjfreeman.elance.com
> >>>>>>> Strategic Power Office with Supplier Automation <
> http://www.businessesnetwork.com/automation/viewforum.php?f=93>
> >>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
> >>>>>>>
> >>>>>>> Systems Integrator-- Glad to Assist
> >>>>>>>
> >>>>>>> Chat  Y! messenger: bjfr33man
> >>>>>>> Linkedin
> >>>>>>> <
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >
> >>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
> >>>>>>>
> >>>>>>>
> >>>>>>>> Hello,
> >>>>>>>>
> >>>>>>>> Thank you for your quick response. Regarding your question about
> real world
> >>>>>>>> applications:
> >>>>>>>> Ecommerce:
> >>>>>>>> http://www.rockauto.com/
> >>>>>>>> http://allegro.pl/
> >>>>>>>>
> >>>>>>>> There are applications that holds > 1 000 000 categories.
> >>>>>>>> In a PLM industry it's also very common to have a couple of
> milions of
> >>>>>>>> objects (consider the complexity of a train or a plain for
> example).
> >>>>>>>>
> >>>>>>>> The point of my post was not a fix, but the implementation of  the
> find root
> >>>>>>>> category method.
> >>>>>>>> I think that you should avoid such a code. You have got great
> database layer
> >>>>>>>> (great possibility to improve performance)  so it would be great
> to utilize
> >>>>>>>> it as much as it's possible.
> >>>>>>>> I really like Ofbiz application thats why I try to give you my
> input.
> >>>>>>>>
> >>>>>>>> Once again thank you for the response and for the link you send
> me. I will
> >>>>>>>> come back with the better solution after studing  the datamodel.
> >>>>>>>>
> >>>>>>>> Regards,
> >>>>>>>> Micha³ Cukierman
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
> >>>>>>>> [hidden email]> napisa³:
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>> For instanc
> >>>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>
> >>
> >>
>
>

[Ruth Hoffman-2]

So you did!
Thanks. I didn't know that site existed.
Regards,
Ruth
----------------------------------------------------
Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
[hidden email]

Scott Gray wrote:

> I made it up.
>
> http://people.apache.org/~coar/mlists.html#ofbiz.apache.org
>
> Regards
> Scott
>
> On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:
>
>  
>> Scott Gray wrote:
>>    
>>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>>
>>>  
>>>      
>>>> Hi Scott:
>>>> How so?
>>>>    
>>>>        
>>> How so what?
>>>
>>>  
>>>      
>>>> I have useful information concerning how OFBiz works and I want to share that with all interested parties.
>>>>    
>>>>        
>>> Every time you send this out, over 500 people have to deal with an email that contains no information other than a link to a paid product.  Hardly in keeping with the spirit of an open source mailing list.  Like I said, share some knowledge and then advertise, that way everybody benefits.
>>>  
>>>      
>> Really? 500? Where did you come up with that number?
>>    
>>>  
>>>      
>>>> Are you now the OFBiz information censor?
>>>>    
>>>>        
>>> Hardly, I'm just a fellow user of this mailing list voicing my concern.
>>>
>>>  
>>>      
>>>> Regards,
>>>> Ruth
>>>> ----------------------------------------------------
>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>> [hidden email]
>>>>
>>>> Scott Gray wrote:
>>>>    
>>>>        
>>>>> Hi Ruth,
>>>>>
>>>>> This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising?
>>>>>
>>>>> Thanks
>>>>> Scott
>>>>>
>>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>>
>>>>>      
>>>>>          
>>>>>> Hello List:
>>>>>> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com
>>>>>>
>>>>>> Regards,
>>>>>> Ruth
>>>>>> ----------------------------------------------------
>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>>>> [hidden email]
>>>>>>
>>>>>> Paul Abernathy wrote:
>>>>>>          
>>>>>>            
>>>>>>> BJ,
>>>>>>>
>>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products.  I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories.  I have a couple of questions:
>>>>>>>
>>>>>>> -Can a category be used in more than one Catalog?
>>>>>>> -Can a category have more than one parent?  It looks like the answer is "no" but just making sure.
>>>>>>>
>>>>>>> thanks,
>>>>>>>
>>>>>>> Paul
>>>>>>>
>>>>>>> BJ Freeman wrote:
>>>>>>>              
>>>>>>>              
>>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>>> I run in the real world over 100,000 products.
>>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>>> I use automated updating from my suppliers to keep thing up-to-date.
>>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>>> availability is as often as 15 min.
>>>>>>>> The average Cpu usage during these operations is about 15% of a 1.6ghz
>>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>>> about 75% when the scheduled services and large imports (1 gig data) are
>>>>>>>> happening.
>>>>>>>>
>>>>>>>>
>>>>>>>> =========================
>>>>>>>> BJ Freeman
>>>>>>>> http://bjfreeman.elance.com
>>>>>>>> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>>
>>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>>
>>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>> Linkedin
>>>>>>>> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>>
>>>>>>>>                  
>>>>>>>>                
>>>>>>>>> Hello,
>>>>>>>>>
>>>>>>>>> Thank you for your quick response. Regarding your question about real world
>>>>>>>>> applications:
>>>>>>>>> Ecommerce:
>>>>>>>>> http://www.rockauto.com/
>>>>>>>>> http://allegro.pl/
>>>>>>>>>
>>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>>> In a PLM industry it's also very common to have a couple of milions of
>>>>>>>>> objects (consider the complexity of a train or a plain for example).
>>>>>>>>>
>>>>>>>>> The point of my post was not a fix, but the implementation of  the find root
>>>>>>>>> category method.
>>>>>>>>> I think that you should avoid such a code. You have got great database layer
>>>>>>>>> (great possibility to improve performance)  so it would be great to utilize
>>>>>>>>> it as much as it's possible.
>>>>>>>>> I really like Ofbiz application thats why I try to give you my input.
>>>>>>>>>
>>>>>>>>> Once again thank you for the response and for the link you send me. I will
>>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Micha³ Cukierman
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>>> [hidden email]> napisa³:
>>>>>>>>>
>>>>>>>>>                        
>>>>>>>>>                  
>>>>>>>>>> For instanc
>>>>>>>>>>                                
>>>>>>>>>>                    
>>>>>>>>                    
>>>>>>>>                
>>>>>>>              
>>>>>>>              
>>>>>      
>>>>>          
>>>  
>>>      
>
>  

[Scott Gray-2]

Oh I was joking about the "made it up", I wasn't actually trying to imply that I made that website, in case it came across that way.

Regards
Scott

On 1/05/2010, at 1:53 AM, Ruth Hoffman wrote:

> So you did!
> Thanks. I didn't know that site existed.
> Regards,
> Ruth
> ----------------------------------------------------
> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
> [hidden email]
>
> Scott Gray wrote:
>> I made it up.
>>
>> http://people.apache.org/~coar/mlists.html#ofbiz.apache.org
>>
>> Regards
>> Scott
>>
>> On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:
>>
>>  
>>> Scott Gray wrote:
>>>    
>>>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>>>
>>>>      
>>>>> Hi Scott:
>>>>> How so?
>>>>>          
>>>> How so what?
>>>>
>>>>      
>>>>> I have useful information concerning how OFBiz works and I want to share that with all interested parties.
>>>>>          
>>>> Every time you send this out, over 500 people have to deal with an email that contains no information other than a link to a paid product.  Hardly in keeping with the spirit of an open source mailing list.  Like I said, share some knowledge and then advertise, that way everybody benefits.
>>>>      
>>> Really? 500? Where did you come up with that number?
>>>    
>>>>      
>>>>> Are you now the OFBiz information censor?
>>>>>          
>>>> Hardly, I'm just a fellow user of this mailing list voicing my concern.
>>>>
>>>>      
>>>>> Regards,
>>>>> Ruth
>>>>> ----------------------------------------------------
>>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>>> [hidden email]
>>>>>
>>>>> Scott Gray wrote:
>>>>>          
>>>>>> Hi Ruth,
>>>>>>
>>>>>> This is bordering on spam and starting to get annoying, would you mind trying to contribute to the discussion before starting in with the advertising?
>>>>>>
>>>>>> Thanks
>>>>>> Scott
>>>>>>
>>>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>>>
>>>>>>                
>>>>>>> Hello List:
>>>>>>> If anyone is interested in a more in-depth treatment of the Catalog Manager, products, catalogs and categories, please see my book: "Getting Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of this at: http://www.myofbiz.com
>>>>>>>
>>>>>>> Regards,
>>>>>>> Ruth
>>>>>>> ----------------------------------------------------
>>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>>>>>> [hidden email]
>>>>>>>
>>>>>>> Paul Abernathy wrote:
>>>>>>>                      
>>>>>>>> BJ,
>>>>>>>>
>>>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I couldn't help noticing this discussion because I wanted to do the same thing - set up a hierarchy of categories for products.  I was just going through the business setup guide located at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide and towards the end it discusses how to set up categories.  I have a couple of questions:
>>>>>>>>
>>>>>>>> -Can a category be used in more than one Catalog?
>>>>>>>> -Can a category have more than one parent?  It looks like the answer is "no" but just making sure.
>>>>>>>>
>>>>>>>> thanks,
>>>>>>>>
>>>>>>>> Paul
>>>>>>>>
>>>>>>>> BJ Freeman wrote:
>>>>>>>>                            
>>>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>>>> I run in the real world over 100,000 products.
>>>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>>>> I use automated updating from my suppliers to keep thing up-to-date.
>>>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>>>> availability is as often as 15 min.
>>>>>>>>> The average Cpu usage during these operations is about 15% of a 1.6ghz
>>>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>>>> about 75% when the scheduled services and large imports (1 gig data) are
>>>>>>>>> happening.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> =========================
>>>>>>>>> BJ Freeman
>>>>>>>>> http://bjfreeman.elance.com
>>>>>>>>> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>>>
>>>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>>>
>>>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>>> Linkedin
>>>>>>>>> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>>>
>>>>>>>>>                                  
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> Thank you for your quick response. Regarding your question about real world
>>>>>>>>>> applications:
>>>>>>>>>> Ecommerce:
>>>>>>>>>> http://www.rockauto.com/
>>>>>>>>>> http://allegro.pl/
>>>>>>>>>>
>>>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>>>> In a PLM industry it's also very common to have a couple of milions of
>>>>>>>>>> objects (consider the complexity of a train or a plain for example).
>>>>>>>>>>
>>>>>>>>>> The point of my post was not a fix, but the implementation of  the find root
>>>>>>>>>> category method.
>>>>>>>>>> I think that you should avoid such a code. You have got great database layer
>>>>>>>>>> (great possibility to improve performance)  so it would be great to utilize
>>>>>>>>>> it as much as it's possible.
>>>>>>>>>> I really like Ofbiz application thats why I try to give you my input.
>>>>>>>>>>
>>>>>>>>>> Once again thank you for the response and for the link you send me. I will
>>>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Micha³ Cukierman
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>>>> [hidden email]> napisa³:
>>>>>>>>>>
>>>>>>>>>>                                          
>>>>>>>>>>> For instanc
>>>>>>>>>>>                                                  
>>>>>>>>>                                  
>>>>>>>>                            
>>>>>>                
>>>>      
>>
>>  

[Scott Gray-2]

Heidi,

I'm not out to get Ruth and I'm glad that new users have another source of information available.

Please re-read what I've said, there are lots of ways to let people know about her site and I was simply trying to communicate that I thought it could be done in a better way.

Regards
Scott

On 1/05/2010, at 1:47 AM, Info Olagos wrote:

> Hello,
>
> I think it is a must that we have also the information available from
> www.myofbiz.com. For me it is very useful and not commercial if you let only
> pay a little bit to pay the hosting costs.
>
> The quality of the material is very high and a must for every ofbiz user.
>
> So i don't see why this information may not be made public as there are also
> the ofbiz books listed under the "books" title at the front page of
> ofbiz.apache.org .
>
> I hope for the knowledge of every ofbiz user that these
> www.myofbiz.comuserguides still maintain available in the future.
>
> Regards,
> Heidi
>
>
>
> 2010/4/30 Scott Gray <[hidden email]>
>
>> I made it up.
>>
>> http://people.apache.org/~coar/mlists.html#ofbiz.apache.org
>>
>> Regards
>> Scott
>>
>> On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:
>>
>>>
>>>
>>> Scott Gray wrote:
>>>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>>>
>>>>
>>>>> Hi Scott:
>>>>> How so?
>>>>>
>>>>
>>>> How so what?
>>>>
>>>>
>>>>> I have useful information concerning how OFBiz works and I want to
>> share that with all interested parties.
>>>>>
>>>>
>>>> Every time you send this out, over 500 people have to deal with an email
>> that contains no information other than a link to a paid product.  Hardly in
>> keeping with the spirit of an open source mailing list.  Like I said, share
>> some knowledge and then advertise, that way everybody benefits.
>>>>
>>> Really? 500? Where did you come up with that number?
>>>>
>>>>> Are you now the OFBiz information censor?
>>>>>
>>>>
>>>> Hardly, I'm just a fellow user of this mailing list voicing my concern.
>>>>
>>>>
>>>>> Regards,
>>>>> Ruth
>>>>> ----------------------------------------------------
>>>>> Find me on the web at http://www.myofbiz.com or Google keyword
>> "myofbiz"
>>>>> [hidden email]
>>>>>
>>>>> Scott Gray wrote:
>>>>>
>>>>>> Hi Ruth,
>>>>>>
>>>>>> This is bordering on spam and starting to get annoying, would you mind
>> trying to contribute to the discussion before starting in with the
>> advertising?
>>>>>>
>>>>>> Thanks
>>>>>> Scott
>>>>>>
>>>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>>>
>>>>>>
>>>>>>> Hello List:
>>>>>>> If anyone is interested in a more in-depth treatment of the Catalog
>> Manager, products, catalogs and categories, please see my book: "Getting
>> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of
>> this at: http://www.myofbiz.com
>>>>>>>
>>>>>>> Regards,
>>>>>>> Ruth
>>>>>>> ----------------------------------------------------
>>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword
>> "myofbiz"
>>>>>>> [hidden email]
>>>>>>>
>>>>>>> Paul Abernathy wrote:
>>>>>>>
>>>>>>>> BJ,
>>>>>>>>
>>>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I
>> couldn't help noticing this discussion because I wanted to do the same thing
>> - set up a hierarchy of categories for products.  I was just going through
>> the business setup guide located at
>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories.  I have a couple
>> of questions:
>>>>>>>>
>>>>>>>> -Can a category be used in more than one Catalog?
>>>>>>>> -Can a category have more than one parent?  It looks like the answer
>> is "no" but just making sure.
>>>>>>>>
>>>>>>>> thanks,
>>>>>>>>
>>>>>>>> Paul
>>>>>>>>
>>>>>>>> BJ Freeman wrote:
>>>>>>>>
>>>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>>>> I run in the real world over 100,000 products.
>>>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>>>> I use automated updating from my suppliers to keep thing
>> up-to-date.
>>>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>>>> availability is as often as 15 min.
>>>>>>>>> The average Cpu usage during these operations is about 15% of a
>> 1.6ghz
>>>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>>>> about 75% when the scheduled services and large imports (1 gig
>> data) are
>>>>>>>>> happening.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> =========================
>>>>>>>>> BJ Freeman
>>>>>>>>> http://bjfreeman.elance.com
>>>>>>>>> Strategic Power Office with Supplier Automation <
>> http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>>>
>>>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>>>
>>>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>>> Linkedin
>>>>>>>>> <
>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
>>>
>>>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> Thank you for your quick response. Regarding your question about
>> real world
>>>>>>>>>> applications:
>>>>>>>>>> Ecommerce:
>>>>>>>>>> http://www.rockauto.com/
>>>>>>>>>> http://allegro.pl/
>>>>>>>>>>
>>>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>>>> In a PLM industry it's also very common to have a couple of
>> milions of
>>>>>>>>>> objects (consider the complexity of a train or a plain for
>> example).
>>>>>>>>>>
>>>>>>>>>> The point of my post was not a fix, but the implementation of  the
>> find root
>>>>>>>>>> category method.
>>>>>>>>>> I think that you should avoid such a code. You have got great
>> database layer
>>>>>>>>>> (great possibility to improve performance)  so it would be great
>> to utilize
>>>>>>>>>> it as much as it's possible.
>>>>>>>>>> I really like Ofbiz application thats why I try to give you my
>> input.
>>>>>>>>>>
>>>>>>>>>> Once again thank you for the response and for the link you send
>> me. I will
>>>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Micha³ Cukierman
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>>>> [hidden email]> napisa³:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> For instanc
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>>
>>
>>

[Tim Ruppert]

Feel free to leave Ruth's references in the book sections and not on every email where someone's asking a question.  Ruth, you already have your URL in your signature - I think what might drive people to your site is to help them instead of just taking them off of the mailing list to go check out your goods.  You are helpful - and there are many other less lazy ways to generate a buzz about how helpful you can be.  It wouldn't be particularly cool for me to just respond to everyone's questions with, "I can help you over here -> mydomain.com" - now would it?

Cheers,
Ruppert

On Apr 30, 2010, at 8:03 AM, Scott Gray wrote:

> Heidi,
>
> I'm not out to get Ruth and I'm glad that new users have another source of information available.
>
> Please re-read what I've said, there are lots of ways to let people know about her site and I was simply trying to communicate that I thought it could be done in a better way.
>
> Regards
> Scott
>
> On 1/05/2010, at 1:47 AM, Info Olagos wrote:
>
>> Hello,
>>
>> I think it is a must that we have also the information available from
>> www.myofbiz.com. For me it is very useful and not commercial if you let only
>> pay a little bit to pay the hosting costs.
>>
>> The quality of the material is very high and a must for every ofbiz user.
>>
>> So i don't see why this information may not be made public as there are also
>> the ofbiz books listed under the "books" title at the front page of
>> ofbiz.apache.org .
>>
>> I hope for the knowledge of every ofbiz user that these
>> www.myofbiz.comuserguides still maintain available in the future.
>>
>> Regards,
>> Heidi
>>
>>
>>
>> 2010/4/30 Scott Gray <[hidden email]>
>>
>>> I made it up.
>>>
>>> http://people.apache.org/~coar/mlists.html#ofbiz.apache.org
>>>
>>> Regards
>>> Scott
>>>
>>> On 1/05/2010, at 1:31 AM, Ruth Hoffman wrote:
>>>
>>>>
>>>>
>>>> Scott Gray wrote:
>>>>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>>>>
>>>>>
>>>>>> Hi Scott:
>>>>>> How so?
>>>>>>
>>>>>
>>>>> How so what?
>>>>>
>>>>>
>>>>>> I have useful information concerning how OFBiz works and I want to
>>> share that with all interested parties.
>>>>>>
>>>>>
>>>>> Every time you send this out, over 500 people have to deal with an email
>>> that contains no information other than a link to a paid product.  Hardly in
>>> keeping with the spirit of an open source mailing list.  Like I said, share
>>> some knowledge and then advertise, that way everybody benefits.
>>>>>
>>>> Really? 500? Where did you come up with that number?
>>>>>
>>>>>> Are you now the OFBiz information censor?
>>>>>>
>>>>>
>>>>> Hardly, I'm just a fellow user of this mailing list voicing my concern.
>>>>>
>>>>>
>>>>>> Regards,
>>>>>> Ruth
>>>>>> ----------------------------------------------------
>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword
>>> "myofbiz"
>>>>>> [hidden email]
>>>>>>
>>>>>> Scott Gray wrote:
>>>>>>
>>>>>>> Hi Ruth,
>>>>>>>
>>>>>>> This is bordering on spam and starting to get annoying, would you mind
>>> trying to contribute to the discussion before starting in with the
>>> advertising?
>>>>>>>
>>>>>>> Thanks
>>>>>>> Scott
>>>>>>>
>>>>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>>>>
>>>>>>>
>>>>>>>> Hello List:
>>>>>>>> If anyone is interested in a more in-depth treatment of the Catalog
>>> Manager, products, catalogs and categories, please see my book: "Getting
>>> Started with Apache OFBiz, The Catalog Manager". You may purchase a copy of
>>> this at: http://www.myofbiz.com
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Ruth
>>>>>>>> ----------------------------------------------------
>>>>>>>> Find me on the web at http://www.myofbiz.com or Google keyword
>>> "myofbiz"
>>>>>>>> [hidden email]
>>>>>>>>
>>>>>>>> Paul Abernathy wrote:
>>>>>>>>
>>>>>>>>> BJ,
>>>>>>>>>
>>>>>>>>> I also am new to ofbiz and am trying to learn how to use it.  I
>>> couldn't help noticing this discussion because I wanted to do the same thing
>>> - set up a hierarchy of categories for products.  I was just going through
>>> the business setup guide located at
>>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guideand towards the end it discusses how to set up categories.  I have a couple
>>> of questions:
>>>>>>>>>
>>>>>>>>> -Can a category be used in more than one Catalog?
>>>>>>>>> -Can a category have more than one parent?  It looks like the answer
>>> is "no" but just making sure.
>>>>>>>>>
>>>>>>>>> thanks,
>>>>>>>>>
>>>>>>>>> Paul
>>>>>>>>>
>>>>>>>>> BJ Freeman wrote:
>>>>>>>>>
>>>>>>>>>> are you sure you are not referring to 1 million products.
>>>>>>>>>> I run in the real world over 100,000 products.
>>>>>>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>>>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>>>>>>> I use automated updating from my suppliers to keep thing
>>> up-to-date.
>>>>>>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>>>>>>> availability is as often as 15 min.
>>>>>>>>>> The average Cpu usage during these operations is about 15% of a
>>> 1.6ghz
>>>>>>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>>>>>>> about 75% when the scheduled services and large imports (1 gig
>>> data) are
>>>>>>>>>> happening.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> =========================
>>>>>>>>>> BJ Freeman
>>>>>>>>>> http://bjfreeman.elance.com
>>>>>>>>>> Strategic Power Office with Supplier Automation <
>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>>>>
>>>>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>>>>
>>>>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>>>> Linkedin
>>>>>>>>>> <
>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
>>>>
>>>>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> Hello,
>>>>>>>>>>>
>>>>>>>>>>> Thank you for your quick response. Regarding your question about
>>> real world
>>>>>>>>>>> applications:
>>>>>>>>>>> Ecommerce:
>>>>>>>>>>> http://www.rockauto.com/
>>>>>>>>>>> http://allegro.pl/
>>>>>>>>>>>
>>>>>>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>>>>>>> In a PLM industry it's also very common to have a couple of
>>> milions of
>>>>>>>>>>> objects (consider the complexity of a train or a plain for
>>> example).
>>>>>>>>>>>
>>>>>>>>>>> The point of my post was not a fix, but the implementation of  the
>>> find root
>>>>>>>>>>> category method.
>>>>>>>>>>> I think that you should avoid such a code. You have got great
>>> database layer
>>>>>>>>>>> (great possibility to improve performance)  so it would be great
>>> to utilize
>>>>>>>>>>> it as much as it's possible.
>>>>>>>>>>> I really like Ofbiz application thats why I try to give you my
>>> input.
>>>>>>>>>>>
>>>>>>>>>>> Once again thank you for the response and for the link you send
>>> me. I will
>>>>>>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>>>>>>
>>>>>>>>>>> Regards,
>>>>>>>>>>> Micha³ Cukierman
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>>>>>>> [hidden email]> napisa³:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>> For instanc
>>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>

[Adrian Crum]

On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
> First, this mailing list is not about you posting your "beliefs" as
> regards OFBiz or anything else. This mailing list is suppose to be for
> the dissemination of facts concerning OFBIz.

And the point Scott was making is that you are not doing that. Instead,
you are promoting a book you have for sale.

Two questions were asked:

1. Can a category be used in more than one Catalog?
2. Can a category have more than one parent?

Your reply didn't answer either of those questions. Your reply was
nothing more than an advertisement for your book. Like Scott said, in
the spirit of the open source community, why not answer the questions
first, and *then* refer the person to your book?

-Adrian

[Michal Cukierman]

The question was:

Why PRIMARY_PARENT_CATEGORY_ID is not used while selecting root categories
(after studying model I supose that there is no need of havin primary one)
Why there is no relation (foreign key) on that column.

But the main question was:
Do we need to select all categoeries from the database to choose only couple
of them.

Today I was providing a training for the external customers (not Ofbiz).
Anyway - I will provide you a parch as soon as I will get some time.

All your messages regarding advertisment was off topic. It's a very bad
thing in this mailing list. You could create a new thread for that.

My summarization after first day in Ofbiz community:)

- Great software (but need to be improved to catch up the competitors)
- Very active community (but not focused on the problem)
- Some people that are here not for helping :)

Hope next day will be better :)




2010/4/30 Adrian Crum <[hidden email]>

> On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
>
>> First, this mailing list is not about you posting your "beliefs" as
>> regards OFBiz or anything else. This mailing list is suppose to be for
>> the dissemination of facts concerning OFBIz.
>>
>
> And the point Scott was making is that you are not doing that. Instead, you
> are promoting a book you have for sale.
>
> Two questions were asked:
>
> 1. Can a category be used in more than one Catalog?
> 2. Can a category have more than one parent?
>
> Your reply didn't answer either of those questions. Your reply was nothing
> more than an advertisement for your book. Like Scott said, in the spirit of
> the open source community, why not answer the questions first, and *then*
> refer the person to your book?
>
> -Adrian
>

[Ruth Hoffman-2]

Adrian Crum wrote:

> On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
>> First, this mailing list is not about you posting your "beliefs" as
>> regards OFBiz or anything else. This mailing list is suppose to be for
>> the dissemination of facts concerning OFBIz.
>
> And the point Scott was making is that you are not doing that.
> Instead, you are promoting a book you have for sale.
>
> Two questions were asked:
>
> 1. Can a category be used in more than one Catalog?
> 2. Can a category have more than one parent?
>
> Your reply didn't answer either of those questions. Your reply was
> nothing more than an advertisement for your book. Like Scott said, in
> the spirit of the open source community, why not answer the questions
> first, and *then* refer the person to your book?

Simple, Adrian: The question had already been answered.
Why is it acceptable "open source community" practice to refer to the
Data Model books - which are copyrighted and require purchase - and not
my books - when answering questions on this list?
>
> -Adrian
>

[Ruth Hoffman-2]

Hi Micha:
Michal Cukierman wrote:

> The question was:
>
> Why PRIMARY_PARENT_CATEGORY_ID is not used while selecting root categories
> (after studying model I supose that there is no need of havin primary one)
> Why there is no relation (foreign key) on that column.
>
> But the main question was:
> Do we need to select all categoeries from the database to choose only couple
> of them.
>
>  

The answer is no. If you'd like understand how the data model has been
implemented through the Catalog Manager, you can
a) Spend many hours reading the code because the data model is just that
- the data model. The business logic is in the code.
b) Read about it in a book (that I spend many hours researching a writing.)

> Today I was providing a training for the external customers (not Ofbiz).
> Anyway - I will provide you a parch as soon as I will get some time.
>
> All your messages regarding advertisment was off topic. It's a very bad
> thing in this mailing list. You could create a new thread for that.
>
> My summarization after first day in Ofbiz community:)
>
> - Great software (but need to be improved to catch up the competitors)
>  

For example, what would you like to see improved?
> - Very active community (but not focused on the problem)
>  
What problem would that be?
> - Some people that are here not for helping :)
>  
Would you be referring to me? If so, sorry you feel that way. If you are
referring to me, I'd like to know more about how I have not helped.
Please feel free to contact me directly at [hidden email].
> Hope next day will be better :)
>
>
>  
Hope so.

>
> 2010/4/30 Adrian Crum <[hidden email]>
>
>  
>> On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
>>
>>    
>>> First, this mailing list is not about you posting your "beliefs" as
>>> regards OFBiz or anything else. This mailing list is suppose to be for
>>> the dissemination of facts concerning OFBIz.
>>>
>>>      
>> And the point Scott was making is that you are not doing that. Instead, you
>> are promoting a book you have for sale.
>>
>> Two questions were asked:
>>
>> 1. Can a category be used in more than one Catalog?
>> 2. Can a category have more than one parent?
>>
>> Your reply didn't answer either of those questions. Your reply was nothing
>> more than an advertisement for your book. Like Scott said, in the spirit of
>> the open source community, why not answer the questions first, and *then*
>> refer the person to your book?
>>
>> -Adrian
>>
>>    
>
>  

[ScottA]

If I were the guy who asked the question, I’d be gone by now. I’d be thinking that I’d like to find an alternate to OFBiz and who’s that going to help? It won’t help sell more e-books, it won’t result in my company getting a new client, it’ll just be a lost opportunity to add a potential user or committer and in that case everyone loses.

I’d love to see the civility return to this list. Answer questions, have a tagline to more info on your sites. Write and post topics about how to use OFBiz and include your company name as a reference. But more than anything else, have respect for a differing opinion or give advice as an old sage but to continue this type of thing will not encourage anyone to participate.

Sorry to poke my nose in but these pissing contests only make the project look bad and that’s a real shame.

[Ruth Hoffman-2]

HI Michal:
Sorry, I misspelled your name. I would really like to know what
improvements you'd like to see in OFBiz. As I said, you may contact me
privately or post them on this list.
Regards,
Ruth

Ruth Hoffman wrote:

> Hi Micha:
> Michal Cukierman wrote:
>> The question was:
>>
>> Why PRIMARY_PARENT_CATEGORY_ID is not used while selecting root
>> categories
>> (after studying model I supose that there is no need of havin primary
>> one)
>> Why there is no relation (foreign key) on that column.
>>
>> But the main question was:
>> Do we need to select all categoeries from the database to choose only
>> couple
>> of them.
>>
>>  
> The answer is no. If you'd like understand how the data model has been
> implemented through the Catalog Manager, you can
> a) Spend many hours reading the code because the data model is just
> that - the data model. The business logic is in the code.
> b) Read about it in a book (that I spend many hours researching a
> writing.)
>> Today I was providing a training for the external customers (not Ofbiz).
>> Anyway - I will provide you a parch as soon as I will get some time.
>>
>> All your messages regarding advertisment was off topic. It's a very bad
>> thing in this mailing list. You could create a new thread for that.
>>
>> My summarization after first day in Ofbiz community:)
>>
>> - Great software (but need to be improved to catch up the competitors)
>>  
> For example, what would you like to see improved?
>> - Very active community (but not focused on the problem)
>>  
> What problem would that be?
>> - Some people that are here not for helping :)
>>  
> Would you be referring to me? If so, sorry you feel that way. If you
> are referring to me, I'd like to know more about how I have not
> helped. Please feel free to contact me directly at
> [hidden email].
>> Hope next day will be better :)
>>
>>
>>  
> Hope so.
>>
>> 2010/4/30 Adrian Crum <[hidden email]>
>>
>>  
>>> On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
>>>
>>>    
>>>> First, this mailing list is not about you posting your "beliefs" as
>>>> regards OFBiz or anything else. This mailing list is suppose to be for
>>>> the dissemination of facts concerning OFBIz.
>>>>
>>>>      
>>> And the point Scott was making is that you are not doing that.
>>> Instead, you
>>> are promoting a book you have for sale.
>>>
>>> Two questions were asked:
>>>
>>> 1. Can a category be used in more than one Catalog?
>>> 2. Can a category have more than one parent?
>>>
>>> Your reply didn't answer either of those questions. Your reply was
>>> nothing
>>> more than an advertisement for your book. Like Scott said, in the
>>> spirit of
>>> the open source community, why not answer the questions first, and
>>> *then*
>>> refer the person to your book?
>>>
>>> -Adrian
>>>
>>>    
>>
>>  
>

[BJ Freeman]

Ruth:, your documents do not add to this discussion.
they do not deal with code but as you said end-user.
at least be consistent.

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Ruth Hoffman sent the following on 4/30/2010 5:53 AM:

> Hi Scott:
> How so?
> I have useful information concerning how OFBiz works and I want to share
> that with all interested parties. Are you now the OFBiz information censor?
> Regards,
> Ruth
> ----------------------------------------------------
> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
> [hidden email]
>
> Scott Gray wrote:
>> Hi Ruth,
>>
>> This is bordering on spam and starting to get annoying, would you mind
>> trying to contribute to the discussion before starting in with the
>> advertising?
>>
>> Thanks
>> Scott
>>
>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>
>>  
>>> Hello List:
>>> If anyone is interested in a more in-depth treatment of the Catalog
>>> Manager, products, catalogs and categories, please see my book:
>>> "Getting Started with Apache OFBiz, The Catalog Manager". You may
>>> purchase a copy of this at: http://www.myofbiz.com
>>>
>>> Regards,
>>> Ruth
>>> ----------------------------------------------------
>>> Find me on the web at http://www.myofbiz.com or Google keyword "myofbiz"
>>> [hidden email]
>>>
>>> Paul Abernathy wrote:
>>>    
>>>> BJ,
>>>>
>>>> I also am new to ofbiz and am trying to learn how to use it.  I
>>>> couldn't help noticing this discussion because I wanted to do the
>>>> same thing - set up a hierarchy of categories for products.  I was
>>>> just going through the business setup guide located at
>>>> https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide
>>>> and towards the end it discusses how to set up categories.  I have a
>>>> couple of questions:
>>>>
>>>> -Can a category be used in more than one Catalog?
>>>> -Can a category have more than one parent?  It looks like the answer
>>>> is "no" but just making sure.
>>>>
>>>> thanks,
>>>>
>>>> Paul
>>>>
>>>> BJ Freeman wrote:
>>>>      
>>>>> are you sure you are not referring to 1 million products.
>>>>> I run in the real world over 100,000 products.
>>>>> I have approx 18 top categories with 3-10 levels of sub categories.
>>>>> if your see 1,000,000 categories that way then it is feasible.
>>>>> I use automated updating from my suppliers to keep thing up-to-date.
>>>>> these updates happen every 24 for prices new and obsolete products.
>>>>> availability is as often as 15 min.
>>>>> The average Cpu usage during these operations is about 15% of a 1.6ghz
>>>>> Cpu with enough RAM to not use the swap file. the peak cpu usage is
>>>>> about 75% when the scheduled services and large imports (1 gig
>>>>> data) are
>>>>> happening.
>>>>>
>>>>>
>>>>> =========================
>>>>> BJ Freeman
>>>>> http://bjfreeman.elance.com
>>>>> Strategic Power Office with Supplier Automation
>>>>> <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>
>>>>> Systems Integrator-- Glad to Assist
>>>>>
>>>>> Chat  Y! messenger: bjfr33man
>>>>> Linkedin
>>>>> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>>>>>
>>>>>
>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>
>>>>>        
>>>>>> Hello,
>>>>>>
>>>>>> Thank you for your quick response. Regarding your question about
>>>>>> real world
>>>>>> applications:
>>>>>> Ecommerce:
>>>>>> http://www.rockauto.com/
>>>>>> http://allegro.pl/
>>>>>>
>>>>>> There are applications that holds > 1 000 000 categories.
>>>>>> In a PLM industry it's also very common to have a couple of
>>>>>> milions of
>>>>>> objects (consider the complexity of a train or a plain for example).
>>>>>>
>>>>>> The point of my post was not a fix, but the implementation of  the
>>>>>> find root
>>>>>> category method.
>>>>>> I think that you should avoid such a code. You have got great
>>>>>> database layer
>>>>>> (great possibility to improve performance)  so it would be great
>>>>>> to utilize
>>>>>> it as much as it's possible.
>>>>>> I really like Ofbiz application thats why I try to give you my input.
>>>>>>
>>>>>> Once again thank you for the response and for the link you send
>>>>>> me. I will
>>>>>> come back with the better solution after studing  the datamodel.
>>>>>>
>>>>>> Regards,
>>>>>> Micha³ Cukierman
>>>>>>
>>>>>>
>>>>>>
>>>>>> W dniu 30 kwietnia 2010 10:11 u¿ytkownik Jacques Le Roux <
>>>>>> [hidden email]> napisa³:
>>>>>>
>>>>>>            
>>>>>>> For instanc
>>>>>>>                  
>>>>>  
>>>>>        
>>>>      
>>
>>  
>

[BJ Freeman]

Micheal:
the rollup is like a linkilst instead of DB relationships.
there for it needs to be walked through.
Since not all Catagories have a rollup you start with the main category.
However what scott suggested about a view entity would give you the Id's
in each. what it will not give, is you all the ID that don't have rollup.


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Michal Cukierman sent the following on 4/30/2010 8:02 AM:

> The question was:
>
> Why PRIMARY_PARENT_CATEGORY_ID is not used while selecting root categories
> (after studying model I supose that there is no need of havin primary one)
> Why there is no relation (foreign key) on that column.
>
> But the main question was:
> Do we need to select all categoeries from the database to choose only couple
> of them.
>
> Today I was providing a training for the external customers (not Ofbiz).
> Anyway - I will provide you a parch as soon as I will get some time.
>
> All your messages regarding advertisment was off topic. It's a very bad
> thing in this mailing list. You could create a new thread for that.
>
> My summarization after first day in Ofbiz community:)
>
> - Great software (but need to be improved to catch up the competitors)
> - Very active community (but not focused on the problem)
> - Some people that are here not for helping :)
>
> Hope next day will be better :)
>
>
>
>
> 2010/4/30 Adrian Crum <[hidden email]>
>
>> On 4/30/2010 6:28 AM, Ruth Hoffman wrote:
>>
>>> First, this mailing list is not about you posting your "beliefs" as
>>> regards OFBiz or anything else. This mailing list is suppose to be for
>>> the dissemination of facts concerning OFBIz.
>>>
>> And the point Scott was making is that you are not doing that. Instead, you
>> are promoting a book you have for sale.
>>
>> Two questions were asked:
>>
>> 1. Can a category be used in more than one Catalog?
>> 2. Can a category have more than one parent?
>>
>> Your reply didn't answer either of those questions. Your reply was nothing
>> more than an advertisement for your book. Like Scott said, in the spirit of
>> the open source community, why not answer the questions first, and *then*
>> refer the person to your book?
>>
>> -Adrian
>>
>

[BJ Freeman]

My grandfather taught me that word to mouth is the best advertising.
I have found that to be true through my life.
It s a lot slower than mass media but more stable.

In this environment, I found the best is to let people get to know me by
answering questions freely.

I also believe in putting links where appropriate.
as you note I have a tag that search engines pick up and I track where
my hits from come from, that and the clients I get, have supported this
method for years.

I use two tracker both free.
http://awstats.sourceforge.net/
which reads the website logs and gives charts and data
http://www.xav.com/scripts/axs/
which creates it own log and give by page data.

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


ScottA sent the following on 4/30/2010 8:45 AM:

> If I were the guy who asked the question, I’d be gone by now. I’d be thinking
> that I’d like to find an alternate to OFBiz and who’s that going to help? It
> won’t help sell more e-books, it won’t result in my company getting a new
> client, it’ll just be a lost opportunity to add a potential user or
> committer and in that case everyone loses.
>
> I’d love to see the civility return to this list. Answer questions, have a
> tagline to more info on your sites. Write and post topics about how to use
> OFBiz and include your company name as a reference. But more than anything
> else, have respect for a differing opinion or give advice as an old sage but
> to continue this type of thing will not encourage anyone to participate.
>
> Sorry to poke my nose in but these pissing contests only make the project
> look bad and that’s a real shame.
>

[Ruth Hoffman-2]

Hi BJ:
Thanks for sharing.

BTW - and this is not an advertisement for anything at all - I often
share by answering questions here. I also have lots of "free" stuff on
my website that represents may hours of work on my part. The site itself
is powered only by OFBiz. (OK, a little advertisement for OFBiz) and so
is an example of what one person can do given the information and
knowledge that I have to offer.

In my world, "free" is the same as saying something has "no value". Like
everyone else on this list, what I have to say has value.

I have taken to heart what the 3 or 4 project committers on this user
oriented mailing list have opined about, and will tone down my delivery.
That doesn't lessen my commitment to the end-user OFBiz community or my
need to get the word out about what I have to offer.

Regards,
Ruth

BJ Freeman wrote:

> My grandfather taught me that word to mouth is the best advertising.
> I have found that to be true through my life.
> It s a lot slower than mass media but more stable.
>
> In this environment, I found the best is to let people get to know me by
> answering questions freely.
>
> I also believe in putting links where appropriate.
> as you note I have a tag that search engines pick up and I track where
> my hits from come from, that and the clients I get, have supported this
> method for years.
>
> I use two tracker both free.
> http://awstats.sourceforge.net/
> which reads the website logs and gives charts and data
> http://www.xav.com/scripts/axs/
> which creates it own log and give by page data.
>
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
> Specialtymarket.com <http://www.specialtymarket.com/>
>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Linkedin
> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>
>
> ScottA sent the following on 4/30/2010 8:45 AM:
>  
>> If I were the guy who asked the question, I’d be gone by now. I’d be thinking
>> that I’d like to find an alternate to OFBiz and who’s that going to help? It
>> won’t help sell more e-books, it won’t result in my company getting a new
>> client, it’ll just be a lost opportunity to add a potential user or
>> committer and in that case everyone loses.
>>
>> I’d love to see the civility return to this list. Answer questions, have a
>> tagline to more info on your sites. Write and post topics about how to use
>> OFBiz and include your company name as a reference. But more than anything
>> else, have respect for a differing opinion or give advice as an old sage but
>> to continue this type of thing will not encourage anyone to participate.
>>
>> Sorry to poke my nose in but these pissing contests only make the project
>> look bad and that’s a real shame.
>>
>>    
>
>
>
>  

[Scott Gray-2]

On 1/05/2010, at 3:02 AM, Michal Cukierman wrote:

> All your messages regarding advertisment was off topic. It's a very bad
> thing in this mailing list. You could create a new thread for that.

My apologies Michal, I should have thought to alter the subject line when things started to go off track.

Regards
Scott

[Scott Gray-2]

On 1/05/2010, at 6:41 AM, Ruth Hoffman wrote:

> I have taken to heart what the 3 or 4 project committers on this user oriented mailing list have opined about, and will tone down my delivery. That doesn't lessen my commitment to the end-user OFBiz community or my need to get the word out about what I have to offer.

Thank you Ruth and please don't think for a second that I don't appreciate your contributions to the community.

Regards
Scott

[David E. Jones-2]

On Apr 30, 2010, at 12:41 PM, Ruth Hoffman wrote:

> In my world, "free" is the same as saying something has "no value".

What a sad world that must be.

Personally I've found that the most productive, innovative, and pleasant efforts I've been involved with have been unpaid. Along with that: I like working, I just hate working for money because those offering the money can (and often do) make the work a living hell in all manner of ways that not only make the work unpleasant, but also unproductive and in many cases altogether unsuccessful.

Thank goodness I can create things of value to myself and others for free, if not I'd probably go crazy. Also thank goodness for good clients, those few and far between (especially with current economic pressures), may we all find more such opportunities and maybe we would all be more civil here as well.

-David