Re: Page Push/Following
Hi, Normally a page push is that the server can pushes to the client more than one page at the same time. The client side of Internet Explorer is or was not ready for this functionality. That's all i know about it. regards, Heidi Olagos 2009/8/10 snowc chsnow...@gmail.com What is Page Push/Following used for in the party visit screen of partymgr? Many thanks, Chris -- View this message in context: http://www.nabble.com/Page-Push-Following-tp24897956p24897956.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many the same products in the catalog screen from the catalog manager
Hello all, I will take a look on it. I think this is a solution. I will inform you on the results. regards, Heidi 2009/8/2 Ahmed Dini asd...@hotmail.com Hello Heidi, This is the link to the patch for the deleting problem. https://issues.apache.org/jira/browse/OFBIZ-2788 https://issues.apache.org/jira/browse/OFBIZ-2788 Good Luck Ahmed Dini wrote: Hello Heidi, I can't help you with why one product is showing 10 times in the same screen, you might need to see this link if you haven't seen before http://docs.ofbiz.org/display/OFBENDUSER/08+Category+-+Edit+Category+screens http://docs.ofbiz.org/display/OFBENDUSER/08+Category+-+Edit+Category+screens . But If you know how to apply patches to your local files I can fix the deleting issue. As I guessed from your error the non-secure link is in EditCategoryProduct.ftl. In my next post, I will post the link to the Jira for this patch. Heidi Dehaes wrote: Hello, VERSION 09.04 In a certain category products screen in the catalog manager i have added products. However a certain product x is visualised 10 times in that screen. Also in the catalog page in the ecommerce site i have this product x 10 times visualised. When i try to delete 9 of them, i get the following error: De volgende fouten kwamen voor: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Found URL parameter [productCategoryId] passed to secure (https) request-map with uri [removeCategoryProductMember] with an event that calls service [removeProductFromCategory]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at http://docs.ofbiz.org/x/r. Thank you in advance for your help. Also i don't find where this products are related to the category in the database. Can someone help me on this then i can delete the 9 extra products referrings in the catalog in the database. thanks , Heidi -- View this message in context: http://www.nabble.com/Many-the-same-products-in-the-catalog-screen-from-the-catalog-manager-tp24777387p24780624.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Many the same products in the catalog screen from the catalog manager
Hello, VERSION 09.04 In a certain category products screen in the catalog manager i have added products. However a certain product x is visualised 10 times in that screen. Also in the catalog page in the ecommerce site i have this product x 10 times visualised. When i try to delete 9 of them, i get the following error: De volgende fouten kwamen voor: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Found URL parameter [productCategoryId] passed to secure (https) request-map with uri [removeCategoryProductMember] with an event that calls service [removeProductFromCategory]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at http://docs.ofbiz.org/x/r. Thank you in advance for your help. Also i don't find where this products are related to the category in the database. Can someone help me on this then i can delete the 9 extra products referrings in the catalog in the database. thanks , Heidi
Fwd: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.StackOverflowError
-- Forwarded message -- From: Heidi Dehaes info.ola...@gmail.com Date: 2009/6/16 Subject: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.StackOverflowError To: user@ofbiz.apache.org Hello, I added some text language conversions to the EcommerceUILabel.xml file in the Ecommerce subdirectory of the version 09.04 of ofbiz. These text language conversions are used on the same page. But from now on if i switch to another language i have the following error: Erreur lors de l'appel de l'événement: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.StackOverflowError (null) How can i prevent the stackoverflowerror? Can i increase some parameter anywhere?? thanks in advance, Heidi Olagos bvba
org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.StackOverflowError
Hello, I added some text language conversions to the EcommerceUILabel.xml file in the Ecommerce subdirectory of the version 09.04 of ofbiz. These text language conversions are used on the same page. But from now on if i switch to another language i have the following error: Erreur lors de l'appel de l'événement: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.StackOverflowError (null) How can i prevent the stackoverflowerror? Can i increase some parameter anywhere?? thanks in advance, Heidi Olagos bvba
Re: Finding the right name for a new component
Hello, In Belgium we call this functionality ticking. regards, Heidi 2009/5/4 Erwan de FERRIERES erwan.de-ferrie...@nereide.biz Dear all, We have to develop an application based on OFBiz. In this application, there will be a system for clocking in/out for the employees.Once this new feature will be created, it will be submitted to the community. So I just want to give the right name to the entities, to be sure it is understandable for everyone. We were thinking of : * ClockingEntry (one entry) * ClockingAnomaly (one anomaly) * ClockingGroup (a group of rules) If those names are Ok for you, then we will keep with them. If you've got a better idea, don't hesitate to tell me ! Cheers, -- - Erwan -
Re: Fwd: adding an extra payment method
yes, thanks for the help. But i saw also these paymentoptions.ftl and the problem (the hardcoding) has still to be anywhere else. I will check further. If you find something interesting about this, please let me know also. Heidi 2009/3/8 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 guess I should have just ask if it was still set to paypal. that would cause you to see the paypal as well as xyz. Actually I think your referring to when a customer is in the cart https://demo40.hotwaxmedia.com/ecommerce/control/checkoutoptions view-map name=checkoutpayment type=screen page=component://ecommerce/widget/OrderScreens.xml#checkoutpayment/ Which leads you to ecommerce/webapp/ecommerce/order/paymentoptions.ftl note the code: #if productStorePaymentMethodTypeIdMap.EXT_OFFLINE?exists tr td width='5%' nowrapinput type=radio name=paymentMethodTypeId value=EXT_OFFLINE #if paymentMethodTypeId?exists paymentMethodTypeId == EXT_OFFLINEchecked/#if//td Heidi Dehaes sent the following on 3/7/2009 1:30 PM: Ok i tried to send you copyscreens but they are too big. but: I set the payment method to DEXIA which is not in the list you showed me. I have to write myself a kind of dexia_event.java file to do the work. But before i do that i don't see the option when i try to buy something at my own website. regards, Heidi 2009/3/7 Heidi Dehaes info.ola...@gmail.com Hello, Yes i am working with ofbiz release 4. My PayPal works fine after i did a modification in the java file 6 months ago. But if i copy the same for a new payment method xyz, i don't see the option when i try to buy a product. regards, Heidi 2009/3/7 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am assuming you are still with ver 4.0. always good to remind since most will respond using the trunk. first the paypal example is not complete and needs work. so if you copied it you may find you payment does not work. so what did you set this to: https://demo40.hotwaxmedia.com/catalog/control/EditProductStorePaySetup?productStoreId=9000 for CC payments Heidi Dehaes sent the following on 3/7/2009 8:59 AM: Hello, I added an extra payment method , a little bit the same way as PayPal but let's say xyz. Payment Method: xyz Service Type: External Payment (no service) Payment Props: payment.properties Apply to All: Y I inserted in the file payment.properties (C:\ ... \applications\accounting\config\payment.properties the same properties as for PayPal but i changed the name of Paypal anywhere in xyz. I will write later on a similar java file like PayPalEvents.java but then for xyz (C:\ ... \applications\accounting\src\org\ofbiz\accounting\thirdparty\paypal). But when i try to pay a command in the ecommerce website, i get showed as payment possiblities only PayPal and never xyz also. Can anyone tell me what i forgot to modify in order that xyz is also shown as payment possibilities? thanks, Heidi -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJsrcArP3NbaWWqE4RAraXAJ95pslpf7JVxxFo7tV4qLr5+EmhLACfcP97 sNdkahBZIftaqnmKtW8y7y0= =jX9X -END PGP SIGNATURE- -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJs7TTrP3NbaWWqE4RAgLmAKDBo84yZGfkuLxgapvUMJqzKjjQTACbBpme /dKMg7CTadMKuwECdIAEcr0= =gzyt -END PGP SIGNATURE-
adding an extra payment method
Hello, I added an extra payment method , a little bit the same way as PayPal but let's say xyz. Payment Method: xyz Service Type: External Payment (no service) Payment Props: payment.properties Apply to All: Y I inserted in the file payment.properties (C:\ ... \applications\accounting\config\payment.properties the same properties as for PayPal but i changed the name of Paypal anywhere in xyz. I will write later on a similar java file like PayPalEvents.java but then for xyz (C:\ ... \applications\accounting\src\org\ofbiz\accounting\thirdparty\paypal). But when i try to pay a command in the ecommerce website, i get showed as payment possiblities only PayPal and never xyz also. Can anyone tell me what i forgot to modify in order that xyz is also shown as payment possibilities? thanks, Heidi
Re: adding an extra payment method
Hello, Yes i am working with ofbiz release 4. My PayPal works fine after i did a modification in the java file 6 months ago. But if i copy the same for a new payment method xyz, i don't see the option when i try to buy a product. regards, Heidi 2009/3/7 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am assuming you are still with ver 4.0. always good to remind since most will respond using the trunk. first the paypal example is not complete and needs work. so if you copied it you may find you payment does not work. so what did you set this to: https://demo40.hotwaxmedia.com/catalog/control/EditProductStorePaySetup?productStoreId=9000 for CC payments Heidi Dehaes sent the following on 3/7/2009 8:59 AM: Hello, I added an extra payment method , a little bit the same way as PayPal but let's say xyz. Payment Method: xyz Service Type: External Payment (no service) Payment Props: payment.properties Apply to All: Y I inserted in the file payment.properties (C:\ ... \applications\accounting\config\payment.properties the same properties as for PayPal but i changed the name of Paypal anywhere in xyz. I will write later on a similar java file like PayPalEvents.java but then for xyz (C:\ ... \applications\accounting\src\org\ofbiz\accounting\thirdparty\paypal). But when i try to pay a command in the ecommerce website, i get showed as payment possiblities only PayPal and never xyz also. Can anyone tell me what i forgot to modify in order that xyz is also shown as payment possibilities? thanks, Heidi -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJsrcArP3NbaWWqE4RAraXAJ95pslpf7JVxxFo7tV4qLr5+EmhLACfcP97 sNdkahBZIftaqnmKtW8y7y0= =jX9X -END PGP SIGNATURE-
Fwd: adding an extra payment method
Ok i tried to send you copyscreens but they are too big. but: I set the payment method to DEXIA which is not in the list you showed me. I have to write myself a kind of dexia_event.java file to do the work. But before i do that i don't see the option when i try to buy something at my own website. regards, Heidi 2009/3/7 Heidi Dehaes info.ola...@gmail.com Hello, Yes i am working with ofbiz release 4. My PayPal works fine after i did a modification in the java file 6 months ago. But if i copy the same for a new payment method xyz, i don't see the option when i try to buy a product. regards, Heidi 2009/3/7 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am assuming you are still with ver 4.0. always good to remind since most will respond using the trunk. first the paypal example is not complete and needs work. so if you copied it you may find you payment does not work. so what did you set this to: https://demo40.hotwaxmedia.com/catalog/control/EditProductStorePaySetup?productStoreId=9000 for CC payments Heidi Dehaes sent the following on 3/7/2009 8:59 AM: Hello, I added an extra payment method , a little bit the same way as PayPal but let's say xyz. Payment Method: xyz Service Type: External Payment (no service) Payment Props: payment.properties Apply to All: Y I inserted in the file payment.properties (C:\ ... \applications\accounting\config\payment.properties the same properties as for PayPal but i changed the name of Paypal anywhere in xyz. I will write later on a similar java file like PayPalEvents.java but then for xyz (C:\ ... \applications\accounting\src\org\ofbiz\accounting\thirdparty\paypal). But when i try to pay a command in the ecommerce website, i get showed as payment possiblities only PayPal and never xyz also. Can anyone tell me what i forgot to modify in order that xyz is also shown as payment possibilities? thanks, Heidi -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJsrcArP3NbaWWqE4RAraXAJ95pslpf7JVxxFo7tV4qLr5+EmhLACfcP97 sNdkahBZIftaqnmKtW8y7y0= =jX9X -END PGP SIGNATURE-
Re: Multiple language Support
Yes, The method with the alternates is the one you should use. Heidi 2009/2/25 Jacques Le Roux jacques.le.r...@les7arts.com From: Jacques Le Roux jacques.le.r...@les7arts.com Using UI : http://docs.ofbiz.org/x/_AM (any help improving this document would be appreciated...) OK, I have updated the document there. It was done in a hurry, please check if nothing is missing and all is true... Thks Jaques Jacques From: Vinu Varghese v...@x-minds.org Hi all, I need to store the product description in multiple languages. Is there any way in ofbiz to accomplish this? Please guide me regards Vinu -- signature full-name Vinu Varghese /full-name company-email v...@x-minds.org /company-email company-website www.x-minds.org /company-website big-words Success always occurs in private, and failure in full view. /big-words company-name-big \/ ._ _ o .__| _ /\ ~~ | | | | | | (_| _\ /company-name-big /signature
Re: %PDF-
Hello, Has anyone had this problem already once ? regards, heidi 2009/2/18 Heidi Dehaes info.ola...@gmail.com Here is the log. It is quite long ! regards, Heidi 2009-02-18 23:49:00,827 (http-0.0.0.0-8443-Processor4) [ ModelScreen.java:137:ERROR] Error rendering screen [component://common/widget/CommonScreens.xml#FoReportDecorator]: java.lang.RuntimeException: Error rendering included template at location [component://common/webcommon/includes/reportTemplate.fo.ftl]: freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException threw an exception when invoked on org.ofbiz.widget.screen.modelscreenwidget$sectionsrende...@f1f2cc.rolling back transaction. 2009-02-18 23:49:00,839 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:295:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2009-02-18 23:49:00,841 (http-0.0.0.0-8443-Processor4) [ ModelScreen.java:148:ERROR] Error rendering screen [component://order/widget/ordermgr/OrderPrintForms.xml#OrderPDF]: org.ofbiz.base.util.GeneralException: Error rendering screen [component://common/widget/CommonScreens.xml#FoReportDecorator]: java.lang.RuntimeException: Error rendering included template at location [component://common/webcommon/includes/reportTemplate.fo.ftl]: freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException threw an exception when invoked on org.ofbiz.widget.screen.modelscreenwidget$sectionsrende...@f1f2cc(Error rendering included template at location [component://common/webcommon/includes/reportTemplate.fo.ftl]: freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException threw an exception when invoked on org.ofbiz.widget.screen.modelscreenwidget$sectionsrende...@f1f2cc). Rolling back transaction. 2009-02-18 23:49:00,847 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:255:ERROR] exception report -- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace stack trace --- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:151) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:105) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:90) org.ofbiz.widget.screen.ScreenFopViewHandler.render(ScreenFopViewHandler.java:67) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:643) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:427) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619
%PDF-
Hello, Does anyone has an idea what the reason is of the following error when i ask the creation of a PDF in Ofbiz orders. It gives me anywhere the error in the opened window: File doesn't start with %PDF- regards, Heidi www.olagos.eu
Re: %PDF-
Hello, What do you mean in fact? If i open your link, i come into the catalog manager. Is this what you meant that i have to do? i don't understand it. regards, Heidi 2009/2/18 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please see if this happens on the https://demo40.hotwaxmedia.com/catalog/control/login/main?USERNAME=demoadminPASSWORD=ofbiz please give steps to re-created this. Heidi Dehaes sent the following on 2/18/2009 12:09 PM: Hello, Does anyone has an idea what the reason is of the following error when i ask the creation of a PDF in Ofbiz orders. It gives me anywhere the error in the opened window: File doesn't start with %PDF- regards, Heidi www.olagos.eu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJnG+6rP3NbaWWqE4RAjJhAJ0XZmO8QqGJ+z1CXyJjjR1CJKEuGwCfWZq4 Zi0qugSJETRNEX/ereU6qVo= =/WjH -END PGP SIGNATURE-
Re: %PDF-
thanks, I will do that but first of all: I have this problem already for a while. And it is possible that i used the ireport editor to have a look at some definition files. Could it be that i used the wrong version of ireport editor and that that gives the problems? regards, Heidi 2009/2/18 Scott Gray scott.g...@hotwaxmedia.com Hi Heidi If you haven't customized the pdf template at all then I would suggest sending us the error message (and surrounding log messages) from the ofbiz.log file. If you have customized it or any surrounding code, send the log anyway but let us know what changes you've made. Regards Scott HotWax Media http://www.hotwaxmedia.com 801.657.2909 - Original Message - From: Heidi Dehaes info.ola...@gmail.com To: user@ofbiz.apache.org Sent: Wednesday, February 18, 2009 1:45:38 PM GMT -07:00 US/Canada Mountain Subject: Re: %PDF- Hello, What do you mean in fact? If i open your link, i come into the catalog manager. Is this what you meant that i have to do? i don't understand it. regards, Heidi 2009/2/18 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please see if this happens on the https://demo40.hotwaxmedia.com/catalog/control/login/main?USERNAME=demoadminPASSWORD=ofbiz please give steps to re-created this. Heidi Dehaes sent the following on 2/18/2009 12:09 PM: Hello, Does anyone has an idea what the reason is of the following error when i ask the creation of a PDF in Ofbiz orders. It gives me anywhere the error in the opened window: File doesn't start with %PDF- regards, Heidi www.olagos.eu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJnG+6rP3NbaWWqE4RAjJhAJ0XZmO8QqGJ+z1CXyJjjR1CJKEuGwCfWZq4 Zi0qugSJETRNEX/ereU6qVo= =/WjH -END PGP SIGNATURE-
Re: %PDF-
) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) java.lang.RuntimeException: Error rendering included template at location [component://common/webcommon/includes/reportTemplate.fo.ftl]: freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException threw an exception when invoked on org.ofbiz.widget.screen.modelscreenwidget$sectionsrende...@f1f2ccorg.ofbiz.widget.screen.htmlwidget.renderhtmltemplate(HtmlWidget.java:90) org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:110) org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:65) org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:806) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:244) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:134) org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:489) org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:244) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:134) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:105) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:90) org.ofbiz.widget.screen.ScreenFopViewHandler.render(ScreenFopViewHandler.java:67) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:643) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:427) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189) javax.servlet.http.HttpServlet.service(HttpServlet.java:595) javax.servlet.http.HttpServlet.service(HttpServlet.java:688) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:619) 2009/2/18 Heidi Dehaes info.ola...@gmail.com thanks, I will do that but first of all: I have this problem already for a while. And it is possible that i used the ireport editor to have a look at some definition files. Could it be that i used the wrong version of ireport editor and that that gives the problems? regards, Heidi 2009/2/18 Scott Gray scott.g...@hotwaxmedia.com Hi Heidi If you haven't customized the pdf template at all then I would suggest sending us the error message (and surrounding log messages) from the ofbiz.log file. If you have customized it or any surrounding code, send the log anyway but let us know what changes you've made. Regards Scott HotWax Media http://www.hotwaxmedia.com 801.657.2909 - Original Message - From: Heidi Dehaes info.ola...@gmail.com To: user@ofbiz.apache.org Sent: Wednesday, February 18, 2009 1:45:38 PM GMT -07:00 US/Canada Mountain Subject: Re: %PDF- Hello, What do you mean in fact? If i open your link, i come into the catalog manager. Is this what you meant that i have to do? i don't understand it. regards, Heidi 2009/2/18 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please see if this happens on the https://demo40.hotwaxmedia.com/catalog/control/login/main?USERNAME=demoadminPASSWORD=ofbiz
product attributes entity --- upload xml or txt from remote website
Hello, With ofbiz release 4 is there a possibility to upload automatically a txt of xml file on an external website anywhere with data for the product attributes entity? For example upload every night a txt or xml file which can be found on an external http website and load it into the product attributes entity? thanks, Heidi http://www.olagos.eu
affiliate marketing
Hello, Can i store in the catalog of ofbiz 4.0 the definition and images of products which are published in the ecommerce site. And when a buyer clicks on the product he will be guided to another site immediately on the same product where he can really buy the product. I store the products of another e-shop in the catalog of ofbiz with a url link to that e-shop. Is that possible in ofbiz??? thanks for some advice. regards, Heidi www.olagos.eu
Re: affiliate marketing
But can i configure it in the standard catalog manager for example? Heidi 2009/2/6 Sven Wesley svenne.d...@gmail.com Short answer: yes of course. But to me it sounds like you want to add another layer of ecommerce on top of the ecommerce... Yes, you can link one product to another site, it's just a matter of editing the GUI and syncronize product ID's. You can also use the ecommerce component to do everything for you, or have the other e-shop to get the products directly from the Ofbiz-catalog. Regards, Sven 2009/2/6 Heidi Dehaes info.ola...@gmail.com Hello, Can i store in the catalog of ofbiz 4.0 the definition and images of products which are published in the ecommerce site. And when a buyer clicks on the product he will be guided to another site immediately on the same product where he can really buy the product. I store the products of another e-shop in the catalog of ofbiz with a url link to that e-shop. Is that possible in ofbiz??? thanks for some advice. regards, Heidi www.olagos.eu
Re: Change Language in Ofbiz
Hello, I thought hosting more shops under the same ofbiz instance in ofbiz 4.0 was already implemented, isn't it? Heidi www.olagos.eu 2009/1/30 Florin Popa flopacons...@gmail.com Hi, Thanks for both replies. We will try it and if possible to improve something, of course we can share it. We are a team working on customization of e-commerce since almost a year. Soon I can share a demo as well as some additional development like advanced Ebay integration or ajax based shopping cart refresh.. Another interesting topic we had to implement ourselves (hosting more shops under the same ofbiz instance as well as admin users controlling at the same time more shops) Best regards, Flopa For a pattern of how to do this check out the add to cart request (and more importantly how it is used in productdetail and other templates) which does support staying on the same page, even though the request is always the same it goes to different views when it is done. -David On Jan 29, 2009, at 11:39 AM, BJ Freeman wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I ask this when it was first implemented. it was designed to reset. it would take a lot of rethink to not do this, from what I saw of the code. However if you find a way besure to submit a patch, through a jira. http://docs.ofbiz.org/display/OFBADMIN/Best+Practices+Guide http://docs.ofbiz.org/display/OFBADMIN/Coding+Conventions http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices http://issues.apache.org/jira/browse/OFBIZ Florin Popa sent the following on 1/29/2009 10:28 AM: Hello, Please help me with the following issue described below. Problem : How to implement functionality to be able to stay on the same page after the user change language (http, https) Details: In order to be able to change the language and return to the same page the last user action before change language should be saved entirely to redirect the user back to it. What I tried was to keep the last url accessed before change language along with the parameters used (for reproducing entirely the last state before change language was accessed), and after change the language to redirect the user to this url. The problem appeared when for example you add an item to cart from a product page and the user is kept on the same page after the item is added. The last accessed url in this case was add to cart and after the user changes his language the response was redirected to the add to cart url. Another problem was that when you log into the application you enter in an https area and the url is created with https but the parameters from the last request are present in the url after redirect which is not desired. Thanks, Flopa -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJgffurP3NbaWWqE4RAnpLAJ46pUFtwsGd2SwR216SY350ZDEqRwCeKvTh pU2ON2HR9IQWOdE0oKYiPtU= =S0Ha -END PGP SIGNATURE-
tracking codes
Hello, Has anyone experience with the use of tracking codes by affiliate websites in ofbiz 4.0 ? Do i need to put the TrackingCodeEvents.java file (from within the marketing component) in the EVENT tag in the ecommerce controller on every line in order to work? Or is it implemented anywhere that it however works without modifiying something? Regards, Heidi http://www.olagos.eu
debug info
Hello, How can i switch on the debug log info? For example in the java code files you have sometimes code like: Debug.logInfo(Selected Payment Methods : + selectedPaymentMethods, module); What to do that i can see this debug information in the log files? regards, Heidi Dehaes www.olagos.eu
Re: showing digital products after being bought
Thank you very much. The tool is very interesting. And the creation of the screens you describe will be very usefull. I only thought that these screens were used in the ecommerce application showing the digital product to download when the digital product is bought and payed. But that is not the case i think. I will test the digital product functionality in version 4.0 and i hope it works so i can implement it. thanks, Heidi Dehaes www.olagos.eu 2009/1/24 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 another approach is to do a list of order Items that are digital item, then iterate through them and find the parties that ordered them this would give a display of the item and all the customers that ordered it. BJ Freeman sent the following on 1/24/2009 3:42 AM: https://demo.hotwaxmedia.com/webtools/control/ArtifactInfo is a great tool to find what and where something is used. Search Names/Locations: and enter Customerscreens if you click on digitalproductlist you will see that there is an entry in the controller but no calls to the this URI My response is for the current SVN Trunk. I would create a Party/orders/products entity view . then do a find for those in the view that have digital products. create a widget to display this info the way you want. Heidi Dehaes sent the following on 1/24/2009 3:23 AM: Hello, When i want to show the digital products someone has bought, onto my screen, what do i have to do? I see digitalproductlist.ftl and digitalproductedit.ftl are part of /applications/ecommerce/widget/Customerscreens.xml and are not part of the standard /applications/ecommerce/widget/Commonscreens.xml which is called in main.ftl after index.jsp is called. Is it only foreseen that an e-shop for digital products is a separate shop than the one for normal products, or can we mix them? How and where to call then Customerscreens.xml? regards, Heidi -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJe181rP3NbaWWqE4RAoqMAKDTk6utezgKadnXpsVb+MXQHN1XNwCgsNob 9HCfg7PetoMWv+YUuRPcyDc= =k6J/ -END PGP SIGNATURE-
Re: showing digital products after being bought
Yes ok i saw it very shortly. But in reality it doesn't function well in my production site of ofbiz4.0. Have there been any updates for it? regards, Heidi 2009/1/26 David E Jones david.jo...@hotwaxmedia.com The screen actually does exist. Look at the bottom of the order history screen. The screen def and template files should be the most helpful there. You should be able to see it functioning by ordering the Digital Gizmo and then go to that page to download the digital file associated with it. The download event is even in place that checks order history and then streams the binary file down. -David On Jan 26, 2009, at 5:40 AM, Heidi Dehaes wrote: Thank you very much. The tool is very interesting. And the creation of the screens you describe will be very usefull. I only thought that these screens were used in the ecommerce application showing the digital product to download when the digital product is bought and payed. But that is not the case i think. I will test the digital product functionality in version 4.0 and i hope it works so i can implement it. thanks, Heidi Dehaes www.olagos.eu 2009/1/24 BJ Freeman bjf...@free-man.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 another approach is to do a list of order Items that are digital item, then iterate through them and find the parties that ordered them this would give a display of the item and all the customers that ordered it. BJ Freeman sent the following on 1/24/2009 3:42 AM: https://demo.hotwaxmedia.com/webtools/control/ArtifactInfo is a great tool to find what and where something is used. Search Names/Locations: and enter Customerscreens if you click on digitalproductlist you will see that there is an entry in the controller but no calls to the this URI My response is for the current SVN Trunk. I would create a Party/orders/products entity view . then do a find for those in the view that have digital products. create a widget to display this info the way you want. Heidi Dehaes sent the following on 1/24/2009 3:23 AM: Hello, When i want to show the digital products someone has bought, onto my screen, what do i have to do? I see digitalproductlist.ftl and digitalproductedit.ftl are part of /applications/ecommerce/widget/Customerscreens.xml and are not part of the standard /applications/ecommerce/widget/Commonscreens.xml which is called in main.ftl after index.jsp is called. Is it only foreseen that an e-shop for digital products is a separate shop than the one for normal products, or can we mix them? How and where to call then Customerscreens.xml? regards, Heidi -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJe181rP3NbaWWqE4RAoqMAKDTk6utezgKadnXpsVb+MXQHN1XNwCgsNob 9HCfg7PetoMWv+YUuRPcyDc= =k6J/ -END PGP SIGNATURE-
showing digital products after being bought
Hello, When i want to show the digital products someone has bought, onto my screen, what do i have to do? I see digitalproductlist.ftl and digitalproductedit.ftl are part of /applications/ecommerce/widget/Customerscreens.xml and are not part of the standard /applications/ecommerce/widget/Commonscreens.xml which is called in main.ftl after index.jsp is called. Is it only foreseen that an e-shop for digital products is a separate shop than the one for normal products, or can we mix them? How and where to call then Customerscreens.xml? regards, Heidi
digital products
Hello, When i want to show the digital products someone has bought, onto my screen, what do i have to do? I see digitalproductlist.ftl and digitalproductedit.ftl are part of /applications/ecommerce/widget/Customerscreens.xml and are not part of the standard /applications/ecommerce/widget/Commonscreens.xml which is called in main.ftl after index.jsp is called. Is it only foreseen that an e-shop for digital products is a separate shop than the one for normal products, or can we mix them? How and where to call then Customerscreens.xml? regards, Heidi
Re: digital products
Thanks for the information. But where do i find the description of the datasource and the dataresource of the digital good Gizmo? Regards, Heidi http://www.olagos.eu 2009/1/19 Vivek Mishra vivek.mis...@hotwaxmedia.com Hello Heidi, I think DemoProduct.xml of e-commerce can help you for doing this. Just go through the data which is setup for Digital Gizmo Product. HTH Regards, -- Vivek Heidi Dehaes wrote: Hello, Can anyone tell me how to setup a digital product, for example a e-book which users can download after purchasing it. I know i have to choose digital product in the product definitions. But then at the content tab in the product definition. What do i have to set up as content for the product? Do i need to set up also a service ? a async or a sync service? How will the product, after purchase, be shown? Will the download be available as a link or will the download file be sent by e-mail automatically? thanks in advance, Heidi Dehaes www.olagos.eu
Re: digital products
Do I have to define a service in the datasource description? Heidi 2009/1/19 Heidi Dehaes info.ola...@gmail.com Thanks for the information. But where do i find the description of the datasource and the dataresource of the digital good Gizmo? Regards, Heidi http://www.olagos.eu 2009/1/19 Vivek Mishra vivek.mis...@hotwaxmedia.com Hello Heidi, I think DemoProduct.xml of e-commerce can help you for doing this. Just go through the data which is setup for Digital Gizmo Product. HTH Regards, -- Vivek Heidi Dehaes wrote: Hello, Can anyone tell me how to setup a digital product, for example a e-book which users can download after purchasing it. I know i have to choose digital product in the product definitions. But then at the content tab in the product definition. What do i have to set up as content for the product? Do i need to set up also a service ? a async or a sync service? How will the product, after purchase, be shown? Will the download be available as a link or will the download file be sent by e-mail automatically? thanks in advance, Heidi Dehaes www.olagos.eu
digital products
Hello, Can anyone tell me how to setup a digital product, for example a e-book which users can download after purchasing it. I know i have to choose digital product in the product definitions. But then at the content tab in the product definition. What do i have to set up as content for the product? Do i need to set up also a service ? a async or a sync service? How will the product, after purchase, be shown? Will the download be available as a link or will the download file be sent by e-mail automatically? thanks in advance, Heidi Dehaes www.olagos.eu
Re: product associations in catalog manager
I will have a look into demoproduct.xml. thanks. Heidi 2009/1/8 Vivek Mishra vivek.mis...@hotwaxmedia.com Hi Heidi, You can refer DemoProduct.xml file of e-commerce for knowing more about this. We use ProdcutAssoc entity for association of one product to another and give association type to specify what kind of association is this. For example when we associate variants to its virtual product we give product association type = Product variant. Just refer the file which I have specified and you get to know the use of other association type. Kind Regards, -- Vivek Mishra Heidi Dehaes wrote: Hello, In the catalog manager if you choose a product , you have a tab available in the product management page for associations. There are different association types available. The only one i think which works in version 4.0 is the following one: - complementary or cross-sell This one is therefore visible on the e-commerce screen when accessing the meaned product. The other types are: - Accessory - Actual product component - Also bought - Contient - Engineering Bill of Materials - Equivalent or substitute - Est emballé dans - Incompatable - Manufacturing Bill of Materials - New version, replacement - Product manufactured as - Product variant - Revision - Unique Item - Upgrade or Up-Sell I don't see any difference in the e-commerce screen when i try to use them. Can anyone give me more information on how to use them or how to implement them if they are not yet implemented in version 4.0 ? Which ftl 's i have to look into and which .java files i have to look into in order to further develop this functionality? thanks, Heidi Dehaes www.olagos.eu
accountancy in ofbiz
Hello, I want to know which accountancy system is used in ofbiz release 4.0 ? Is the normal European system which i think they call it in English double accountancy system used in ofbiz? Or is there something special American system used in it? regards, Heidi Dehaes Olagos
Re: accountancy in ofbiz
Is it complete in the latest release? Heidi 2008/12/4 Jacques Le Roux [EMAIL PROTECTED] The accounting system was not complete in R4 Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, I want to know which accountancy system is used in ofbiz release 4.0 ? Is the normal European system which i think they call it in English double accountancy system used in ofbiz? Or is there something special American system used in it? regards, Heidi Dehaes Olagos
Re: how to configure smtp and pop for gmail account
Which version of ofbiz do you use? Heidi 2008/8/12, Ravi Thakur [EMAIL PROTECTED]: Hi to all, can any one help me to know where and how i configure ofbiz to get and send mail through my gmail account in CRMSFA module... -- Ravindra Thakur
external key
Hello, Why does Ofbiz utiilize an external key besides the login information? regards, Heidi
Re: external key
yes, version 4.0 2008/7/28, BJ Freeman [EMAIL PROTECTED]: and this is ver 4.0 I believe? Heidi Dehaes sent the following on 7/28/2008 3:49 AM: Hello, Why does Ofbiz utiilize an external key besides the login information? regards, Heidi
Re: external key
ok so we have already a hint what it does. Thank you very much, Heidi 2008/7/28, BJ Freeman [EMAIL PROTECTED]: found this Add external login key for Authorize and Capture buttons for credit cards and made them buttontext (r 439116) Heidi Dehaes sent the following on 7/28/2008 5:13 AM: yes, version 4.0 2008/7/28, BJ Freeman [EMAIL PROTECTED]: and this is ver 4.0 I believe? Heidi Dehaes sent the following on 7/28/2008 3:49 AM: Hello, Why does Ofbiz utiilize an external key besides the login information? regards, Heidi
Re: distributed application
thanks for all the information Heidi 2008/7/25 David E Jones [EMAIL PROTECTED]: ... or just use the Entity Sync stuff that is conveniently included in OFBiz... -David On Jul 25, 2008, at 4:04 AM, Jaskooner Singh wrote: There are many products available that do database synconisation and replication. Some are platform specific and some are platform neutral. Check here for some info on postgres Website or the Daffodil Replicator. Jaskooner Sent from my iPhone On 24 Jul 2008, at 20:16, Heidi Dehaes [EMAIL PROTECTED] wrote: yes, ok i know load balancing. But that is for the web server. But is there no online synchronisation between the two databases? Heidi 2008/7/24 Jacques Le Roux [EMAIL PROTECTED]: This is done using a technique called Load Balancing. Tomcat (embedded in OFBiz) provides some help, you might find information on the Net... Jacques From: Heidi Dehaes [EMAIL PROTECTED] and do you know how to do that? Heidi 2008/7/20 Adrian Crum [EMAIL PROTECTED]: --- On Sun, 7/20/08, Heidi Dehaes [EMAIL PROTECTED] wrote: From: Heidi Dehaes [EMAIL PROTECTED] Subject: distributed application To: user@ofbiz.apache.org Date: Sunday, July 20, 2008, 3:55 AM Hello, I have read it is possible to run ofbiz at different locations on different computers simultaneously whereby the database is being synchronized every x seconds. And is it so you can then have 1 concurrent users by using poor internet connections at each pc? Distributing OFBiz over a number of servers is usually done because the site has a high volume of traffic. -Adrian
Re: distributed application
yes, ok i know load balancing. But that is for the web server. But is there no online synchronisation between the two databases? Heidi 2008/7/24 Jacques Le Roux [EMAIL PROTECTED]: This is done using a technique called Load Balancing. Tomcat (embedded in OFBiz) provides some help, you might find information on the Net... Jacques From: Heidi Dehaes [EMAIL PROTECTED] and do you know how to do that? Heidi 2008/7/20 Adrian Crum [EMAIL PROTECTED]: --- On Sun, 7/20/08, Heidi Dehaes [EMAIL PROTECTED] wrote: From: Heidi Dehaes [EMAIL PROTECTED] Subject: distributed application To: user@ofbiz.apache.org Date: Sunday, July 20, 2008, 3:55 AM Hello, I have read it is possible to run ofbiz at different locations on different computers simultaneously whereby the database is being synchronized every x seconds. And is it so you can then have 1 concurrent users by using poor internet connections at each pc? Distributing OFBiz over a number of servers is usually done because the site has a high volume of traffic. -Adrian
Re: distributed application
is this about distributing servers ? Heidi 2008/7/21 awdesh parihar [EMAIL PROTECTED]: Hello Heidi , please take a look of link document , i think you will find answer of your question http://svnbook.red-bean.com/en/1.4/svn-book.html -Awdesh Parihar
distributed application
Hello, I have read it is possible to run ofbiz at different locations on different computers simultaneously whereby the database is being synchronized every x seconds. Can anyone explain me how this architecture is organised and how it functions? How to install this? And is it so you can then have 1 concurrent users by using poor internet connections at each pc? thanks, Heidi
Re: no emails sent
My email functions now. I had to do a ant clean before doing a ant in order to compile my java files. I had to change the emailservices.java file a little bit in order to connect via SSL to gmail provider. regards, Heidi 2008/7/18 Heidi Dehaes [EMAIL PROTECTED]: That is very good information. I used until now a mailserver , open source, but which had a lot of errors in the protocols and also in fact not useful. thanks, Heidi 2008/7/18, BJ Freeman [EMAIL PROTECTED]: as a side note: look at using the Apache James mail server. been using it for a few years now. Heidi Dehaes sent the following on 7/17/2008 2:56 PM: Thanks for all information. It is already better with defining the email in the store. but is there a JavaMail specialist. I got still this error. And i modified the emailservices.java file to use the gmail mailprovider. I used the trunk version to modify the release 4 version a little bit with new parameters for SSL. 2008-07-17 23:49:19,898 (default-invoker-Thread-5) [ EmailServices.java:240:ERROR] exception report -- Cannot send email message to [EMAIL PROTECTED] from [EMAIL PROTECTED] cc [null] bcc [null] subject [EMAIL PROTECTED] Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) 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:597) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.content.email.EmailServices.sendMailFromScreen regards, Heidi 2008/7/17 Jacques Le Roux [EMAIL PROTECTED]: At least you should add a Tell-A-Friend email type in https://localhost:8443/catalog/control/EditProductStoreEmails?productStoreId=9000 From the top of my head, not sure it's enough though. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, When i try to send a email from the tell-a-friend popup screen, i get this message and no email is sended: 2008-07-16 23:19:28,808 (default-invoker-Thread-228) [ ServiceDispatcher.java:396:ERROR] exception report -- Service [sendMailFromScreen] threw an unexpected exception/error Exception: org.ofbiz.service.GenericServiceException Message: Service target threw an unexpected exception (Error in screen location/name: no # found to separate the location from the name; correct example: component://product/screen/product/ProductScreens.xml#EditProduct) can someone help me to search for a solution? Is it a common known error in the ofbizrelease 4 version? thanks, Heidi
Re: distributed application
and do you know how to do that? Heidi 2008/7/20 Adrian Crum [EMAIL PROTECTED]: --- On Sun, 7/20/08, Heidi Dehaes [EMAIL PROTECTED] wrote: From: Heidi Dehaes [EMAIL PROTECTED] Subject: distributed application To: user@ofbiz.apache.org Date: Sunday, July 20, 2008, 3:55 AM Hello, I have read it is possible to run ofbiz at different locations on different computers simultaneously whereby the database is being synchronized every x seconds. And is it so you can then have 1 concurrent users by using poor internet connections at each pc? Distributing OFBiz over a number of servers is usually done because the site has a high volume of traffic. -Adrian
shipments in facility in release 4
Hello, Is there a patch available for shipments pages in facitlity . It gives me error screens when i want to manage shipments. Known? Regards, Heidi
Re: no emails sent
What are these three commits? I modified only the emailservices.java file. Perhaps i have also to modify the smtp..java file. thanks for the info, Heidi 2008/7/18, Adrian Crum [EMAIL PROTECTED]: Heidi, The commit log shows three commits were required to implement gmail. Did you get all of those changes ported over to Release 4? -Adrian Heidi Dehaes wrote: Thanks for all information. It is already better with defining the email in the store. but is there a JavaMail specialist. I got still this error. And i modified the emailservices.java file to use the gmail mailprovider. I used the trunk version to modify the release 4 version a little bit with new parameters for SSL. 2008-07-17 23:49:19,898 (default-invoker-Thread-5) [ EmailServices.java:240:ERROR] exception report -- Cannot send email message to [EMAIL PROTECTED] from [EMAIL PROTECTED] cc [null] bcc [null] subject [EMAIL PROTECTED] Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) 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:597) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.content.email.EmailServices.sendMailFromScreen regards, Heidi 2008/7/17 Jacques Le Roux [EMAIL PROTECTED]: At least you should add a Tell-A-Friend email type in https://localhost:8443/catalog/control/EditProductStoreEmails?productStoreId=9000 From the top of my head, not sure it's enough though. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, When i try to send a email from the tell-a-friend popup screen, i get this message and no email is sended: 2008-07-16 23:19:28,808 (default-invoker-Thread-228) [ ServiceDispatcher.java:396:ERROR] exception report -- Service [sendMailFromScreen] threw an unexpected exception/error Exception: org.ofbiz.service.GenericServiceException Message: Service target threw an unexpected exception (Error in screen location/name: no # found to separate the location from the name; correct example: component://product/screen/product/ProductScreens.xml#EditProduct) can someone help me to search for a solution? Is it a common known error in the ofbizrelease 4 version? thanks, Heidi
Re: no emails sent
That is very good information. I used until now a mailserver , open source, but which had a lot of errors in the protocols and also in fact not useful. thanks, Heidi 2008/7/18, BJ Freeman [EMAIL PROTECTED]: as a side note: look at using the Apache James mail server. been using it for a few years now. Heidi Dehaes sent the following on 7/17/2008 2:56 PM: Thanks for all information. It is already better with defining the email in the store. but is there a JavaMail specialist. I got still this error. And i modified the emailservices.java file to use the gmail mailprovider. I used the trunk version to modify the release 4 version a little bit with new parameters for SSL. 2008-07-17 23:49:19,898 (default-invoker-Thread-5) [ EmailServices.java:240:ERROR] exception report -- Cannot send email message to [EMAIL PROTECTED] from [EMAIL PROTECTED] cc [null] bcc [null] subject [EMAIL PROTECTED] Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) 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:597) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.content.email.EmailServices.sendMailFromScreen regards, Heidi 2008/7/17 Jacques Le Roux [EMAIL PROTECTED]: At least you should add a Tell-A-Friend email type in https://localhost:8443/catalog/control/EditProductStoreEmails?productStoreId=9000 From the top of my head, not sure it's enough though. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, When i try to send a email from the tell-a-friend popup screen, i get this message and no email is sended: 2008-07-16 23:19:28,808 (default-invoker-Thread-228) [ ServiceDispatcher.java:396:ERROR] exception report -- Service [sendMailFromScreen] threw an unexpected exception/error Exception: org.ofbiz.service.GenericServiceException Message: Service target threw an unexpected exception (Error in screen location/name: no # found to separate the location from the name; correct example: component://product/screen/product/ProductScreens.xml#EditProduct) can someone help me to search for a solution? Is it a common known error in the ofbizrelease 4 version? thanks, Heidi
Re: no emails sent
Thanks for all information. It is already better with defining the email in the store. but is there a JavaMail specialist. I got still this error. And i modified the emailservices.java file to use the gmail mailprovider. I used the trunk version to modify the release 4 version a little bit with new parameters for SSL. 2008-07-17 23:49:19,898 (default-invoker-Thread-5) [ EmailServices.java:240:ERROR] exception report -- Cannot send email message to [EMAIL PROTECTED] from [EMAIL PROTECTED] cc [null] bcc [null] subject [EMAIL PROTECTED] Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. i30sm3772757ugd.43 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) 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:597) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:344) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) org.ofbiz.content.email.EmailServices.sendMailFromScreen regards, Heidi 2008/7/17 Jacques Le Roux [EMAIL PROTECTED]: At least you should add a Tell-A-Friend email type in https://localhost:8443/catalog/control/EditProductStoreEmails?productStoreId=9000 From the top of my head, not sure it's enough though. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, When i try to send a email from the tell-a-friend popup screen, i get this message and no email is sended: 2008-07-16 23:19:28,808 (default-invoker-Thread-228) [ ServiceDispatcher.java:396:ERROR] exception report -- Service [sendMailFromScreen] threw an unexpected exception/error Exception: org.ofbiz.service.GenericServiceException Message: Service target threw an unexpected exception (Error in screen location/name: no # found to separate the location from the name; correct example: component://product/screen/product/ProductScreens.xml#EditProduct) can someone help me to search for a solution? Is it a common known error in the ofbizrelease 4 version? thanks, Heidi
Re: email test
But what action have i to do that the template email is started to send away? Heidi 2008/7/5, Vikas Mayur [EMAIL PROTECTED]: First read Email Server Settings in http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guideto configure necessary settings. ProductStoreEmailSetting is the entity where the email template location is defined with couple of other fields. This template is send in the email. Make sure to use a valid email address in all email notifications send by the system. Rest of comments inline. On Fri, Jul 4, 2008 at 6:31 PM, Heidi Dehaes [EMAIL PROTECTED] wrote: Hello, How can i test that the ofbiz application sends email notifications? I never sends any email. Also not with Tell-a-friend functionality. I have also not used Tell-a-friend functionality but if your question is how to reach here, its pretty simple if you look into the code. This is on the product detail page for each product. http://demo.hotwaxmedia.com/ecommerce/control/product/~category_id=PROMOTIONS/~product_id=GZ-2644 Hope this helps ! Vikas regards, Heidi
i can't send email with javamail in ofbiz 4
Hello I can't send emails from the ofbiz application. i have always the following error: in short this one: Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. c24sm9404593ika.4 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. c24sm9404593ika.4 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) My general.properties is like this: ### # Licensed to the Apache Software Foundation (ASF) under one # or more contributor license agreements. See the NOTICE file # distributed with this work for additional information # regarding copyright ownership. The ASF licenses this file # to you under the Apache License, Version 2.0 (the # License); you may not use this file except in compliance # with the License. You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, # software distributed under the License is distributed on an # AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY # KIND, either express or implied. See the License for the # specific language governing permissions and limitations # under the License. ### # -- unique instance id (20 char max) unique.instanceId=ofbiz1 # -- the default currency to use for prices, etc currency.uom.id.default=EUR # -- the default decimal format for currency currency.decimal.format=##0.00 # -- locales made available separated by comma's locales.available=en,fr,nl,de # -- the default country for drop downs country.geo.id.default=EUR # -- the default trackingCodeId to use for Partner Managed Tracking Codes partner.trackingCodeId.default= # -- USPS address matching string - should be all lower case, no spaces, pipe delimited usps.address.match=(^.*?p[\\. ]*o[\\. ]*box.*$)|(^.*?post.*?office.*?box.*$)|((^|(^.*? ))r[\\. ]*r[\\. ]*(( +)|([0-9#]+)).*$)|(^.*?rural.*?route.*$) # -- mail notifications enabled (Y|N) mail.notifications.enabled=yes # -- redirect all mail notifications to this address for testing [EMAIL PROTECTED] # -- the default mail server to use mail.smtp.relay.host=smtp.gmail.com # -- SMTP Auth settings mail.smtp.auth.user=[EMAIL PROTECTED] mail.smtp.auth.password=** # -- debug SMTP mail option enabled (Y|N) mail.debug.on=true # -- Additional Required Fields needed for Gmail and other non #traditional smtp servers # -- These added fields also work for Yahoo business mail for instance # -- Gmail smtp port can be either 465 or 587 mail.smtp.port=465 # -- Gmail requires StartTLS mail.smtp.starttls.enable=true # -- Gmail requires a JSSE socket factory, the following socketFactory #settings will override JavaMail's default socketFactory settings # -- Port needs to be the same as mail.smtp.port mail.smtp.socketFactory.port=465 mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory #--Fallback [true|false] determines whether you will allow a non secure #connection if you are unable to get a secure one mail.smtp.socketFactory.fallback=false # -- debug SMTP mail option enabled (Y|N) mail.debug.on=true # -- HTTP upload max size in bytes (-1 for unlimited) http.upload.max.size=-1 # -- spam header name and value to block incoming spam detected by external spam checker, configured for spam assin mail.spam.name=X-Spam-Flag mail.spam.value=YES CAN ANYONE HELP ME ??? THANKS HEIDI in long form it is this one: 2008-07-09 00:11:24,742 (http-0.0.0.0-8443-Processor8) [ EmailServices.java:240:ERROR] exception report -- Cannot send email message to [EMAIL PROTECTED] from [EMAIL PROTECTED] cc [EMAIL PROTECTED] bcc [null] subject [Confirmation ! ] Exception: com.sun.mail.smtp.SMTPSendFailedException Message: 530 5.7.0 Must issue a STARTTLS command first. c24sm9404593ika.4 stack trace --- com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. c24sm9404593ika.4 com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388) com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959) com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583) org.ofbiz.content.email.EmailServices.sendMail(EmailServices.java:236) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
Re: mailer
thanks, heidi 2008/7/3, Jacques Le Roux [EMAIL PROTECTED]: No (as you can see yourself in general.properties file). It was added after release4.0 freeze and is not a bug fix https://issues.apache.org/jira/browse/OFBIZ-1256 Jacques From: Heidi Dehaes [EMAIL PROTECTED] Is the SSL functionality not available in the 4.0 version? Heidi 2008/7/3 Heidi Dehaes [EMAIL PROTECTED]: I don't see any information in the 4.0 version about gmail. Heidi 2008/7/3 BJ Freeman [EMAIL PROTECTED]: in the trunk version not sure it is in the 4.0 version Heidi Dehaes sent the following on 7/3/2008 12:33 PM: Hello, Can the mailer in ofbiz be configured to send mail via GMAIL. This is to connect to the mailserver smtp.gmail.com via SSL? thanks, Heidi www.olagos.eu
email test
Hello, How can i test that the ofbiz application sends email notifications? I never sends any email. Also not with Tell-a-friend functionality. regards, Heidi
mailer
Hello, Can the mailer in ofbiz be configured to send mail via GMAIL. This is to connect to the mailserver smtp.gmail.com via SSL? thanks, Heidi www.olagos.eu
mailer
Hello, Can the mailer in ofbiz be configured to send mail via GMAIL. This is to connect to the mailserver smtp.gmail.com via SSL? thanks, Heidi www.olagos.eu
Re: mailer
I don't see any information in the 4.0 version about gmail. Heidi 2008/7/3 BJ Freeman [EMAIL PROTECTED]: in the trunk version not sure it is in the 4.0 version Heidi Dehaes sent the following on 7/3/2008 12:33 PM: Hello, Can the mailer in ofbiz be configured to send mail via GMAIL. This is to connect to the mailserver smtp.gmail.com via SSL? thanks, Heidi www.olagos.eu
Re: mailer
Is the SSL functionality not available in the 4.0 version? Heidi 2008/7/3 Heidi Dehaes [EMAIL PROTECTED]: I don't see any information in the 4.0 version about gmail. Heidi 2008/7/3 BJ Freeman [EMAIL PROTECTED]: in the trunk version not sure it is in the 4.0 version Heidi Dehaes sent the following on 7/3/2008 12:33 PM: Hello, Can the mailer in ofbiz be configured to send mail via GMAIL. This is to connect to the mailserver smtp.gmail.com via SSL? thanks, Heidi www.olagos.eu
ofbiz is so slow
Hello, I use the ofbiz application and embedded tomcat server behind a Apache webserver. I am wondering that webpages on the Apache web server are very fast and webpages from the ofbizapplication are very slow. My database behind the application is MYSQL. I use 4 GB central memory with a Q6600 Quad Core Intel Processor on Windows Vista. Is it normal ? How to speed up the ofbiz application? I use already standard caching possibilities in the catalog screen. Regards, Heidi ofbiz: http://www.olagos.eu apache: http://www.olagos.eu/soldenzomer2008/index.html
Re: ofbiz is so slow
If you try my pages you will see i have only 1 page in 5 seconds, i guess. No i didn't tune the caching. It is rather difficult stuff for me. Heidi 2008/7/2, David E Jones [EMAIL PROTECTED]: I guess it depends on what you mean by slow. Compared to static pages serving up dynamic pages rendered on the fly will definitely be slower, but on a machine like that you should still be able to get 50-100 pages per second. Have you gone through the Technical Production Setup Guide and done the performance related configurations (especially of the caching)? -David On Jul 2, 2008, at 2:47 AM, Heidi Dehaes wrote: Hello, I use the ofbiz application and embedded tomcat server behind a Apache webserver. I am wondering that webpages on the Apache web server are very fast and webpages from the ofbizapplication are very slow. My database behind the application is MYSQL. I use 4 GB central memory with a Q6600 Quad Core Intel Processor on Windows Vista. Is it normal ? How to speed up the ofbiz application? I use already standard caching possibilities in the catalog screen. Regards, Heidi ofbiz: http://www.olagos.eu apache: http://www.olagos.eu/soldenzomer2008/index.html
Re: ofbiz is so slow
Yes, i know Linux is better but i am not a specialist in Linux. But i am not using a separate server for the database? I thought my workstation has enough power and memory to do it on the same machine. Should it be better to separate the db on a separate machine? The static content is separated and directly accessible from the Apache server. Heidi 2008/7/2, Jacques Le Roux [EMAIL PROTECTED]: I'm not a specialist, but I will 1st switch from Vista to Linux :o) I'm quite sure Vista is not really production ready (never tried Vista and I think will never) But there are plenty all other tricks which are not specific to OFBiz... You can't compare access to static content behind Apache to dynamic pages from OFBiz. Are you using a second server for DB at least ? Have you separated your static content and provide it directly from Apache server in front ? Etc. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, I use the ofbiz application and embedded tomcat server behind a Apache webserver. I am wondering that webpages on the Apache web server are very fast and webpages from the ofbizapplication are very slow. My database behind the application is MYSQL. I use 4 GB central memory with a Q6600 Quad Core Intel Processor on Windows Vista. Is it normal ? How to speed up the ofbiz application? I use already standard caching possibilities in the catalog screen. Regards, Heidi ofbiz: http://www.olagos.eu apache: http://www.olagos.eu/soldenzomer2008/index.html
Re: ofbiz is so slow
You mean in the startup command? I don't know by heart. I am at a distance from my (remote) server now. What do you propose for a 4 GB central memory? With Vista 32 bit only 3 GB is addressable. And my MYSQL database has to run also. Heidi 2008/7/2, Scott Gray [EMAIL PROTECTED]: Sorry if this is an obvious question but how much memory have you given to OFBiz? Regards Scott 2008/7/2 Heidi Dehaes [EMAIL PROTECTED]: Yes, i know Linux is better but i am not a specialist in Linux. But i am not using a separate server for the database? I thought my workstation has enough power and memory to do it on the same machine. Should it be better to separate the db on a separate machine? The static content is separated and directly accessible from the Apache server. Heidi 2008/7/2, Jacques Le Roux [EMAIL PROTECTED]: I'm not a specialist, but I will 1st switch from Vista to Linux :o) I'm quite sure Vista is not really production ready (never tried Vista and I think will never) But there are plenty all other tricks which are not specific to OFBiz... You can't compare access to static content behind Apache to dynamic pages from OFBiz. Are you using a second server for DB at least ? Have you separated your static content and provide it directly from Apache server in front ? Etc. Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, I use the ofbiz application and embedded tomcat server behind a Apache webserver. I am wondering that webpages on the Apache web server are very fast and webpages from the ofbizapplication are very slow. My database behind the application is MYSQL. I use 4 GB central memory with a Q6600 Quad Core Intel Processor on Windows Vista. Is it normal ? How to speed up the ofbiz application? I use already standard caching possibilities in the catalog screen. Regards, Heidi ofbiz: http://www.olagos.eu apache: http://www.olagos.eu/soldenzomer2008/index.html
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Yes, I have it also from time to time with version 4.x from OFBIZ. But i have no details at the moment. In every case when this happens i have to restart the java application. Heidi http://www.olagos.eu 2008/6/30, maburger [EMAIL PROTECTED]: Hi *, we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error within the JobManager.poll method. It seems like a DB lock is set on the JOB_SANBOX table, so the JobManager is not abled to execute the store operation. Has anyone ever had a similar problem or is this a known bug? We are using the last 3.x OFBiz release. Thanks for every reply! Here's the Stacktrace (The corresponding MySQL error is a lock wait timeout exceeded): 2008-06-26 18:34:16,276 [EMAIL PROTECTED] ERROR org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back transaction. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) java.sql.SQLException: Io exception: Connection timed out at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) at org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) 2008-06-26 18:34:16,276 [EMAIL PROTECTED] WARN
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
I am using the geronimo DBCP i think. Heidi 2008/7/1, maburger [EMAIL PROTECTED]: Are you using the DBCP or the old Minerva pool implementation? Heidi Dehaes wrote: Yes, I have it also from time to time with version 4.x from OFBIZ. But i have no details at the moment. In every case when this happens i have to restart the java application. Heidi http://www.olagos.eu 2008/6/30, maburger [EMAIL PROTECTED]: Hi *, we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error within the JobManager.poll method. It seems like a DB lock is set on the JOB_SANBOX table, so the JobManager is not abled to execute the store operation. Has anyone ever had a similar problem or is this a known bug? We are using the last 3.x OFBiz release. Thanks for every reply! Here's the Stacktrace (The corresponding MySQL error is a lock wait timeout exceeded): 2008-06-26 18:34:16,276 [EMAIL PROTECTED] ERROR org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back transaction. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) java.sql.SQLException: Io exception: Connection timed out at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) at org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Ok i use release 4 branch ofbiz (not the trunk version); So i probably use only Geronimo. but i don't know details about this transaction tool and connection pools, etc. Heidi 2008/7/1, BJ Freeman [EMAIL PROTECTED]: DBCPConnectionFactory was added rev 58 . only bug fixes happen in the 4.0 branch. BDCP is not considered a bug fix. Note: if you do a search of DBCPConnectionFactory in the commits mailing list you will find the commits. maburger sent the following on 7/1/2008 3:00 AM: Could you tell me when this change is applied to the 4.0 branch? BJ Freeman wrote: DBCP is a change that happened in the Trunk version. Heidi Dehaes sent the following on 7/1/2008 2:29 AM: I am using the geronimo DBCP i think. Heidi 2008/7/1, maburger [EMAIL PROTECTED]: Are you using the DBCP or the old Minerva pool implementation? Heidi Dehaes wrote: Yes, I have it also from time to time with version 4.x from OFBIZ. But i have no details at the moment. In every case when this happens i have to restart the java application. Heidi http://www.olagos.eu 2008/6/30, maburger [EMAIL PROTECTED]: Hi *, we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error within the JobManager.poll method. It seems like a DB lock is set on the JOB_SANBOX table, so the JobManager is not abled to execute the store operation. Has anyone ever had a similar problem or is this a known bug? We are using the last 3.x OFBiz release. Thanks for every reply! Here's the Stacktrace (The corresponding MySQL error is a lock wait timeout exceeded): 2008-06-26 18:34:16,276 [EMAIL PROTECTED] ERROR org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back transaction. org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out)) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME = ? AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io exception: Connection timed out) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) at java.lang.Thread.run(Thread.java:595) java.sql.SQLException: Io exception: Connection timed out at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339
ofbiz hangs from time to time with following error
Hello, From time to time, but regularly, my ofbiz applications hangs. When a new user tries to charge the site, it isn't from one moment to another not possible. If i look then into party visits i have the following error: Can anyone help me to resolve this error? thanks, Heidi http://www.olagos.eu Visit Detail VisitID / SessionID 63699 / 64813CC5F13AF715268A739F7EF0AC59.jvm1 Visitor ID Niet Gevonden PartyID/UserLoginID / User Created WebApp Server 10.0.0.3 / olagos-PC Client / Client User Initial Locale Initial Request Initial Referer Initial User Agent Cookie Van/tot Datum 2008-05-19 20:14:26.000 / 2008-05-19 20:14:26.000 Hit Tracker Content ID Type Size Start Time Time URI on line 114, column 23 in component://party/webapp/partymgr/visit/visitdetail.ftl Negative ending index for range, is lowIndex..highIndex-1 The problematic instruction: -- == list serverHits[lowIndex..highIndex-1] as hit [on line 114, column 5 in component://party/webapp/partymgr/visit/visitdetail.ftl] -- Java backtrace for programmers: -- freemarker.template.TemplateException: on line 114, column 23 in component://party/webapp/partymgr/visit/visitdetail.ftl Negative ending index for range, is lowIndex..highIndex-1 at freemarker.core.DynamicKeyName.dealWithRangeKey(DynamicKeyName.java:161) at freemarker.core.DynamicKeyName._getAsTemplateModel(DynamicKeyName.java:77) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:87) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:196) at freemarker.core.Environment.process(Environment.java:176) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:179) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:161) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation(FreeMarkerWorker.java:138) at org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:82) at org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:110) at org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:65) at org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:806) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:244) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:521) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:183) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:553) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:244) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:521) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:183) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:553) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:299) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:299) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:299) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:299) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:244) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:134) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:394) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:151) at
Re: applet request
You can easily put your applet request code APPLET ... /APPLET in an FTL file which builds the page you want to have it on. Heidi 2008/4/28, uma kuty [EMAIL PROTECTED]: Can any one suggest me..how to load an applet in ofbiz framewok. Regards, Uma - Bring your gang together. Do your thing. Find your favourite Yahoo! Group.
Re: applet request
Can't evaluate it at the moment. But the code-part or the archive-part seems me a little bit strange. I can send you this evening an example of a working applet. (this evening = in 7 hours later from now on) regards, Heidi 2008/4/28, uma kuty [EMAIL PROTECTED]: Hi, I tried it.But its not working,and this is the code, applet code=org.ofbiz.ecommerce.misc.sample.class archive=ofbiz-ecommerce.jar width=500 height=500/applet I wrote it in a FTL file. Regards, Uma Heidi Dehaes [EMAIL PROTECTED] wrote: You can easily put your applet request code in an FTL file which builds the page you want to have it on. Heidi 2008/4/28, uma kuty : Can any one suggest me..how to load an applet in ofbiz framewok. Regards, Uma - Bring your gang together. Do your thing. Find your favourite Yahoo! Group. - Explore your hobbies and interests. Click here to begin.
Re: google base or google products
But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
I don't see a link near the footer. Do you mean in the catalog page or the ecommerce page? I think i have to add these pages anywhere inthe controller.xml file? Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: On Apr 22, 2008, at 11:42 AM, Heidi Dehaes wrote: I don't see a link near the footer. which version are you running? Version 4.0 . Do you mean in the catalog page or the ecommerce page? Not ecomerce; in all the backend applications (including the catalog application). Don't see anything added in the backend applications. I think i have to add these pages anywhere inthe controller.xml file? No, they are already included in the trunk. But the controller.xml from the trunk doesn't add data in the controller.xml 's in the different application subdirectories? Jacopo Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
I use Ofbiz release 4.0. From the trunk i only installed the specialpurpose directory. Perhaps i have to modify my build.xml ?? Heidi 2008/4/22, Heidi Dehaes [EMAIL PROTECTED]: 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: On Apr 22, 2008, at 11:42 AM, Heidi Dehaes wrote: I don't see a link near the footer. which version are you running? Version 4.0 . Do you mean in the catalog page or the ecommerce page? Not ecomerce; in all the backend applications (including the catalog application). Don't see anything added in the backend applications. I think i have to add these pages anywhere inthe controller.xml file? No, they are already included in the trunk. But the controller.xml from the trunk doesn't add data in the controller.xml 's in the different application subdirectories? Jacopo Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
Should the google be loaded automatically? If it is not loaded or disabled what to modify that it will be enabled or loaded? Heidi 2008/4/22, BJ Freeman [EMAIL PROTECTED]: The Trunk is the only version that has the modified tabs(ones in footer). unless the tab as been disabled you should see it on the top, in ver4.0 read you log to make sure the google is being loaded. Heidi Dehaes sent the following on 4/22/2008 8:05 AM: I use Ofbiz release 4.0. From the trunk i only installed the specialpurpose directory. Perhaps i have to modify my build.xml ?? Heidi 2008/4/22, Heidi Dehaes [EMAIL PROTECTED]: 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: On Apr 22, 2008, at 11:42 AM, Heidi Dehaes wrote: I don't see a link near the footer. which version are you running? Version 4.0 . Do you mean in the catalog page or the ecommerce page? Not ecomerce; in all the backend applications (including the catalog application). Don't see anything added in the backend applications. I think i have to add these pages anywhere inthe controller.xml file? No, they are already included in the trunk. But the controller.xml from the trunk doesn't add data in the controller.xml 's in the different application subdirectories? Jacopo Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
That is already the case but i don't see the button. Heidi 2008/4/22, BJ Freeman [EMAIL PROTECTED]: you must add theload-components parent-directory=specialpurpose/ to your framework\base\config\component-load.xml Heidi Dehaes sent the following on 4/22/2008 8:26 AM: Should the google be loaded automatically? If it is not loaded or disabled what to modify that it will be enabled or loaded? Heidi 2008/4/22, BJ Freeman [EMAIL PROTECTED]: The Trunk is the only version that has the modified tabs(ones in footer). unless the tab as been disabled you should see it on the top, in ver4.0 read you log to make sure the google is being loaded. Heidi Dehaes sent the following on 4/22/2008 8:05 AM: I use Ofbiz release 4.0. From the trunk i only installed the specialpurpose directory. Perhaps i have to modify my build.xml ?? Heidi 2008/4/22, Heidi Dehaes [EMAIL PROTECTED]: 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: On Apr 22, 2008, at 11:42 AM, Heidi Dehaes wrote: I don't see a link near the footer. which version are you running? Version 4.0 . Do you mean in the catalog page or the ecommerce page? Not ecomerce; in all the backend applications (including the catalog application). Don't see anything added in the backend applications. I think i have to add these pages anywhere inthe controller.xml file? No, they are already included in the trunk. But the controller.xml from the trunk doesn't add data in the controller.xml 's in the different application subdirectories? Jacopo Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: google base or google products
Found it. Thanks for your help. Have to test it still. But in the specialpurpose subdirectory in the file component-load.xml the description for googlebase was not there. Thanks a lot everybody, Heidi 2008/4/22, Heidi Dehaes [EMAIL PROTECTED]: That is already the case but i don't see the button. Heidi 2008/4/22, BJ Freeman [EMAIL PROTECTED]: you must add theload-components parent-directory=specialpurpose/ to your framework\base\config\component-load.xml Heidi Dehaes sent the following on 4/22/2008 8:26 AM: Should the google be loaded automatically? If it is not loaded or disabled what to modify that it will be enabled or loaded? Heidi 2008/4/22, BJ Freeman [EMAIL PROTECTED]: The Trunk is the only version that has the modified tabs(ones in footer). unless the tab as been disabled you should see it on the top, in ver4.0 read you log to make sure the google is being loaded. Heidi Dehaes sent the following on 4/22/2008 8:05 AM: I use Ofbiz release 4.0. From the trunk i only installed the specialpurpose directory. Perhaps i have to modify my build.xml ?? Heidi 2008/4/22, Heidi Dehaes [EMAIL PROTECTED]: 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: On Apr 22, 2008, at 11:42 AM, Heidi Dehaes wrote: I don't see a link near the footer. which version are you running? Version 4.0 . Do you mean in the catalog page or the ecommerce page? Not ecomerce; in all the backend applications (including the catalog application). Don't see anything added in the backend applications. I think i have to add these pages anywhere inthe controller.xml file? No, they are already included in the trunk. But the controller.xml from the trunk doesn't add data in the controller.xml 's in the different application subdirectories? Jacopo Heidi 2008/4/22, Jacopo Cappellato [EMAIL PROTECTED]: The link to the Google Base application is at the bottom of every page (near the footer). Jacopo On Apr 22, 2008, at 8:58 AM, Heidi Dehaes wrote: But i need a tab in the menu from ofbiz catalog for example isn't it? I need to have a export button anywhere in the application? Don't i need to add something in the controller.xml file for example? Heidi 2008/4/21, [EMAIL PROTECTED] [EMAIL PROTECTED]: You have only to configure the file googleBaseExport.properties into the google base application and from there you will be able to export your products created in OFBiz into google base. Marco - Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
google base or google products
Hello, I downloaded the google base software for ofbiz in the specialpurpose. But how to implement now the google support in ofbiz? Can anyone help me? thanks, Heidi
Re: How to set smtp server at local network
or the domain name works also. Heidi 2008/4/15, BJ Freeman [EMAIL PROTECTED]: my guess is that is should be left at the default localhost Pradeep Kumar sent the following on 4/15/2008 1:00 PM: Hi, I installed the SMTP server and configured it in general.properties file but it does not work. I set like this mail.smtp.relay.host = server and it is giving this error : No matching list found It is running on the port no. 99 What is the solution for this ?
Re: surveys
thanks, Heidi 2008/4/6, Jacques Le Roux [EMAIL PROTECTED]: Have a look at minisurvey.ftl Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, Can anyone explain me how i can visualize in the webpage of the e-shop surveys i have created. Where and how do they appear? Can i make them multilingual? heidi
Re: surveys
Thanks, If i know that it is not easy, i am ok already. heidi 2008/4/8, Jacques Le Roux [EMAIL PROTECTED]: Heidi, I'm afraid there ares no easy answers. You are right AFAIK there are no UIs to deal with that. So the only way is to use a file like the ones I suggested you to look at... Jacques From: Heidi Dehaes [EMAIL PROTECTED] thanks, Heidi 2008/4/6, Jacques Le Roux [EMAIL PROTECTED]: Have a look at minisurvey.ftl Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, Can anyone explain me how i can visualize in the webpage of the e-shop surveys i have created. Where and how do they appear? Can i make them multilingual? heidi
Re: catalogs ? not multilingual
I used CATEGORY CONTENT CATEGORY NAME: PREPARE CREATE I create the text for the category name for for example English. Then i create the text for the category name for for example French. and so on. Then in the CONTENT under tab CONTENT for this text , i chose ASSOCIATION and i chose EDIT CONTENT ASSOCIATION and ALTERNATE LOCALE so that the language is automatically changed when needed. BUT i don't have this possibilities for CATALOGUS There is no screen in ofbiz to do the same things for CATALOGI. Heidi 2008/4/6, Jacques Le Roux [EMAIL PROTECTED]: How did you do for categories and products ? If you followed demo data files you may follow the same way for catalog. It has not been done for catalog, as it should be obvious at this stage (ie after having done categories and products) Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, Can anyone explain me how to make catalogs multilingual? It is quite easy to do it for the names of categories and for the content of products. But i don't see any possibility for doing it with catalogs? thanks in advance, heidi
catalogs ? not multilingual
Hello, Can anyone explain me how to make catalogs multilingual? It is quite easy to do it for the names of categories and for the content of products. But i don't see any possibility for doing it with catalogs? thanks in advance, heidi
surveys
Hello, Can anyone explain me how i can visualize in the webpage of the e-shop surveys i have created. Where and how do they appear? Can i make them multilingual? heidi
in stock / not in stock
Hello, What is the (detailed) procedure to follow in order to have near the product visualised the sentence: in stock or not in stock? What steps have to be done? thanks, H.
usually ships in 3 days
Hello, I have for one catalogus with different categories the following line besides the products in this categories : usually ships in 3 days How can i do this away? I don't have this mentionned near the products of the other catalogusses. thanks for help, Heidi
Re: Accounting: TVA
My site is: http://www.olagos.eu 2008/3/4, Heidi Dehaes [EMAIL PROTECTED]: In ofbiz you have the possibility to enter a rule for TVA taxes. You can choose that it is added to the total amount of the order. However i entered in the TVA rule that the tax rate is 21 %. But in reality it counts something between 18 and 19 %. What is the reason and how to solve? So i gave in: - type: TVA et taxes assimilées - Store ID: - Category: - - Eigendomsoverdracht: Destination - Min Item Price: 0 - Min Purchase : 0 - Tax Shipping: Y - TAX PERCENTAGE : 21 - From Date: .. - Thru Date: - - Description: TVA You can also look to my site and try to buy something. You will see in the checkout at the end before you go to paypal that the calculation is not exactly what it should be. thanks, Heidi 2008/3/4, David E Jones [EMAIL PROTECTED]: Please provide more details, such as everything in the cart/order you are looking at including all items, adjustments, etc. -David On Mar 4, 2008, at 1:46 AM, Heidi Dehaes wrote: Hello, I see that the TVA which is added to the total amount to pay by the customer, is in percentage around 19,6 %. Although i entered 21 % in the rule for TVA adding. I think there must be anywhere an error in the code? Has someone experience with this? thanks in advance, Heidi http://www.olagos.eu
Re: Accounting: TVA
Hi again, It is solved. The problem is that my name and address used for the purchase are put on France temporarily. In the database in the TaxAuthorityRateProduct table there are three records with no productStoreId filled in. So they count for each Store. And these ones have TaxAuthGeoId = FRA When i changed the country of my address with which i did the purchase, to Belgium, the problem was solved. The tax was calculated with exactly 21 %. So solution is to delete for sure these three records in the TaxAuthorityRateProduct table which don't point to any special ProductStoreId. Heidi 2008/3/4, Heidi Dehaes [EMAIL PROTECTED]: For example: I buy the product: 14 - Layla 1 - 32 cm: for the price of 19,97 euro. Cart Total: 19,97 euro I do a checkout and pass further on to How shall we ship?: Further with How shall you pay? (with PayPal) Then i come to the Final Checkout Review: There is mentioned: Product: 14 - Layla 1 - 32 cm Qty Ordered: 1 Unit Price: 16,50 euro Shipping and Handling: 6,00 euro Sales Tax: 4,41 euro Grand Total:26,91 euro 21 % tax or TVA on (16,50 + 6 euro's) is 4,725 euro and not 4,41 euro. There is the problem ! Heidi 2008/3/4, David E Jones [EMAIL PROTECTED]: The details of the order or cart to show the details of the results you are describing would be more helpful than describing how you got to them. -David On Mar 4, 2008, at 2:07 AM, Heidi Dehaes wrote: In ofbiz you have the possibility to enter a rule for TVA taxes. You can choose that it is added to the total amount of the order. However i entered in the TVA rule that the tax rate is 21 %. But in reality it counts something between 18 and 19 %. What is the reason and how to solve? So i gave in: - type: TVA et taxes assimilées - Store ID: - Category: - - Eigendomsoverdracht: Destination - Min Item Price: 0 - Min Purchase : 0 - Tax Shipping: Y - TAX PERCENTAGE : 21 - From Date: .. - Thru Date: - - Description: TVA You can also look to my site and try to buy something. You will see in the checkout at the end before you go to paypal that the calculation is not exactly what it should be. thanks, Heidi 2008/3/4, David E Jones [EMAIL PROTECTED]: Please provide more details, such as everything in the cart/order you are looking at including all items, adjustments, etc. -David On Mar 4, 2008, at 1:46 AM, Heidi Dehaes wrote: Hello, I see that the TVA which is added to the total amount to pay by the customer, is in percentage around 19,6 %. Although i entered 21 % in the rule for TVA adding. I think there must be anywhere an error in the code? Has someone experience with this? thanks in advance, Heidi http://www.olagos.eu
Re: Accounting: TVA
No, i think it was installed automatically. But i used ofbizNeogia before and converted the database and upgraded to ofbiz4.0. That is the reason. Heidi 2008/3/4, Jacques Le Roux [EMAIL PROTECTED]: To be clear : this only comes from your own data, there are no such default configuration OOTB (I just checked) Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hi again, It is solved. The problem is that my name and address used for the purchase are put on France temporarily. In the database in the TaxAuthorityRateProduct table there are three records with no productStoreId filled in. So they count for each Store. And these ones have TaxAuthGeoId = FRA When i changed the country of my address with which i did the purchase, to Belgium, the problem was solved. The tax was calculated with exactly 21 %. So solution is to delete for sure these three records in the TaxAuthorityRateProduct table which don't point to any special ProductStoreId. Heidi 2008/3/4, Heidi Dehaes [EMAIL PROTECTED]: For example: I buy the product: 14 - Layla 1 - 32 cm: for the price of 19,97 euro. Cart Total: 19,97 euro I do a checkout and pass further on to How shall we ship?: Further with How shall you pay? (with PayPal) Then i come to the Final Checkout Review: There is mentioned: Product: 14 - Layla 1 - 32 cm Qty Ordered: 1 Unit Price: 16,50 euro Shipping and Handling: 6,00 euro Sales Tax: 4,41 euro Grand Total:26,91 euro 21 % tax or TVA on (16,50 + 6 euro's) is 4,725 euro and not 4,41 euro. There is the problem ! Heidi 2008/3/4, David E Jones [EMAIL PROTECTED]: The details of the order or cart to show the details of the results you are describing would be more helpful than describing how you got to them. -David On Mar 4, 2008, at 2:07 AM, Heidi Dehaes wrote: In ofbiz you have the possibility to enter a rule for TVA taxes. You can choose that it is added to the total amount of the order. However i entered in the TVA rule that the tax rate is 21 %. But in reality it counts something between 18 and 19 %. What is the reason and how to solve? So i gave in: - type: TVA et taxes assimilées - Store ID: - Category: - - Eigendomsoverdracht: Destination - Min Item Price: 0 - Min Purchase : 0 - Tax Shipping: Y - TAX PERCENTAGE : 21 - From Date: .. - Thru Date: - - Description: TVA You can also look to my site and try to buy something. You will see in the checkout at the end before you go to paypal that the calculation is not exactly what it should be. thanks, Heidi 2008/3/4, David E Jones [EMAIL PROTECTED]: Please provide more details, such as everything in the cart/order you are looking at including all items, adjustments, etc. -David On Mar 4, 2008, at 1:46 AM, Heidi Dehaes wrote: Hello, I see that the TVA which is added to the total amount to pay by the customer, is in percentage around 19,6 %. Although i entered 21 % in the rule for TVA adding. I think there must be anywhere an error in the code? Has someone experience with this? thanks in advance, Heidi http://www.olagos.eu
Taxes as TVA
Hello, In ofbiz you have the possibility to enter a rule for TVA taxes. You can choose that it is added to the total amount of the order. However i entered in the TVA rule that the tax rate is 21 %. But in reality it counts something between 18 and 19 %. What is the reason and how to solve? So i gave in: - type: TVA et taxes assimilées - Store ID: - Category: - - Eigendomsoverdracht: Origin (ORIG) - Min Item Price: 0 - Min Purchase : 0 - Tax Shipping: Y - TAX PERCENTAGE : 21 - From Date: .. - Thru Date: - - Description: TVA for Belgium thanks in advance, Heidi
Re: Taxes as TVA
Thanks for the information. It is worthwhile. But even then i don't see immediately a reason not to calculate the tax on the 21 % i inputted as a parameter. I will check the java code. Do you have an idea which java file calculates the percentage TVA? thanks, Heidi 2008/3/3, Jacques Le Roux [EMAIL PROTECTED]: Did you know this http://docs.ofbiz.org/display/OFBTECH/OFBiz%27s+Tax+Authority+Data+Model ? Jacques From: Heidi Dehaes [EMAIL PROTECTED] Hello, In ofbiz you have the possibility to enter a rule for TVA taxes. You can choose that it is added to the total amount of the order. However i entered in the TVA rule that the tax rate is 21 %. But in reality it counts something between 18 and 19 %. What is the reason and how to solve? So i gave in: - type: TVA et taxes assimilées - Store ID: - Category: - - Eigendomsoverdracht: Origin (ORIG) - Min Item Price: 0 - Min Purchase : 0 - Tax Shipping: Y - TAX PERCENTAGE : 21 - From Date: .. - Thru Date: - - Description: TVA for Belgium thanks in advance, Heidi
Re: Shipping Estimates according to weight
Hello, I give a shipping cost in the system for 0 - 250 gram, another shipping cost for 250,1 - 500 gram, another shipping cost for 500,1 - 750 gram, etc. Heidi Dehaes www.olagos.eu 2008/2/28, simmy007 [EMAIL PROTECTED]: My query is related to shipping costs , I have a specific requirement regarding the shipping , I have to increase the shipping cost according to weight i.e for every 250 gm of weight some amount (say 100 Rs)should be added on shipping. I had look on shipping tab but it shows per unit price but I want to add stack amount. Do ofbiz provide this functionality or Is there any better way to achieve this. -- View this message in context: http://www.nabble.com/Shipping-Estimates-according-to-weight-tp15732437p15732437.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ofbiz as a affiliate site
Hi Vince, I mean that someone else can show my products on their website, but that they are routed to our website to the specific product for the real sale, so that we earn the money. Besides that a commission must be payed to the external website who shows the products. thanks, Heidi 2008/2/24, Vince M. Clark [EMAIL PROTECTED]: Can you be more clear about what an affiliate means to you? - Original Message - From: Heidi Dehaes [EMAIL PROTECTED] To: user@ofbiz.apache.org Sent: Friday, February 22, 2008 7:31:05 AM (GMT-0700) America/Denver Subject: Re: ofbiz as a affiliate site 2008/2/20, Heidi Dehaes [EMAIL PROTECTED]: Hello, I want to know if ofbiz can function as a affiliate site. And if so how to configure ofbiz to do that. thanks, Heidi http://www.olagos.eu
Re: ofbiz as a affiliate site
2008/2/20, Heidi Dehaes [EMAIL PROTECTED]: Hello, I want to know if ofbiz can function as a affiliate site. And if so how to configure ofbiz to do that. thanks, Heidi http://www.olagos.eu
EXTERNALLOGINKEY
Hello, Can someone explain me what are the EXTERNALLOGINKEY 's used for like someone here in the example uses to try to access my site https://www.olagos.eu:8443/ordermgr/control/main?externalLoginKey=EL706006419794 thanks, Heidi http://www.olagos.eu http://www.olagos.be http://www.olagos.com
ofbiz table Work_effort problem in derby database
hello, I have a problem with the work_effort table in the ofbiz database (derby). Especially when i like to see the order list in the orders tab and i click on an order to edit the order, i receive an error. org.ofbiz.base.util.GeneralException: Error rendering screen [component://order/widget/ordermgr/OrderViewScreens.xml#OrderHeaderView]: org.ofbiz.base.util.GeneralException: Error running BSH script at location [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh]: org.ofbiz.base.util.GeneralException: Error running BSH script at [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh], line [297]: Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null : at Line: 297 : in file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : manufacturingInQuantitySummaryByFacility .get ( estimatedQuantityTotal ) Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation (Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null) (Error running BSH script at [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh], line [297]: Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null : at Line: 297 : in file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : manufacturingInQuantitySummaryByFacility .get ( estimatedQuantityTotal ) Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation (Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null)) (Error running BSH script at location [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh]: org.ofbiz.base.util.GeneralException: Error running BSH script at [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh], line [297]: Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null : at Line: 297 : in file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : manufacturingInQuantitySummaryByFacility .get ( estimatedQuantityTotal ) Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation (Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null) (Error running BSH script at [component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh], line [297]: Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null : at Line: 297 : in file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : manufacturingInQuantitySummaryByFacility .get ( estimatedQuantityTotal ) Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation (Sourced file: component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh : Typed variable declaration : null))) When i want to see the table work_effort in the webtools , entity data maintenance, i receive this error. Can someone help how i can repair such a single table in a derby database. PS.: i use Squirrel to edit the database. thanks, Delopper at Olagos.eu org.ofbiz.base.util.GeneralException: Error rendering screen [component://webtools/widget/EntityScreens.xml#FindGeneric]: org.ofbiz.base.util.GeneralException: Error running BSH script at location [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]: org.ofbiz.base.util.GeneralException: Error running BSH script at [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh], line [121]: Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : Method Invocation delegator.findCountByCondition : at Line: 121 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : delegator .findCountByCondition ( findByEntity .getEntityName ( ) , condition , null ) Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(*) FROM OFBIZ.WORK_EFFORT(Unknown container format at container null : 543,451,493) (Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : Method Invocation delegator.findCountByCondition) (Error running BSH script at [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh], line [121]: Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : Method Invocation delegator.findCountByCondition : at Line: 121 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : delegator .findCountByCondition ( findByEntity .getEntityName ( ) , condition , null ) Target exception: