Re: Error trying to buy a Digital Good

2009-09-22 Thread Simon Hutchinson

Hi Jacques,

Yes I will take a look.

Simon
On 21 Sep 2009, at 20:42, Jacques Le Roux wrote:


Hi Simon,

Could you please avec a look at OFBIZ-2929 ?

Thanks

Jacques

From: Simon Hutchinson simon.hutchin...@ixxus.co.uk

Hi Mario
I am currently using 09.04 r813407
I have performed a clean build of the demo - ant clean-all run- 
install
Am am unable to test an anonymous quick checkout at the moment for  
you  due to an issue currently logged on Jira (see https://issues.apache.org/jira/browse/OFBIZ-2929)
However if I am logged in then I can perform a quick checkout for  
the  good that you are referring to without error, which is  
subsequently  available for download in my order history.

Which revision are you using?
Are you testing on a clean demo build?
Regards
Simon
On 21 Sep 2009, at 12:06, MarioF wrote:


Hi all,

I received an error when I try to buy a Digital Good, for example  
the
Digital Gizmo (ID: GZ-DIG). If the product is a Finished Good all   
works

fine.

I make the following. I add the Digital Gizmo to the cart and make  
a  Quick
Checkout. I pay with a valid credit card and submit the order.  
The  result

screen is this:


The Following Errors Occurred:

Problem with order change; see above error


In the console I have this:

2009-09-21 12:56:06,984 (http-0.0.0.0-8443-4)   
[  OrderChangeHelper.java:85

:ERROR]
 exception report
--
Service invocation error, status changes were not updated for order
#WSCO10091
Exception: org.ofbiz.service.GenericServiceException Message:  
Could  not
commit transaction for service [changeOrderItemStatus] call: Roll  
back
error, could not commit transaction, was rolled back instead  
because  of:

Error in simple-method [Convert UOM values
[file:/D:/Projekte/ofbiz/ofbiz-trunk/framework/common/script/org/  
ofbiz/common/CommonServices.xml#convertUom]]:

; [UOM Conversion Relationship Not Found]
 stack trace
---
org.ofbiz.service.GenericServiceException: Could not commit   
transaction for
service [changeOrderItemStatus] call: Roll back error, could not   
commit
transaction, was rolled back instead because of: Error in simple-  
method

[Convert UOM values
[file:/D:/Projekte/ofbiz/ofbiz-trunk/framework/common/script/org/  
ofbiz/common/CommonServices.xml#convertUom]]:

; [UOM Conversion Relationship Not Found]
org 
.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:  
548)
org 
.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:  
221)
org 
.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:  
159)
org 
 .ofbiz 
 .order 
 .order 
.OrderChangeHelper.orderStatusChanges(OrderChangeHelper.java: 166)
org 
 .ofbiz 
 .order 
.order.OrderChangeHelper.approveOrder(OrderChangeHelper.java:72)
org 
 .ofbiz 
 .order 
 .shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java: 
1023)
org 
 .ofbiz 
 .order 
 .shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java: 
885)
org 
 .ofbiz 
 .order 
 .shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java: 
553)
org 
 .ofbiz 
 .order 
 .shoppingcart.CheckOutEvents.processPayment(CheckOutEvents.java: 
517)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun 
 .reflect 
 .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun 
 .reflect 
 .DelegatingMethodAccessorImpl 
 .invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:585)
org 
.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:  
92)
org 
.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:  
78)
org 
.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:  
611)
org 
 .ofbiz 
.webapp.control.RequestHandler.doRequest(RequestHandler.java: 374)
org 
 .ofbiz 
.webapp.control.RequestHandler.doRequest(RequestHandler.java: 515)
org 
 .ofbiz 
.webapp.control.RequestHandler.doRequest(RequestHandler.java: 515)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java: 
214)

javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org 
 .apache 
 .catalina 
 .core 
 .ApplicationFilterChain 
.internalDoFilter(ApplicationFilterChain.java: 290)
org 
 .apache 
 .catalina 
 .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
206)
org 
.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:  
264)
org 
 .apache 
 .catalina 
 .core 
 .ApplicationFilterChain 
.internalDoFilter(ApplicationFilterChain.java: 235)
org 
 .apache 
 .catalina 
 .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
206)
org 
 .apache 
 .catalina 
.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 233)
org 
 .apache 
 .catalina 
.core.StandardContextValve.invoke(StandardContextValve.java: 175)
org 
 .apache 
 .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org 
 .apache 
 

Re: How to Create Own Store

2009-09-22 Thread Jacques Le Roux

Hi Kumar,

http://docs.ofbiz.org/x/oR4

Jacques

From: Jitender jitender.mau...@gmail.com


Hi Chirag and others !
how to call some some other API Methods wihich is available in WSDL file
wating for reply :

Thanks.
Jitender
-

Chirag Manocha-2 wrote:


Hi Kumar,
As Sumit said you can refer DemoProducts.xml and if you want to do the 
setup from front end then you can refer 
https://demo.ofbiz.org/catalog/control/EditProductStore


Regards
--
Chirag Manocha
HotWax Media Pvt. Ltd.
Website :- www.hotwaxmedia.com
Contact :- +91-98263-19099



Sumit Pandit wrote:

Hi Kumar,

Please refer eCommerce - DemoProduct.xml.

--
Thanks and Regards
Sumit Pandit

On 18-Sep-09, at 12:54 PM, Jitender Kumar Maurya wrote:


Hi,

can u please help : How to Create Own Store using ofbiz.

wating for reply

Thanks.
Kumar







--
View this message in context: 
http://www.nabble.com/How-to-Create-Own-Store-tp25504237p25530579.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: IBM surepos and ofbiz

2009-09-22 Thread Jacques Le Roux

I meaned, if you want me too look at this IBM code please send it (I suggest 
Nabble attachment or direct email to me)

Jacques

From: Jacques Le Roux jacques.le.r...@les7arts.com

I may have a look at IBM code, but I have none of them (kbd msr and line 
display) on hand.

Jacques

From: wmbo...@gmail.com

On Tuesday, September 8th a user posted Cannot open POS regarding
configuring javapos for a surepos 500.  I have a surepos 741 (older
with rs485), and have had some success.


I used the svn version of ofbiz though I don't think that should
matter.  I am on linux, but others can hopefully help with the
difference in operating systems.  I am not familar enough with
windows.

One thing unusual I had to do was to create links in
/ofbiz/specialpurpose/pos  to the /ibm/javapos and /javax-usb
directories.

ln -s /opt/ibm/javapos/ .
ln -s /opt/javax-usb/ .

Edited /ofbiz/specialpurpose/pos/ofbiz-component.xml to include those
directories.

ofbiz-component name=pos
   xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
   
xsi:noNamespaceSchemaLocation=http://ofbiz.apache.org/dtds/ofbiz-component.xsd;
   resource-loader name=main type=component/
   classpath type=dir location=config/
   classpath type=dir location=styles/
   classpath type=dir location=screens/
   classpath type=jar location=lib/*/
   classpath type=jar location=build/lib/*/
!-- These 4 lines are the lines I added →
!-- They must be relative to the current directory, possibly under
this directory →

   classpath type=dir location=javapos/etc/
   classpath type=jar location=javax-usb/lib/*/
   classpath type=dir location=javax-usb/etc/
   classpath type=jar location=javapos/lib/*/

