Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Scott Gray <scott.gray@hotwaxmedia.com>
Mime-Version: 1.0 (Apple Message framework v1078)
Content-Type: multipart/signed; boundary=Apple-Mail-31-122085628;
 protocol="application/pkcs7-signature"; micalg=sha1
Subject: Re: Question regarding Catalog management in Ofbiz
Date: Sat, 1 May 2010 01:35:45 +1200
In-Reply-To: <4BDADBBD.4090703@aesolves.com>
To: user@ofbiz.apache.org
References: <z2m3f8e48c11004291230z81f367d0pb762576feebee6b3@mail.gmail.com>
	 <CAACE9B82E2C4F43A6F02F31C1FC4057@inspiron530>
 <16191819.117261272617523676.JavaMail.root@free-man.net>
 <2559935.117751272621982066.JavaMail.root@free-man.net>
 <4BDAC4F3.80809@spidercomputing.com> <4BDACDB2.3090009@aesolves.com>
 <4B87D786-7107-4169-85AF-F68096A734EF@hotwaxmedia.com>
 <4BDAD2BE.3060005@aesolves.com>
 <62F648B0-B632-4572-AE91-89CC139FECE2@hotwaxmedia.com>
 <4BDADBBD.4090703@aesolves.com>
Message-Id: <CF440B4A-2AE1-47F6-BF6D-A5DF3E60A91C@hotwaxmedia.com>

--Apple-Mail-31-122085628
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

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:

>=20
>=20
> Scott Gray wrote:
>> On 1/05/2010, at 12:53 AM, Ruth Hoffman wrote:
>>=20
>> =20
>>> Hi Scott:
>>> How so?
>>>   =20
>>=20
>> How so what?
>>=20
>> =20
>>> I have useful information concerning how OFBiz works and I want to =
share that with all interested parties.
>>>   =20
>>=20
>> 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.
>> =20
> Really? 500? Where did you come up with that number?
>> =20
>>> Are you now the OFBiz information censor?
>>>   =20
>>=20
>> Hardly, I'm just a fellow user of this mailing list voicing my =
concern.
>>=20
>> =20
>>> Regards,
>>> Ruth
>>> ----------------------------------------------------
>>> Find me on the web at http://www.myofbiz.com or Google keyword =
"myofbiz"
>>> ruth.hoffman@myofbiz.com
>>>=20
>>> Scott Gray wrote:
>>>   =20
>>>> Hi Ruth,
>>>>=20
>>>> 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?
>>>>=20
>>>> Thanks
>>>> Scott
>>>>=20
>>>> On 1/05/2010, at 12:31 AM, Ruth Hoffman wrote:
>>>>=20
>>>>      =20
>>>>> 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
>>>>>=20
>>>>> Regards,
>>>>> Ruth
>>>>> ----------------------------------------------------
>>>>> Find me on the web at http://www.myofbiz.com or Google keyword =
"myofbiz"
>>>>> ruth.hoffman@myofbiz.com
>>>>>=20
>>>>> Paul Abernathy wrote:
>>>>>          =20
>>>>>> BJ,
>>>>>>=20
>>>>>> 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+Busine=
ss+Setup+Guide and towards the end it discusses how to set up =
categories.  I have a couple of questions:
>>>>>>=20
>>>>>> -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.
>>>>>>=20
>>>>>> thanks,
>>>>>>=20
>>>>>> Paul
>>>>>>=20
>>>>>> BJ Freeman wrote:
>>>>>>              =20
>>>>>>> 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.
>>>>>>>=20
>>>>>>>=20
>>>>>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
>>>>>>> BJ Freeman
>>>>>>> http://bjfreeman.elance.com
>>>>>>> Strategic Power Office with Supplier Automation =
<http://www.businessesnetwork.com/automation/viewforum.php?f=3D93>
>>>>>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>>>>>>=20
>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>=20
>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>> Linkedin
>>>>>>> =
<http://www.linkedin.com/profile?viewProfile=3D&key=3D1237480&locale=3Den_=
US&trk=3Dtab_pro>=20
>>>>>>> Michal Cukierman sent the following on 4/30/2010 1:51 AM:
>>>>>>>=20
>>>>>>>                  =20
>>>>>>>> Hello,
>>>>>>>>=20
>>>>>>>> Thank you for your quick response. Regarding your question =
about real world
>>>>>>>> applications:
>>>>>>>> Ecommerce:
>>>>>>>> http://www.rockauto.com/
>>>>>>>> http://allegro.pl/
>>>>>>>>=20
>>>>>>>> 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).
>>>>>>>>=20
>>>>>>>> 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.
>>>>>>>>=20
>>>>>>>> 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.
>>>>>>>>=20
>>>>>>>> Regards,
>>>>>>>> Micha=B3 Cukierman
>>>>>>>>=20
>>>>>>>>=20
>>>>>>>>=20
>>>>>>>> W dniu 30 kwietnia 2010 10:11 u=BFytkownik Jacques Le Roux <
>>>>>>>> jacques.le.roux@les7arts.com> napisa=B3:
>>>>>>>>=20
>>>>>>>>                        =20
>>>>>>>>> For instanc
>>>>>>>>>                               =20
>>>>>>>                   =20
>>>>>>              =20
>>>>      =20
>>=20
>> =20


