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
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&PASSWORD=xxx&JavaScriptEnabled=N
Here's the thing.. Eventually, you're going to make hack
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) that
> accepts just th
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 own custom xmlrpc server
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 parameter" in lieu of "Ther
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 allows me
> to specify the data
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 usi
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 toT
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, Raj
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 |
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
> string if the string did
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 locale
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 Development
> HotWax Systems Pvt
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,
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 c
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
wrote:
> Hi R
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 update product price then all prim
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).
lookedUpVa
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 Dixi
19 matches
Mail list logo