Merged the correct devices from ibm jpos.xml into the
ofbiz/specialpurpose/pos/config/jpos.xml  file.
This was easiest by using the IBM tools to create a jpos file and then
putting all of the devices from that into the ofbiz jpos.xml file.

Then modified ofbiz/framework/base/config/pos-containers.xml to use
the correct device from the jpos.xml file.

I then did an ant run-install and ant run-install-seed

After that everything worked.

I am using a sun-java with ibm  java and javax-usb files in my system
class path, but it would not run links and changes to the
/ofbiz/specialpurpose/pos/ofbiz-component.xml file.

I have gotten both the pos printer an epson with an RS485 module that
mimics a model 4 and the ibm cash drawer RS485 working.
I would like to get the keyboard msr (not keyboard wedge) and display
device working but I am not sure they are implemented in ofbiz.  IBM
does include sample code in their control center for both.  I have
zilch in programming skills so that probably wouldn't help.

If anyone can give me some advice, I would give it a try though.








Re: How to Create Own Store

2009-09-22 Thread Jitender

what is the .ftl file in ofbiz
how it works?

wating for reply
---


Chirag Manocha-2 wrote:
 
 Hi Kumar,
 As Sumit said you can refer DemoProducts.xml and if you want to do the 
 setup from front end then you can refer 
 https://demo.ofbiz.org/catalog/control/EditProductStore
 
 Regards
 -- 
 Chirag Manocha
 HotWax Media Pvt. Ltd.
 Website :- www.hotwaxmedia.com
 Contact :- +91-98263-19099
 
 
 
 Sumit Pandit wrote:
 Hi Kumar,

 Please refer eCommerce - DemoProduct.xml.

 -- 
 Thanks and Regards
 Sumit Pandit

 On 18-Sep-09, at 12:54 PM, Jitender Kumar Maurya wrote:

 Hi,

 can u please help : How to Create Own Store using ofbiz.

 wating for reply

 Thanks.
 Kumar

 
 

-- 
View this message in context: 
http://www.nabble.com/How-to-Create-Own-Store-tp25504237p25530610.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: How to Create Own Store

2009-09-22 Thread Jacques Le Roux

http://freemarker.org/

Jacques

From: Jitender jitender.mau...@gmail.com


what is the .ftl file in ofbiz
how it works?

wating for reply
---


Chirag Manocha-2 wrote:


Hi Kumar,
As Sumit said you can refer DemoProducts.xml and if you want to do the 
setup from front end then you can refer 
https://demo.ofbiz.org/catalog/control/EditProductStore


Regards
--
Chirag Manocha
HotWax Media Pvt. Ltd.
Website :- www.hotwaxmedia.com
Contact :- +91-98263-19099



Sumit Pandit wrote:

Hi Kumar,

Please refer eCommerce - DemoProduct.xml.

--
Thanks and Regards
Sumit Pandit

On 18-Sep-09, at 12:54 PM, Jitender Kumar Maurya wrote:


Hi,

can u please help : How to Create Own Store using ofbiz.

wating for reply

Thanks.
Kumar







--
View this message in context: 
http://www.nabble.com/How-to-Create-Own-Store-tp25504237p25530610.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: Adding a custom date field to a product within a certain category

2009-09-22 Thread Simon Hutchinson

Thanks Scott,

This is looking like a possible approach.
It will certainly work from the perspective of our eCommerce  
application for search and display on the product detail page.


However I am still a little unsure from a back-office perspective.

The data model does not allow me to create ProductTypeAttr without a  
ProductAttribute due to PK constraint. I cannot create the  
ProductAttribute without a Product again due to a PK constraint.
I hoped form your post that I would be able to link ProductAttributes  
(without being associated to an existing Product) to specific  
ProductTypes with the with the link between Product and  
ProductAttributes being created at the time that the Product is added.


I can think of some ways of achieving this but it will involve more  
customisation of the catalog app then I would like to undertake  
(unless absolutely essential). Am I missing something obvious here?


To summarise, this solution is great from the ecommerce perspective  
and would do exactly what I want.
Is there a way of making this approach easier to administer from the  
back-office? Ideally, when a user is working in the catalog  
application and they create a product of type My Product then I  
would like the attribute fields to be presented (name, type), ready to  
be filled in with values if required. i.e Without the user needing to  
have prior knowledge of attribute name and type.


Thanks

Simon



On 21 Sep 2009, at 23:55, Scott Gray wrote:

Attributes could still be a decent fit, you could create new  
ProductTypes that are children of FINISHED_GOOD and tie the  
attributes to the ProductType via ProductTypeAttr.  You could then  
customize the Product UI to display the attributes depending on the  
ProductType selected.  If I'm not wrong ProductKeywords are  
generated from ProductAtrributes for they automatically be included  
in search results whereas you would have to customize the keyword  
generation for any new Product fields.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 22/09/2009, at 10:41 AM, Jacques Le Roux wrote:

In this case I would extend the Product entity, using (filling)  
this field uniquely when necessary


Jacques

From: Simon Hutchinson simon.hutchin...@ixxus.co.uk

Hi Jacques,
Thanks for the reply.
I don't know if attributes are the right solution or if I am  
missing  something.

If for example I have two types of products.
1. Books
2. Cars
These will share some product properties that are currently  
defined  e.g size, weight, description etc 
If I want to add something specific to books e.g numberOfPages  
then  are attributes the correct choice?
This will involve the user entering the data to know the name and  
type  of the attribute to enter as free text which seems error- 
prone.
I can see how attributes would be useful for adding ad-hoc  
information  to specific instances of product but this doesn't  
seem to be a good  solution for adding Product Type specific  
information that I might  need to search on for example.
Would you still advise that I use attributes based on this  
information  or should I be looking elsewhere?

Kind regards
Simon
On 20 Sep 2009, at 17:05, Jacques Le Roux wrote:
You may use an Attribute (see Attributes tab for a specific  
product)


Jacques

From: Simon Hutchinson simon.hutchin...@ixxus.co.uk

Hi all,
One of the items that our store is going to sell are publications.
I want to know the best way to  add a new date published   
property  for products that are created in the publications   
category.
I have looked into extending the Product entity but this  
solution   makes a product too specific.
I have researched features but can see how I can add a free  
entry   feature of a date type.
If anyone could point me in the right direction as to how best  
to   assign specific properties to products of a certain type  
that would  be  great.

Kind Regards
Simon Hutchinson
t: +44 (0)20 7033 2333  m: +44 (0)7595 020569  f: +44 (0)20 7033  
2330
a:   Ixxus Limited, Holywell Centre, 1 Phipp Street, London,  
EC2A 4PS

United Kingdom.  www.ixxus.com http://www.ixxus.com/
This message should be regarded as confidential. If you have  
received
this email in error please notify the sender and destroy it   
immediately.
Statements of intent shall only become binding when confirmed in  
hard

copy by an authorised signatory.




Kind Regards
Simon Hutchinson
t: +44 (0)20 7033 2333  m: +44 (0)7595 020569  f: +44 (0)20 7033  
2330
a:   Ixxus Limited, Holywell Centre, 1 Phipp Street, London, EC2A  
4PS

United Kingdom.  www.ixxus.com http://www.ixxus.com/
This message should be regarded as confidential. If you have  
received
this email in error please notify the sender and destroy it  
immediately.
Statements of intent shall only become binding when confirmed in  
hard

copy by an authorised signatory.







Kind Regards

Simon Hutchinson

t: +44 (0)20 7033 2333  m: +44 (0)7595 020569  f: +44 (0)20 7033 2330
a:   Ixxus 

