Thanks Rishi. On Tue, Apr 17, 2018 at 2:08 PM, Rishi Solanki <rishisolan...@gmail.com> wrote:
> UtilDateTime is the utility class, add the time format support you want and > use it. Most format supported by this utility class OFBiz have. > > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > On Tue, Apr 17, 2018 at 12:27 PM, Rajesh Mallah <mallah.raj...@gmail.com> > wrote: > > > Now I am passing "2018-04-17 12:09:17+05:30" as fromDate , > > Which is the value picked up from the DB column. > > > > Even at XML level the string is preserved , but at some stage after > > hitting tomcat it becomes: "2018-04-17 12:09:17+05:30.0" > > > > which is not parseable. > > > > |W| [ModelService.makeValid] : Type conversion of field [fromDate] to > type > > [java.sql.Timestamp] failed f > > or value "2018-04-17 12:09:17+05:30": > > org.apache.ofbiz.base.util.GeneralException: java.text.ParseException: > > Unparseable date: "2018-04-17 12:09:17+05:30.0" (java.text.ParseExceptio > > n: Unparseable date: "2018-04-17 12:09:17+05:30.0") > > > > > > <!--- snippet from the XML-RPC --> > > > > <member> > > <name>fromDate</name> > > <value> > > <string><![CDATA[2018-04-17 12:09:17+05:30]]></string> > > </value> > > </member> > > > > <!-- end of snippet --> > > > > > > > > > > regds > > mallah. > > > > > > On Tue, Apr 17, 2018 at 11:08 AM, Rajesh Mallah <mallah.raj...@gmail.com > > > > wrote: > > > > > Hello Mr Deepak , > > > > > > Thanks for the response . The record does exists but i guess > > > i am not specifying the params good enough to hit the record > > > by pkey. > > > > > > I wish there were a "product_price_id" in ProductPrice entity. :-) > > > > > > regds > > > mallah. > > > > > > > > > > > > > > > > > > On Tue, Apr 17, 2018 at 9:58 AM, Deepak Dixit <deepak.di...@hotwax.co> > > > wrote: > > > > > >> Hi Rajesh, > > >> > > >> If you want to create product price you should use createProductPrice > > >> service, > > >> https://demo-stable.ofbiz.apache.org/webtools/control/Servic > > >> eList?sel_service_name=createProductPrice > > >> > > >> If productPrice record already exists you should use > updateProductPrice, > > >> > > >> Thanks & Regards > > >> -- > > >> Deepak Dixit > > >> Director of Product Engineering > > >> HotWax Commerce <https://hotwax.co/> > > >> > > >> On Mon, Apr 16, 2018 at 11:42 PM, Rajesh Mallah < > > mallah.raj...@gmail.com> > > >> wrote: > > >> > > >> > Hi , > > >> > > > >> > I am calling > > >> > > > >> > https://demo-stable.ofbiz.apache.org/webtools/control/ > > >> > ServiceList?sel_service_name=updateProductPrice > > >> > > > >> > with ARGS > > >> > > > >> > { > > >> > currencyUomId "INR", > > >> > fromDate "2018-04-16 17:39:52", > > >> > price 150, > > >> > productId "PROD_SW52D5H3EN", > > >> > productPricePurposeId "PURCHASE", > > >> > productPriceTypeId "DEFAULT_PRICE", > > >> > productStoreGroupId "_NA_", > > >> > taxInPrice "Y", > > >> > termUomId "WT_kg" > > >> > } > > >> > > > >> > > > >> > I am getting error: > > >> > > > >> > > > >> > faultString:Error running the simple-method: Entity value not found > > with > > >> > name: lookedUpValue Method = updateProductPrice, File = > > >> > file:/opt/ofbiz/apache-ofbiz-16.11.04/applications/product/ > > >> > minilang/product/price/PriceServices.xml, > > >> > Element = <set-nonpk-fields>, Line 69null > > >> > > > >> > > > >> > the minilang def is reproduced here for convinience: > > >> > > > >> > <simple-method method-name="updateProductPrice" > > >> short-description="Update > > >> > an ProductPrice"> > > >> > <set field="callingMethodName" value="updateProductPrice"/> > > >> > <set field="checkAction" value="UPDATE"/> > > >> > <call-simple-method method-name=" > > checkProductRelatedPermission" > > >> > xml-resource="component://product/minilang/product/ > > >> > product/ProductServices.xml"/> > > >> > <check-permission permission="CATALOG_PRICE_MAINT"> > > >> > <fail-property resource="ProductUiLabels" > > >> > property="ProductPriceMaintPermissionError"/> > > >> > </check-permission> > > >> > <check-errors/> > > >> > > > >> > <call-simple-method method-name=" > > inlineHandlePriceWithTaxInclud > > >> > ed"/> > > >> > > > >> > <entity-one entity-name="ProductPrice" > > >> > value-field="lookedUpValue"/> > > >> > > > >> > <!-- grab the old price value before setting nonpk parameter > > >> fields > > >> > --> > > >> > <field-to-result field="lookedUpValue.price" > > >> > result-name="oldPrice"/> > > >> > > > >> > <set-nonpk-fields map="parameters" > > value-field="lookedUpValue"/> > > >> > > > >> > <now-timestamp field="nowTimestamp"/> > > >> > <set field="lookedUpValue.lastModifiedDate" > > >> > from-field="nowTimestamp"/> > > >> > <set field="lookedUpValue.lastModifiedByUserLogin" > > >> > from-field="userLogin.userLoginId"/> > > >> > > > >> > <store-value value-field="lookedUpValue"/> > > >> > </simple-method> > > >> > > > >> > The productID does exists in Entity ProductPrice > > >> > Where am I going wrong ? > > >> > > > >> > thanks & regds > > >> > Rajesh Mallah. > > >> > > > >> > > > > > > > > >
