Missing documentation
The very last line of: http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide appears to be referencing: http://docs.ofbiz.org/display/OFBIZ/Creating+Configurable++Products which has mostly empty content. Is my interpretation of the end-user documentation space for details on how to set these things up incorrect? Should I be looking somewhere else in the wiki or in a different online resource? Your help to fill in the gaps of a walk through of the example configurable products greatly appreciated. -- View this message in context: http://www.nabble.com/Missing-documentation-tp18106207p18106207.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: can any one tell me were orderid is set
thanks for that i solved it.i have another query like where is the shipping address set or how can we set the shipping address explicitly.expects an answer as am working on these stuff for quite a few days. Scott Gray wrote: The order id is available after the storeOrder service has been run. Regards Scott 2008/6/25 Aravind_RP [EMAIL PROTECTED]: hi all Am new to ofbiz order processing session and wish to implement it as a webservice,for that i want to know were the orderid is set for the first time.can any one help me..it is urgent -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18105439.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18106256.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Missing documentation
From: jason_lunn [EMAIL PROTECTED] The very last line of: http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide This is official documentation (see the OFBENDUSER part in URL) appears to be referencing: I can't see any obvious references nor links to http://docs.ofbiz.org/display/OFBIZ/Creating+Configurable++Products which is not part of official documentation but an individual effort (see the OFBIZ part in URL) which has mostly empty content. Is my interpretation of the end-user documentation space for details on how to set these things up incorrect? Should I be looking somewhere else in the wiki or in a different online resource? It's pretty clear from the start : http://docs.ofbiz.org/dashboard.action Your help to fill in the gaps of a walk through of the example configurable products greatly appreciated. If you read French here is one I write some years ago (when I was in the same situation than you), still valid (look for Les articles configurables) http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.pdf Else you may have a look at the DemoConfigurator.xml file Jacques View this message in context: http://www.nabble.com/Missing-documentation-tp18106207p18106207.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: can any one tell me were orderid is set
If your question is where it is saved than PostalAddress is the entity. -Vikas On Wed, Jun 25, 2008 at 12:33 PM, Aravind_RP [EMAIL PROTECTED] wrote: thanks for that i solved it.i have another query like where is the shipping address set or how can we set the shipping address explicitly.expects an answer as am working on these stuff for quite a few days. Scott Gray wrote: The order id is available after the storeOrder service has been run. Regards Scott 2008/6/25 Aravind_RP [EMAIL PROTECTED]: hi all Am new to ofbiz order processing session and wish to implement it as a webservice,for that i want to know were the orderid is set for the first time.can any one help me..it is urgent -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18105439.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18106256.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: help big table display!
Instead of list, use EntityListIterator like entity-condition entity-name=TLog list-name=TLogs use-iterator/ /entity-condition - Vikas On Wed, Jun 25, 2008 at 8:16 AM, stamilo [EMAIL PROTECTED] wrote: hi, i have a big table ,about 10,000 rows data , i use form name=LOGList type=list list-name=examples paginate-target=LOGList actions entity-condition entity-name=TLogorder-by field-name=fKey//entity-condition /actions that , want do display data , but nothing showed , console report : [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2) [StandardWrapperValve. java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception [java] java.lang.OutOfMemoryError: Java heap space how i can display the big table ? thx!
Re: help big table display!
Vikas, If you will noticed David has alread mentioned it in another thread which is generated from this topic :-). Although Stamilo will be double happy to see double reply of his email :-) -- Ashish 2008/6/25 Vikas Mayur [EMAIL PROTECTED]: Instead of list, use EntityListIterator like entity-condition entity-name=TLog list-name=TLogs use-iterator/ /entity-condition - Vikas On Wed, Jun 25, 2008 at 8:16 AM, stamilo [EMAIL PROTECTED] wrote: hi, i have a big table ,about 10,000 rows data , i use form name=LOGList type=list list-name=examples paginate-target=LOGList actions entity-condition entity-name=TLogorder-by field-name=fKey//entity-condition /actions that , want do display data , but nothing showed , console report : [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2) [StandardWrapperValve. java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception [java] java.lang.OutOfMemoryError: Java heap space how i can display the big table ? thx!
Re: can any one tell me were Shipping Address is getting set
No,My question is were or which function sets the shipping address.so if my modification is to directly give an address than making a change in the database then were shall i make my change. Vikas Mayur-2 wrote: If your question is where it is saved than PostalAddress is the entity. -Vikas On Wed, Jun 25, 2008 at 12:33 PM, Aravind_RP [EMAIL PROTECTED] wrote: thanks for that i solved it.i have another query like where is the shipping address set or how can we set the shipping address explicitly.expects an answer as am working on these stuff for quite a few days. Scott Gray wrote: The order id is available after the storeOrder service has been run. Regards Scott 2008/6/25 Aravind_RP [EMAIL PROTECTED]: hi all Am new to ofbiz order processing session and wish to implement it as a webservice,for that i want to know were the orderid is set for the first time.can any one help me..it is urgent -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18105439.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18106256.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18107181.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Need Help with Recurrence Rules
Hi Adrian, There are a total of four entities namely JobSandbox, RecurrenceRule, RecurrenceInfo, RuntimeData (Optinal) that are required to create a schedule service. From UI there are two steps to create a recurrence rule. Second step is optional. This is the step where the data is stored in RuntimeData entity. To create a RecurreceRule go to https://localhost:8443/webtools/control/scheduleJob Step 1 : Lets suppose we want to define a recurrence rule on createPerson service than we can enter values on page reached by above URL like Job = Create a person serviceName = createPerson Frequency = How the service will be called - is it after every second, every minute, every week etc. Select appropriate value from select box Interval = It will a interger value - if specified than the service will be invoked after the interval mentioned (Say we have selected Frequency = MINUTELY, Interval = 5 - the service will be invoked after every 5 minutes) Other fields have good description on this form itself. Once you submit this form, it will take you to second step. As we know that the service createPerson takes two required attributes i.e. firstName and lastName namely. Enter the value for these fields (and optional fields if you want) in second step. Submit this form. So we have now created a schedule service. Now you can status of the job in the job list at https://localhost:8443/webtools/control/jobList For creating a recurrence rule you can refer to the file ManufacturingScheduledServices.xml Rest of comments inline. On Tue, Jun 24, 2008 at 10:55 PM, Adrian Crum [EMAIL PROTECTED] wrote: I've spent hours looking through the recurrence rule code and doing Google searches, but I'm still having a hard time understanding how to set up recurrence rules. Has there been any documentation done on this? I do not see any kind of document supporting these artifacts either. Also, it appears to me there is no way to set up a recurrence that occurs on intervals like: 1. The second Sunday in May 2. The first Monday of every month I think these are not supported yet. or am I missing something? Is there a UI for entering recurrence rules? Any help would greatly appreciated! -Adrian Hope this helps ! - Vikas
Re: can any one tell me were orderid is set
If you take the time to watch the framework introduction videos on docs.ofbiz.org you will be able to answer these questions yourself. All you need to understand is the basic flow between requests, events, services, views, etc, then you can examine the entire order process as it stands in OFBiz and reapply the concepts to your own work. Regards Scott 2008/6/25 Aravind_RP [EMAIL PROTECTED]: thanks for that i solved it.i have another query like where is the shipping address set or how can we set the shipping address explicitly.expects an answer as am working on these stuff for quite a few days. Scott Gray wrote: The order id is available after the storeOrder service has been run. Regards Scott 2008/6/25 Aravind_RP [EMAIL PROTECTED]: hi all Am new to ofbiz order processing session and wish to implement it as a webservice,for that i want to know were the orderid is set for the first time.can any one help me..it is urgent -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18105439.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/can-any-one-tell-me-were-orderid-is-set-tp18105439p18106256.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many entities that should has foreign key but it not, why?
The relation-type = nofk is used when we need a relation but don't want to apply foreign key constraints on it. This relation comes in existance only when we need to use the attribute of a entity into another entity. And we needed that when we delete/expire a record from entity say PaymentBudgetAllocation then their is no need to delete the record from BudgetItem. In such case we specify relation-type = nofk. Thanks and Regards [Rishi Solnaki] On Tue, Jun 24, 2008 at 5:41 PM, him_aeng [EMAIL PROTECTED] wrote: I see you intent to make two of compound key (budgetId and budgetItemSeqId) of PaymentBudgetAllocation entity have relation-type = nofk that not similar to The Data Model Resource Book Vol.1 in Figure 8.10. I think you have to has a good reason for implementation /applications/accounting/entitydef/entitymodel.xml entity entity-name=PaymentBudgetAllocation package-name=org.ofbiz.accounting.payment title=Payment Budget Allocation Entity field name=budgetId type=id-ne/field field name=budgetItemSeqId type=id-ne/field field name=paymentId type=id-ne/field field name=amount type=currency-amount/field prim-key field=budgetId/ prim-key field=budgetItemSeqId/ prim-key field=paymentId/ relation type=one fk-name=PAYMENT_BA_BDGT rel-entity-name=Budget key-map field-name=budgetId/ /relation - relation type=one-nofk rel-entity-name=BudgetItem + relation type=one fk-name=PAYMENT_BUDGIT rel-entity-name=BudgetItem key-map field-name=budgetId/ key-map field-name=budgetItemSeqId/ /relation relation type=one fk-name=PAYMENT_BA_PMT rel-entity-name=Payment key-map field-name=paymentId/ /relation /entity and another question in the same figure in the book (Figure 8.10). In order_item entity has two attribute that is budgetId and budgetItemSeqId but you don't use it to link to budget_item entity, and I don't know why? /applications/order/entitydef/entitymodel.xml entity entity-name=OrderItem package-name=org.ofbiz.order.order never-cache=true title=Order Item Entity field name=orderId type=id-ne/field field name=orderItemSeqId type=id-ne/field field name=externalId type=id/field field name=orderItemTypeId type=id-ne/field field name=orderItemGroupSeqId type=id-ne/field field name=isItemGroupPrimary type=indicator/field field name=fromInventoryItemId type=id/field field name=budgetId type=id/field field name=budgetItemSeqId type=id/field ... + relation type=one fk-name=ORDER_ITEM_BUDGET_ITEM rel-entity-name=BudgetItem + key-map field-name=budgetId/ + key-map field-name=budgetItemSeqId/ + /relation -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18089666.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with tax recalculation after order item cancellation
Hi Rashko Comments inline, these are just my first thoughts I haven't looked at the code or entities 2008/6/24 Rashko Rejmer [EMAIL PROTECTED]: The status of the item is set to ITEM_CANCELLED and tax adjustments are not removed. Instead of this it is created order header adjustment that compensates order item sales tax adjustments. This was introduced in OFBIZ-461. The reason was that it was not possible to remove OrderAdjustment if one part of the adjustment is already invoiced(OrderAdjustmentBilling is present). Instead of creating these balancing adjustments wouldn't it be ok to just update the OrderAdjustment with the new tax amount? After quick shipping the order the tax adjustments for the cancelled order items are ignored and in the invoice is present only the order header tax adjustment that negates the cancelled order item tax adjustments. So the invoice total amount is different from the order total amount. This sounds strange because if the order item was cancelled then there should have been no OrderAdjustmentBillings which would mean we could have just deleted the order adjustment and not created the balancing adjustments in the first place. Even if this will be corrected I was wandering if this is the best approach because during order item cancellation it is created only one order header tax adjustment for all order item tax adjustments, without any information about the Tax authorities. It sounds like a work around that could do with a better approach The second problem is that order item editing does not follow this pattern. For example if you cancel one order item and then edit the price of another order item, then tax adjustments of the previously cancelled order item(first one) are removed, It is removed also the order header tax adjustment. Like I said at the top I can't see why we can't just adjust the amounts on the existing order adjustments, I can't imagine any need to preserve the original tax amounts. Regards Scott
Re: eclipse, svn ignore and the build folder
Hi Grant The build folders are already be set to be ignored in svn, they don't show up in my eclipse ide. The changed symbol is there because you have changed the svn properties for that folder. Regards Scott 2008/6/25 Grant Edwards [EMAIL PROTECTED]: Hi, In eclipse if I add the accounting/build folder to the list of files to ignore, eclipse does just that. It ignores the build folder. The accounting folder however is still marked with a little black annotation indicating that some change has occurred. Anyone know how to get rid of that little black annotation ? Cheers Grant Edwards
view-entity where condition
hi i want to make a view-entity like this: select a.fkey , a.fdesc , b.fname , c.faddr , d.ftel from a left join b on a.fkey = b.fkey left join c on a.fkey = c.fkey left join d on a.fkey = d.fkey where a.fkey = b.fkey and b.fkey = c.fkey and c.fkey = d.fkey then i write this: view-entity entity-name=ViewAll package-name=org.ofbiz member-entity entity-alias=TA entity-name=a/ member-entity entity-alias=TB entity-name=b/ member-entity entity-alias=TC entity-name=c/ member-entity entity-alias=TD entity-name=d/ alias-all entity-alias=TA / alias-all entity-alias=TB / alias-all entity-alias=TC / alias-all entity-alias=TD / view-link entity-alias=TA rel-entity-alias=TB key-map field-name=fKey//view-link view-link entity-alias=TA rel-entity-alias=TC key-map field-name=fKey//view-link view-link entity-alias=TA rel-entity-alias=TD key-map field-name=fKey//view-link relation type=one rel-entity-name=TA key-map field-name=fKey/ /relation relation type=one rel-entity-name=TB key-map field-name=fKey/ /relation relation type=one rel-entity-name=TC key-map field-name=fKey/ /relation relation type=one rel-entity-name=TD key-map field-name=fKey/ /relation /view-entity but , can't work, no where condition in sql string , so the result very big , and not left join how ? thx.
Re: Missing documentation
This is documentation provided by the Community (users) unfortunately I let the documentation I was planning on writting slip. So all you see is the place holders. also one other person was going to write up their experience but has not provided anything yet. jason_lunn sent the following on 6/24/2008 11:57 PM: The very last line of: http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide appears to be referencing: http://docs.ofbiz.org/display/OFBIZ/Creating+Configurable++Products which has mostly empty content. Is my interpretation of the end-user documentation space for details on how to set these things up incorrect? Should I be looking somewhere else in the wiki or in a different online resource? Your help to fill in the gaps of a walk through of the example configurable products greatly appreciated.
Re: eclipse, svn ignore and the build folder
Hi Scott Unfortunately for me I see every single build file there is to see. I picked up my subversion config file from http://ofbiz.apache.org/svn/config The change symbol is also present on the parent directory of EVER build directory. Cheers Grant Edwards Scott Gray wrote: Hi Grant The build folders are already be set to be ignored in svn, they don't show up in my eclipse ide. The changed symbol is there because you have changed the svn properties for that folder. Regards Scott 2008/6/25 Grant Edwards [EMAIL PROTECTED]: Hi, In eclipse if I add the accounting/build folder to the list of files to ignore, eclipse does just that. It ignores the build folder. The accounting folder however is still marked with a little black annotation indicating that some change has occurred. Anyone know how to get rid of that little black annotation ? Cheers Grant Edwards
Re: help big table display!
thx, i'm very happy, haha :) :) 2008/6/25 Ashish Vijaywargiya [EMAIL PROTECTED]: Vikas, If you will noticed David has alread mentioned it in another thread which is generated from this topic :-). Although Stamilo will be double happy to see double reply of his email :-) -- Ashish 2008/6/25 Vikas Mayur [EMAIL PROTECTED]: Instead of list, use EntityListIterator like entity-condition entity-name=TLog list-name=TLogs use-iterator/ /entity-condition - Vikas On Wed, Jun 25, 2008 at 8:16 AM, stamilo [EMAIL PROTECTED] wrote: hi, i have a big table ,about 10,000 rows data , i use form name=LOGList type=list list-name=examples paginate-target=LOGList actions entity-condition entity-name=TLogorder-by field-name=fKey//entity-condition /actions that , want do display data , but nothing showed , console report : [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2) [StandardWrapperValve. java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception [java] java.lang.OutOfMemoryError: Java heap space how i can display the big table ? thx!
Process cash book / bank account
Hi In my hand I have a copy of my bank statement. One of the entries on my bank statement is banking fees of ZAR 1000.00. At the moment I am unable to work out how to apply this to my bank account (Accounts Receivable Master card) currently defined in OFBiz accounting. Any help would be appreciated Thanks Rees
Re: Many entities that should has foreign key but it not, why?
Thank you very much for your kindly reply. Your reply make my brain get fresh (but still dumb) Thank you again Tanakorn Numrubporn Rishi Solanki wrote: The relation-type = nofk is used when we need a relation but don't want to apply foreign key constraints on it. This relation comes in existance only when we need to use the attribute of a entity into another entity. And we needed that when we delete/expire a record from entity say PaymentBudgetAllocation then their is no need to delete the record from BudgetItem. In such case we specify relation-type = nofk. Thanks and Regards [Rishi Solnaki] On Tue, Jun 24, 2008 at 5:41 PM, him_aeng [EMAIL PROTECTED] wrote: I see you intent to make two of compound key (budgetId and budgetItemSeqId) of PaymentBudgetAllocation entity have relation-type = nofk that not similar to The Data Model Resource Book Vol.1 in Figure 8.10. I think you have to has a good reason for implementation /applications/accounting/entitydef/entitymodel.xml entity entity-name=PaymentBudgetAllocation package-name=org.ofbiz.accounting.payment title=Payment Budget Allocation Entity field name=budgetId type=id-ne/field field name=budgetItemSeqId type=id-ne/field field name=paymentId type=id-ne/field field name=amount type=currency-amount/field prim-key field=budgetId/ prim-key field=budgetItemSeqId/ prim-key field=paymentId/ relation type=one fk-name=PAYMENT_BA_BDGT rel-entity-name=Budget key-map field-name=budgetId/ /relation - relation type=one-nofk rel-entity-name=BudgetItem + relation type=one fk-name=PAYMENT_BUDGIT rel-entity-name=BudgetItem key-map field-name=budgetId/ key-map field-name=budgetItemSeqId/ /relation relation type=one fk-name=PAYMENT_BA_PMT rel-entity-name=Payment key-map field-name=paymentId/ /relation /entity and another question in the same figure in the book (Figure 8.10). In order_item entity has two attribute that is budgetId and budgetItemSeqId but you don't use it to link to budget_item entity, and I don't know why? /applications/order/entitydef/entitymodel.xml entity entity-name=OrderItem package-name=org.ofbiz.order.order never-cache=true title=Order Item Entity field name=orderId type=id-ne/field field name=orderItemSeqId type=id-ne/field field name=externalId type=id/field field name=orderItemTypeId type=id-ne/field field name=orderItemGroupSeqId type=id-ne/field field name=isItemGroupPrimary type=indicator/field field name=fromInventoryItemId type=id/field field name=budgetId type=id/field field name=budgetItemSeqId type=id/field ... + relation type=one fk-name=ORDER_ITEM_BUDGET_ITEM rel-entity-name=BudgetItem + key-map field-name=budgetId/ + key-map field-name=budgetItemSeqId/ + /relation -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18089666.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18112059.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: eclipse, svn ignore and the build folder
I would suggest to 1. Create a big patch from your OFBiz root 2. Make a new fresh svn check out 3. Apply the patch to the new project 4. Import the new project in Eclipse Hopefully, it will solve your issue (maybe not... then try another way... you have to be creative with Eclipse ;o) Jacques From: Grant Edwards [EMAIL PROTECTED] Hi Scott Unfortunately for me I see every single build file there is to see. I picked up my subversion config file from http://ofbiz.apache.org/svn/config The change symbol is also present on the parent directory of EVER build directory. Cheers Grant Edwards Scott Gray wrote: Hi Grant The build folders are already be set to be ignored in svn, they don't show up in my eclipse ide. The changed symbol is there because you have changed the svn properties for that folder. Regards Scott 2008/6/25 Grant Edwards [EMAIL PROTECTED]: Hi, In eclipse if I add the accounting/build folder to the list of files to ignore, eclipse does just that. It ignores the build folder. The accounting folder however is still marked with a little black annotation indicating that some change has occurred. Anyone know how to get rid of that little black annotation ? Cheers Grant Edwards
Re: Many entities that should has foreign key but it not, why?
Sorry for asking another question. When I see to the Real Database that OFBiz just constructed and look in to the constraint part of PaymentBudgetAllocation I can't see any thing that point to the one-nofk thing. It show only which is one thing in database. Is that mean, It doesn't matter that you specify relation-type = one-nofk or not? The real entity in RDBMS remain the same (don't have relation at all). So, I just feel strange that what the purpose of one-nofk relation-type? Thank and Regards Tanakorn Numrubporn Rishi Solanki wrote: The relation-type = nofk is used when we need a relation but don't want to apply foreign key constraints on it. This relation comes in existance only when we need to use the attribute of a entity into another entity. And we needed that when we delete/expire a record from entity say PaymentBudgetAllocation then their is no need to delete the record from BudgetItem. In such case we specify relation-type = nofk. Thanks and Regards [Rishi Solnaki] On Tue, Jun 24, 2008 at 5:41 PM, him_aeng [EMAIL PROTECTED] wrote: I see you intent to make two of compound key (budgetId and budgetItemSeqId) of PaymentBudgetAllocation entity have relation-type = nofk that not similar to The Data Model Resource Book Vol.1 in Figure 8.10. I think you have to has a good reason for implementation /applications/accounting/entitydef/entitymodel.xml entity entity-name=PaymentBudgetAllocation package-name=org.ofbiz.accounting.payment title=Payment Budget Allocation Entity field name=budgetId type=id-ne/field field name=budgetItemSeqId type=id-ne/field field name=paymentId type=id-ne/field field name=amount type=currency-amount/field prim-key field=budgetId/ prim-key field=budgetItemSeqId/ prim-key field=paymentId/ relation type=one fk-name=PAYMENT_BA_BDGT rel-entity-name=Budget key-map field-name=budgetId/ /relation - relation type=one-nofk rel-entity-name=BudgetItem + relation type=one fk-name=PAYMENT_BUDGIT rel-entity-name=BudgetItem key-map field-name=budgetId/ key-map field-name=budgetItemSeqId/ /relation relation type=one fk-name=PAYMENT_BA_PMT rel-entity-name=Payment key-map field-name=paymentId/ /relation /entity and another question in the same figure in the book (Figure 8.10). In order_item entity has two attribute that is budgetId and budgetItemSeqId but you don't use it to link to budget_item entity, and I don't know why? /applications/order/entitydef/entitymodel.xml entity entity-name=OrderItem package-name=org.ofbiz.order.order never-cache=true title=Order Item Entity field name=orderId type=id-ne/field field name=orderItemSeqId type=id-ne/field field name=externalId type=id/field field name=orderItemTypeId type=id-ne/field field name=orderItemGroupSeqId type=id-ne/field field name=isItemGroupPrimary type=indicator/field field name=fromInventoryItemId type=id/field field name=budgetId type=id/field field name=budgetItemSeqId type=id/field ... + relation type=one fk-name=ORDER_ITEM_BUDGET_ITEM rel-entity-name=BudgetItem + key-map field-name=budgetId/ + key-map field-name=budgetItemSeqId/ + /relation -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18089666.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18112499.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: can any one tell me were orderid is set
Hi all, Sorry for the Spam everyone. I am trying to unsubscribe from the user email list: [EMAIL PROTECTED] [EMAIL PROTECTED] But it does not seem to work, would anyone know how? Thanks a lot. C
Re: Need Help with Recurrence Rules
Vikas, Your reply was very helpful. Thank you very much! -Adrian Vikas Mayur wrote: Hi Adrian, There are a total of four entities namely JobSandbox, RecurrenceRule, RecurrenceInfo, RuntimeData (Optinal) that are required to create a schedule service. From UI there are two steps to create a recurrence rule. Second step is optional. This is the step where the data is stored in RuntimeData entity. To create a RecurreceRule go to https://localhost:8443/webtools/control/scheduleJob Step 1 : Lets suppose we want to define a recurrence rule on createPerson service than we can enter values on page reached by above URL like Job = Create a person serviceName = createPerson Frequency = How the service will be called - is it after every second, every minute, every week etc. Select appropriate value from select box Interval = It will a interger value - if specified than the service will be invoked after the interval mentioned (Say we have selected Frequency = MINUTELY, Interval = 5 - the service will be invoked after every 5 minutes) Other fields have good description on this form itself. Once you submit this form, it will take you to second step. As we know that the service createPerson takes two required attributes i.e. firstName and lastName namely. Enter the value for these fields (and optional fields if you want) in second step. Submit this form. So we have now created a schedule service. Now you can status of the job in the job list at https://localhost:8443/webtools/control/jobList For creating a recurrence rule you can refer to the file ManufacturingScheduledServices.xml Rest of comments inline. On Tue, Jun 24, 2008 at 10:55 PM, Adrian Crum [EMAIL PROTECTED] wrote: I've spent hours looking through the recurrence rule code and doing Google searches, but I'm still having a hard time understanding how to set up recurrence rules. Has there been any documentation done on this? I do not see any kind of document supporting these artifacts either. Also, it appears to me there is no way to set up a recurrence that occurs on intervals like: 1. The second Sunday in May 2. The first Monday of every month I think these are not supported yet. or am I missing something? Is there a UI for entering recurrence rules? Any help would greatly appreciated! -Adrian Hope this helps ! - Vikas
Recurring Work Efforts
I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
Yes, I think so. I've tried to encourage people to use re-usable entities like WorkEffort and RecurrenceInfo/Rule to implement these things over the years, and so there is some code in place for them. Even recently Bilgin did some work on this for happy hour promotions: https://issues.apache.org/jira/browse/OFBIZ-1756 There is a bit of code already implemented to determine when a recurrence applies and such, but I know more work needs to be done. There are also certain fields on the RecurrenceRule entity that I'm not sure are really supported, along the lines of what you were asking about in the other thread for things like the first Monday of each week at 2PM and such. -David On Jun 25, 2008, at 11:57 AM, Adrian Crum wrote: David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
Cool. I'll get it working for the existing recurrence rules, then tackle new rule sets later. -Adrian David E Jones wrote: Yes, I think so. I've tried to encourage people to use re-usable entities like WorkEffort and RecurrenceInfo/Rule to implement these things over the years, and so there is some code in place for them. Even recently Bilgin did some work on this for happy hour promotions: https://issues.apache.org/jira/browse/OFBIZ-1756 There is a bit of code already implemented to determine when a recurrence applies and such, but I know more work needs to be done. There are also certain fields on the RecurrenceRule entity that I'm not sure are really supported, along the lines of what you were asking about in the other thread for things like the first Monday of each week at 2PM and such. -David On Jun 25, 2008, at 11:57 AM, Adrian Crum wrote: David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
Btw, I was thinking a recurring work effort would create child workefforts - that are related to the parent workeffort as a Scheduled Interval type. What do you think? -Adrian Adrian Crum wrote: Cool. I'll get it working for the existing recurrence rules, then tackle new rule sets later. -Adrian David E Jones wrote: Yes, I think so. I've tried to encourage people to use re-usable entities like WorkEffort and RecurrenceInfo/Rule to implement these things over the years, and so there is some code in place for them. Even recently Bilgin did some work on this for happy hour promotions: https://issues.apache.org/jira/browse/OFBIZ-1756 There is a bit of code already implemented to determine when a recurrence applies and such, but I know more work needs to be done. There are also certain fields on the RecurrenceRule entity that I'm not sure are really supported, along the lines of what you were asking about in the other thread for things like the first Monday of each week at 2PM and such. -David On Jun 25, 2008, at 11:57 AM, Adrian Crum wrote: David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
Wouldn't that result in a lot of redundant WorkEffort records, and the need for background processes to run to keep them up to date and consistent, and a lot of risk that they would get out of date and inconsistent? -David On Jun 25, 2008, at 12:30 PM, Adrian Crum wrote: Btw, I was thinking a recurring work effort would create child workefforts - that are related to the parent workeffort as a Scheduled Interval type. What do you think? -Adrian Adrian Crum wrote: Cool. I'll get it working for the existing recurrence rules, then tackle new rule sets later. -Adrian David E Jones wrote: Yes, I think so. I've tried to encourage people to use re-usable entities like WorkEffort and RecurrenceInfo/Rule to implement these things over the years, and so there is some code in place for them. Even recently Bilgin did some work on this for happy hour promotions: https://issues.apache.org/jira/browse/OFBIZ-1756 There is a bit of code already implemented to determine when a recurrence applies and such, but I know more work needs to be done. There are also certain fields on the RecurrenceRule entity that I'm not sure are really supported, along the lines of what you were asking about in the other thread for things like the first Monday of each week at 2PM and such. -David On Jun 25, 2008, at 11:57 AM, Adrian Crum wrote: David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
Re: Recurring Work Efforts
How else would it work? I create a recurring workeffort for depositing my paycheck at the bank. It repeats every two weeks. If the recurring workeffort creates a child workeffort, then I can update the child's status to Complete once I deposit my paycheck. If there is only one workeffort, how do I update a single instance of it every two weeks? -Adrian David E Jones wrote: Wouldn't that result in a lot of redundant WorkEffort records, and the need for background processes to run to keep them up to date and consistent, and a lot of risk that they would get out of date and inconsistent? -David On Jun 25, 2008, at 12:30 PM, Adrian Crum wrote: Btw, I was thinking a recurring work effort would create child workefforts - that are related to the parent workeffort as a Scheduled Interval type. What do you think? -Adrian Adrian Crum wrote: Cool. I'll get it working for the existing recurrence rules, then tackle new rule sets later. -Adrian David E Jones wrote: Yes, I think so. I've tried to encourage people to use re-usable entities like WorkEffort and RecurrenceInfo/Rule to implement these things over the years, and so there is some code in place for them. Even recently Bilgin did some work on this for happy hour promotions: https://issues.apache.org/jira/browse/OFBIZ-1756 There is a bit of code already implemented to determine when a recurrence applies and such, but I know more work needs to be done. There are also certain fields on the RecurrenceRule entity that I'm not sure are really supported, along the lines of what you were asking about in the other thread for things like the first Monday of each week at 2PM and such. -David On Jun 25, 2008, at 11:57 AM, Adrian Crum wrote: David, Thanks for the info! Would it be worthwhile for me to add some code to the WorkEffort component to set up a recurring work effort? It's something we need here. -Adrian David E Jones wrote: I think it's only used by background code at the minute, or in other words no UI has been created for it yet. There is a simplistic UI that populates the entity in webtools for the service engine job scheduler thingy. -David On Jun 25, 2008, at 9:47 AM, Adrian Crum wrote: I see there is a recurrenceInfoId field in the WorkEffort entity, but I can't find a way to set up a recurring work effort. Does anyone know how that can be done? -Adrian
POS - Additional Info working with questions
All, I've gotten most of the functionality of pressing a button to modify a field to appear on a prep receipt (the receipt that a cook or delivery person will see...Not the custreceipt). What works: I have a button on the main POS page (you can really put it where ever you want) that does some neat things... 1) It calls the newly added keyboard.java file BUT we've modified the method that calls it to use a different xml file so some things can be changed to suit this field, such as more text area and a carriage return button. 2) It passes your custom request into the special instructions field that we mentioned was already implemented for shipping. What doesn't work: 1) I'm not finished working with the new receipt template. It's a little confusing, but I'm getting the hang of it. 2) I'm not even going to attempt to modify the journal.java's jtable to try to call the custom requests so that they show up on the monitor. If one of you guys are good enough to do that and know the API well enough, go for it! Showing up on the receipt is goood enough for this sys admin transformed into quasi java programmer! 3) I'm currently working on adding methods to the (forgive me I don't have it in front of me, so I'm guessing at which java file). Printer...Or device loader? Basically what I'm trying to do is add a Receipt2, or ReceiptPrep to pos-components.xml and add the already working TCP printer though JPOS's SetupPos program. Then I can differentiate the print button I want to use to send the data using the prep template (no extra text, or prices, just orders with customizations) and the regular customer receipt printing functionality at the end of the sale. I'm almost finished with this. Hopefully if all goes well tonight (it never does!) I'll have time to not only create a Jira issue for this (if anyone is interested) but I'll hopefully be able to create a Jira issue for the TCP printer info / setup / small quarks. I haven't forgotten about the TCP printer, don't worry ;) Just thought I'd keep you all in the loop, rather than completely finish then get a good Idea from someone! Thanks!
Re: POS - Additional Info working with questions
From: Branden Strickland [EMAIL PROTECTED] All, I've gotten most of the functionality of pressing a button to modify a field to appear on a prep receipt (the receipt that a cook or delivery person will see...Not the custreceipt). What works: I have a button on the main POS page (you can really put it where ever you want) that does some neat things... 1) It calls the newly added keyboard.java file BUT we've modified the method that calls it to use a different xml file so some things can be changed to suit this field, such as more text area and a carriage return button. Interesting, I was also thinking about a property to completly deactivate the keyboard at will (some people are using a real keyd) 2) It passes your custom request into the special instructions field that we mentioned was already implemented for shipping. What doesn't work: 1) I'm not finished working with the new receipt template. It's a little confusing, but I'm getting the hang of it. 2) I'm not even going to attempt to modify the journal.java's jtable to try to call the custom requests so that they show up on the monitor. If one of you guys are good enough to do that and know the API well enough, go for it! Showing up on the receipt is goood enough for this sys admin transformed into quasi java programmer! We will see, when we will have your code. 3) I'm currently working on adding methods to the (forgive me I don't have it in front of me, so I'm guessing at which java file). Printer...Or device loader? Basically what I'm trying to do is add a Receipt2, or ReceiptPrep to pos-components.xml and add the already working TCP printer though JPOS's SetupPos program. Then I can differentiate the print button I want to use to send the data using the prep template (no extra text, or prices, just orders with customizations) and the regular customer receipt printing functionality at the end of the sale. I'm almost finished with this. Hopefully if all goes well tonight (it never does!) I'll have time to not only create a Jira issue for this (if anyone is interested) but I'll hopefully be able to create a Jira issue for the TCP printer info / setup / small quarks. Feel free top open as many as Jira issues you need. I haven't forgotten about the TCP printer, don't worry ;) Just thought I'd keep you all in the loop, rather than completely finish then get a good Idea from someone! Sorry not even an ideas tonight (without speaking of a good one) : too late :o) Jacques Thanks!
JPos The Big Deal?
Newbie: Still dangerous ;) Guys I'm struggling to understand why JPos is even needed. Just started playing with ofbiz, saw POS module, got excited, rushed out and got myself a symbol barcode scanner... and I see that when I plug it into the usb, it behaves just like a keyboard, no driver, no nothing needed. If I scan whichever and whatever type of of barcode... it reads it. So I'm wondering what on earth JPos is supposed to do, why do we need it? I'm thinking that if I rush out and get a printer... the thing is going to work just like any other printer and will work from word, or notepad, or swing... so we just printing. A terminal post... is probably just going to be a printer as well? A credit card scanner... probably gives you the number?... like the keyboard again... or would be completely separate and chat to the bank... and the person behind the POS just records a credit sale, or something? So what is JPos really doing for us... its just standard pc stuff? One could turn Excel into a little POS... no? I dont get it? What makes Jpos really needed? I read that is about standardizing... but a printer is a printer, a scanner is a keyboard, whats to standardize, its plug and play anyway? What is a cash drawer... probably print char Esc A to the printer... hardly reason for a standard? What am I missing? Thanks
Re: JPos The Big Deal?
Johnny, I think you are confused between JPos and JavaPos. I don't know much about POS, but I think it is JavaPos which is used and not the JPos. JPos is totally different beast that is implementation ISO-8583 protocol which is a low level messaging protocol between devices like ATM and financial switches/hubs. You can know more about JavaPos (http://www.javapos.com/). Thanks, Raj Johnny Kewl wrote: Newbie: Still dangerous ;) Guys I'm struggling to understand why JPos is even needed. Just started playing with ofbiz, saw POS module, got excited, rushed out and got myself a symbol barcode scanner... and I see that when I plug it into the usb, it behaves just like a keyboard, no driver, no nothing needed. If I scan whichever and whatever type of of barcode... it reads it. So I'm wondering what on earth JPos is supposed to do, why do we need it? I'm thinking that if I rush out and get a printer... the thing is going to work just like any other printer and will work from word, or notepad, or swing... so we just printing. A terminal post... is probably just going to be a printer as well? A credit card scanner... probably gives you the number?... like the keyboard again... or would be completely separate and chat to the bank... and the person behind the POS just records a credit sale, or something? So what is JPos really doing for us... its just standard pc stuff? One could turn Excel into a little POS... no? I dont get it? What makes Jpos really needed? I read that is about standardizing... but a printer is a printer, a scanner is a keyboard, whats to standardize, its plug and play anyway? What is a cash drawer... probably print char Esc A to the printer... hardly reason for a standard? What am I missing? Thanks
can a beanObject could be sent to ofbiz sevice definition
hai all i greatly appreciate the responses i got for my previous query.Is it possible to sent a bean object to ofbiz service,like if we want to set a new address using existing ofbiz service createPartyPostalAddress instead of sending each parameter and defining it in services.xml can we set a bean object and sent it to service. Plz help me if anyone has solved this problem. -- View this message in context: http://www.nabble.com/can-a-beanObject-could-be-sent-to-ofbiz-sevice-definition-tp18126286p18126286.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Many entities that should has foreign key but it not, why?
No foreign key indices are maintained for the one-nofk relationship, that is the reason why no foreign key constraints apply to a one-nofk relationship. This may be the reason that you are not able to locate this relation is the constraint part. You can find this relationship in the Webtools application in context of the entity you are looking for. In case of one-nofk relationship constraints do not apply but you can fetch the related data on the basis of this relationship. This is the reason of keeping this relationship, you can have access to related data but you need not to worry about any constraints while performing CRUD operations. On Wed, Jun 25, 2008 at 6:59 PM, him_aeng [EMAIL PROTECTED] wrote: Sorry for asking another question. When I see to the Real Database that OFBiz just constructed and look in to the constraint part of PaymentBudgetAllocation I can't see any thing that point to the one-nofk thing. It show only which is one thing in database. Is that mean, It doesn't matter that you specify relation-type = one-nofk or not? The real entity in RDBMS remain the same (don't have relation at all). So, I just feel strange that what the purpose of one-nofk relation-type? Thank and Regards Tanakorn Numrubporn Rishi Solanki wrote: The relation-type = nofk is used when we need a relation but don't want to apply foreign key constraints on it. This relation comes in existance only when we need to use the attribute of a entity into another entity. And we needed that when we delete/expire a record from entity say PaymentBudgetAllocation then their is no need to delete the record from BudgetItem. In such case we specify relation-type = nofk. Thanks and Regards [Rishi Solnaki] On Tue, Jun 24, 2008 at 5:41 PM, him_aeng [EMAIL PROTECTED] wrote: I see you intent to make two of compound key (budgetId and budgetItemSeqId) of PaymentBudgetAllocation entity have relation-type = nofk that not similar to The Data Model Resource Book Vol.1 in Figure 8.10. I think you have to has a good reason for implementation /applications/accounting/entitydef/entitymodel.xml entity entity-name=PaymentBudgetAllocation package-name=org.ofbiz.accounting.payment title=Payment Budget Allocation Entity field name=budgetId type=id-ne/field field name=budgetItemSeqId type=id-ne/field field name=paymentId type=id-ne/field field name=amount type=currency-amount/field prim-key field=budgetId/ prim-key field=budgetItemSeqId/ prim-key field=paymentId/ relation type=one fk-name=PAYMENT_BA_BDGT rel-entity-name=Budget key-map field-name=budgetId/ /relation - relation type=one-nofk rel-entity-name=BudgetItem + relation type=one fk-name=PAYMENT_BUDGIT rel-entity-name=BudgetItem key-map field-name=budgetId/ key-map field-name=budgetItemSeqId/ /relation relation type=one fk-name=PAYMENT_BA_PMT rel-entity-name=Payment key-map field-name=paymentId/ /relation /entity and another question in the same figure in the book (Figure 8.10). In order_item entity has two attribute that is budgetId and budgetItemSeqId but you don't use it to link to budget_item entity, and I don't know why? /applications/order/entitydef/entitymodel.xml entity entity-name=OrderItem package-name=org.ofbiz.order.order never-cache=true title=Order Item Entity field name=orderId type=id-ne/field field name=orderItemSeqId type=id-ne/field field name=externalId type=id/field field name=orderItemTypeId type=id-ne/field field name=orderItemGroupSeqId type=id-ne/field field name=isItemGroupPrimary type=indicator/field field name=fromInventoryItemId type=id/field field name=budgetId type=id/field field name=budgetItemSeqId type=id/field ... + relation type=one fk-name=ORDER_ITEM_BUDGET_ITEM rel-entity-name=BudgetItem + key-map field-name=budgetId/ + key-map field-name=budgetItemSeqId/ + /relation -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18089666.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/Many-entities-that-should-has-foreign-key-but-it-not%2C-why--tp18089666p18112499.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED]
Re: Users - Amazon.com Integration
I'm looking for an Amazon interface very much as Andy Zeneski outlined in this thread. What ever became of that effort? Does such a package exist to integrate Amazon with OFBiz? Any information would be very appreciated. Thanks in advance, -Milton Clark [EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Users---Amazon.com-Integration-tp4434952p18126696.html Sent from the OFBiz - User mailing list archive at Nabble.com.