Load Balancing in OFbiz

2009-09-22 Thread Neha . Mehta
Hi,

I want to load balance OFBiz requests using multiple servers(server 
cluster). Do i need to use multiple tomcat instances for that?? Is there 
any other efficient way to go for the same..

I need to set up session replication using embedded tomcat but i am not 
able to get any concrete steps to go ahead. Do i need multiple tomcat 
instances running on different servers respective to same OFBiz code base 
?? or different OFBiz deployed on different application servers?


Thanks  Regards,
Neha Mehta


__

Re: Adding a custom date field to a product within a certain category

2009-09-22 Thread Scott Gray

Hi Simon,

On 22/09/2009, at 8:05 PM, Simon Hutchinson wrote:


Thanks Scott,

This is looking like a possible approach.
It will certainly work from the perspective of our eCommerce  
application for search and display on the product detail page.


However I am still a little unsure from a back-office perspective.

The data model does not allow me to create ProductTypeAttr without a  
ProductAttribute due to PK constraint.


Do you mean without a ProductType?  There's no PK constraint related  
to ProductAttribute.  But yes you would need to create a ProductType  
first but tying the attributes to a ProductType is sort of the point.


I cannot create the ProductAttribute without a Product again due to  
a PK constraint.


That's correct but ProductTypeAttr should fill this need.

I hoped form your post that I would be able to link  
ProductAttributes (without being associated to an existing Product)  
to specific ProductTypes with the with the link between Product and  
ProductAttributes being created at the time that the Product is added.


That's correct, you'd need to add the logic yourself though.

I can think of some ways of achieving this but it will involve more  
customisation of the catalog app then I would like to undertake  
(unless absolutely essential). Am I missing something obvious here?


It's not uncommon to need to customize the various apps, the best way  
to do so is to extend applications using a separate hot-deploy app.   
You shouldn't need to change too much to support this though.


To summarise, this solution is great from the ecommerce perspective  
and would do exactly what I want.
Is there a way of making this approach easier to administer from the  
back-office? Ideally, when a user is working in the catalog  
application and they create a product of type My Product then I  
would like the attribute fields to be presented (name, type), ready  
to be filled in with values if required. i.e Without the user  
needing to have prior knowledge of attribute name and type.


The approach I described should work fine.  To summarize:
Add a UI for defining ProductTypes and adding attributes to them (I  
don't think this is present OOTB)
Add some logic to automatically create the ProductAttributes when a  
Product is created

That's really about all there is to it.

Regards
Scott



Thanks

Simon



On 21 Sep 2009, at 23:55, Scott Gray wrote:

Attributes could still be a decent fit, you could create new  
ProductTypes that are children of FINISHED_GOOD and tie the  
attributes to the ProductType via ProductTypeAttr.  You could then  
customize the Product UI to display the attributes depending on the  
ProductType selected.  If I'm not wrong ProductKeywords are  
generated from ProductAtrributes for they automatically be included  
in search results whereas you would have to customize the keyword  
generation for any new Product fields.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 22/09/2009, at 10:41 AM, Jacques Le Roux wrote:

In this case I would extend the Product entity, using (filling)  
this field uniquely when necessary


Jacques

From: Simon Hutchinson simon.hutchin...@ixxus.co.uk

Hi Jacques,
Thanks for the reply.
I don't know if attributes are the right solution or if I am  
missing  something.

If for example I have two types of products.
1. Books
2. Cars
These will share some product properties that are currently  
defined  e.g size, weight, description etc 
If I want to add something specific to books e.g numberOfPages  
then  are attributes the correct choice?
This will involve the user entering the data to know the name and  
type  of the attribute to enter as free text which seems error- 
prone.
I can see how attributes would be useful for adding ad-hoc  
information  to specific instances of product but this doesn't  
seem to be a good  solution for adding Product Type specific  
information that I might  need to search on for example.
Would you still advise that I use attributes based on this  
information  or should I be looking elsewhere?

Kind regards
Simon
On 20 Sep 2009, at 17:05, Jacques Le Roux wrote:
You may use an Attribute (see Attributes tab for a specific  
product)


Jacques

From: Simon Hutchinson simon.hutchin...@ixxus.co.uk

Hi all,
One of the items that our store is going to sell are  
publications.
I want to know the best way to  add a new date published   
property  for products that are created in the publications   
category.
I have looked into extending the Product entity but this  
solution   makes a product too specific.
I have researched features but can see how I can add a free  
entry   feature of a date type.
If anyone could point me in the right direction as to how best  
to   assign specific properties to products of a certain type  
that would  be  great.

Kind Regards
Simon Hutchinson
t: +44 (0)20 7033 2333  m: +44 (0)7595 020569  f: +44 (0)20  
7033 2330
a:   Ixxus Limited, Holywell Centre, 1 Phipp Street, London,  

Re: Load Balancing in OFbiz

2009-09-22 Thread Brett Palmer
Neha,

Here is a configuration we use to do load balancing in ofbiz.  Others may do
something else.

1. One machine is running an Apache Web server with mod_jk setup to
communicate with different instances of ofbiz.  The mod_jk is setup to load
balance between the different ofbiz instances.  Here is a document that
helps you get setup:

http://tomcat.apache.org/connectors-doc/generic_howto/loadbalancers.html


2. Then we start multiple boxes running ofbiz server - all pointing to the
same database.  The servers are setup to communicate using mod_jk's AJP
protocol.   You need to set the jvm-route in the
framework/base/config/ofbiz-containers.xml file to insure the load balancer
maintains sessions between requests.  Here is a snippet of that
configuration file.

container name=catalina-container
class=org.ofbiz.catalina.container.CatalinaContainer
!-- static configuration for tomcat --
property name=delegator-name value=default/
property name=use-naming value=false/
property name=debug value=0/
property name=catalina-runtime-home value=runtime/catalina/
property name=apps-context-reloadable value=false/
property name=apps-cross-context value=false/
property name=apps-distributable value=false/
!-- one or more tomcat engines (servers); map to this + host --
property name=default-server value=engine
property name=default-host value=0.0.0.0/
*property name=jvm-route value=jvm1/*
property name=access-log-pattern
.


3. One large box is running our database server.


We've been please with how well the Apache load balancing module works with
ofbiz.


Brett

On Tue, Sep 22, 2009 at 2:42 AM, neha.me...@lntinfotech.com wrote:

 Hi,

 I want to load balance OFBiz requests using multiple servers(server
 cluster). Do i need to use multiple tomcat instances for that?? Is there
 any other efficient way to go for the same..

 I need to set up session replication using embedded tomcat but i am not
 able to get any concrete steps to go ahead. Do i need multiple tomcat
 instances running on different servers respective to same OFBiz code base
 ?? or different OFBiz deployed on different application servers?


 Thanks  Regards,
 Neha Mehta


 __


Re: Load Balancing in OFbiz

2009-09-22 Thread Hans Bakker
Hi Neha,

because OFBiz is using Tomcat V5 check on the internet how to load
balance tomcat together with apache.

there is a lot of text on that, an example:
http://tomcat.apache.org/tomcat-5.5-doc/balancer-howto.html

Regards,
Hans

On Tue, 2009-09-22 at 14:12 +0530, neha.me...@lntinfotech.com wrote:
 Hi,
 
 I want to load balance OFBiz requests using multiple servers(server 
 cluster). Do i need to use multiple tomcat instances for that?? Is there 
 any other efficient way to go for the same..
 
 I need to set up session replication using embedded tomcat but i am not 
 able to get any concrete steps to go ahead. Do i need multiple tomcat 
 instances running on different servers respective to same OFBiz code base 
 ?? or different OFBiz deployed on different application servers?
 
 
 Thanks  Regards,
 Neha Mehta
 
 
 __
-- 
Antwebsystems.com: Quality OFBiz services for competitive rates



Re: Load Balancing in OFbiz

2009-09-22 Thread Scott Gray

OFBiz uses Tomcat v6

Regards
Scott

On 22/09/2009, at 9:35 PM, Hans Bakker wrote:


Hi Neha,

because OFBiz is using Tomcat V5 check on the internet how to load
balance tomcat together with apache.

there is a lot of text on that, an example:
http://tomcat.apache.org/tomcat-5.5-doc/balancer-howto.html

Regards,
Hans

On Tue, 2009-09-22 at 14:12 +0530, neha.me...@lntinfotech.com wrote:

Hi,

I want to load balance OFBiz requests using multiple servers(server
cluster). Do i need to use multiple tomcat instances for that?? Is  
there

any other efficient way to go for the same..

I need to set up session replication using embedded tomcat but i am  
not

able to get any concrete steps to go ahead. Do i need multiple tomcat
instances running on different servers respective to same OFBiz  
code base

?? or different OFBiz deployed on different application servers?


Thanks  Regards,
Neha Mehta


__

--
Antwebsystems.com: Quality OFBiz services for competitive rates





smime.p7s
Description: S/MIME cryptographic signature


How to create new role in ofbiz

2009-09-22 Thread naveen chanda

Hi All,

Could any one explain me the steps to create a new role in ofbiz and how to
add the roles to the user.

Thanks,
Naveen Chanda
-- 
View this message in context: 
http://www.nabble.com/How-to-create-new-role-in-ofbiz-tp25530705p25530705.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Vaildations in OFBiz

2009-09-22 Thread naveen chanda

Hi,

I am new to ofbiz implementation and i got a requirement to validate the zip
code as per the country and telephone numbers, could any one give me the
steps to this.

And, please provide me the steps to do validation for a simple text box,
which is empty.

Hope, you will provide me this.


Thanks,
Naveen Chanda
-- 
View this message in context: 
http://www.nabble.com/Vaildations-in-OFBiz-tp25530708p25530708.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Vaildations in OFBiz

2009-09-22 Thread Vikas Mayur

Naveen,

You may either want to use client side validation or server side  
validation or even both.


For former you can use javascript and for latter you can use simple  
map-processor.


For map-processor you can read from this link - 
http://ofbiz.apache.org/docs/minilang.html#Simple_Map_Processor

HTH!

Vikas
On Sep 22, 2009, at 6:23 PM, naveen chanda wrote:



Hi,

I am new to ofbiz implementation and i got a requirement to validate  
the zip
code as per the country and telephone numbers, could any one give me  
the

steps to this.

And, please provide me the steps to do validation for a simple text  
box,

which is empty.

Hope, you will provide me this.


Thanks,
Naveen Chanda
--
View this message in context: 
http://www.nabble.com/Vaildations-in-OFBiz-tp25530708p25530708.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: How to create new role in ofbiz

2009-09-22 Thread Vikas Mayur

Naveen,

Follow this link - 
https://demo.ofbiz.org/partymgr/control/viewroles?partyId=DemoCustomer

Vikas

On Sep 22, 2009, at 6:19 PM, naveen chanda wrote:



Hi All,

Could any one explain me the steps to create a new role in ofbiz and  
how to

add the roles to the user.

Thanks,
Naveen Chanda
--
View this message in context: 
http://www.nabble.com/How-to-create-new-role-in-ofbiz-tp25530705p25530705.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Re: Vaildations in OFBiz

2009-09-22 Thread Sumit Pandit

Hello Naveen,

You can find solution to your requirement at - demo.ofbiz.org, If you  
add few items to cart and then checkout via - https://demo.ofbiz.org/ecommerce/control/anonOnePageCheckout


Thanks and Regards
Sumit Pandit

On 22-Sep-09, at 6:23 PM, naveen chanda wrote:



Hi,

I am new to ofbiz implementation and i got a requirement to validate  
the zip
code as per the country and telephone numbers, could any one give me  
the

steps to this.

And, please provide me the steps to do validation for a simple text  
box,

which is empty.

Hope, you will provide me this.


Thanks,
Naveen Chanda
--
View this message in context: 
http://www.nabble.com/Vaildations-in-OFBiz-tp25530708p25530708.html
Sent from the OFBiz - User mailing list archive at Nabble.com.





Question related to GeronimoTransactionManager and JNDI

2009-09-22 Thread Jacopo Cappellato

Hi all,

I am one of the committers of the Apache OFBiz project, and as you may  
know we are using Geronimo Tx Manager as the default JTA implementation.


We have some code that is not working and I am wondering if you may  
give us some hints to fix it; the code below attempts to bind the  
GeronimoTransactionManager using JNDI:


InitialContext ic = new InitialContext();
ic.rebind(java:comp/UserTransaction, new  
GeronimoTransactionManager());


unfortunately the code above throws the following exception:

 java.lang.IllegalArgumentException: RegistryContext: object to bind  
must be Remote, Reference, or Referenceable


Thanks,

Jacopo Cappellato



Re: Question related to GeronimoTransactionManager and JNDI

2009-09-22 Thread Jacopo Cappellato

ooops... of course this was not intended for this mailing list :-)
sorry for the confusion... I probably need a coffee

Jacopo

On Sep 22, 2009, at 4:06 PM, Jacopo Cappellato wrote:


Hi all,

I am one of the committers of the Apache OFBiz project, and as you  
may know we are using Geronimo Tx Manager as the default JTA  
implementation.


We have some code that is not working and I am wondering if you may  
give us some hints to fix it; the code below attempts to bind the  
GeronimoTransactionManager using JNDI:


   InitialContext ic = new InitialContext();
   ic.rebind(java:comp/UserTransaction, new  
GeronimoTransactionManager());


unfortunately the code above throws the following exception:

java.lang.IllegalArgumentException: RegistryContext: object to bind  
must be Remote, Reference, or Referenceable


Thanks,

Jacopo Cappellato





Shipping Address for Order

2009-09-22 Thread su2

Hi Friends,

Where/in which entity can I find shipping address(not the postal/billing
address) related to order. 

Thanks for the help in advance.

Su-
-- 
View this message in context: 
http://www.nabble.com/Shipping-Address-for-Order-tp25530788p25530788.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



POS resolution 800x600

2009-09-22 Thread ngterry

Hi,

I have just modified the hard code variables in
/specialpurpose/pos/screens/default to fit 800x600 resolution by ratio.  But
the screen seems biased to the upper left.  How can I adjust it to the
center?  

Do I have to add several pixels to the top and left to orgin (0,0) to move
it back to center?

http://www.nabble.com/file/p25530823/screen.png 

Regards,
Terence 
-- 
View this message in context: 
http://www.nabble.com/POS-resolution-800x600-tp25530823p25530823.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



How to run Ofbiz as guest

2009-09-22 Thread ngterry

Hi,

How can I run Ofbiz in Windows XP as guest?  Ofbiz will be closed
automatically when I do not use my Administrator Account to run.  How do I
solve it?

Regards,
Terence
-- 
View this message in context: 
http://www.nabble.com/How-to-run-Ofbiz-as-guest-tp25530824p25530824.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Squares in POS panel for Chinese

2009-09-22 Thread ngterry

Hi,

How come the wording in the upper left of the POS panel for Chinese becoming
squares?
http://www.nabble.com/file/p25530826/screen.png 
Regards,
Terence
-- 
View this message in context: 
http://www.nabble.com/Squares-in-POS-panel-for-Chinese-tp25530826p25530826.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



contactMechId partyId

2009-09-22 Thread su2

Hello Friends,

What is the difference between partyId  contactMechID ? Where can I find
the relation between them?

Thanks for the help in advance.

Su-
-- 
View this message in context: 
http://www.nabble.com/contactMechId---partyId-tp25530830p25530830.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: contactMechId partyId

2009-09-22 Thread S K Pradeep Kumar
check the partyContactMech table

On Tue, Sep 22, 2009 at 10:40 PM, su2 shu...@pexsupply.com wrote:


 Hello Friends,

 What is the difference between partyId  contactMechID ? Where can I find
 the relation between them?

 Thanks for the help in advance.

 Su-
 --
 View this message in context:
 http://www.nabble.com/contactMechId---partyId-tp25530830p25530830.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.




-- 
With regards,
S K Pradeep kumar


Re: contactMechId partyId

2009-09-22 Thread Shuchi Mehta
I can see the relation, but I still do not know the significance of 
contactMechId.


S K Pradeep Kumar wrote:

check the partyContactMech table

On Tue, Sep 22, 2009 at 10:40 PM, su2 shu...@pexsupply.com wrote:

  

Hello Friends,

What is the difference between partyId  contactMechID ? Where can I find
the relation between them?

Thanks for the help in advance.

Su-
--
View this message in context:
http://www.nabble.com/contactMechId---partyId-tp25530830p25530830.html
Sent from the OFBiz - User mailing list archive at Nabble.com.






  


Re: contactMechId partyId

2009-09-22 Thread su2

What is the significance of contactMechID? 




su2 wrote:
 
 Hello Friends,
 
 What is the difference between partyId  contactMechID ? Where can I find
 the relation between them?
 
 Thanks for the help in advance.
 
 Su-
 

-- 
View this message in context: 
http://www.nabble.com/contactMechId---partyId-tp25530830p25530834.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: contactMechId partyId

2009-09-22 Thread Erwan de FERRIERES

In the data model book vol 1, page 53

Le 22/09/2009 19:22, su2 a écrit :


What is the significance of contactMechID?




su2 wrote:


Hello Friends,

What is the difference between partyId  contactMechID ? Where can I find
the relation between them?

Thanks for the help in advance.

Su-





--
Erwan


Re: contactMechId partyId

2009-09-22 Thread Adrian Crum

Do you have a copy of The Data Model Resource book?

http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Related+Books

-Adrian

su2 wrote:

Hello Friends,

What is the difference between partyId  contactMechID ? Where can I find
the relation between them?

Thanks for the help in advance.

Su-


RE: contactMechId partyId

2009-09-22 Thread Abhai Chaudhary
ContactMechID represents the primary mode of communication with a contact, 
possible Option could be Phone, Email etc. You can always customize these 
options from entitydef.xml for part application.





-Original Message-
From: su2 [mailto:shu...@pexsupply.com]
Sent: Tuesday, September 22, 2009 10:22 AM
To: user@ofbiz.apache.org
Subject: Re: contactMechId  partyId


What is the significance of contactMechID?




su2 wrote:

 Hello Friends,

 What is the difference between partyId  contactMechID ? Where can I find
 the relation between them?

 Thanks for the help in advance.

 Su-


--
View this message in context: 
http://www.nabble.com/contactMechId---partyId-tp25530830p25530834.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


http://www.mindtree.com/email/disclaimer.html


Re: contactMechId partyId

2009-09-22 Thread S K Pradeep Kumar
   The contactMechId is the primary key for each contact mechanisms that
associate with particular party. You can see that in the contactMech table,
there is one contact mech id for each and every contact mechanisms and their
contact mech types .

On Tue, Sep 22, 2009 at 10:53 PM, Shuchi Mehta shu...@pexsupply.com wrote:

 I can see the relation, but I still do not know the significance of
 contactMechId.


 S K Pradeep Kumar wrote:

 check the partyContactMech table

 On Tue, Sep 22, 2009 at 10:40 PM, su2 shu...@pexsupply.com wrote:



 Hello Friends,

 What is the difference between partyId  contactMechID ? Where can I find
 the relation between them?

 Thanks for the help in advance.

 Su-
 --
 View this message in context:
 http://www.nabble.com/contactMechId---partyId-tp25530830p25530830.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.











-- 
With regards,
S K Pradeep kumar


Re: Vaildations in OFBiz

2009-09-22 Thread masionas

Form what I see you will have to load zip code - (country and telephone)
data file into ofbiz entity. And write a simple code to make a lookup and
match.


naveen chanda wrote:
 
 Hi,
 
 I am new to ofbiz implementation and i got a requirement to validate the
 zip code as per the country and telephone numbers, could any one give me
 the steps to this.
 
 And, please provide me the steps to do validation for a simple text box,
 which is empty.
 
 Hope, you will provide me this.
 
 
 Thanks,
 Naveen Chanda
 

-- 
View this message in context: 
http://www.nabble.com/Vaildations-in-OFBiz-tp25530708p25530865.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



View-entity with WHERE clause

2009-09-22 Thread su2

Hello Friends,

I would like to create a view entity for entity orderheader and
orderContactMech. I want to have that to represent following SQL.

---
SELECT orderheader.orderId, orderheader.orderDate,
orderContactMech.contactMechId 
FROM orderheader OUTER JOIN  orderContactMech ON orderheader.orderId =
orderContactMech.orderId
WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
---

I have idea how to create view entity without WHERE clause. But not sure how
to add WHERE clause.

I appreciate the help.

Thanks in advance.

Su-




-- 
View this message in context: 
http://www.nabble.com/View-entity-with-WHERE-clause-tp25530883p25530883.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: View-entity with WHERE clause

2009-09-22 Thread BJ Freeman
http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
The where is in the find query.
or conditionals in the widgets.

su2 sent the following on 9/22/2009 12:52 PM:
 Hello Friends,
 
 I would like to create a view entity for entity orderheader and
 orderContactMech. I want to have that to represent following SQL.
 
 ---
 SELECT orderheader.orderId, orderheader.orderDate,
 orderContactMech.contactMechId 
 FROM orderheader OUTER JOIN  orderContactMech ON orderheader.orderId =
 orderContactMech.orderId
 WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
 ---
 
 I have idea how to create view entity without WHERE clause. But not sure how
 to add WHERE clause.
 
 I appreciate the help.
 
 Thanks in advance.
 
 Su-
 
 
 
 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.



Re: Shipping Address for Order

2009-09-22 Thread BJ Freeman
a view entity that includes the type of address

su2 sent the following on 9/22/2009 8:29 AM:
 Hi Friends,
 
 Where/in which entity can I find shipping address(not the postal/billing
 address) related to order. 
 
 Thanks for the help in advance.
 
 Su-

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.



Re: contactMechId partyId

2009-09-22 Thread BJ Freeman
look at the contact Mech Entity it tells you the relationships.

su2 sent the following on 9/22/2009 10:10 AM:
 Hello Friends,
 
 What is the difference between partyId  contactMechID ? Where can I find
 the relation between them?
 
 Thanks for the help in advance.
 
 Su-

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.



Re: View-entity with WHERE clause

2009-09-22 Thread Shuchi Mehta
Sorry I was not able to understand find query part. I got the widget 
part. Where do we specify find query?


Thank you for the help.
Su-



BJ Freeman wrote:

http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
The where is in the find query.
or conditionals in the widgets.

su2 sent the following on 9/22/2009 12:52 PM:
  

Hello Friends,

I would like to create a view entity for entity orderheader and
orderContactMech. I want to have that to represent following SQL.

---
SELECT orderheader.orderId, orderheader.orderDate,
orderContactMech.contactMechId 
FROM orderheader OUTER JOIN  orderContactMech ON orderheader.orderId =

orderContactMech.orderId
WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
---

I have idea how to create view entity without WHERE clause. But not sure how
to add WHERE clause.

I appreciate the help.

Thanks in advance.

Su-







  


Re: View-entity with WHERE clause

2009-09-22 Thread BJ Freeman
it is in the same document I gave a link to
under Finding
please read the whole document.

Shuchi Mehta sent the following on 9/22/2009 1:32 PM:
 Sorry I was not able to understand find query part. I got the widget
 part. Where do we specify find query?
 
 Thank you for the help.
 Su-
 
 
 
 BJ Freeman wrote:
 http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
 The where is in the find query.
 or conditionals in the widgets.

 su2 sent the following on 9/22/2009 12:52 PM:
  
 Hello Friends,

 I would like to create a view entity for entity orderheader and
 orderContactMech. I want to have that to represent following SQL.

 ---

 SELECT orderheader.orderId, orderheader.orderDate,
 orderContactMech.contactMechId FROM orderheader OUTER JOIN 
 orderContactMech ON orderheader.orderId =
 orderContactMech.orderId
 WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
 ---


 I have idea how to create view entity without WHERE clause. But not
 sure how
 to add WHERE clause.

 I appreciate the help.

 Thanks in advance.

 Su-




 

   
 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.



Re: View-entity with WHERE clause

2009-09-22 Thread Shuchi Mehta

Thank you. And apologize for being little impatient.

I read the document, and what I understood is Finding (findByAnd) method 
is used in .bsh file. So, I just want to make sure that there is no way 
to specify WHERE clause while creating the view-entity. correct?


Again, thanks for your help.
Shuchi-

BJ Freeman wrote:

it is in the same document I gave a link to
under Finding
please read the whole document.

Shuchi Mehta sent the following on 9/22/2009 1:32 PM:
  

Sorry I was not able to understand find query part. I got the widget
part. Where do we specify find query?

Thank you for the help.
Su-



BJ Freeman wrote:


http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
The where is in the find query.
or conditionals in the widgets.

su2 sent the following on 9/22/2009 12:52 PM:
 
  

Hello Friends,

I would like to create a view entity for entity orderheader and
orderContactMech. I want to have that to represent following SQL.

---

SELECT orderheader.orderId, orderheader.orderDate,
orderContactMech.contactMechId FROM orderheader OUTER JOIN 
orderContactMech ON orderheader.orderId =

orderContactMech.orderId
WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
---


I have idea how to create view entity without WHERE clause. But not
sure how
to add WHERE clause.

I appreciate the help.

Thanks in advance.

Su-






  
  


  


View-entity does not work with 3 member-Entities

2009-09-22 Thread su2

Hello Friends,

I am trying to create view-entity which works fine with 2 entities but does
not work with 3 entity-member.

I have couple of questions.

1. Is there any restriction on entity-member while creating view-entity ?
2. Is it possible to create view-entity using other view-entity instead of
entity ?

I really appreciate the help.

Thanks you.
Su-
-- 
View this message in context: 
http://www.nabble.com/View-entity-does-not-work-with-3-member-Entities-tp25530906p25530906.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: View-entity with WHERE clause

2009-09-22 Thread BJ Freeman
findby can be used in minilanq, and java, which includes the bsh
\framework\entity\dtd\entitymodel.xsd has all the current capablities.
since your using 4.0 you will have to see since I don't use it any more.

Shuchi Mehta sent the following on 9/22/2009 1:48 PM:
 Thank you. And apologize for being little impatient.
 
 I read the document, and what I understood is Finding (findByAnd) method
 is used in .bsh file. So, I just want to make sure that there is no way
 to specify WHERE clause while creating the view-entity. correct?
 
 Again, thanks for your help.
 Shuchi-
 
 BJ Freeman wrote:
 it is in the same document I gave a link to
 under Finding
 please read the whole document.

 Shuchi Mehta sent the following on 9/22/2009 1:32 PM:
  
 Sorry I was not able to understand find query part. I got the widget
 part. Where do we specify find query?

 Thank you for the help.
 Su-



 BJ Freeman wrote:

 http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
 The where is in the find query.
 or conditionals in the widgets.

 su2 sent the following on 9/22/2009 12:52 PM:
  
  
 Hello Friends,

 I would like to create a view entity for entity orderheader and
 orderContactMech. I want to have that to represent following SQL.

 ---


 SELECT orderheader.orderId, orderheader.orderDate,
 orderContactMech.contactMechId FROM orderheader OUTER JOIN
 orderContactMech ON orderheader.orderId =
 orderContactMech.orderId
 WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
 ---



 I have idea how to create view entity without WHERE clause. But not
 sure how
 to add WHERE clause.

 I appreciate the help.

 Thanks in advance.

 Su-




 
 

   
 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.



Re: Shipping Address for Order

2009-09-22 Thread Scott Gray

BJ,

Please try and keep in mind that there are hundreds of subscribers on  
these mailing lists and sending junk responses such as this is really  
just a waste of everyones time.


Thanks


Su,

Same as my last response, Orders and ContactMechs are tied together  
using OrderContactMech, the contactMechPurposeTypeId that you want to  
match is SHIPPING_LOCATION.  I strongly recommend that you start  
browsing the entities using webtools and trying to understand how they  
relate otherwise this is going to be a very long process for you.


Regards
Scott

On 23/09/2009, at 8:21 AM, BJ Freeman wrote:


a view entity that includes the type of address

su2 sent the following on 9/22/2009 8:29 AM:

Hi Friends,

Where/in which entity can I find shipping address(not the postal/ 
billing

address) related to order.

Thanks for the help in advance.

Su-


--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Systems Integrator.





smime.p7s
Description: S/MIME cryptographic signature


Re: View-entity with WHERE clause

2009-09-22 Thread Yoke Power
Hi Su,

Just to give a back ground, Entity and View Entity work in the same fashion
at runtime/query execution; the only difference being, entity is used for
single entity and view-entity is used for combining multiple entities; that
being said, entity OR view-entity query has two parts namely

1) Static Part -- Entity or View-Entity (Joined Tables) - defined in
the xml i.e. entitymodel.xml
2) Dynamic Part -- Where condition, Having, Order By etc -- Passed at
runtime

If you want to create the view-entity with Where condition using mini lang
use entity-condition
if you want to create the view-entity in java call the Generic Delegator's
find method and pass the condition (object) as the second parameter i.e. the
method signature is
public EntityListIterator find(String entityName, EntityCondition
whereEntityCondition,
EntityCondition havingEntityCondition, SetString
fieldsToSelect, ListString orderBy, EntityFindOptions findOptions)
throws GenericEntityException

Example of calling the find method in the Service can be found in
org.ofbiz.accounting.finaccount.FinAccountServices.java

EntityCondition condition =
EntityCondition.makeCondition(exprs, EntityOperator.AND);
EntityListIterator eli = null;
try {
eli = delegator.find(FinAccountTrans, condition, null,
null, UtilMisc.toList(-transactionDate), null);

Let us know if you have questions

- YOKEPOWER


On Tue, Sep 22, 2009 at 6:05 PM, BJ Freeman bjf...@free-man.net wrote:

 findby can be used in minilanq, and java, which includes the bsh
 \framework\entity\dtd\entitymodel.xsd has all the current capablities.
 since your using 4.0 you will have to see since I don't use it any more.

 Shuchi Mehta sent the following on 9/22/2009 1:48 PM:
  Thank you. And apologize for being little impatient.
 
  I read the document, and what I understood is Finding (findByAnd) method
  is used in .bsh file. So, I just want to make sure that there is no way
  to specify WHERE clause while creating the view-entity. correct?
 
  Again, thanks for your help.
  Shuchi-
 
  BJ Freeman wrote:
  it is in the same document I gave a link to
  under Finding
  please read the whole document.
 
  Shuchi Mehta sent the following on 9/22/2009 1:32 PM:
 
  Sorry I was not able to understand find query part. I got the
 widget
  part. Where do we specify find query?
 
  Thank you for the help.
  Su-
 
 
 
  BJ Freeman wrote:
 
  http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling
  The where is in the find query.
  or conditionals in the widgets.
 
  su2 sent the following on 9/22/2009 12:52 PM:
 
 
  Hello Friends,
 
  I would like to create a view entity for entity orderheader and
  orderContactMech. I want to have that to represent following SQL.
 
 
 ---
 
 
  SELECT orderheader.orderId, orderheader.orderDate,
  orderContactMech.contactMechId FROM orderheader OUTER JOIN
  orderContactMech ON orderheader.orderId =
  orderContactMech.orderId
  WHERE orderContactMech.contactMechPurposeTypeId =
 'SHIPPING_LOCATION'.
 
 ---
 
 
 
  I have idea how to create view entity without WHERE clause. But not
  sure how
  to add WHERE clause.
 
  I appreciate the help.
 
  Thanks in advance.
 
  Su-
 
 
 
 
 
 
 
 
 

 --
 BJ Freeman
 http://www.businessesnetwork.com/automation
 http://bjfreeman.elance.com

 http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
 Systems Integrator.




Re: View-entity does not work with 3 member-Entities

2009-09-22 Thread Yoke Power
hi Su,

Answers inline

On Tue, Sep 22, 2009 at 5:07 PM, su2 shu...@pexsupply.com wrote:


 Hello Friends,

 I am trying to create view-entity which works fine with 2 entities but does
 not work with 3 entity-member.

 I have couple of questions.

 1. Is there any restriction on entity-member while creating view-entity ?

  ANS: There is no restriction in the entity-member while
creating view-entity; you could use the entity or a view-entity as a part of
the View-Entity creation

 2. Is it possible to create view-entity using other view-entity instead of
 entity ?

  ANS:  Yes it is possbile


 I really appreciate the help.

 Thanks you.
 Su-
 --
 View this message in context:
 http://www.nabble.com/View-entity-does-not-work-with-3-member-Entities-tp25530906p25530906.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.




Re: View-entity with WHERE clause

2009-09-22 Thread David E Jones


In the OFBiz trunk there is an option for view-entity definitions to  
include an entity-condition element that is similar to the ones in  
simple-method and various widgets, and that will allow you to add a  
where condition to the view-entity def.


-David


On Sep 22, 2009, at 1:52 PM, su2 wrote:



Hello Friends,

I would like to create a view entity for entity orderheader and
orderContactMech. I want to have that to represent following SQL.

---
SELECT orderheader.orderId, orderheader.orderDate,
orderContactMech.contactMechId
FROM orderheader OUTER JOIN  orderContactMech ON orderheader.orderId =
orderContactMech.orderId
WHERE orderContactMech.contactMechPurposeTypeId = 'SHIPPING_LOCATION'.
---

I have idea how to create view entity without WHERE clause. But not  
sure how

to add WHERE clause.

I appreciate the help.

Thanks in advance.

Su-




--
View this message in context: 
http://www.nabble.com/View-entity-with-WHERE-clause-tp25530883p25530883.html
Sent from the OFBiz - User mailing list archive at Nabble.com.




Delivering .swf files via the serveObjectData object

2009-09-22 Thread Al Byers
Has anyone delivered a Flash movie using the streaming capability of the
content management system? I am looking at it in the debugger and it seems
to be delivering content, but I am wondering if there are headers or
something that needs to be done to get a movie to display? Instead of
displaying the movie in the browser, it pops ups the download window and
asks how to display it.

-Al


Re: Load Balancing in OFbiz

2009-09-22 Thread Neha . Mehta
Hi Brett,

Thanx for your generosity.
I have to load balance OFBiz on multiple servers. For this do i need to 
have replica of my OFBiz code running on multiple servers and run embedded 
OFBiz tomcat on all these servers??? Or do i need to have multiple tomcat 
instances on a single server?? ALso please let me know, is it better to 
use embedded tomcat or external tomcat for load balancing ??

All the forums that i have read talk about running multiple tomcat 
instances on same server.. I do not understand the reason behind this.. 
Kindly help me out.



Thanks  Regards,
Neha Mehta


__

Re: Delivering .swf files via the serveObjectData object

2009-09-22 Thread Al Byers
These are the headers when coming for this non-working url:
https://localhost:8443/eng/control/stream?contentId=247658

ServerApache-Coyote/1.1
ExpiresWed, 23 Sep 2009 04:34:06 GMT
Last-ModifiedWed, 23 Sep 2009 04:34:06 GMT
Cache-Controlno-store, no-cache, must-revalidate, post-check=0,
pre-check=0, false
Pragmano-cache
Content-Dispositionattachment;filename=q32_engine.swf
Content-Typeapplication/x-shockwave-flash;charset=UTF-8
Content-Length309183
DateWed, 23 Sep 2009 04:34:06 GMT
Request Headers
Hostlocalhost:8443
User-AgentMozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3
Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Languageen-us,en;q=0.5
Accept-Encodinggzip,deflate
Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive300
Connectionkeep-alive
Refererhttps://localhost:8443/eng/control/AuthorTool
CookieSaveStateCookie=undefined%2Cassess%2Croot%2COPTION_LABELING%2COPTION_GROUP%2COPTION_MATCH%2COPTION_ANY%2COPTION_ONE%2Cnull%2C%2C1%2C2%2C3%2C4%2C7%2C5%2C6%2C99;
JSESSIONID=30505A4145DF6140132481E34E6F3364.jvm1;
pe.autoUserLoginId=admin; webtools.autoUserLoginId=admin;
eng.autoUserLoginId=admin; OFBiz.Visitor=10001

These are the headers for the working url:
http://localhost:8080/eng/images/q32_engine.swf

ServerApache-Coyote/1.1
EtagW/309183-1253597059000
Last-ModifiedTue, 22 Sep 2009 05:24:19 GMT
Content-Typeapplication/x-shockwave-flash
Content-Length309183
DateWed, 23 Sep 2009 04:38:14 GMT
Request Headers
Hostlocalhost:8080
User-AgentMozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3
Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Languageen-us,en;q=0.5
Accept-Encodinggzip,deflate
Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive300
Connectionkeep-alive
CookieJSESSIONID=30505A4145DF6140132481E34E6F3364.jvm1;
pe.autoUserLoginId=admin; webtools.autoUserLoginId=admin;
eng.autoUserLoginId=admin; OFBiz.Visitor=10001

Does anybody see anything?

-Al

On Tue, Sep 22, 2009 at 9:26 PM, Al Byers bye...@automationgroups.com wrote:

 Has anyone delivered a Flash movie using the streaming capability of the 
 content management system? I am looking at it in the debugger and it seems to 
 be delivering content, but I am wondering if there are headers or something 
 that needs to be done to get a movie to display? Instead of displaying the 
 movie in the browser, it pops ups the download window and asks how to display 
 it.

 -Al


Re: Delivering .swf files via the serveObjectData object

2009-09-22 Thread Brett Palmer
Al,

The only thing I see that stands out is the chartset setting for the
non-working CMS url.

charset=UTF-8

Maybe setting the chartset the flashplayer assumes it is text and not binary
file.


Brett

On Tue, Sep 22, 2009 at 11:01 PM, Al Byers bye...@automationgroups.comwrote:

 These are the headers when coming for this non-working url:
 https://localhost:8443/eng/control/stream?contentId=247658

 ServerApache-Coyote/1.1
 ExpiresWed, 23 Sep 2009 04:34:06 GMT
 Last-ModifiedWed, 23 Sep 2009 04:34:06 GMT
 Cache-Controlno-store, no-cache, must-revalidate, post-check=0,
 pre-check=0, false
 Pragmano-cache
 Content-Dispositionattachment;filename=q32_engine.swf
 Content-Typeapplication/x-shockwave-flash;charset=UTF-8
 Content-Length309183
 DateWed, 23 Sep 2009 04:34:06 GMT
 Request Headers
 Hostlocalhost:8443
 User-AgentMozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
 rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3
 Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 Accept-Languageen-us,en;q=0.5
 Accept-Encodinggzip,deflate
 Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
 Keep-Alive300
 Connectionkeep-alive
 Refererhttps://localhost:8443/eng/control/AuthorTool

 CookieSaveStateCookie=undefined%2Cassess%2Croot%2COPTION_LABELING%2COPTION_GROUP%2COPTION_MATCH%2COPTION_ANY%2COPTION_ONE%2Cnull%2C%2C1%2C2%2C3%2C4%2C7%2C5%2C6%2C99;
 JSESSIONID=30505A4145DF6140132481E34E6F3364.jvm1;
 pe.autoUserLoginId=admin; webtools.autoUserLoginId=admin;
 eng.autoUserLoginId=admin; OFBiz.Visitor=10001

 These are the headers for the working url:
 http://localhost:8080/eng/images/q32_engine.swf

 ServerApache-Coyote/1.1
 EtagW/309183-1253597059000
 Last-ModifiedTue, 22 Sep 2009 05:24:19 GMT
 Content-Typeapplication/x-shockwave-flash
 Content-Length309183
 DateWed, 23 Sep 2009 04:38:14 GMT
 Request Headers
 Hostlocalhost:8080
 User-AgentMozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
 rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3
 Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 Accept-Languageen-us,en;q=0.5
 Accept-Encodinggzip,deflate
 Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
 Keep-Alive300
 Connectionkeep-alive
 CookieJSESSIONID=30505A4145DF6140132481E34E6F3364.jvm1;
 pe.autoUserLoginId=admin; webtools.autoUserLoginId=admin;
 eng.autoUserLoginId=admin; OFBiz.Visitor=10001

 Does anybody see anything?

 -Al

 On Tue, Sep 22, 2009 at 9:26 PM, Al Byers bye...@automationgroups.com
 wrote:
 
  Has anyone delivered a Flash movie using the streaming capability of the
 content management system? I am looking at it in the debugger and it seems
 to be delivering content, but I am wondering if there are headers or
 something that needs to be done to get a movie to display? Instead of
 displaying the movie in the browser, it pops ups the download window and
 asks how to display it.
 
  -Al



Re: Load Balancing in OFbiz

2009-09-22 Thread Brett Palmer
1.  We run one instance of ofbiz on a separate server but this is because we
are running a single application and want to scale by adding more machines.

2.  It is easier to use the embedded ofbiz version rather than a standalone
tomcat with ofbiz placed as a standard WAR file.  From the Apache Web server
perspective there isn't any difference.  It is talking AJP protocol and
can't tell if it is an embedded version of tomcat or standalone.

3.  I'm not sure the reason some are running several version of ofbiz on the
same machine.  My guess is they have different customers or application and
don't need the extra hardware to service these applications.  We multiple
instances of ofbiz on the same machine but this is so we can have a dev,
testing, and production version running on the same machine.

For maximum scalability you would put 1 instance of ofbiz on a single
machine and load balance between these machines.  We are using Amazon's EC2
servers so it is easy for us to shutdown to a single server at night and
then start up several server during the days when the application is busy.


Brett

On Tue, Sep 22, 2009 at 10:45 PM, neha.me...@lntinfotech.com wrote:

 Hi Brett,

 Thanx for your generosity.
 I have to load balance OFBiz on multiple servers. For this do i need to
 have replica of my OFBiz code running on multiple servers and run embedded
 OFBiz tomcat on all these servers??? Or do i need to have multiple tomcat
 instances on a single server?? ALso please let me know, is it better to
 use embedded tomcat or external tomcat for load balancing ??

 All the forums that i have read talk about running multiple tomcat
 instances on same server.. I do not understand the reason behind this..
 Kindly help me out.



 Thanks  Regards,
 Neha Mehta


 __


Re: Load Balancing in OFbiz

2009-09-22 Thread Brett Palmer
and Yes, you need to replicate the same code on all the different machines.
 We have used subversion to do this as you only need to update each server
to the version you want to run.  Then manually modify some config files such
as the jvm path that I indicated earlier and your up and running.


Brett

On Tue, Sep 22, 2009 at 11:30 PM, Brett Palmer brettgpal...@gmail.comwrote:

 1.  We run one instance of ofbiz on a separate server but this is because
 we are running a single application and want to scale by adding more
 machines.

 2.  It is easier to use the embedded ofbiz version rather than a standalone
 tomcat with ofbiz placed as a standard WAR file.  From the Apache Web server
 perspective there isn't any difference.  It is talking AJP protocol and
 can't tell if it is an embedded version of tomcat or standalone.

 3.  I'm not sure the reason some are running several version of ofbiz on
 the same machine.  My guess is they have different customers or application
 and don't need the extra hardware to service these applications.  We
 multiple instances of ofbiz on the same machine but this is so we can have a
 dev, testing, and production version running on the same machine.

 For maximum scalability you would put 1 instance of ofbiz on a single
 machine and load balance between these machines.  We are using Amazon's EC2
 servers so it is easy for us to shutdown to a single server at night and
 then start up several server during the days when the application is busy.


 Brett

 On Tue, Sep 22, 2009 at 10:45 PM, neha.me...@lntinfotech.com wrote:

 Hi Brett,

 Thanx for your generosity.
 I have to load balance OFBiz on multiple servers. For this do i need to
 have replica of my OFBiz code running on multiple servers and run embedded
 OFBiz tomcat on all these servers??? Or do i need to have multiple tomcat
 instances on a single server?? ALso please let me know, is it better to
 use embedded tomcat or external tomcat for load balancing ??

 All the forums that i have read talk about running multiple tomcat
 instances on same server.. I do not understand the reason behind this..
 Kindly help me out.



 Thanks  Regards,
 Neha Mehta


 __