You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Michal Cukierman <du...@gmail.com> on 2010/04/29 21:30:57 UTC
Question regarding Catalog management in Ofbiz
I am a PLM consultant interested in Open source projects. I am interested in
Ofbiz as a application framework, as well as the Fully flaged ERP system. I
have to say that it has a lot of great solutions (i.e. modularity and small
amount of code).
Please forgive me if my question will be stupid as I have downloaded the
Ofbiz sources today and I am quite new to the subject.
So lets go to the point:
In the line 96 (around, depending on svn version) of the class
CategoryWorker of the products component there is a line:
..
Collection<GenericValue> allCategories =
delegator.findList("ProductCategory", null, null, null, null, false);
..
Before I started to implement my solution using ofbiz I wanted to make some
test, especialy on large amounts of data.
So far I have got 1 000 000 categories in my database and after
selecing: Choose
Top Category <https://localhost:8443/catalog/control/ChooseTopCategory>action
from the catalog management I run out of memory (4 GB of Xmx).
I was considering why do we have to select all ( one milion!) records from
the database if we want to choose only several of them?
I have seen that you use PRODUCT_CATEGORY_ROLLUP table to keep the
parent-child relations between categories. I understand that there is a need
of having many to many relation.
But besides we also have Many to one relation: primary parent category -
child categories, shouldn't we consider those as well while selecting the
ROOT objects?
My solution was preaty trivial I have changed the line 96 in the mentioned
class to:
Collection<GenericValue> allCategories = delegator.findList
("ProductCategory",
EntityCondition.makeCondition("PRIMARY_PARENT_CATEGORY_ID", null), null,
null, null, false);
Is it a good solution? If it's not - I will find another way (some join
etc.), because from my point of view - selecting one milion objects if we
need a couple of them can be done by RDMS in almost realtime.
Please correct me if I am wrong. I can be wrong.
Best Regards,
Michał Cukierman
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
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 <
jacques.le.roux@les7arts.com> napisał:
> For instanc
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
A few of points:
- CategoryWorker.getCategoriesWithNoParent(...) is a seldom used method and certainly not used in the eCommerce application. If would be better to understand properly how OFBiz navigates Categories and then worry about the performance of that. I'm quite sure that method could be improved though.
- A structure of 1 million categories is in my opinion probably not a good one, my guess is that they may have more categories than parts and is probably indicative of the limitations of the software they're using rather than OFBiz's limitations. OFBiz provides many methods for navigating, filtering and searching around products. Are there going to bottlenecks when you have millions of products? Absolutely, but I'm quite sure they could be overcome fairly easily.
- I don't believe primaryParentCategory can be used in this case, it is merely additional information that is not guaranteed to be present. I would either create a view entity that forms an outer join between ProductCategory and ProductCategoryRollup (although that may not be performant enough), or otherwise I would introduce some stronger business rules that prevent categories being created if the don't have a parent (either parent category or catalog).
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 30/04/2010, at 11:02 PM, Michal Cukierman wrote:
> Sorry for sending you another message but I have just found an interesting
> link:
>
> http://allegro.pl/category_map.php
>
> It's a category map.
>
> If you want to use OFBiz in real commercial systems (not for SMB industry)
> you need to face such use cases.
>
> Regards,
> Michał Cukierman
>
> W dniu 30 kwietnia 2010 12:56 użytkownik Michal Cukierman
> <du...@gmail.com>napisał:
>
>> Hi,
>>
>> Yes I am sure that I am talking about categories. See the example of
>> rockauto or any other automotive ecommerce shop:
>> 200 brands x 20 years x 10 models x 5 engine types x 12 part groups
>> (interior, engine, exterior, accesories)
>> 200 x 20 x 10 x 5 x 12 = 2 400 000.
>> Its only an example. Software like Alldata or PartExpert generates much
>> more cateogies. What about American car parts association?
>>
>> Anyway this is not a case. It's not a point to discuss.
>> Please consider the application with 10 000 categories and select * from
>> statement running concurently. Please try to update some category with
>> ReadCommited isolation level (As you use as default).
>>
>> This disscusion does not make sens. My question was:
>> - What is the way of using primary_parent_category?
>> - Is my fix ok?
>> - In addition I pointed you a mistake in your code (which kills my
>> application and is a performance issue)
>> - I said that i will prepare a patch as soon as I will find whats around
>>
>> Whats you response:
>> - read our books that could be bought here
>> - your fix is a bad one, no suggestion how to improve it
>> - our code is a good one and we don't need to change it. As ofbiz works on
>> my laptop
>> - after such constructive responses I don't really want to sent you my
>> patches (just to show you, not saying that you are going to commit it)
>>
>> All I wanted to do from my side is to give you my input and a little help.
>> After all, I still can't understand why selecting even 1000 record from
>> database if we need to use 10 is a good solution.
>>
>> Regards,
>> Michał
>>
>>
>>
>>
>> W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman <bj...@free-man.net>napisał:
>>
>> 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 <
>>>> jacques.le.roux@les7arts.com> napisał:
>>>>
>>>>> For instanc
>>>>
>>>
>>>
>>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
Thank you for your advices. I will save days of wark thanks to you.
@TECDOC:
Is a great software, just what I wanted to have. The pricelist is good as
well. Exposed web serwise or standalone DVD catalogue is all I need. I will
investigate this solution in a days. What is very important for my at the
moment is USA market support (I have seen some supliers so far). The another
thing to investigate is the licence. Is it legal to use it in exposed web
applications?
@Regarding top categories:
I have implemented SQL function for doing the magic, it's quite simple join
(as expected to be). The performance on my huge database is excelent (just
in time, after first run results are cached).
SELECT D.PRODUCT_CATEGORY_ID FROM PRODUCT_CATEGORY_ROLLUP P
RIGHT JOIN
PRODUCT_CATEGORY D ON P.PRODUCT_CATEGORY_ID and
D.PRODUCT_CATEGORY_ID
WHERE PARENT_PRODUCT_CATEGORY_ID is null;
I am now learning the OFbiz database API to implement the solution above. I
have not found an API to create RIGHT/LEFT joins so far.
EntityListIterator is a good solution but implementation of SQL statement
above would be even better in my opinion. Anyway in case of problem I have
a backup in your idea.
Regarads and many thanks,
Michał
2010/5/2 Deyan Tsvetanov <de...@ittconsult.com>
> TECDOC
Re: Question regarding Catalog management in Ofbiz
Posted by Deyan Tsvetanov <de...@ittconsult.com>.
Hi Michal,
I agree, that the categories part is tricky. In the legacy system
database you will most probably have the same category many times with
different ID for each vendor. If you want to use the model with one
category for all vendors than you will need to maintain mapping when you
do the import process. This is some labor, I agree. However you should
calculate the pros and cons. Should you perform this labor you will get
some precious features. The end users will be able to search for a part
in the "Brake-wheel hub" category which is compatible with BMW 330XD
model year 2010 for example. End users wouldn't care about the vendor
but the compatibility, because most of the car parts are often
compatible with other brands and car models. The customers need a car
part that works for them :)
Do you know a software called TECDOC ? Have a look there, you'll get
some ideas.
About EntityListIterator: it is a very very very recommended solution
over the generic List. When you make a query which gets 1,000,000
results the database would create a cursor for you which contains the
results. Using the EntityListIterator you would get the results one by
one. You are not doing anything illegal as this is the model in JDBC as
well - the java.sql.ResultSet class is also an interator. If you don't
believe me you could perform a simple test - create 1,000,000 records
into a table and fetch them in a List, do it 10 times without restarting
the JVM and monitor the heap usage. You have a case where the memory
usage depends on the number of the results - a classical example of
memory leak :)
Fetching the results in a List is convenient for small result sets -
like nomenclature tables. All the rest should be done using
EntityListIterator.
Regards,
Deyan
On Sat, 2010-05-01 at 21:08 +0200, Michal Cukierman wrote:
> Thank you Deyan for your post,
>
> Actualy those are very precious sugestions. Thank you very much for that. I
> am now investigating possible ways for solving my concerns, Ofbiz is one of
> tools that are pretented to be the best. There is one problem regarding
> creation of complex categories structure. To be more precise: In my system I
> am going to import all categories structures automaticly from suppliers.
> Those can differ from each other. Your solution would be great if there will
> be one model to refer. I tried to use structures from automotive software
> like PartEpert or AllData. Unfortunately I am unable to gather data from
> those databases. What is more: different part manufactures use different
> numbering schema (yes, I am PLM consultant:)). Have you found a way of
> modeling your structure, is there an open database keeping all those data?
> I assume that most of companies do it manualy. In my case it could be
> dificult, because of automatic import process.
>
> The best thing would be to have a categories structure based on Parts
> numbers. We would be able to find replacements, variants and uses for each
> part. As far I have not found a good solution for that.
>
> Regarding EntityListIterator, if its an implementation of Lazy loading
> (fetch data 'just in time'), it could be a problem as well (1 000 000 calls
> to a database is slow as well - but it will not kill my app). I see the
> following solutions for solwing the problem:
>
> 1) join on rollup and Product category.
> 2) select product categories where parent category id is not in ( select
> from rollup ).
>
> I have not checked that as far as I don't have time for this at the moment.
> Anyway, single query is the best solution. Databases are optimised for
> operations like that and we should use it.
>
>
> Regards,
> Michał
>
> 2010/5/1 Deyan Tsvetanov <de...@ittconsult.com>
>
> > associations, for example: compatible with, replaceable by,
> > required or anything else ( product_assoc_type table )
> >
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
Thank you Deyan for your post,
Actualy those are very precious sugestions. Thank you very much for that. I
am now investigating possible ways for solving my concerns, Ofbiz is one of
tools that are pretented to be the best. There is one problem regarding
creation of complex categories structure. To be more precise: In my system I
am going to import all categories structures automaticly from suppliers.
Those can differ from each other. Your solution would be great if there will
be one model to refer. I tried to use structures from automotive software
like PartEpert or AllData. Unfortunately I am unable to gather data from
those databases. What is more: different part manufactures use different
numbering schema (yes, I am PLM consultant:)). Have you found a way of
modeling your structure, is there an open database keeping all those data?
I assume that most of companies do it manualy. In my case it could be
dificult, because of automatic import process.
The best thing would be to have a categories structure based on Parts
numbers. We would be able to find replacements, variants and uses for each
part. As far I have not found a good solution for that.
Regarding EntityListIterator, if its an implementation of Lazy loading
(fetch data 'just in time'), it could be a problem as well (1 000 000 calls
to a database is slow as well - but it will not kill my app). I see the
following solutions for solwing the problem:
1) join on rollup and Product category.
2) select product categories where parent category id is not in ( select
from rollup ).
I have not checked that as far as I don't have time for this at the moment.
Anyway, single query is the best solution. Databases are optimised for
operations like that and we should use it.
Regards,
Michał
2010/5/1 Deyan Tsvetanov <de...@ittconsult.com>
> associations, for example: compatible with, replaceable by,
> required or anything else ( product_assoc_type table )
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
the rollup is the complexity but the actual category is entered onces.
for imports I have a entity that while importing converts the supplier
categories to the once you use in ofbiz.
this allows you to have standard categories for all suppliers, in the
catalogs used for customer ordering.
each supplier has their own catalog with their categories for ordering
from them (see supplier_product)
then there is/are catalog(s) for the ecommerce(customer) ordering.
I implemented this for a Autoparts store where their system was updated
nightly with inventory prices and new or obsolete parts.
Association of parts, has nothing to do with categories but products.
categories are used for quick look up of a product. once you at the
product then association to other products for compatible, replacement
are used.
from there then the suppliers for that product is looked up.
at least that is the way I implemented it.
=========================
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 5/1/2010 12:08 PM:
> Thank you Deyan for your post,
>
> Actualy those are very precious sugestions. Thank you very much for that. I
> am now investigating possible ways for solving my concerns, Ofbiz is one of
> tools that are pretented to be the best. There is one problem regarding
> creation of complex categories structure. To be more precise: In my system I
> am going to import all categories structures automaticly from suppliers.
> Those can differ from each other. Your solution would be great if there will
> be one model to refer. I tried to use structures from automotive software
> like PartEpert or AllData. Unfortunately I am unable to gather data from
> those databases. What is more: different part manufactures use different
> numbering schema (yes, I am PLM consultant:)). Have you found a way of
> modeling your structure, is there an open database keeping all those data?
> I assume that most of companies do it manualy. In my case it could be
> dificult, because of automatic import process.
>
> The best thing would be to have a categories structure based on Parts
> numbers. We would be able to find replacements, variants and uses for each
> part. As far I have not found a good solution for that.
>
> Regarding EntityListIterator, if its an implementation of Lazy loading
> (fetch data 'just in time'), it could be a problem as well (1 000 000 calls
> to a database is slow as well - but it will not kill my app). I see the
> following solutions for solwing the problem:
>
> 1) join on rollup and Product category.
> 2) select product categories where parent category id is not in ( select
> from rollup ).
>
> I have not checked that as far as I don't have time for this at the moment.
> Anyway, single query is the best solution. Databases are optimised for
> operations like that and we should use it.
>
>
> Regards,
> Michał
>
> 2010/5/1 Deyan Tsvetanov <de...@ittconsult.com>
>
>> associations, for example: compatible with, replaceable by,
>> required or anything else ( product_assoc_type table )
>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Deyan Tsvetanov <de...@ittconsult.com>.
Yes, it is a good example. I've done a project with car parts so i'm
pretty familiar with the millions of categories :)
However there is a lot of room for optimization. In ofbiz you could add
a product into many categories so you don't have to create a category
"Brake-wheel hub" many times for each brand.
One additional feature of ofbiz that could be used here is the product
manufacturer party - manufacturer_party_id, so you don't have to create
each vendor as a category. Of course you are free to do it if it's
easier for you :)
Ofbiz data model is actually perfect for car or any types of parts,
because it's very flexible. You could associate products and using
different associations, for example: compatible with, replaceable by,
required or anything else ( product_assoc_type table )
Cheers,
Deyan
On Fri, 2010-04-30 at 13:02 +0200, Michal Cukierman wrote:
> Sorry for sending you another message but I have just found an interesting
> link:
>
> http://allegro.pl/category_map.php
>
> It's a category map.
>
> If you want to use OFBiz in real commercial systems (not for SMB industry)
> you need to face such use cases.
>
> Regards,
> Michał Cukierman
>
> W dniu 30 kwietnia 2010 12:56 użytkownik Michal Cukierman
> <du...@gmail.com>napisał:
>
> > Hi,
> >
> > Yes I am sure that I am talking about categories. See the example of
> > rockauto or any other automotive ecommerce shop:
> > 200 brands x 20 years x 10 models x 5 engine types x 12 part groups
> > (interior, engine, exterior, accesories)
> > 200 x 20 x 10 x 5 x 12 = 2 400 000.
> > Its only an example. Software like Alldata or PartExpert generates much
> > more cateogies. What about American car parts association?
> >
> > Anyway this is not a case. It's not a point to discuss.
> > Please consider the application with 10 000 categories and select * from
> > statement running concurently. Please try to update some category with
> > ReadCommited isolation level (As you use as default).
> >
> > This disscusion does not make sens. My question was:
> > - What is the way of using primary_parent_category?
> > - Is my fix ok?
> > - In addition I pointed you a mistake in your code (which kills my
> > application and is a performance issue)
> > - I said that i will prepare a patch as soon as I will find whats around
> >
> > Whats you response:
> > - read our books that could be bought here
> > - your fix is a bad one, no suggestion how to improve it
> > - our code is a good one and we don't need to change it. As ofbiz works on
> > my laptop
> > - after such constructive responses I don't really want to sent you my
> > patches (just to show you, not saying that you are going to commit it)
> >
> > All I wanted to do from my side is to give you my input and a little help.
> > After all, I still can't understand why selecting even 1000 record from
> > database if we need to use 10 is a good solution.
> >
> > Regards,
> > Michał
> >
> >
> >
> >
> > W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman <bj...@free-man.net>napisał:
> >
> > 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 <
> >> > jacques.le.roux@les7arts.com> napisał:
> >> >
> >> >> For instanc
> >> >
> >>
> >>
> >>
> >
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
Sorry for sending you another message but I have just found an interesting
link:
http://allegro.pl/category_map.php
It's a category map.
If you want to use OFBiz in real commercial systems (not for SMB industry)
you need to face such use cases.
Regards,
Michał Cukierman
W dniu 30 kwietnia 2010 12:56 użytkownik Michal Cukierman
<du...@gmail.com>napisał:
> Hi,
>
> Yes I am sure that I am talking about categories. See the example of
> rockauto or any other automotive ecommerce shop:
> 200 brands x 20 years x 10 models x 5 engine types x 12 part groups
> (interior, engine, exterior, accesories)
> 200 x 20 x 10 x 5 x 12 = 2 400 000.
> Its only an example. Software like Alldata or PartExpert generates much
> more cateogies. What about American car parts association?
>
> Anyway this is not a case. It's not a point to discuss.
> Please consider the application with 10 000 categories and select * from
> statement running concurently. Please try to update some category with
> ReadCommited isolation level (As you use as default).
>
> This disscusion does not make sens. My question was:
> - What is the way of using primary_parent_category?
> - Is my fix ok?
> - In addition I pointed you a mistake in your code (which kills my
> application and is a performance issue)
> - I said that i will prepare a patch as soon as I will find whats around
>
> Whats you response:
> - read our books that could be bought here
> - your fix is a bad one, no suggestion how to improve it
> - our code is a good one and we don't need to change it. As ofbiz works on
> my laptop
> - after such constructive responses I don't really want to sent you my
> patches (just to show you, not saying that you are going to commit it)
>
> All I wanted to do from my side is to give you my input and a little help.
> After all, I still can't understand why selecting even 1000 record from
> database if we need to use 10 is a good solution.
>
> Regards,
> Michał
>
>
>
>
> W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman <bj...@free-man.net>napisał:
>
> 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 <
>> > jacques.le.roux@les7arts.com> napisał:
>> >
>> >> For instanc
>> >
>>
>>
>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
unfortunately I struggle with my native language so what the link shows
does not make sense to me.
I am sure some of the others can though.
btw if you want to provide a patch.
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices
and welcome to the community.
=========================
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 4:02 AM:
> Sorry for sending you another message but I have just found an interesting
> link:
>
> http://allegro.pl/category_map.php
>
> It's a category map.
>
> If you want to use OFBiz in real commercial systems (not for SMB industry)
> you need to face such use cases.
>
> Regards,
> Michał Cukierman
>
> W dniu 30 kwietnia 2010 12:56 użytkownik Michal Cukierman
> <du...@gmail.com>napisał:
>
>> Hi,
>>
>> Yes I am sure that I am talking about categories. See the example of
>> rockauto or any other automotive ecommerce shop:
>> 200 brands x 20 years x 10 models x 5 engine types x 12 part groups
>> (interior, engine, exterior, accesories)
>> 200 x 20 x 10 x 5 x 12 = 2 400 000.
>> Its only an example. Software like Alldata or PartExpert generates much
>> more cateogies. What about American car parts association?
>>
>> Anyway this is not a case. It's not a point to discuss.
>> Please consider the application with 10 000 categories and select * from
>> statement running concurently. Please try to update some category with
>> ReadCommited isolation level (As you use as default).
>>
>> This disscusion does not make sens. My question was:
>> - What is the way of using primary_parent_category?
>> - Is my fix ok?
>> - In addition I pointed you a mistake in your code (which kills my
>> application and is a performance issue)
>> - I said that i will prepare a patch as soon as I will find whats around
>>
>> Whats you response:
>> - read our books that could be bought here
>> - your fix is a bad one, no suggestion how to improve it
>> - our code is a good one and we don't need to change it. As ofbiz works on
>> my laptop
>> - after such constructive responses I don't really want to sent you my
>> patches (just to show you, not saying that you are going to commit it)
>>
>> All I wanted to do from my side is to give you my input and a little help.
>> After all, I still can't understand why selecting even 1000 record from
>> database if we need to use 10 is a good solution.
>>
>> Regards,
>> Michał
>>
>>
>>
>>
>> W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman <bj...@free-man.net>napisał:
>>
>> 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 <
>>>> jacques.le.roux@les7arts.com> napisał:
>>>>
>>>>> For instanc
>>>
>>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
Hi,
Yes I am sure that I am talking about categories. See the example of
rockauto or any other automotive ecommerce shop:
200 brands x 20 years x 10 models x 5 engine types x 12 part groups
(interior, engine, exterior, accesories)
200 x 20 x 10 x 5 x 12 = 2 400 000.
Its only an example. Software like Alldata or PartExpert generates much more
cateogies. What about American car parts association?
Anyway this is not a case. It's not a point to discuss.
Please consider the application with 10 000 categories and select * from
statement running concurently. Please try to update some category with
ReadCommited isolation level (As you use as default).
This disscusion does not make sens. My question was:
- What is the way of using primary_parent_category?
- Is my fix ok?
- In addition I pointed you a mistake in your code (which kills my
application and is a performance issue)
- I said that i will prepare a patch as soon as I will find whats around
Whats you response:
- read our books that could be bought here
- your fix is a bad one, no suggestion how to improve it
- our code is a good one and we don't need to change it. As ofbiz works on
my laptop
- after such constructive responses I don't really want to sent you my
patches (just to show you, not saying that you are going to commit it)
All I wanted to do from my side is to give you my input and a little help.
After all, I still can't understand why selecting even 1000 record from
database if we need to use 10 is a good solution.
Regards,
Michał
W dniu 30 kwietnia 2010 12:06 użytkownik BJ Freeman
<bj...@free-man.net>napisał:
> 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 <
> > jacques.le.roux@les7arts.com> napisał:
> >
> >> For instanc
> >
>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by ScottA <Sc...@UnionDiamond.com>.
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.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Question-regarding-Catalog-management-in-Ofbiz-tp2076087p2077100.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: letting prospective customer get to know you
Posted by Ruth Hoffman <rh...@aesolves.com>.
David E Jones wrote:
> 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.
>
Actually, David, my world isn't the least bit sad. Its really a pretty
nice place to be. I wouldn't have it any other way. Each and every day
it just gets better. I am so grateful for all that I have including the
ability to choose the work I do and to place my own value on those
efforts. I never work for "free". I may not always be paid with money,
but that doesn't mean I work for "free".
> 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.
>
But that has nothing to do with working for "free". It has everything to
do with managing your expectations.
> 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.
>
Maybe. Tomorrow is another day. Can't wait to see what surprises it brings!
Regards,
Ruth
> -David
>
>
>
Re: letting prospective customer get to know you
Posted by David E Jones <de...@me.com>.
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
Re: letting prospective customer get to know you
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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
Re: letting prospective customer get to know you
Posted by Ruth Hoffman <rh...@aesolves.com>.
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.
>>
>>
>
>
>
>
letting prospective customer get to know you
Posted by BJ Freeman <bj...@free-man.net>.
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.
>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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
> ruth.hoffman@myofbiz.com.
>> Hope next day will be better :)
>>
>>
>>
> Hope so.
>>
>> 2010/4/30 Adrian Crum <ad...@hlmksw.com>
>>
>>
>>> 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
>>>
>>>
>>
>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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 ruth.hoffman@myofbiz.com.
> Hope next day will be better :)
>
>
>
Hope so.
>
> 2010/4/30 Adrian Crum <ad...@hlmksw.com>
>
>
>> 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
>>
>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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
Re: Question regarding Catalog management in Ofbiz
Posted by Michal Cukierman <du...@gmail.com>.
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 <ad...@hlmksw.com>
> 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
>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
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 <ad...@hlmksw.com>
>
>> 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
>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Adrian Crum <ad...@hlmksw.com>.
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
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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"
> ruth.hoffman@myofbiz.com
>
>
> 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"
>>> ruth.hoffman@myofbiz.com
>>>
>>> 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 <sc...@hotwaxmedia.com>
>>>>
>>>>
>>>>> 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"
>>>>>> ruth.hoffman@myofbiz.com
>>>>>>
>>>>>> 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 <
>>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> For instanc
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>
>>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
ruth.hoffman@myofbiz.com
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"
>> ruth.hoffman@myofbiz.com
>>
>> 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 <sc...@hotwaxmedia.com>
>>>
>>>
>>>
>>>> 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"
>>>>> ruth.hoffman@myofbiz.com
>>>>>
>>>>> 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 <
>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> For instanc
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>>
>>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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"
> ruth.hoffman@myofbiz.com
>
> 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 <sc...@hotwaxmedia.com>
>>
>>
>>> 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"
>>>> ruth.hoffman@myofbiz.com
>>>>
>>>> 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 <
>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> For instanc
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
ruth.hoffman@myofbiz.com
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 <sc...@hotwaxmedia.com>
>
>
>> 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"
>>> ruth.hoffman@myofbiz.com
>>>
>>> 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 <
>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>
>>>>>>
>>>>>>
>>>>>>> For instanc
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>
>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Info Olagos <in...@gmail.com>.
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 <sc...@hotwaxmedia.com>
> 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"
> > ruth.hoffman@myofbiz.com
> >
> > 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 <
> >>>> jacques.le.roux@les7arts.com> napisa³:
> >>>>
> >>>>
> >>>>> For instanc
> >>>>>
> >>>
> >>>
> >>>
> >>
> >>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Tim Ruppert <ti...@hotwaxmedia.com>.
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 <sc...@hotwaxmedia.com>
>>
>>> 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"
>>>>>> ruth.hoffman@myofbiz.com
>>>>>>
>>>>>> 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"
>>>>>>>> ruth.hoffman@myofbiz.com
>>>>>>>>
>>>>>>>> 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 <
>>>>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>> For instanc
>>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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 <sc...@hotwaxmedia.com>
>
>> 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"
>>>>> ruth.hoffman@myofbiz.com
>>>>>
>>>>> 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"
>>>>>>> ruth.hoffman@myofbiz.com
>>>>>>>
>>>>>>> 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 <
>>>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> For instanc
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Info Olagos <in...@gmail.com>.
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 <sc...@hotwaxmedia.com>
> 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"
> >>> ruth.hoffman@myofbiz.com
> >>>
> >>> 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"
> >>>>> ruth.hoffman@myofbiz.com
> >>>>>
> >>>>> 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 <
> >>>>>>>> jacques.le.roux@les7arts.com> napisa³:
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>> For instanc
> >>>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>
> >>
> >>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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"
> ruth.hoffman@myofbiz.com
>
> 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"
>>>>> ruth.hoffman@myofbiz.com
>>>>>
>>>>> 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"
>>>>>>> ruth.hoffman@myofbiz.com
>>>>>>>
>>>>>>> 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 <
>>>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> For instanc
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
ruth.hoffman@myofbiz.com
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"
>>>> ruth.hoffman@myofbiz.com
>>>>
>>>> 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"
>>>>>> ruth.hoffman@myofbiz.com
>>>>>>
>>>>>> 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 <
>>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> For instanc
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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"
>>> ruth.hoffman@myofbiz.com
>>>
>>> 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"
>>>>> ruth.hoffman@myofbiz.com
>>>>>
>>>>> 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 <
>>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>>
>>>>>>>>
>>>>>>>>> For instanc
>>>>>>>>>
>>>>>>>
>>>>>>
>>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
>> ruth.hoffman@myofbiz.com
>>
>> 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"
>>>> ruth.hoffman@myofbiz.com
>>>>
>>>> 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 <
>>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> For instanc
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>
>>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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.
> 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"
> ruth.hoffman@myofbiz.com
>
> 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"
>>> ruth.hoffman@myofbiz.com
>>>
>>> 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 <
>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>
>>>>>>
>>>>>>> For instanc
>>>>>>>
>>>>>
>>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
ruth.hoffman@myofbiz.com
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"
>> ruth.hoffman@myofbiz.com
>>
>> 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 <
>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>
>>>>>
>>>>>
>>>>>> For instanc
>>>>>>
>>>>>>
>>>>
>>>>
>>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
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"
> ruth.hoffman@myofbiz.com
>
> 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"
>>> ruth.hoffman@myofbiz.com
>>>
>>> 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 <
>>>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>>>
>>>>>>
>>>>>>> For instanc
>>>>>>>
>>>>>
>>>>>
>>>>
>>
>>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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"
> ruth.hoffman@myofbiz.com
>
> 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 <
>>>> jacques.le.roux@les7arts.com> napisa³:
>>>>
>>>>
>>>>> For instanc
>>>>>
>>>
>>>
>>>
>>
>>
Re: Question regarding Catalog management in Ofbiz
Posted by Ruth Hoffman <rh...@aesolves.com>.
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"
ruth.hoffman@myofbiz.com
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 <
>>> jacques.le.roux@les7arts.com> napisa³:
>>>
>>>
>>>> For instanc
>>>>
>>
>>
>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by Paul Abernathy <pa...@spidercomputing.com>.
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 <
>> jacques.le.roux@les7arts.com> napisał:
>>
>>
>>> For instanc
>>>
>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
Yes to both.
catalog is basically tying product, catagories and searches together.
so you can have multiple catalogs, with any or all products and
categories already defined.
=========================
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>
Paul Abernathy sent the following on 4/30/2010 4:54 AM:
> 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 <
>>> jacques.le.roux@les7arts.com> napisał:
>>>
>>>
>>>> For instanc
>>>>
>>
>>
>>
>
>
Re: Question regarding Catalog management in Ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
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 <
> jacques.le.roux@les7arts.com> napisał:
>
>> For instanc
>
Re: Question regarding Catalog management in Ofbiz
Posted by Jacques Le Roux <ja...@les7arts.com>.
You are too quick with your assumptions. For instance did you test your change with the OOTB values and without? If you had done so
you would have found that they don't give the same result.
I suggest to have a look at the p.71-75 of the data model reference book
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books
And at large to read this book before making any new assumptions.
This does not mean that your use case should not be more thought about...
But one million categories, is this modeling something real in our world?
Jacques
Michal Cukierman wrote:
> I am a PLM consultant interested in Open source projects. I am interested in
> Ofbiz as a application framework, as well as the Fully flaged ERP system. I
> have to say that it has a lot of great solutions (i.e. modularity and small
> amount of code).
> Please forgive me if my question will be stupid as I have downloaded the
> Ofbiz sources today and I am quite new to the subject.
>
> So lets go to the point:
>
> In the line 96 (around, depending on svn version) of the class
> CategoryWorker of the products component there is a line:
>
> ..
> Collection<GenericValue> allCategories =
> delegator.findList("ProductCategory", null, null, null, null, false);
> ..
>
> Before I started to implement my solution using ofbiz I wanted to make some
> test, especialy on large amounts of data.
> So far I have got 1 000 000 categories in my database and after
> selecing: Choose
> Top Category <https://localhost:8443/catalog/control/ChooseTopCategory>action
> from the catalog management I run out of memory (4 GB of Xmx).
>
> I was considering why do we have to select all ( one milion!) records from
> the database if we want to choose only several of them?
>
> I have seen that you use PRODUCT_CATEGORY_ROLLUP table to keep the
> parent-child relations between categories. I understand that there is a need
> of having many to many relation.
> But besides we also have Many to one relation: primary parent category -
> child categories, shouldn't we consider those as well while selecting the
> ROOT objects?
>
>
> My solution was preaty trivial I have changed the line 96 in the mentioned
> class to:
>
> Collection<GenericValue> allCategories = delegator.findList
> ("ProductCategory",
> EntityCondition.makeCondition("PRIMARY_PARENT_CATEGORY_ID", null), null,
> null, null, false);
>
> Is it a good solution? If it's not - I will find another way (some join
> etc.), because from my point of view - selecting one milion objects if we
> need a couple of them can be done by RDMS in almost realtime.
>
> Please correct me if I am wrong. I can be wrong.
>
>
> Best Regards,
> Michał Cukierman