Re: help with updateProductPrice

Hi Mike , I concur with you. In fact i am already taking such an approach of directly connecting to DB . Instead of XML RPC its JSON in my case. So my client software connects to a non-OfBiz App server. The Appserver tries to accomplish the task using a documented WebService interface using

Re: help with updateProductPrice

Just make your DB updates, then make an API call or use wget to clear the cache. For instance: wget --no-check-certificate -T 360 https://IP_ADDRESS/webtools/control/FindUtilCacheClearAll?USERNAME=admin=xxx=N Here's the thing.. Eventually, you're going to make hacks to satisfy various

Re: help with updateProductPrice

Hi Mike , moreover there is the factor of Caching at various levels . If you directly interact with DB , i feel the caches may become stale . regds Mallah. On Tue, Apr 17, 2018 at 9:17 PM, Mike wrote: > Why not just write your own custom xmlrpc server (perl/python/java)

Re: help with updateProductPrice

Its always not that straightforward. I tend to use webservices as it provides consistent results and you do not have to "reverse engineer" . Moreover things should work as advertised (documented) ! On Tue, Apr 17, 2018 at 9:17 PM, Mike wrote: > Why not just write your

Re: help with updateProductPrice

Why not just write your own custom xmlrpc server (perl/python/java) that accepts just the P/N and new price, searches for the current record, and performs a SQL call to update the DB. On Tue, Apr 17, 2018 at 8:12 AM, Rajesh Mallah wrote: > ERRATA: I meant "There is no

Re: help with updateProductPrice

ERRATA: I meant "There is no parameter" in lieu of "There is parameter" On Tue, Apr 17, 2018 at 8:09 PM, Rajesh Mallah wrote: > > Hi Rishi , > > I am using XML RPC with OFBiz so my capabilities are limited to > what the interface provides. There is parameter that

Re: help with updateProductPrice

Hi Rishi , I am using XML RPC with OFBiz so my capabilities are limited to what the interface provides. There is parameter that allows me to specify the data format/pattern . At this moment i have solved my problem temporarily by appending .001 after the second part in HH:MM:SS and i am only

Re: help with updateProductPrice

Idea of utility class is, use the format you would like and pass the value. It will convert into timestamp used in the table. In case you could not get the desired format in the utility class then the class uses the java.text.SimpleDateFormat class to resolve its purpose. Please take a look at

Re: help with updateProductPrice

Further Info: fromDate In XML results in from_date | 2018-04-17 14:59:34.001+05:30 in DB. looks like the parser is kind enough to consider TZ spec without colons. regds mallah. On Tue, Apr 17, 2018 at 2:42 PM,

Re: help with updateProductPrice

Its PostgreSQL regds below is a sample data : SQL> select * from ofbiz.product_price where product_id='PROD_SW52D5H3EN' order by created_date desc limit 1; -[ RECORD 1 ]---+-- product_id | PROD_SW52D5H3EN product_price_type_id |

Re: help with updateProductPrice

Hi Rajesh, Could you please share which database you are using? Thanks & Regards -- Deepak Dixit www.hotwax.co On Tue, Apr 17, 2018 at 2:36 PM, Rajesh Mallah wrote: > Hi , > > > it was in conversion/DateTimeConverters.java that was appending '.0' to > the > end of >

Re: help with updateProductPrice

Hi , it was in conversion/DateTimeConverters.java that was appending '.0' to the end of string if the string did not contain any decimals. So i have now started sending the fractional seconds. And things are better (if not perfect). public java.sql.Timestamp convert(String obj, Locale

Re: help with updateProductPrice

Thanks Rishi. On Tue, Apr 17, 2018 at 2:08 PM, Rishi Solanki 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

Re: help with updateProductPrice

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,

Re: help with updateProductPrice

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

Re: help with updateProductPrice

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

Re: help with updateProductPrice

Thanks . This is possibly the reason , shall check and confirm. However it is difficult to match datetime fields *exactly* when integrating external systems . regds mallah. On Tue, Apr 17, 2018 at 10:25 AM, Akash Jain wrote: > Hello Mallah, > > As you want to

Re: help with updateProductPrice

Hello Mallah, As you want to update product price then all primary key (productId, fromDate, currencyUomId, productPricePurposeId, productPriceTypeId and productStoreGroupId) of ProductPrice should be matched (A ProductPrice record should exist with all matching primary key you passed).

Re: help with updateProductPrice

Hi Rajesh, If you want to create product price you should use createProductPrice service, https://demo-stable.ofbiz.apache.org/webtools/control/ServiceList?sel_service_name=createProductPrice If productPrice record already exists you should use updateProductPrice, Thanks & Regards -- Deepak

help with updateProductPrice

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