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)

Best Practice Uploading Sales Orders

When you first launch Ofbiz it is extremely important to upload Open Sales, Open Purchase Orders, Trial Balances as well as initial inventory quantities and open accounts receivable and open accounts payable. This is a minimum to get a corporate system ready to utilize. Now comes the question.

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: [MODERATE EMAIL] Wiki edit request

Hi Mathieu, Le 17/04/2018 à 12:22, Mathieu Lirzin a écrit : Hello Jacques, Jacques Le Roux writes: Le 17/04/2018 à 11:33, Mathieu Lirzin a écrit : Sharan Foga writes: I couldn't find your name in the list of people who have an ICLA.

Re: [MODERATE EMAIL] Wiki edit request

Hi Chris, Thanks for the idea but this is not in hour hands but ASF infra team http://www.apache.org/dev/infra-contact Only moderation is. Sincerely the ASF uses ezmlm for handling its ML, and I doubt the infra will change anything there ;) Imagine, the infra

RE: Price Rule Engine

Scott Thanks a Bunch! I just solved my question below with your help. I added 3 actions. -100% of List 100% Average Cost Percent of Margin ...and it worked perfectly. Final questions. 1. Is there away that the system can default all users to List Price instead of Default Price? 2. Is there

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: [MODERATE EMAIL] Wiki edit request

No what you guys should is this... Have a list of maillist users in an array... say mailListUsers On all incoming mail to the mail list do some soft of indexOf(mailListUsers); Than a conditional if indexOf(mailListUsers) > -1 { sendMail... (However you do it) }; if indexOf(mailListUsers) <

RE: Price Rule Engine

That sounds awesome! So how does two actions work with each other. How would you configure the following using multiple actions! Avg Cost + Percent of Margin Thanks Scott!! Original Message Subject: Re: Price Rule Engine From: Rishi Solanki Date:

Re: [MODERATE EMAIL] Wiki edit request

Hi Deepak, It's great to have the  [MODERATE EMAIL] prefix on the 1st moderated message. But then people reuse the subject prefix w/o removing the prefix and it's confusing. I think we should not add this prefix to avoid this confusion Thanks Jacques Le 17/04/2018 à 06:32, Deepak Dixit a

Re: [MODERATE EMAIL] Wiki edit request

Hello Jacques, Jacques Le Roux writes: > Le 17/04/2018 à 11:33, Mathieu Lirzin a écrit : >> >> Sharan Foga writes: >> >>> I couldn't find your name in the list of people who have an >>> ICLA. Please can you complete one. We ask all contributors

Re: How to resolve CSRF attack

Ahh ok makes sense, you know to first sign up for the list serv before you hit it up xD... On Tue, Apr 17, 2018, 4:27 AM Jacques Le Roux, wrote: > It means that the person sends a message to the ML w/o being subscribed to > it. So we (moderators) have to allow this

Re: [MODERATE EMAIL] Wiki edit request

Hi Mathieu No worries. Normally when people request access to our wiki, if they don’t have an ICLA then I send them the link to the contributors page to take a look at because it includes a link to the discussion about introducing it, when it was introduced (in November 2014) and what it

Re: [MODERATE EMAIL] Wiki edit request

Hi  Mathieu, Le 17/04/2018 à 11:33, Mathieu Lirzin a écrit : Hello Sharan, Sharan Foga writes: I couldn't find your name in the list of people who have an ICLA. Please can you complete one. We ask all contributors to complete one before we give access to our wiki. Indeed

Re: How to resolve CSRF attack

Hi Paul, I tried hard to use it 9 months ago but did not succeed. I even then inadvertently committed my then WIP work and then removed it at http://svn.apache.org/viewvc?view=revision=1799243 I also tried the Tomcat RestCsrfPreventionFilter see my comment in OFBIZ-6766 at

Re: [MODERATE EMAIL] Wiki edit request

Hello Sharan, Sharan Foga writes: > I couldn't find your name in the list of people who have an > ICLA. Please can you complete one. We ask all contributors to complete > one before we give access to our wiki. Indeed I was unaware of this requirement. Maybe the wording in

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: How to resolve CSRF attack

It means that the person sends a message to the ML w/o being subscribed to it. So we (moderators) have to allow this message to pass. Jacques Le 17/04/2018 à 04:49, Chris Clark a écrit : What does yoyr message has been moderated mean? On Mon, Apr 16, 2018, 3:00 AM Sonali Agrahari,

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: Price Rule Engine

+1 it will work for sure. Thank you Scott for the trick, loving it. Thanks again! 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 11:45 AM, Scott Gray

Re: [MODERATE EMAIL] Wiki edit request

Hi Mathieu I couldn't find your name in the list of people who have an ICLA. Please can you complete one. We ask all contributors to complete one before we give access to our wiki. You can find details of how to do it on our contributors page:

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: [MODERATE EMAIL] Wiki edit request

Hello, Deepak Dixit writes: > Your email has been moderated, please subscribe mailing list > http://ofbiz.apache.org/mailing-lists.html Done. Thanks. -- Mathieu Lirzin GPG: F2A3 8D7E EB2B 6640 5761 070D 0ADE E100 9460 4D37

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: Price Rule Engine

Have you tried setting the list price to zero? Alternatively, if you want to maintain a value in list price then use two price rule actions: 1. Percentage of list price: -100 2. Percentage of average cost: 130 That should set the first modifier to effectively zero the starting price, and then