Holding Company financial question
Hi everyone I have a question regarding the concept of holding company I've the accounting department which is a sub organization from the whole company I know that I can setup the accounting of this accounting department separately and get all transactions and reports aside from the whole company But my question is: do the transaction done in sub company affect the transactions done in main big holding company? for example if the sub organization is required to pay 1000 in the accounts payable of the whole company will this appear i the accounts payable? I'd be glad for any clarifications thanks -- View this message in context: http://ofbiz.135035.n4.nabble.com/Holding-Company-financial-question-tp3428021p3428021.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Difference Bteween write off and cancel in invoices
Hi All Can anyone explain to me difference between the status "write off" and "Cancel" in invoices? financially is there a difference? what points should I consider when I change the status of the invoice to "write off" or "cancel" Thanks in Advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Difference-Bteween-write-off-and-cancel-in-invoices-tp3417744p3417744.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Supplier Not Find Exception While creating PO from Requirement
Hi All I've a question regarding creation of PO from requirement When I make a requirement to certain supplier and the currency of that supplier is not USD fro example EUR or GBP and then approve the requirement then go to the tab "Find Approved requirement for supplier" Then check the checkbox then click prepare order I face an error "Supplier product not found" I can easily go and make a purchase order and choose whatever Currency I like with no errors The error only occurs when I make PO from requirement when the currency isn't USD can anyone explain this? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Supplier-Not-Find-Exception-While-creating-PO-from-Requirement-tp3414013p3414013.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Workeffort calender Question
Hi All I want to ask something about calenders is workeffort First of all Can Create more than calender per user login? when I go to workeffort then calender section I want to create different calenders Assume the case that I have a school where there are for example different teachers and different labs to be used and such things so I need multiple calenders is there any suggestions how can I manage this? I know that I can add other parties to calender as calender attendee, so as far as I'm correct that role is all over the calender not a certain event correct? and if I added someone as a calender attendee this means that the events will automatically be added to his/her calender? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Workeffort-calender-Question-tp3396485p3396485.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Open link in a new tab
Hi All Is there any option in ofbiz that can enable me to open a new tab or new window when I click a button? so instead of navigating to another page i want that page in anew window or tab If so how? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Open-link-in-a-new-tab-tp3393348p3393348.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Invalid Quote Unit price
I've already done so has anyone tried to make a quote in euro and product price in usd for example? is that related to calculateProductPrice service?' -- View this message in context: http://ofbiz.135035.n4.nabble.com/Invalid-Quote-Unit-price-tp3384768p3390747.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Invalid Quote Unit price
Any help guys about the product prices currencies and how they reflect in the quote? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Invalid-Quote-Unit-price-tp3384768p3390184.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Invalid Quote Unit price
Hi All I want to install products that have default prices in different currency fto USD For example I want to install product1 that have the default price = 20 EGP I want to create a quote and add this product as a quote Item but actually the quote unit price is not correctly calculated and sometimes it returns 0 How can the ofbiz handle a case where the quote is In Euro and the product prices are in EGPs for example has anyone experience the same or similar problem? I know there might not be any currency conversion but at least is there a problem in attaching a product to quote item where the product and the quote have different currencies? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Invalid-Quote-Unit-price-tp3384768p3384768.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Users - Sales Tab is missing. How to edit sales tax for astore.
Jacques Le Roux wrote: > >> Jacques, >> >> Thanks for the email. It did work. Now sales tax is not added to the >> order >> total. It just shows '0', though i would prefer it not to show at all if >> the >> tax amount is '0'. > > If you want to set VAT taxes you may use Accounting/Tax authorities and > link to > your store by "Vat Tax Auth Geo Id" & "Vat Tax Auth Party Id " at the > bottom of > Stores/Store. Else (no taxe at all) you have to modify the corresponding > templates... (see > applications/ecommerce/webapp/ecommerce/cart/showcart.ftl) > >> I have another question about the 'Tax IDs & Exemptions' option that >> shows >> in the shipment address page right after one logs-in the website. Can it >> be >> disable altogether. It may be confusing for retail customers and if one >> does >> not use it, it make no sense to display it. > > See "Show Tax Is Exempt" at the bottom of Stores/Store > > Jacques > > ___ > Users mailing list > us...@lists.ofbiz.org > http://lists.ofbiz.org/mailman/listinfo/users > Hi All I'm trying to disable sales Taxes generally in ofbiz but I don't know how I know that i accounting there's a part called Tax Authorities and there are some options in the store which contains some flags for example I want the Ecommerce web store not to add any sales taxes on products how I can disable this? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Sales-Tab-is-missing-How-to-edit-sales-tax-for-a-store-tp139617p3353288.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Broken Pipe exception
Hi All I face a broken Pipe exception a lot sometimes I know the reason sometimes no I just want to make sure that I have no compatibility problems regarding the JDK I'm using ofbiz10.04 the svn version and my operating system is fedora 8 I've installed also the jdk 1.6 does anyone see I've any compatibility problems? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Broken-Pipe-exception-tp3304521p3304521.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Quote and discount
Hi All I'm asking if I can run a certain percent discount on the whole total of the quote? I've checked the quote adjustments but they seem to work on each quote item separately that's not what I want but i want to run on the whole quote items plus I found that I can enter an amount for example $10 but not a percentage I have a question also regarding the price rules. Do the price rules work during the quote? I see the it works on certain price of the product the default price or sale price as I understand is that correct? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Quote-and-discount-tp3296758p3296758.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Service products and Order Statuses
Thanks for your reply And sorry for being late but this is due to unexpected conditions in Egypt I've checked the url but unfortunately this doesn't have enough to help me I'm talking about the order status flow is there any listener or method that change the order status to approved or completed when the product type is a service product The handling of the order statuses is different in case the product is service Another important thing to mention is that I tried to go back to 9.04 and test it (make an order on Gizmo news letter which is linked to subscription resource and to its type is service I created the order then tried to approve it,I faced an exception "Can't change from order completed to order approved" does anyone have a clue what happens? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Service-products-and-Order-Statuses-tp3241751p3262640.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Service products and Order Statuses
Hello I have a question related to the product and the order statuses when I go and set up the product as a service does that affect the ordinary flow of the order statuses? auto approval or auto completion or anything of that kind? I've looked through the secas but I couldn't find it I've already made some customization regarding the order statuses and their changes anhd all worked fine with me when I was using the finished good products but something very strange happened. the odrer changes from approved to completed then to approved again and this causes me a problem really in the subscriptions table because I've made products like Gizmo new letter and it seems the subscription records are created upon the approval or the order so when the order passes two approval two records are created any help please? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Service-products-and-Order-Statuses-tp3241751p3241751.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Cart Item Problem
Thanks Scott It really worked with me and I like to share this so that other users can get benefits from that so that anyone who would like to add something to the order item must study this method Thanks scott Thanks freeman -- View this message in context: http://ofbiz.135035.n4.nabble.com/Cart-Item-Problem-tp3225516p3232262.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Debugging ofbiz in eclipse....
Hi All I'm running ofbiz on linux I'm working noq on 10.04 the svn copy I've problems making the remote debugging and I dunno how to configure the startofbiz.sh file although I've read about it? has anyone modified the startofbiz.sh to be in the debugging mode? or can anyone tell what exact lines do I have to comment regarding the 10.04? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Debugging-ofbiz-in-eclipse-tp158695p3231858.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Cart Item Problem
Thank a lot for your answer I'm really lost in shopping cart classes Could you please give me any guidelines how to study specifically the delegators used regarding the shopping cart or generally how can I get to learn this. Things have been much easier when I used the minilang. even sometimes when using the java I used to make genericValue objects specify the entity and make the CRUDs operations but in case this cartItem objects hasn't been yet in the database so I'm missing this level. I don't know where the part that corresponds to the part of GenericValue objects and these staff can you provide me with any links or even files from the code itself to learn and understand thanks a lot -- View this message in context: http://ofbiz.135035.n4.nabble.com/Cart-Item-Problem-tp3225516p3231121.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Cart Item Problem
Hi All I'm having a problem related to how the objects are related to the database tables so that the object can be saved This was very easy using minlang where you can specify what entity are you using and do the CRUDs easily but what about the java objects how they are mapped to the database tables I cam Across this problem while tring to do the following I want to add two field in the OrderItem table those fields are called fromDate and toDate I've added them to the database table through the entitymodel.xml very easily Actually those two fields come from the quote like startReservation date for example so I went to the service loadCartFromQuote and added them into the cartItem Object I don't know how to map this to the orderItem table I mean now the cartItem contains 2 dates and the OrderItem has 2 dates how the mapping is done? where the method that will save the cart item to order item and put it in the database? I've searched for a while and I found that ofbiz doesn't use ORM then how it works? I'd be grateful for a reply -- View this message in context: http://ofbiz.135035.n4.nabble.com/Cart-Item-Problem-tp3225516p3225516.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: inventory for a virtual product?
Hi All I'm trying to achieve the following scenario The Customer will subscribe to a product this product is magazine or journal so I've created the product and set up a subscription resource to it and created a sales order and then choose the product and I found a record in the subscriptions linking the order with the productSubscription that's fine my problem now is that those magazines and books will not be in warehouse. The publisher will send them direct t the client so I don't want want any inventory items and I don't want any stock checking So I made the it virtual product and I tried to make another sales order on the product but I couldn't. it gave me the following message Choose Variation Before Adding to Cart Although It's not a virtual product why that happened? Am I on the right direction of completing a sales order where items are not in my warehouse? Should I set the supplier to Can Drop Shipe="Y" I'm confused about this -- View this message in context: http://ofbiz.135035.n4.nabble.com/inventory-for-a-virtual-product-tp152521p3220897.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: subscriptions
What I understand is That this services can be called from ecommerce website is this true? I've checked the ditShoppingList u've mentioned and it has frequency, interval, start and end date as I want but I want to use these features in the order manager in the back office. can this be done or I'll have to build my own module? Another Question Actually if a customer wants a subscription of a monthly magazine for ten months I want this to be treated as one order and not ten orders. I think the automatic reorders will treat them as separate orders right? I'm thankful if you can support me with extra information Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/subscriptions-tp158459p3219787.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: subscriptions
Hi All I've the same problem I want to use the subscriptions in ofbiz to handle the subscriptions of magazines and journals I don't know how to do this would anyone tell me what to do if I want to make a weekly subscription and how to assign the start and end date why they are not supported in the order? they are associated with the subscriptionResoure Does that mean if a customer wants the weekly journal for Jan. to December and another one wants it from March to Dec. I'll create two products each one is assigned the same subscription resource and different purchase-from and purchase-to dates? I'd be grateful for any reply Thanks a lot -- View this message in context: http://ofbiz.135035.n4.nabble.com/subscriptions-tp158459p3215881.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Collapsible Panels using ftl
Hi All In the order view screen which includes: orderinfo.ftl ordershippinginfo.ftl ordercontactinfo.ftl ..etc I want to make these screenlets collapsible just like the ordershippinginfo.ftl I've seen how it works and succeeded but my problem is how to make the default "Collapsible" not Expandable can anyone please help? this is the javascript function I use where order Action1 is the screenlet id I've tried to reverse the order of Expand and Collapse but nothing worked I've tried some things does anyone know how to make default collapsed and not expanded -- View this message in context: http://ofbiz.135035.n4.nabble.com/Collapsible-Panels-using-ftl-tp3205860p3205860.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Lookup form multiple parameters
Hi Thanks for your reply Freeman Actually I know that the lookup uses this entity But the situation with me isn't like this I'm using my local copy and the entity isn't empty and yet the lookup doesn't work but when I put the name the customer hard coded and put demoCustomer for example it works The main problem is that the target parameter from the the EditRequest to the targeted look up form That's the main problem I think If anyone has time please can he/she check the target parameter and how it's received ? I've failed to fix it Thanks for all of you -- View this message in context: http://ofbiz.135035.n4.nabble.com/Export-Ofbiz-Services-that-use-complex-type-parameters-New-AXIS2-Ofbiz-Component-Example-tp160706p3171614.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Lookup form multiple parameters
Thanks a lot for your reply Actually I'm having a problem with the following https://demo-trunk.ofbiz.apache.org/ordermgr/control/request Please try to make a request and try to fill Fulfill contact mech Id. the lookup button is not visible on the server but it's visible in my version 10.04 it's supposed that the look up will bring up all the contact mechanisms for the demo customer but that does not happen just brings an empty list I've reported that problem in the following topic too http://ofbiz.135035.n4.nabble.com/Fulfill-Contact-Mech-Id-not-working-td3166032.html I've also wrote down the code where I suspect there's a problem -- View this message in context: http://ofbiz.135035.n4.nabble.com/Export-Ofbiz-Services-that-use-complex-type-parameters-New-AXIS2-Ofbiz-Component-Example-tp160706p3171138.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: form action buttons
I've another question regarding this if I'll use link buttons and targets if I want to use a target service that looks exactly like update service except that it sets a certain field with a certain value in my case (The status field) how can I path the parameters? use for each parameter? can any one help me with that? -- View this message in context: http://ofbiz.135035.n4.nabble.com/form-action-buttons-tp3170195p3170508.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: form action buttons
Thanks a lot for your reply. I understood your point about making link a link button and hyperlink with target and give it parameter if I'd like. I'll put more information about what I want to do so that you and others can help I want to put some buttons in addition to the regular submit and each button should be responsible for doing 2 things: changing the status of the entity used in the form (changing a value generally) and doing the regular sumbit task of updating the value so if I used your solution that's what I expect I'll d and please anyone correct me - make different versions of the update service each one will be the regular update plus putting extra code NOT to take the status from the parameters but seeting it to certain value -make the buttons as button links and set target of each one to the suitable update service version that suits it and assign the parameter name the Id of the entity record I wish to update and change the status like the delete or cancel links My point was to use a hidden field in the form say (actionSelected) and when a certain button is pressed then I'll use the javascript to set that field to certain value and do some customization in the update service to check for the value of actionSelected to decide to which status it will be updated and that will save me from creating different targets.That hidden input and javascript will help me decide which button was pressed and that's very important for me Thanks in advance for any help -- View this message in context: http://ofbiz.135035.n4.nabble.com/form-action-buttons-tp3170195p3170492.html Sent from the OFBiz - User mailing list archive at Nabble.com.
form action buttons
Hi all I want to make buttons in my form and when each button is pressed a different action takes place like in html and freemarker and other languages I want to know how specify a javascript action for a button and where to write it and how to specify its path I've seen the attributes "parameter-name" and "action" and "attribute-name" I think action is for javascript action I don't know how to use them. can anyone give me any example or specify an forms.xml file in ofbiz that uses this technique actually I\ve done this many times but through the freemarker now I want to do this through the regular xml forms that are widely used in ofbiz Thanks a lot for any help -- View this message in context: http://ofbiz.135035.n4.nabble.com/form-action-buttons-tp3170195p3170195.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Lookup form multiple parameters
Can anyone give me a hint how we receive those target parameters in LookUpWorkshop -- View this message in context: http://ofbiz.135035.n4.nabble.com/Export-Ofbiz-Services-that-use-complex-type-parameters-New-AXIS2-Ofbiz-Component-Example-tp160706p3166845.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Fulfill Contact Mech Id not working
Actually the main problem is in the screen Edit Request when I go to create request I choose customet and then I should choose fullFul contact mech Id using the lookup button and it's expected that I'll get a list of the available contact mechanisms of that client but that doesn't happen and I got emtyp list. this is the important part in the custRequestForms as you see the fromPartyId is used as target parameter to the LookupPreferredContactMech but Actually this parameter seems to be incorrectly received because I get an empty list. what I did as a test is that I went to LookupPreferredContactMech and put the partyId myself for example DemoCustomer and everything worked find I got a list of all possible contact mechanisms for this party so I'm asking how to receive it correctly? can anyone check with me the code in LookupPreferredContactMech I'll put it anyway it seems there's something wrong in this when I hard coded it it worked also in the previous version it was "parameters.parm0" I've tried lots of things for example "parameters.fromPartyId" does anyone have a clue? where can I study the code of the target-parameter and how to send and receive it? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Fulfill-Contact-Mech-Id-not-working-tp3166032p3166836.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Fulfill Contact Mech Id not working
does anyone know how to acccess the target parameters ? if it's not list just one parameters? how to access it. it seems this is the problem -- View this message in context: http://ofbiz.135035.n4.nabble.com/Fulfill-Contact-Mech-Id-not-working-tp3166032p3166067.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting right behavior of use-when when using in multi (form type) form
I faced A similar problem and I found no answer to me question but while customizing in the return forms I found those lines observe how the condition should be written (I didn't have time to test it myself) -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-right-behavior-of-use-when-when-using-in-multi-form-type-form-tp3166002p3166022.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting error when going to Find Approved Requirements screen
Also when I navigate to "Find approved requirements" I face the following exception does anyone have a clue about that? 2010-12-14 21:17:40,156 (http-0.0.0.0-8443-3) [FlexibleStringExpander.java:509:W ARN ] exception report -- Error evaluating BSH scriptlet [${bsh: org.ofbiz.party.party.PartyHelper.getPart yName(delegator, partyId, false);}], inserting nothing; error was: Sourced file: inline evaluation of: `` org.ofbiz.party.party.PartyHelper.getPartyName(delegat or, partyId, false);'' : Undefined variable or class name while evaluating: org. ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline evaluation of: `` o rg.ofbiz.party.party.PartyHelper.getPartyName(delegator, partyId, false);'' : or g .ofbiz .party .party .PartyHelper .getPartyName ( delegator , partyId , false ) Exception: bsh.EvalError Message: Sourced file: inline evaluation of: `` org.ofbiz.party.party.PartyHelpe r.getPartyName(delegator, partyId, false);'' : Undefined variable or class name while evaluating: org.ofbiz.party.party.PartyHelper stack trace --- Sourced file: inline evaluation of: `` org.ofbiz.party.party.PartyHelper.getPart yName(delegator, partyId, false);'' : Undefined variable or class name while eva luating: org.ofbiz.party.party.PartyHelper : at Line: 1 : in file: inline evalua tion of: `` org.ofbiz.party.party.PartyHelper.getPartyName(delegator, partyId, f alse);'' : org .ofbiz .party .party .PartyHelper .getPartyName ( delegator , par tyId , false ) bsh.UtilEvalError.toEvalError(Unknown Source) bsh.UtilEvalError.toEvalError(Unknown Source) bsh.BSHMethodInvocation.eval(Unknown Source) bsh.BSHPrimaryExpression.eval(Unknown Source) bsh.BSHPrimaryExpression.eval(Unknown Source) bsh.Interpreter.evalParsedScript(Unknown Source) bsh.Interpreter.eval(Unknown Source) bsh.Interpreter.eval(Unknown Source) bsh.Interpreter.eval(Unknown Source) org.ofbiz.base.util.BshUtil.eval(BshUtil.java:72) org.ofbiz.base.util.string.FlexibleStringExpander$BshElem.get(FlexibleStringExpa nder.java:500) org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp ander.java:386) org.ofbiz.base.util.string.FlexibleStringExpander.expandString(FlexibleStringExp ander.java:356) org.ofbiz.widget.form.ModelFormField$DisplayField.getDescription(ModelFormField. java:2101) org.ofbiz.widget.form.MacroFormRenderer.renderDisplayField(MacroFormRenderer.jav a:190) org.ofbiz.widget.form.ModelFormField$DisplayField.renderFieldString(ModelFormFie ld.java:2084) org.ofbiz.widget.form.ModelFormField.renderFieldString(ModelFormField.java:595) org.ofbiz.widget.form.ModelForm.renderItemRow(ModelForm.java:1665) org.ofbiz.widget.form.ModelForm.renderItemRows(ModelForm.java:1593) org.ofbiz.widget.form.ModelForm.renderListFormString(ModelForm.java:1105) org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java:839) org.ofbiz.widget.screen.ModelScreenWidget$Form.renderWidgetString(ModelScreenWid get.java:840) org.ofbiz.widget.screen.MacroScreenRenderer.renderScreenletSubWidget(MacroScreen Renderer.java:710) -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-error-when-going-to-Find-Approved-Requirements-screen-tp3087755p3087784.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Getting error when going to Find Approved Requirements screen
Hi all I'm trying to make a product requirement then approve it then go to the screen "Find approved requirements by supplier" so that I should see the requirements grouped by supplier then I face the following exception Error getting list size Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELE T COUNT(DISTINCT *) FROM OFBIZ.REQUIREMENT RQ INNER JOIN OFBIZ.REQUIREMENT_ROL RQR ON RQ.REQUIREMENT_ID = RQR.REQUIREMENT_ID WHERE (RQR.ROLE_TYPE_ID = ? AND Q.STATUS_ID = ? AND RQ.REQUIREMENT_TYPE_ID = ? AND ((RQR.THRU_DATE IS NULL OR R R.THRU_DATE > ?) AND (RQR.FROM_DATE IS NULL OR RQR.FROM_DATE <= ?))) GROUP BY R R.PARTY_ID) TEMP_NAME (Syntax error: Encountered "*" at line 1, column 45.) cause Exception: java.sql.SQLSyntaxErrorException Message: Syntax error: Encountered "*" at line 1, column 45. cause Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: Syntax error: Encountered "*" at line 1, column 45. cause Exception: org.apache.derby.iapi.error.StandardException Message: Syntax error: Encountered "*" at line 1, column 45. stack trace -- ERROR 42X01: Syntax error: Encountered "*" at line 1, column 45. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternal tatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(Unknown Source) org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnect on.java:291) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnect on.java:291) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:362) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1 81) org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityL stIterator.java:515) I'm using 10.04 and I didnt change anything in the file script service of the requirements has anyone used the requirements and the feature of grouping the requirements by suppliers? is their a bug or have I misused something Can anyone tell me what's the exception is about? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-error-when-going-to-Find-Approved-Requirements-screen-tp3087755p3087755.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Ofbiz integration with phone or Call centre device
Thanks a lot Freeman for your great support but if you allow me I have some inquiries ad I'm totally new to this field. I'll repeat facts about that and please correct me if I'm wrong. The Ofbiz can be integrated with a called center device with Asterisk software running on it and this integration code is free and I can use it and then I'll be able to to use the phone number of the calling customer as I wish. If I'll use another telephone or call center device or so then I'll use the Java telephone API and do that part myself If anyone can correct me if I'm wrong or provide me with more information I'll be grateful Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz-integration-with-phone-or-Call-centre-device-tp3082555p3083094.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Ofbiz integration with phone or Call centre device
Hi All I'm asking about the possibility of integrating the ofbiz with phone or call centre device. I want to achieve the following scenario A customer calls then the system knows the phone number and lookup it's information from the databse I dun think there's something like that in ofbiz am I right? Did anyone experience the same situation or have some more information in that field? even if it's just Java related? I their any guide Lines Thanks in Advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz-integration-with-phone-or-Call-centre-device-tp3082555p3082555.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Returns Invoice
Hi all I'm using release10.04 I'm asking about the auto creation of the invoice (Customer refund invoice) I go to the certain order I want. then "create return" and specify the items then click accept then go and receive the shipment and the recieve the return from the inventory and the status remains received not completed when I changed it myself to completed it generated for me the invoice but the total is zero and there's no items would anyone please tell me what I'm doing wrong? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/CheckOutHelper-makeTaxContext-r718913-goes-bm-tp157961p3078244.html Sent from the OFBiz - User mailing list archive at Nabble.com.
General question about lookup in ofbiz
Hi all I've a question please genereally in the lookup forms when I go to make a lookup on the party or a product the ofbiz goes and finds the name if that party or that product and put beside the field shaded with yellow colour how it does that?? what's the function or method it uses? Another question I want to do a customization in the request screen so that when the employee chooses a customer preferred currency of that customer is loaded automatically in the currency field does anyone have suggestion on how this could be done? Can I relate it to the code that gets the name of the party after I look it up to get the currency too and if that's applicable how to refresh the page? after such information -- View this message in context: http://ofbiz.135035.n4.nabble.com/General-question-about-lookup-in-ofbiz-tp3077850p3077850.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: comparing two dates using use-when
It seem I don't have enough infoirmation about use-when attribute. does anyone have? everything goes right when I use it to check if something is null or not but when I do further checking it deosn't go right the use-when is widely used in ofbiz to check if something is null or not or the map in the conext is null or not but what I want to do now is to check if the productStatus equals certain value or not and the checking always gives me negative answer something strange happens as well when I go to print the productStatus it doesn't print the status it's not null but prints nothing on the screen I put the actions before alt-target because I'll need it to decide which target shall i go to. Am I putting the actions in a wrong place? does anyone have any suggestion to use different submit buttons and different targets based on product status? -- View this message in context: http://ofbiz.135035.n4.nabble.com/comparing-two-dates-using-use-when-tp306p3077804.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: comparing two dates using use-when
Thanks a lot for your replies Unfortunately both solutions didn't work for me Any more suggestions? -- View this message in context: http://ofbiz.135035.n4.nabble.com/comparing-two-dates-using-use-when-tp306p3074040.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: comparing two dates using use-when
Hi All Please all I need help on using the use-when attribute I've made a product status field in the form and I want to check for that field this field s string and I can't use use- when with strings what I have done is this: This was to store the status of the product this is to change target when the status equals "Periodic Mass Load" this is a submit button I want to use also if the status matches this value "Periodic Mass Load" anyone can help or give me a link to read? I duno how to check strings. I tried to remove spaces but the problem remains te same. Instead of single quotes I put double quote and the same problem remains here's the exception at java.lang.Thread.run(Thread.java:619) 2010-12-05 16:38:17,127 (http-0.0.0.0-8443-2) [FlexibleStringExpander.java:692:ERROR] Error evaluating expression ${productStatus.equals('Periodic Mass Load')}: javax.el.ELException: Error parsing '${productStatus.equals('Periodic Mass Load')}': syntax error at position 22, encountered '(', expected '}' 2010-12-05 16:38:17,157 (http-0.0.0.0-8443-2) [StandardWrapperValve.java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception bsh.TokenMgrError: Lexical error at line 1, column 26. Encountered: "e" (101), after : "\'P" at bsh.ParserTokenManager.getNextToken(Unknown Source) at bsh.Parser.jj_scan_token(Unknown Source) at bsh.Parser.jj_3R_138(Unknown Source) at bsh.Parser.jj_3R_129(Unknown Source) at bsh.Parser.jj_3R_98(Unknown Source) at bsh.Parser.jj_3R_57(Unknown Source) at bsh.Parser.jj_3R_33(Unknown Source) at bsh.Parser.jj_3R_107(Unknown Source) at bsh.Parser.jj_3R_70(Unknown Source) at bsh.Parser.jj_3R_39(Unknown Source) at bsh.Parser.jj_3R_134(Unknown Source) at bsh.Parser.jj_3R_106(Unknown Source) at bsh.Parser.jj_3R_69(Unknown Source) at bsh.Parser.jj_3R_37(Unknown Source) at bsh.Parser.jj_3R_101(Unknown Source) at bsh.Parser.jj_3R_57(Unknown Source) at bsh.Parser.jj_3R_33(Unknown Source) at bsh.Parser.jj_3R_107(Unknown Source) at bsh.Parser.jj_3R_70(Unknown Source) at bsh.Parser.jj_3R_39(Unknown Source) at bsh.Parser.jj_3R_133(Unknown Source) at bsh.Parser.jj_3R_104(Unknown Source) at bsh.Parser.jj_3R_58(Unknown Source) at bsh.Parser.jj_3R_33(Unknown Source) at bsh.Parser.jj_3_8(Unknown Source) at bsh.Parser.jj_2_8(Unknown Source) at bsh.Parser.Expression(Unknown Source) at bsh.Parser.StatementExpression(Unknown Source) at bsh.Parser.Statement(Unknown Source) at bsh.Parser.BlockStatement(Unknown Source) at bsh.Parser.Line(Unknown Source) at bsh.Interpreter.parseScript(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at org.ofbiz.widget.form.ModelForm.getTarget(ModelForm.java:1967) at org.ofbiz.widget.form.MacroFormRenderer.renderFormOpen(MacroFormRenderer.java:1237) at org.ofbiz.widget.form.ModelForm.renderSingleFormString(ModelForm.java:879) at org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java:837) at org.ofbiz.widget.screen.ModelScreenWidget$Form.renderWidgetString(ModelScreenWidget.java:840) -- View this message in context: http://ofbiz.135035.n4.nabble.com/comparing-two-dates-using-use-when-tp306p3073306.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Currency problem in choosing the appropriate supplier in requirement
I wanted to make a simple regarding the requirement problem of assigning the requirement to the supplier that has the least price regardless of the difference in currencies. I created a field in the entity supplier product called priceDefaultCurrency which will hold the price in my default currency. I've decided to use the table in the accounting that holds foreign currency changes and idea is when we automatically assign a requirement we'll check if the price is the default say USD or not if it's in USD then priceDefaultCurrency will be equal the lastPrice and if not the I'll get the record that holds the conversion rate from the table uomConversionDated. and get the conversion factor and multiply it to the price and this will be the value of priceDefaultCurrency I'll depend in my code that there exists for example just oe rate from say EUR to USD then I can fix that. I've tried to that in minilang but I've an exception the case where the price is in USD the code goes right and the priceDefaultCurrency is updated right the case where the price isn't in USD it gve me exception and the priceDefaultCurrency is 0 here's the code I've it in the service autoAssignRequirementToSupplier this the whole service code I know it doesn't do the assignmet in the right way but at least I need to update the field priceDefaultCurrency and the exception is Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELEC T COUNT(DISTINCT *) FROM OFBIZ.REQUIREMENT RQ INNER JOIN OFBIZ.REQUIREMENT_ROLE RQR ON RQ.REQUIREMENT_ID = RQR.REQUIREMENT_ID WHERE (RQR.ROLE_TYPE_ID = ? AND R Q.STATUS_ID = ? AND RQ.REQUIREMENT_TYPE_ID = ? AND ((RQR.THRU_DATE IS NULL OR RQ R.THRU_DATE > ?) AND (RQR.FROM_DATE IS NULL OR RQR.FROM_DATE <= ?))) GROUP BY RQ R.PARTY_ID) TEMP_NAME (Syntax error: Encountered "*" at line 1, column 45.) cause - Exception: java.sql.SQLSyntaxErrorException Message: Syntax error: Encountered "*" at line 1, column 45. cause - Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: Syntax error: Encountered "*" at line 1, column 45. cause - Exception: org.apache.derby.iapi.error.StandardException Message: Syntax error: Encountered "*" at line 1, column 45. stack trace --- ERROR 42X01: Syntax error: Encountered "*" at line 1, column 45. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalS tatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source) org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(Unknown Source) org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnecti -- View this message in context: http://ofbiz.135035.n4.nabble.com/Currency-problem-in-choosing-the-appropriate-supplier-in-requirement-tp2551814p3061844.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: No inventory for
Hi All Actually I'm facing a strange scenario and I hope anyone will help me I know that the retail store is intended to be used by POS but for some reason I want to have the 2 options available for me which are: 1-Create orders using my retail store through pos creation 2- Create orders from backend using the order entry screens in the order manager using the retail store I faced exception during the picking process of the when I created the order from order manager when I go to facility and click the picking tab it gives me a message "no orders to be picked" although I've created inventory for the products and set a location for them is that because of a special setting in the retail store? do I have to create another store? I think this is because of the option "isImmediatelyFulfilled"= "Y" what I've noticed is that the retail store doesn't have any inventory and so this flag is set to Y so that we can make orders from POS right? I don't think I want to use it this way what If I want to treat it normally for example the POS have some inventory and I'm selling the products till the products are finished? What if I changed That flag to "N" and just through the POS I shall only select the available products? Thanks in advance for any help -- View this message in context: http://ofbiz.135035.n4.nabble.com/No-inventory-for-My-Retail-Store-tp147908p3052408.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: POS order
Although something crossed my mind about the order statuses I know it's completed what if it needs a stock move? will that cause kind of contradiction Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/POS-order-tp142142p3050164.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: POS order
Hi Jacques Thanks a lot for your previous reply I have more inquireis about the POS and I really wish you could help me with them Now I'm thinking of using the webpos and I've tested it and made a successful order and saw it in the order manager and that was great and it had the status of completed. I want to have the following scenario in my POS The customer is asking about a product and this product is not in my retail store right now so I want to make a stock move between stores I know this is very normal in the ordinary order but how this cases are handlel in the POS when a csuometr asks about a product and this product has finished from your store and you'll move it from other stores ? Can I set is automatically fulfilled to N how to handle these cases as a user ? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/POS-order-tp142142p3050159.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can´t create order from quote
I understand what are trying to say about the product being on my system but this is how it goes in my case I was really away from my resources and I just tried that in earlier version and the PO was done successfully I'll investigate more in this and tell you the results if you are interested -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-create-order-from-quote-tp159273p3050021.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: POS order
Hi All I have some questions regarding the pos and the order relations If I go and open the pos terminal using startofbiz.bat on a windows machine and chose some products then clicked "save sale" this means my sales order is successfully completed? how can I make sure? where can I see that in the database? Shall I see this order when I go to the order manager? is the order done by the POS terminal is treated as an order and it's saved in the orderheader table. I've tried to make order through POS but I couldn't find it in the order list in the order manager is that natural or the order I've made through the POS wasn't successful? As a matter of fact I don't need all the options found in the POS but I wanted to skip the shipping steps in the ordinary order screens but I found that even if I used quick "finalize with default options" I'm asked about the shipping address of the customer and shipping options ans such staff so I decided to explore the POS Also something crossed my mind what if I set the customer in the order entry screen to "_NA_" will I be able to escape from entering the shipping address of that customer? Thanks in advance for anyone who can help -- View this message in context: http://ofbiz.135035.n4.nabble.com/POS-order-tp142142p3046385.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can´t create order from quote
Hi Freeman Hi all I go to order manager then choose quotes click on the button create quote then choose the type to be product purchase then I specify the from and to parties From:Supplier To:company then I click submit the quote is created then I change the status of the quote to be accepted I click on the button create order in the quote screen then it navigates to the order entry screen as if I'm in the middle of purchase order entry would you please tell me what I'm doing is right or wrong I know well that it's very ordinary to create sales order from a quote but I'm asking if that's the case with purchase order I'll repeat the error message that I encounter: enter a shipping address there's no exception in the log file when I go to create the PO again from ordinary order entry screen with the same details I don't encounter any error messages Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-create-order-from-quote-tp159273p3046236.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can´t create order from quote
The usual way of creating quote just I set its type to product purchase then I specify the from party to any supplier and to party to my company I don't know if this is right or not and I didnt read about that in the wiki I really need to know is this right or the quote is just part of the sales process from the company to a customer. If it's a part of a sales can you help me what are the different types of quotes are used for? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-create-order-from-quote-tp159273p3045677.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can´t create order from quote
Thanks a lot for your reply but you please explain more. What I understood from your message is that the quote is a stage in the sales order process and I can't create a PO from quote is that right? would you please tell me the difference from business side what's the difference between the two types of quote the Quote for product and quote for product purchase I'm very grateful for your help Thanks a lot in advance Shereen -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-create-order-from-quote-tp159273p3042827.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can´t create order from quote
I can't create a purchase order from a quote. the quote type is product purchase the error is: Please enter a shipping address no exception in the log file it seems as if the shipping information isnt passed to the method that creates the order knowing that when I navigate to make a purchase order everything is ok I'm using the svn version 10.04 -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-create-order-from-quote-tp159273p3041684.html Sent from the OFBiz - User mailing list archive at Nabble.com.
How to include ftl from a form
Hi all I have a technical question Can I insert ftl inside a form? For example I'm doing some customization in the request screens the EditRequest screen includes a form this form consists many fields one after the other I've added a checkBox at the end of the form and I just want to put some note just before that check box how to do that? I've only tried to play with fields in the forms but I didnt try to insert pure text is this possible? I just want to add some text in bold red colour so i thought of ftl but I only know that it could include it from screen not form I also tried to use but it agave me errors I duno what are the right conditions to do this -- View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-include-ftl-from-a-form-tp3036602p3036602.html Sent from the OFBiz - User mailing list archive at Nabble.com.
EditPartyGroup screen
Hi All I have a question in the party application when I choose any partyGroup and go to update it. If I go to update the party group information I find a field called Currency appears to be a text field and another called Preferred Currency Uom Id a dropdown menu for currencies what's the difference between both? I check the party forms and I found that editPartyGroup contains the Preferred Currency Uom Id and the viewPartyGroup contains another Preferred Currency Uom Id. I want t remove the currency text field I see it's of no use from where can I remove it? -- View this message in context: http://ofbiz.135035.n4.nabble.com/EditPartyGroup-screen-tp3031596p3031596.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Store Credit options
Hi All I'm asking about the possibility of storing credit notes in ofbiz and reusing them for example some customer will return a product this product's price is 20 dollars but he'll not get money he'll use this 20 dollar as a credit note so when next time he makes an order with 40 dolllar he's going to pay only 20 and consume his credit note I know there's an option in return called store credit but what's the financial consequences of using that option what it will do? does any one knows a good way of handling returns with no refund but with store credit wether it's a sales or purchase return so that I can compare and see if I have to do some coding or the features are enough for me. Actually trying to imagine that is hard for me especially for purchase orders. If I have credit note with 100 and the next purchase order costed me 1000 so I'll only make a payment with 900 what about the other 100 dollar how I'm gonna make another payment with 100 dollar and make ofbiz understand that it's from credit? are billing and financial accounts used in that? if so how? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Store-Credit-options-tp3024947p3024947.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Status?
Hi Santosh Thanks a lot for trying to help me. I followed your advice and I created the products from category and it's really better to do so this way because simply I make my categories in a hierarchical way so simply I'll go to the child category and create the product. About the status of the product I also tried to do what u told me and I set introduction date in 2011 but in appeared in the product lookup screen however :( But when I tried to add to the order it gave me error telling me it's not ready for sale. is there a way where it may not appear in the product list of sales order? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Status-tp956708p3024913.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Status?
Thanks Atul Thanks Jacques I didnt look at the series you are mentioning in your link Actually I search for the general Apache Ofbiz Cookbook and it seemed to me technical. Anyway I'll see if I can buy the book you told me about Thanks a lot and if anyone who passed through these stages and can inform me how to do this that will be also great :) -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Status-tp956708p3023496.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Status?
Thanks Freeman Thanks Atul I saw the links of the tutorials you sent me. unfortunately they didnt include my answers About Ruth Hoffman I've the other book called Apache_Ofbiz_Development_for_Beginners from packet publisher too it's a technical book when I viewed the table of contents of Ruth's book I found it from a technical point of view too right? I think my questions are more of a user just how at product to catalog when it will be active and such staff is those issues discussed in the book or I can find it somewhere else? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Status-tp956708p3023275.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Status?
Also I've a question about the product status and when it shall be available I know this is asked before but I want to make sure that I get it correctly First: If I created the product and didnt put an introduction date what will be the status of that product? will it be disabled? will it appear in the lookups for sales orders and catalogs? I'm asking these questions because I want to follow this scenario: someone will have the role to create a new product but this product will not be activated and shouldn't appear to lookup of sales orders and no one can add it to the catalogue untill someone creates add the prices and suppliers and such stuff so I was thinking of using the advantage of introduction date instead of making new statuses Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Status-tp956708p3022157.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Status?
Hi All I have really a simple question but there's something simple I cant do. How to add a product to a catalog I've problems understanding the catalogue I've read the wiki but there's something I don't understand about the addition of the product. That's what I've tried to do: went to the catalog manager main page Clicked on shortcut new product Entered all the needed information and the product successfully created when I click on certain catalog there's no tab for products that exists in that catalog should I add this product to a store then add the store to the catalog if so how? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Status-tp956708p3022131.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: bsh or groovy in services
hi all Can I now integrate write groovy in minilang as the bsh? if so how? the same way e call bsh? -- View this message in context: http://ofbiz.135035.n4.nabble.com/bsh-or-groovy-in-services-tp152367p3020941.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Customization of pickList services
Hi All I changed in the order flow a little and therefore now I have to do some customization in the picking process My flow goes as follows I've added an attribute in the customer party called require prepayment this indicates if the customer should make down payments in the his orders or not. in the sales order I do checking if this customer has the require prepayment attribute the prepayment should be received first then the order shall move from "ORDER_APPROVED "to a state called "Ready for shipping" Now regarding the picking I want the order that are ready to be picked should be either of the two cases: 1-Ready to ship 2-Approved and the customer doesnt have the require prepayment attribute I was able to do that checking using ftl and groovy by using orderReaderHelper to get the customer then check the require prepayment attribute but how can I make that checking in pickListservices in that service the checking is done this way Can I modify this to match the scanrio I want In other way make the order possible for picking if it's status is "READY_TO_SHIP" or if the order status is "ORDER_APPROVED" and the customer doesn't have the require prepayment field does the minilang allow me to write such a code ? or it would be safer to make the scenario I want want lead to another status and simply check on that status? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Customization-of-pickList-services-tp3020899p3020899.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting an OrderPaymentPreference in orderinfo.ftl
Thanks Scott a lot for your advce actually Freeman advised me to use groovy as well. My problem is that I don't know groovy I've never wrote any code in groovy but I'll check the files already implemented and try to do it. I've asked more specific question n topic Check on party fields from ftl files I've mentioned that I want to make a groovy file and that groovy file checks on certain field in the party entity. this is an extra field I've put in the party entity called requirePrepayment and it's a checkbox I just want get the customer related to the order then check if that field is checked or not. If you can help me with any code or suggestions that would be great -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-an-OrderPaymentPreference-in-orderinfo-ftl-tp3015326p3016691.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Check on party fields from ftl files
It wil be the first time ever I use the groovy. But I'll follow your advice and try this but meanwhile I'll try also to do it using the ftl That's what I've done till now: <#assign orh = Static["org.ofbiz.order.order.OrderReadHelper"].getHelper(orderHeader)> <#assign billToParty = orh.getBillToParty()?if_exists> <#assign billToPartyNameResult = dispatcher.runSync("getPartyNameForDate", Static["org.ofbiz.base.util.UtilMisc"].toMap("partyId", billToParty.partyId, "compareDate", orderHeader.orderDate, "userLogin", userLogin))/> I think that way I'm getting the customer now I want to check on certain field that's how I tried to check it and it gave me exception: <#assign reqPrepayment = billToParty.requirePrepayment/> the exception is Error on line 33, column 13 in component://order/webapp/ordermgr/order/orderinfo.ftl billToParty.requirePrepayment is undefined. It cannot be assigned to reqPrepayment at freemarker.core.Assignment.accept(Assignment.java:111) where else should that field be declared and I'm really so thankful for your help -- View this message in context: http://ofbiz.135035.n4.nabble.com/Check-on-party-fields-from-ftl-files-tp3015477p3015542.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting an OrderPaymentPreference in orderinfo.ftl
I now this feature in ofbiz I've seen the tables and the records I just want be able to do any checking I like in my ftl files for more cutomization I'm also facing another proble of getting entities and check on their fields I've mentioned that in separate topic Thanks a lot for your reply -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-an-OrderPaymentPreference-in-orderinfo-ftl-tp3015326p3015480.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Check on party fields from ftl files
Hi all I'm new to freemarker and I want to do some checking in the orderinfo.ftl I want to get the customer for the order then check on certain field in the that customer In more detailes I've added a field to the party called requirePrepayment now I want in the orderinfo.ftl to know the customer (the bill to party and check on that field. I think I'll need the orderhelper right? would anyone suggest some code? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Check-on-party-fields-from-ftl-files-tp3015477p3015477.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Getting an OrderPaymentPreference in orderinfo.ftl
Hi all I've done some customization in the order flow now I want to make a check that order must be paid before being ready to be packed I'm working on the orderinfo.ftl my question is how using ftl code can I get the related payment status in the entity OrderPaymentPreference for the orderheader that I have? I've done some trials but all failed I'll be grateful for any suggestion -- View this message in context: http://ofbiz.135035.n4.nabble.com/Getting-an-OrderPaymentPreference-in-orderinfo-ftl-tp3015326p3015326.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ftl permission question
It worked with me I'm very grateful thank you -- View this message in context: http://ofbiz.135035.n4.nabble.com/ftl-permission-question-tp3010080p3013328.html Sent from the OFBiz - User mailing list archive at Nabble.com.
ftl permission question
Hi all I'm asking about the possibilty of checking certain role in ftl file is it possible? for example I've done some custom changes regarding the order and I've created a stage called Manager approve this manager approve has a button just like hold order and cancel order in the order.ftl but I dont want this button or link to be available unless the logged user is a manager would anyone give me any ideas or suggestion on how to implement that I've already done some permission checking but using minilang in simple methods although I've put some permission checking on some screnlits but I think the case is different here I want the security to be done on certain link or button not screenlit not service Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/ftl-permission-question-tp3010080p3010080.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Questions about order statuses check and orderinfo.ftl
Hi All I'm doing some customizations in the order statuses flows and I faced the following case I've noticed that in orderinfo.ftl it uses frequency the check <#if currentStatus.statusId != "ORDER_COMPLETED" && currentStatus.statusId != "ORDER_CANCELLED"> it checks the current status of the order that's ok but what if I want to check for a previous state ? for example I'm in a hold stage but I want to check what stage was before that hold something like that <#elseif currentStatus.statusId == "ORDER_HOLD" && oldStatusId!="ORDER_APPROVED_MGR"> this gaives me exception tell me that oldStatusId is not defined I know there's no field in order header entity called oldStatusId but this field is saved in the order services java method the method is called setOrderStatus How can I make use of that status? I'd be thankful for any suggestions Best Regards and Thanks in Advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Questions-about-order-statuses-check-and-orderinfo-ftl-tp3009053p3009053.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Free Shipping?
Thanks Freeman I got your point but still the Ofbiz needs a valid shipping address even if no shipping is required right? I think disabling that will require some coding or it's not possible ? will cause other problems? you know it's as if you choose from certain store or catalog then there will be no shipping at all no need to enter shipping address or so I'll do some studies and search and if you have further recommendations please tell me Regards -- View this message in context: http://ofbiz.135035.n4.nabble.com/Free-Shipping-tp156203p3008991.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Free Shipping?
Hi Santosh I'm very grateful for your help and support You're completely right about the point "how the orders will be delivered?" Actually I want to do something like a pos without using pos and I have my reasons not to use one. Just imagine this order will be entered in the system as if I'm selling in a real store and the customer is right here so no need for me to go check the shipping address and use shipping method and such things there will be other problem too of the obligation of using a currently entered customer from the system but I think this will not be a big problem for now I'll be grateful and thankful to know your suggestions and recommendations Best Regards -- View this message in context: http://ofbiz.135035.n4.nabble.com/Free-Shipping-tp156203p3008621.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Free Shipping?
Hi all My problem is similar to the problem of the free shipping. I want a way to avoid shipping at all. NO shipping For example when I choose my products of certain stores the shipping can be skipped no method is required nor any expenses or such things as if you were selling in pos or something is that possible through the GUI or I have to do it using some coding? If so is there any one who have suggestions or guide me how to do it? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Free-Shipping-tp156203p3008417.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Advice wether to use workflow engine
Hi All During my work on understanding the code of how order process takes place and the valid statuses changes and such things Actually I'm trying to study the order java services. what I understand now is that I'll have to change in the status valid changes table and do some changes in the code but I didnt study any xpdl files even there's one in the order. how this xpdl file affect me ? will it be enough to change the order services that allow changes from one stage to the other and do the necessary changes in the database? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Advice-wether-to-use-workflow-engine-tp2994955p3003900.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Auto approval problem
Thanks narayan thx jacques I'll follow your advice -- View this message in context: http://ofbiz.135035.n4.nabble.com/Auto-approval-problem-tp3003489p3003622.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Auto approval problem
I was trying to make a new ECA in the seca.xml in the order servicedefin my trial wasn't successful and I just commented the code then I synchronized with the source svn I found after that a strange behavior which is when I go to make a new sales order the click create the order is both created and approved !! It's the first time I encounter this problem and I havent changed anywhere else in the code. Is there a condition where the order is auto approved?? by the way I was doing my experiments using the admin account is there any help?? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Auto-approval-problem-tp3003489p3003489.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Find order questions
Thanks a lot for your reply I'll follow your advice I'll try to make my questions more specific. I'd be very grateful for any guidance from you or any user regarding my previous questions about order entities and so. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Find-order-questions-tp351p3001507.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Find order questions
Thanks for your advice I'll try to do that. I was asking too about the functionality can i define my own lists with type and states defined as I wish using lists in forms and performfind? what entity should I choose then? if I used my portal I'll only choose screens? I want more security than this for example I show the order list of certain statuses will I be able to do that? or this will not be changed unless I do changes in the .groovy files and ftl files associated with the order Thanks a lot for help in my BJ Freeman wrote: > > I suggest you get familiar with myportal > Its purpose is to provide screens for a particular login. > > > = > BJ Freeman > Strategic Power Office with Supplier Automation > <http://www.businessesnetwork.com/automation/viewforum.php?f=52> > Specialtymarket.com <http://www.specialtymarket.com/> > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > >> Shereen sent the following on 10/18/2010 4:35 AM: >> Hi all >> I want to make custom different lists of order so that every employee can >> see different list according to his job >> for example I want the sales person to the approved orders only and i >> want >> the accountant to see the created orders only >> I know this seems simple But I'm confused about some staff. >> First I've done things similar in the requests using form lists and >> performfind and by setting some fields before the performfid >> >> Can I do this in the order? can I follow the same way of lists and >> performfind and such things? >> if so what entity should I use I find there are a lot of entities in the >> order but none named Order I tried to the trace the already implemented >> code >> but I failed to make something successful so can anyone help me doing >> that >> using the normal form list and perform find? > > BJ Freeman wrote: > > I suggest you get familiar with myportal > Its purpose is to provide screens for a particular login. > > > = > BJ Freeman > Strategic Power Office with Supplier Automation > <http://www.businessesnetwork.com/automation/viewforum.php?f=52> > Specialtymarket.com <http://www.specialtymarket.com/> > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > >> Shereen sent the following on 10/18/2010 4:35 AM: >> Hi all >> I want to make custom different lists of order so that every employee can >> see different list according to his job >> for example I want the sales person to the approved orders only and i >> want >> the accountant to see the created orders only >> I know this seems simple But I'm confused about some staff. >> First I've done things similar in the requests using form lists and >> performfind and by setting some fields before the performfid >> >> Can I do this in the order? can I follow the same way of lists and >> performfind and such things? >> if so what entity should I use I find there are a lot of entities in the >> order but none named Order I tried to the trace the already implemented >> code >> but I failed to make something successful so can anyone help me doing >> that >> using the normal form list and perform find? > > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Find-order-questions-tp351p3000380.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Find order questions
Shereen wrote: > > Hi all > I want to make custom different lists of order so that every employee can > see different list according to his job > for example I want the sales person to the approved orders only and i want > the accountant to see the created orders only > I know this seems simple But I'm confused about some staff. > First I've done things similar in the requests using form lists and > performfind and by setting some fields before the performfid > > Can I do this in the order? can I follow the same way of lists and > performfind and such things? > if so what entity should I use I find there are a lot of entities in the > order but none named Order I tried to the trace the already implemented > code but I failed to make something successful so can anyone help me doing > that using the normal form list and perform find? > I'm struggling now to understand orderlist.ftl is that the key to what I'm trying to do or it can be done in a simpler way? I just want simple lists of created , approved orders etc and this lists appear matching the roles os the one to view them -- View this message in context: http://ofbiz.135035.n4.nabble.com/Find-order-questions-tp351p3000125.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Find order questions
Hi all I want to make custom different lists of order so that every employee can see different list according to his job for example I want the sales person to the approved orders only and i want the accountant to see the created orders only I know this seems simple But I'm confused about some staff. First I've done things similar in the requests using form lists and performfind and by setting some fields before the performfid Can I do this in the order? can I follow the same way of lists and performfind and such things? if so what entity should I use I find there are a lot of entities in the order but none named Order I tried to the trace the already implemented code but I failed to make something successful so can anyone help me doing that using the normal form list and perform find? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Find-order-questions-tp351p351.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Account and Lead assign to me
Anyone can help in leads and contact problems? why when a lead or a contact is created by someone it doesnt show up in his "my" lists. why he still have to press assign to me. I've checked the records in the database and I found them correct the owner of the lead or contact is recorded correctly. this is of a great importance to me because i want to disable the assign to me button. I'm grateful for any help -- View this message in context: http://ofbiz.135035.n4.nabble.com/Account-and-Lead-assign-to-me-tp2994898p2999101.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Checkbox confirmation
Thanks for your contribution I've tried this it didnt work at first because I didnt update the service definition file I decided to post my updates so anyone who faces similar problem may get use of it -- View this message in context: http://ofbiz.135035.n4.nabble.com/Checkbox-confirmation-tp2998649p2999068.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Checkbox confirmation
Thanks a lot for your help so what I understand is that I can use that checkbox even if it's not in the entity it's just a form field and I can check for it in the create service I tried to do that checking but if it was completely ignored as if the condition has no existence so would you please tell me how can I do that in my code? check if the check box is checked or not. is that available in minilang ? can I use if compare or if compare field ? if so how? For sme reasons I dont want to use javascript. Thanks again for your support -- View this message in context: http://ofbiz.135035.n4.nabble.com/Checkbox-confirmation-tp2998649p2998879.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Checkbox confirmation
Hi all I want to add a checkbox in the create quote screen like a confirmation box and the user shouldnt be able to Create the quote unless he checks it I added this line to the form EditeQuote knowing that this field has NO existence in the quote entity. or I should add it to the entity? Plus I want to force the user to check it. I want to do that in the Create Quote simple service I want to do that by adding this condition to the conditions already existing can anyone guide me what's the right way to do so? can I use if compare and if compare field or they work only for fields existing in the quote entity? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Checkbox-confirmation-tp2998649p2998649.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Advice wether to use workflow engine
I'll do that I'll have to get more involved in how statuses and changes are done my sources for now are mainly the code itself If anyone have a link or any other material that explains that more about the order that will help a lot during my search in the forum I found a link but the content was removed or smthing or even if anyone can recommend me a book -- View this message in context: http://ofbiz.135035.n4.nabble.com/Advice-wether-to-use-workflow-engine-tp2994955p2998202.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Advice wether to use workflow engine
BJ Freeman wrote: > > follow the change status you will have to customize. > you will have to add statuses and the roles and or permisission of the > people that can change statuses. > > there was a discussion on Workflow and xpdl on the mailing list in the > last 30 days. go the mailing list link from the main page and look for > archive, or you can use google to search for parameters like > ofbiz workflow xpdl > > Note about time, ofbiz takes years to learn, you may have to look for > someone experienced that you can consult with or contract out the work > you need done. > > >> Shereen sent the following on 10/14/2010 12:58 AM: >> I'm new to ofbiz developing just a week or so ago. >> I need to change the order flows and customize it. >> what's the best to use? workflow engine and using xpdl? or using eeca and >> seca? >> I have no experience in using workflows or xpdl so I'll have to learn >> them >> first and I dont have plenty of time >> I have made very simple examples using eeca and seca. >> I'll give more explanation about what I want to do >> For example I want the order to pass 2 approve stages not one I want the >> order to be approved by the accountant and then the manager. >> i.e I want to change in the stage of the order add new stages make some >> stage available only under certain condition. >> I read in documenation that eeca and seca are better is this true in my >> case >> or i'll have to study xpdl and workflows to do that? >> I'd be grateful for any help > > I'm very thankful for your reply and co operation I've done some search that's why I'm really worried about using workflow engine in my situation also I've noticed in the documentation some notice about the eeca and seca https://cwiki.apache.org/confluence/display/OFBADMIN/Apache+OFBiz+Project+Overview#ApacheOFBizProjectOverview-EDA In my case what do u advice me to do? try to fixmy problems using permissions, roles, eeca, seca and such things ? ond avoid the actual flow of order process or it's not right to do so ? I'm grateful again -- View this message in context: http://ofbiz.135035.n4.nabble.com/Advice-wether-to-use-workflow-engine-tp2994955p2995138.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Subscriptions
Any help about subscriptions guys? I just want to achieve the following scenario install magazines and articles as subscription and the use them in my order so that any customer can order them I realized subscriptions are not related to order then what I should do ? I just want the customer to ask for a monthly magazine instead of order product with the fixed selling price -- View this message in context: http://ofbiz.135035.n4.nabble.com/Subscriptions-tp2954212p2994980.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Advice wether to use workflow engine
I'm new to ofbiz developing just a week or so ago. I need to change the order flows and customize it. what's the best to use? workflow engine and using xpdl? or using eeca and seca? I have no experience in using workflows or xpdl so I'll have to learn them first and I dont have plenty of time I have made very simple examples using eeca and seca. I'll give more explanation about what I want to do For example I want the order to pass 2 approve stages not one I want the order to be approved by the accountant and then the manager. i.e I want to change in the stage of the order add new stages make some stage available only under certain condition. I read in documenation that eeca and seca are better is this true in my case or i'll have to study xpdl and workflows to do that? I'd be grateful for any help -- View this message in context: http://ofbiz.135035.n4.nabble.com/Advice-wether-to-use-workflow-engine-tp2994955p2994955.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Account and Lead assign to me
Also I've noticed that in leads the assign to me button appears and is not hidden in the My leads list why? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Account-and-Lead-assign-to-me-tp2994898p2994904.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Account and Lead assign to me
I have the following questions please BY default when a user login go and create an account in SFA the account is assigned to him automatically but this is not the case in Leads. why? this is a bug or something meant to be? What changes should I make in the service method of the creation of a lead if I want it to be assigned automatically to the person who created it? I need that because I want to make the sales man only sees his leads which should be automatically assigned to him when he creates them. The services of Create account and create lead are similar but not the same I found something I dun understand in the creation of the account should the value be ACCOUNT_OWNER instead of ACCOUNT? in creation of lead it's the second seems logic to me but the first behaves as I wish ( the account is automatically assigned) Can anyone guide me through this and advice me which changes should I make? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Account-and-Lead-assign-to-me-tp2994898p2994898.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Exception while implementing find screen
I'm thankful for any one who tried to help I figured out just by chance that I must name my list ListIT that's why the list iterator was not working -- View this message in context: http://ofbiz.135035.n4.nabble.com/Exception-while-implementing-find-screen-tp2991964p2992016.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Exception while implementing find screen
this is the stack trace if anyone can help Error closing the result, connection, etc in finalize SQLProcessor Exception: java.lang.NullPointerException Message: null stack trace --- java.lang.NullPointerException org.apache.commons.dbcp.managed.ManagedConnection.close(ManagedConnection.java:147) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:224) org.ofbiz.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:820) java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) java.lang.ref.Finalizer.access$100(Finalizer.java:14) java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) 2010-10-12 16:01:06,116 (Finalizer) [ EntityListIterator.java:543:ERROR] EntityListIterator Not Closed for Entity [LetterOfGuarantee], caught in Finalize -- View this message in context: http://ofbiz.135035.n4.nabble.com/Exception-while-implementing-find-screen-tp2991964p2991985.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Exception while implementing find screen
Hi all I want to implement my new module in accounting and I want the home page as the default page: 1- create new 2- search fields 3- list of search results while doing the search parts I faced the following exception: EntityListIterator Exception here's my list here's my find form this is the screen ${uiLabelMap.AccountingViewPermissionError} controller I want to just look like the agreement main screen -- View this message in context: http://ofbiz.135035.n4.nabble.com/Exception-while-implementing-find-screen-tp2991964p2991964.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Permissions
Hi all I want to make a little change in sfa and I'm wondering if anyone can help me I want ONLY the accounting manager to be able to view the the all accounts I don't want other sales persons to view all accounts first I commented the the part of code that includes the list of accounts in the default accounts page. I want to keep the find screen but only the sfa admin should be able to see it . can anyone please help me how to do that? I have only basic information about permissions and services with permissions -- View this message in context: http://ofbiz.135035.n4.nabble.com/Permissions-tp2991515p2991515.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can't install to MySQL 5 database
Would anyone please tell me the right to steps to use mysql database instead of derby? I know that I should change the entityengine.xml as exmply did what else should i do? also I have another question can I use external mysql server instead of localmysql? exmbly wrote: > > Hi, Mridul, > > I only made changes to the delegator and localmysql > datasource/inline-jdbc. > > Here's my delegators. I set things to localmysql datasourc and commented > out the olap stuff. I wasn't sure about the default-no-eca so I changed > that to localmysql datasource as well. Same for test. > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > > > > > > entity-group-reader="main" entity-eca-reader="main"> > > > > entity-group-reader="main" entity-eca-reader="main"> > datasource-name="localpostgres"/> > > > The only other change I made was to the localmysql datasource inline-jdbc > element to point to my instance of MySQL with my username and password. I > created the ofbiz schema in MySQL as well. > > jdbc-driver="com.mysql.jdbc.Driver" > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" > jdbc-username="" > jdbc-password="" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > > Do you think I did something wrong here? > > Thanks for your help. > > Glenn... > > Mridul Pathak-2 wrote: >> >> Can you please share your entityengine.xml file, there might be some >> problem >> in the configurations you have done. >> -- >> Thanks & Regards >> Mridul Pathak >> Hotwax Media >> http://www.hotwaxmedia.com >> mridul.pat...@hotwaxmedia.com >> >> On Wed, Sep 2, 2009 at 10:49 PM, exmbly wrote: >> >>> >>> I get the following error running ant run-install after changing to a >>> MySQL >>> 5 >>> database ( installing the jdbc driver and modifying entityengine.xml): >>> >>> [java] 2009-09-02 10:03:59,809 (main) [ ModelEntityChecker.java:501:INFO >>> ] >>> [initReservedWords] array length=1023 >>> [java] Exception in thread "main" java.lang.NullPointerException >>> [java] at >>> org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) >>> [java] at >>> >>> org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) >>> [java] at >>> org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) >>> [java] at >>> >>> org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) >>> [java] at >>> >>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) >>> [java] at >>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >>> [java] at >>> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >>> [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) >>> [java] at org.ofbiz.base.start.Start.start(Start.java:326) >>> [java] at org.ofbiz.base.start.Start.main(Start.java:409) >>> [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ >>> ContainerLoader.java:114:INFO ] Shutting down containers >>> [java] Java Result: 1 >>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >> >> > > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-install-to-MySQL-5-database-tp163486p2969472.html Sent from the OFBiz - User mailing list archive at Nabble.com.
CRUD using minilang
I'm trying to use the minilang to delete a record in an entity. I faced the following exception Error calling event: org.ofbiz.webapp.event.EventHandlerException: Found URL parameter [reviewId] passed to secure (https) request-map with uri [RemovePlanetReview] with an event that calls service [learningRemovePlanetReview]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at http://docs.ofbiz.org/x/r. Does anyone know what's this? I've done this experiment in release10.04 this is how I wrote the delete button in the form this is the service this is the request would anyone please tell what's going on? Am I going to face the same trouble in 10.04 ? Thanks in advance to anyone who can help -- View this message in context: http://ofbiz.135035.n4.nabble.com/CRUD-using-minilang-tp2966908p2966908.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Daily journals
if you excuse me I'll tell you what i've understood and correct me if I'm wrong. this feature isnt available in ofbiz curently and you advise me to make report containing the information. I don't understand the meaning of BIRT ?? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Daily-journals-tp2955515p2966678.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Daily journals
I'm expecting to see daily accounting transactions and debit and credit amounts of course the debit and credit accounts must be equal. for everyday there's a new daily journal -- View this message in context: http://ofbiz.135035.n4.nabble.com/Daily-journals-tp2955515p2966492.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Daily journals
Any help using the journals? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Daily-journals-tp2955515p2966390.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Daily journals
Hi all I want to use the accounting daily journals in ofbiz a journal where you enter your daily transactions. Is something like that available in ofbiz. I've found in the Organization accounting setup that we can implement a new journal and is this similar to what I'm talking about? what's the error journal and if I can create a new journal can I use it as my daily journal.by setting something that makes all transactions in everyday and show me the debit and credit amounts? Thanks in advance -- View this message in context: http://ofbiz.135035.n4.nabble.com/Daily-journals-tp2955515p2955515.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Subscriptions
Hi all I'm asking how can I handle subscriptions in the following way through ofbiz I want to handle subscriptions for magazines journals and such things for my customer. The subscription will contain the basic information like any subscription as dates and frequency and such things but I ant them to be kind of orders I want the subscription be approved and treated financially just as an order. I know there is a subscription module in catalog but it's not related to the order right? It doesnt follow the order's cycle. How can I manage subscription for magazines and journals from the users point of view ? Thanks a lot -- View this message in context: http://ofbiz.135035.n4.nabble.com/Subscriptions-tp2954212p2954212.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Users - Can any body of you update the new Freemarker Template jar file
I'm searching for a freemarker eclipse plugin it will help me a lot writing ftl but I duno from where do download it would anyone please tell me a link where i can download this jar.? I searched in some other forums and links the gave me are no longer available. I'm using eclipse galileo Thanks a lot -- View this message in context: http://ofbiz.135035.n4.nabble.com/Users-Can-any-body-of-you-update-the-new-Freemarker-Template-jar-file-tp139177p2954010.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Requests in the ecommerce website
Hi all I'm discovering the features in the ecommerce website. I logged using the account for demo customer I tried the button requests. it contains the requests of the DemoCustomer. Can the demo customer create a request for himself or this request is created from the back office only? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Requests-in-the-ecommerce-website-tp2718832p2718832.html Sent from the OFBiz - User mailing list archive at Nabble.com.