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 XML/RPC or connects to DB directly and emulates part of the logic of OFBiz (in case XML/RPC Webservice) is insufficient/infeasible. thanks for the tip regarding Invalidating the caches. Is there any variant of the same to clear caches of a set of particular entities? regds mallah. On Wed, Apr 18, 2018 at 11:04 AM, Mike wrote: > 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 hacks to satisfy > various problems that come up. Making your own, custom xmlrpc/SOAP/REST is > well within the norm. If you make one (hack), like to make an easy fast > price updater, you'll start to use the same technique to solve another > problem. It's great to be a purist (if you can), but you have to have a > way of working around bugs. Just MHO. > > On Tue, Apr 17, 2018 at 10:14 PM, Rajesh Mallah > wrote: > > > 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 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 < > mallah.raj...@gmail.com> > > > wrote: > > > > > > > ERRATA: I meant "There is no parameter" in lieu of "There is > parameter" > > > > > > > > On Tue, Apr 17, 2018 at 8:09 PM, Rajesh Mallah < > > mallah.raj...@gmail.com> > > > > 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 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 using > > > > > createProductPrice instead of updateProductPrice . As creating new > > > > > prices allows to have a history/audit of prices. I feel > > > > updateProductPrice > > > > > is really overwriting the values and trail is lost. > > > > > > > > > > regds > > > > > mallah. > > > > > > > > > > > > > > > > > > > > > > > > > On Tue, Apr 17, 2018 at 6:49 PM, Rishi Solanki < > > > rishisolan...@gmail.com> > > > > > wrote: > > > > > > > > > >> 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 toTimestamp() method variations and format > you > > > are > > > > >> receiving in the xml. Once you have the format with you, it can be > > > > easily > > > > >> converted into timestamp. Also if utility class does not support > > then > > > go > > > > >> to > > > > >> core class for same i.e java.text.SimpleDateFormat and look for > the > > > > >> supporting format. > > > > >> > > > > >> HTH! > > > > >> > > > > >> > > > > >> 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 3:02 PM, Rajesh Mallah < > > > mallah.raj...@gmail.com > > > > > > > > > >> wrote: > > > > >> > > > > >> > 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, Rajesh Mallah < > > > > mallah.raj...@gmail.com > > > > >> > > > > > >> > wrote: > > > > >> > > > > > >> > > > > > > >> > > Its PostgreSQL > > > > >> > > regds > > > > >> > > > > > > >> > > > > > > >> > > below is a sample data : > > > > >> > > > > > > >> > > SQL> select * from ofbiz.product_price where > >
回复:答复: usage of product attributes
Hi Rajesh, Good to know. I am more focusing on back end erp functioning so I got you wrong. Have a nice day. B.R. Schumann +86-1800-150-1800 原始邮件 主题:Re: 答复: usage of product attributes 发件人:Rajesh Mallah 收件人:user@ofbiz.apache.org 抄送: Hi Schumann , I was wanting MOQ ( minimum order quantity ) for the purpose of selling the product. The MOQ under suppliers of product is for purchase. It does not hurt me in current application. Hence i am using product attribute only. regds mallah. On Mon, Apr 16, 2018 at 6:30 AM, Schumann Ye wrote: > Dear Rajesh, > > Have you tried using the tab "Suppliers" with the link below? > https://demo-stable.ofbiz.apache.org/catalog/control/EditProductSuppliers? > productId=WG-9943 > > If I understand your question correctly, MOQ in ERP/MRP II/MRP could be > used for business processes calculation like triggering a new purchase > requisition when a certain demand could not be met. > Normally it applies to the purchased item, however, theoretically it could > be also set for manufactured item. > > In your example, it's the latter case. > > Back to your another question, if you create a record for > "product_attribute", which gives us only a link between product_id and the > attr_name/attr_value. > Based on what I have seen in MrpServices.java, it seems the field value of > "product_attribute" is not considered during MRP run. > So I think the chance is little. > > Let us know if there is any progress. > Thanks > > HIH. > > Schumann > > -邮件原件- > 发件人: Rajesh Mallah > 发送时间: 2018年4月14日 22:21 > 收件人: user@ofbiz.apache.org > 主题: usage of product attributes > > Hi , > > I wanted to store minimum order quantity (MOQ) at product level. > going by the OOTB product management screen eg: > > https://demo-stable.ofbiz.apache.org/catalog/control/ > EditProduct?productId=WG-9943 > i do not apparently see a place to store it. > > can/should I be using "Attributes" for storing such attributes ? > I also wanted to store "Maximum Order Quantity" and some more custom > details about the product. > > > regds > mallah. >
Re: 答复: usage of product attributes
Hi Rajesh, It is supported OOTB add product price of type MINIMUM_ORDER_PRICE so that your quantity get calculated. For example; If your selling price per piece is $100 and you want to set the minimum order quantity to 5, then set the MINIMUM_ORDER_PRICE as $500. Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Wed, Apr 18, 2018 at 6:10 PM, Schumann Ye wrote: > Hi Rajesh, > > Good to know. > I am more focusing on back end erp functioning so I got you wrong. > Have a nice day. > > B.R. > Schumann > +86-1800-150-1800 > > > 原始邮件 > 主题:Re: 答复: usage of product attributes > 发件人:Rajesh Mallah > 收件人:user@ofbiz.apache.org > 抄送: > > > Hi Schumann , > > I was wanting MOQ ( minimum order quantity ) for the purpose of > selling the product. The MOQ under suppliers of product is for purchase. > > It does not hurt me in current application. Hence i am using product > attribute > only. > > regds > mallah. > > > On Mon, Apr 16, 2018 at 6:30 AM, Schumann Ye > wrote: > > > Dear Rajesh, > > > > Have you tried using the tab "Suppliers" with the link below? > > https://demo-stable.ofbiz.apache.org/catalog/control/ > EditProductSuppliers? > > productId=WG-9943 > > > > If I understand your question correctly, MOQ in ERP/MRP II/MRP could be > > used for business processes calculation like triggering a new purchase > > requisition when a certain demand could not be met. > > Normally it applies to the purchased item, however, theoretically it > could > > be also set for manufactured item. > > > > In your example, it's the latter case. > > > > Back to your another question, if you create a record for > > "product_attribute", which gives us only a link between product_id and > the > > attr_name/attr_value. > > Based on what I have seen in MrpServices.java, it seems the field value > of > > "product_attribute" is not considered during MRP run. > > So I think the chance is little. > > > > Let us know if there is any progress. > > Thanks > > > > HIH. > > > > Schumann > > > > -邮件原件- > > 发件人: Rajesh Mallah > > 发送时间: 2018年4月14日 22:21 > > 收件人: user@ofbiz.apache.org > > 主题: usage of product attributes > > > > Hi , > > > > I wanted to store minimum order quantity (MOQ) at product level. > > going by the OOTB product management screen eg: > > > > https://demo-stable.ofbiz.apache.org/catalog/control/ > > EditProduct?productId=WG-9943 > > i do not apparently see a place to store it. > > > > can/should I be using "Attributes" for storing such attributes ? > > I also wanted to store "Maximum Order Quantity" and some more custom > > details about the product. > > > > > > regds > > mallah. > > >
Re: 答复: usage of product attributes
Thanks . Its doable i feel at least for MOQ On Wed, Apr 18, 2018 at 7:20 PM, Rishi Solanki wrote: > Hi Rajesh, > It is supported OOTB add product price of type MINIMUM_ORDER_PRICE so that > your quantity get calculated. > For example; > If your selling price per piece is $100 and you want to set the minimum > order quantity to 5, then set the MINIMUM_ORDER_PRICE as $500. > > > > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > On Wed, Apr 18, 2018 at 6:10 PM, Schumann Ye > wrote: > > > Hi Rajesh, > > > > Good to know. > > I am more focusing on back end erp functioning so I got you wrong. > > Have a nice day. > > > > B.R. > > Schumann > > +86-1800-150-1800 > > > > > > 原始邮件 > > 主题:Re: 答复: usage of product attributes > > 发件人:Rajesh Mallah > > 收件人:user@ofbiz.apache.org > > 抄送: > > > > > > Hi Schumann , > > > > I was wanting MOQ ( minimum order quantity ) for the purpose of > > selling the product. The MOQ under suppliers of product is for purchase. > > > > It does not hurt me in current application. Hence i am using product > > attribute > > only. > > > > regds > > mallah. > > > > > > On Mon, Apr 16, 2018 at 6:30 AM, Schumann Ye > > wrote: > > > > > Dear Rajesh, > > > > > > Have you tried using the tab "Suppliers" with the link below? > > > https://demo-stable.ofbiz.apache.org/catalog/control/ > > EditProductSuppliers? > > > productId=WG-9943 > > > > > > If I understand your question correctly, MOQ in ERP/MRP II/MRP could be > > > used for business processes calculation like triggering a new purchase > > > requisition when a certain demand could not be met. > > > Normally it applies to the purchased item, however, theoretically it > > could > > > be also set for manufactured item. > > > > > > In your example, it's the latter case. > > > > > > Back to your another question, if you create a record for > > > "product_attribute", which gives us only a link between product_id and > > the > > > attr_name/attr_value. > > > Based on what I have seen in MrpServices.java, it seems the field value > > of > > > "product_attribute" is not considered during MRP run. > > > So I think the chance is little. > > > > > > Let us know if there is any progress. > > > Thanks > > > > > > HIH. > > > > > > Schumann > > > > > > -邮件原件- > > > 发件人: Rajesh Mallah > > > 发送时间: 2018年4月14日 22:21 > > > 收件人: user@ofbiz.apache.org > > > 主题: usage of product attributes > > > > > > Hi , > > > > > > I wanted to store minimum order quantity (MOQ) at product level. > > > going by the OOTB product management screen eg: > > > > > > https://demo-stable.ofbiz.apache.org/catalog/control/ > > > EditProduct?productId=WG-9943 > > > i do not apparently see a place to store it. > > > > > > can/should I be using "Attributes" for storing such attributes ? > > > I also wanted to store "Maximum Order Quantity" and some more custom > > > details about the product. > > > > > > > > > regds > > > mallah. > > > > > >
Implement JOB
Hello I am looking for a way to implement a job to be able to do, for example, that at certain times of the day an information backup of OFBiz is executed. Where can I find an example of something similar or what would be the paths to follow? *Jonathan Cárdenas Vargas.*
Re: Implement JOB
OK On Apr 18, 2018 11:57 AM, "Jonathan Javier" wrote: Hello I am looking for a way to implement a job to be able to do, for example, that at certain times of the day an information backup of OFBiz is executed. Where can I find an example of something similar or what would be the paths to follow? *Jonathan Cárdenas Vargas.*
Re: OFBiz Blog - March 2018 Update
Great effort as usual folks. On every release we are reminded of how great and active our community is. On Mon, Apr 16, 2018 at 10:31 AM, Sharan Foga wrote: > Hi Everyone > > You can find the details of our monthly blog update at the link below:: > > https://s.apache.org/Hj05 > > Thanks to Michael, Jacques and Pranay for their continued support in > reviewing, providing feedback and helping preparing it. > > Thanks > Sharan
Re: Implement JOB
Backups at the database level are best. Depending on which database you use there are standard practices and lots of options. If you’re deploying fresh, you can look into something like Amazon Aurora or other hosted Postgres providers which handle backups for you. —P > On Apr 18, 2018, at 10:57, Jonathan Javier wrote: > > Hello > > I am looking for a way to implement a job to be able to do, for example, > that at certain times of the day an information backup of OFBiz is > executed. Where can I find an example of something similar or what would be > the paths to follow? > > *Jonathan Cárdenas Vargas.*
Re: Implement JOB
Hi Jonathan, which database do you use with OFBiz? Regards, Michael Am 18.04.18 um 17:57 schrieb Jonathan Javier: Hello I am looking for a way to implement a job to be able to do, for example, that at certain times of the day an information backup of OFBiz is executed. Where can I find an example of something similar or what would be the paths to follow? *Jonathan Cárdenas Vargas.* smime.p7s Description: S/MIME Cryptographic Signature
Re: Implement JOB
I currently use H2. The idea of being able to execute an automatic backup of the data was by way of example. I would really like to use scheduled tasks to run a special service every 3 hours during the day. Regards -- Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Re: Implement JOB
Hello Jonathan, If your problematic was run a service define on the service engine each 3 hours, follow this process: Go to https://yourserver/webtools/control/scheduleJob set field as : Service: your service name to run Frequency: 3 Interval: Hourly Count: -1 Max Retry: 0 leave all other field empty and submit. Set your parameters for the run and submit. Now on https://yourserver/webtools/control/FindJob your job will appear as Pending service Nicolas On 18/04/2018 21:11, Jonathan Javier wrote: I currently use H2. The idea of being able to execute an automatic backup of the data was by way of example. I would really like to use scheduled tasks to run a special service every 3 hours during the day. Regards -- Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html