Configure Php project with OFBiz framework
Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Cannot complete OfBiz setup wizard
information needs to be added into the process to import the General ledger look at Setupevents.xml create General Ledger Setup Tim Stoel sent the following on 7/20/2011 5:04 PM: I have installed OfBiz 10.04 on Centos 5.6 with MySQL, and no demo data is installed. I just deleted the databases, recreated them, and ran ./ant run-install-seed and ./ant create-admin-user-login, and then started the setup wizard. I filled out ³Organization² ³Facility² and I am unable to complete ³Product Store². I am getting this error: Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][createdTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][lastUpdatedStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTyp eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMet hodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/CARRIER_SHIPMENT_METHOD`, CONSTRAINT `CARR_SHMETH_TYPE` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`) REFERENCES `SHIPMENT_METHOD_TYPE` (`SHIPMENT_METHOD_TYPE_ID` calling service parseEntityXmlFile in importTempDataFile Should I even be using this wizard to set up OfBiz? Or should I just do it all manually? Thanks in advance! Tim Stoel
Re: Cannot complete OfBiz setup wizard
sorry Import Default ProductStore Shipment data BJ Freeman sent the following on 7/20/2011 11:53 PM: information needs to be added into the process to import the General ledger look at Setupevents.xml create General Ledger Setup Tim Stoel sent the following on 7/20/2011 5:04 PM: I have installed OfBiz 10.04 on Centos 5.6 with MySQL, and no demo data is installed. I just deleted the databases, recreated them, and ran ./ant run-install-seed and ./ant create-admin-user-login, and then started the setup wizard. I filled out ³Organization² ³Facility² and I am unable to complete ³Product Store². I am getting this error: Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][createdTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][lastUpdatedStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTyp eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMet hodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/CARRIER_SHIPMENT_METHOD`, CONSTRAINT `CARR_SHMETH_TYPE` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`) REFERENCES `SHIPMENT_METHOD_TYPE` (`SHIPMENT_METHOD_TYPE_ID` calling service parseEntityXmlFile in importTempDataFile Should I even be using this wizard to set up OfBiz? Or should I just do it all manually? Thanks in advance! Tim Stoel
Re: Configure Php project with OFBiz framework
Use apache rewrite rule and virtualhost or Alias to contact your php application, if your OFBiz has been connected with apache by ajp. Nicolas Le 21/07/2011 08:28, jairaj a écrit : Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Nicolas MALIN Consultant Tél : 06.17.66.40.06 Site projet : http://www.neogia.org/ --- Société LibrenBerry Tél : 02.48.02.56.12 Site : http://www.librenberry.net/
Re: Configure Php project with OFBiz framework
This may help https://issues.apache.org/jira/browse/OFBIZ-4203 Jacques From: jairaj gaur.jai...@gmail.com Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Configure Php project with OFBiz framework
What kind of a project your using. http://www.caucho.com/resin-3.0/quercus/ With regards, S K Pradeep kumar, 9980609494 On Thu, Jul 21, 2011 at 11:58 AM, jairaj gaur.jai...@gmail.com wrote: Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Configure Php project with OFBiz framework
For my client I have to develop 34 different modules using ofbiz framework , I have few modules already designed in Php lang that I have to integrate with other modules. Some module are already hosted , for this we are using Apache Server. Now I dont want to re-develop my Php module in OFbiz. Could you please give me some more idea about Quercus and how it ll help me. Thank you -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3683035.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Configure Php project with OFBiz framework
I installed http://php-java-bridge.sourceforge.net/pjb/installation.php as a POC in the ecommerce webapp folder. I have not had a chance to really dig into it yet. jairaj sent the following on 7/20/2011 11:28 PM: Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com.
EntityConditions to lookup records between 2 dates
The following doesn't seem to work. Calendar calS = Calendar.getInstance(); calS.set(Calendar.DAY_OF_MONTH, 25); calS.set(Calendar.MONTH, (calS.get(Calendar.MONTH)-1)); Calendar calE = Calendar.getInstance(); calE.set(Calendar.DAY_OF_MONTH, 25); Timestamp periodBeginning = UtilDateTime.getTimestamp(calS.getTimeInMillis()); Timestamp periodEnd = UtilDateTime.getTimestamp(calE.getTimeInMillis()); EntityCondition condition1 = EntityCondition.makeCondition(EntityOperator.AND, EntityCondition.makeCondition(invoiceTypeId, EntityOperator.EQUALS, SALES_INVOICE), EntityCondition.makeCondition(invoiceDate, EntityOperator.LESS_THAN, periodEnd), EntityCondition.makeCondition(invoiceDate, EntityOperator.GREATER_THAN, periodBeginning)); This must be a fairly common task is there an EntityOperator for timestamps? Thanks in advance. -- Regards, Justin Venture-Net Research Development
Re: EntityConditions to lookup records between 2 dates
I don't know why the EntityCondition isn't working, but I see something wrong in your calendar logic. Instead of subtracting one from the int constant, you should use the Calendar object's add method to subtract one month. -Adrian On 7/21/2011 2:23 PM, Justin Robinson wrote: The following doesn't seem to work. Calendar calS = Calendar.getInstance(); calS.set(Calendar.DAY_OF_MONTH, 25); calS.set(Calendar.MONTH, (calS.get(Calendar.MONTH)-1)); Calendar calE = Calendar.getInstance(); calE.set(Calendar.DAY_OF_MONTH, 25); Timestamp periodBeginning = UtilDateTime.getTimestamp(calS.getTimeInMillis()); Timestamp periodEnd = UtilDateTime.getTimestamp(calE.getTimeInMillis()); EntityCondition condition1 = EntityCondition.makeCondition(EntityOperator.AND, EntityCondition.makeCondition(invoiceTypeId, EntityOperator.EQUALS, SALES_INVOICE), EntityCondition.makeCondition(invoiceDate, EntityOperator.LESS_THAN, periodEnd), EntityCondition.makeCondition(invoiceDate, EntityOperator.GREATER_THAN, periodBeginning)); This must be a fairly common task is there an EntityOperator for timestamps? Thanks in advance.
Ofbiz Eclipse plugin
Hello I'm working on an existing Ofbiz Eclipse plugin that is based on this one: http://www.itu.dk/~hessellund/smartemf/ofbizexplorer.htm I have added some new features: -Parsing controller.xml -Finding service call/invocation in (reference, usage) in java files. Currently it's commented out because it's very slow for the first time to parse everything. Im going to add an incremental project builder extension to support for incremental parsing. Im adding new things to it. https://github.com/rasztasd/ofbiz-eclipse-project-explorer
Re: Cannot complete OfBiz setup wizard
Thanks for the link Hans, but this page doesn't load for me, I tried the Google cache and a search with no luck either. Tim From: Hans Bakker mailingl...@antwebsystems.com Reply-To: user@ofbiz.apache.org Date: Thu, 21 Jul 2011 08:12:33 +0700 To: user@ofbiz.apache.org Subject: Re: Cannot complete OfBiz setup wizard You can find an explanation how to do this. at http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co ntent if the problem persists, you may enter a jira issue for this. Depending on the urgency we can help you solve this problem. Regards, Hans. On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: I have installed OfBiz 10.04 on Centos 5.6 with MySQL, and no demo data is installed. I just deleted the databases, recreated them, and ran ./ant run-install-seed and ./ant create-admin-user-login, and then started the setup wizard. I filled out ³Organization² ³Facility² and I am unable to complete ³Product Store². I am getting this error: Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][createdTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][lastUpdatedStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTyp eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMet hodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/CARRIER_SHIPMENT_METHOD`, CONSTRAINT `CARR_SHMETH_TYPE` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`) REFERENCES `SHIPMENT_METHOD_TYPE` (`SHIPMENT_METHOD_TYPE_ID` calling service parseEntityXmlFile in importTempDataFile Should I even be using this wizard to set up OfBiz? Or should I just do it all manually? Thanks in advance! Tim Stoel -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: Cannot complete OfBiz setup wizard
it took about a minute to be load. The final URL was http://www.antwebsystems.com/control/mainSetup-OFBiz-with-your-data-in-15-minutes-16907-content did a traceroute to www.antwebsystems.com once left US backbone ttl jump to 176ms min and either timed out or was about 400ms the closer to the server. you can use http://.traceroute.org to view from different places in the world back to your server. Tim Stoel sent the following on 7/21/2011 9:08 AM: Thanks for the link Hans, but this page doesn't load for me, I tried the Google cache and a search with no luck either. Tim From: Hans Bakker mailingl...@antwebsystems.com Reply-To: user@ofbiz.apache.org Date: Thu, 21 Jul 2011 08:12:33 +0700 To: user@ofbiz.apache.org Subject: Re: Cannot complete OfBiz setup wizard You can find an explanation how to do this. at http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co ntent if the problem persists, you may enter a jira issue for this. Depending on the urgency we can help you solve this problem. Regards, Hans. On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: I have installed OfBiz 10.04 on Centos 5.6 with MySQL, and no demo data is installed. I just deleted the databases, recreated them, and ran ./ant run-install-seed and ./ant create-admin-user-login, and then started the setup wizard. I filled out ³Organization² ³Facility² and I am unable to complete ³Product Store². I am getting this error: Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][createdTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][lastUpdatedStamp,2011-07-20 16:58:15.373(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-20 16:58:15.286(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTyp eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMet hodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/CARRIER_SHIPMENT_METHOD`, CONSTRAINT `CARR_SHMETH_TYPE` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`) REFERENCES `SHIPMENT_METHOD_TYPE` (`SHIPMENT_METHOD_TYPE_ID` calling service parseEntityXmlFile in importTempDataFile Should I even be using this wizard to set up OfBiz? Or should I just do it all manually? Thanks in advance! Tim Stoel -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Exceptions to Best Practices
https://cwiki.apache.org/OFBIZ/exceptions-to-best-practices-approach.html I have read this for a few days to figure out its goal. it is to note the Exceptions to Best Practices and provide a Best Practices to those?
Re: OFBiz Blog, Integration 3rd party tools
Sascha, sorry to revive such an old post but we were just looking for a similar option and we also found Roller. It does look like it would accomplish everything we need. Did you have any success with it? Cheers. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-Blog-Integration-3rd-party-tools-tp1415270p3684820.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Exceptions to Best Practices
It looks like the only best practice on it is the one sub-page about only referring to partyId using a join table with the ID of the related entity, a partyId and a roleTypeId. Then it lists dozens of exceptions. I didn't look up who made that page, but given the number of exceptions I hope they would realize that what they think is a best practice is really not. -David On Jul 21, 2011, at 9:19 PM, BJ Freeman wrote: https://cwiki.apache.org/OFBIZ/exceptions-to-best-practices-approach.html I have read this for a few days to figure out its goal. it is to note the Exceptions to Best Practices and provide a Best Practices to those?
Re: Exceptions to Best Practices
yes the new format does not let you go to the dash board and hides authors. I was able to go to the dashboard and the find the page to view the old way and found Added by cjhowe, last edited by Jacques Le Roux on Aug 12, 2008 (view change) sorry to waste time. David E Jones sent the following on 7/21/2011 1:34 PM: It looks like the only best practice on it is the one sub-page about only referring to partyId using a join table with the ID of the related entity, a partyId and a roleTypeId. Then it lists dozens of exceptions. I didn't look up who made that page, but given the number of exceptions I hope they would realize that what they think is a best practice is really not. -David On Jul 21, 2011, at 9:19 PM, BJ Freeman wrote: https://cwiki.apache.org/OFBIZ/exceptions-to-best-practices-approach.html I have read this for a few days to figure out its goal. it is to note the Exceptions to Best Practices and provide a Best Practices to those?
Re: OFBiz Blog, Integration 3rd party tools
Hi Scott, nope we went another way. Roller doesn't fit to our needs, so i give up investigating on this task. The reason was we need more than only the blog functionality and we had to create an ofbiz based CMS System. Cheers Sascha 2011/7/21 ScottA sc...@uniondiamond.com Sascha, sorry to revive such an old post but we were just looking for a similar option and we also found Roller. It does look like it would accomplish everything we need. Did you have any success with it? Cheers. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-Blog-Integration-3rd-party-tools-tp1415270p3684820.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Sascha Rodekamp Visit the new german OFBiz Blog: http://www.ofbiz.biz Lynx-Consulting GmbH Johanniskirchplatz 6 D-33615 Bielefeld http://www.lynx.de