--Apple-Mail-31-122085628
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGPTCCBjkw
ggUhoAMCAQICEQDYl7EXGWhQIpBs19Ozq1G2MA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJV
UzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNF
UlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UE
AxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTA5MTAx
NDAwMDAwMFoXDTEwMTAxNDIzNTk1OVowgeAxNTAzBgNVBAsTLENvbW9kbyBUcnVzdCBOZXR3b3Jr
IC0gUEVSU09OQSBOT1QgVkFMSURBVEVEMUYwRAYDVQQLEz1UZXJtcyBhbmQgQ29uZGl0aW9ucyBv
ZiB1c2U6IGh0dHA6Ly93d3cuY29tb2RvLm5ldC9yZXBvc2l0b3J5MR8wHQYDVQQLExYoYykyMDAz
IENvbW9kbyBMaW1pdGVkMRMwEQYDVQQDEwpTY290dCBHcmF5MSkwJwYJKoZIhvcNAQkBFhpzY290
dC5ncmF5QGhvdHdheG1lZGlhLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBALNA
v8gB9OAet+B7Pm6SjpVHtavdj8RO5h75hmqYIu4gMhQmU/AJYL/pVddK85VQOMtJyngDvlKvlH5v
Xc8HwLyM3IsfrxrNzZ6mbwM1eU2BbISYMzB5BmDjieLe6xQ7sQBKPV3cSZbTAyDPs5qm/mj3jDBH
ynz5sSKcHDEvTAmubpD28mnROOSqIstApC8enFr/zMCMofL85DxOkqOjJlX0xUdvOrTaKqfk1Sej
ZJtSg0gZ5M2Tkfah/2/ALGVXKSh3cceHwuP3yMvv/uYllQZBRZiHehvTBP6qEENNxYC1LN4Zg/YD
h4+MieK2vMENUiv4qfrR5JKkaAl8A7EyI68CAwEAAaOCAhwwggIYMB8GA1UdIwQYMBaAFImCZ33E
nSZwAEu0UEh83j2uBG59MB0GA1UdDgQWBBSuGHgRPxvu0/VVHM/UmH0tUUO2sDAOBgNVHQ8BAf8E
BAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJ
YIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEW
HWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6
Ly9jcmwuY29tb2RvY2EuY29tL1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRF
bWFpbC5jcmwwSqBIoEaGRGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVu
dEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMGwGCCsGAQUFBwEBBGAwXjA2BggrBgEFBQcwAoYq
aHR0cDovL2NydC5jb21vZG9jYS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MCQGCCsGAQUFBzABhhho
dHRwOi8vb2NzcC5jb21vZG9jYS5jb20wJQYDVR0RBB4wHIEac2NvdHQuZ3JheUBob3R3YXhtZWRp
YS5jb20wDQYJKoZIhvcNAQEFBQADggEBAJ6ziClX9Dz6y35D8yjDqnEcoBrkbWPMekTFuMBI8j7O
Wzz9ADIon1wgWGAuDKkaDi/RixEsx8WlESbcJX15egqICh09KtzjNg3G6IFHFtZH7Lkl9VX0zrS2
T409wyVWUEekBFnIKVuTwhNazsILn8nlwEWN0EoAziDNutlOH5F+G17139oMi2OfY9qK5HUn9VcV
XCy72LeCo/ABtZRBnr12FaT6V6mfWwBvS35NTpJOWPS0/mEuS3+gQcOxA3Q+eNhbAj8+TQ6j41uA
sg7Oxe36WPLgtIyDEk5MRaFBZnokkEo2m+QVfq4a4acYiX6veJ+dxDNSzLwbP+G+IYCXAUgxggP/
MIID+wIBATCBxDCBrjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExh
a2UgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8v
d3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRp
Y2F0aW9uIGFuZCBFbWFpbAIRANiXsRcZaFAikGzX07OrUbYwCQYFKw4DAhoFAKCCAg8wGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTAwNDMwMTMzNTQ1WjAjBgkqhkiG
9w0BCQQxFgQUcYlp2IE8d82otodhye+kgVcYQCswgdUGCSsGAQQBgjcQBDGBxzCBxDCBrjELMAkG
A1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMV
VGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20x
NjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbAIR
ANiXsRcZaFAikGzX07OrUbYwgdcGCyqGSIb3DQEJEAILMYHHoIHEMIGuMQswCQYDVQQGEwJVUzEL
MAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRS
VVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMt
VVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhEA2JexFxloUCKQ
bNfTs6tRtjANBgkqhkiG9w0BAQEFAASCAQB8NB/BASerZgL6GQtA/pb9oxU9SETDeopFrCCGBsy7
xR0PStSp7IgKhrrgdBybb9GLBzQkg2RzAcG8rCi0MzRPBPdwB89Tm7pInpLB/FQXJgC8bA9SIxYn
ltlG5LSqm/01iApqwgYM4HbyqefdVcLv4l9SMlpwHiWh8Z+J6uMJEazj8E3DA+O4WjkLI/KRn2hA
YQJStODWmFHUVvY/3xIF18rPBhm6etNQX5MtbEAN70E+gpCqaaB15ITMdSHGdyzLF1bkxTOVfE02
Wyo3MqqnEuOWuRxQwnONRROLNq9drL8/D0LImyi240hdW1aXFBJRNYZDiyZvI3a5SrFSWKM5AAAA
AAAA

--Apple-Mail-31-122085628--