Re: Shopping List - Create List reorders
You may as well try using ShoppingListItem.modifiedPrice, you will have to write one line custom code to set the previous price. On Wed, Jul 10, 2013 at 4:31 PM, Len Shein lsh...@solveda.com wrote: Community, I have an issue with the Shopping List 'createListReorders' service I was hoping the community could provide some feedback on. When a product is added to the Shopping List (type=SLT_AUTO_REODR) the product and the quantity is correctly added as a shopping list item. However the unit price of the product is NOT added. The 'createListReorders' service then creates the order (according to Shopping list recurrence rules) based on the shopping list items of the shopping list and re-calculates the price of the product at the time the order is created, essentially using the 'current' product price. My issue is I would like the shopping list item to 'save' the unit price of the product at the time the 'customer' adds the shopping list item to the 'Shopping List'. This way if the price is changed in the current product configuration, the 'original' unit price of when the shopping list item was added remains the same for that customers shopping list. The best way I see to accomplish this requirement would be to extend entity 'SHOPPING_LIST_ITEM'; adding UNTI_PRICE. The 'createListReorders' service would then use this price when adding the shopping list item to the order. Has anyone had any experience with this? Is there an alternative solution? Len Shein lsh...@salmonllc.com O: 516.742.7888 x225 O: 732.333.4303 C: 917.882.8515 -- Regards, Varun Bhansaly
Re: Unwanted OrderStatus when importing
To disable EECA set entity-eca-enabled=true in entityengine.xml's delegator definition. SECA may have to disabled by making a minor change in Java code AFAIK there's no setting to disable it. On Tue, Jul 9, 2013 at 11:55 PM, Skip s...@thedevers.org wrote: I am importing millions of records from an existing system. Somehow, I am getting multiple OrderStatus records with PAYMENT_NOT_RECEIVED for every order imported. Firstly, does anyone know what eca is causing this, and second, is there a way to disable all ecas while I import these records? Thanks in advance Skip -- Regards, Varun Bhansaly
Re: How does visual theme for product store work?
Hi Robert, Visual themes define the resources they are going to use such as - JS, CSS, header, footer etc. When you are viewing a product store, the configured theme is picked by a decorator, is then applied to render the screen. On Fri, Jun 21, 2013 at 7:40 AM, Robert Wynkoop robert.wynk...@gmail.comwrote: How does setting the visual theme for product store work? How does this change the view? Does it use a different style sheet? I trying to investigate how view themes are handled. I have been looking at RequestHandler.renderView and MacroScreenView.render but have not seen anything related to themes. Robert Wynkoop -- Regards, Varun Bhansaly
RE: radio widgets in 12.o4
You can as well try managing the orientation using CSS. On 22 Jun 2013 07:12, Skip s...@thedevers.org wrote: My mistake, these radio buttons were not displayed in their own tr, they were displayed in a div. They are now displayed in a span I have modified the code in HtmlFormRenderer to use div instead of span like it used to be. This works for me, but I am thinking that others might like them horizontally, so it might be a nice addition to have an orientation keyword in the radio xsd. Skip -Original Message- From: Skip [mailto:s...@thedevers.org] Sent: Friday, June 21, 2013 6:19 PM To: OfbizUser Subject: radio widgets in 12.o4 It used to be that radio widget fields were displayed with each option displayed in its own tr with the label and button in tds Now, all the radio buttons and their labels are in the same tr. Is there some way I can force the renderer to display them vertically instead of horizontally? Thanks Skip
Re: New to OFBiz. How to modify the eCommerce app?
Hi Robert, It depends on how much changes you are making. Instead of copying entire eCommerce component over to hot-deploy, you can as well 'extend' the eCommerce component, make and maintain your changes separately (See https://cwiki.apache.org/OFBIZ/faq-tips-tricks-cookbook-howto.html#FAQ-Tips-Tricks-Cookbook-HowTo-HowtoExtendanexistingcomponentincustomizedapplication? ). On Thu, May 23, 2013 at 9:25 AM, Paul Foxworthy p...@cohsoft.com.au wrote: Hi Robert, I agree with the others that your UI is your UI and it's fine to copy it and make the changes you need for your own situation. It's harder with OFBiz services. You might make a change that with a bit of refinement may one day become a submission. But for now you decide to keep to yourself, perhaps to test it. You might have customizations that you know would not be relevant to the OFBiz community in general. You might base your work on a release of OFBiz, and cherry-pick fixes that are going into trunk. One day you might move to a later release, and the cherry-picked changes won't be needed any more. In short, you might branch with some prospect of merging at some stage in the future. In these situations, you want a clear separation between core OFBiz and your own changes, so you can move to a different core in future and integrate your changes. I suspect you understand all of that perfectly well, thus your caution about changing OFBiz code. We use Mercurial patch queues (MQ) to handle this. We start with core OFBiz, and we make our own changes in hot-deploy when we need and want to. Anything that is our own mod of core OFBiz is done as a patch in a patch queue. We have several guards so we can apply different sequences of patches. We have guards for submitted patches, for pending submissions, and others for customizations that are for a specific customer. MQ is working well for us and if you want to manage these issues I suggest you give it a try. See http://mercurial.selenic.com/wiki/MqExtension for more. Cheers Paul Foxworthy Ruth Hoffman-2 wrote Hi Robert: Having worked on many OFBiz based ecommerce applications (both large and small), I agree with Paul. Copy over and use the OOTB webapp as a guide to move forward with your own customizations. Best of luck. Ruth Hoffman On 5/22/13 4:08 PM, Paul Piper wrote: Hi Robert, that really depends on what you are set out to do. In general, I recommend to copy the eCommerce app over to hot-deploy and get the module to run from there. Then check it into your local repository to keep it consistent. With SVN you can use svn:external for instance to include your own module while keeping the rest of ofbiz consistent with the svn trunk. Then you can do your own changes and commit to your local repository at any time. Does that help or were you looking for something else? Regards, Paul P.S.: I don't think that Nick understood your question - BigFish certainly isn't the answer -- View this message in context: http://ofbiz.135035.n4.nabble.com/New-to-OFBiz-How-to-modify-the-eCommerce-app-tp4641469p4641473.html Sent from the OFBiz - User mailing list archive at Nabble.com. - -- Coherent Software Australia Pty Ltd http://www.coherentsoftware.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ -- View this message in context: http://ofbiz.135035.n4.nabble.com/New-to-OFBiz-How-to-modify-the-eCommerce-app-tp4641469p4641484.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Pack Backordered quantity
Could be possible that newly created inventory was reserved for another order, did you check detail screen for newly received item? What's the OFBiz version you're using? On Thu, May 23, 2013 at 6:59 PM, jyoti jyoti.sha...@viithiisys.com wrote: When inventory is received for a product, then at that time it should be checked if there is any reservation against that product. So, reservation should be moved to the newly created inventory. Is it a bug in ofbiz? Thanks, Jyoti -- View this message in context: http://ofbiz.135035.n4.nabble.com/Pack-Backordered-quantity-tp4641447p4641511.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Selecting distinct columns
Has anyone got something similar working in MySQL (with entity engine)? On Sat, Apr 13, 2013 at 6:53 AM, Varun Bhansaly vbhans...@gmail.com wrote: A correction on the last portion - I'm using OFBiz trunk and using delegator.find(...) and NOT using delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. On Fri, Apr 12, 2013 at 5:40 PM, Varun Bhansaly vbhans...@gmail.comwrote: What is the best way of formulating a query which attempts to select two distinct columns - For example, the desired query is - SELECT DISTINCT PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID FROM PRODUCT_FEATURE PF The closest which can be achieved is SELECT DISTINCT (PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID) FROM PRODUCT_FEATURE PF this generated query is not acceptable in MySQL but works fine in PostgreSQL and its generated with this view definition - view-entity entity-name=ProductFeatureView package-name=mypackage member-entity entity-alias=PF entity-name=ProductFeature/ alias name=productFeatureTypeAndCategory entity-alias=PF complex-alias operator=, complex-alias-field entity-alias=PF field=productFeatureTypeId/ complex-alias-field entity-alias=PF field=productFeatureCategoryId/ /complex-alias /alias /view-entity I'm using OFBiz trunk and using delegator.find(...) and delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. Thanks, -- View this message in context: http://ofbiz.135035.n4.nabble.com/Selecting-distinct-columns-tp4640610.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Selecting distinct columns
Thanks, however this example won't help as it 'selects' only 1 column
(UtilMisc.toSet(brandName)), the requirement is to be able to write
something like this (UtilMisc.toSet(brandName, productName)).
Also (may be I forgot to mention earlier) the need is to be able to get
count of distinct values, hence instead of using delegator.findList(...)
won't be optimal, would instead prefer
delegator.find(...).getResultsSizeAfterPartialList()
OR delegator.findCountByCondition(...)
On Sun, Apr 14, 2013 at 10:38 PM, S K Pradeep Kumar
s.k.pradeepku...@gmail.com wrote:
Here is one example
conditions = FastList.newInstance();
conditions.add(EntityCondition.makeCondition(productCategoryId,
EntityOperator.IN, categoryIds));
if (parameters.filter) {
conditions.add(EntityCondition.makeCondition(brandName,
EntityOperator.LIKE, parameters.filter + %));
}
conditions.add(EntityCondition.makeConditionDate(fromDate, thruDate));
findOptions = new EntityFindOptions();
findOptions.setDistinct(true);
brandRows = delegator.findList(ProductAndCategoryMember,
EntityCondition.makeCondition(conditions, EntityOperator.AND),
UtilMisc.toSet(brandName), UtilMisc.toList(brandName), findOptions,
true);
With regards,
S K Pradeep Kumar,
9035009495
On Sun, Apr 14, 2013 at 8:53 PM, Varun Bhansaly vbhans...@gmail.com
wrote:
Has anyone got something similar working in MySQL (with entity engine)?
On Sat, Apr 13, 2013 at 6:53 AM, Varun Bhansaly vbhans...@gmail.com
wrote:
A correction on the last portion - I'm using OFBiz trunk and using
delegator.find(...) and
NOT using delegator.findCountByCondition(...) because the latter does
not
allow supplying columns to be selected.
On Fri, Apr 12, 2013 at 5:40 PM, Varun Bhansaly vbhans...@gmail.com
wrote:
What is the best way of formulating a query which attempts to select
two
distinct columns -
For example, the desired query is -
SELECT DISTINCT PF.PRODUCT_FEATURE_TYPE_ID,
PF.PRODUCT_FEATURE_CATEGORY_ID
FROM PRODUCT_FEATURE PF
The closest which can be achieved is
SELECT DISTINCT (PF.PRODUCT_FEATURE_TYPE_ID,
PF.PRODUCT_FEATURE_CATEGORY_ID)
FROM PRODUCT_FEATURE PF
this generated query is not acceptable in MySQL but works fine in
PostgreSQL
and its generated with this view definition -
view-entity entity-name=ProductFeatureView
package-name=mypackage
member-entity entity-alias=PF
entity-name=ProductFeature/
alias name=productFeatureTypeAndCategory entity-alias=PF
complex-alias operator=,
complex-alias-field entity-alias=PF
field=productFeatureTypeId/
complex-alias-field entity-alias=PF
field=productFeatureCategoryId/
/complex-alias
/alias
/view-entity
I'm using OFBiz trunk and using delegator.find(...) and
delegator.findCountByCondition(...) because the latter does not allow
supplying columns to be selected.
Thanks,
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Selecting-distinct-columns-tp4640610.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
--
Regards,
Varun Bhansaly
--
Regards,
Varun Bhansaly
--
Regards,
Varun Bhansaly
Selecting distinct columns
What is the best way of formulating a query which attempts to select two distinct columns - For example, the desired query is - SELECT DISTINCT PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID FROM PRODUCT_FEATURE PF The closest which can be achieved is SELECT DISTINCT (PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID) FROM PRODUCT_FEATURE PF this generated query is not acceptable in MySQL but works fine in PostgreSQL and its generated with this view definition - view-entity entity-name=ProductFeatureView package-name=mypackage member-entity entity-alias=PF entity-name=ProductFeature/ alias name=productFeatureTypeAndCategory entity-alias=PF complex-alias operator=, complex-alias-field entity-alias=PF field=productFeatureTypeId/ complex-alias-field entity-alias=PF field=productFeatureCategoryId/ /complex-alias /alias /view-entity I'm using OFBiz trunk and using delegator.find(...) and delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. Thanks, -- View this message in context: http://ofbiz.135035.n4.nabble.com/Selecting-distinct-columns-tp4640610.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Selecting distinct columns
A correction on the last portion - I'm using OFBiz trunk and using delegator.find(...) and NOT using delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. On Fri, Apr 12, 2013 at 5:40 PM, Varun Bhansaly vbhans...@gmail.com wrote: What is the best way of formulating a query which attempts to select two distinct columns - For example, the desired query is - SELECT DISTINCT PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID FROM PRODUCT_FEATURE PF The closest which can be achieved is SELECT DISTINCT (PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID) FROM PRODUCT_FEATURE PF this generated query is not acceptable in MySQL but works fine in PostgreSQL and its generated with this view definition - view-entity entity-name=ProductFeatureView package-name=mypackage member-entity entity-alias=PF entity-name=ProductFeature/ alias name=productFeatureTypeAndCategory entity-alias=PF complex-alias operator=, complex-alias-field entity-alias=PF field=productFeatureTypeId/ complex-alias-field entity-alias=PF field=productFeatureCategoryId/ /complex-alias /alias /view-entity I'm using OFBiz trunk and using delegator.find(...) and delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. Thanks, -- View this message in context: http://ofbiz.135035.n4.nabble.com/Selecting-distinct-columns-tp4640610.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Ofbiz process gets killed abruptly without any clue
What is the h/w configuration of the box on which OFBiz and DB are hosted ? What is the size of the database ? Have you tried analyzing the JVM crash log files generated after the crash ? Have you tried any of the memory profiling tools ? On Wed, Jan 30, 2013 at 1:22 AM, Deepak Agarwal dagarwa...@gmail.com wrote: It's 100% consistent, tried from different hardwares. Everytime I reserve inventory for a product the jvm gets killed without any trace. On Tue, Jan 29, 2013 at 2:46 PM, Deepak Agarwal dagarwa...@gmail.comwrote: Hi All, We have been running our store with following parameter for last 10 months: - requireInventory N - reserver inventory Y - balance inventory Y - check inventory Y Now, suddenly ofbiz process is getting killed while reserving the inventory. There is no foot steps , it simply just gets killed. We have disabled this option but while packing we do require an inventory reserved else we can't pack. Any suggestions? -- Thanks, Deepak Agarwal, Mobile: +91 9501190044 -- Thanks, Deepak Agarwal, Mobile: +91 9501190044 -- Regards, Varun Bhansaly
Re: fees for payment methods / types
On Mon, Jan 21, 2013 at 4:47 AM, Robert G. g...@mercon24.de wrote: Hey Varun, thanks for your reply. Ah you mean the surcharge, which I can add within the shippment.properties (or a similar name, have it not in my mind now). - Yes and that's shipment.properties your statement: May be you would want to apply COD surcharge to shipping estimates and present it to the customer beforehand or may be give an indication that COD surcharge may apply. does it mean, that it is allready there, that I can show it to the customer beforehand? Or is that not implemented yet? - Its better to show rates (inclusive of COD surcharge) being charged beforehand. Neither of the above is available OOTB. Another easy way would be to add a shipping method named COD, where I can define the costs, but in fact COD is a payment method. - I'm not sure if it will a good idea to define a new shipping method named COD. In general it is also interesting to apply fees for different payment methods in case that I want to let the customer pay my Paypal fees, but this is not ootb, right? - Not sure if such a thing is available OOTB. -- View this message in context: http://ofbiz.135035.n4.nabble.com/fees-for-payment-methods-types-tp4639041p4639075.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: fees for payment methods / types
This is in all likelihood not available OOTB will require custom development.
Re: fees for payment methods / types
There's actually an implementation on adding COD surcharge while confirming shipments with UPS, you can have a look at that and see if that suits your requirements. May be you would want to apply COD surcharge to shipping estimates and present it to the customer beforehand or may be give an indication that COD surcharge may apply. On Sun, Jan 20, 2013 at 8:18 AM, Varun Bhansaly vbhans...@gmail.com wrote: This is in all likelihood not available OOTB will require custom development. -- Regards, Varun Bhansaly
Re: Run service at ofbiz startup
You can try configuring start-up services in framework/service/config/serviceengine.xml. See http://svn.apache.org/repos/asf/ofbiz/trunk/framework/service/config/serviceengine.xml On Wed, Aug 22, 2012 at 9:40 AM, ian tabangay itaban...@gmail.com wrote: Hi. Is it possible to run a service in ofbiz everytime it starts up? Thanks! Ian Tabangay -- Regards, Varun Bhansaly
Owner gets changed for serialized inventory item
Hi, I have noticed something strange happening while completing orders with products having serialized inventory and wanted to confirm if this is the expected behavior. After having completed the order, serialized inventory item's owner party gets changed to the Id of the order's customer party Id. This however does not happen for non-serialized inventory i.e. owner party Id does not get changed. This occurs with latest OFBiz trunk as well slightly customized instance of OFBiz 10.04. Any inputs will be highly appreciated. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Owner-gets-changed-for-serialized-inventory-item-tp4635220.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Multiple Instances of Ofbiz - Same server
At the very basic these will have to be changed - It works for me in v10.04 ADMIN_PORT - startofbiz.sh ADMIN_PORT - stopofbiz.sh jndi port - framework/base/config/jndi.properties ajp port - framework/base/config/ofbiz-containers.xml http port - framework/base/config/ofbiz-containers.xml https port - framework/base/config/ofbiz-containers.xml beanshell terminal port - framework/base/config/ofbiz-containers.xml naming - framework/base/config/ofbiz-containers.xml rmi - framework/base/config/ofbiz-containers.xml http port - framework/webapp/config/url.properties https ports - framework/webapp/config/url.properties This https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-Widgetssetting should help as well. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Multiple-Instances-of-Ofbiz-Same-server-tp4634724p4634725.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Doubts
A restart is not required for changes made to *UiLabels.xml, *services*.xml, and *secas*.xml files. Just clear the cache from Webtools and changes in these should be picked up by the system. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Doubts-tp4634684p4634728.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Doubts
This is what I quickly tried on my local v10.04 code base. Edited applications/accounting/servicedef/secas_invoice.xml, before edit it had two ecas defined on cancelInvoice : revertAcctgTransOnCancelInvoice and removeInvoiceItemAssocOnCancelInvoice. Changed them to revertAcctgTransOnCancelInvoice1 and removeInvoiceItemAssocOnCancelInvoice2. Did a cache clear and used webtool's service reference, it now shows the modified services names. Regarding service definition, I copied the definition of createPartyAcctgPreference and created a new one named createPartyAcctgPreferenceXYZ. Did a cache clear and used webtool's service reference, it now shows new service named createPartyAcctgPreferenceXYZ. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Doubts-tp4634684p4634741.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Regarding ProductGeo entity
Hi Jacopo, I can work on a patch for this once we can freeze the - 1. Entity 2. UI - meaning should productGeoEnumId remain editable ? 3. Upgrade path for existing systems. On Jul 2, 2012 3:56 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Yes, I see what I mean and without looking at the data model I suspect that you are right and that the productGeoEnumId should be part of the primary key; the primary key should actually also contain a fromDate field. Regards, Jacopo On Jul 2, 2012, at 10:22 AM, varun bhansaly wrote: Hi Jacopo, Thanks for your response, please find the explanation below - For product GZ-1001, I would like to setup this configuration - ProductGeo productId=GZ-1001 geoId=IND productGeoEnumId=PG_PURCH_INCLUDE / ProductGeo productId=GZ-1001 geoId=IND productGeoEnumId=PG_SHIP_INCLUDE / When I try to create these from Product Geo, then while trying to setup the second configuration, the UI crashes, with the following exception - Exception thrown while creating the newEntity GenericValue: Error while inserting: [GenericEntity:ProductGeo][createdStamp,2012-07-02 09:13:34.138(java.sql.Timestamp)][createdTxStamp,2012-07-02 09:13:34.111(java.sql.Timestamp)][description,null()][geoId,IND(java.lang.String)][lastUpdatedStamp,2012-07-02 09:13:34.138(java.sql.Timestamp)][lastUpdatedTxStamp,2012-07-02 09:13:34.111(java.sql.Timestamp)][productGeoEnumId,PG_PURCH_INCLUDE(java.lang.String)][productId,GZ-1001(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_GEO (PRODUCT_ID, GEO_ID, PRODUCT_GEO_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL120702063321810' defined on 'PRODUCT_GEO'.)) This prevents me from stating that the product can only be sold to Indian (billing and shipping) addresses. On Mon, Jul 2, 2012 at 12:50 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Hi Varun, could you please better elaborate (possibly with an example of xml data) the issue that you are having? Jacopo On Jul 2, 2012, at 8:29 AM, varun bhansaly wrote: Hi, Anybody having any idea why entity ProductGeo has primary key combination - ProductId + GeoId, such primary key combination prevents configuration like - Product Purchase Include Geo to India and Product Shipment Include Geo to India. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Regarding ProductGeo entity
Hi, Anybody having any idea why entity ProductGeo has primary key combination - ProductId + GeoId, such primary key combination prevents configuration like - Product Purchase Include Geo to India and Product Shipment Include Geo to India. -- Regards, Varun Bhansaly
Re: Regarding ProductGeo entity
Hi Jacopo, Thanks for your response, please find the explanation below - For product GZ-1001, I would like to setup this configuration - ProductGeo productId=GZ-1001 geoId=IND productGeoEnumId=PG_PURCH_INCLUDE / ProductGeo productId=GZ-1001 geoId=IND productGeoEnumId=PG_SHIP_INCLUDE / When I try to create these from Product Geo, then while trying to setup the second configuration, the UI crashes, with the following exception - Exception thrown while creating the newEntity GenericValue: Error while inserting: [GenericEntity:ProductGeo][createdStamp,2012-07-02 09:13:34.138(java.sql.Timestamp)][createdTxStamp,2012-07-02 09:13:34.111(java.sql.Timestamp)][description,null()][geoId,IND(java.lang.String)][lastUpdatedStamp,2012-07-02 09:13:34.138(java.sql.Timestamp)][lastUpdatedTxStamp,2012-07-02 09:13:34.111(java.sql.Timestamp)][productGeoEnumId,PG_PURCH_INCLUDE(java.lang.String)][productId,GZ-1001(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_GEO (PRODUCT_ID, GEO_ID, PRODUCT_GEO_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL120702063321810' defined on 'PRODUCT_GEO'.)) This prevents me from stating that the product can only be sold to Indian (billing and shipping) addresses. On Mon, Jul 2, 2012 at 12:50 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Hi Varun, could you please better elaborate (possibly with an example of xml data) the issue that you are having? Jacopo On Jul 2, 2012, at 8:29 AM, varun bhansaly wrote: Hi, Anybody having any idea why entity ProductGeo has primary key combination - ProductId + GeoId, such primary key combination prevents configuration like - Product Purchase Include Geo to India and Product Shipment Include Geo to India. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Has anyone implemented Faceted Search using SOLR?
Hi Deepak, The keyword TYPE was deprecated in earlier version of MySQL and is non-existent in the version you are using. To get across this, you can, Edit ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java in eclipse and replace sqlBuf.append( TYPE ) with sqlBuf.append( ENGINE ) Compile OFBiz try to install again. On Sun, Jun 24, 2012 at 2:12 AM, Deepak Agarwal dagarwa...@gmail.comwrote: ant run-install-seed throws following . my mysql version is 5.5.16. Could you quickly tell me if this is a known issue. [java] 2012-06-24 02:09:35,132 (main) [ DatabaseUtil.java:352:ERROR] Could not create table [WORK_EFFORT_TYPE_ATTR]: SQL Exception while executing th e following: [java] CREATE TABLE WORK_EFFORT_TYPE_ATTR (WORK_EFFORT_TYPE_ID VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, ATTR_NAME VARCHAR(60) C HARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, LAST_UPDATED_STAMP DATET IME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DA TETIME, CONSTRAINT PK_WORK_EFFORT_TYPE_ATTR PRIMARY KEY (WORK_EFFORT_TYPE_ID, AT TR_NAME)) TYPE InnoDB CHARACTER SET latin1 COLLATE latin1_general_cs [java] Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : You have an error in your SQL syntax; check the manual that corresponds to you r MySQL server version for the right syntax to use near 'TYPE InnoDB CHARACTER S ET latin1 COLLATE latin1_general_cs' at line 1 On Sun, Jun 24, 2012 at 1:27 AM, Nick Rosser nros...@salmonllc.com wrote: Yes it's free to use. Apache license. The intent is to totally integrate with ofbiz so any order placed via the bigfish ecommerce ui can be fufilled in the backend ofbiz. We are working with a client currently that will use a bigfish ecomm solution and run thru an erp solution we built for them some time ago. More news next week, we have a release ready. And we'll get solr working for sanjeev! Nick C: 516.901.1720 nros...@salmonllc.com On Jun 23, 2012, at 3:33 PM, Mike mz4whee...@gmail.com wrote: It's not my project. It's Nicks with salmonllc.com. I believe it has an Apache 2.0 license, so it is free it use. Maybe Nick can clarify. I'm still evaluating it, but so far very impressed. It appears to fully integrate with OFBiz's back-end as well. On Sat, Jun 23, 2012 at 12:24 PM, Deepak Agarwal dagarwa...@gmail.com wrote: Mike, I checked your admin panel. Amazing... great work I must say. Is it free to use. Can I move just switch to it without any hassle of configurations ? On Sat, Jun 23, 2012 at 5:12 AM, Mike mz4whee...@gmail.com wrote: You can check out BigFish: http://bigfish.salmonllc.com http://bigfish.salmonllc.com/**bfDownload.html http://bigfish.salmonllc.com/bfDownload.html It's an awesome OFBiz ecommerce frontend (and simplified backend) that has SOLR built-in. Nick Rosser and his team of experts at sammonllc.comhave put together a great set of features that is nothing short of amazing. I'm sold on it [grin]. You can always download it and checkout how they integrated SOLR. On Thu, Jun 21, 2012 at 11:40 AM, Sanjeev Gupta subscr...@sanjeevg.com wrote: Hi Rajbir, I spent a couple of days trying to play around with the approach you recommended but couldn't get it to work for me. So finally gave it up. Will probably wait for someone to contribute the feature to the trunk. - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message in context: http://ofbiz.135035.n4.nabble.**com/Has-anyone-implemented-** Faceted-Search-using-SOLR-**tp4633260p4633892.html http://ofbiz.135035.n4.nabble.com/Has-anyone-implemented-Faceted-Search-using-SOLR-tp4633260p4633892.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks, Deepak Agarwal, Paxcel Technologies Pvt Ltd. Hartron Complex, Sector 18, Gurgaon, India. E-Mail: deepak.agar...@paxcel.net Mobile: +91 9910322604 -- Thanks, Deepak Agarwal, Paxcel Technologies Pvt Ltd. Hartron Complex, Sector 18, Gurgaon, India. E-Mail: deepak.agar...@paxcel.net Mobile: +91 9910322604 %2B91%209910322604 -- Regards, Varun Bhansaly
Re: Ofbiz - order fulfilment and shipments
Have you configured Company's accounting preference ? See for reference
https://demo-trunk.ofbiz.apache.org:8443/accounting/control/AdminMain?organizationPartyId=Company
On Sun, Jun 10, 2012 at 11:47 PM, arihant jain onlyforsadh...@gmail.comwrote:
when i try to quick ship entire order or pack, I get the following
exception. any ideas?
The Following Errors Occurred:
ERROR: Could not complete the Issue OrderItemShipGrpInvRes to Shipment
[file:/D:/prolab/Source/trunk/ofbiz-11.04/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment]
process [problem removing the orderItemShipGrpInvRes value: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Error in
simple-method [Create an accounting transactions for a sales shipment
issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT)
[file:/D:/prolab/Source/trunk/ofbiz-11.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]:
; {COGS costing method is not supported: }]
On Sun, Jun 10, 2012 at 8:12 PM, Deepika1 S deepika...@tcs.com wrote:
Hi Sumit,
The tracking code the view order list is applicable when entire order has
a single shipment id and then it can have a tracking no. Suppose we pack
the line items separately and we have got 3 shipment id's then it might
happen that 3 different tracking no. might arise, then which tracking no.
to display in the view order list tracking code section?
Regards,
Deepika Sahu
-Sumit Pandit meetsumit...@gmail.com wrote: -
To: user@ofbiz.apache.org
From: Sumit Pandit meetsumit...@gmail.com
Date: 06/10/2012 07:03PM
Subject: Re: Ofbiz - order fulfilment and shipments
Hello Arihant,
Tracking number is associated with Shipment.
You have to first approve your order, then click on Quick Ship Entire
order
link(or pack your order). It will generate a shipment number for order.
Click on shipment id, it will navigate you to shipment detail page. Click
on route segment tab. Here you can enter tracking number to shipment.
On Thu, Jun 7, 2012 at 8:00 PM, arihant jain onlyforsadh...@gmail.com
wrote:
Hi,
I am new to ofbiz and have been able to create sales order. There is a
fair
bit of functionality around shipment(s) which is overwhelming me. I
just
need to be able to enter a tracking number for the fedex shipment which
will be sent to the customer against the sales order. And hopefully
that
completes the order process. Can some one point me to what menu item /
option to be used? Also I intend to use ofbiz for pure order
management /
tracking and not for accounting purposes. i.e. I will not generate
invoices
thru ofbiz or use ofbiz for manage accounts. Do I need to do something
special to enable that?
Thanks
-A
--
Thanks and Regards
Sumit Pandit
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
--
Regards,
Varun Bhansaly
Re: Ofbiz - order fulfilment and shipments
Either you can try after doing *Company configuration* OR you can follow
this tip -
https://cwiki.apache.org/OFBIZ/faq-tips-tricks-cookbook-howto.html#FAQ-Tips-Tricks-Cookbook-HowTo-IssuewithcreateAcctgTransAndEntriesserviceand
see if it works in this case.
On Mon, Jun 11, 2012 at 10:21 AM, arihant jain onlyforsadh...@gmail.comwrote:
Thanks Varun. Like I mentioned in a previous mail, I do not intend to use
the system for accounting. I want to use it purely for order and inventory
management. In that context, is it easy to 'turn off' the accounting
aspects related to order management?
On Mon, Jun 11, 2012 at 5:55 AM, varun bhansaly vbhans...@gmail.com
wrote:
Have you configured Company's accounting preference ? See for reference
https://demo-trunk.ofbiz.apache.org:8443/accounting/control/AdminMain?organizationPartyId=Company
On Sun, Jun 10, 2012 at 11:47 PM, arihant jain onlyforsadh...@gmail.com
wrote:
when i try to quick ship entire order or pack, I get the following
exception. any ideas?
The Following Errors Occurred:
ERROR: Could not complete the Issue OrderItemShipGrpInvRes to Shipment
[file:/D:/prolab/Source/trunk/ofbiz-11.04/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment]
process [problem removing the orderItemShipGrpInvRes value: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Error in
simple-method [Create an accounting transactions for a sales shipment
issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT)
[file:/D:/prolab/Source/trunk/ofbiz-11.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]:
; {COGS costing method is not supported: }]
On Sun, Jun 10, 2012 at 8:12 PM, Deepika1 S deepika...@tcs.com
wrote:
Hi Sumit,
The tracking code the view order list is applicable when entire order
has
a single shipment id and then it can have a tracking no. Suppose we
pack
the line items separately and we have got 3 shipment id's then it
might
happen that 3 different tracking no. might arise, then which tracking
no.
to display in the view order list tracking code section?
Regards,
Deepika Sahu
-Sumit Pandit meetsumit...@gmail.com wrote: -
To: user@ofbiz.apache.org
From: Sumit Pandit meetsumit...@gmail.com
Date: 06/10/2012 07:03PM
Subject: Re: Ofbiz - order fulfilment and shipments
Hello Arihant,
Tracking number is associated with Shipment.
You have to first approve your order, then click on Quick Ship Entire
order
link(or pack your order). It will generate a shipment number for
order.
Click on shipment id, it will navigate you to shipment detail page.
Click
on route segment tab. Here you can enter tracking number to shipment.
On Thu, Jun 7, 2012 at 8:00 PM, arihant jain
onlyforsadh...@gmail.com
wrote:
Hi,
I am new to ofbiz and have been able to create sales order. There
is
a
fair
bit of functionality around shipment(s) which is overwhelming me. I
just
need to be able to enter a tracking number for the fedex shipment
which
will be sent to the customer against the sales order. And hopefully
that
completes the order process. Can some one point me to what menu
item
/
option to be used? Also I intend to use ofbiz for pure order
management /
tracking and not for accounting purposes. i.e. I will not generate
invoices
thru ofbiz or use ofbiz for manage accounts. Do I need to do
something
special to enable that?
Thanks
-A
--
Thanks and Regards
Sumit Pandit
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
--
Regards,
Varun Bhansaly
--
Regards,
Varun Bhansaly
Re: Federated Table - MySql5.5
You can try this https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-ExternalDatabase On Thu, Jun 7, 2012 at 11:52 AM, pankaj pankaj.kuma...@gmail.com wrote: Dear All, Can we create Federated Table with MySql Database. Actually the requirement is I want to access one table which resides in another system. We tested with MySql Database which worked fine but how to do with Ofbiz. Please find below link for same given by MySql. http://dev.mysql.com/doc/refman/5.5/en/federated-description.html With Regards, Pankaj -- View this message in context: http://ofbiz.135035.n4.nabble.com/Federated-Table-MySql5-5-tp4633311.html Sent from the OFBiz - Dev mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
How to reverse engineer an application feature
Hi Everybody, Figured out this good way of reverse engineering/ dissecting application specific features, thought it would be good to share. Suppose for a particular feature there is a need to figure out all what all entities are affected. We can simply do the action on the application's UI, thereafter use Web Tools Import / Export XML Data Export to export all entities which were updated after a particular time by specifying a value in Records Updated Since field: its value could be action time + 10 seconds. Some of the exported entities like JobSandbox, RuntimeData, ServerHit etc. may be ignored. For more accurate results, this should be tried on systems which no one is else is simultaneously accessing. -- Regards, Varun Bhansaly
Re: Form widgets and entities
Application UI is built using the decorator pattern, you can try this specific step https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide#OFBizTutorial-ABeginnersDevelopmentGuide-CreatemainDecoratorfordecoratingthisapplication Even doing a View page source of the screen reveals a lot about what OFBiz screens are used to implement the UI. Hope this helps. On Thu, Jun 7, 2012 at 8:17 PM, G.Ben g.benabdel...@gmail.com wrote: Thank you Dhiraj, Please how can I use existing CSS Themes included in Ofbiz in my application ? Rgds. G.Ben. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Form-widgets-and-entities-tp4633328p466.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: automatic
You can execute ant create-component to create basic directory structure for an OFBiz component with some files such as screens etc. On Wed, Jun 6, 2012 at 8:30 PM, G.Ben g.benabdel...@gmail.com wrote: Hello all , developping application from scratch, is there a way to genearete some xml files automatically ? ... or all screens, css, widgets , etc ... by hand ? Thank you for your help. Regards. G.Ben. -- View this message in context: http://ofbiz.135035.n4.nabble.com/automatic-tp4633291.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
ofbiz-10.04 - Unable to quick ship entire order due to accountingQuantityTotal = 0
Hi, Have been facing an issue related to inventory transfer between warehouses in ofbiz-10.04. Orders cannot be quick shipped if transferred inventory is reserved for the order. Analysis reveals error is thrown from service createAcctgTransForSalesShipmentIssuance, transferred inventory has accountingQuantityTotal = 0 While researching on the meaning of Accounting Quantity Total of inventory item, found this http://ofbiz.135035.n4.nabble.com/What-is-quot-Accounting-Quantity-Total-quot-of-inventory-item-td1693983.html This error can be replicated in https://demo-stable.ofbiz.apache.org/ordermgr If someone has faced this issue earlier or knows the solution please do share. -- Regards, Varun Bhansaly
Error compiling trunk
Have been facing issues related to trunk (at r1343711) compilation via ./ant (10.04 compiles with no errors) This is the error snippet - classes: [javac16] Compiling 3 source files to /home/varun.bhansaly/ofbiz/framework/base/build/classes [javac16] /home/varun.bhansaly/ofbiz/framework/base/src/org/ofbiz/base/util/template/FreeMarkerWorker.java:87: cannot find symbol [javac16] symbol : method setNullWildcards(boolean) [javac16] location: class freemarker.ext.beans.BeansWrapper [javac16] wrapper.setNullWildcards(true); [javac16]^ [javac16] 1 error BUILD FAILED /home/varun.bhansaly/ofbiz/build.xml:216: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/framework/build.xml:148: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/macros.xml:39: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/framework/base/build.xml:90: Compile failed; see the compiler error output for details. -- Regards, Varun Bhansaly
Re: Error compiling trunk
Yes, error remains. On Tue, May 29, 2012 at 7:00 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: Have you tried running ant clean? -Adrian On 5/29/2012 2:26 PM, varun bhansaly wrote: Have been facing issues related to trunk (at r1343711) compilation via ./ant (10.04 compiles with no errors) This is the error snippet - classes: [javac16] Compiling 3 source files to /home/varun.bhansaly/ofbiz/**framework/base/build/classes [javac16] /home/varun.bhansaly/ofbiz/**framework/base/src/org/ofbiz/** base/util/template/**FreeMarkerWorker.java:87: cannot find symbol [javac16] symbol : method setNullWildcards(boolean) [javac16] location: class freemarker.ext.beans.**BeansWrapper [javac16] wrapper.setNullWildcards(true)**; [javac16]^ [javac16] 1 error BUILD FAILED /home/varun.bhansaly/ofbiz/**build.xml:216: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/build.xml:148: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**macros.xml:39: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/base/build.xml:90: Compile failed; see the compiler error output for details. -- Regards, Varun Bhansaly
Re: Error compiling trunk
freemarker-2.3.19.jar already absent. freemarker-2.3.19-null-wildcards.jar already present. Error remains, am using Oracle JDK 1.6.0_26, not sure if that could be the issue. On Tue, May 29, 2012 at 7:43 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Please make sure you don't have the following file: framework/base/lib/freemarker-2.3.19.jar (delete it if you find it) and instead make sure you have: framework/base/lib/freemarker-2.3.19-null-wildcards.jar Jacopo On May 29, 2012, at 4:09 PM, varun bhansaly wrote: Yes, error remains. On Tue, May 29, 2012 at 7:00 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: Have you tried running ant clean? -Adrian On 5/29/2012 2:26 PM, varun bhansaly wrote: Have been facing issues related to trunk (at r1343711) compilation via ./ant (10.04 compiles with no errors) This is the error snippet - classes: [javac16] Compiling 3 source files to /home/varun.bhansaly/ofbiz/**framework/base/build/classes [javac16] /home/varun.bhansaly/ofbiz/**framework/base/src/org/ofbiz/** base/util/template/**FreeMarkerWorker.java:87: cannot find symbol [javac16] symbol : method setNullWildcards(boolean) [javac16] location: class freemarker.ext.beans.**BeansWrapper [javac16] wrapper.setNullWildcards(true)**; [javac16]^ [javac16] 1 error BUILD FAILED /home/varun.bhansaly/ofbiz/**build.xml:216: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/build.xml:148: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**macros.xml:39: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/base/build.xml:90: Compile failed; see the compiler error output for details. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: OFBIZ __ PostgreSQL
This FAQ https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database should help. Simply ignore *references changes related to MySQL*, instead execute postgres datasource configuration steps provided by Arun Kumar Batham. On Tue, May 29, 2012 at 7:13 PM, Arun Kumar Batham arun.bat...@hotwaxmedia.com wrote: Hello, Take back up of your derby database and import it into postgresql database after tis installation. For migrating from derby database to postgresql database open framework/entity/config/**entityengine.xml and do the following changes in datasource-name field: delegator name=default entity-model-reader=main entity-group-reader=main entity-eca-reader=main distributed-cache-clear- **enabled=false group-map group-name=org.ofbiz datasource-name=**localpostgres/ group-map group-name=org.ofbiz.olap datasource-name=**localpostgres/ /delegator delegator name=default-no-eca entity-model-reader=main entity-group-reader=main entity-eca-reader=main entity-eca-enabled=false distributed-cache-clear- enabled=false group-map group-name=org.ofbiz datasource-name=**localpostgres/ group-map group-name=org.ofbiz.olap datasource-name=**localpostgres/ group-map group-name=org.ofbiz.tenant datasource-name=** localderbytenant/ /delegator Enter jdbc-username and jdbc-password of postgres database here: datasource name=localpostgres helper-class=org.ofbiz.**entity.datasource.**GenericHelperDAO schema-name=public field-type-name=postgres check-on-start=true add-missing-on-start=true use-fk-initially-deferred=**false read-data reader-name=tenant/ read-data reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ inline-jdbc jdbc-driver=org.postgresql.**Driver jdbc-uri=jdbc:postgresql://12**7.0.0.1/trunkhttp://127.0.0.1/trunk jdbc-username=Your postgres Database User Name jdbc-password=Your postgres Database Password time-between-eviction-runs-**millis=60/ /datasource and then open the console, browse to ofbiz folder and run this command: ant download-PG-JDBC I think this information help you. Thank you. Regards Arun Kumar Batham HotWax Media, Est. 1997 http://www.hotwaxmedia.com/ On Tuesday 29 May 2012 06:41 PM, G.Ben wrote: Hi, I'm looking for some help about migrating from ofbiz derby database to postgresql database, and also how to create and set data directly from postgresql without having to pass by derby. According to tutorials that I have, I can't find how they get connected to another database (postgres in my case) and defining entities there, and keep developing the application. P.S : * I'm using Eclipse IDE * I'm just a beginner in ofbiz so I have just few knowledge about the OFBiz environement. Thank you for you help :) -- View this message in context: http://ofbiz.135035.n4.nabble.** com/OFBIZ-PostgreSQL-**tp4632713.htmlhttp://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Error compiling trunk
Yes, error remains. On Tue, May 29, 2012 at 8:15 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: please confirm that you get the error if you run: ./ant clean build Jacopo On May 29, 2012, at 4:20 PM, varun bhansaly wrote: freemarker-2.3.19.jar already absent. freemarker-2.3.19-null-wildcards.jar already present. Error remains, am using Oracle JDK 1.6.0_26, not sure if that could be the issue. On Tue, May 29, 2012 at 7:43 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Please make sure you don't have the following file: framework/base/lib/freemarker-2.3.19.jar (delete it if you find it) and instead make sure you have: framework/base/lib/freemarker-2.3.19-null-wildcards.jar Jacopo On May 29, 2012, at 4:09 PM, varun bhansaly wrote: Yes, error remains. On Tue, May 29, 2012 at 7:00 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: Have you tried running ant clean? -Adrian On 5/29/2012 2:26 PM, varun bhansaly wrote: Have been facing issues related to trunk (at r1343711) compilation via ./ant (10.04 compiles with no errors) This is the error snippet - classes: [javac16] Compiling 3 source files to /home/varun.bhansaly/ofbiz/**framework/base/build/classes [javac16] /home/varun.bhansaly/ofbiz/**framework/base/src/org/ofbiz/** base/util/template/**FreeMarkerWorker.java:87: cannot find symbol [javac16] symbol : method setNullWildcards(boolean) [javac16] location: class freemarker.ext.beans.**BeansWrapper [javac16] wrapper.setNullWildcards(true)**; [javac16]^ [javac16] 1 error BUILD FAILED /home/varun.bhansaly/ofbiz/**build.xml:216: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/build.xml:148: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**macros.xml:39: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/base/build.xml:90: Compile failed; see the compiler error output for details. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Error compiling trunk
It is solved now, did a svn st and found following ? framework/example ? framework/common/webcommon/WEB-INF/geolocation.ftl ? framework/birt/lib/platform ? framework/base/lib/freemarker-2.3.15.jar ? framework/base/lib/j2eespecs/tomcat-6.0.26-servlet-api.jar ? framework/base/lib/j2eespecs/tomcat-6.0.26-jsp-api.jar ? framework/base/lib/j2eespecs/tomcat-6.0.26-annotations-api.jar ? framework/base/lib/j2eespecs/tomcat-6.0.26-el-api.jar ? framework/base/lib/scripting/groovy-all-1.7.3.jar ? framework/base/lib/commons/commons-fileupload-1.2.jar ? framework/entity/lib/jdbc/mysql-connector-java-5.1.10-bin.jar ? framework/entity/lib/jdbc/postgresql-8.4-701.jdbc3.jar ? framework/catalina/lib/tomcat-6.0.26-tomcat-juli.jar ? framework/catalina/lib/tomcat-6.0.26-tomcat-juli-adapters.jar ? framework/catalina/lib/tomcat-6.0.26-tomcat-dbcp.jar ? framework/catalina/lib/tomcat-6.0.26-catalina-tribes.jar ? framework/catalina/lib/tomcat-6.0.26-catalina-ha.jar ? framework/catalina/lib/tomcat-6.0.26-jasper-jdt.jar ? framework/catalina/lib/tomcat-6.0.26-catalina.jar ? framework/catalina/lib/tomcat-6.0.26-jasper-el.jar ? framework/catalina/lib/tomcat-6.0.26-jasper.jar ? framework/catalina/lib/tomcat-6.0.26-tomcat-coyote.jar ? startofbiz.sh Not sure why they remained even after svn up, manually removed them compiled again with success. On Tue, May 29, 2012 at 8:23 PM, varun bhansaly vbhans...@gmail.com wrote: Yes, error remains. On Tue, May 29, 2012 at 8:15 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: please confirm that you get the error if you run: ./ant clean build Jacopo On May 29, 2012, at 4:20 PM, varun bhansaly wrote: freemarker-2.3.19.jar already absent. freemarker-2.3.19-null-wildcards.jar already present. Error remains, am using Oracle JDK 1.6.0_26, not sure if that could be the issue. On Tue, May 29, 2012 at 7:43 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Please make sure you don't have the following file: framework/base/lib/freemarker-2.3.19.jar (delete it if you find it) and instead make sure you have: framework/base/lib/freemarker-2.3.19-null-wildcards.jar Jacopo On May 29, 2012, at 4:09 PM, varun bhansaly wrote: Yes, error remains. On Tue, May 29, 2012 at 7:00 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: Have you tried running ant clean? -Adrian On 5/29/2012 2:26 PM, varun bhansaly wrote: Have been facing issues related to trunk (at r1343711) compilation via ./ant (10.04 compiles with no errors) This is the error snippet - classes: [javac16] Compiling 3 source files to /home/varun.bhansaly/ofbiz/**framework/base/build/classes [javac16] /home/varun.bhansaly/ofbiz/**framework/base/src/org/ofbiz/** base/util/template/**FreeMarkerWorker.java:87: cannot find symbol [javac16] symbol : method setNullWildcards(boolean) [javac16] location: class freemarker.ext.beans.**BeansWrapper [javac16] wrapper.setNullWildcards(true)**; [javac16]^ [javac16] 1 error BUILD FAILED /home/varun.bhansaly/ofbiz/**build.xml:216: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/build.xml:148: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**macros.xml:39: The following error occurred while executing this line: /home/varun.bhansaly/ofbiz/**framework/base/build.xml:90: Compile failed; see the compiler error output for details. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Order Sequence
If you are storing orders in the same entity OrderHeader, then you will have to take measures to prevent PK violations. On 5/18/12, Venkat Mangudi venkatmang...@gmail.com wrote: On Fri, May 18, 2012 at 1:27 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: You can override the createOrderHeader service with your own. Then use separate sequence names for POs and SOs. That is probably what I will be doing. Will create a flag and allow this to be configured. Once I am done, will send the diff to the dev list. -- Regards, Venkat -- Regards, Varun Bhansaly
Error upgrading from ofbiz-09.04 to 10.04
I have been facing issues in installing seed data while trying to upgrade
from ofbiz release09.04@978897 to release10.04@1137445
The error come up when system executes
applications/accounting/data/AccountingTypeData.xml
and especially while executing the seed snippet,
PaymentGatewayPayflowPro paymentGatewayConfigId=PAYFLOWPRO_CONFIG
certsPath=${sys:getProperty('ofbiz.home')}/applications/accounting/pfcerts
hostAddress=pilot-payflowpro.paypal.com hostPort=443 timeout=80
proxyAddress= proxyPort=80 proxyLogon= proxyPassword=
vendor=[Vendor] userId=[PayFlow UserID] pwd=[PayFlow
Password] partner=[PayFlow Partner] checkAvs=Y checkCvv2=Y
preAuth=Y enableTransmit=true
logFileName=${sys:getProperty('ofbiz.home')}/runtime/logs/payflow_java.log
loggingLevel=6 maxLogFileSize=100 stackTraceOn=N
returnUrl=[Express Checkout Return URL] cancelReturnUrl=[Express
Checkout Cancel Return URL] redirectUrl=[Express Checkout Customer
Redirect URL]/
Following exception is thrown
Exception: org.ofbiz.base.util.GeneralRuntimeException
Message: null (Odd number of characters.)
stack trace
---
org.ofbiz.base.util.GeneralRuntimeException: null (Odd number of
characters.)
org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:430)
org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:412)
org.apache.commons.codec.DecoderException: Odd number of characters.
org.apache.commons.codec.binary.Hex.decodeHex(Hex.java:69)
org.ofbiz.base.util.StringUtil.fromHexString(StringUtil.java:427)
org.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:86)
org.ofbiz.entity.GenericDelegator.decryptFields(GenericDelegator.java:3116)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1409)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:286)
org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:423)
javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337)
javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:262)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:222)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:214)
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:389)
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:273)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:412)
As per my observations, system is *unable to decrypt* text [PayFlow
Password]
If anyone has faced this issue before, please do share.
--
Regards,
Varun Bhansaly
Re: ofbiz 10.04 and lock wait time out exceptions
For now have increased value for innodb_lock_wait_timeout from 50 to 300. http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout On Thu, May 3, 2012 at 7:54 AM, varun bhansaly vbhans...@gmail.com wrote: Hi, I'm using ofbiz release10.04@1072382 with MySQL database server (with default settings). Of late I have been observing lots of 'lock wait time out' exceptions in the logs primarily while the system is trying to update entity OrderHeader. If anyone has any suggestions please do share. Below is the portion of the exception trace - 2012-05-01 18:51:34,865 [ERROR] SQL Exception while executing the following: UPDATE ORDER_HEADER SET ORDER_TYPE_ID=?, ORDER_NAME=?, EXTERNAL_ID=?, SALES_CHANNEL_ENUM_ID=?, ORDER_DATE=?, PRIORITY=?, ENTRY_DATE=?, PICK_SHEET_PRINTED_DATE=?, VISIT_ID=?, STATUS_ID=?, CREATED_BY=?, FIRST_ATTEMPT_ORDER_ID=?, CURRENCY_UOM=?, SYNC_STATUS_ID=?, BILLING_ACCOUNT_ID=?, ORIGIN_FACILITY_ID=?, WEB_SITE_ID=?, PRODUCT_STORE_ID=?, TERMINAL_ID=?, TRANSACTION_ID=?, AUTO_ORDER_SHOPPING_LIST_ID=?, NEEDS_INVENTORY_ISSUANCE=?, IS_RUSH_ORDER=?, INTERNAL_CODE=?, REMAINING_SUB_TOTAL=?, GRAND_TOTAL=?, IS_VIEWED=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE ORDER_ID=? 2012-05-01 18:51:34,867 [ERROR] Error while updating [GenericEntity:OrderHeader][autoOrderShoppingListId,null()][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][createdTxStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,72.00(java.math.BigDecimal)][internalCode,null()][isRushOrder,null()][isViewed,null()][lastUpdatedStamp,2012-05-01 18:50:43.297(java.sql.Timestamp)][lastUpdatedTxStamp,2012-05-01 18:50:42.078(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][orderId,SE11510(java.lang.String)][orderName,Test Order(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][pickSheetPrintedDate,null()][priority,2(java.lang.String)][productStoreId,9000(java.lang.String)][remainingSubTotal,72.00(java.math.BigDecimal)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,5171(java.lang.String)][webSiteId,OrderEntry(java.lang.String)] 2012-05-01 18:51:34,869 [ERROR] exception report -- Failure in store operation for entity [OrderHeader]: org.ofbiz.entity.GenericEntityException: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)) cause - Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception: (Lock wait timeout exceeded; try restarting transaction) cause - Exception: java.sql.SQLException Message: Lock wait timeout exceeded; try restarting transaction -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: ofbiz 10.04 and lock wait time out exceptions
This change does not help - still getting the same exceptions. On Thu, May 3, 2012 at 8:29 PM, varun bhansaly vbhans...@gmail.com wrote: For now have increased value for innodb_lock_wait_timeout from 50 to 300. http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout On Thu, May 3, 2012 at 7:54 AM, varun bhansaly vbhans...@gmail.comwrote: Hi, I'm using ofbiz release10.04@1072382 with MySQL database server (with default settings). Of late I have been observing lots of 'lock wait time out' exceptions in the logs primarily while the system is trying to update entity OrderHeader. If anyone has any suggestions please do share. Below is the portion of the exception trace - 2012-05-01 18:51:34,865 [ERROR] SQL Exception while executing the following: UPDATE ORDER_HEADER SET ORDER_TYPE_ID=?, ORDER_NAME=?, EXTERNAL_ID=?, SALES_CHANNEL_ENUM_ID=?, ORDER_DATE=?, PRIORITY=?, ENTRY_DATE=?, PICK_SHEET_PRINTED_DATE=?, VISIT_ID=?, STATUS_ID=?, CREATED_BY=?, FIRST_ATTEMPT_ORDER_ID=?, CURRENCY_UOM=?, SYNC_STATUS_ID=?, BILLING_ACCOUNT_ID=?, ORIGIN_FACILITY_ID=?, WEB_SITE_ID=?, PRODUCT_STORE_ID=?, TERMINAL_ID=?, TRANSACTION_ID=?, AUTO_ORDER_SHOPPING_LIST_ID=?, NEEDS_INVENTORY_ISSUANCE=?, IS_RUSH_ORDER=?, INTERNAL_CODE=?, REMAINING_SUB_TOTAL=?, GRAND_TOTAL=?, IS_VIEWED=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE ORDER_ID=? 2012-05-01 18:51:34,867 [ERROR] Error while updating [GenericEntity:OrderHeader][autoOrderShoppingListId,null()][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][createdTxStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,72.00(java.math.BigDecimal)][internalCode,null()][isRushOrder,null()][isViewed,null()][lastUpdatedStamp,2012-05-01 18:50:43.297(java.sql.Timestamp)][lastUpdatedTxStamp,2012-05-01 18:50:42.078(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][orderId,SE11510(java.lang.String)][orderName,Test Order(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][pickSheetPrintedDate,null()][priority,2(java.lang.String)][productStoreId,9000(java.lang.String)][remainingSubTotal,72.00(java.math.BigDecimal)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,5171(java.lang.String)][webSiteId,OrderEntry(java.lang.String)] 2012-05-01 18:51:34,869 [ERROR] exception report -- Failure in store operation for entity [OrderHeader]: org.ofbiz.entity.GenericEntityException: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)) cause - Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception: (Lock wait timeout exceeded; try restarting transaction) cause - Exception: java.sql.SQLException Message: Lock wait timeout exceeded; try restarting transaction -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
ofbiz 10.04 and lock wait time out exceptions
Hi, I'm using ofbiz release10.04@1072382 with MySQL database server (with default settings). Of late I have been observing lots of 'lock wait time out' exceptions in the logs primarily while the system is trying to update entity OrderHeader. If anyone has any suggestions please do share. Below is the portion of the exception trace - 2012-05-01 18:51:34,865 [ERROR] SQL Exception while executing the following: UPDATE ORDER_HEADER SET ORDER_TYPE_ID=?, ORDER_NAME=?, EXTERNAL_ID=?, SALES_CHANNEL_ENUM_ID=?, ORDER_DATE=?, PRIORITY=?, ENTRY_DATE=?, PICK_SHEET_PRINTED_DATE=?, VISIT_ID=?, STATUS_ID=?, CREATED_BY=?, FIRST_ATTEMPT_ORDER_ID=?, CURRENCY_UOM=?, SYNC_STATUS_ID=?, BILLING_ACCOUNT_ID=?, ORIGIN_FACILITY_ID=?, WEB_SITE_ID=?, PRODUCT_STORE_ID=?, TERMINAL_ID=?, TRANSACTION_ID=?, AUTO_ORDER_SHOPPING_LIST_ID=?, NEEDS_INVENTORY_ISSUANCE=?, IS_RUSH_ORDER=?, INTERNAL_CODE=?, REMAINING_SUB_TOTAL=?, GRAND_TOTAL=?, IS_VIEWED=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE ORDER_ID=? 2012-05-01 18:51:34,867 [ERROR] Error while updating [GenericEntity:OrderHeader][autoOrderShoppingListId,null()][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][createdTxStamp,2012-05-01 18:48:57.0(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,72.00(java.math.BigDecimal)][internalCode,null()][isRushOrder,null()][isViewed,null()][lastUpdatedStamp,2012-05-01 18:50:43.297(java.sql.Timestamp)][lastUpdatedTxStamp,2012-05-01 18:50:42.078(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2012-05-01 18:48:57.0(java.sql.Timestamp)][orderId,SE11510(java.lang.String)][orderName,Test Order(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][pickSheetPrintedDate,null()][priority,2(java.lang.String)][productStoreId,9000(java.lang.String)][remainingSubTotal,72.00(java.math.BigDecimal)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,5171(java.lang.String)][webSiteId,OrderEntry(java.lang.String)] 2012-05-01 18:51:34,869 [ERROR] exception report -- Failure in store operation for entity [OrderHeader]: org.ofbiz.entity.GenericEntityException: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while updating OrderHeader (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)) cause - Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception: (Lock wait timeout exceeded; try restarting transaction) cause - Exception: java.sql.SQLException Message: Lock wait timeout exceeded; try restarting transaction -- Regards, Varun Bhansaly
Re: different between service and event
Have a look at these - https://cwiki.apache.org/OFBIZ/faq-tips-tricks-cookbook-howto.html#FAQ-Tips-Tricks-Cookbook-HowTo-WhatisthedifferencebetweenEventandService%3F http://ofbiz.135035.n4.nabble.com/Best-practices-Event-vs-Service-td2306346.html On Sun, Feb 26, 2012 at 7:53 PM, Budianto Lie popo6...@gmail.com wrote: Hello, What's the difference between service and event ? When to used them? Thanks, popo -- Regards, Varun Bhansaly
Re: Hits
Yes, you can find this information in entity *ProductCalculatedInfo* On Tue, Jan 24, 2012 at 9:22 PM, Gavin Mabie gavin.ma...@urbannex.co.zawrote: Hi Is there a way in Ofbiz to check how many times a product has been viewed? Regards Gavin -- Regards, Varun Bhansaly
Re: Apply only one promotion per order
Hi David, I have a similar requirement where in two promotions have been setup on the store. The requirement is that if web store user uses Promotion 2, shipping discount should NOT be applied. Below are the details of the promotions - 1. Promotion 1 - If shipping method is UPS Ground give 100 % shipping discount (using action Shippin X % Discount). 2. Promotion 2 - This requires a promo code and makes a product available at a special price (using action Product for [Special Promo] Price) + no shipping discount should be given. To give an idea about how promotion 2 is setup, it has two rules - rule 1 - negates 100 % shipping discount if shipping method is UPS Ground rule 2 - product is available at a special price. So with this setup, what happens is - 1. If user chooses UPS Ground, shipping discount is negated, BUT product is available at default price. 2. If user chooses any other UPS method, shipping charges are applied, and product is available at special price. Could you please list down the steps you took to solve your scenario. If any one has any suggestions, please do post. On Tue, Sep 27, 2011 at 11:12 AM, David-DiSiD Technologies dcerv...@disid.com wrote: Thanks Deb, AFAIK, these limits affect to the current order, or current customer, or current promotion. I mean, they don't interact with other promotions currently applied, then they don't solve my problem. Anyways, I think I found the solution. I've to use the *promo rules*, and configure them taking in account the other promotions that can be applied and their own rules. It means that the promo admin has to know what are the promotions configured in system, their rules, their dates, etc. Thanks again - David DiSiD Technologies, S.L. - http://www.disid.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Apply-only-one-promotion-per-order-tp3844614p3846239.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Dealing with Freight forwarder
I am a business user who is using ofbiz to manage my business and serve my customers. My customer has been recorded as a party in the system and this person sends us the PO. We follow normal steps to create and process the order i.e. by using ofbiz order manager and to avoid shipping charges we use standard shipping $0.00. On Fri, Aug 19, 2011 at 11:28 AM, BJ Freeman bjf...@free-man.net wrote: Customer as in the one that has ofbiz or as one that enters orders into ofbiz? Please detail the steps starting with the first order that goes through ofbiz to the the items that get shipped to the customer that placed the original order. varun bhansaly sent the following on 8/18/2011 7:03 PM: The scenario I am trying to address - customer uses a freight forwarder resides in a country which does not fall under the jurisdiction of the configured tax authority. However, the freight forwarder resides in a Geo which falls under the jurisdiction of the configured tax authority, so if freight forwarder's address is used as shipping address for the order then taxes get applied. Also, the order should be connected to end customer as well. On Fri, Aug 19, 2011 at 12:01 AM, BJ Freeman bjf...@free-man.net wrote: There are many different levels of freight forwarders and how much interaction you let them have though the system. you can use DHL which pretty much they handle everything so everything is done as normal shipper. Most Freight forwarder would handled as a Facility/shipper. the next level is using a freight forwarder, where they do the packaging of your shipment on ofbiz. The accounting gets complimented. order wise the PO will specify the shipping address as the Freight forwarder then a second PO to the Freight forwarder and shows all the items they should expect to ship. varun bhansaly sent the following on 8/18/2011 9:44 AM: Has anyone modeled the concept of Freight forwarder used the it to process orders in ofbiz order manager ? Any suggestions or ideas on how to handle this ? -- Regards, Varun Bhansaly
Re: ofbiz integration with Paypal Website Payment Pro
Hi Suman, Were you able to get this working ? I had a similar requirement and had to apply some fixes myself. What I've noticed is that - the payflow pro API is able to receive the token and redirect to paypal, BUT the order details are NOT listed on the left hand side frame on paypal website. On Tue, Jul 19, 2011 at 4:33 PM, suman kar suman@gmail.com wrote: Hi, Has any one integrated ofbiz 10.04 with Website Payment Pro. I came across this link https://issues.apache.org/jira/browse/OFBIZ-934which use Payflow pro API. Though this works fine for credit card authorizations, it does NOT work for paypal express checkout. I have executed the XML from DemoProduct.xml. In general, has anyone used Payflow pro API for paypal express checkout ? If yes, what should be URL under the image for express checkout ? Thanks -- Regards, Varun Bhansaly
Re: multiple domains at the root location
Hi Hans, We've a similar requirement to host 2 websites and backend applications on a single instance of ofbiz-10.04 on EC2. The websites have to be mounted on mounted on root. We are ready with the first website, www.website1.com. Website1 will be accessible at www.website1.com backend applications will be accessible at ofbiz.mycompany.com We've configured the DNS settings and currently both these URLs point to the same IP address. We've applied virtual host settings in hot-deploy/website1/ofbiz-component.xml framework/images/ofbiz-component.xml We've also applied your changes from revision 1081692 Though theres a problem when we try to access ofbiz.mycompany.com, it redirects to www.website1.com If you have a tip, please let us know. On Tue, Mar 15, 2011 at 3:01 PM, Hans Bakker mailingl...@antwebsystems.comwrote: This function was already in OFbiz but it did not work anymore... fixed in revision 1081692. You can use multiple web-apps with the same mount-point however with different virtual-host host-name specs Regards, Hans On Tue, 2011-03-15 at 13:35 +0700, Hans Bakker wrote: perhaps some extra info, we are using the Amazon ec2 loadbalancer as frontend (decrypting ssl) and pass on directly to the ofbiz system. Raj already suggested to use apache for that, but apache is not there and we would like to do this directly in OFBiz. Regards, Hans On Tue, 2011-03-15 at 13:03 +0700, Hans Bakker wrote: May i have your opinion? We have the requirement to run several different ecommerce domainnames as a root application. I know we had a domain name in the webapp definition in ofbiz-component.xml, but that was removed at a certain point. Any suggestions how to implement this? Perhaps using the website entity? and using the webapp mount point internally? thanks in advance for your suggestions Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. -- Regards, Varun Bhansaly
Re: multiple domains at the root location
Hi Hans, Thanks for your response. I've made settings suggested by you in Store website http port and https port, it did not work. When I access ofbiz.mycompany.com, it still takes me to www.website1.com Also let me correct myself, when I try to access ofbiz.mycompany.com, ofbiz serves the same content as it serves for www.website1.com and NOT re-directs as mentioned earlier. On Fri, Jun 10, 2011 at 12:34 PM, Hans Bakker mailingl...@antwebsystems.com wrote: hi varun also make sure your domains are set in the related website entity: content - websites - select website - update http and https fields for others, the related blog is at: http://www.antwebsystems.com/control/ViewBlogArticle?contentId=18704blogContentId=AWS_BLOG Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. On Fri, 2011-06-10 at 12:23 +0530, varun bhansaly wrote: Hi Hans, We've a similar requirement to host 2 websites and backend applications on a single instance of ofbiz-10.04 on EC2. The websites have to be mounted on mounted on root. We are ready with the first website, www.website1.com. Website1 will be accessible at www.website1.com backend applications will be accessible at ofbiz.mycompany.com We've configured the DNS settings and currently both these URLs point to the same IP address. We've applied virtual host settings in hot-deploy/website1/ofbiz-component.xml framework/images/ofbiz-component.xml We've also applied your changes from revision 1081692 Though theres a problem when we try to access ofbiz.mycompany.com, it redirects to www.website1.com If you have a tip, please let us know. On Tue, Mar 15, 2011 at 3:01 PM, Hans Bakker mailingl...@antwebsystems.comwrote: This function was already in OFbiz but it did not work anymore... fixed in revision 1081692. You can use multiple web-apps with the same mount-point however with different virtual-host host-name specs Regards, Hans On Tue, 2011-03-15 at 13:35 +0700, Hans Bakker wrote: perhaps some extra info, we are using the Amazon ec2 loadbalancer as frontend (decrypting ssl) and pass on directly to the ofbiz system. Raj already suggested to use apache for that, but apache is not there and we would like to do this directly in OFBiz. Regards, Hans On Tue, 2011-03-15 at 13:03 +0700, Hans Bakker wrote: May i have your opinion? We have the requirement to run several different ecommerce domainnames as a root application. I know we had a domain name in the webapp definition in ofbiz-component.xml, but that was removed at a certain point. Any suggestions how to implement this? Perhaps using the website entity? and using the webapp mount point internally? thanks in advance for your suggestions Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. -- Regards, Varun Bhansaly
Re: multiple domains at the root location
All these settings work fine on our non EC2 environment (with ofbiz-10.04) but NOT in EC2 production. Anyways thanks for your help. On Fri, Jun 10, 2011 at 1:17 PM, Hans Bakker mailingl...@antwebsystems.comwrote: Can you please also try this on the trunk version? We got that working here Regards, Hans On Fri, 2011-06-10 at 12:47 +0530, varun bhansaly wrote: Hi Hans, Thanks for your response. I've made settings suggested by you in Store website http port and https port, it did not work. When I access ofbiz.mycompany.com, it still takes me to www.website1.com Also let me correct myself, when I try to access ofbiz.mycompany.com, ofbiz serves the same content as it serves for www.website1.com and NOT re-directs as mentioned earlier. On Fri, Jun 10, 2011 at 12:34 PM, Hans Bakker mailingl...@antwebsystems.com wrote: hi varun also make sure your domains are set in the related website entity: content - websites - select website - update http and https fields for others, the related blog is at: http://www.antwebsystems.com/control/ViewBlogArticle?contentId=18704blogContentId=AWS_BLOG Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. On Fri, 2011-06-10 at 12:23 +0530, varun bhansaly wrote: Hi Hans, We've a similar requirement to host 2 websites and backend applications on a single instance of ofbiz-10.04 on EC2. The websites have to be mounted on mounted on root. We are ready with the first website, www.website1.com. Website1 will be accessible at www.website1.com backend applications will be accessible at ofbiz.mycompany.com We've configured the DNS settings and currently both these URLs point to the same IP address. We've applied virtual host settings in hot-deploy/website1/ofbiz-component.xml framework/images/ofbiz-component.xml We've also applied your changes from revision 1081692 Though theres a problem when we try to access ofbiz.mycompany.com, it redirects to www.website1.com If you have a tip, please let us know. On Tue, Mar 15, 2011 at 3:01 PM, Hans Bakker mailingl...@antwebsystems.comwrote: This function was already in OFbiz but it did not work anymore... fixed in revision 1081692. You can use multiple web-apps with the same mount-point however with different virtual-host host-name specs Regards, Hans On Tue, 2011-03-15 at 13:35 +0700, Hans Bakker wrote: perhaps some extra info, we are using the Amazon ec2 loadbalancer as frontend (decrypting ssl) and pass on directly to the ofbiz system. Raj already suggested to use apache for that, but apache is not there and we would like to do this directly in OFBiz. Regards, Hans On Tue, 2011-03-15 at 13:03 +0700, Hans Bakker wrote: May i have your opinion? We have the requirement to run several different ecommerce domainnames as a root application. I know we had a domain name in the webapp definition in ofbiz-component.xml, but that was removed at a certain point. Any suggestions how to implement this? Perhaps using the website entity? and using the webapp mount point internally? thanks in advance for your suggestions Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. -- Regards, Varun Bhansaly
ofbiz paypal integration
Hi, Has anyone tried integrating paypal with ofbiz-10.04 ? I have made all the configurations using this https://cwiki.apache.org/OFBENDUSER/apache-ofbiz-business-setup-guide.html#ApacheOFBizBusinessSetupGuide-PayPalPaymentSetupas reference. For Return Url, I've specified http:// my-server:8080/control/payPalCheckoutReturn Paypal sandox successfully redirects to this return URL, and I can see the order information. But as soon as I click 'submit order', order is created but following error is displayed (seems related to payment authorization) Error in authOrderPayments service: org.ofbiz.service.GenericServiceException: Could not commit transaction for service [authOrderPayments] call: Roll back error, could not commit transaction, was rolled back instead because of: Error in Service [authOrderPaymentPreference]: Error processing payment authorization: org.ofbiz.base.util.GeneralException: Could not find any valid payment settings for order with ID [ORD10456], and payment operation (serviceType) [PRDS_PAY_AUTH] (Could not commit transaction for service [authOrderPayments] call: Roll back error, could not commit transaction, was rolled back instead because of: Error in Service [authOrderPaymentPreference]: Error processing payment authorization: org.ofbiz.base.util.GeneralException: Could not find any valid payment settings for order with ID [ORD10456], and payment operation (serviceType) [PRDS_PAY_AUTH]) If anyone has any tips, do share. -- Regards, Varun Bhansaly
Re: ofbiz paypal integration
Thanks Rick, my configuration settings seem fine as I'm able to pay in the paypal sandbox, with paypal redirecting me to the website once again. Though not sure why while creating the order the payment authorization fails. On Mon, May 30, 2011 at 6:25 PM, r...@thebva.com wrote: Varun, What are your configuration settings? I had the same problem, only to find that paypal had changed the settings needed to connect to them. Specifically, host address changed to payflowpro.paypal.com. Rick --- On Mon, 5/30/11, varun bhansaly vbhans...@gmail.com wrote: From: varun bhansaly vbhans...@gmail.com Subject: ofbiz paypal integration To: ofbiz user user@ofbiz.apache.org Date: Monday, May 30, 2011, 6:08 AM Hi, Has anyone tried integrating paypal with ofbiz-10.04 ? I have made all the configurations using this https://cwiki.apache.org/OFBENDUSER/apache-ofbiz-business-setup-guide.html#ApacheOFBizBusinessSetupGuide-PayPalPaymentSetupas reference. For Return Url, I've specified http:// my-server:8080/control/payPalCheckoutReturn Paypal sandox successfully redirects to this return URL, and I can see the order information. But as soon as I click 'submit order', order is created but following error is displayed (seems related to payment authorization) Error in authOrderPayments service: org.ofbiz.service.GenericServiceException: Could not commit transaction for service [authOrderPayments] call: Roll back error, could not commit transaction, was rolled back instead because of: Error in Service [authOrderPaymentPreference]: Error processing payment authorization: org.ofbiz.base.util.GeneralException: Could not find any valid payment settings for order with ID [ORD10456], and payment operation (serviceType) [PRDS_PAY_AUTH] (Could not commit transaction for service [authOrderPayments] call: Roll back error, could not commit transaction, was rolled back instead because of: Error in Service [authOrderPaymentPreference]: Error processing payment authorization: org.ofbiz.base.util.GeneralException: Could not find any valid payment settings for order with ID [ORD10456], and payment operation (serviceType) [PRDS_PAY_AUTH]) If anyone has any tips, do share. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Issue with paypal shipping callback
Thanks scott, this was the issue indeed. May be we should update the the guide here at https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide#ApacheOFBizBusinessSetupGuide-payPalPaymentSetup On Tue, May 24, 2011 at 2:59 AM, Scott Gray scott.g...@hotwaxmedia.comwrote: Been a while but I'm pretty sure that their API can't handle host names that have the port number specified meaning you have to host the request on port 80: http://mysite.com/ecommerce/control/payPalCheckoutUpdate Took me a LONG time to figure that one out. Regards Scott HotWax Media http://www.hotwaxmedia.com On 24/05/2011, at 3:17 AM, varun bhansaly wrote: Hi, Has anyone tried configuring Shipping callback url in the paypal payment gateway configuration screen in ofbiz 10.04 ? As far as I understand paypal would invoke this URL to calculate shipping charges. I've configured Shipping callback url to http://mysite.com:8080/ecommerce/control/payPalCheckoutUpdate, but this url is NEVER invoked. If anyone has any tips, please do share. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
ofbiz payflow pro integration
Anybody having any experience on VeriSign PayFlow Pro integration ? Is this supported in ofbiz 10.04 release ? Came acrosss a link in the cookbook but it does not work (re directs to ofbiz website) https://cwiki.apache.org/OFBIZ/faq-tips-tricks-cookbook-howto.html#FAQ-Tips-Tricks-Cookbook-HowTo-Payment -- Regards, Varun Bhansaly
Re: ofbiz payflow pro integration
Thanks Jacques, that was helpful indeed. Though I came across this very helpful guide here - https://cwiki.apache.org/OFBENDUSER/apache-ofbiz-business-setup-guide.html#ApacheOFBizBusinessSetupGuide-PayflowProPaymentSetup https://cwiki.apache.org/OFBENDUSER/apache-ofbiz-business-setup-guide.html#ApacheOFBizBusinessSetupGuide-PayflowProPaymentSetupI've tried the steps they work fine. May be update the link in the FAQ section to point to this URL. On Sat, May 21, 2011 at 1:23 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: You are in luck, I have a copy of that locally, here it is I'd really appreciate if you could fix the description and create a page under the FAQ page and put the link in FAQ to it Jacques Date: Thu, 03 Mar 2005 15:29:07 + From: Helmut Eggebert helmuteggeb...@hotmail.com Subject: [OFBiz] Users - Re: problem with VeriSign PayFlow Pro set up To: us...@lists.ofbiz.org Message-ID: bay22-f21b7ed3dea107fb702bb66c3...@phx.gbl Content-Type: text/plain; format=flowed Hi Users, Thanks to Brett's generous assistance I figured out what was wrong. It was a classpath issue. I needed to add the following line to my OFBIZ_HOME/applications/accounting/ofbiz-component.xml file: classpath type=jar location=lib/verisign/*/ Once I added that, it worked fine. So, for those trying to do this in the future, here's a review that somebody might want to put on the wiki: VeriSign Payflow Pro OFBiz Config Howto (based on trunk revision 4576) 1) Verified all the correct properties to use by talking to VeriSign and confirming the cert directory in their downloaded sdk as well as the vendor, partner, username and password for our account 2) Set thse properties correctly in payment.properties including the cert directory, vendor, partner, username and password. 3) Put Verisign.jar from Verisign's Java SDK in a verisign directory in applications/accounting/lib, changed the accounting build.xml and built it again 4) Confirm that applications/accounting/build/classes/org/ofbiz/accounting/thirdparty/verisign/PayflowPro.class was built and exists 5) Add the classpath to the Verisign.jar file in the applications/accounting/ofbiz-component.xml file with an entry such as classpath type=jar location=lib/verisign/*/ 6) In Catalog Manager - Stores - Payments, remove demo data configured as test services for credit cards and set up the all these services to the service name payflowCCProcessor 7) Restart ofbiz 8) Test by simulatin a user checkout in the demo store and put a valid CC in 9) Submit the order so the card could be authorized Thanks again. From: David E. Jones jone...@ofbiz.org Subject: Re: [OFBiz] Users - Re: problem with VeriSign PayFlow Pro set up To: OFBiz Users / Usage Discussion \(High Traffic\) us...@lists.ofbiz.org Message-ID: becf43de988cdf6a47751344f4ebe...@ofbiz.org Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed There's something funny here... You say in #3 to put the jar in the applications/accounting/lib folder, but then in #5 you put in a reference to the lib/verisign/* location, which translates to the applications/accounting/lib/verisign folder. Perhaps that was a problem, or am I missing something here... ? -David From: Helmut Eggebert helmuteggeb...@hotmail.com Subject: [OFBiz] Users - Re: problem with VeriSign PayFlow Pro set up To: us...@lists.ofbiz.org Message-ID: bay22-f29138f8d479ff2ab936aecc3...@phx.gbl Content-Type: text/plain; format=flowed Hi, David, you are correct that my instructions had an error. However, it was just a typo. I made a directory in accouning/lib called verisign and put Verisign.jar into accounting/lib/verisign and then the classpath was to lib/verisign. It worked. The problem was that originally I had no entry at all in accounting/ofbiz-component.xml so my classpath was missing. -- Regards, Varun Bhansaly
compressHTML recommended configuration
Hi, I'm using ofbiz 10.04, whats the best recommended way of enabling HTML whitespace compression. 1. Is it by uncommenting in widget.properties compress.HTML, OR 2. by specifying compressHTML context parameter in web.xml ? If yes, then would this need to be done for all web apps ? -- Regards, Varun Bhansaly
Re: Increase session time out for web app
Thanks Bilgin. On Mon, Apr 25, 2011 at 2:18 PM, Bilgin Ibryam bibr...@gmail.com wrote: I think this is the only place you need to change. Bilgin On Fri, Apr 22, 2011 at 5:17 PM, varun bhansaly vbhans...@gmail.com wrote: Hi, Is it possible to configure/ increase session time out for various web apps ? I think I would have to modify session-timeout tag in web.xml of webapps. Are there anyother configuration files which need to updated ? -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
USPS Address validation
Hi, Has anybody tried/ implemented USPS address validation feature in e-commerce component ? If yes, how is supposed to work and where would its results be visible ? -- Regards, Varun Bhansaly
UPS API returns discounted rates
Hi, I have configured UPS, during my testing, I've noticed the API always returns discounted rates. Is it possible to obtain published rates from API ? If any one has any idea on this confiuration/ change, please do share. -- Regards, Varun Bhansaly
Increase session time out for web app
Hi, Is it possible to configure/ increase session time out for various web apps ? I think I would have to modify session-timeout tag in web.xml of webapps. Are there anyother configuration files which need to updated ? -- Regards, Varun Bhansaly
Re: Where to see the generated sql when retrieving result from view entity?
If you are using MySQL, they you may append amp;profileSQL=trueamp;maxQuerySizeToLog=4096 to the jdbc-uri for MySQL in entityengine.xml On Tue, Mar 29, 2011 at 6:05 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: http://markmail.org/message/s57f7znzczb6us6h Jacques From: arini.rusda krelgir...@gmail.com Hi, I want to see the generated sql when i'm trying to retrieve data from view entities, because my view entity didn't show the result i expected when i want to do some grouping. Someone could tell me how to view the generated sql? Because i couldn't find it in the ofbiz.log Thanks in advance - Best Regards, Arini Rusda Informatics Department, Sepuluh Nopember Institute of Technology -- View this message in context: http://ofbiz.135035.n4.nabble.com/Where-to-see-the-generated-sql-when-retrieving-result-from-view-entity-tp3414553p3414553.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Re: Regarding catalog configuration
Another challenging part is defining the BOM for this fabricated window, because for each window quantity of raw materials involved will vary. If any one has any suggestion or experience of such an implementation, please do share. On Wed, Mar 2, 2011 at 7:41 AM, varun bhansaly vbhans...@gmail.com wrote: I have been planning to implement ofbiz for fabrication industry. Here the raw materials involved in fabricating a window are measured in terms of metres, some even in 'tube' (for foam). For example, to fabricate a 60 cm x 100cm window, some of the raw materials required will be - 1. Inner Frame 5 Chambers 83 mm - 2.9 m 2. Frame 5 Chambers, 65 mm - 3.2 m 3. Reinforcement for Frame - 1m 4. Foam - 0.5 tube I am slightly confused as to how to configure raw materials in the catalog and the BOM to ensure correct inventory levels. If someone has some ideas/ guidance, please do share. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Regarding catalog configuration
I have been planning to implement ofbiz for fabrication industry. Here the raw materials involved in fabricating a window are measured in terms of metres, some even in 'tube' (for foam). For example, to fabricate a 60 cm x 100cm window, some of the raw materials required will be - 1. Inner Frame 5 Chambers 83 mm - 2.9 m 2. Frame 5 Chambers, 65 mm - 3.2 m 3. Reinforcement for Frame - 1m 4. Foam - 0.5 tube I am slightly confused as to how to configure raw materials in the catalog and the BOM to ensure correct inventory levels. If someone has some ideas/ guidance, please do share. -- Regards, Varun Bhansaly
Re: Anyone using OFBiz Trunk + MySql 5.0.x + Ubuntu 10.04 + Sun Jdk1.6 combination - How much time it take to run ant run-install command?
= include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI tinyca. # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/ I have commented out #table_definition_cache = 2400 as it was not allowing me to restart mysql server. Do you think that switching to Mysql 5.1.x can make any difference here? In past I have also tried on Mysql 5.1.x version but at that time didn't do Fine Tunning thing. May be this time setting few additional parameter on Mysql 5.1.x can give better result. WDYT? Thanks! -- Ashish On Mon, Feb 21, 2011 at 12:39 AM, Ashish Vijaywargiya vijaywargiya.ash...@gmail.com wrote: Wow, too quick Mike. Thanks a lot! Doing this changes right away and will be back to you in next 15 minutes or so. This is quite interesting, I am having 1 more machine on which Ubuntu 8.04 is running and over there I didn't do any manual adjustment. The ant run-install command takes about 4-5 minutes in completion. -- Ashish On Mon, Feb 21, 2011 at 12:35 AM, Mike mz4whee...@gmail.com wrote: Tuning. Ofbiz has over 800 tables. Here are a few things to tweak. table_cache= 2400 table_definition_cache = 2400 max_heap_table_size = 512M tmp_table_size = 512M join_buffer_size= 5M query_cache_limit = 64M query_cache_size= 128M On Sun, Feb 20, 2011 at 10:54 AM, Ashish Vijaywargiya vijaywargiya.ash...@gmail.com wrote: Hello, Since last 2 years I was using OFBiz Trunk + Mysql 5.0.x + Ubuntu 8.04 + Sun Jdk1.6. Everything was working as expected the command ant run-install was taking about 4 - 5 minutes on my laptop. Before 3, 4 month I have switched to Ubuntu 10.04 but now ant run-install command is taking about 19 - 22 minutes on my laptop. *On my machine I have observed that ant run-install command is taking too much time at the time of index creation.* I have tried with all the mysql connector(3.0.x, 3.1.x 5.x) but all the time completion time for ant run-install command remains around 19 - 22 minutes. ashish@ashish-laptop:~/ofbiz_dev/testing$ svn info Path: . URL: https://svn.apache.org/repos/asf/ofbiz/trunk Repository Root: https://svn.apache.org/repos/asf Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 Revision: 1072680 Node Kind: directory Schedule: normal Last Changed Author: erwan Last Changed Rev: 1072600 Last Changed Date: 2011-02-20 19:43:03 +0530 (Sun, 20 Feb 2011) Recently ran this command and here is the out come of time frame: [java] 2011-02-21 00:17:43,537 (main) [EntityDataLoadContainer.java:397:INFO ] 4 of 15353 from file:/home/ashish/ofbiz_dev/testing/specialpurpose/webpos/data/WebPosSecurityData.xml [java] 2011-02-21 00:17:43,537 (main) [EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data load with 15353 rows changed. [java] 2011-02-21 00:17:43,537 (main) [ ContainerLoader.java:113:INFO ] Shutting down containers BUILD SUCCESSFUL Total time: 21 minutes 35 seconds Anyone using OFBiz Trunk + MySql 5.0.x + Ubuntu 10.04 + Sun Jdk1.6 combination? How much time it is taking to run ant run-install command for you? I am assuming that I may need to do some additional settings inside my.cnf file in Ubuntu 10.04. Any pointer would be greatly appreciated. Thanks! -- Ashish -- Regards, Varun Bhansaly
Marketing package - package customization
Hi, While using marketing package type products, is it possible to customize the package (during order creation) by substituting one item for another item ? -- Regards, Varun Bhansaly
Re: Marketing package - package customization
Thanks BJ. I tested this by creating a product association of type Equivalent or Substitute for product Gizmo Basket Assembly Pick. This does not seem to work OOTB, and may be would require custom development. Please correct me if my understanding is incorrect. On Wed, Feb 2, 2011 at 12:06 AM, BJ Freeman bjf...@free-man.net wrote: if you have a productAssocType of PRODUCT_SUBSTITUTE then you can use them in your customization. one other you may consider is PRODUCT_COMPLEMENT. I don't think PRODUCT_UPGRADE would be good but in some cases it might be considered. = BJ Freeman Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 2/1/2011 9:38 AM: Hi, While using marketing package type products, is it possible to customize the package (during order creation) by substituting one item for another item ? -- Regards, Varun Bhansaly
Re: Debugging ofbiz in eclipse....
Hope this helps https://cwiki.apache.org/confluence/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse On Sun, Jan 23, 2011 at 2:46 AM, BJ Freeman bjf...@free-man.net wrote: google is your friend try ofbiz debugging :D = BJ Freeman Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Shereen sent the following on 1/22/2011 1:11 PM: Hi All I'm running ofbiz on linux I'm working noq on 10.04 the svn copy I've problems making the remote debugging and I dunno how to configure the startofbiz.sh file although I've read about it? has anyone modified the startofbiz.sh to be in the debugging mode? or can anyone tell what exact lines do I have to comment regarding the 10.04? Thanks in advance -- Regards, Varun Bhansaly
Questions and observation regarding multi tenant
Hi, I have been testing multi tenant on ofbiz 10.04 release branch. I could setup the demo data using run-install-multitenant. Though I have a few questions observation which I would like to share with the community - Question first, 1. Significance of datasource name localderbytenant ? 2. Whats the purpose of the configuration described here in https://cwiki.apache.org/OFBIZ/multitenancy-support.html#Multitenancysupport-Datasourcereferenceondelegator, as the tenant information would be stored in entity TenantDataSource ? Observation - 1. Tried login into webtools with tenant DEMO1, user bizadmin, rightly this user was not allowed to login indicated by the message You cannot login to this application. 2. Next, tried login into webtools tenant DEMO2, user admin. Login was denied with message Error calling event: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.NullPointerException (null) With error messages in the log - 2010-12-21 18:05:03,008 (http-0.0.0.0-8443-4) [DelegatorFactoryImpl.java:30 :INFO ] Creating new delegator [default#DEMO1#DEMO2] (http-0.0.0.0-8443-4) 2010-12-21 18:05:03,069 (http-0.0.0.0-8443-4) [DelegatorFactoryImpl.java:35 :ERROR] exception report -- Error creating delegator Exception: org.ofbiz.entity.GenericEntityException Message: No Tenant record found for delegator [default#DEMO1#DEMO2] with tenantId [DEMO1#DEMO2] This seems session is not being cleared in case of #1. -- Regards, Varun Bhansaly
Re: Questions regarding survey
Hi Santosh, Have you found the purpose of items #4, #5. It would be really helpful if you (or if any one else) share your findings. On Mon, Jul 12, 2010 at 5:47 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hello list, I am working with content component for survey and I want to know purpose of following fields: - (1) responseService (on survey creation form under SurveyID tab) (2) AcroForm (PDF) Content ID (on survey creation form under SurveyID tab) (3) PDF Content Id (on survey creation form under SurveyID tab) (4) W/Question (in list of questions under Questions tab) (5) W/Option (in list of questions under Questions tab) Thanks and Regards Santosh Malviya -- Regards, Varun Bhansaly
Regarding entity audit log
Hi, Is it possible to enable audit log on an entity in such a way that configuration to enable audit on columns is maintained in a custom component. For eg, if auditing is to be enabled on OrderHeader entity, custom component would contain columns with enable-audit-log. I have tried with the extend entity mechanism, but that results in exceptions due to duplicate columns. -- Regards, Varun Bhansaly
Re: Product Customizations
I think INVENTORY_ITEM_ATTRIBUTE entity could be used to store custom attributes. Though I don't think there's UI OOTB to put values for custom attributes into this entity. May be this will require some customization. Thanks, Varun On Tue, Nov 9, 2010 at 12:33 PM, Raj Saini rajsa...@gmail.com wrote: PRODUCT_ATTRIBUTE are good to store product attributes e.g. number of pages of a book, cover type etc. You are right values of GOOD_IDENTIFICATION values are per product and not per inventory item. If you look at the inventory items, you will see fields like serial number, soft identifier etc which may be mapped to your fields of your inventory item. On 09/11/10 11:56, Naveen Poddar wrote: Not sure as to how to make use of PRODUCT_ATTRIBUTE in the current scenario. Regarding using GOOD_IDENTIFICATION new identification types, isn't the value for the identification type will remain constant for a product ? In the current scenario, every inventory item for product X500 will have a distinct value for Part Number, ESN number, Revision Number. Please correct me if my understanding is wrong. On Mon, Nov 8, 2010 at 10:02 PM, BJ Freemanbjf...@free-man.net wrote: GOOD_IDENTIFICATION as defined on page75 of the data model books allows you to add as many Identifications as you want. You can also add definition for the Type of Identification. https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification = BJ Freeman Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.comhttp://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Naveen Poddar sent the following on 11/8/2010 5:29 AM: Serialized inventory could be used to store serial nos. I have had a look at the GOOD_IDENTIFICATION entity, which stores a mapping b/w type, product value, but in my case there are other attributes such as part Number, an ESN number, Revision Number. This value for each of these attribute vary for each of the physical inventory of a product. Thanks, On Mon, Nov 8, 2010 at 6:20 PM, Raj Sainirajsa...@gmail.com wrote: Hi Naveen, You can look at the Goods Identifiers where you can store multiple identifier of a product. Also, if your products have serial number, you would like to consider the serialized inventory. Thanks, Raj On 08/11/10 17:12, Naveen Poddar wrote: Hi, I am working on the online store feature. We want the ability to add more information to each product. Right now for an item we can only store the Serial Number. There are many more numbers and information associated with each item in the inventory. We have part numbers, revision numbers, dates, service tags, asset tags, manufacture date, model, etc. Some of these may be meaningless for some of the products. For example - We receive 10 quantities of product X500. Each X500 has a Part Number, an ESN number, Revision Number. When we receive 10 quantities of product M450, each of these have a part number, serial number... but no ESN. Is there any way to store these information? Thanks, -- Regards, Varun Bhansaly
Re: Free Shipping?
Hi, I have set ProductStore/Inventory/Is Immediately Fulfilled field to Y, even after this setting, while processing sales orders from ordermgr app I am getting this screen - Sales Order : Order Entry Ship-To Settings. Is there any other configuration that needs to be made ? Thanks, Varun On Sun, Oct 24, 2010 at 3:16 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: I think you are looking for the face to face feature in OFBiz. Set the ProductStore/Inventory/Is Immediately Fulfilled field to Y Your store will then behave like a POS. Jacques From: Shereen sheri_ash...@hotmail.com Thanks Freeman I got your point but still the Ofbiz needs a valid shipping address even if no shipping is required right? I think disabling that will require some coding or it's not possible ? will cause other problems? you know it's as if you choose from certain store or catalog then there will be no shipping at all no need to enter shipping address or so I'll do some studies and search and if you have further recommendations please tell me Regards -- View this message in context: http://ofbiz.135035.n4.nabble.com/Free-Shipping-tp156203p3008991.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Entity engine compare columns
Hi, Is it possible to compare two columns using the entity engine, For eg, write a query like this - SELECT * FROM USER_LOGIN WHERE USER_LOGIN_ID PARTY_ID -- Regards, Varun Bhansaly
Re: Entity engine compare columns
Thanks, but I wish to compare two columns. BTW, if I write this in java service, what should be the type for partyId ? On Mon, Oct 11, 2010 at 6:43 PM, Chirag Manocha cmano...@emforium.comwrote: Hi Varun, Following will work for you :- EntityCondition.makeCondition(USER_LOGIN_ID, EntityJoinOperator.NOT_EQUAL, partyId) Regards -- Chirag Manocha Emforium Software Pvt. Ltd. | ALL-IN Software +91-98735-47457 | +91-98263-19099 Please don't print this Email unless you really need to - this will preserve trees on planet earth. From: pankaj savita pankajsav...@gmail.com To: user@ofbiz.apache.org Sent: Monday, October 11, 2010 6:12:44 PM Subject: Re: Entity engine compare columns Hi Varun, You can make EntityCondition using: EntityCondition.makeCondition(USER_LOGIN_ID, EntityOperator.GREATER_THAN_EQUAL_TO, PARTY_ID) or EntityCondition.makeCondition(USER_LOGIN_ID, EntityOperator.LESS_THAN_EQUAL_TO, PARTY_ID) -- Thanks Regards, Pankaj Savita Mob: +91 9890262476 Mail to: pankajsav...@gmail.com On Mon, Oct 11, 2010 at 4:40 PM, varun bhansaly vbhans...@gmail.com wrote: Hi, Is it possible to compare two columns using the entity engine, For eg, write a query like this - SELECT * FROM USER_LOGIN WHERE USER_LOGIN_ID PARTY_ID -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Entity engine compare columns
This is what works - EntityCondition.makeCondition(oldValueText, EntityOperator.NOT_EQUAL, EntityFieldValue.makeFieldValue(newValueText)); and the generated query is - SELECT AUDIT_HISTORY_SEQ_ID, CHANGED_ENTITY_NAME, CHANGED_FIELD_NAME, PK_COMBINED_VALUE_TEXT, OLD_VALUE_TEXT, NEW_VALUE_TEXT, CHANGED_DATE, CHANGED_BY_INFO, CHANGED_SESSION_INFO, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM ENTITY_AUDIT_LOG WHERE (OLD_VALUE_TEXT NEW_VALUE_TEXT) ORDER BY CHANGED_DATE DESC Thanks All. On Mon, Oct 11, 2010 at 7:29 PM, Bilgin Ibryam bibr...@gmail.com wrote: The condtion should be something like this: (EntityFieldValue.makeFieldValue(userLoginId), EntityOperator.EQUALS, partyId) Bilgin On Mon, Oct 11, 2010 at 12:10 PM, varun bhansaly vbhans...@gmail.com wrote: Hi, Is it possible to compare two columns using the entity engine, For eg, write a query like this - SELECT * FROM USER_LOGIN WHERE USER_LOGIN_ID PARTY_ID -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Regarding SECAs
What I have implemented is, create 3 services serviceToBeInvoked1, serviceToBeInvoked2, serviceToBeInvoked3. Service definition for these 3 would point to serviceToBeInvoked, so it will be like this. service name=serviceToBeInvoked1 engine=simple auth=true location=component://your/component/YourServices.xml invoke=serviceToBeInvoked etc. 2010/9/9 Michał Cukierman of...@partbook.eu I am an ofbiz newbe. Could you write a service wrapper in simple method? For example: service name=yourServiceWrapper engine=simple auth=true location=component://your/component/YourServices.xml invoke=yourMethod /service and: eca service=someService event=invoke action service=yourServiceWrapper mode=sync/ and in a simple method pass your aguments and invoke someService, lets say in a loop? I suppose you set arguments in your service declaration as well. Dnia 2010-09-09, czw o godzinie 07:25 +0530, varun bhansaly pisze: Hi, I am using ofbiz 09.04, wanted to know if its possible to configure a seca on a service which could be invoked multiple times with different values - The scenario - eca service=someService event=invoke set field-name=field1 value=SOME_VALUE1/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE2/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE3/ action service=serviceToBeInvoked mode=sync/ /eca So for every someService invoke, serviceToBeInvoked should be executed 3 times with different values for field1. With the above configuration, service engine executes serviceToBeInvoked only once. What could be other suggested ways so that serviceToBeInvoked is executed 3 times. -- Regards, Varun Bhansaly
Re: Regarding SECAs
Thanks Deepak, For the current scenario, parameters event have to be same. A good example (similar to mine is) is secas on storeOrder. On Thu, Sep 9, 2010 at 4:50 PM, Deepak Dixit deepak.di...@hotwaxmedia.comwrote: Hi Varun, You call same service in seca for different parameter. You can take reference for accounting/servicedef/secas.xml, here is the example : eca service=createCreditCard event=commit set field-name=mode value=CREATE/ action service=verifyCreditCard mode=sync run-as-user=system/ /eca eca service=updateCreditCard event=commit condition-field field-name=oldPaymentMethodId operator=not-equals to-field-name=paymentMethodId/ set field-name=mode value=UPDATE/ action service=verifyCreditCard mode=sync run-as-user=system/ /eca Thanks Regards -- Deepak Dixit HotWax Media Pvt. Ltd. Website :- www.hotwaxmedia.com Contact :- +91-98267-54548 Skype Id :- deepakdixit varun bhansaly wrote: What I have implemented is, create 3 services serviceToBeInvoked1, serviceToBeInvoked2, serviceToBeInvoked3. Service definition for these 3 would point to serviceToBeInvoked, so it will be like this. service name=serviceToBeInvoked1 engine=simple auth=true location=component://your/component/YourServices.xml invoke=serviceToBeInvoked etc. 2010/9/9 Michał Cukierman of...@partbook.eu I am an ofbiz newbe. Could you write a service wrapper in simple method? For example: service name=yourServiceWrapper engine=simple auth=true location=component://your/component/YourServices.xml invoke=yourMethod /service and: eca service=someService event=invoke action service=yourServiceWrapper mode=sync/ and in a simple method pass your aguments and invoke someService, lets say in a loop? I suppose you set arguments in your service declaration as well. Dnia 2010-09-09, czw o godzinie 07:25 +0530, varun bhansaly pisze: Hi, I am using ofbiz 09.04, wanted to know if its possible to configure a seca on a service which could be invoked multiple times with different values - The scenario - eca service=someService event=invoke set field-name=field1 value=SOME_VALUE1/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE2/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE3/ action service=serviceToBeInvoked mode=sync/ /eca So for every someService invoke, serviceToBeInvoked should be executed 3 times with different values for field1. With the above configuration, service engine executes serviceToBeInvoked only once. What could be other suggested ways so that serviceToBeInvoked is executed 3 times. -- Regards, Varun Bhansaly
Re: Ofbiz installation tutorial???
up and running quickly. Simply, create the directory you wish to run OFBiz in (make sure that Java is on the classpath while working in this directory), change to that directory, unzip your file there and startup OFBiz. For example: 1) Create a directory such as /home/ofbiz 2) Download the zip file to your new directory. You will have something that looks like this: /home/ofbiz/ofbizdownload.zip 3) Unzip your file using something like gzip (Not sure what the Ubuntu unzip command is.) 4) Move to the unzipped file location doing something like: cd /home/ofbiz/ofbizdownload 4) Run the Unix OFBiz invocation script that comes with the distribution: ./startofbiz.sh 5) Navigate to the ecommerce startup page http://localhost:8080/ecommerce 6) Observe that you see the ecommerce landing page Once you understand what you've got out-of-the-box and you are ready to do some development work, then consider downloading from SVN. Regards, Ruth Hoffman http://www.myofbiz.com MavrickIT wrote: Thanks Patel for trying to help me out. I have gone through the links already that you gave me. Thing is, I already installed JRE6, full SDK, and tomcat, SVN, ANT etc. These were installed in root by default. I created folder /home/ofbiz. So, there is nothing inside ...home/ofbiz$ I performed svn co http://svn.apache.. Even I tried svn co http://../ofbiz9+ and svn co http:///ofbiz4.0 So, how could I download ofbiz or even extract it, I don't know. Even, from where to download it? Some google sites say, to download ofbiz separately and extract it to /home/ofbiz user. Somewhere (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide) it's shown that, OFBiz with embedded Tomcat. I can't find any exact solution. I am yet confused what should I type @ the terminal for installing Ofbiz from the beginning. Waiting for any suitable reply.:-( Thank you. Anil Patel-3 wrote: Hi, For quick setup use http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide Please see following documents to setup development/staging environment. http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Se tup+Guide http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide Regards Anil patel On Oct 2, 2009, at 12:34 PM, MavrickIT wrote: Can anybody help me out for Ofbiz installation guide [step by step command lines] from the Terminal (Ububntu)? I've been facing lots trouble about it. Please find me a solution. I found no solid step by step commands tutorials for installing ofbiz or running it. well, I am newbie to linux as well. Eventually, I don't even know how to extract or download ofbiz. Please help me. -- View this message in context: http://www.nabble.com/Ofbiz-installation-tutorialtp25716734p25716734.h tml Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
Regarding SECAs
Hi, I am using ofbiz 09.04, wanted to know if its possible to configure a seca on a service which could be invoked multiple times with different values - The scenario - eca service=someService event=invoke set field-name=field1 value=SOME_VALUE1/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE2/ action service=serviceToBeInvoked mode=sync/ /eca eca service=someService event=invoke set field-name=field1 value=SOME_VALUE3/ action service=serviceToBeInvoked mode=sync/ /eca So for every someService invoke, serviceToBeInvoked should be executed 3 times with different values for field1. With the above configuration, service engine executes serviceToBeInvoked only once. What could be other suggested ways so that serviceToBeInvoked is executed 3 times. -- Regards, Varun Bhansaly
Re: Ofbiz WorkFlow Engine
Hi Deepa, Are you looking at something like designing the process flow, for eg as in jBPM workflow engine the process designer ? Though processes could be implemented using SECAs, EECAs etc. On Tue, Sep 7, 2010 at 1:24 PM, Deepa Priolkar dee...@techmahindra.comwrote: Thanks Varun for replying.. I have checked this link but its talking about XPDL which actually comes with Shark implementation and in the same link they have mentioned that Shark is not yet implemented in Ofbiz. The alternative is event based. SO does this mean we don't have workflow definition type of design in Ofbiz as of now other then the events? Thanks, Deepa -Original Message- From: varun bhansaly [mailto:vbhans...@gmail.com] Sent: Monday, September 06, 2010 9:57 PM To: user@ofbiz.apache.org Subject: Re: Ofbiz WorkFlow Engine Hi, This document might help http://ofbiz.apache.org/docs/workflow.html On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar dee...@techmahindra.comwrote: Hi All, Need some help to know if we have any workflow integrated in ofbiz 9.04 version? if we already have the workflow is it using xpdl? Is it Shark workflow? Please let me know.. need this urgently before i start designing for one of my requirement. Appreciate your help. Thanks Regards, Deepa Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at a href=http://www.techmahindra.com/Disclaimer.html http://www.techmahindra.com/Disclaimer.html/a externally and a href= http://tim.techmahindra.com/Disclaimer.html; http://tim.techmahindra.com/Disclaimer.html/a internally within Tech Mahindra.=== = -- Regards, Varun Bhansaly Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at a href=http://www.techmahindra.com/Disclaimer.html http://www.techmahindra.com/Disclaimer.html/a externally and a href= http://tim.techmahindra.com/Disclaimer.html; http://tim.techmahindra.com/Disclaimer.html/a internally within Tech Mahindra. -- Regards, Varun Bhansaly
Re: Ofbiz WorkFlow Engine
Hi, This document might help http://ofbiz.apache.org/docs/workflow.html On Mon, Sep 6, 2010 at 9:39 PM, Deepa Priolkar dee...@techmahindra.comwrote: Hi All, Need some help to know if we have any workflow integrated in ofbiz 9.04 version? if we already have the workflow is it using xpdl? Is it Shark workflow? Please let me know.. need this urgently before i start designing for one of my requirement. Appreciate your help. Thanks Regards, Deepa Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at a href=http://www.techmahindra.com/Disclaimer.html http://www.techmahindra.com/Disclaimer.html/a externally and a href= http://tim.techmahindra.com/Disclaimer.html; http://tim.techmahindra.com/Disclaimer.html/a internally within Tech Mahindra. -- Regards, Varun Bhansaly
MySQL DB creation with demo data
Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3 having 4 processors 2 gb ram. Encoding in entityengine.xml is set to utf8. Database creation with demo data takes minimum 40 minutes. Is this an acceptable for db creation given above configuration ? PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs ram used to take 10 mins. -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
Thanks for sharing the thoughts configuration, quite strangely, db creation on a plain jane default mysql installation (of a previous version) would not take so long. Does it sound some sort of encoding issue ? Thanks, -- View this message in context: http://ofbiz.135035.n4.nabble.com/MySQL-DB-creation-with-demo-data-tp2401466p2401921.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: MySQL DB creation with demo data
I have tried loading over network as well as from local. Are talking of mysqldump restore as well ? On Tue, Aug 31, 2010 at 10:30 PM, BJ Freeman bjf...@free-man.net wrote: if I read this correct you have introduced many variables. 1) have you tested loading a MySQL db over the network in this configuration, list a restore, not using ofbiz? 2) have you tested loading a local MySQL db using ofbiz? = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 5:32 AM: Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3 having 4 processors 2 gb ram. Encoding in entityengine.xml is set to utf8. Database creation with demo data takes minimum 40 minutes. Is this an acceptable for db creation given above configuration ? PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs ram used to take 10 mins. -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
Thanks BJ, what is available is the 'target' m/c only with latest MySQL, no backup has been taken for this dev env. Since I work primarily with ofbiz, theres no other dataset to reference. On Tue, Aug 31, 2010 at 11:02 PM, BJ Freeman bjf...@free-man.net wrote: the first is to isolate if ofbiz is causing anything by removing it from the equation. so do a equivalent restore of data from the machine that ofbiz resides on to the target that MySQL resides on and time. you can do this by saving the MySQL data of a current db that has ofbiz structure and data then loading like above to the db on the target machine. That give you a bench mark of the DB by itself. then setup ofbiz to a local db with the same setting as the remote one and see what the load time of the db is from ofbiz. that should give you a fair estimation where the problem is. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 10:10 AM: I have tried loading over network as well as from local. Are talking of mysqldump restore as well ? On Tue, Aug 31, 2010 at 10:30 PM, BJ Freemanbjf...@free-man.net wrote: if I read this correct you have introduced many variables. 1) have you tested loading a MySQL db over the network in this configuration, list a restore, not using ofbiz? 2) have you tested loading a local MySQL db using ofbiz? = BJ Freemanhttp://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.comhttp://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 5:32 AM: Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3 having 4 processors 2 gb ram. Encoding in entityengine.xml is set to utf8. Database creation with demo data takes minimum 40 minutes. Is this an acceptable for db creation given above configuration ? PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs ram used to take 10 mins. -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
I have tried with latest Connector/J 5.1.13, but result is the same (slow db creation) On Tue, Aug 31, 2010 at 11:58 PM, BJ Freeman bjf...@free-man.net wrote: that does make it more difficult. Not sure what you can do, you might check if it is the MySQL jdbc driver you using in ofiz. and possibly so setting the driver needs in the entityengine.xml = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 10:58 AM: Thanks BJ, what is available is the 'target' m/c only with latest MySQL, no backup has been taken for this dev env. Since I work primarily with ofbiz, theres no other dataset to reference. On Tue, Aug 31, 2010 at 11:02 PM, BJ Freemanbjf...@free-man.net wrote: the first is to isolate if ofbiz is causing anything by removing it from the equation. so do a equivalent restore of data from the machine that ofbiz resides on to the target that MySQL resides on and time. you can do this by saving the MySQL data of a current db that has ofbiz structure and data then loading like above to the db on the target machine. That give you a bench mark of the DB by itself. then setup ofbiz to a local db with the same setting as the remote one and see what the load time of the db is from ofbiz. that should give you a fair estimation where the problem is. = BJ Freemanhttp://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.comhttp://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 10:10 AM: I have tried loading over network as well as from local. Are talking of mysqldump restore as well ? On Tue, Aug 31, 2010 at 10:30 PM, BJ Freemanbjf...@free-man.net wrote: if I read this correct you have introduced many variables. 1) have you tested loading a MySQL db over the network in this configuration, list a restore, not using ofbiz? 2) have you tested loading a local MySQL db using ofbiz? = BJ Freemanhttp://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=52 Specialtymarket.comhttp://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man varun bhansaly sent the following on 8/31/2010 5:32 AM: Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3 having 4 processors2 gb ram. Encoding in entityengine.xml is set to utf8. Database creation with demo data takes minimum 40 minutes. Is this an acceptable for db creation given above configuration ? PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs ram used to take 10 mins. -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community server, utf8 encoding default, it takes 3.38 mins with demo data. On Wed, Sep 1, 2010 at 5:54 AM, David E Jones d...@me.com wrote: On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: I have two environments: 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the initial data. 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the data. Don't have the solution but I have noticed that on machines with slow disks the performance while creating indices, constraints and tables is poor. Are both machines running the same software, ie same database, JVM, and app server? How about the same operating system? I've seen this kind of difference a lot when comparing Linux/OSX/etc to Windows. Windows uses blocking synchronous IO and is REALLY slow compared to the asynchronous IO of more server-worthy operating systems. -David -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
Another piece of stat - Suppose db is created, when ofbiz is booting, it takes it around a minute to gather db information, thats in collecting meta data. On Wed, Sep 1, 2010 at 6:38 AM, varun bhansaly vbhans...@gmail.com wrote: I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community server, utf8 encoding default, it takes 3.38 mins with demo data. On Wed, Sep 1, 2010 at 5:54 AM, David E Jones d...@me.com wrote: On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: I have two environments: 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the initial data. 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the data. Don't have the solution but I have noticed that on machines with slow disks the performance while creating indices, constraints and tables is poor. Are both machines running the same software, ie same database, JVM, and app server? How about the same operating system? I've seen this kind of difference a lot when comparing Linux/OSX/etc to Windows. Windows uses blocking synchronous IO and is REALLY slow compared to the asynchronous IO of more server-worthy operating systems. -David -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: MySQL DB creation with demo data
Db creation takes 10 mins now (acceptable than 2 hours). It was due to the new h/w we had migrated to. Thanks for all the responses. On Wed, Sep 1, 2010 at 6:44 AM, varun bhansaly vbhans...@gmail.com wrote: Another piece of stat - Suppose db is created, when ofbiz is booting, it takes it around a minute to gather db information, thats in collecting meta data. On Wed, Sep 1, 2010 at 6:38 AM, varun bhansaly vbhans...@gmail.comwrote: I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community server, utf8 encoding default, it takes 3.38 mins with demo data. On Wed, Sep 1, 2010 at 5:54 AM, David E Jones d...@me.com wrote: On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: I have two environments: 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the initial data. 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the data. Don't have the solution but I have noticed that on machines with slow disks the performance while creating indices, constraints and tables is poor. Are both machines running the same software, ie same database, JVM, and app server? How about the same operating system? I've seen this kind of difference a lot when comparing Linux/OSX/etc to Windows. Windows uses blocking synchronous IO and is REALLY slow compared to the asynchronous IO of more server-worthy operating systems. -David -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: exceptions while running latest ofbiz code on Jboss using mysql db
Try increasing the jvm heap memory from startofbiz.bat On Fri, Aug 20, 2010 at 2:20 PM, PrateekJain prateekm.j...@lntinfotech.comwrote: whenever i am trying to run ofbiz-10-Aug-2010 code on windows platform on JBoss using mysql db i get java.lang.OutOfMemoryError: unable to create new native thread server is started but apllication is not running Count,null()][finishDateTime,2010-08-10 21:04:31.0(java.sql.Timestamp)][jobId,290027(java.lang.String)][jobName,Send Email( .lang.String)][lastUpdatedStamp,2010-08-20 12:40:45.0(java.sql.Timestamp)][lastUpdatedTxStamp,2010-08-20 12:37:03.0(java.sq mestamp)][loaderName,null()][maxRecurrenceCount,-1(java.lang.Long)][maxRetry,null()][parentJobId,SENDEMAIL(java.lang.String oolId,pool(java.lang.String)][previousJobId,282453(java.lang.String)][recurrenceInfoId,null()][runAsUser,system(java.lang.S g)][runByInstanceId,ofbiz1(java.lang.String)][runTime,2010-08-20 10:29:15.0(java.sql.Timestamp)][runtimeDataId,null()][serv ame,sendEmailDated(java.lang.String)][startDateTime,2010-08-20 12:40:45.0(java.sql.Timestamp)][statusId,SERVICE_RUNNING(jav ng.String)][tempExprId,SENDEMAIL(java.lang.String)] 13:47:41,558 ERROR [[/accounting]] Exception starting filter ContextFilter java.lang.OutOfMemoryError: unable to create new native thread at java.lang.Thread.start0(Native Method) at java.lang.Thread.start(Thread.java:597) at org.ofbiz.entity.transaction.GenericXaResource.start(GenericXaResource.java:101) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:776) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:499) at org.ofbiz.entity.transaction.GenericXaResource.enlist(GenericXaResource.java:71) at org.ofbiz.entity.transaction.GenericXaResource.enlist(GenericXaResource.java:54) at org.ofbiz.entity.transaction.DebugXaResource.enlist(DebugXaResource.java:53) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:191) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131) at org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:766) at org.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:241) at org.ofbiz.service.job.JobPoller.init(JobPoller.java:63) at org.ofbiz.service.job.JobManager.init(JobManager.java:82) at org.ofbiz.service.job.JobManager.getInstance(JobManager.java:90) at org.ofbiz.service.ServiceDispatcher.init(ServiceDispatcher.java:113) at org.ofbiz.service.ServiceDispatcher.init(ServiceDispatcher.java:130) at org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:164) at org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:139) at org.ofbiz.service.GenericDispatcher.getLocalDispatcher(GenericDispatcher.java:78) at org.ofbiz.service.GenericDispatcher.getLocalDispatcher(GenericDispatcher.java:43) at org.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34) at org.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39) at org.ofbiz.entityext.eca.DelegatorEcaHandler.setDelegator(DelegatorEcaHandler.java:55) at org.ofbiz.entity.GenericDelegator.initEntityEcaHandler(GenericDelegator.java:346) at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:42) at org.ofbiz.webapp.control.ContextFilter.getDelegator(ContextFilter.java:347) at org.ofbiz.webapp.control.ContextFilter.init(ContextFilter.java:108) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:275) at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:397) at org.apache.catalina.core.ApplicationFilterConfig.init(ApplicationFilterConfig.java:108) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3722) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4367) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) at
ofbiz 9.04 to 10.04 upgrade
Hi, I am planning to migrate my current ofbiz 9.04 to ofbiz 10.04. I do have a list of files changed in core 9.04, further most of my code is in separate components. Is there any guide pointing out the set of steps to be executed for upgrade ? It would be helpful if some1 has done something similar would like to share the approach. -- Regards, Varun Bhansaly
View entity extra conditions
Hi, I have written a view entity, as shown below, the intention is to perform inner join b/w two entities a further condition. But after looking at the raw SQL, it seems entity engine seems to ignore entity condition tag. view-entity entity-name=PartyRoleAndPersonExt package-name=org.ofbiz.custom title=party role and party detail member-entity entity-alias=PR entity-name=PartyRole/ member-entity entity-alias=PERSON entity-name=Person/ alias-all entity-alias=PRexclude field=partyId//alias-all alias entity-alias=PERSON name=personPartyId field=partyId/ alias entity-alias=PERSON name=firstName/ alias entity-alias=PERSON name=lastName/ alias entity-alias=PERSON name=middleName/ view-link entity-alias=PR rel-entity-alias=PERSON key-map field-name=partyId/ /view-link entity-condition condition-expr field-name=roleTypeId value=SALES_REP entity-alias=PR/ /entity-condition /view-entity Am i missing anything ? Is there any other way to specify extra conditions in the view entity definition itself ? -- Regards, Varun Bhansaly
Re: View entity extra conditions
Hi, Thanks for ur reply, entity alias is already being used in the condition expr, further using rel-optional = true results in Left Outer Join whereas rel-optional = false (which is default) results in inner join. On Sun, Aug 15, 2010 at 12:32 PM, Ravindra Mandre raviof...@gmail.comwrote: Hi, Comments inline On Sun, Aug 15, 2010 at 11:53 AM, varun bhansaly vbhans...@gmail.com wrote: Hi, I have written a view entity, as shown below, the intention is to perform inner join b/w two entities a further condition. But after looking at the raw SQL, it seems entity engine seems to ignore entity condition tag. view-entity entity-name=PartyRoleAndPersonExt package-name=org.ofbiz.custom title=party role and party detail member-entity entity-alias=PR entity-name=PartyRole/ member-entity entity-alias=PERSON entity-name=Person/ alias-all entity-alias=PRexclude field=partyId//alias-all alias entity-alias=PERSON name=personPartyId field=partyId/ alias entity-alias=PERSON name=firstName/ alias entity-alias=PERSON name=lastName/ alias entity-alias=PERSON name=middleName/ view-link entity-alias=PR rel-entity-alias=PERSON key-map field-name=partyId/ /view-link entity-condition condition-expr field-name=roleTypeId value=SALES_REP entity-alias=PR/ try by providing entity-alias name on which you are making condition , and rel-optional=true in view link HTH Ravindra Mandre /entity-condition /view-entity Am i missing anything ? Is there any other way to specify extra conditions in the view entity definition itself ? -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: View entity extra conditions
Hi Jacques, I forgot to mention, I am using https://svn.apache.org/repos/asf/ofbiz/branches/release09.04 at rev 934744. In this ModelViewEntity does not consider entity-condition, so while this is still a valid view entity definition, the engine ignores entity-condition. With the latest 10.04 trunk ModelViewEntity contains the parsing logic for entity-condition. Thanks for helping me solve this (on a sunday !) partly. Now I need to find a way to easily patch these changes into my 09.04 codebase. On Sun, Aug 15, 2010 at 4:11 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: With your initial definition It works for me, I get the details (as definef in your view: names) of persons with role type SALES_REP only What is missing in your results? And also what do you mean when you say when this view entity is being queried in the code, these filteringconditions need not be explicitly specified., what to you attempt to do at this moment? Jacques From: varun bhansaly vbhans...@gmail.com Hi Jacques, The requirement is to define a view entity, write some additional filtering conditions in the definition itself, when this view entity is being queried in the code, these filteringconditions need not be explicitly specified. So taking the view definition in the start of this trail, when i query PartyRoleAndPersonExt from webtools like this ( http://localhost:8080/webtools/control/FindGeneric?entityName=PartyRoleAndPersonExtfind=trueVIEW_SIZE=50VIEW_INDEX=0 ), the result should show details of person having role type SALES_REP only. On Sun, Aug 15, 2010 at 3:06 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: What results are you expecting and what results do you get? Jacques From: varun bhansaly vbhans...@gmail.com Hi Jacques, The view surely does not give the results. Moreover, if i look at the raw SQL sent to db server, it doesnt include the conditions mentioned in condition expr. On Sun, Aug 15, 2010 at 1:32 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: You say it seems, don't the view give you the results you want? Jacques From: varun bhansaly vbhans...@gmail.com Hi, I have written a view entity, as shown below, the intention is to perform inner join b/w two entities a further condition. But after looking at the raw SQL, it seems entity engine seems to ignore entity condition tag. view-entity entity-name=PartyRoleAndPersonExt package-name=org.ofbiz.custom title=party role and party detail member-entity entity-alias=PR entity-name=PartyRole/ member-entity entity-alias=PERSON entity-name=Person/ alias-all entity-alias=PRexclude field=partyId//alias-all alias entity-alias=PERSON name=personPartyId field=partyId/ alias entity-alias=PERSON name=firstName/ alias entity-alias=PERSON name=lastName/ alias entity-alias=PERSON name=middleName/ view-link entity-alias=PR rel-entity-alias=PERSON key-map field-name=partyId/ /view-link entity-condition condition-expr field-name=roleTypeId value=SALES_REP entity-alias=PR/ /entity-condition /view-entity Am i missing anything ? Is there any other way to specify extra conditions in the view entity definition itself ? -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: set to NULL in SECAs
Hi Scott, I had already seen the implementations in ServiceEcaSetField.java. I would not want to introduce yet another SECA to remove partyId. Guess introducing a value such (as setToNull) for the format attribute would not break any thing else. Thanksm On Tue, Jul 20, 2010 at 11:57 AM, Scott Gray scott.g...@hotwaxmedia.comwrote: So you want some of the results from CC to go into CA but not all of them? I think the code only allows for an all or nothing approach, the only real workaround is to add another service that manually calls CC but does not return the unwanted fields. You're welcome to look at the implementations yourself, they're in ServiceEcaAction.java and ServiceEcaSetField.java. Perhaps ideally a SECA action would provide a bit more flexibility similar to what we have in the minilang call-service attribute whereby you can use child elements to specify exactly what should be done with each result field. Regards Scott On 20/07/2010, at 5:06 PM, varun bhansaly wrote: The issue is with attribute name = partyId both CC CA are custom services working fine independently. partyId comes in the output of CC, the idea is to either 1. reset partyId to null OR 2. not to send it in input to CA. for 2. I have tried with result-map-name attribute, but it remains the same (as observed while context is printing in CA). I would not want to change any of the input output params since they work fine independently. Thanks On Tue, Jul 20, 2010 at 10:14 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: I'm guessing here that you want service2 to be triggered before service1 and ultimately have it alter the value of attribute1 before it gets passed to service1? If so, then just define attribute1 as INOUT and then modify it inside service2 and get rid of attribute2 altogether. Regards Scott HotWax Media http://www.hotwaxmedia.com On 20/07/2010, at 4:26 PM, varun bhansaly wrote: Thanks Jacques, Scott, is there any other way to achieve the same w/o customizing the framework code ? This is the actual problem http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html Thanks, On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: Won't work, I'm pretty sure nothing will after looking at the code. Regards Scott HotWax Media http://www.hotwaxmedia.com On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote: Try nullField, ie set field-name=attribute1 value=nullField/ Jacques From: varun bhansaly vbhans...@gmail.com Hi, I am implementing a scenario using SECAs, where in it would be required to set a field to NULL or empty string. Is it possible to set a field to NULL using the set tags of eca xmls. I've tried with set field-name=attribute1 value=/ but this does not set attribute1 to empty string -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
query on SECA definition
Hi,
I am facing issues with attribute result-map-name in my SECA definition
Listed below is the scenario i am trying to implement
Service definitions -
service name=CA engine=java location=locationName1
invoke=functionName1
attribute name=attribute1 type=String mode=IN optional=true/
attribute name=partyId type=String mode=INOUT optional=true/
/service
service name=CC engine=java location=locationName2
invoke=functionName2
attribute name=attribute1 type=String mode=IN optional=true/
!-- This is an auto generated id generated by the framework --
attribute name=attribute2 type=String mode=OUT optional=true/
!-- This is an auto generated id generated by the framework --
attribute name=partyId type=String mode=INOUT optional=true/
/service
SECA definition -
eca service=CA event=invoke
action service=CC mode=sync result-to-context=false
result-map-name=result/
set field-name=attribute1 env-name=${result.attribute2}/
/eca
The problem -
For each invocation of service CA, same result map result remains the
same until unless server is restarted. Is there any thing wrong with the
SECA definition ?
Also, Is there any way to set a field name as null in SECA set tags -
I've tried with set field-name=attribute1 value=/ but this does not
set attribute1 to empty string
--
Regards,
Varun Bhansaly
query regarding SECAs
Hi,
I am facing issues with attribute result-map-name in my SECA definition
Listed below is the scenario i am trying to implement
Service definitions -
service name=CA engine=java location=locationName1
invoke=functionName1
attribute name=attribute1 type=String mode=IN optional=true/
attribute name=partyId type=String mode=INOUT optional=true/
/service
service name=CC engine=java location=locationName2
invoke=functionName2
attribute name=attribute1 type=String mode=IN optional=true/
!-- This is an auto generated id generated by the framework --
attribute name=attribute2 type=String mode=OUT optional=true/
!-- This is an auto generated id generated by the framework --
attribute name=partyId type=String mode=INOUT optional=true/
/service
SECA definition -
eca service=CA event=invoke
action service=CC mode=sync result-to-context=false
result-map-name=result/
set field-name=attribute1 env-name=${result.attribute2}/
/eca
The problem -
For each invocation of service CA, same result map result remains the
same until unless server is restarted. Is there any thing wrong with the
SECA definition ?
Also, Is there any way to set a field name as null in SECA set tags -
I've tried with set field-name=attribute1 value=/ but this does not
set attribute1 to empty string
--
Regards,
Varun Bhansaly
set to NULL in SECAs
Hi, I am implementing a scenario using SECAs, where in it would be required to set a field to NULL or empty string. Is it possible to set a field to NULL using the set tags of eca xmls. I've tried with set field-name=attribute1 value=/ but this does not set attribute1 to empty string -- Regards, Varun Bhansaly
Re: set to NULL in SECAs
The issue is with attribute name = partyId both CC CA are custom services working fine independently. partyId comes in the output of CC, the idea is to either 1. reset partyId to null OR 2. not to send it in input to CA. for 2. I have tried with result-map-name attribute, but it remains the same (as observed while context is printing in CA). I would not want to change any of the input output params since they work fine independently. Thanks On Tue, Jul 20, 2010 at 10:14 AM, Scott Gray scott.g...@hotwaxmedia.comwrote: I'm guessing here that you want service2 to be triggered before service1 and ultimately have it alter the value of attribute1 before it gets passed to service1? If so, then just define attribute1 as INOUT and then modify it inside service2 and get rid of attribute2 altogether. Regards Scott HotWax Media http://www.hotwaxmedia.com On 20/07/2010, at 4:26 PM, varun bhansaly wrote: Thanks Jacques, Scott, is there any other way to achieve the same w/o customizing the framework code ? This is the actual problem http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html Thanks, On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray scott.g...@hotwaxmedia.com wrote: Won't work, I'm pretty sure nothing will after looking at the code. Regards Scott HotWax Media http://www.hotwaxmedia.com On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote: Try nullField, ie set field-name=attribute1 value=nullField/ Jacques From: varun bhansaly vbhans...@gmail.com Hi, I am implementing a scenario using SECAs, where in it would be required to set a field to NULL or empty string. Is it possible to set a field to NULL using the set tags of eca xmls. I've tried with set field-name=attribute1 value=/ but this does not set attribute1 to empty string -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Want to hear a story of how automatic services gets fired :)
Hi Sakthi, this will help understand https://cwiki.apache.org/confluence/display/OFBTECH/Service+Engine+Guide On Fri, Jul 16, 2010 at 2:34 AM, BJ Freeman bjf...@free-man.net wrote: forgot this one https://demo-trunk.ofbiz.apache.org/webtools/control/scheduleJob sakthi vadivel sent the following on 7/15/2010 11:24 AM: hiii folks I am just new to ofbiz, i have read through the post Password Expiry there i read about Running a nightly job. I want to know how nightly jobs are triggered, which caused it to run, on which basis its gets triggered, which process is parent of this nightly jobs and automatic async services and what ECA will do for us. If anyone kindly explains it and an example service name (to find out code) it'll be very helpful for me to get overall imagination of the system functioning. regards sakthi -- Regards, Varun Bhansaly
Re: OFBIZ
This might help https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers Thanks, On Wed, Jul 14, 2010 at 5:01 PM, Mateus Medice mateus.med...@gmail.comwrote: Good morning guys!!! How are You? Fine? hehehe I'll see de price of the books and buy, this is the way... hehehe, So, I would wanna ask you!!! If you know ONE big store that use the OFBiz as a ecommerce. I Need to see some reals exemples!!! Please, I Need to see!!! Since the documentation that I need to pay, I think some links of companies that use the OFBiz would be free Thanks, Mateus Medice -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-tp2282914p2288592.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly
