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 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
Re: Apachecon EU 2012
Pierre, I'm not a member of the PMC (as far as I know ;-) and unfortunately I don't have much time at the moment. I believe the organization (at least parts of) of ApacheCon is hapening on the public mailing list 'apachecon-discuss' (see http://www.apache.org/foundation/mailinglists.html for subscription info and archives) What do others think, does it make sense to have an OFBiz Track/Day (as we had one in the past IIRC) at ApacheCon EU? Christian Pierre Smits schrieb: Christian, As you are one of our pmc members, can you coordinate with the team of ApacheCon EU 2012? Regards, Pierre 2012/6/21 Christian Geisert christian.geis...@isu-gmbh.de Pierre Smits schrieb: Dear All, ApacheCON EU 2012 will be held in Sinsheim , Germany on November, 5th till 9th. I was wondering if there intentions to participate and/or hold some presentations or get-togethers. As I'm living less than 100 km away from the location I'll be there (if time permits). Some kind of OFBiz get-together would be great. Christian
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: Regarding ProductGeo entity
Hello Varun, The productId for which you are trying to create a row in Product_Geo , exist in product table also? Thanks Nandani On Mon, Jul 2, 2012 at 1:52 PM, varun bhansaly vbhans...@gmail.com 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
Re: get random entries from entity field
By default it gives you latest records, for getting it in your way pass the orderBy list. Also see the delegator.findListItereatorByCondition() method. -- Rishi Solanki Manager, Enterprise Software Development HotWax Media Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxmedia.com On Mon, Jul 2, 2012 at 12:18 AM, Robert G. g...@mercon24.de wrote: I should read better :) Ok when I say get N records, does it mean getting the latest N records? Or is it randomly from all? -- View this message in context: http://ofbiz.135035.n4.nabble.com/get-random-entries-from-entity-field-tp4634190p4634309.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Regarding ProductGeo entity
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
http://bigfiles.ofbiz.org/ is missing
FYI: https://issues.apache.org/jira/browse/INFRA-4996 Jacques
Re: get random entries from entity field
You have to pass fieldToSelect as an Set, Use UtilMisc.toSet(field); e.g SetString fieldToSelect = UtilMisc.toSet(field); Thanks Regards -- Deepak Dixit HotWax Media Pvt. Ltd. www.hotwaxmedia.com Contact :- +91-98267-54548 Skype :- deepakdixit On Jul 2, 2012, at 3:42 PM, Robert G. wrote: Hey, I tried to use this method: /public ListGenericValue findList(String entityName, EntityCondition entityCondition, SetString fieldsToSelect, ListString orderBy, EntityFindOptions findOptions, boolean useCache) throws GenericEntityException;/ Now I understood, that I can choose the columns of the database table which I wanna get with: SetString fieldsToSelect is that right? but how do the Set does have to look? I checked the java API ref, but couldnt find an example. If I just give a string (name of the column) to the method, I get an error. please help me on that. Thank you. -- View this message in context: http://ofbiz.135035.n4.nabble.com/get-random-entries-from-entity-field-tp4634190p4634321.html Sent from the OFBiz - User mailing list archive at Nabble.com. smime.p7s Description: S/MIME cryptographic signature
Re: Calculate the weight of product from its components
Pierre, Thank you for your valuable response. I will work on finding a way to achieve that, and will back to you and for the community for feedback and discussion. Regards, Medhat On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] ml-node+s135035n463428...@n4.nabble.com wrote: Medhat, Currenty there isn't in ProdCat nor in MFG a function that aggregates weights or prices of components/sub assemblies in the end product. It would definitely be a valuable addition to the usability of both application. However, you can add the total to the end products manually. Regards, Pierre 2012/7/1 Medhat [hidden email]http://user/SendEmail.jtp?type=nodenode=4634281i=0 Hi, I have a product Manufactured from many products or raw materials Example: Product A has a weight 1Kg Product B has a weight 0.5Kg Product C is a result of assembling 1 unit of Product A 2 units of Product B Product C has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg My Question is: Is there a way to let ofbiz Calculates the weight of Product C Using weights of products A B as inputs ? Appreciating your help and Advice. Regards, Medhat -- View this message in context: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html To unsubscribe from Calculate the weight of product from its components, click herehttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4634261code=bWVkaGF0NzE3M0BnbWFpbC5jb218NDYzNDI2MXwtMTc1NzAwODA1OA== . NAMLhttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: get random entries from entity field
ok, I think this is my last question concerning this subject :) I get a list with delegator.findList(...) f.ex. for the Entity ProductReview I get: /{[GenericEntity:ProductReview][productId,1(java.lang.String)][productReview,this is an example review no. 1(java.lang.String)][userLoginId,admin(java.lang.String)], [GenericEntity:ProductReview][productId,1(java.lang.String)][productReview,this is an example review no. 2(java.lang.String)][userLoginId,admin(java.lang.String)]} / now I want to add a key value pair to both entries of this list. I could only succeed when I change a value of an existing key, but adding a new K-V combination I could not succeed. I also tried it with UtilMisc.addToSetInList, but couldnt get it work. Do someone know the solution? I want a result like (bold marked is new): /{[GenericEntity:ProductReview][productId,1(java.lang.String)][productReview,this is an example review no. 1(java.lang.String)][userLoginId,admin(java.lang.String)]*[newValue,thisIsTheNewValue(java.lang.String)]*, [GenericEntity:ProductReview][productId,1(java.lang.String)][productReview,this is an example review no. 2(java.lang.String)][userLoginId,admin(java.lang.String)]*[newValue,thisIsTheNewValue(java.lang.String)]*} / -- View this message in context: http://ofbiz.135035.n4.nabble.com/get-random-entries-from-entity-field-tp4634190p4634361.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Calculate the weight of product from its components
Hi, Another Question, I have a product stored in the Inventory with UOM Kg and sold with different UOM gm. Dose ofbiz make this conversion by it self ? Appreciating your help and Advice. Regards, Medhat On Mon, Jul 2, 2012 at 7:05 PM, Medhat medhat7...@gmail.com wrote: Pierre, Thank you for your valuable response. I will work on finding a way to achieve that, and will back to you and for the community for feedback and discussion. Regards, Medhat On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] ml-node+s135035n463428...@n4.nabble.com wrote: Medhat, Currenty there isn't in ProdCat nor in MFG a function that aggregates weights or prices of components/sub assemblies in the end product. It would definitely be a valuable addition to the usability of both application. However, you can add the total to the end products manually. Regards, Pierre 2012/7/1 Medhat [hidden email] http://user/SendEmail.jtp?type=nodenode=4634281i=0 Hi, I have a product Manufactured from many products or raw materials Example: Product A has a weight 1Kg Product B has a weight 0.5Kg Product C is a result of assembling 1 unit of Product A 2 units of Product B Product C has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg My Question is: Is there a way to let ofbiz Calculates the weight of Product C Using weights of products A B as inputs ? Appreciating your help and Advice. Regards, Medhat -- View this message in context: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html To unsubscribe from Calculate the weight of product from its components, click here http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4634261code=bWVkaGF0NzE3M0BnbWFpbC5jb218NDYzNDI2MXwtMTc1NzAwODA1OA== . NAML http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html Sent from the OFBiz - User mailing list archive at Nabble.com.