Re: Update entity product - mass update for producut price
su2 wrote: Will this XMLRPC work with the "WHERE" clause. I have 4000+ items/rows to update with "WHERE" clause. My Sample query I want to execute is UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123' Can please somebody help me with this? Thank you. Su- First you have to create an ofbiz service which takes the productId(your where clause) and fields to update (wight for example). Then using xmlrpc you can call this service for each line (4000 times) Bilgin
Re: Update entity product - mass update for producut price
Will this XMLRPC work with the "WHERE" clause. I have 4000+ items/rows to update with "WHERE" clause. My Sample query I want to execute is UPDATE PRODUCT SET WEIGHT = 1 WHERE PRODUCT_ID = 'xyz123' Can please somebody help me with this? Thank you. Su- -- View this message in context: http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1460329.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Update entity product - mass update for producut price
For more details on XML-RPC please have a look on http://ws.apache.org/xmlrpc/. Using XML-RPC libraries you can call OFBiz services remotely by setting attribute export="true" in service definition. For more details you can refer existing code OOTB. Refer XmlRpc*.java files & refer "xmlrpc" controller entry in webtools component. HTH! -- Ashish On Mon, Jan 25, 2010 at 9:55 PM, su2 wrote: > > Thank you Jeroen for the reply. > > Can you please elaborate the 'calling services through the XML-RPC > interface.' > > As what I understood from webtools > XML import i can import data, but i > want to update data that means I will have "WHERE" condition while updating > the tables/entities. > > I am looking into Talend Open Studio. > > Thank you. > su- > -- > View this message in context: > http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289508.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Update entity product - mass update for producut price
Hi, Have a look at the ImprotProductServices.java >> productImportFromSpreadsheet. More you find at - http://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Mon, Jan 25, 2010 at 8:17 PM, su2 wrote: > > Hello All, > > We have requirement where we need to do mass update on product price(also > few other things, supplier etc) once every two weeks, we have thousands of > products for which manual updates are not possible. > > I would really appreciate if someone can give me some idea. We have > ProductID and Product Price in one excel. > > Thank you in advance. > Su- > > > -- > View this message in context: > http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Update entity product - mass update for producut price
Thank you Jeroen for the reply. Can you please elaborate the 'calling services through the XML-RPC interface.' As what I understood from webtools > XML import i can import data, but i want to update data that means I will have "WHERE" condition while updating the tables/entities. I am looking into Talend Open Studio. Thank you. su- -- View this message in context: http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289508.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Update entity product - mass update for producut price
Hi Su, We've used Talend Open Studio in a project to upload data from various sources by calling services through the XML-RPC interface. Jeroen van der Wal Stromboli b.v. +31 655 874050 On Mon, Jan 25, 2010 at 3:47 PM, su2 wrote: > > Hello All, > > We have requirement where we need to do mass update on product price(also > few other things, supplier etc) once every two weeks, we have thousands of > products for which manual updates are not possible. > > I would really appreciate if someone can give me some idea. We have > ProductID and Product Price in one excel. > > Thank you in advance. > Su- > > > -- > View this message in context: > http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Update entity product - mass update for producut price
Hello All, We have requirement where we need to do mass update on product price(also few other things, supplier etc) once every two weeks, we have thousands of products for which manual updates are not possible. I would really appreciate if someone can give me some idea. We have ProductID and Product Price in one excel. Thank you in advance. Su- -- View this message in context: http://n4.nabble.com/Update-entity-product-mass-update-for-producut-price-tp1289414p1289414.html Sent from the OFBiz - User mailing list archive at Nabble.com.