automatic
Hello all , developping application from scratch, is there a way to genearete some xml files automatically ? ... or all screens, css, widgets , etc ... by hand ? Thank you for your help. Regards. G.Ben. -- View this message in context: http://ofbiz.135035.n4.nabble.com/automatic-tp4633291.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Automatic Purchasing
I'm having some difficulty getting Automatic Purchasing to work. I have set the RequirementsEnumMethod to a variety of values (PRODRQM_STOCK, PRODRQM_STOCK_ATP, PRODRQM_ATP) for some products, which are backordered. When I click on the Requirements shortcut from (Purchase) Orders I see no items in the Requirement list. What am I missing? -- Dave Tenerowicz [EMAIL PROTECTED] Office: 303.493.6727 Mobile 303.906.6116 Fax 303.814.8330 Visit us at http://www.salmonllc.com
Automatic Backorders?
I am trying figure out how to have a backorder generated automatically. I have tried various store settings and can't get anything to happen. I am expecting a Requirement (maybe that's wrong?) to be generated when I sell an item not in stock. I searched Naggle for "backorder" and found nothing on this topic (other than discussions on how to improve it). I am hoping somone will respond so I don't have to dig through the source code again. Skip
Re: automatic
You can execute ant create-component to create basic directory structure for an OFBiz component with some files such as screens etc. On Wed, Jun 6, 2012 at 8:30 PM, G.Ben wrote: > Hello all , > > developping application from scratch, is there a way to genearete some xml > files automatically ? ... or all screens, css, widgets , etc ... by hand ? > > Thank you for your help. > > Regards. > > G.Ben. > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/automatic-tp4633291.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > -- Regards, Varun Bhansaly
Re: automatic
Oh yes, I forgot about that command, thank you so much :) -- View this message in context: http://ofbiz.135035.n4.nabble.com/automatic-tp4633291p4633293.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Automatic data import
Hi all, I need to import some products from another database. I think that I can do it manually in the following way: 1- The other database generates some xml file with all the products to import in the ofbiz database and allow the access with one URL. 2- XML Data Import in the webtools application. My question now is, how can I make an automatic data import? I mean, for example, that every day ofbiz goes to the same URL and import the same file. Is this possible? Thanks in advance. -- View this message in context: http://www.nabble.com/Automatic-data-import-tp25746481p25746481.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Purchasing
Hello Dave, I am trying this to work also. Two tips, requirement type has to be product requirement (I got it created automatically with RequirementsEnumMethod set to automatic for every sales order, BTW what is ATP?). Also the requirement should be approved. Please give me a line if you get it to work. -- Daniel Dave Tenerowicz escribió: > I'm having some difficulty getting Automatic Purchasing to work. I > have set the RequirementsEnumMethod to a variety of values > (PRODRQM_STOCK, PRODRQM_STOCK_ATP, PRODRQM_ATP) for some products, > which are backordered. > > When I click on the Requirements shortcut from (Purchase) Orders I see > no items in the Requirement list. What am I missing? >
Re: Automatic Purchasing
ATP = Available to Promise, i.e. Quantity on Hand - Reservations = ATP Regards Scott On 11/06/07, Daniel Martínez <[EMAIL PROTECTED]> wrote: Hello Dave, I am trying this to work also. Two tips, requirement type has to be product requirement (I got it created automatically with RequirementsEnumMethod set to automatic for every sales order, BTW what is ATP?). Also the requirement should be approved. Please give me a line if you get it to work. -- Daniel Dave Tenerowicz escribió: > I'm having some difficulty getting Automatic Purchasing to work. I > have set the RequirementsEnumMethod to a variety of values > (PRODRQM_STOCK, PRODRQM_STOCK_ATP, PRODRQM_ATP) for some products, > which are backordered. > > When I click on the Requirements shortcut from (Purchase) Orders I see > no items in the Requirement list. What am I missing? >
Re: Automatic Purchasing
Well, I got it. The requirement should have at least a party with role SUPPLIER. This happens automatically if this is parametrized in the product screen. This leaves me wondering ... The only way a product requirement is candidate for a purchase order is that we already know a supplier for it. I will write an email for the dev list. Regards, -- Daniel Daniel Martínez escribió: > Hello Dave, > > I am trying this to work also. Two tips, requirement type has to be > product requirement (I got it created automatically with > RequirementsEnumMethod set to automatic for every sales order, BTW what > is ATP?). Also the requirement should be approved. > > Please give me a line if you get it to work. > -- > Daniel > > Dave Tenerowicz escribió: > >> I'm having some difficulty getting Automatic Purchasing to work. I >> have set the RequirementsEnumMethod to a variety of values >> (PRODRQM_STOCK, PRODRQM_STOCK_ATP, PRODRQM_ATP) for some products, >> which are backordered. >> >> When I click on the Requirements shortcut from (Purchase) Orders I see >> no items in the Requirement list. What am I missing? >> >>
Re: Automatic Purchasing
Hi Daniel This subject has come up before, and there have been some interesting ideas... One idea that intrigues me, as it is the way I think about making an order, is if a business would setup a requirements/automatic purchasing system that would run periodically on a supplier by supplier basis instead of after every sale on an item by item basis. For example, setup a purchasing scan that runs through all the suppliers, and looks for items that need to be reordered. It might eliminate the need for all of the requirements data tables in the database, and instead could create orders automatically, or on-demand for any particular supplier. Additionally, for those companies that like to operate this way, the orders could easily be adjusted to meet minimum quantity or dollar values for price breaks or reduce the number of orders you're likely to need to place with a particular supplier by including items in the order that you are running lowish on. Rather than just ordering items that have a strict requirement, you would include items that are relatively low on. This might save you from needing to place another order as soon, and would probably cut down on shipping costs, but stocking would be a little more complicated since the orders would have few numbers of a larger variety of products. In other words, if you're already placing an order, why not include some of the other items that you're running low on. I believe a system like this might allow a business to reduce backorders, since most items would usually be reordered before the inventory actually reaches the minimum. A previous discussion on the topic. http://www.mail-archive.com/user@ofbiz.apache.org/msg00675.html Another thread about combining Requirements, etc. http://osdir.com/ml/java.ofbiz.user/2005-11/msg00020.html Thanks -- Daniel *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*- Have a GREAT Day! Daniel Kunkel [EMAIL PROTECTED] BioWaves, LLC http://www.BioWaves.com 14150 NE 20th St. Suite F1 Bellevue, WA 98007 800-734-3588425-895-0050 http://www.Apartment-Pets.com http://www.Illusion-Optical.com http://www.Card-Offer.com http://www.RackWine.com http://www.JokesBlonde.com http://www.Brain-Fun.com *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Re: Automatic Purchasing
Hi Daniel, thanks for the tips, What I was wondering in my previous mail is why has a supplier role be informed in a product requirement for it to be candidate for a purchase order. IMO a product requirement should always be subject to purchase. Anyway, I have yet to look closer on this. Daniel Kunkel escribió: > Hi Daniel > > This subject has come up before, and there have been some interesting > ideas... > > One idea that intrigues me, as it is the way I think about making an > order, is if a business would setup a requirements/automatic purchasing > system that would run periodically on a supplier by supplier basis > instead of after every sale on an item by item basis. > >From my experience (small-medium sized production companies) companies purchase when ATP gets low (i.e. for products with regular demand) or by sales order (i.e. for products with peaks on demand). I haven't looked very close on ofbiz capabilities yet but I think it covers most needs. > For example, setup a purchasing scan that runs through all the > suppliers, and looks for items that need to be reordered. It might > eliminate the need for all of the requirements data tables in the > database, and instead could create orders automatically, or on-demand > for any particular supplier. > Well, I like a lot the requirement model of ofbiz because I think it is conceptually clear and very flexible. Also, IMO automatic creation of orders is not a good idea for most companies, I rather like automatic creation of requirements and then let the humans purchase ;). What I miss in ofbiz is to place an order from the requirement screen with the possibility select more than one but this shouldn't be difficult. Also, a planning report (one that shows links between sales/purchases orders and shipments) will be desirable ;). > Additionally, for those companies that like to operate this way, the > orders could easily be adjusted to meet minimum quantity or dollar > values for price breaks or reduce the number of orders you're likely to > need to place with a particular supplier by including items in the order > that you are running lowish on. Rather than just ordering items that > have a strict requirement, you would include items that are relatively > low on. This might save you from needing to place another order as soon, > and would probably cut down on shipping costs, but stocking would be a > little more complicated since the orders would have few numbers of a > larger variety of products. > In other words, if you're already placing an order, why not include some > of the other items that you're running low on. > If I understood well, grouping requirements in an order will cover this. > I believe a system like this might allow a business to reduce > backorders, since most items would usually be reordered before the > inventory actually reaches the minimum. > A previous discussion on the topic. > http://www.mail-archive.com/user@ofbiz.apache.org/msg00675.html > > Another thread about combining Requirements, etc. > http://osdir.com/ml/java.ofbiz.user/2005-11/msg00020.html > > Thanks > Regards, -- Daniel Martínez
Re: Automatic Purchasing
Daniel, Daniel Martínez wrote: Hi Daniel, thanks for the tips, What I was wondering in my previous mail is why has a supplier role be informed in a product requirement for it to be candidate for a purchase order. Where are you seeing this? I agree with you that unassigned requirements are as good as assigned ones; in the rightmost requirement screen there is a checkbox to select all the unassigned requirements. You can then manually assign to them a supplier and then create the order. But maybe I am missing the screen where you see that this is not working (and you are probably correct because some of them still need to be cleaned up). Jacopo
Re: Automatic Purchasing
Daniel, Daniel Martínez wrote: Well, I like a lot the requirement model of ofbiz because I think it is conceptually clear and very flexible. Also, IMO automatic creation of orders is not a good idea for most companies, I rather like automatic creation of requirements and then let the humans purchase ;). What I miss in ofbiz is to place an order from the requirement screen with the possibility select more than one but this shouldn't be difficult. The screen is the ApprovedProductRequirements: https://demo.hotwaxmedia.com/ordermgr/control/ApprovedProductRequirements Select a supplier and do the search and at the bottom of the screen you'll see the "Purchase Order Quick Entry" button Jacopo Also, a planning report (one that shows links between sales/purchases orders and shipments) will be desirable ;).
Re: Automatic Purchasing
Jacopo, Jacopo Cappellato escribió: > Daniel, > > Daniel Martínez wrote: >> Well, I like a lot the requirement model of ofbiz because I think it is >> conceptually clear and very flexible. Also, IMO automatic creation of >> orders is not a good idea for most companies, I rather like automatic >> creation of requirements and then let the humans purchase ;). What I >> miss in ofbiz is to place an order from the requirement screen with the >> possibility select more than one but this shouldn't be difficult. > > The screen is the ApprovedProductRequirements: > > https://demo.hotwaxmedia.com/ordermgr/control/ApprovedProductRequirements > > Select a supplier and do the search and at the bottom of the screen > you'll see the "Purchase Order Quick Entry" button Thanks, I see. Of course this only works for assigned requirements. A "quick assign" button to a provider will be desirable. The situation I am thinking is a lack of parametrization in the catalog data. This is common if we want a system that is quick to use in the beginning. If a company has lots of products/suppliers it will be some time until it informs ofbiz about the possible suppliers for each product. It would be good that ofbiz would let to create orders from requirements passing over information about the supplier (and i.e. the supplier product id) in the run. -- Daniel
Re: Automatic Purchasing
Jacopo, Jacopo Cappellato escribió: > Daniel, > > Daniel Martínez wrote: >> Hi Daniel, thanks for the tips, >> >> What I was wondering in my previous mail is why has a supplier role be >> informed in a product requirement for it to be candidate for a purchase >> order. > > Where are you seeing this? I agree with you that unassigned > requirements are as good as assigned ones; in the rightmost > requirement screen there is a checkbox to select all the unassigned > requirements. You can then manually assign to them a supplier and then > create the order. > But maybe I am missing the screen where you see that this is not > working (and you are probably correct because some of them still need > to be cleaned up). The screen I was talking is the "RequirementsForSupplier" screen. It is accesed from the (purchase) order entry and it seems to be the only way to order the requirements. Maybe a tick for "unassigned requirements" will be needed here also. -- Daniel
Re: Automatic Backorders?
been a while look at checkInventoryAvailability [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: > I am trying figure out how to have a backorder generated automatically. I > have tried various store settings and can't get anything to happen. I am > expecting a Requirement (maybe that's wrong?) to be generated when I sell an > item not in stock. > > I searched Naggle for "backorder" and found nothing on this topic (other > than discussions on how to improve it). > > I am hoping somone will respond so I don't have to dig through the source > code again. > > Skip > > > >
RE: Automatic Backorders?
Yep, I have checkInventory and reserveInventory = "Y". I was using the OOTB demo data and this is the default for the web store. I also tried setting requireInventory = "Y", but then I couldnt sell it. I tried isDemoStore="N" but that didn't make any difference. I am thinking that there is a setting somewhere else that might affect this. The checkInventoryAvailability() service is exactly what is needed. Gonna see if I can track down how it gets called. Skip -Original Message- From: BJ Freeman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 2:32 PM To: user@ofbiz.apache.org Subject: Re: Automatic Backorders? been a while look at checkInventoryAvailability [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: > I am trying figure out how to have a backorder generated automatically. I > have tried various store settings and can't get anything to happen. I am > expecting a Requirement (maybe that's wrong?) to be generated when I sell an > item not in stock. > > I searched Naggle for "backorder" and found nothing on this topic (other > than discussions on how to improve it). > > I am hoping somone will respond so I don't have to dig through the source > code again. > > Skip > > > >
Re: Automatic Backorders?
oops you talking about creating back orders. are you doing a shopping cart or something custom. BJ Freeman sent the following on 10/31/2007 1:31 PM: > been a while > look at > checkInventoryAvailability > > [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: >> I am trying figure out how to have a backorder generated automatically. I >> have tried various store settings and can't get anything to happen. I am >> expecting a Requirement (maybe that's wrong?) to be generated when I sell an >> item not in stock. >> >> I searched Naggle for "backorder" and found nothing on this topic (other >> than discussions on how to improve it). >> >> I am hoping somone will respond so I don't have to dig through the source >> code again. >> >> Skip >> >> >> >> > > >
Re: Automatic Backorders?
You need to set the details in Product -> Facilities, even then I'm not sure if it happens automatically or if you need to run an mrp first. Scott On 01/11/2007, BJ Freeman <[EMAIL PROTECTED]> wrote: > oops you talking about creating back orders. > are you doing a shopping cart or something custom. > > BJ Freeman sent the following on 10/31/2007 1:31 PM: > > been a while > > look at > > checkInventoryAvailability > > > > [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: > >> I am trying figure out how to have a backorder generated automatically. I > >> have tried various store settings and can't get anything to happen. I am > >> expecting a Requirement (maybe that's wrong?) to be generated when I sell > >> an > >> item not in stock. > >> > >> I searched Naggle for "backorder" and found nothing on this topic (other > >> than discussions on how to improve it). > >> > >> I am hoping somone will respond so I don't have to dig through the source > >> code again. > >> > >> Skip > >> > >> > >> > >> > > > > > > >
RE: Automatic Backorders?
BJ Thanks for the response. This is just OOTB ofbiz trying to see how backorders get handled so I can report on them for the AR work I am doing. I am just trying to generate a backorder and see what entities are created and how it affects billing and the like after the order is received. To start with, I just want to create a backorder associated with an order that has some of the parts shipped. I have not yet been able to create a backorder that I can recognize as such. I am expecting it to turn up in Requirements, but that may be the wrong assumption. Skip -Original Message- From: BJ Freeman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 3:01 PM To: user@ofbiz.apache.org Subject: Re: Automatic Backorders? oops you talking about creating back orders. are you doing a shopping cart or something custom. BJ Freeman sent the following on 10/31/2007 1:31 PM: > been a while > look at > checkInventoryAvailability > > [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: >> I am trying figure out how to have a backorder generated automatically. I >> have tried various store settings and can't get anything to happen. I am >> expecting a Requirement (maybe that's wrong?) to be generated when I sell an >> item not in stock. >> >> I searched Naggle for "backorder" and found nothing on this topic (other >> than discussions on how to improve it). >> >> I am hoping somone will respond so I don't have to dig through the source >> code again. >> >> Skip >> >> >> >> > > >
RE: Automatic Backorders?
Scott Thanks, I'll check this out. I noticed that checkInventoryAvailability() is being run as a sandbox job and I have three entries about two hours apart in the log saying the job was run. Skip -Original Message- From: Scott Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 2:10 PM To: user@ofbiz.apache.org Subject: Re: Automatic Backorders? You need to set the details in Product -> Facilities, even then I'm not sure if it happens automatically or if you need to run an mrp first. Scott On 01/11/2007, BJ Freeman <[EMAIL PROTECTED]> wrote: > oops you talking about creating back orders. > are you doing a shopping cart or something custom. > > BJ Freeman sent the following on 10/31/2007 1:31 PM: > > been a while > > look at > > checkInventoryAvailability > > > > [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: > >> I am trying figure out how to have a backorder generated automatically. I > >> have tried various store settings and can't get anything to happen. I am > >> expecting a Requirement (maybe that's wrong?) to be generated when I sell an > >> item not in stock. > >> > >> I searched Naggle for "backorder" and found nothing on this topic (other > >> than discussions on how to improve it). > >> > >> I am hoping somone will respond so I don't have to dig through the source > >> code again. > >> > >> Skip > >> > >> > >> > >> > > > > > > >
RE: Automatic Backorders?
Not having much luck here. I set the minimum stock on hand for a GZ-1001 to 0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but nothing I could detect happened. So, I went to Manufacturing->MRP and ran it for the Web Store. Nothing that I can detect happened. Can someone tell me how to write an order with a backorder on it and then have a purchase order written so that when it is received, the shipping clerk knows the item belongs to an order? Maybe this is some new code I need to write? Skip -Original Message- From: Scott Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 2:10 PM To: user@ofbiz.apache.org Subject: Re: Automatic Backorders? You need to set the details in Product -> Facilities, even then I'm not sure if it happens automatically or if you need to run an mrp first. Scott On 01/11/2007, BJ Freeman <[EMAIL PROTECTED]> wrote: > oops you talking about creating back orders. > are you doing a shopping cart or something custom. > > BJ Freeman sent the following on 10/31/2007 1:31 PM: > > been a while > > look at > > checkInventoryAvailability > > > > [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: > >> I am trying figure out how to have a backorder generated automatically. I > >> have tried various store settings and can't get anything to happen. I am > >> expecting a Requirement (maybe that's wrong?) to be generated when I sell an > >> item not in stock. > >> > >> I searched Naggle for "backorder" and found nothing on this topic (other > >> than discussions on how to improve it). > >> > >> I am hoping somone will respond so I don't have to dig through the source > >> code again. > >> > >> Skip > >> > >> > >> > >> > > > > > > >
Re: Automatic Backorders?
Skip: I am converting what I did to using SECAS. i will be putting this in the Jiras I have welcome any input on there use. https://issues.apache.org/jira/browse/OFBIZ-1286 is the main one. [EMAIL PROTECTED] sent the following on 10/31/2007 2:20 PM: > Not having much luck here. I set the minimum stock on hand for a GZ-1001 to > 0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but > nothing I could detect happened. So, I went to Manufacturing->MRP and ran > it for the Web Store. Nothing that I can detect happened. > > Can someone tell me how to write an order with a backorder on it and then > have a purchase order written so that when it is received, the shipping > clerk knows the item belongs to an order? Maybe this is some new code I > need to write? > > Skip > > -Original Message- > From: Scott Gray [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 31, 2007 2:10 PM > To: user@ofbiz.apache.org > Subject: Re: Automatic Backorders? > > > You need to set the details in Product -> Facilities, even then I'm > not sure if it happens automatically or if you need to run an mrp > first. > > Scott > > On 01/11/2007, BJ Freeman <[EMAIL PROTECTED]> wrote: >> oops you talking about creating back orders. >> are you doing a shopping cart or something custom. >> >> BJ Freeman sent the following on 10/31/2007 1:31 PM: >>> been a while >>> look at >>> checkInventoryAvailability >>> >>> [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM: >>>> I am trying figure out how to have a backorder generated automatically. > I >>>> have tried various store settings and can't get anything to happen. I > am >>>> expecting a Requirement (maybe that's wrong?) to be generated when I > sell an >>>> item not in stock. >>>> >>>> I searched Naggle for "backorder" and found nothing on this topic > (other >>>> than discussions on how to improve it). >>>> >>>> I am hoping somone will respond so I don't have to dig through the > source >>>> code again. >>>> >>>> Skip >>>> >>>> >>>> >>>> >>> >>> > > > >
Re: Automatic Backorders?
here is the code in checkInventoryAvailability
List exprs = UtilMisc.toList(new
EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
Double(0)));
as you have already found out it is run in the sandbox.
there is a lot more to consider that what is checkInventoryAvailability
Like inventory that has multiple suppliers. and those supplier have a
preference.
the Preference it updated from past orders to them.
This has to do with cost, delivery, and billing agreements.
[EMAIL PROTECTED] sent the following on 10/31/2007 1:17 PM:
> BJ
>
> Thanks for the response. This is just OOTB ofbiz trying to see how
> backorders get handled so I can report on them for the AR work I am doing.
> I am just trying to generate a backorder and see what entities are created
> and how it affects billing and the like after the order is received.
>
> To start with, I just want to create a backorder associated with an order
> that has some of the parts shipped.
>
> I have not yet been able to create a backorder that I can recognize as such.
> I am expecting it to turn up in Requirements, but that may be the wrong
> assumption.
>
> Skip
>
> -Original Message-
> From: BJ Freeman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 31, 2007 3:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>> been a while
>> look at
>> checkInventoryAvailability
>>
>> [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM:
>>> I am trying figure out how to have a backorder generated automatically.
> I
>>> have tried various store settings and can't get anything to happen. I am
>>> expecting a Requirement (maybe that's wrong?) to be generated when I sell
> an
>>> item not in stock.
>>>
>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>> than discussions on how to improve it).
>>>
>>> I am hoping somone will respond so I don't have to dig through the source
>>> code again.
>>>
>>> Skip
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Automatic Backorders?
in checkInventoryAvailability
dispatcher.runAsync("sendOrderBackorderNotification",
UtilMisc.toMap("orderId", orderId, "userLogin", userLogin));
is where I put code to call CheckPO's
Now in dropship the POs are generated based on the order so the vendor
may get a PO for one item to drop ship to a customer.
for local inventory it is a seperate process that is closer to MRP.
the PO's are then send the SendPOtoVendor.
where the PO is formated per that particular vendor specificatiions and
sent to them.
then could be via web scrapping, FTP, Email, EDI.
hope to have this all submitted soon
[EMAIL PROTECTED] sent the following on 10/31/2007 2:20 PM:
> Not having much luck here. I set the minimum stock on hand for a GZ-1001 to
> 0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but
> nothing I could detect happened. So, I went to Manufacturing->MRP and ran
> it for the Web Store. Nothing that I can detect happened.
>
> Can someone tell me how to write an order with a backorder on it and then
> have a purchase order written so that when it is received, the shipping
> clerk knows the item belongs to an order? Maybe this is some new code I
> need to write?
>
> Skip
>
> -Original Message-
> From: Scott Gray [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 31, 2007 2:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> You need to set the details in Product -> Facilities, even then I'm
> not sure if it happens automatically or if you need to run an mrp
> first.
>
> Scott
>
> On 01/11/2007, BJ Freeman <[EMAIL PROTECTED]> wrote:
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic
> (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>
>
>
>
RE: Automatic Backorders?
Thanks BJ, I'll have a look at this all. I agree about the multiple
suppliers. I am writing a more complicated automated purchasing app partly
because of this (different supplier prices, different shipping times,
minimum order quantities, etc.). However, I also want to produce something
stupid that can be run to just fill backorders from the prefered supplier so
rush orders with backorders on them can get handled by someone without
in-depth purchasing knowledge.
Skip
-Original Message-
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 1:10 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
here is the code in checkInventoryAvailability
List exprs = UtilMisc.toList(new
EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
Double(0)));
as you have already found out it is run in the sandbox.
there is a lot more to consider that what is checkInventoryAvailability
Like inventory that has multiple suppliers. and those supplier have a
preference.
the Preference it updated from past orders to them.
This has to do with cost, delivery, and billing agreements.
[EMAIL PROTECTED] sent the following on 10/31/2007 1:17 PM:
> BJ
>
> Thanks for the response. This is just OOTB ofbiz trying to see how
> backorders get handled so I can report on them for the AR work I am doing.
> I am just trying to generate a backorder and see what entities are created
> and how it affects billing and the like after the order is received.
>
> To start with, I just want to create a backorder associated with an order
> that has some of the parts shipped.
>
> I have not yet been able to create a backorder that I can recognize as
such.
> I am expecting it to turn up in Requirements, but that may be the wrong
> assumption.
>
> Skip
>
> -Original Message-
> From: BJ Freeman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 31, 2007 3:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>> been a while
>> look at
>> checkInventoryAvailability
>>
>> [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM:
>>> I am trying figure out how to have a backorder generated automatically.
> I
>>> have tried various store settings and can't get anything to happen. I
am
>>> expecting a Requirement (maybe that's wrong?) to be generated when I
sell
> an
>>> item not in stock.
>>>
>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>> than discussions on how to improve it).
>>>
>>> I am hoping somone will respond so I don't have to dig through the
source
>>> code again.
>>>
>>> Skip
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Automatic Backorders?
also have a look at getSuppliersForProduct
[EMAIL PROTECTED] sent the following on 11/1/2007 11:28 AM:
> Thanks BJ, I'll have a look at this all. I agree about the multiple
> suppliers. I am writing a more complicated automated purchasing app partly
> because of this (different supplier prices, different shipping times,
> minimum order quantities, etc.). However, I also want to produce something
> stupid that can be run to just fill backorders from the prefered supplier so
> rush orders with backorders on them can get handled by someone without
> in-depth purchasing knowledge.
>
> Skip
>
> -Original Message-
> From: BJ Freeman [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 01, 2007 1:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> here is the code in checkInventoryAvailability
>
> List exprs = UtilMisc.toList(new
> EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
> Double(0)));
>
> as you have already found out it is run in the sandbox.
>
> there is a lot more to consider that what is checkInventoryAvailability
> Like inventory that has multiple suppliers. and those supplier have a
> preference.
> the Preference it updated from past orders to them.
> This has to do with cost, delivery, and billing agreements.
>
>
>
> [EMAIL PROTECTED] sent the following on 10/31/2007 1:17 PM:
>> BJ
>>
>> Thanks for the response. This is just OOTB ofbiz trying to see how
>> backorders get handled so I can report on them for the AR work I am doing.
>> I am just trying to generate a backorder and see what entities are created
>> and how it affects billing and the like after the order is received.
>>
>> To start with, I just want to create a backorder associated with an order
>> that has some of the parts shipped.
>>
>> I have not yet been able to create a backorder that I can recognize as
> such.
>> I am expecting it to turn up in Requirements, but that may be the wrong
>> assumption.
>>
>> Skip
>>
>> -Original Message-
>> From: BJ Freeman [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, October 31, 2007 3:01 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Automatic Backorders?
>>
>>
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> [EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
>> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell
>> an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
>
>
Re: Automatic Backorders?
Skip,
[EMAIL PROTECTED] wrote:
Thanks BJ, I'll have a look at this all. I agree about the multiple
suppliers. I am writing a more complicated automated purchasing app partly
because of this (different supplier prices, different shipping times,
minimum order quantities, etc.). However, I also want to produce something
stupid that can be run to just fill backorders from the prefered supplier so
rush orders with backorders on them can get handled by someone without
in-depth purchasing knowledge.
you may want to try to set the requirementMethodEnumId field in the
Product entity (or ProductStore): there is a drop-down field for this in
the Edit Product screen.
There are many options, I'd suggest "When QOH reaches..."
All the ("product") requirements created in the system are automatically
associated to the main supplier (there is a field to mark the main
supplier in the SupplierProduct entity).
Jacopo
Skip
-Original Message-
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 1:10 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
here is the code in checkInventoryAvailability
List exprs = UtilMisc.toList(new
EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
Double(0)));
as you have already found out it is run in the sandbox.
there is a lot more to consider that what is checkInventoryAvailability
Like inventory that has multiple suppliers. and those supplier have a
preference.
the Preference it updated from past orders to them.
This has to do with cost, delivery, and billing agreements.
[EMAIL PROTECTED] sent the following on 10/31/2007 1:17 PM:
BJ
Thanks for the response. This is just OOTB ofbiz trying to see how
backorders get handled so I can report on them for the AR work I am doing.
I am just trying to generate a backorder and see what entities are created
and how it affects billing and the like after the order is received.
To start with, I just want to create a backorder associated with an order
that has some of the parts shipped.
I have not yet been able to create a backorder that I can recognize as
such.
I am expecting it to turn up in Requirements, but that may be the wrong
assumption.
Skip
-Original Message-
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 31, 2007 3:01 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
oops you talking about creating back orders.
are you doing a shopping cart or something custom.
BJ Freeman sent the following on 10/31/2007 1:31 PM:
been a while
look at
checkInventoryAvailability
[EMAIL PROTECTED] sent the following on 10/31/2007 10:58 AM:
I am trying figure out how to have a backorder generated automatically.
I
have tried various store settings and can't get anything to happen. I
am
expecting a Requirement (maybe that's wrong?) to be generated when I
sell
an
item not in stock.
I searched Naggle for "backorder" and found nothing on this topic (other
than discussions on how to improve it).
I am hoping somone will respond so I don't have to dig through the
source
code again.
Skip
Automatic purchase orders
Hi, I have an interesting client set up where their business is basically two entities (from an accounting perspective), one does sales and rentals, the other manufactures custom built furniture sold by the retail outlet. When an order is raised from the retail outlet I want to automatically create a purchase order to the manufacturing side for all items supplied by that supplier. An order could contain many items that need to be supplied. The other problem I have is defining the specifications for the ordered items e.g. height, width, depth, edging as the products are never standard. Is there anyway I can set a product up so that a PO is raised on order approval. Regards, Paul
Automatic DB Update
>From what I've been reading, OFBiz is supposed to automatically update your database if you modify an entity. For some reason, I cannot get mine to update. I've tried using the Update Tool to no avail. Can anyone tell me why I'm having issues? Thanks.
Re: Automatic data import
I think that I found the solution. I write here for anyone who is interested. The service that makes this is entityImport. In the Webtools -> Service Engine Tools the user can Schedule job with the parameters of the service. MarioF wrote: > > Hi all, > > I need to import some products from another database. I think that I can > do it manually in the following way: > > 1- The other database generates some xml file with all the products to > import in the ofbiz database and allow the access with one URL. > 2- XML Data Import in the webtools application. > > My question now is, how can I make an automatic data import? I mean, for > example, that every day ofbiz goes to the same URL and import the same > file. Is this possible? > > Thanks in advance. > > > > -- View this message in context: http://www.nabble.com/Automatic-data-import-tp25746481p25748840.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic DB Update
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It will add tables. this is setup in the entityengine.xml to do this. add-missing-on-start="true" Sanders, Brian sent the following on 3/25/2009 6:30 AM: >>From what I've been reading, OFBiz is supposed to automatically update > your database if you modify an entity. For some reason, I cannot get > mine to update. I've tried using the Update Tool to no avail. Can anyone > tell me why I'm having issues? Thanks. > > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJyl4ArP3NbaWWqE4RAroHAJwNLHej5jMryN/aAeWtOv7xIoqjIACgldpn L5AIItQnWKpInWz7HICKqFM= =+TdK -END PGP SIGNATURE-
Re: Automatic DB Update
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 make sure you add the path to your entity file in the ofbiz-component.xml of the component you put it in. BJ Freeman sent the following on 3/25/2009 9:38 AM: > It will add tables. > this is setup in the entityengine.xml > to do this. > add-missing-on-start="true" > > Sanders, Brian sent the following on 3/25/2009 6:30 AM: >> >From what I've been reading, OFBiz is supposed to automatically update >> your database if you modify an entity. For some reason, I cannot get >> mine to update. I've tried using the Update Tool to no avail. Can anyone >> tell me why I'm having issues? Thanks. > > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd Bs5lL2QC9WmqPSxMZ00muAU= =I9zV -END PGP SIGNATURE-
Re: Automatic DB Update
On Mar 25, 2009, at 7:30 AM, Sanders, Brian wrote: From what I've been reading, OFBiz is supposed to automatically update your database if you modify an entity. For some reason, I cannot get mine to update. I've tried using the Update Tool to no avail. Can anyone tell me why I'm having issues? Thanks. Here is an index of older documentation, that has unfortunately been mostly buried as people like to write new stuff more than maintain old stuff: http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Documentation+Index For this question the Entity Engine Configuration Guide has helpful info: http://ofbiz.apache.org/docs/entityconfig.html -David
RE: Automatic DB Update
What I'm doing is adding a column/field to ReturnItem (although I think I've changed my mind). I saw David's subsequent responses and will take a look at those docs. -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: Wednesday, March 25, 2009 3:08 PM To: user@ofbiz.apache.org Subject: Re: Automatic DB Update -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 make sure you add the path to your entity file in the ofbiz-component.xml of the component you put it in. BJ Freeman sent the following on 3/25/2009 9:38 AM: > It will add tables. > this is setup in the entityengine.xml > to do this. > add-missing-on-start="true" > > Sanders, Brian sent the following on 3/25/2009 6:30 AM: >> >From what I've been reading, OFBiz is supposed to automatically update >> your database if you modify an entity. For some reason, I cannot get >> mine to update. I've tried using the Update Tool to no avail. Can anyone >> tell me why I'm having issues? Thanks. > > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd Bs5lL2QC9WmqPSxMZ00muAU= =I9zV -END PGP SIGNATURE-
RE: Automatic DB Update
If you look near the bottom of http://www.opensourcestrategies.com/ofbiz/hello_world3.php, you will see an excerpt from a log file which shows DatabaseUtil adding a field to a database. I checked the code and it looks like it should be adding the field. Any ideas why this might not be working? I'm using a MySql db if that makes any difference. Thanks. -Original Message- From: Sanders, Brian [mailto:bsand...@connextions.com] Sent: Thursday, March 26, 2009 9:18 AM To: user@ofbiz.apache.org Subject: RE: Automatic DB Update What I'm doing is adding a column/field to ReturnItem (although I think I've changed my mind). I saw David's subsequent responses and will take a look at those docs. -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: Wednesday, March 25, 2009 3:08 PM To: user@ofbiz.apache.org Subject: Re: Automatic DB Update -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 make sure you add the path to your entity file in the ofbiz-component.xml of the component you put it in. BJ Freeman sent the following on 3/25/2009 9:38 AM: > It will add tables. > this is setup in the entityengine.xml > to do this. > add-missing-on-start="true" > > Sanders, Brian sent the following on 3/25/2009 6:30 AM: >> >From what I've been reading, OFBiz is supposed to automatically update >> your database if you modify an entity. For some reason, I cannot get >> mine to update. I've tried using the Update Tool to no avail. Can anyone >> tell me why I'm having issues? Thanks. > > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd Bs5lL2QC9WmqPSxMZ00muAU= =I9zV -END PGP SIGNATURE-
RE: Automatic DB Update
After a little investigation, it turns out that in the entityengine.xml
file, there is an attribute which belongs to : schema-name.
When OFBiz checks the database on startup, it was prepending the schema
to the table names which was causing the matching to fail. By removing
the attribute, OFBiz was able to make the match and add the column
automatically. If you look at
org.ofbiz.entity.jdbc.DatabaseUtil.checkDB():line 193, you will see the
statement:
if (tableNames.contains(entity.getTableName(datasourceInfo))) {
entity.getTableName(datasourceInfo) was returning .
whereas tableNames contained only the . When the column is added,
common sense tells me to look the column in the same place I defined it
(before/after a certain column), but it adds it to the end. I'm not sure
how easy it would be, but placing the column after a particular column
would be a nice feature. Unfortunately, I don't have the time to look
into incorporating it ATM, but maybe someone else would be able to.
-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com]
Sent: Friday, March 27, 2009 9:07 AM
To: user@ofbiz.apache.org
Subject: RE: Automatic DB Update
If you look near the bottom of
http://www.opensourcestrategies.com/ofbiz/hello_world3.php, you will see
an excerpt from a log file which shows DatabaseUtil adding a field to a
database. I checked the code and it looks like it should be adding the
field. Any ideas why this might not be working? I'm using a MySql db if
that makes any difference. Thanks.
-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com]
Sent: Thursday, March 26, 2009 9:18 AM
To: user@ofbiz.apache.org
Subject: RE: Automatic DB Update
What I'm doing is adding a column/field to ReturnItem (although I think
I've changed my mind). I saw David's subsequent responses and will take
a look at those docs.
-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net]
Sent: Wednesday, March 25, 2009 3:08 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic DB Update
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
make sure you add the path to your entity file in the
ofbiz-component.xml of the component you put it in.
BJ Freeman sent the following on 3/25/2009 9:38 AM:
> It will add tables.
> this is setup in the entityengine.xml
> to do this.
> add-missing-on-start="true"
>
> Sanders, Brian sent the following on 3/25/2009 6:30 AM:
>> >From what I've been reading, OFBiz is supposed to automatically
update
>> your database if you modify an entity. For some reason, I cannot get
>> mine to update. I've tried using the Update Tool to no avail. Can
anyone
>> tell me why I'm having issues? Thanks.
>
>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd
Bs5lL2QC9WmqPSxMZ00muAU=
=I9zV
-END PGP SIGNATURE-
Re: Automatic DB Update
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
actually if you have a entity and/or extend an entity this should not be
a problem.
Now if you have a DB already then of course setting the schema is important.
The way ofbiz works is the DB layers is a common feature layer.
so what every DB is supported that has the least feature is what this
layer does.
However if you wish to expand on this, feel free to contribute.
Sanders, Brian sent the following on 4/2/2009 12:54 PM:
> After a little investigation, it turns out that in the entityengine.xml
> file, there is an attribute which belongs to : schema-name.
> When OFBiz checks the database on startup, it was prepending the schema
> to the table names which was causing the matching to fail. By removing
> the attribute, OFBiz was able to make the match and add the column
> automatically. If you look at
> org.ofbiz.entity.jdbc.DatabaseUtil.checkDB():line 193, you will see the
> statement:
> if (tableNames.contains(entity.getTableName(datasourceInfo))) {
>
> entity.getTableName(datasourceInfo) was returning .
> whereas tableNames contained only the . When the column is added,
> common sense tells me to look the column in the same place I defined it
> (before/after a certain column), but it adds it to the end. I'm not sure
> how easy it would be, but placing the column after a particular column
> would be a nice feature. Unfortunately, I don't have the time to look
> into incorporating it ATM, but maybe someone else would be able to.
>
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Friday, March 27, 2009 9:07 AM
> To: user@ofbiz.apache.org
> Subject: RE: Automatic DB Update
>
> If you look near the bottom of
> http://www.opensourcestrategies.com/ofbiz/hello_world3.php, you will see
> an excerpt from a log file which shows DatabaseUtil adding a field to a
> database. I checked the code and it looks like it should be adding the
> field. Any ideas why this might not be working? I'm using a MySql db if
> that makes any difference. Thanks.
>
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Thursday, March 26, 2009 9:18 AM
> To: user@ofbiz.apache.org
> Subject: RE: Automatic DB Update
>
> What I'm doing is adding a column/field to ReturnItem (although I think
> I've changed my mind). I saw David's subsequent responses and will take
> a look at those docs.
>
> -Original Message-
> From: BJ Freeman [mailto:bjf...@free-man.net]
> Sent: Wednesday, March 25, 2009 3:08 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic DB Update
>
> make sure you add the path to your entity file in the
> ofbiz-component.xml of the component you put it in.
>location="entitydef/yourentityfile.xml"/>
>
>
> BJ Freeman sent the following on 3/25/2009 9:38 AM:
>> It will add tables.
>> this is setup in the entityengine.xml
>> to do this.
>> add-missing-on-start="true"
>
>> Sanders, Brian sent the following on 3/25/2009 6:30 AM:
>>> >From what I've been reading, OFBiz is supposed to automatically
> update
>>> your database if you modify an entity. For some reason, I cannot get
>>> mine to update. I've tried using the Update Tool to no avail. Can
> anyone
>>> tell me why I'm having issues? Thanks.
>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJ1RrjrP3NbaWWqE4RAn9nAJsH95ocejJmvE3MRvPCKi9774kCtgCcCunT
dip4wBB16ZbDetsVRdRqnvc=
=xFki
-END PGP SIGNATURE-
Automatic PDF Printing - Revisited
This is a duplicated question. Sorry if you are looking at this a second
time. Here is the orignial post:
I would like to print various .fo.ftl PDF forms automatically using ECA
services. I have written (using modified Sun code) a PDF print writer. All
I need as a way to get a ByteArrayOutputStream from the .fo.ftl. Using
org.ofbiz.widget.screen.ScreenFopViewHandler.render as an example, I can
easily get a ByteArrayOutputStream and print it. Unfortunately, this
routine requires a request and a response, although the response is never
really used and can probably be null.
The question is how to get the request in the eca service. I read the
entries at:
http://ofbiz.markmail.org/message/54mvqvnmmhnwoahy?q=Session+in+Services
where Rishi Solanki sez to just add:
However, that did not work. You get an error "The following required
parameter is missing: [IN] [printInvoicePDF.request]."
So, I modified the code in in
framework\webapp\src\org\ofbiz\webapp\event\ServiceEventHandler.java
around line 220:
// don't include locale, that is also taken care of below
if ("locale".equals(name)) continue;
//Added by skipd to set up a request and response
if ("request".equals(name))
{
serviceContext.put("request", request);
continue;
}
if ("response".equals(name))
{
serviceContext.put("responset", response);
continue;
}
This all works now, but there are two problems. I am told that it breaks
the job sandbox. Second, I have to modifiy the service definition of the
service on which the eca runs to also include the request which kind of
messes with the purpose of an ECA.
Here is the code in ScreenFopViewHandler.render
ScreenRenderer screens = new ScreenRenderer(writer, null,
htmlScreenRenderer);
screens.populateContextForRequest(request, response, servletContext);
...
screens.getContext().put("formStringRenderer", new FoFormRenderer(request,
response));
screens.render(page);
ByteArrayOutputStream out = new ByteArrayOutputStream();
TransformerFactory transFactory = TransformerFactory.newInstance();
Fop fop = fopFactory.newFop(contentType, out);
Transformer transformer = transFactory.newTransformer();
// set the input source (XSL-FO) and generate the output stream of
contentType
Reader reader = new StringReader(writer.toString());
Source src = new StreamSource(reader);
...
Then, instead of:
// write to the browser
try {
out.writeTo(response.getOutputStream());
response.getOutputStream().flush();
} catch (IOException e) {
throw new ViewHandlerException("Unable write to browser OutputStream", e);
}
Changed to this:
PDFPrint(out, printerdefinition);
This all works. No browser is involved. The only issue is that the calls to
populateContextForRequest, and FoFormRenderer both require request and
response arguments. The response is only used (as far as I can tell) for
populating a beanshell, and it is never used in any of the .bsh scripts for
PDF generation. It is never used in FoFormRenderer. In any case, I would not
be writing to the browser, only capturing the output stream and sending it
on to the PDFPrint routine that I have written.
In other words, what I want to do is use the various fo.ftl screens for
the various forms, render them to a ByteArrayOutputStream, and send that
ByteArrayOutputStream to a routine that knows how to print the resulting PDF
stream directly to a printer.
I expect that this would be useful to lots of people. All of my customers
want it as it saves them several minutes per order, i.e., accounts payable
does not have to look up all the completed orders, and print invoices. Pick
and packing slips get printed automatically, when an ecommerce order is
placed, a pick slip is automatically printed, etc, etc.
I also would like to contribute the code back to the project and so would
like whatever method used to be "approved".
Skip
Products And Automatic Requirements
I'm trying to figure out how to set up multiple automatic requirements for a product, and I need some help. A product will generate multiple requirements automatically when a sales order is approved. One requirement is created automatically if inventory levels fall below a certain point - this requirement triggers a production run. Another requirement is created automatically when a sales order is approved regardless of inventory levels - that requirement is for product installation. I spent some time looking through the catalog manager and the auto-requirements services - createAutoRequirementsForOrder and createATPRequirementsForOrder. I don't see how to set this up. It appears that you can assign only one requirement method to a product, and for some reason that method is connected to inventory. The second requirement I mentioned (for product installation) is not tied to inventory, it is a requirement for labor. Does anyone know how I can set this up? -Adrian
POS automatic GL posting disable
I'd like to disable the automatic GL posting on the POS side, and just have that happen when the order hits the server via a sync. Any pointers or explicit directions would be appreciated. Thanks.
MySQL database automatic periodic backup
Hi list, I would like to have OFBiz automatically backup its own database at regular time intervals. Has someone already done something similar or could offer me some idea on the best way to implement it? Many thanks, -Bruno
Automatic Requirements when QOH drops
I have been trying my hand to get setting up Requirements to be generated when QOH reaches minimum stock. My intention is to generate POs when QOH reeaches low levels. I do not want to use MRPs. I tried reading through user lists but was not able to get what suited above requirement. I have simple prodcut setup. Fan - Finished product Motor - Raw material FanBlades - Raw material I want to produce a Fan from Motor and Fanblades. Please assume that we manufacture FAN so there is no need to create PO for Fan. For Motor and Fanblades, below are setup In product screen, Requirement Method Enum Id - (PRODRQM_STOCK) When QOH Reaches Minimum Stock for Product-Facility In product screen, Require Inventory - Y In product->setup Supplier tab, main supplier, Last Price and Supplier prod id In product->setup facilities tab, I have minimum stock and reorder qty setup For FAN, below is setup In product screen, Requirement Method Enum Id Blank In product screen, Require Inventory - N In product->No setup on Supplier tab In product->setup facilities tab, I have minimum stock and reorder qty setup Inventory levels are such that if I approve 1 sales order or 1 Fan, inventory levels of Motor and fanblades will drop below QOH. I create and approve 1 sales order. However i do not see requirements created for Motor and fanblades. Can you please suggest what i am missing here? Or is there anything wrong in configuration. Thanks in advance! -- View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Requirements-when-QOH-drops-tp2295670p2295670.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic PDF Printing - Revisited
Did you get my response to your original question?
If not, go look it up. This is already well supported OOTB by the screen widget.
-David
On Feb 18, 2011, at 9:06 AM, skip@thedevers wrote:
> This is a duplicated question. Sorry if you are looking at this a second
> time. Here is the orignial post:
>
> I would like to print various .fo.ftl PDF forms automatically using ECA
> services. I have written (using modified Sun code) a PDF print writer. All
> I need as a way to get a ByteArrayOutputStream from the .fo.ftl. Using
> org.ofbiz.widget.screen.ScreenFopViewHandler.render as an example, I can
> easily get a ByteArrayOutputStream and print it. Unfortunately, this
> routine requires a request and a response, although the response is never
> really used and can probably be null.
>
> The question is how to get the request in the eca service. I read the
> entries at:
>
> http://ofbiz.markmail.org/message/54mvqvnmmhnwoahy?q=Session+in+Services
>
> where Rishi Solanki sez to just add:
> type="javax.servlet.http.HttpServletRequest"/>
>
> However, that did not work. You get an error "The following required
> parameter is missing: [IN] [printInvoicePDF.request]."
>
> So, I modified the code in in
> framework\webapp\src\org\ofbiz\webapp\event\ServiceEventHandler.java
>
> around line 220:
>
> // don't include locale, that is also taken care of below
> if ("locale".equals(name)) continue;
>
> //Added by skipd to set up a request and response
> if ("request".equals(name))
> {
> serviceContext.put("request", request);
> continue;
> }
> if ("response".equals(name))
> {
> serviceContext.put("responset", response);
> continue;
> }
>
>
> This all works now, but there are two problems. I am told that it breaks
> the job sandbox. Second, I have to modifiy the service definition of the
> service on which the eca runs to also include the request which kind of
> messes with the purpose of an ECA.
>
> Here is the code in ScreenFopViewHandler.render
>
>
> ScreenRenderer screens = new ScreenRenderer(writer, null,
> htmlScreenRenderer);
> screens.populateContextForRequest(request, response, servletContext);
>
> ...
> screens.getContext().put("formStringRenderer", new FoFormRenderer(request,
> response));
> screens.render(page);
>
>
> ByteArrayOutputStream out = new ByteArrayOutputStream();
>
> TransformerFactory transFactory = TransformerFactory.newInstance();
>
> Fop fop = fopFactory.newFop(contentType, out);
> Transformer transformer = transFactory.newTransformer();
>
> // set the input source (XSL-FO) and generate the output stream of
> contentType
> Reader reader = new StringReader(writer.toString());
> Source src = new StreamSource(reader);
>
> ...
>
> Then, instead of:
> // write to the browser
> try {
> out.writeTo(response.getOutputStream());
> response.getOutputStream().flush();
> } catch (IOException e) {
> throw new ViewHandlerException("Unable write to browser OutputStream", e);
> }
>
> Changed to this:
>
> PDFPrint(out, printerdefinition);
>
> This all works. No browser is involved. The only issue is that the calls to
> populateContextForRequest, and FoFormRenderer both require request and
> response arguments. The response is only used (as far as I can tell) for
> populating a beanshell, and it is never used in any of the .bsh scripts for
> PDF generation. It is never used in FoFormRenderer. In any case, I would not
> be writing to the browser, only capturing the output stream and sending it
> on to the PDFPrint routine that I have written.
>
> In other words, what I want to do is use the various fo.ftl screens for
> the various forms, render them to a ByteArrayOutputStream, and send that
> ByteArrayOutputStream to a routine that knows how to print the resulting PDF
> stream directly to a printer.
>
> I expect that this would be useful to lots of people. All of my customers
> want it as it saves them several minutes per order, i.e., accounts payable
> does not have to look up all the completed orders, and print invoices. Pick
> and packing slips get printed automatically, when an ecommerce order is
> placed, a pick slip is automatically printed, etc, etc.
>
> I also would like to contribute the code back to the project and so would
> like whatever method used to be "approved".
>
> Skip
>
RE: Automatic PDF Printing - Revisited
Thanks for the quick response. There are indeed lots of examples, most
notibly in EmailServices.java that are suitable.
Thanks again.
Skip
-Original Message-
From: David E Jones [mailto:d...@me.com]
Sent: Friday, February 18, 2011 11:06 AM
To: user@ofbiz.apache.org
Subject: Re: Automatic PDF Printing - Revisited
Did you get my response to your original question?
If not, go look it up. This is already well supported OOTB by the screen
widget.
-David
On Feb 18, 2011, at 9:06 AM, skip@thedevers wrote:
> This is a duplicated question. Sorry if you are looking at this a second
> time. Here is the orignial post:
>
> I would like to print various .fo.ftl PDF forms automatically using ECA
> services. I have written (using modified Sun code) a PDF print writer.
All
> I need as a way to get a ByteArrayOutputStream from the .fo.ftl. Using
> org.ofbiz.widget.screen.ScreenFopViewHandler.render as an example, I can
> easily get a ByteArrayOutputStream and print it. Unfortunately, this
> routine requires a request and a response, although the response is never
> really used and can probably be null.
>
> The question is how to get the request in the eca service. I read the
> entries at:
>
> http://ofbiz.markmail.org/message/54mvqvnmmhnwoahy?q=Session+in+Services
>
> where Rishi Solanki sez to just add:
> type="javax.servlet.http.HttpServletRequest"/>
>
> However, that did not work. You get an error "The following required
> parameter is missing: [IN] [printInvoicePDF.request]."
>
> So, I modified the code in in
> framework\webapp\src\org\ofbiz\webapp\event\ServiceEventHandler.java
>
> around line 220:
>
> // don't include locale, that is also taken care of below
> if ("locale".equals(name)) continue;
>
> //Added by skipd to set up a request and response
> if ("request".equals(name))
> {
> serviceContext.put("request", request);
> continue;
> }
> if ("response".equals(name))
> {
> serviceContext.put("responset", response);
> continue;
> }
>
>
> This all works now, but there are two problems. I am told that it breaks
> the job sandbox. Second, I have to modifiy the service definition of the
> service on which the eca runs to also include the request which kind of
> messes with the purpose of an ECA.
>
> Here is the code in ScreenFopViewHandler.render
>
>
> ScreenRenderer screens = new ScreenRenderer(writer, null,
> htmlScreenRenderer);
> screens.populateContextForRequest(request, response, servletContext);
>
> ...
> screens.getContext().put("formStringRenderer", new FoFormRenderer(request,
> response));
> screens.render(page);
>
>
> ByteArrayOutputStream out = new ByteArrayOutputStream();
>
> TransformerFactory transFactory = TransformerFactory.newInstance();
>
> Fop fop = fopFactory.newFop(contentType, out);
> Transformer transformer = transFactory.newTransformer();
>
> // set the input source (XSL-FO) and generate the output stream of
> contentType
> Reader reader = new StringReader(writer.toString());
> Source src = new StreamSource(reader);
>
> ...
>
> Then, instead of:
> // write to the browser
> try {
> out.writeTo(response.getOutputStream());
> response.getOutputStream().flush();
> } catch (IOException e) {
> throw new ViewHandlerException("Unable write to browser OutputStream", e);
> }
>
> Changed to this:
>
> PDFPrint(out, printerdefinition);
>
> This all works. No browser is involved. The only issue is that the calls
to
> populateContextForRequest, and FoFormRenderer both require request and
> response arguments. The response is only used (as far as I can tell) for
> populating a beanshell, and it is never used in any of the .bsh scripts
for
> PDF generation. It is never used in FoFormRenderer. In any case, I would
not
> be writing to the browser, only capturing the output stream and sending it
> on to the PDFPrint routine that I have written.
>
> In other words, what I want to do is use the various fo.ftl screens
for
> the various forms, render them to a ByteArrayOutputStream, and send that
> ByteArrayOutputStream to a routine that knows how to print the resulting
PDF
> stream directly to a printer.
>
> I expect that this would be useful to lots of people. All of my customers
> want it as it saves them several minutes per order, i.e., accounts payable
> does not have to look up all the completed orders, and print invoices.
Pick
> and packing slips get printed automatically, when an ecommerce order is
> placed, a pick slip is automatically printed, etc, etc.
>
> I also would like to contribute the code back to the project and so would
> like whatever method used to be "approved".
>
> Skip
>
Automatic Creation of Commission Invoice
Hello everybody, I'm a new user of Ofbiz. I have my ofbiz instance implemented and almost in production mode. Now I need to know how to make ofbiz automaticly creates a commission invoce for each sales order or invoice. I read the user documentation and looks like a aggrements must be created for do that. so I create a aggreement but nothings happen. I searched for two days everywhere without luck Can somebody help me please? some steps to follow would be great. I saw that the method createCommissionInvoices must be executed but I can't make ofbiz to do that. thanks for your time!!
Mechanism of Automatic Accounting Entries
Hi all! I've been looking deeply into accounting services in ofbiz, especially the automatic acct-trans-entries(credit & debit) that will be created if for example Payment is received. For example, for 1 Incoming Payment transaction, ofbiz will automatically created Debit for GlAccountId 00 and Credit for GlAccountId 126000 I got the feeling that it is "hardcoded" somewhere in the services. Is there any mapping existed for this mechanism? Maybe in xml seed data or tables? Something that looks like: Business Process BP-1 --> Accounting Process AcctProc-1, which in turns are: AcctProc-1 --> Debit 00, Credit 126000 (and could be extended) What I want to do is to add one pair of acct-trans-entries, so it would look like: Debit 00 Credit 126000 Debit 123456 Credit 654321 Anyone can help me? Thanks!!! best regards, Johnson Chandra
Re: Products And Automatic Requirements
Adrian - Automating Requirements is supported by MRP module; Opentaps wiki has a very good write up on this; Following is a good starting point http://www.opentaps.org/docs/index.php/Automating_Purchasing_with_Requirements - Sakthi On 2/2/12, Adrian Crum wrote: > I'm trying to figure out how to set up multiple automatic requirements > for a product, and I need some help. > > A product will generate multiple requirements automatically when a sales > order is approved. One requirement is created automatically if inventory > levels fall below a certain point - this requirement triggers a > production run. Another requirement is created automatically when a > sales order is approved regardless of inventory levels - that > requirement is for product installation. > > I spent some time looking through the catalog manager and the > auto-requirements services - createAutoRequirementsForOrder and > createATPRequirementsForOrder. I don't see how to set this up. It > appears that you can assign only one requirement method to a product, > and for some reason that method is connected to inventory. The second > requirement I mentioned (for product installation) is not tied to > inventory, it is a requirement for labor. > > Does anyone know how I can set this up? > > -Adrian > > -- Sent from my mobile device
Re: Products And Automatic Requirements
Thank you for the link, but unfortunately it doesn't tell me anything I don't know already. I ended up creating a custom entity and service to accomplish what I needed. An additional requirement that I hadn't mentioned previously is the ability to trigger automatic requirements based on the internal organization - which I was able to accomplish with the custom entity and service. -Adrian On 2/16/2012 11:41 PM, Integrin Solutions wrote: Adrian - Automating Requirements is supported by MRP module; Opentaps wiki has a very good write up on this; Following is a good starting point http://www.opentaps.org/docs/index.php/Automating_Purchasing_with_Requirements - Sakthi On 2/2/12, Adrian Crum wrote: I'm trying to figure out how to set up multiple automatic requirements for a product, and I need some help. A product will generate multiple requirements automatically when a sales order is approved. One requirement is created automatically if inventory levels fall below a certain point - this requirement triggers a production run. Another requirement is created automatically when a sales order is approved regardless of inventory levels - that requirement is for product installation. I spent some time looking through the catalog manager and the auto-requirements services - createAutoRequirementsForOrder and createATPRequirementsForOrder. I don't see how to set this up. It appears that you can assign only one requirement method to a product, and for some reason that method is connected to inventory. The second requirement I mentioned (for product installation) is not tied to inventory, it is a requirement for labor. Does anyone know how I can set this up? -Adrian
Re: Products And Automatic Requirements
Just so i know, why create a service, why not use MRP module for automating Requirements management? Am i missing your point? - Sakthi On 2/16/12, Adrian Crum wrote: > Thank you for the link, but unfortunately it doesn't tell me anything I > don't know already. > > I ended up creating a custom entity and service to accomplish what I > needed. An additional requirement that I hadn't mentioned previously is > the ability to trigger automatic requirements based on the internal > organization - which I was able to accomplish with the custom entity and > service. > > -Adrian > > On 2/16/2012 11:41 PM, Integrin Solutions wrote: >> Adrian - >> >> Automating Requirements is supported by MRP module; Opentaps wiki has >> a very good write up on this; Following is a good starting point >> http://www.opentaps.org/docs/index.php/Automating_Purchasing_with_Requirements >> >> - Sakthi >> >> On 2/2/12, Adrian Crum wrote: >>> I'm trying to figure out how to set up multiple automatic requirements >>> for a product, and I need some help. >>> >>> A product will generate multiple requirements automatically when a sales >>> order is approved. One requirement is created automatically if inventory >>> levels fall below a certain point - this requirement triggers a >>> production run. Another requirement is created automatically when a >>> sales order is approved regardless of inventory levels - that >>> requirement is for product installation. >>> >>> I spent some time looking through the catalog manager and the >>> auto-requirements services - createAutoRequirementsForOrder and >>> createATPRequirementsForOrder. I don't see how to set this up. It >>> appears that you can assign only one requirement method to a product, >>> and for some reason that method is connected to inventory. The second >>> requirement I mentioned (for product installation) is not tied to >>> inventory, it is a requirement for labor. >>> >>> Does anyone know how I can set this up? >>> >>> -Adrian >>> >>> > -- Sent from my mobile device
automatic timezone conversion in OFbiz
Hello Community, Can anyone confirm if the timezone conversion in OFbiz is supported in multi tenant system? Like there are three tenants in different timezone and the ofbiz is deployed on a server in 4th timezone. Will all the tenants be able to view time according to their own timezone? And it will be helpful to know if the conversion is done according to the browser it opens in or by the system it is running on. Thank You Regards, Swati Srivastava (Software Development Engineer) (Xerus Systems LLC)
Re: POS automatic GL posting disable
Look for createAcctgTrans string in all *eca*.xml Jacques - Original Message - From: "Jeff Burton" <[EMAIL PROTECTED]> To: Sent: Friday, February 29, 2008 2:41 AM Subject: POS automatic GL posting disable I'd like to disable the automatic GL posting on the POS side, and just have that happen when the order hits the server via a sync. Any pointers or explicit directions would be appreciated. Thanks.
Re: MySQL database automatic periodic backup
if you talking about the actual database no. this would require a class that is specific to each database that would be specified in the entityengine.xml however if you look at webtools, you can export the data as entities. using that as a model you can export and add date-time to the files. this then can be run as a re-occurring service. Bruno Busco sent the following on 12/7/2008 8:03 AM: > Hi list, > I would like to have OFBiz automatically backup its own database at regular > time intervals. > Has someone already done something similar or could offer me some idea on > the best way to implement it? > > Many thanks, > -Bruno >
Re: MySQL database automatic periodic backup
Hi BJ, sometime I read in the list that the OFBiz export fuctionality was not intended to be used to perform a system administration database backup. I was thinking to run through an OFBiz re-occurring service an external mysql dump command or similar. Are somewhere examples of running similar external applications from OFBiz? Many thanks, -Bruno 2008/12/7 BJ Freeman <[EMAIL PROTECTED]> > if you talking about the actual database no. > this would require a class that is specific to each database that would > be specified in the entityengine.xml > > however if you look at webtools, you can export the data as entities. > using that as a model you can export and add date-time to the files. > this then can be run as a re-occurring service. > > > Bruno Busco sent the following on 12/7/2008 8:03 AM: > > Hi list, > > I would like to have OFBiz automatically backup its own database at > regular > > time intervals. > > Has someone already done something similar or could offer me some idea on > > the best way to implement it? > > > > Many thanks, > > -Bruno > > >
Re: MySQL database automatic periodic backup
Each database has a different way to back up. so yes, if you write the low level database dependent class then write a general back service that call the back up class that has been loaded for that database, you could do this. Bruno Busco sent the following on 12/7/2008 10:26 AM: > Hi BJ, > sometime I read in the list that the OFBiz export fuctionality was not > intended to be used to perform a system administration database backup. > I was thinking to run through an OFBiz re-occurring service an external > mysql dump command or similar. > > Are somewhere examples of running similar external applications from OFBiz? > > Many thanks, > -Bruno > > 2008/12/7 BJ Freeman <[EMAIL PROTECTED]> > >> if you talking about the actual database no. >> this would require a class that is specific to each database that would >> be specified in the entityengine.xml >> >> however if you look at webtools, you can export the data as entities. >> using that as a model you can export and add date-time to the files. >> this then can be run as a re-occurring service. >> >> >> Bruno Busco sent the following on 12/7/2008 8:03 AM: >>> Hi list, >>> I would like to have OFBiz automatically backup its own database at >> regular >>> time intervals. >>> Has someone already done something similar or could offer me some idea on >>> the best way to implement it? >>> >>> Many thanks, >>> -Bruno >>> >
Re: MySQL database automatic periodic backup
It sounds like it would be better to keep this out of OFBiz if you don't want the data running through the Entity Engine and the applications. Yes, the service engine supports scheduled services and you can use "hack-ish" things to call command-line programs, but cron is way more direct and because it can more easily run on the same machine and is much smaller and has less "moving parts" than OFBiz, it would be more reliable. -David On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote: Hi BJ, sometime I read in the list that the OFBiz export fuctionality was not intended to be used to perform a system administration database backup. I was thinking to run through an OFBiz re-occurring service an external mysql dump command or similar. Are somewhere examples of running similar external applications from OFBiz? Many thanks, -Bruno 2008/12/7 BJ Freeman <[EMAIL PROTECTED]> if you talking about the actual database no. this would require a class that is specific to each database that would be specified in the entityengine.xml however if you look at webtools, you can export the data as entities. using that as a model you can export and add date-time to the files. this then can be run as a re-occurring service. Bruno Busco sent the following on 12/7/2008 8:03 AM: Hi list, I would like to have OFBiz automatically backup its own database at regular time intervals. Has someone already done something similar or could offer me some idea on the best way to implement it? Many thanks, -Bruno
Re: MySQL database automatic periodic backup
Agree on not putting the backup inside the backuped system. Run it either cold or hot, I run mysqldump every day and the backups are nicely restored with load (set constraints off, load, set constraints on). Regards, Sven 2008/12/7 David E Jones <[EMAIL PROTECTED]> > > It sounds like it would be better to keep this out of OFBiz if you don't > want the data running through the Entity Engine and the applications. > > Yes, the service engine supports scheduled services and you can use > "hack-ish" things to call command-line programs, but cron is way more direct > and because it can more easily run on the same machine and is much smaller > and has less "moving parts" than OFBiz, it would be more reliable. > > -David > > > > On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote: > > Hi BJ, >> sometime I read in the list that the OFBiz export fuctionality was not >> intended to be used to perform a system administration database backup. >> I was thinking to run through an OFBiz re-occurring service an external >> mysql dump command or similar. >> >> Are somewhere examples of running similar external applications from >> OFBiz? >> >> Many thanks, >> -Bruno >> >> 2008/12/7 BJ Freeman <[EMAIL PROTECTED]> >> >> if you talking about the actual database no. >>> this would require a class that is specific to each database that would >>> be specified in the entityengine.xml >>> >>> however if you look at webtools, you can export the data as entities. >>> using that as a model you can export and add date-time to the files. >>> this then can be run as a re-occurring service. >>> >>> >>> Bruno Busco sent the following on 12/7/2008 8:03 AM: >>> Hi list, I would like to have OFBiz automatically backup its own database at >>> regular >>> time intervals. Has someone already done something similar or could offer me some idea on the best way to implement it? Many thanks, -Bruno >>> >
Re: MySQL database automatic periodic backup
Many thanks for the clarification. I will definitively go with cron. -Bruno 2008/12/7 Sven Wesley <[EMAIL PROTECTED]> > Agree on not putting the backup inside the backuped system. Run it either > cold or hot, I run mysqldump every day and the backups are nicely restored > with load (set constraints off, load, set constraints on). > > Regards, > Sven > > 2008/12/7 David E Jones <[EMAIL PROTECTED]> > > > > > It sounds like it would be better to keep this out of OFBiz if you don't > > want the data running through the Entity Engine and the applications. > > > > Yes, the service engine supports scheduled services and you can use > > "hack-ish" things to call command-line programs, but cron is way more > direct > > and because it can more easily run on the same machine and is much > smaller > > and has less "moving parts" than OFBiz, it would be more reliable. > > > > -David > > > > > > > > On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote: > > > > Hi BJ, > >> sometime I read in the list that the OFBiz export fuctionality was not > >> intended to be used to perform a system administration database backup. > >> I was thinking to run through an OFBiz re-occurring service an external > >> mysql dump command or similar. > >> > >> Are somewhere examples of running similar external applications from > >> OFBiz? > >> > >> Many thanks, > >> -Bruno > >> > >> 2008/12/7 BJ Freeman <[EMAIL PROTECTED]> > >> > >> if you talking about the actual database no. > >>> this would require a class that is specific to each database that would > >>> be specified in the entityengine.xml > >>> > >>> however if you look at webtools, you can export the data as entities. > >>> using that as a model you can export and add date-time to the files. > >>> this then can be run as a re-occurring service. > >>> > >>> > >>> Bruno Busco sent the following on 12/7/2008 8:03 AM: > >>> > Hi list, > I would like to have OFBiz automatically backup its own database at > > >>> regular > >>> > time intervals. > Has someone already done something similar or could offer me some idea > on > the best way to implement it? > > Many thanks, > -Bruno > > > >>> > > >
Re: Automatic Requirements when QOH drops
the data model book Vol I page 132-158 pretty much covers the data model, requirements,Requests,Agreements. this included roles. did you use just seed data or the demo data? the current implementation OTTB uses the manufacturing component. so you will have to dig through the demo data and the manufacturing code to figure out how to go around it. applications\manufacturing\src\org\ofbiz\manufacturing\mrp\ProposedOrder.java will give yu an Idea of the current implementation and considerations. NPOfbiz sent the following on 7/20/2010 8:16 AM: I have been trying my hand to get setting up Requirements to be generated when QOH reaches minimum stock. My intention is to generate POs when QOH reeaches low levels. I do not want to use MRPs. I tried reading through user lists but was not able to get what suited above requirement. I have simple prodcut setup. Fan - Finished product Motor - Raw material FanBlades - Raw material I want to produce a Fan from Motor and Fanblades. Please assume that we manufacture FAN so there is no need to create PO for Fan. For Motor and Fanblades, below are setup In product screen, Requirement Method Enum Id - (PRODRQM_STOCK) When QOH Reaches Minimum Stock for Product-Facility In product screen, Require Inventory - Y In product->setup Supplier tab, main supplier, Last Price and Supplier prod id In product->setup facilities tab, I have minimum stock and reorder qty setup For FAN, below is setup In product screen, Requirement Method Enum Id Blank In product screen, Require Inventory - N In product->No setup on Supplier tab In product->setup facilities tab, I have minimum stock and reorder qty setup Inventory levels are such that if I approve 1 sales order or 1 Fan, inventory levels of Motor and fanblades will drop below QOH. I create and approve 1 sales order. However i do not see requirements created for Motor and fanblades. Can you please suggest what i am missing here? Or is there anything wrong in configuration. Thanks in advance!
Re: Automatic Requirements when QOH drops
Thanks for the reply. I use demo data setup. And ofbiz as user with all admin privileges. I think I should rephrase my question to make it more clear. Is it possible to create automatic requirements only for raw materials and not for finished goods? In above example, there is no neeed to create requirement for Fan since the company manufactures Fan. But if the raw materials QOH drops below minimum, we would want POs to be created for raw materials. I know this can be done in MRP. I am not sure if this can happen when we process Sales order which results in inventory going low. I have read that this should happen, but perhaps not able to figure the configuration right. Whats puzzling me is I am setting Requirement Method Enum Id to Blank for Fan (finished good) and PRODRQM_STOCK for raw materials. Will this work fine? What am I missing in the settings? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Requirements-when-QOH-drops-tp2295670p2296634.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Creation of Commission Invoice
In accounting -> invoices, did you see the the 'commission run' button? Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. On Thu, 2011-08-25 at 22:40 -0500, Carlos Guzman wrote: > Hello everybody, > > I'm a new user of Ofbiz. I have my ofbiz instance implemented and almost > in production mode. > Now I need to know how to make ofbiz automaticly creates a commission > invoce for each sales order or invoice. > I read the user documentation and looks like a aggrements must be > created for do that. so I create a aggreement but nothings happen. > > I searched for two days everywhere without luck > Can somebody help me please? some steps to follow would be great. > I saw that the method createCommissionInvoices must be executed but I > can't make ofbiz to do that. > > thanks for your time!!
Re: Automatic Creation of Commission Invoice
Hello Hans, Yes, I saw the button and see the person there whom I must pay. but only the "Find" button is available and nothing happens. When I create a order, I include this party too... but same result. any suggestion? thanks for your fast response! hans_bakker wrote: > > In accounting -> invoices, did you see the the 'commission run' button? > > Regards, > Hans > > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Myself on twitter: http://twitter.com/hansbak > Antwebsystems.com: Quality services for competitive rates. > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3769969.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Creation of Commission Invoice
I did not use it yet, but what i would do is check the screen what the selection criteria are (InvoiceScreens.xml#CommissionRun from the page source) That would tell you what is required and then work from there? Regards, Hans On Thu, 2011-08-25 at 21:08 -0700, cguZZman wrote: > Hello Hans, > > Yes, I saw the button and see the person there whom I must pay. but only the > "Find" button is available and nothing happens. > When I create a order, I include this party too... but same result. > any suggestion? > thanks for your fast response! > > > > hans_bakker wrote: > > > > In accounting -> invoices, did you see the the 'commission run' button? > > > > Regards, > > Hans > > > > > > -- > > Ofbiz on twitter: http://twitter.com/apache_ofbiz > > Myself on twitter: http://twitter.com/hansbak > > Antwebsystems.com: Quality services for competitive rates. > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3769969.html > Sent from the OFBiz - User mailing list archive at Nabble.com. -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.
Re: Automatic Creation of Commission Invoice
Hello Carlos, If you want to create automatic Commission invoice, you need to take care of these points : 1. Sales Order should have been placed by selecting additional party(Person) from the Additional Party page. 2. Sales Order should be completed and invoice should be in Paid status. 3. Role for additional party should be Sales Representative. 4. Commission Agreement should exist for the product(s) added in order w.r.t the additional party. Once you run all these point you will be able to search Commission Invoice in Commission Run screen. You can refer these links as example : 1. Sales Order using DemoRepAll as Sales Representative : https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011. 2. Commission Agreement : https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000 3. Commission Invoice (Commission Run screen) : https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun HTH -- Regards Surya Kusumakar
Re: Automatic Creation of Commission Invoice
Hans, Surya thanks for you response. Surya, I follow your points and I can see the invoces now. but when I select an invoice and select the action Commision Run and clic the Run button, I get this error: org.ofbiz.webapp.control.RequestHandlerException: Unknown request [processCommissionRun]; this request does not exist or cannot be called directly. I saw the code of the controller of accounting and really it does not exist. I'm using ofbiz 10.4. then I saw the trunk version of the controller and yes, there does exist. looks like I need to move to the trunk version. Surya Kusumakar-2 wrote: > > Hello Carlos, > > If you want to create automatic Commission invoice, you need to take care > of > these points : > > 1. Sales Order should have been placed by selecting additional > party(Person) > from the Additional Party page. > 2. Sales Order should be completed and invoice should be in Paid status. > 3. Role for additional party should be Sales Representative. > 4. Commission Agreement should exist for the product(s) added in order > w.r.t > the additional party. > > Once you run all these point you will be able to search Commission Invoice > in Commission Run screen. > > You can refer these links as example : > > 1. Sales Order using DemoRepAll as Sales Representative : > https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011. > > 2. Commission Agreement : > https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000 > > 3. Commission Invoice (Commission Run screen) : > https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun > > HTH > > -- > Regards > Surya Kusumakar > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773092.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Creation of Commission Invoice
Hi Carlos, There is one more issue on Commission Run screen, the Commission invoice which is shown on Commission Run screen is actually Sales Invoice (Sales Order one) with Paid status, but it should be Commission Invoice with In Process status. There is some bug in code, Commission Invoice is actually not getting created. -- Thanks & Regards Surya Kusumakar On Sat, Aug 27, 2011 at 8:29 PM, cguZZman wrote: > Hans, Surya thanks for you response. > > Surya, I follow your points and I can see the invoces now. > but when I select an invoice and select the action Commision Run and clic > the Run button, I get this error: > org.ofbiz.webapp.control.RequestHandlerException: Unknown request > [processCommissionRun]; this request does not exist or cannot be called > directly. > > I saw the code of the controller of accounting and really it does not > exist. > I'm using ofbiz 10.4. > then I saw the trunk version of the controller and yes, there does exist. > > looks like I need to move to the trunk version. > > > Surya Kusumakar-2 wrote: > > > > Hello Carlos, > > > > If you want to create automatic Commission invoice, you need to take care > > of > > these points : > > > > 1. Sales Order should have been placed by selecting additional > > party(Person) > > from the Additional Party page. > > 2. Sales Order should be completed and invoice should be in Paid status. > > 3. Role for additional party should be Sales Representative. > > 4. Commission Agreement should exist for the product(s) added in order > > w.r.t > > the additional party. > > > > Once you run all these point you will be able to search Commission > Invoice > > in Commission Run screen. > > > > You can refer these links as example : > > > > 1. Sales Order using DemoRepAll as Sales Representative : > > > https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011 > . > > > > 2. Commission Agreement : > > > https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000 > > > > 3. Commission Invoice (Commission Run screen) : > > https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun > > > > HTH > > > > -- > > Regards > > Surya Kusumakar > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773092.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Mechanism of Automatic Accounting Entries
Hello Jaya, ofbiz create a debit for GlAccountId 00 because your payment method are linked to that account. when the payment was made, I think it was made to the "Company Account", "Electronic Funds Transfer" or "Financial Account". so you can change the GL account in Organization GL Settings > Setup > GL Account Defaults > Payment Method ID/GL Account ID and about the account 126000, you can configure this in the option "GL ACCOUNT TYPE DEFAULTS" editing the GL account type for "Accounts Receivable - Unapplied Payments". I hope this help. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Mechanism-of-Automatic-Accounting-Entries-tp3771119p3773134.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Creation of Commission Invoice
Hi Surya, I saw that, and I thought the commission invoice would create when the button "Run" is pressed. so, what does the button "Run"? I can't get this button do something because of the error above. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773157.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Automatic Creation of Commission Invoice
Hi Carlos, Sorry for the confusion, yes Run button actually creates Commission Invoice against the Sales Invoice, but it is not working on Trunk as well. The purpose Run button is to create Commission Invoice in In Process status against the Paid Sales Invoice. -- Thanks & Regards Surya Kusumakar On Sat, Aug 27, 2011 at 9:05 PM, cguZZman wrote: > Hi Surya, > > I saw that, and I thought the commission invoice would create when the > button "Run" is pressed. > so, what does the button "Run"? > I can't get this button do something because of the error above. > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773157.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Automatic Creation of Commission Invoice
Hi Surya, Thanks for the info. I will install Trunk version anyway and see what is going on and try to fix it. This feature is almost critical to use ofbiz in my bussiness. thank you and I will give news later. El 27/08/2011 11:53 a.m., Surya Kusumakar escribió: Hi Carlos, Sorry for the confusion, yes Run button actually creates Commission Invoice against the Sales Invoice, but it is not working on Trunk as well. The purpose Run button is to create Commission Invoice in In Process status against the Paid Sales Invoice.
Re: Automatic Creation of Commission Invoice
you will find he answer in \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml and InvoicesServices.createCommissionInvoices I run it as a scheduled service. Carlos Guzman sent the following on 8/27/2011 10:21 AM: > Hi Surya, > Thanks for the info. I will install Trunk version anyway and see what is > going on and try to fix it. This feature is almost critical to use ofbiz > in my bussiness. > thank you and I will give news later. > > > El 27/08/2011 11:53 a.m., Surya Kusumakar escribió: >> Hi Carlos, >> >> Sorry for the confusion, yes Run button actually creates Commission >> Invoice >> against the Sales Invoice, but it is not working on Trunk as well. The >> purpose Run button is to create Commission Invoice in In Process status >> against the Paid Sales Invoice. >> >
Re: Automatic Creation of Commission Invoice
Hello BJ, thanks for you response. Please, tell us how you get it working? what should we do? El 27/08/2011 01:05 p.m., BJ Freeman escribió: you will find he answer in \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml and InvoicesServices.createCommissionInvoices I run it as a scheduled service. Carlos Guzman sent the following on 8/27/2011 10:21 AM: Hi Surya, Thanks for the info. I will install Trunk version anyway and see what is going on and try to fix it. This feature is almost critical to use ofbiz in my bussiness. thank you and I will give news later. El 27/08/2011 11:53 a.m., Surya Kusumakar escribió: Hi Carlos, Sorry for the confusion, yes Run button actually creates Commission Invoice against the Sales Invoice, but it is not working on Trunk as well. The purpose Run button is to create Commission Invoice in In Process status against the Paid Sales Invoice.
Re: Automatic Creation of Commission Invoice
you will have to modify the sample code for affiliates commissions if you want to use that. I suggest you read the InvoicesServices.createCommissionInvoices to understand what has to be completed to run the service. you can go to webtools and find the service then setup the scheduled run from there. you can look at the code that run the service in the webtools to complete the code for the page. if you want it automatic schedules service then use one of the current code as a template. Carlos Guzman sent the following on 8/27/2011 11:18 AM: > Hello BJ, thanks for you response. > Please, tell us how you get it working? > what should we do? > > > > El 27/08/2011 01:05 p.m., BJ Freeman escribió: >> you will find he answer in >> \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml >> >> and >> InvoicesServices.createCommissionInvoices >> >> I run it as a scheduled service. >> >> Carlos Guzman sent the following on 8/27/2011 10:21 AM: >>> Hi Surya, >>> Thanks for the info. I will install Trunk version anyway and see what is >>> going on and try to fix it. This feature is almost critical to use ofbiz >>> in my bussiness. >>> thank you and I will give news later. >>> >>> >>> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió: >>>> Hi Carlos, >>>> >>>> Sorry for the confusion, yes Run button actually creates Commission >>>> Invoice >>>> against the Sales Invoice, but it is not working on Trunk as well. The >>>> purpose Run button is to create Commission Invoice in In Process status >>>> against the Paid Sales Invoice. >>>> >
Re: Automatic Creation of Commission Invoice
here is a jira that may be of interest https://issues.apache.org/jira/browse/OFBIZ-2713 Carlos Guzman sent the following on 8/27/2011 11:18 AM: > Hello BJ, thanks for you response. > Please, tell us how you get it working? > what should we do? > > > > El 27/08/2011 01:05 p.m., BJ Freeman escribió: >> you will find he answer in >> \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml >> >> and >> InvoicesServices.createCommissionInvoices >> >> I run it as a scheduled service. >> >> Carlos Guzman sent the following on 8/27/2011 10:21 AM: >>> Hi Surya, >>> Thanks for the info. I will install Trunk version anyway and see what is >>> going on and try to fix it. This feature is almost critical to use ofbiz >>> in my bussiness. >>> thank you and I will give news later. >>> >>> >>> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió: Hi Carlos, Sorry for the confusion, yes Run button actually creates Commission Invoice against the Sales Invoice, but it is not working on Trunk as well. The purpose Run button is to create Commission Invoice in In Process status against the Paid Sales Invoice. >
Re: Create automatic supplying for the company
ofbiz automatically creates PO's but does not send them to suppliers. I did some work on this but it has stopped. it is not in the distribution. You would either have to do this or have someone do it for you. here is a demo. take a look at what it does. Think you will find what you want is there. http://demo.hotwaxmedia.com/ecommerce/control/product/~category_id=PROMOTIONS/~product_id=GZ-2644 everything goes to the Database. you would have to write something to export to the xml format you want. > ladroge sent the following on 2/11/2008 3:33 AM: >> I want to know how to plan an automatic supplying order for product when it >> is backordered. >> The second problem is how to create a link on the ecommerce website when a >> customer select a product he will be redirected to the form to write detail >> according the product and these details will be saved on the database.(XML >> document integration to the website). >> >> Thanks >> > > > >
Re: Create automatic supplying for the company
send to the user Mailing list ladroge sent the following on 2/11/2008 3:33 AM: > I want to know how to plan an automatic supplying order for product when it > is backordered. > The second problem is how to create a link on the ecommerce website when a > customer select a product he will be redirected to the form to write detail > according the product and these details will be saved on the database.(XML > document integration to the website). > > Thanks >
automatic subscription extension cancellation how to do?
Question to the community: I have a customer who would like to have subscriptions extended automatically unless cancelled before 1 month before the ending of the subscription period. What i was thinking about is adding some fields to the subscription entity called 'extent' which could be 'N' indicating the subscription should not be extended. It is also required to be able to add a period before the subscription can be cancelled. Then we will need a service which creates automatically an order, copying the original order for the next subscription period, at the moment the subscription expires. This order will then create a new subscription. So i think we need 3 new fields: extent: N or Y/blank cancelPeriod cancelPeriodUomId Is this the best way to do it? Regards, Hans -- AntWebsystems.com: Quality OFBiz services for competitive rates.
About automatic purchase order ship and receive
Hi all, We have implement automatically purchase order ship and receive by the follow step, 1. Create a customize service and invoke service quickShipPurchaseOrder and receiveInventoryProduct 2. Add a customize eca service as below to invoke this new defined service. So does anybody also did this kind of change before and can u advice us that whether there would be any impact to the out-of-the-box process for this change? Regards, Liu Xiangqian Wizitsoft Information Technology Ltd. www.wizitsoft.com | (86) 010-62670653 ext 614
Re: automatic subscription extension cancellation how to do?
The current design uses the Subscription entity only for already paid subscriptions. For automatic renewals the current code and such uses the ShoppingList with the auto-reorder type to automatically reorder the product that will extend the Subscription. -David On May 15, 2008, at 12:30 AM, Hans Bakker wrote: Question to the community: I have a customer who would like to have subscriptions extended automatically unless cancelled before 1 month before the ending of the subscription period. What i was thinking about is adding some fields to the subscription entity called 'extent' which could be 'N' indicating the subscription should not be extended. It is also required to be able to add a period before the subscription can be cancelled. Then we will need a service which creates automatically an order, copying the original order for the next subscription period, at the moment the subscription expires. This order will then create a new subscription. So i think we need 3 new fields: extent: N or Y/blank cancelPeriod cancelPeriodUomId Is this the best way to do it? Regards, Hans -- AntWebsystems.com: Quality OFBiz services for competitive rates.
Re: automatic subscription extension cancellation how to do?
Now we have a subscription, isn't using the subscription a better way to go then the shopping list? A much better implementation especially if you think that a subscription is repetitive in nature anyway. andone way should not exclude the other way? is there a problem when i would add this? What is the opinion of the community? On Thu, 2008-05-15 at 00:35 -0600, David E Jones wrote: > The current design uses the Subscription entity only for already paid > subscriptions. > > For automatic renewals the current code and such uses the ShoppingList > with the auto-reorder type to automatically reorder the product that > will extend the Subscription. > > -David > > > On May 15, 2008, at 12:30 AM, Hans Bakker wrote: > > > Question to the community: > > > > I have a customer who would like to have subscriptions extended > > automatically unless cancelled before 1 month before the ending of the > > subscription period. > > > > What i was thinking about is adding some fields to the subscription > > entity called 'extent' which could be 'N' indicating the subscription > > should not be extended. It is also required to be able to add a period > > before the subscription can be cancelled. > > > > Then we will need a service which creates automatically an order, > > copying the original order for the next subscription period, at the > > moment the subscription expires. This order will then create a new > > subscription. > > > > So i think we need 3 new fields: > > > > extent: N or Y/blank > > cancelPeriod > > cancelPeriodUomId > > > > Is this the best way to do it? > > > > Regards, > > Hans > > -- > > AntWebsystems.com: Quality OFBiz services for competitive rates. > > > > -- AntWebsystems.com: Quality OFBiz services for competitive rates.
Re: automatic subscription extension cancellation how to do?
Hans, why you don't want to use auto reorder ShoppingList? It is already working the way you described? Bilgin
Re: automatic subscription extension cancellation how to do?
Bilgin, The main problem i have is that this customer is not using the ecommerce and want to handle this from the backend. Did you try to add a recurring order from the backend? enter the order for the subscription product, then: 1. go to party, 2. find the customer 3. create the shoppinglist 4. enter the recurrence: not available 5. enter the productid. 6. activate the shoppinglist when the customer cancels the subscription: 1. go to party, 2. find the customer 3. find the related shoppinglist (if there are more subscriptions) 4. remove the product from the shoppinglist Now the proposed way: - create: enter the order for the subscription product to cancel: 1. go to catalog -> subscriptions 2. list all subscriptions for that customer. 3. set the extent flag to 'N' on the particular subscription. In the frontend, we could add an extra column in the orderlist: subscription with the ability to cancel the subscription. regards, Hans On Thu, 2008-05-15 at 11:29 +0300, Bilgin Ibryam wrote: > Hans, > > why you don't want to use auto reorder ShoppingList? It is already > working the way you described? > > Bilgin > > > -- AntWebsystems.com: Quality OFBiz services for competitive rates.
Re: automatic subscription extension cancellation how to do?
On Thu, 2008-05-15 at 16:09 +0700, Hans Bakker wrote: > Bilgin, > The main problem i have is that this customer is not using the > ecommerce > and want to handle this from the backend. One solution could be adding a screen to order manager, where the user can create auto reorders for existing orders. Just my 2 cents
Re: About automatic purchase order ship and receive
Hello Liu, Now in OFBiz , When Purchase Order is placed, Order is in ORDER_CREATED status and item in order is in ITEM_CREATED status. So when user clicks on link of "Approve Order" then, Order is in ORDER_APPROVED status and item in Order is in ITEM_APPROVED status. So according to your service when ever user Clicks on Approve Order link, Shipment will be created automatically and Inventory will also be received automatically. And if receive is successfull then Order will be in Complete status. But if user approves the order and if he wish to edit items or add more items in order after that. Then your service will be killing this process. Presently if User clicks on Approve Order then an option occurs for "Quick Receive Purchase Order". This is a multi process step where Shipment is created first and then Order items are received for this Shipment. So to automate this process, we can have functionality like when user clicks on "Quick Receive Purchase Order" then quickShipPurchaseOrder and receiveInventoryProduct should be called automatically. And so this multi step process can be reduced to single step process. Lets see what community says on this. Thanks -Divesh Hi all, We have implement automatically purchase order ship and receive by the follow step, 1. Create a customize service and invoke service quickShipPurchaseOrder and receiveInventoryProduct 2. Add a customize eca service as below to invoke this new defined service. So does anybody also did this kind of change before and can u advice us that whether there would be any impact to the out-of-the-box process for this change? Regards, Liu Xiangqian Wizitsoft Information Technology Ltd. www.wizitsoft.com | (86) 010-62670653 ext 614
Re: About automatic purchase order ship and receive
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ECA is to modify or update an Entity, like re-calc the grand total of an order in the orderheader. SCA is when you want to perform operations based on some other event like a service update. So yours should be an SCA Should review how a SCA works. Looks like you may be doing Dropshipper. if your using the trunk have you reviewed The dropshipper code. Larry.Liu sent the following on 3/2/2009 10:34 PM: > Hi all, > > We have implement automatically purchase order ship and receive > > by the follow step, > > 1. Create a customize service and invoke service quickShipPurchaseOrder and > receiveInventoryProduct > > 2. Add a customize eca service as below to invoke this new defined service. > > > > > > > So does anybody also did this kind of change before and can u advice us that > whether there would be any impact to the out-of-the-box process for this > change? > > Regards, > Liu Xiangqian > > Wizitsoft Information Technology Ltd. > www.wizitsoft.com | (86) 010-62670653 ext 614 > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJrQ1trP3NbaWWqE4RAph6AJ9wMWNCdIFiuT7hRQBec8K/HKOcIwCgtN2y sdGlso9kyck9JZfeHFX0yYI= =jtvl -END PGP SIGNATURE-
Re: About automatic purchase order ship and receive
Hi Freeman, As you adviced, it's better to do this in SCA rather than ECA and give an example of dropshipper, but we have search throught the latest trunk of Ofbiz, but didn't find any code related to dropshipper, can you please give any advice on where do these code located? BTW: by SCA, do you mean service condition action, just common service? Thanks Regards, Liu Xiangqian Wizitsoft Information Technology Ltd. www.wizitsoft.com | (86) 010-62670653 ext 614 On Tue, Mar 3, 2009 at 6:58 PM, BJ Freeman wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > ECA is to modify or update an Entity, like re-calc the grand total of an > order in the orderheader. > SCA is when you want to perform operations based on some other event > like a service update. > So yours should be an SCA > Should review how a SCA works. > Looks like you may be doing Dropshipper. > if your using the trunk have you reviewed The dropshipper code. > > Larry.Liu sent the following on 3/2/2009 10:34 PM: > > Hi all, > > > > We have implement automatically purchase order ship and receive > > > > by the follow step, > > > > 1. Create a customize service and invoke service quickShipPurchaseOrder > and > > receiveInventoryProduct > > > > 2. Add a customize eca service as below to invoke this new defined > service. > > > > > > > > > > > > > > So does anybody also did this kind of change before and can u advice us > that > > whether there would be any impact to the out-of-the-box process for this > > change? > > > > Regards, > > Liu Xiangqian > > > > Wizitsoft Information Technology Ltd. > > www.wizitsoft.com | (86) 010-62670653 ext 614 > > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.6 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFJrQ1trP3NbaWWqE4RAph6AJ9wMWNCdIFiuT7hRQBec8K/HKOcIwCgtN2y > sdGlso9kyck9JZfeHFX0yYI= > =jtvl > -END PGP SIGNATURE- >
Re: About automatic purchase order ship and receive
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dropshipper items must be in the Dropshipper Category. https://demo.hotwaxmedia.com/catalog/control/EditCategory?productCategoryId=dropShip you can find info in applications\product\data\ProductTypeData.xml PRODRQM_DS PRODRQM_DSQOH also DROP_SHIPMENT as a shipment.shipmentTypeId SCA=service Condition Action. However in researching a link for you I found http://docs.ofbiz.org/display/OFBTECH/Service+Engine+Guide Now refrers to it as a Event Condition action. Larry.Liu sent the following on 3/5/2009 12:05 AM: > Hi Freeman, > > As you adviced, it's better to do this in SCA rather than ECA and give an > example of dropshipper, but we have search throught the latest trunk of > Ofbiz, but didn't find any code related to dropshipper, can you please give > any advice on where do these code located? > > BTW: by SCA, do you mean service condition action, just common service? > > Thanks > > Regards, > Liu Xiangqian > > Wizitsoft Information Technology Ltd. > www.wizitsoft.com | (86) 010-62670653 ext 614 > > > On Tue, Mar 3, 2009 at 6:58 PM, BJ Freeman wrote: > > ECA is to modify or update an Entity, like re-calc the grand total of an > order in the orderheader. > SCA is when you want to perform operations based on some other event > like a service update. > So yours should be an SCA > Should review how a SCA works. > Looks like you may be doing Dropshipper. > if your using the trunk have you reviewed The dropshipper code. > > Larry.Liu sent the following on 3/2/2009 10:34 PM: Hi all, We have implement automatically purchase order ship and receive by the follow step, 1. Create a customize service and invoke service quickShipPurchaseOrder > and receiveInventoryProduct 2. Add a customize eca service as below to invoke this new defined > service. So does anybody also did this kind of change before and can u advice us > that whether there would be any impact to the out-of-the-box process for this change? Regards, Liu Xiangqian Wizitsoft Information Technology Ltd. www.wizitsoft.com | (86) 010-62670653 ext 614 >> -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJsAhErP3NbaWWqE4RAiaQAJ0eikObjxeIepRQnPWd2TPwEqmN/ACgrqtM 3aOhYWShKBhyHeLPcp1MGmo= =aIK+ -END PGP SIGNATURE-
Automatic cache clear for entity elements when doing CRUD operations?
Hi., I am using cache for most of the times for entities (like ProductCategoryMember, ProductCategory, Product, ShipmentMethod, etc.,) to increase the application performance interms of database connections(hits). Now question is ***When create, store or remove operations are done through the Entity Engine, Does it be able to automatically clear any cache entries that might contain the updated value??? * Right now, its not happening to me. If I want to enable this feature, where I need to change/edit the configurations. Please update me with the process to implement this. Thanks in Advance, -- Kumaraswamy.N ecomZera Online Services Pvt. Ltd.
Re: Automatic cache clear for entity elements when doing CRUD operations?
Hi Kumar, UtilCache.clearAllCaches(); delegator.clearAllCaches(); The above methods will be your friends, but method is a shortcut to completely clear all entity engine caches. For performance reasons this should not be called very often. But for sure other methods of UtilCache and delgator object will be of your help. Rishi Solanki Enterprise Software Developer HotWax Media Pvt. Ltd. On Tue, Jan 5, 2010 at 9:40 AM, Kumaraswamy nandipati < kumarasw...@ecomzera.com> wrote: > Hi., > > I am using cache for most of the times for entities (like > ProductCategoryMember, ProductCategory, Product, ShipmentMethod, etc.,) to > increase the application performance interms of database connections(hits). > > Now question is > ***When create, store or remove operations are done through the Entity > Engine, Does it be able to automatically clear any cache entries that might > contain the updated value??? > * > Right now, its not happening to me. If I want to enable this feature, where > I need to change/edit the configurations. Please update me with the process > to implement this. > > Thanks in Advance, > > > -- > Kumaraswamy.N > ecomZera Online Services Pvt. Ltd. >
Re: Automatic cache clear for entity elements when doing CRUD operations?
Hi Rishi, My previous question was not clear I think. Please *apologize* for this. Here, I am writing in clear terms. I am using 2 instances of ofbiz for one of my web application. -First ofbiz instance points e-commerce module only. -Second ofbiz instance used to represent all other modules(catalog, content, partymgr, ordermgr, webtools etc.) These two ofbiz instances hosted on different machines. Communications configured by proxyPass calls at apache. Here goes my problem, I enabled cache for retrieving ProductCategoryMembers. Here, when ever I do any CRUD operations on this entity(i.e, *obiviously happens in second ofbiz instance*), cache gets cleared for second instance only. Its not getting cleared for first instance of Ofbiz. Otherwise I need to wait for certain time on first instance(as per cache.properties file) which is not relevant in this scenario. To refresh cache in these two ofbiz instances at once what I supposed to do? Is there any synchronization technique for this?? On Tue, Jan 5, 2010 at 11:41 AM, Rishi Solanki wrote: > Hi Kumar, > UtilCache.clearAllCaches(); > delegator.clearAllCaches(); > The above methods will be your friends, but method is a shortcut to > completely clear all entity engine caches. For performance reasons this > should not be called very often. > But for sure other methods of UtilCache and delgator object will be of your > help. > > Rishi Solanki > Enterprise Software Developer > HotWax Media Pvt. Ltd. > > > On Tue, Jan 5, 2010 at 9:40 AM, Kumaraswamy nandipati < > kumarasw...@ecomzera.com> wrote: > > > Hi., > > > > I am using cache for most of the times for entities (like > > ProductCategoryMember, ProductCategory, Product, ShipmentMethod, etc.,) > to > > increase the application performance interms of database > connections(hits). > > > > Now question is > > ***When create, store or remove operations are done through the Entity > > Engine, Does it be able to automatically clear any cache entries that > might > > contain the updated value??? > > * > > Right now, its not happening to me. If I want to enable this feature, > where > > I need to change/edit the configurations. Please update me with the > process > > to implement this. > > > > Thanks in Advance, > > > > > > -- > > Kumaraswamy.N > > ecomZera Online Services Pvt. Ltd. > > > -- Thanks, Kumaraswamy.N ecomZera Online Services Pvt. Ltd.
Re: Automatic cache clear for entity elements when doing CRUD operations?
Hi., I am achieving this by using "Socket Connection" and streaming the GenericValue objects which are need to be cache cleared in the other ofbiz instance. Anyhow, there is no such strong cause to enable distributed environment for OfBiz here, so, I chose "Socket Connection with Object Streaming" decistion. Please suggest me that, is there any other best way to achieve this?? On Tue, Jan 5, 2010 at 11:49 AM, Kumaraswamy nandipati < kumarasw...@ecomzera.com> wrote: > Hi Rishi, > > My previous question was not clear I think. Please *apologize* for this. > Here, I am writing in clear terms. > > I am using 2 instances of ofbiz for one of my web application. > -First ofbiz instance points e-commerce module only. > -Second ofbiz instance used to represent all other modules(catalog, > content, partymgr, ordermgr, webtools etc.) > > These two ofbiz instances hosted on different machines. Communications > configured by proxyPass calls at apache. > > Here goes my problem, I enabled cache for retrieving > ProductCategoryMembers. Here, when ever I do any CRUD operations on this > entity(i.e, *obiviously happens in second ofbiz instance*), cache gets > cleared for second instance only. Its not getting cleared for first instance > of Ofbiz. Otherwise I need to wait for certain time on first instance(as per > cache.properties file) which is not relevant in this scenario. > > To refresh cache in these two ofbiz instances at once what I supposed to > do? Is there any synchronization technique for this?? > > > On Tue, Jan 5, 2010 at 11:41 AM, Rishi Solanki wrote: > >> Hi Kumar, >> UtilCache.clearAllCaches(); >> delegator.clearAllCaches(); >> The above methods will be your friends, but method is a shortcut to >> completely clear all entity engine caches. For performance reasons this >> should not be called very often. >> But for sure other methods of UtilCache and delgator object will be of >> your >> help. >> >> Rishi Solanki >> Enterprise Software Developer >> HotWax Media Pvt. Ltd. >> >> >> On Tue, Jan 5, 2010 at 9:40 AM, Kumaraswamy nandipati < >> kumarasw...@ecomzera.com> wrote: >> >> > Hi., >> > >> > I am using cache for most of the times for entities (like >> > ProductCategoryMember, ProductCategory, Product, ShipmentMethod, etc.,) >> to >> > increase the application performance interms of database >> connections(hits). >> > >> > Now question is >> > ***When create, store or remove operations are done through the Entity >> > Engine, Does it be able to automatically clear any cache entries that >> might >> > contain the updated value??? >> > * >> > Right now, its not happening to me. If I want to enable this feature, >> where >> > I need to change/edit the configurations. Please update me with the >> process >> > to implement this. >> > >> > Thanks in Advance, >> > >> > >> > -- >> > Kumaraswamy.N >> > ecomZera Online Services Pvt. Ltd. >> > >> > > > > -- > Thanks, > > Kumaraswamy.N > ecomZera Online Services Pvt. Ltd. > -- Thanks, Kumaraswamy.N 91-9866805250.
Want to hear a story of how automatic services gets fired :)
hiii folks I am just new to ofbiz, i have read through the post "Password Expiry" there i read about "Running a nightly job". I want to know how nightly jobs are triggered, which caused it to run, on which basis its gets triggered, which process is parent of this nightly jobs and automatic async services and what ECA will do for us. If anyone kindly explains it and an example service name (to find out code) it'll be very helpful for me to get overall imagination of the system functioning. regards sakthi
Re: Want to hear a story of how automatic services gets fired :)
https://demo-trunk.ofbiz.apache.org/webtools/control/FindJob click on find pick any of the services you see. sakthi vadivel sent the following on 7/15/2010 11:24 AM: hiii folks I am just new to ofbiz, i have read through the post "Password Expiry" there i read about "Running a nightly job". I want to know how nightly jobs are triggered, which caused it to run, on which basis its gets triggered, which process is parent of this nightly jobs and automatic async services and what ECA will do for us. If anyone kindly explains it and an example service name (to find out code) it'll be very helpful for me to get overall imagination of the system functioning. regards sakthi
Re: Want to hear a story of how automatic services gets fired :)
forgot this one https://demo-trunk.ofbiz.apache.org/webtools/control/scheduleJob sakthi vadivel sent the following on 7/15/2010 11:24 AM: hiii folks I am just new to ofbiz, i have read through the post "Password Expiry" there i read about "Running a nightly job". I want to know how nightly jobs are triggered, which caused it to run, on which basis its gets triggered, which process is parent of this nightly jobs and automatic async services and what ECA will do for us. If anyone kindly explains it and an example service name (to find out code) it'll be very helpful for me to get overall imagination of the system functioning. regards sakthi
Re: Want to hear a story of how automatic services gets fired :)
Hi Sakthi, this will help understand https://cwiki.apache.org/confluence/display/OFBTECH/Service+Engine+Guide On Fri, Jul 16, 2010 at 2:34 AM, BJ Freeman wrote: > forgot this one > https://demo-trunk.ofbiz.apache.org/webtools/control/scheduleJob > > > > > > sakthi vadivel sent the following on 7/15/2010 11:24 AM: > >> hiii folks >> >> >> I am just new to ofbiz, i have read through the post >> "Password Expiry" there i read about "Running a nightly job". >> I want to know how nightly jobs are triggered, which caused it to run, >> on which basis its gets triggered, which process is parent of >> this nightly jobs and automatic async services and what ECA will do for >> us. >> >>If anyone kindly explains it and an example service name >> (to find out code) it'll be very helpful for me to get overall >> imagination of the system functioning. >> >> regards >> sakthi >> >> -- Regards, Varun Bhansaly
Re: Want to hear a story of how automatic services gets fired :)
Hii OFBiz community :) that links was very useful to me. I'm yet to complete reading serviceEngineGuide. I'm interested to know the parent process of this jobs(service), could anyone point out that job specifically. with thanks and regards sakthi On Fri, Jul 16, 2010 at 2:31 AM, BJ Freeman wrote: > https://demo-trunk.ofbiz.apache.org/webtools/control/FindJob > click on find > pick any of the services you see. > > sakthi vadivel sent the following on 7/15/2010 11:24 AM: >> >> hiii folks >> >> I am just new to ofbiz, i have read through the post >> "Password Expiry" there i read about "Running a nightly job". >> I want to know how nightly jobs are triggered, which caused it to run, >> on which basis its gets triggered, which process is parent of >> this nightly jobs and automatic async services and what ECA will do for >> us. >> >> If anyone kindly explains it and an example service name >> (to find out code) it'll be very helpful for me to get overall >> imagination of the system functioning. >> >> regards >> sakthi >> > -- sakthi
Re: Want to hear a story of how automatic services gets fired :)
It is best at this point that you read all the documentation and go through the code for ofbiz It is a necessity to anyone developing in ofbiz. you can start from the homepage click on documentation. to be more direct the links you were given answer this question. sakthi vadivel sent the following on 7/16/2010 3:35 AM: Hii OFBiz community :) that links was very useful to me. I'm yet to complete reading serviceEngineGuide. I'm interested to know the parent process of this jobs(service), could anyone point out that job specifically. with thanks and regards sakthi On Fri, Jul 16, 2010 at 2:31 AM, BJ Freeman wrote: https://demo-trunk.ofbiz.apache.org/webtools/control/FindJob click on find pick any of the services you see. sakthi vadivel sent the following on 7/15/2010 11:24 AM: hiii folks I am just new to ofbiz, i have read through the post "Password Expiry" there i read about "Running a nightly job". I want to know how nightly jobs are triggered, which caused it to run, on which basis its gets triggered, which process is parent of this nightly jobs and automatic async services and what ECA will do for us. If anyone kindly explains it and an example service name (to find out code) it'll be very helpful for me to get overall imagination of the system functioning. regards sakthi
