Re: From where we can add/update currencies and countries and list of ship costs.
Hi Sameer, You can set up the currency from general.properties, at ProductStore entity and partyAcctgPreference entity. Also look at the - Shipping <https://localhost:8443/catalog/control/EditProductStoreShipSetup?productStoreId=9000> - Shipping Estimates <https://localhost:8443/catalog/control/EditProductStoreShipmentCostEstimates?productStoreId=9000> To view the shipping costing. You can do further study based on your requirements. With regards, S K Pradeep Kumar, 9035009495 On Tue, Mar 5, 2024 at 1:12 AM Sameer Alwosaby wrote: > Hello Community, > > I am new to the apache ofbiz, From where we can add/update currencies and > countries and list of ship costs. Is there any setup or need to create > ofbiz Plugin. > > Thanks > Sameer alwosaby >
Re: Customizing the Ecommerce site
You can create a new theme. https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=47383935=true With regards, S K Pradeep Kumar, 9035009495 On Mon, Apr 10, 2023 at 8:29 AM Sebastian Naumann < sebastiandill1...@gmail.com> wrote: > Hi everyone, > > how would one customize the design of the front End outward facing store > Front? > > For starters, i want to just do some minor adjustments to the UI in terms > of colors, borders, etc. > > I'm planning on using the same bootstrap Version as currently loaded in the > HeaderHead.ftl File, so i dont break any of the classes. > > So my thought was: > > 1. Build my own Version of bootstrap from the SASS files. > 2. plug the reference to that into the Ftl file. > > Any thoughts on this or on General customizations? I'm trying to touch the > least amount of files as possible to get started, as I want to keep this > easily upgradable. > > Thanks for the help here as well. >
Re: Apache ofbiz integration with SAP
Hi Dinesh, If SAP supports REST API, you can write the REST API's in OFBiz and integrate. Recommended with Strong security. If SAP supports SOAP, then you can export the OFBiz services as SOAP and integrate. With regards, S K Pradeep Kumar, 9035009495 On Tue, Nov 24, 2020 at 3:55 PM Dinesh Kumar Viswanath wrote: > Is there any option for integrating Apache OfBiz with SAP. We are looking > for options to integrate with SAP modules from Apache OfBiz. >
Re: relation between OrderItem and OrderPaymentPreference at the time of refund
https://photos.app.goo.gl/E7qYA96gySQnpWpo7 On Wed, Sep 9, 2020, 12:44 PM Sameer Apte wrote: > Thanks for your reply S K Pradeep Kumar. > Will go through that . Struggling to see the screen shot though..could you > please send it again? I wonder if mailing list supports screenshots.. > Regards > Sameer Apte > > > On Wed, 9 Sep 2020, 06:12 S K Pradeep Kumar, > wrote: > > > Hi Sameer, > > > > OFBiz allows a partial refund with a payment selection. > > [image: Screenshot 2020-09-09 10-20-13.png] > > > > You can go through the same flow. > > Here are some of the entities that might help. > > OrderItemBilling > > Payment > > OrderPaymentPrefAndPayment (View) > > ReturnItemBilling > > InvoiceAndApplAndPayment(View) > > > > You can send OrderItemSeqId to > > createOrderPaymentPreference > > > > You can go through the services and entities. > > You just need an item level payment methods association. > > > > It can be achieved, with slight modifications. > > > > With regards, > > S K Pradeep Kumar, > > 9035009495 > > > > > > On Tue, Sep 8, 2020 at 4:28 PM Sameer Apte wrote: > > > >> Hi Team, > >> > >> I have a question around refund functionality. > >> Please consider below scenario: > >> *Given that * > >>*customer has 2 credit cards *referred to as CARD1 & CARD2 below. > >>customer has existing order O1 with two orderItems > >>(ITEM1 = 1 bag of banana) > >> *(ITEM2 = 1 bag of apples)* > >>customer has already made payment for above order (and therefore 2 > >> orderItems) using *CARD1* > >> > >> *When* customer edits the order prior to fulfilment and adds (ITEM3 = 1 > >> bag > >> of grapes) > >> *THEN* customer would be redirected to payment gateway for > additional > >> payment for grapes > >> * AND* customer uses the *CARD2 for paying for grapes* > >> > >> This scenario seems to be working as expected and I have noticed that by > >> the end of it we get 2 records in OrderPaymentPreference table 1 for > each > >> card. > >> > >> Now comes the actual question around refund. > >> > >> When a customer tries to edit the above order prior to fulfilment and > >> removes apples > >> then ideally we should be refunding using CARD1. > >> > >> However as I am not seeing an actual link between orderPaymentPreference > >> with OrderItems, I am not sure how ofbiz can decide which card should be > >> picked up for refund. > >> In the pdf - that shows the entities, it is shown that > >> OrderPaymentPrefernce table has column OrderItemSeqId, but it seems > ofbiz > >> is not populating it anyways. > >> > >> So could you please advise or provide some pointers to which ofbiz > >> services/ entities could be used to make sure that the correct card is > >> picked up for refunding? > >> > >> Scenario becomes interesting when the customer increases the quantity of > >> existing items E.g. in the example above, if customer adds 1 more bag of > >> apples and then uses CARD2 for making that payment and subsequently > tries > >> to cancel the apples altogether. In which case refund should be done > using > >> CARD1 and CARD2 both... :-) > >> > >> Essentially I am trying to make sure that if a customer has made 2 > >> payments > >> using 2 cards, then when it comes to partial refund due to changes to > >> order, ofbiz should not be refunding more to any of the cards than what > >> was > >> paid using that card by the customer. > >> > >> Regards, > >> Sameer Apte > >> > > >
Re: relation between OrderItem and OrderPaymentPreference at the time of refund
Hi Sameer, OFBiz allows a partial refund with a payment selection. [image: Screenshot 2020-09-09 10-20-13.png] You can go through the same flow. Here are some of the entities that might help. OrderItemBilling Payment OrderPaymentPrefAndPayment (View) ReturnItemBilling InvoiceAndApplAndPayment(View) You can send OrderItemSeqId to createOrderPaymentPreference You can go through the services and entities. You just need an item level payment methods association. It can be achieved, with slight modifications. With regards, S K Pradeep Kumar, 9035009495 On Tue, Sep 8, 2020 at 4:28 PM Sameer Apte wrote: > Hi Team, > > I have a question around refund functionality. > Please consider below scenario: > *Given that * >*customer has 2 credit cards *referred to as CARD1 & CARD2 below. >customer has existing order O1 with two orderItems >(ITEM1 = 1 bag of banana) > *(ITEM2 = 1 bag of apples)* >customer has already made payment for above order (and therefore 2 > orderItems) using *CARD1* > > *When* customer edits the order prior to fulfilment and adds (ITEM3 = 1 bag > of grapes) > *THEN* customer would be redirected to payment gateway for additional > payment for grapes > * AND* customer uses the *CARD2 for paying for grapes* > > This scenario seems to be working as expected and I have noticed that by > the end of it we get 2 records in OrderPaymentPreference table 1 for each > card. > > Now comes the actual question around refund. > > When a customer tries to edit the above order prior to fulfilment and > removes apples > then ideally we should be refunding using CARD1. > > However as I am not seeing an actual link between orderPaymentPreference > with OrderItems, I am not sure how ofbiz can decide which card should be > picked up for refund. > In the pdf - that shows the entities, it is shown that > OrderPaymentPrefernce table has column OrderItemSeqId, but it seems ofbiz > is not populating it anyways. > > So could you please advise or provide some pointers to which ofbiz > services/ entities could be used to make sure that the correct card is > picked up for refunding? > > Scenario becomes interesting when the customer increases the quantity of > existing items E.g. in the example above, if customer adds 1 more bag of > apples and then uses CARD2 for making that payment and subsequently tries > to cancel the apples altogether. In which case refund should be done using > CARD1 and CARD2 both... :-) > > Essentially I am trying to make sure that if a customer has made 2 payments > using 2 cards, then when it comes to partial refund due to changes to > order, ofbiz should not be refunding more to any of the cards than what was > paid using that card by the customer. > > Regards, > Sameer Apte >
Re: Edit Order
Hi Sameer, Yes, OFBiz provides Order Edit : - Add or Remove the items from the order. Also, update adjustments. Cancel Order : Is already there. With regards, S K Pradeep Kumar, 9035009495 On Tue, Aug 18, 2020 at 3:54 PM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > Dear friends, > > I wish to know if Ofbiz eCommerce shop offers the order edit and order > cancel functionality after the order is successfully paid and submitted by > the customer. > > Example: customer successfully places the order and subsequently wishes to > edit the ordered items / cancel the order. > > Regards, > Shrilesh K. >
Re: [TUTORIAL] APACHE OFBIZ INSTALL ON WINDOWS 10
https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+install+OFBiz+with+the+Demo+Data With regards, S K Pradeep Kumar, 9035009495 On Sun, Jul 5, 2020 at 10:00 PM John The wrote: > Hi Support, > > > > Do you have tutorial for installation Apache OfBiz on Windows 10 OS? > > Thank you. > > > > *Regards,* > > > > > > > > *John The* > > > > [image: TrustLogoT2] > > *CV. TRUST TECHNOLOGY* > > *Kompleks Cemara Hijau Blok R24* > > *Desa Sampali, Percut Sei. Tuan* > > *Deli Serdang – 20371* > > *Sumatera Utara – Indonesia* > > *Telp. +62-811-650-1126* > > *Fax. +62-61-6639283* > > *WA/HP. +62-819-88-3425* > > www.trust-technology.co.id > > >
Re: Invoice Item Type
Hi James, Amazon $15 is a commission for product listing, so, you can use the commission feature in the ofbiz. Look at commission run : https://demo-stable.ofbiz.apache.org/ap/control/CommissionRun Remaining everything is going as its. Just link the commission invoice with actual order invoiceId as parent Id. With regards, S K Pradeep Kumar, 9035009495 On Mon, Oct 14, 2019 at 11:19 PM wrote: > Good Day. We are trying to determine if Invoice Item Type can be used > for processing Amazon orders in Ofbiz. > Here is the scenario > > Customer purchases product on amazon.com for a total of $100. > We process the order from amazon but we have to account for amazon fees > of $15 > So we want to show the order subtotal of $100 Amazon fees as new invoice > item type of -$15 (similar to how discounts work) > Total Order is $85. > > When Amazon sends us the payment it will be for $85 and we can process > the $85 to close out the invoice. > > Question. How can we add an additional invoice item type called Amazon > Fees? How can we trigger it to be added on the sales order? > > Thanks, > > James >
Re: Invoice Numbering Sequence
Check this table "sequence_value_item" With regards, S K Pradeep Kumar, 9035009495 On Wed, Apr 10, 2019 at 1:40 AM wrote: > Where in Ofbiz can you change the invoice numbering sequence? We do not > want to use invoice numbers that have already been used in our old > system. Is there somewhere to input starting numbers for invoice and > sales order. > > Thanks, > > James >
Re: Order creation using webservices
Check this org\ofbiz\order\test\SalesOrderTest.java With regards, S K Pradeep Kumar, 9035009495 On Wed, May 9, 2018 at 9:41 PM, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > Hi , > > I am working on an custom application that interacts with OFBiz > using webservices solely. I am able to do quite a lot using this approach > and now its time to create the orders in OFBiz system. > > I am able to create the orders using the OOTB interface and using the > resources that are created using the Webservices interface. > > Since order creation is a relatively complex process affecting too many > entities and too many UI screens on OOTB i am bit lost about the > proper approach. > > Since the custom UI that i am creating for the enduser has limited > flexibility the parameters for order creation are in strict control , hence > i am looking for at least one pathway that shall lead to a successful > order creation. Eg there is only one payment choice and only one > shipping method to simplify the process. > > suggestions are solicited. > > regds > mallah. >
Re: UPS/Fed Integration
http://shop.opentaps.org/index.php/featured/opentaps-ofbiz-fedex-integration-module.html With regards, S K Pradeep Kumar, 9035009495 On Fri, Apr 20, 2018 at 10:02 PM, <ja...@productive1.com> wrote: > Does the OTB integration with Fedex and UPS include UPS Freight and > Fedex Freight? > > Thanks, > > James >
Re: Amazon/eBay Integration??
http://shop.opentaps.org/index.php/opentaps-amazon-mws-integration-module.html http://www.opentaps.org/docs/index.php/Amazon_Integration With regards, S K Pradeep Kumar, 9035009495 On Mon, Feb 19, 2018 at 7:51 PM, Rishi Solanki <rishisolan...@gmail.com> wrote: > James, > > Please check the ebay and ebaystore plugins to get the idea about ebay > integration. OFBiz have very basic support and you may need to enhance as > per your custom need. > > - http://svn.apache.org/repos/asf/ofbiz/ofbiz-plugins/trunk/ebay/ > - http://svn.apache.org/repos/asf/ofbiz/ofbiz-plugins/trunk/ebaystore/ > > There is no OOTB support for Amazon Integration. > > HTH! > > > > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > On Mon, Feb 19, 2018 at 7:35 PM, <ja...@productive1.com> wrote: > > > > > Is there an Amazon and/or Ebay integration available for Ofbiz or > > Opentaps? > > >
Re: Export CSV
Hi Ahmad, I think, its nothing to do with OFBiz. You need to add the language support to your Excel https://support.office.com/en-us/article/Enable-or-change-a-keyboard-layout-language-1C2242C0-FE15-4BC3-99BC-535DE6F4F258 With regards, S K Pradeep Kumar, 9035009495 On Sun, Jan 14, 2018 at 4:34 PM, Ahmad Al ajarmeh <aalajar...@bi-bst.com> wrote: > Hello dears , > > I use version 16.11.1 , I need solve for my problem, When I export to > CSV file the excel don’t read Arabic words, > > And handle it like this : “ §ظ„ط±ط§طھط¨ ط§ظ„ط§ط³ط§ط³ظٹ ”. > > What can I do in this case ? > > > > *Best Regards,* > > > > Ahmad Alajarmeh > > Java Developer > > > > [image: Description: Logo for Office-4] > > > > [image: Description: bi email-3-02] > > > > P.O.Box 3516 Amman, 11821 > > The Hashemite Kingdom of Jordan > > *Tel.* +962 (6) 556 2620 > > *Mob (Jordan).* +962 78 836 5695 > > [image: Description: bi email-3-04] > > [image: Description: bi email-3-05] > > /biict > > @biict > > > > >
Re: Loans
Check with FinAccount, virtual currency. With regards, S K Pradeep Kumar, 9035009495 On Sun, Mar 12, 2017 at 6:48 PM, Bahaa Alamood < balam...@arcdigitalsolutionsandconsultancy.com> wrote: > Hello all, > > We have a situation where the business borrow money from the investors and > then the business returns the money to the investors when the project they > helped financing is done. How can I input this in ofbiz in a way such that > this money shows up in the reports? > > > -- > Bahaaldin Al-amood > IQ Tel: +964 (0) 780 926 2103 > US tel: 540 632 1388 > email: ba...@arcdsc.com > Skype ID: bahaa.alamood > > Arc Digital Solutions and Consultancy > www.arcdsc.com > > This message contains information that may be confidential > and privileged to Arc digital Solutions and Consultancy, its partners, or > customers. > Unauthorized use is strictly prohibited. Unless you are the > addressee (or authorized to receive mail for the addressee), > you should not use, copy or disclose to anyone this message > or any information contained in this message. If you have > received this message in error, please so advise the sender > by reply e-mail and delete this message. Thank you for your > cooperation. > >
Re: OFBiz intrgration with CAS/LDAP
Also framework\common\webcommon\WEB-INF\common-controller.xml With regards, S K Pradeep Kumar, 9035009495 On Tue, Feb 23, 2016 at 6:00 PM, S K Pradeep Kumar < s.k.pradeepku...@gmail.com> wrote: > Hi Vivek, > > Please go through following properties in security.properties , you will > get idea. > > # -- Use LDAP for user authentication? -- > security.ldap.enable=false > > # -- Fail login if LDAP authentication fails? -- > security.ldap.fail.login=false > > # -- should we allow x509 certificate login > security.login.cert.allow=true > > # -- HTTP header based ID (for integrations; uncomment to enable) > #security.login.http.header=REMOTE_USER > > With regards, > S K Pradeep Kumar, > 9035009495 > > On Tue, Feb 23, 2016 at 1:40 PM, vivek.mi <vmvivek...@gmail.com> wrote: > >> Hello everyone, >> >> I want to integrate ofbiz to cas/ldap server. I want to know how can it be >> done in ofbiz, is there any integration done already? >> >> >> Thanks & regards, >> Vivek Mishra >> >> >> >> - >> Vivek Mishra >> -- >> View this message in context: >> http://ofbiz.135035.n4.nabble.com/OFBiz-intrgration-with-CAS-LDAP-tp4677438.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > >
Re: OFBiz intrgration with CAS/LDAP
Hi Vivek, Please go through following properties in security.properties , you will get idea. # -- Use LDAP for user authentication? -- security.ldap.enable=false # -- Fail login if LDAP authentication fails? -- security.ldap.fail.login=false # -- should we allow x509 certificate login security.login.cert.allow=true # -- HTTP header based ID (for integrations; uncomment to enable) #security.login.http.header=REMOTE_USER With regards, S K Pradeep Kumar, 9035009495 On Tue, Feb 23, 2016 at 1:40 PM, vivek.mi <vmvivek...@gmail.com> wrote: > Hello everyone, > > I want to integrate ofbiz to cas/ldap server. I want to know how can it be > done in ofbiz, is there any integration done already? > > > Thanks & regards, > Vivek Mishra > > > > - > Vivek Mishra > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/OFBiz-intrgration-with-CAS-LDAP-tp4677438.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: OFBiz and Kafka integration
Hi Adrian, I found the jms integration with ActivMQ https://www.ecomify.de/blog/apache-ofbiz-esb-integration-per-jms-398/ With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Wed, Oct 7, 2015 at 11:04 PM, Adrian Crum < adrian.c...@sandglass-software.com> wrote: > have you looked at JMS? OFBiz includes a JMS integration. > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > On 10/7/2015 10:19 AM, S K Pradeep Kumar wrote: > >> Hi Adrian, >> >> This is required for the data exchange between 2 systems. >> >> Basically, we are taking user and product data from other system. >> >> With regards, >> Pradeep Kumar >> >> With regards, >> S K Pradeep Kumar, >> 9035009495 >> >> On Wed, Oct 7, 2015 at 6:54 PM, Adrian Crum < >> adrian.c...@sandglass-software.com> wrote: >> >> Why is the integration necessary? What is the use case? >>> >>> Adrian Crum >>> Sandglass Software >>> www.sandglass-software.com >>> >>> >>> On 10/7/2015 3:48 AM, S K Pradeep Kumar wrote: >>> >>> Hi All, >>>> >>>> Is there any one integrated OFBiz with Apache Kafka? >>>> >>>> What would be the best approach for this? >>>> >>>> With regards, >>>> Pradeep Kumar >>>> >>>> >>>> >>
OFBiz and Kafka integration
Hi All, Is there any one integrated OFBiz with Apache Kafka? What would be the best approach for this? With regards, Pradeep Kumar
Re: OFBiz and Kafka integration
Hi Adrian, This is required for the data exchange between 2 systems. Basically, we are taking user and product data from other system. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Wed, Oct 7, 2015 at 6:54 PM, Adrian Crum < adrian.c...@sandglass-software.com> wrote: > Why is the integration necessary? What is the use case? > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > > On 10/7/2015 3:48 AM, S K Pradeep Kumar wrote: > >> Hi All, >> >> Is there any one integrated OFBiz with Apache Kafka? >> >> What would be the best approach for this? >> >> With regards, >> Pradeep Kumar >> >>
Re: Ofbiz Integration with other J2EE based ERPs
Hi Somaya, Yes, its possible. Whichever the service you want to integrate just export as SOAP service and call them from your ERP system. export=true is the attribute need to be set in services*.xml file for the corresponding service. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Wed, Aug 5, 2015 at 1:41 PM, Somaya Aboulwafa somaya.w...@gmail.com wrote: Dear all, Where in the documentation can I find the integration facilities/ methods/ interfaces that ofbiz provides with other J2EE based business solutions. We have our own ERP solution and we want to see the possibility of integrating it with the Financial Accounting and management component of Ofbiz. is this possible? are there any technical documentation about this?? -- Thank you, Somaya Aboulwafa
OFBiz session between load balancer
Hi All, What is the modification we need to do for the OFBiz application to manage the session between 2 server hosted on Amazon Elastic load Balancer. With regards, Pradeep
Re: POS
Hi Mariano, I was able to do it. Just need to load XuiScreen twice in XuiContainer and send appropriate parameter as per your requirement. JFrame jframe = new JFrame(); jframe.setUndecorated(true); new XuiScreen( new String[] { this.startupDir + this.startupFile, classPackageName}, jframe); //Code for second screen JFrame jframe1 = new JFrame(); jframe1.setUndecorated(true); new XuiScreen(new String[] { specialpurpose/pos/config/xpos1.properties,classPackageName}, jframe1); With regards, S K Pradeep Kumar, 9035009495 On Wed, Aug 13, 2014 at 6:34 AM, Mariano M mariano.ma...@gmail.com wrote: Pradeep, Have you find the answer to this? Have you implemented this? Thank you, Mariano -- View this message in context: http://ofbiz.135035.n4.nabble.com/POS-tp4641941p4653429.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Suitability of OfBiz for our upcoming project
Hi Andrew, OFBiz support REST implementation : https://cwiki.apache.org/confluence/display/OFBIZ/Export+service+using+REST Using ofbis rest we have implemented complete eCommerce part : http://www.petbest.com And Here is the feature list : https://cwiki.apache.org/confluence/display/OFBIZ/Feature+summary With regards, S K Pradeep Kumar, 9035009495 On Thu, May 22, 2014 at 10:16 AM, Andrew Hine andrew.h...@touchcorp.com wrote: Hi, We are considering using OfBiz for our upcoming project. We require a sophisticated (i.e with complex nested product categories, multiple prices, promotions, discount vouchers, images e.t.c) product management system. In addition we also require custom after sale receipt documents to be issued to the customer, potentially different for every product. All of the above needs to be maintainable via an admin GUI interface with access control, version control e.t.c. We are selling electronic products, so after the shopping cart is submitted, the system needs to talk to our back end services to generate and supply the product, providing any custom links / access codes to the custom after sales receipt document. We don't require a web based front end but require a restful API interface. Is OfBiz able to provide this functionality out of the box? Would much custom development be required? Thanks, Andrew This email and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. This email may contain personal information of individuals, and be subject to Commonwealth and/or State privacy laws in Australia. This email is also subject to copyright. If you are not the intended recipient, you must not read, print, store, copy, forward or use this email for any reason, in accordance with privacy and copyright laws. If you have received this email in error, please notify the sender by return email, and delete this email from your inbox.
Re: Suitability of OfBiz for our upcoming project
Hi Paul, Yes, Its using complete ofbiz eCommerce related components (Order, facility, party, catalog, accounting) for its operations. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Fri, May 30, 2014 at 5:34 PM, Paul Mandeltort p...@marcospec.com wrote: Pradeep, petbest.com is very well done. Good job! Does the company utilize any of the backend components of ofbiz for fulfillment, catalog, accounting, etc? --Paul -- Paul Mandeltort | Marco Specialties Inc +1-512-394-8119 | p...@marcospec.com On May 30, 2014, at 5:19 AM, S K Pradeep Kumar s.k.pradeepku...@gmail.com wrote: Hi Andrew, OFBiz support REST implementation : https://cwiki.apache.org/confluence/display/OFBIZ/Export+service+using+REST Using ofbis rest we have implemented complete eCommerce part : http://www.petbest.com And Here is the feature list : https://cwiki.apache.org/confluence/display/OFBIZ/Feature+summary With regards, S K Pradeep Kumar, 9035009495 On Thu, May 22, 2014 at 10:16 AM, Andrew Hine andrew.h...@touchcorp.com wrote: Hi, We are considering using OfBiz for our upcoming project. We require a sophisticated (i.e with complex nested product categories, multiple prices, promotions, discount vouchers, images e.t.c) product management system. In addition we also require custom after sale receipt documents to be issued to the customer, potentially different for every product. All of the above needs to be maintainable via an admin GUI interface with access control, version control e.t.c. We are selling electronic products, so after the shopping cart is submitted, the system needs to talk to our back end services to generate and supply the product, providing any custom links / access codes to the custom after sales receipt document. We don't require a web based front end but require a restful API interface. Is OfBiz able to provide this functionality out of the box? Would much custom development be required? Thanks, Andrew This email and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. This email may contain personal information of individuals, and be subject to Commonwealth and/or State privacy laws in Australia. This email is also subject to copyright. If you are not the intended recipient, you must not read, print, store, copy, forward or use this email for any reason, in accordance with privacy and copyright laws. If you have received this email in error, please notify the sender by return email, and delete this email from your inbox.
Re: Ofbiz CSS
Yes, It supports. With regards, S K Pradeep Kumar, 9035009495 On Wed, May 21, 2014 at 9:03 AM, Eric Halim e...@ppu.co.id wrote: Does Ofbiz CSS support something like saas or lesscss?
Re: Ofbiz Component on different server
Hi Robert, You can use the ofbiz inbuilt blogs and can be run on the same server with same domain name. With regards, Pradeep kumar With regards, S K Pradeep Kumar, 9035009495 On Tue, May 20, 2014 at 1:11 PM, Robert Gan g...@mercon24.de wrote: Hey guys, I have ofbiz running on a single server. Now I thought about creating multiple blogs with ofbiz. Is it possible to run each blog with its own server with its own domain name? If yes, which are the steps to achieve that? greetings robert -- View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz-Component-on-different-server-tp4651104.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Deadlock issue with OFBiz tranactions
Thanks Adrian Crum, Scott. Yes, we are refactoring the GlAccountOrganization related services. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Mon, May 19, 2014 at 6:44 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: GlAccountOrganization looks like it could be contentious for locks due to the postedBalance field (lots of separate long running transactions trying to update multiple rows at the same time). The service updating it probably needs refactoring so that the update is moved to a smaller transaction that executes after the main one has committed successfully. Regards Scott On 17/05/2014, at 3:46 pm, Adrian Crum adrian.c...@sandglass-software.com wrote: Deadlock issues are hard to reproduce because they are usually timing dependent. If your issue is easily reproducible, then most likely it is caused by an action (SECA) trying to change data that is being iterated over by another action (the service invoking the SECA). Look through the stack trace and see if there is a situation where the EntityListIterator is being used, and during iteration another service tries to change the table being iterated over. If yes, then the EntityListIterator needs to be converted to a java.util.List. Adrian Crum Sandglass Software www.sandglass-software.com On 5/7/2014 11:47 AM, S K Pradeep Kumar wrote: Hi All, What might be the possible reason for this issue : This issue starts only when we have the separate servers for Database and Application. but this issue is not coming on the single server. We have deployed the application on Amazon EC2 servers. Application is deployed on : EC2 Medium instance with 3.75 GB RAM MySql Database is on : EC2 Medium instance with 3.75 GB RAM 2014-05-07 19:36:54,593 (TP-Processor107) [ CallService.java:333:ERROR] exception report -- Exception: java.lang.Exception Message: Error: ERROR: Could not complete the Update GlAccountOrganization [file:/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#updateGlAccountOrganization] process [problem storing the lookedUpValue value: Error while updating: [GenericEntity:GlAccountOrganization][createdStamp,2013-08-19 12:32:25.0(java.sql.Timestamp)][createdTxStamp,2013-08-19 12:32:25.0(java.sql.Timestamp)][fromDate,2001-01-01 00:00:00.0(java.sql.Timestamp)][glAccountId,214000(java.lang.String)][lastUpdatedStamp,2014-05-07 19:36:54.579(java.sql.Timestamp)][lastUpdatedTxStamp,2014-05-07 19:36:54.334(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][postedBalance,701133.69(java.math.BigDecimal)][roleTypeId,null()][thruDate,null()] (SQL Exception while executing the following:UPDATE GL_ACCOUNT_ORGANIZATION SET ROLE_TYPE_ID=?, FROM_DATE=?, THRU_DATE=?, POSTED_BALANCE=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE GL_ACCOUNT_ID=? AND ORGANIZATION_PARTY_ID=? (Deadlock found when trying to get lock; try restarting transaction))] calling service updateGlAccountOrganization in postAcctgTrans stack trace --- java.lang.Exception: Error: ERROR: Could not complete the Update GlAccountOrganization [file:/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#updateGlAccountOrganization] process [problem storing the lookedUpValue value: Error while updating: [GenericEntity:GlAccountOrganization][createdStamp,2013-08-19 12:32:25.0(java.sql.Timestamp)][createdTxStamp,2013-08-19 12:32:25.0(java.sql.Timestamp)][fromDate,2001-01-01 00:00:00.0(java.sql.Timestamp)][glAccountId,214000(java.lang.String)][lastUpdatedStamp,2014-05-07 19:36:54.579(java.sql.Timestamp)][lastUpdatedTxStamp,2014-05-07 19:36:54.334(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][postedBalance,701133.69(java.math.BigDecimal)][roleTypeId,null()][thruDate,null()] (SQL Exception while executing the following:UPDATE GL_ACCOUNT_ORGANIZATION SET ROLE_TYPE_ID=?, FROM_DATE=?, THRU_DATE=?, POSTED_BALANCE=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE GL_ACCOUNT_ID=? AND ORGANIZATION_PARTY_ID=? (Deadlock found when trying to get lock; try restarting transaction))] calling service updateGlAccountOrganization in postAcctgTrans org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:333) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920) org.ofbiz.minilang.method.envops.Iterate.exec(Iterate.java:118) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920) org.ofbiz.minilang.method.ifops.IfCompare.exec(IfCompare.java:135) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:739
Re: Ofbiz Component on different server
Yes you can do that, just keep the blog and its related components (i.e. Content, party ...etc. ) and create one light weight ofbiz and deploy in another server. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Tue, May 20, 2014 at 3:55 PM, Robert Gan g...@mercon24.de wrote: Hey thanks for your message. I know that. BUt I want them on different server, because I want different IP addresses and different domain names. I want to manage all blogs from one main source / System, I dont want to deploy the complete ofbiz to each server for each blog... So I want one Server for hosting ofbiz and other server's who host the blog applications which shall be connected to the main server. is that possible? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz-Component-on-different-server-tp4651104p465.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Deadlock issue with OFBiz tranactions
(SimpleMethod.java:160) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53) org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) _$gen.file_58$.youmart.youmart_95$v3.trunk.applications.accounting.servicedef.services_95$ledger_46$xml_35$createAcctgTransForShipmentReceipt.runSync(file:/youmart/youmart_v3/trunk/applications/accounting/servicedef/services_ledger.xml#createAcctgTransForShipmentReceipt:357) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:138) org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:151) org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:162) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:500) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:177) org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:247) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920) org.ofbiz.minilang.method.envops.Loop.exec(Loop.java:82) org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920) org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:739) org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160) org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142) org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78) org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53) org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) _$gen.file_58$.youmart.youmart_95$v3.trunk.applications.product.servicedef.services_95$shipment_46$xml_35$receiveInventoryProduct.runSync(file:/youmart/youmart_v3/trunk/applications/product/servicedef/services_shipment.xml#receiveInventoryProduct:775) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:163) org.ofbiz.order.shoppinglist.ShoppingListEvents.dailyUpload(ShoppingListEvents.java:1423) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:92) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:78) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:642) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:388) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:226) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:89) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:339) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619) With regards, S K Pradeep Kumar, 9035009495
Pickup from store option
Hi All, We have multi retail store client with eCommerce website. Client wants his customer to order from eCommerce website and pick it from the selected retail store. What is the best solution to do this. With regards, S K Pradeep Kumar, 9035009495
Re: server_hit and visit table growing very large
YOu can stop storing the data, Here is the configuration. framework\webapp\config\serverstats.properties With regards, S K Pradeep Kumar, 9035009495 On Thu, Dec 5, 2013 at 4:01 PM, Deepak Agarwal dagarwa...@gmail.com wrote: Our server_hit and visit table has crossed 100 GB individually. I tried moving them to a separate entitygroup but in vain because it is coupled with few other entities like party, content. What would the best way to manage it. We surely don't want this data to be resided on the db where we have our customers and orders data. Also, these hits are important to us so I can't really off them from serverstats properties file. -- Thanks, Deepak Agarwal, Mobile: +91 9501190044
Re: Deployment on the web freehostia.com
Hi Antony, Apache server is optional for ofbiz deployment. if you have mysql dbms is enough. Even we can run the ofbiz with Amazon EC2 m1.small instance. With regards, S K Pradeep Kumar, 9035009495 On Thu, Nov 14, 2013 at 7:29 PM, Antony Adopo saius...@gmail.com wrote: OK thanks, But for hosting: the hoster (free hostia for instance) must have a apache server or no? or it depends only of dbms that he provides? And also, with your personnal experience, could you advise me a special hoster for ofbiz ecommerce web site? I don't need powerfil capacities for moment (i'm still in development stage) Thanks 2013/11/14 Jacques Le Roux jacques.le.r...@les7arts.com Apart https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Documentation+Index#OFBizDocumentationIndex-ConfigurationDocuments you might find useful the Apache HTTPD (Apache Web server) section of https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo Other that that we have no specific documentation on deploying OFBiz. You will have to refer to external documentation. I recommend to use Postgres as DBMS Jacques On Wednesday, November 13, 2013 11:14 PM Antony Adopo saius...@gmail.com wrote: Hello, ofbizers. please, could someone could describe me guideline to deploy my ofbiz website on internet. I use http://www.freehostia.com to do it. I worked all the time in my own computer and derby data base. and now I have to deploy on the previous link. but i don't know how. I can also use others others you know thanks PS: it is my fist time to deploy a first site
Re: Autoresponder for marketing
I think this might help you : http://www.getresponse.com/ http://shop.opentaps.org/index.php/featured/getresponse-email-marketing-integration-module.html With regards, S K Pradeep Kumar, 9035009495 On Fri, Oct 25, 2013 at 8:19 PM, Imac edsay...@hotmail.com wrote: Hi all, Needed to know if there was an autoresponder capability OOTB and also bounced mail support. I have been going over the demo for about a month now and have come to the conclusion that Ofbiz would most likely fit my needs OOTB with minor modifications (mostly on the commerce site itself), if the campaign (communications) features would work the way I need. My site will be primarily a lead generation site with ecommerce in the near future. Along with that I will also be running a services biz which will focus heavily on customer relations and events/speaking engagements and training sessions. I know Ofbiz might be overkill for this but I feel better safe than sorry for the future. One other thing would be content/site management and if I'm not mistaken, from what I've seen it should do ok for what I need. If anyone has any suggestions or comments as to what I would like to do, they would be much appreciated. Also, I am very willing to contribute back any work that I do with Ofbiz in exchange for your patience and help along the way. I'm going to need it! Thanks in advance Ed
Re: Autoresponder for marketing
You can use any opentaps OOTB component in ofbiz With regards, S K Pradeep Kumar, 9035009495 On Fri, Oct 25, 2013 at 11:10 PM, Imac edsay...@hotmail.com wrote: Thanks for that Pradeep. However, I was looking for something self hosted and AIO and I'm not sure opentaps would be the way to go for me. Also, it isn't very reassuring to see the opentaps ecommerce site using magento for the storefront! On 10/25/13 7:21 PM, S K Pradeep Kumar s.k.pradeepku...@gmail.com wrote: I think this might help you : http://www.getresponse.com/ http://shop.opentaps.org/index.php/featured/getresponse-email-marketing-in tegration-module.html With regards, S K Pradeep Kumar, 9035009495 On Fri, Oct 25, 2013 at 8:19 PM, Imac edsay...@hotmail.com wrote: Hi all, Needed to know if there was an autoresponder capability OOTB and also bounced mail support. I have been going over the demo for about a month now and have come to the conclusion that Ofbiz would most likely fit my needs OOTB with minor modifications (mostly on the commerce site itself), if the campaign (communications) features would work the way I need. My site will be primarily a lead generation site with ecommerce in the near future. Along with that I will also be running a services biz which will focus heavily on customer relations and events/speaking engagements and training sessions. I know Ofbiz might be overkill for this but I feel better safe than sorry for the future. One other thing would be content/site management and if I'm not mistaken, from what I've seen it should do ok for what I need. If anyone has any suggestions or comments as to what I would like to do, they would be much appreciated. Also, I am very willing to contribute back any work that I do with Ofbiz in exchange for your patience and help along the way. I'm going to need it! Thanks in advance Ed
Re: Loyalty Program / FinAccount payment
Hi Greg, As of now store credit is used for Order Return. For better clarity you go through the Return process once. And have look at Customer profile. Also 1. Store credit is maintained as FinAccount only. 2. If some FinAccount is created for customer as store credit, then it is automatically listed in the list of payment options customer can pick the option. for this you need to go through Quick checkout 3. System will take care the currency, if your using multiple currency then some slight modification might be needed. 4. createOrder/processPayment will take care the FinAccount as payment method. 5. Follow the same flow and create your own finAccountTypeId for loyalty program, that would be better. Because existing STORE_CREDIT_ACCT is used by the order return. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Fri, Jul 19, 2013 at 2:16 PM, greg jocher g...@jocher.ch wrote: Hi Thank you for your input - can you give me some more details? Currently we have the following setup: - each customers owns a finaccount, type loyalty program - each point credit/debit has a assosiated transaction - productStore uses the paymentsettings of methodtype fin_account (from the demodata) - productStore has fin_account settings for the loyalty point account - we add the paymentinfo (finaccount, finaccountid, amount) to the shoppingCart before createOrder But now, i am stuck. 1. do we have to add this finaccount paymentinfo manually (like we do so) 2. do we have to add the correct amount? (grandtotal - amount = 0) cause of no cash error 3. do we really have to convert the amount into the right currency? 4. will the processPayment or createOrder create a fin_account transaction? 5. is there something missing or totally wrong in our setup? best regards greg On 07/18/2013 06:53 PM, S K Pradeep Kumar wrote: You can use the store credit. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Thu, Jul 18, 2013 at 9:29 PM, greg jocher g...@jocher.ch wrote: Hi all We have to add a Loyalty program based on FinAccounts(?) to our ecommerce: The customer earns points based on the order subtotal, a promotion or something. These points should be used/debited on future order(s). We tried to add both payment methods (selected + fin_account) to the cart, but only the selected one will be used. Is there a way to add a second payment method? Regards Greg
Re: Loyalty Program / FinAccount payment
You can use the store credit. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Thu, Jul 18, 2013 at 9:29 PM, greg jocher g...@jocher.ch wrote: Hi all We have to add a Loyalty program based on FinAccounts(?) to our ecommerce: The customer earns points based on the order subtotal, a promotion or something. These points should be used/debited on future order(s). We tried to add both payment methods (selected + fin_account) to the cart, but only the selected one will be used. Is there a way to add a second payment method? Regards Greg
Re: Ecommerce ship to a party or partygroup address
I think this helps you : party_profile_default With regards S K Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Fri, Jul 12, 2013 at 2:59 PM, greg jocher g...@jocher.ch wrote: Hi All We are working on a custom checkout implementation and are stuck at the address setup. Our customers use many different adresses: - Home address - Work address - Thirdparty address - Thirdparty work address Each customer has a default (general or shipping/billing) address. We could not find an easy way to add and link these addresses in ofbiz without loosing information and duplicating content. Example with a thirdparty work address: We have to ship the order of customer Marge Simpson to a thirdparty work address: Company FOO - PartyGroup (groupName) Homer Jay Simpson - Person/Party (firstName middleName lastName) Workstreet 123 - PostalAddress (address1) 1 Biztown - PostalAddress (postalCode city) But we were unable to link Homer's CompanyFoo's PostalAddress X with the customer (Marge Simpson) We can link: - Homer with Marge - Company with Marge - PostalAddress with Marge But there is now relation between all 3. The ofbiz way we found: Company FOO - PostalAddress (toName) Homer Jay Simpson - PostalAddress/Party (attentionName) Workstreet 123 - PostalAddress (address1) 1 Biztown - PostalAddress (postalCode city) This way we loose the following information: - address = company address - firstname - lastname - middleName and we duplicate content. So, we have two questions: Is there a way to link such (standard) addresses? Can we flag an address as default (shipping) address? Best regards Greg
POS
Hi all, What is the best way to implement the Secondary Display (facing the customer) in Ofbiz POS. With regards, Pradeep Kumar,
Re: Selecting distinct columns
Here is one example conditions = FastList.newInstance(); conditions.add(EntityCondition.makeCondition(productCategoryId, EntityOperator.IN, categoryIds)); if (parameters.filter) { conditions.add(EntityCondition.makeCondition(brandName, EntityOperator.LIKE, parameters.filter + %)); } conditions.add(EntityCondition.makeConditionDate(fromDate, thruDate)); findOptions = new EntityFindOptions(); findOptions.setDistinct(true); brandRows = delegator.findList(ProductAndCategoryMember, EntityCondition.makeCondition(conditions, EntityOperator.AND), UtilMisc.toSet(brandName), UtilMisc.toList(brandName), findOptions, true); With regards, S K Pradeep Kumar, 9035009495 On Sun, Apr 14, 2013 at 8:53 PM, Varun Bhansaly vbhans...@gmail.com wrote: Has anyone got something similar working in MySQL (with entity engine)? On Sat, Apr 13, 2013 at 6:53 AM, Varun Bhansaly vbhans...@gmail.com wrote: A correction on the last portion - I'm using OFBiz trunk and using delegator.find(...) and NOT using delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. On Fri, Apr 12, 2013 at 5:40 PM, Varun Bhansaly vbhans...@gmail.com wrote: What is the best way of formulating a query which attempts to select two distinct columns - For example, the desired query is - SELECT DISTINCT PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID FROM PRODUCT_FEATURE PF The closest which can be achieved is SELECT DISTINCT (PF.PRODUCT_FEATURE_TYPE_ID, PF.PRODUCT_FEATURE_CATEGORY_ID) FROM PRODUCT_FEATURE PF this generated query is not acceptable in MySQL but works fine in PostgreSQL and its generated with this view definition - view-entity entity-name=ProductFeatureView package-name=mypackage member-entity entity-alias=PF entity-name=ProductFeature/ alias name=productFeatureTypeAndCategory entity-alias=PF complex-alias operator=, complex-alias-field entity-alias=PF field=productFeatureTypeId/ complex-alias-field entity-alias=PF field=productFeatureCategoryId/ /complex-alias /alias /view-entity I'm using OFBiz trunk and using delegator.find(...) and delegator.findCountByCondition(...) because the latter does not allow supplying columns to be selected. Thanks, -- View this message in context: http://ofbiz.135035.n4.nabble.com/Selecting-distinct-columns-tp4640610.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Regards, Varun Bhansaly -- Regards, Varun Bhansaly
Re: Remove Port number from the URL
Just change the port no.'s in ofbiz-container.xml and url.properties file for both http and https. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Mon, Apr 1, 2013 at 12:48 PM, Vikas vi...@divsinsol.com wrote: Hi All, How I Can remove the port number (8443, 8080) from the URL? Thanks Vikas -- View this message in context: http://ofbiz.135035.n4.nabble.com/Remove-Port-number-from-the-URL-tp4640263.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Currency type
check for the store settings. With regards, S K Pradeep Kumar, 9035009495 On Wed, Mar 27, 2013 at 12:54 PM, shaghee shiji.ganapa...@gmail.com wrote: I create one product store with base currency type INR, and add product with create new product link in catalog. Currency type selected for product was INR for the price and cost, but at the product page price of the product showing as $0.00. Did i miss any config? general.properties modified currency.uom.id.default=USD to currency.uom.id.default=INR Then the combo starts to show the INR on top, but still product page showing $0.00 as price. Productscreen.xml is modified and no change in result. Please help to solve this. Thank to your replies. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Currency-type-tp4640141.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Raw material Inventory
Hi Vikas, How could that effect to inventory. With regards, Pradeep Kumar With regards, S K Pradeep Kumar, 9035009495 On Wed, Feb 13, 2013 at 10:31 AM, Vikas Mayur vikasma...@gmail.com wrote: Look for the setup of products of type RAW_MATERIAL in demo data. Regards Vikas On Feb 5, 2013, at 6:12 PM, S K Pradeep Kumar wrote: Hi All, Can some one help me in maintaining the Raw material Inventory. Product is cloth. Industry : Garments. With regards, S K Pradeep Kumar, 9035009495
Re: Is there any service to udpate order item shipgroup assoc
Hi Deepak, For this there is a provision in the UI level only. There are 2 way's 1. Using the Splitting Preference you can create the 2 shipments. 2. You can create the 2 Ship groups (you can go through checkout process in ecommerce, after adding the product to the cart enter this url https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/splitship here you can create the ship groups for each product) With regards, S K Pradeep Kumar, 9035009495 On Sat, Jan 19, 2013 at 2:19 AM, Deepak Agarwal dagarwa...@gmail.comwrote: I have a sales order with 10 items. I want to ship it in 2 shipgroups. Didn't find a place where I can move the order items b/w ship groups after the approval of the order. If it is needed to be implemented then will that following work suffice? 1) update OrderItemShipGroupAssoc 2) update OrderItemShipGrpInvRes (run balance inventory service ?) -- Thanks, Deepak Agarwal, Mobile: +91 9501190044
Re: REST and JSON
https://cwiki.apache.org/OFBIZ/export-service-using-rest.html With regards, S K Pradeep Kumar, 9035009495 On Thu, Nov 8, 2012 at 11:37 PM, Gintare Ragaisiene gintare.ragaisi...@gmail.com wrote: Hi again does OfBiz supports REST and JSON ? Thanks! Gintare
Re: Broken pipe exception
Hi Jacques, Thanks for the reply, i am not facing any other problem. How can i stop the client aborted issue. With regards, S K Pradeep Kumar, 9035009495 On Fri, Aug 31, 2012 at 12:23 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Most of the time it's because the client has aborted and have no more consequences, do you face any other problems? Jacques From: S K Pradeep Kumar s.k.pradeepku...@gmail.com Hi All, How can we resolve the javax.net.ssl.SSLException Message: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe thanks in advance. With regards, S K Pradeep Kumar, 9035009495
Re: creating FacilityManager problem
This service requires, the authorization. You supposed to send the userLogin in service context. With regards, S K Pradeep Kumar, 9035009495 On Fri, Jul 20, 2012 at 6:01 PM, shilpa shilp...@veninore.com wrote: Hi Friend, I am creating facility manager in my application,and calling in my application ofbiz createfacility service.So that time getting bellow mentioned error.Please check and guide me. One more question is that can i use in my application create facility service.that is im only creating services not doing other operation like creating an inventory,like that.please tell me shall i used ofbiz services in my application .becoz now im getting facilitygenericpermission error.. 2012-07-20 17:44:46,578 (http-0.0.0.0-8080-2) [ RequestHandler.java:648:INFO ] Ran Event [service:component://product/servicedef/services_facility.xml#createFacility] from [request], result is [error] 2012-07-20 17:44:46,578 (http-0.0.0.0-8080-2) [ RequestHandler.java:431:ERROR] Request CreateFacility caused an error with the following message: You must be logged in to complete the [Main permission logic] process. 2012-07-20 17:44:46,578 (http-0.0.0.0-8080-2) [ RequestHandler.java:750:INFO ] Rendering View [EditFacility], sessionId=4FD55262329883E9F829C0B7A67C63CD.jvm1 thanks svn -- View this message in context: http://ofbiz.135035.n4.nabble.com/creating-FacilityManager-problem-tp4635074.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ERP
Hi Elaine, As per my knowledge things can be done in ofbiz are colored in red in the attachment document. With regards, S K Pradeep kumar, 9980609494 On Tue, Oct 25, 2011 at 10:42 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: There are no user licenses with Apache OFBiz - it is free, open source software. There are service providers who can assist you with evaluation and migration: https://cwiki.apache.org/**OFBIZ/apache-ofbiz-service-**providers.htmlhttps://cwiki.apache.org/OFBIZ/apache-ofbiz-service-providers.html -Adrian On 10/25/2011 10:09 AM, Elaine Tang wrote: Hi, We are currently usingsalesorder.com http://salesorder.comas our ERP and are looking to migrate to an open source ERP which we can run on our own server. Please could you advise whether your product supports the attached requirements and whether they are supported by the community or paid edition? Please could you advise the price for a 2 and 5 user license for the paid edition if required. Please could you also recommend the best way to migrate fromsalesorder.com http://salesorder.com? Thanks Elaine ERP2.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Re: ERP
With regards, S K Pradeep kumar, 9980609494 On Wed, Oct 26, 2011 at 6:24 PM, S K Pradeep Kumar s.k.pradeepku...@gmail.com wrote: Hi Elaine, As per my knowledge things can be done in ofbiz are colored in red in the attachment document. With regards, S K Pradeep kumar, 9980609494 On Tue, Oct 25, 2011 at 10:42 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: There are no user licenses with Apache OFBiz - it is free, open source software. There are service providers who can assist you with evaluation and migration: https://cwiki.apache.org/**OFBIZ/apache-ofbiz-service-**providers.htmlhttps://cwiki.apache.org/OFBIZ/apache-ofbiz-service-providers.html -Adrian On 10/25/2011 10:09 AM, Elaine Tang wrote: Hi, We are currently usingsalesorder.com http://salesorder.comas our ERP and are looking to migrate to an open source ERP which we can run on our own server. Please could you advise whether your product supports the attached requirements and whether they are supported by the community or paid edition? Please could you advise the price for a 2 and 5 user license for the paid edition if required. Please could you also recommend the best way to migrate fromsalesorder.com http://salesorder.com? Thanks Elaine ERP2.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Has any one used Mongo DB with ofbiz
Hi All, Has any one used Mongo DB with ofbiz? Please give me some idea. thanks in advance. With regards, S K Pradeep kumar, 9980609494
Re: Creating Promotion
Hi Piyush, There are so many category types. PROMOTIONAL == Featured NEW ARRIVAL's == latest MOST POPULAR BEST SELLER can be achieved by ProductCalculatedInfo entity. With regards, S K Pradeep kumar, 9980609494 On Mon, Aug 22, 2011 at 1:28 PM, pmittal.1982 pmittal.1...@gmail.comwrote: Hi All, I have just started exploring ofBiz and am planning to migrate my old website to ofBiz platform. I also want to have two or three categories of products on the ecommerce main page like Latest Arrivals Featured etc, cn you please tell if we have a solution to the problem raised by Abhijeet. I tried the solution proposed by Preeti but somehow its not working. Thanks in advance. Piyush -- View this message in context: http://ofbiz.135035.n4.nabble.com/Creating-Promotion-tp164906p3759509.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Configure Php project with OFBiz framework
What kind of a project your using. http://www.caucho.com/resin-3.0/quercus/ With regards, S K Pradeep kumar, 9980609494 On Thu, Jul 21, 2011 at 11:58 AM, jairaj gaur.jai...@gmail.com wrote: Hello friends, I am stuck in a problem need a solution asap. Actually/* I want to configure one of my Php project with my OFbiz modules using the same Apache server and DB as PostgreSQL*/. If anyone have any idea related this problem ,please share. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Configure-Php-project-with-OFBiz-framework-tp3682916p3682916.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: how to download Apache ofbiz
Use : build.ofbiz.org With regards, S K Pradeep kumar, 9980609494 On Tue, Jul 19, 2011 at 4:42 AM, Bilgin Ibryam bibr...@gmail.com wrote: Go to http://ofbiz.apache.org and use the BIG Download OFBiz button. Cheers, Bilgin On Mon, Jul 18, 2011 at 7:23 PM, UMESH KUSHWAH umesh60...@gmail.com wrote: -- View this message in context: http://ofbiz.135035.n4.nabble.com/how-to-download-Apache-ofbiz-tp3676080p3676080.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Hardware device with webpos
Hi All, Any idea about how to integrate the hardware devices with webpos. thanks in advance. With regards, S K Pradeep kumar, 9980609494
Search Cloud
Hi All, Is there any body has created/integrated *Search Cloud* with ofbiz. Is there any one developed/implemented the fallowing terms organic results sponsored results keyword tags and statistical log How these can be achieved in ofbiz. Any kind of help will the highly appreciated. Is there any link to explore further thanks, in advance. With regards, S K Pradeep kumar, 9980609494
OpenSocial
Hi All, Is there any one is integrated OpenSocialthanks in advance. With regards, S K Pradeep kumar, 9980609494
Re: Product attributes missing
Its maintained in login.groovy previousParams = session.getAttribute(_PREVIOUS_PARAMS_); With regards, S K Pradeep kumar, 9980609494 On Mon, Apr 18, 2011 at 10:05 AM, Akshat Aggarwal akshat.aggar...@hcl.comwrote: Hi , If we go from a category or product page to login page and fill in our credentials and return to the page it says no product id or category id found. The attributes are not getting stored in session. Can anyone help me with this Akshat Aggarwal ::DISCLAIMER:: --- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ---
Re: Problem with add to cart whenever we refresh the browser
You can use ajax. With regards, S K Pradeep kumar, 9980609494 On Wed, Apr 13, 2011 at 1:41 PM, Deepak Dixit deepak.di...@hotwaxmedia.comwrote: You can use request-redirect for add to cart request. ie. response name=success type=request-redirect value=main/ Thanks Regards -- Deepak Dixit HotWax Media Pvt. Ltd. www.hotwaxmedia.com Contact :- +91-98267-54548 Skype :- deepakdixit On Apr 13, 2011, at 12:50 PM, Amrish Kumar wrote: Hi, can anyone tell me how to solve the problem for add to cart on browser refresh. Whenever we add any product it adds one quantity and again if I refresh the browser it adds one more product. can any one give me the solution for this. -- Print this mail only if absolutely necessary. Save Paper. Save Trees. Regards, Amrish Kumar, Palindrome Software Labs
Re: How can i use the php code in ofbiz
Ok, With regards, S K Pradeep kumar, 9980609494 On Mon, Feb 28, 2011 at 1:52 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Hi Raj, No I did not know,that's interesting. It seems easier to use the work I propose though, reasons: * No need to touch to PHP nor Tomcat * Can use any PHP version (Tomcat uses only PHP 4) Anyway, if Pradeep is still interested, I will put the archive I have in a Jira and we will see... Pradeep? Thanks Jacques From: Raj Saini rajsa...@gmail.com Hi Jacques, I am not sure if you are aware of it. Tomcat also have PHP support. I used it once for a small application. There is a Tomcat wiki page as well http://wiki.apache.org/tomcat/UsingPhp. Thanks, Raj On Monday 28 February 2011 10:39 AM, Jacques Le Roux wrote: Hi Pradeep, If you are interested, I have a work effort done by another guy to use Quercus in OFBiz. I got it to work at some point (2 years ago) and I know the (big French) company where this guy works uses it everyday. Unfortunately he recently (2 weeks ago) sent me a last version (I asked him to have all working from hot-deploy, because before it was in special-purpose and Quercus has a GPL license). Unfortunately I had no chances yet to have a close look and fix the issue I crossed with this implementation OOTB. So, If you are interested, I could create a Jira and post the archive there. I'd really like if you could contribute back the work if you get it working. It's well documented and I believe it should not be more than a couple of hours to have it completely generalized. What do you think? Jacques From: S K Pradeep Kumar s.k.pradeepku...@gmail.com Hi all, I have one application developed using php(front end) and java(Back End). We need to port that application to ofbiz. Is there any way we can use the php code in place of groovy/ftl. With regards, S K Pradeep kumar, 9980609494
How can i use the php code in ofbiz
Hi all, I have one application developed using php(front end) and java(Back End). We need to port that application to ofbiz. Is there any way we can use the php code in place of groovy/ftl. With regards, S K Pradeep kumar, 9980609494
Re: How can i use the php code in ofbiz
Hi Jacques, I am interested in making this to work. Any how i have to make it work. With regards, S K Pradeep kumar, 9980609494 On Mon, Feb 28, 2011 at 10:39 AM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Hi Pradeep, If you are interested, I have a work effort done by another guy to use Quercus in OFBiz. I got it to work at some point (2 years ago) and I know the (big French) company where this guy works uses it everyday. Unfortunately he recently (2 weeks ago) sent me a last version (I asked him to have all working from hot-deploy, because before it was in special-purpose and Quercus has a GPL license). Unfortunately I had no chances yet to have a close look and fix the issue I crossed with this implementation OOTB. So, If you are interested, I could create a Jira and post the archive there. I'd really like if you could contribute back the work if you get it working. It's well documented and I believe it should not be more than a couple of hours to have it completely generalized. What do you think? Jacques From: S K Pradeep Kumar s.k.pradeepku...@gmail.com Hi all, I have one application developed using php(front end) and java(Back End). We need to port that application to ofbiz. Is there any way we can use the php code in place of groovy/ftl. With regards, S K Pradeep kumar, 9980609494
Upgrade to jquery
Hi All, I am using the older version of ofbiz 9.04 which is having the prototype js. I would like to upgrade it to jquery. What are all the changes i need to do to upgrade it? With regards, S K Pradeep kumar, 9980609494
Re: Upgrade to jquery
using trunk only. With regards, S K Pradeep kumar, 9980609494 On Fri, Feb 25, 2011 at 5:22 PM, Pranay Pandey pranay.pan...@hotwaxmedia.com wrote: Hi Pradeep, Using trunk or waiting for the latest release is the option IMO. Thanks Regards -- Pranay Pandey On Feb 25, 2011, at 4:31 PM, S K Pradeep Kumar wrote: Hi All, I am using the older version of ofbiz 9.04 which is having the prototype js. I would like to upgrade it to jquery. What are all the changes i need to do to upgrade it? With regards, S K Pradeep kumar, 9980609494
Re: Pointing OFBiz direct to domain
Hi, You can change the ports 8080 to 80. To do this you have to edit ofbiz-container.xml and url.properties files. With regards, S K Pradeep kumar, 9980609494 On Mon, Feb 14, 2011 at 8:45 AM, Kenneth G. Bice awsnap.kenn...@gmail.comwrote: Hello, I am trying to understand how I can create a product catalog for display on the web and have OFBiz point directly to the domain ie; http://my.domain.com not my.domain.com:8080 or whatever. I guess I need some documentation on deploying the catalog for web. Any info would be appreciated. KGB
Mobile ecommerc
Hi All, I have a requirement to implement the mobile version of the existing ofbiz e-commerce application. Which are the best way's to implement the mobile version of the website? Which technology is best? Which technology fits best with ofbiz? Thanks in advance. With regards, S K Pradeep kumar, 9980609494
Re: Help on scripting
If you want to include the java script just before body tag. You have to include this directly in the corresponding footer.ftl file. where you will get the end of the /body and /html With regards, S K Pradeep kumar, 9980609494 On Fri, Feb 11, 2011 at 4:36 PM, Hardik Handa hardik.ha...@hcl.com wrote: Is their any way to add a javascript just before the body ends !! i tried a lot of combinations on commonscreens.xml but was unsuccessful. Thanx in advance Regards, Hardik Handa Software Engineer - CMHP-RETAIL-COE-eCommerce HCL Technologies Ltd. C-22A, Sector 57, NOIDA. 201301, UP. (India) Tel: +91-120-2586417-19 Mob: +91-9811671898 www.hcltech.com www.hcl.com -Original Message- From: Sascha Rodekamp [mailto:sascha.rodekamp.lynx...@googlemail.com] Sent: 11 February 2011 PM 03:17 To: user@ofbiz.apache.org Subject: Re: Help on scripting Ok that's pretty easy. Just include the jQueryVersion.min.js in your common-screens.xml. The error msg means the you don't load the jQuery lib before you load the slider stuff. Have a look to the global CommonScreen.xml there you find an example of how to include JS Libs. Have a good day Sascha 2011/2/11 Hardik Handa hardik.ha...@hcl.com Error: jQuery is not defined Source File: http://localhost:8080/images/js_HCL/spotlight_product_slider.js Line : 327 This is the error And the line number defined in the firefox i.e 327 says (jQuert); -Original Message- From: Sascha Rodekamp [mailto:sascha.rodekamp.lynx...@googlemail.com] Sent: 11 February 2011 PM 02:58 To: user@ofbiz.apache.org Subject: Re: Help on scripting Hi Hardik, what do u import in you're common-screen.xml? The html file oder did you create an ftl file? Is the rest of the site is loaded properly? Did you se any JS Errors? Regards Sascha 2011/2/11 Hardik Handa hardik.ha...@hcl.com I have been using this javascript for sliding effect jq_slider.js on my homepage although this same javascript is working on pure html , imported this in the commonscreens.xml But the effect isn't coming. Could someone tell me why is this happening and any solution for this. Thanx in advance Regards, Hardik Handa Software Engineer - CMHP-RETAIL-COE-eCommerce HCL Technologies Ltd. C-22A, Sector 57, NOIDA. 201301, UP. (India) Tel: +91-120-2586417-19 Mob: +91-9811671898 www.hcltech.comhttp://www.hcltech.com www.hcl.comhttp://www.hcl.in/ ::DISCLAIMER:: --- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. --- -- Sascha Rodekamp Lynx-Consulting GmbH Johanniskirchplatz 6 D-33615 Bielefeld http://www.lynx.de -- Sascha Rodekamp Lynx-Consulting GmbH Johanniskirchplatz 6 D-33615 Bielefeld http://www.lynx.de
Localization
Hi All, I have to do the localization for the ofbiz ecommerce application, how can do this. I want my website front end(ecommerce), in Indian local languages such as Hindi, kannada, telugu and tamil. How can i do this. Thanks, With regards, S K Pradeep kumar, 9980609494
Re: Customize login page
Hi, You can change the login by changing the theme name in the fallowing row field value in user_preference table. _NA_VISUAL_THEMEGLOBAL_PREFERENCESFLAT_GREY\N 2010-07-07 11:22:522010-07-07 11:22:522010-07-07 11:22:52 2010-07-07 11:22:52 With regards, S K Pradeep kumar, 9980609494 On Thu, Jan 6, 2011 at 4:01 AM, Carsten Schinzer c.schin...@googlemail.comwrote: Hi, I guess the easiest would be to change the stylesheet of the Tomahawk theme if you want to apply simple layout changes. I am typically just copying a theme-folder entirely (with a new name them) before changing things. You can change the default theme within your user profile then to the new one. Regards Carsten
Re: OFbiz with Ajax (DWR)
Yes, it can be. With regards, S K Pradeep kumar, 9980609494 On Wed, Oct 6, 2010 at 6:48 PM, Deepa Priolkar dee...@techmahindra.comwrote: Hi, Can DWR be integrated with Ofbiz? Is there any sample example for the same? Thanks Regards, Deepa Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at a href=http://www.techmahindra.com/Disclaimer.html http://www.techmahindra.com/Disclaimer.html/a externally and a href= http://tim.techmahindra.com/Disclaimer.html; http://tim.techmahindra.com/Disclaimer.html/a internally within Tech Mahindra.
Hi can anybody came across this problem
Hi All, Anybody came across this problem and what is the solution. [r...@ip-208-109-170-166 cp123]# *** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x0a253af8 *** === Backtrace: = /lib/libc.so.6[0x36c250] /lib/libc.so.6(__libc_malloc+0x67)[0x36dd87] /usr/sbin/mysqld(my_malloc+0x25)[0x848a495] /usr/sbin/mysqld[0x81e2ae6] /usr/sbin/mysqld(_Z17mysql_lock_tablesP3THDPP8st_tablejjPb+0x5a)[0x81e367a] /usr/sbin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjPb+0x2f1)[0x8232d81] /usr/sbin/mysqld(_Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTb+0x3d)[0x8239d2d] /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x11e)[0x826d29e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x354c)[0x81fa10c] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjPPKc+0x27c)[0x81fee9c] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x658)[0x81ff508] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe1)[0x82006f1] /usr/sbin/mysqld(handle_one_connection+0x7b1)[0x81f0a31] /lib/libpthread.so.0[0x45573b] /lib/libc.so.6(clone+0x5e)[0x3d3cfe] === Memory map: mysql With regards, S K Pradeep kumar, 9980609494
Re: Hi can anybody came across this problem
Hi BJ, In ofbiz.log its saying only Can't establish connection with database. thats it. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 8:38 PM, BJ Freeman bjf...@free-man.net wrote: what steps did you perform what is the errors in ofbiz logs S K Pradeep Kumar sent the following on 9/28/2010 5:55 AM: Hi All, Anybody came across this problem and what is the solution. [r...@ip-208-109-170-166 cp123]# *** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x0a253af8 *** === Backtrace: = /lib/libc.so.6[0x36c250] /lib/libc.so.6(__libc_malloc+0x67)[0x36dd87] /usr/sbin/mysqld(my_malloc+0x25)[0x848a495] /usr/sbin/mysqld[0x81e2ae6] /usr/sbin/mysqld(_Z17mysql_lock_tablesP3THDPP8st_tablejjPb+0x5a)[0x81e367a] /usr/sbin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjPb+0x2f1)[0x8232d81] /usr/sbin/mysqld(_Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTb+0x3d)[0x8239d2d] /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x11e)[0x826d29e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x354c)[0x81fa10c] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjPPKc+0x27c)[0x81fee9c] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x658)[0x81ff508] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe1)[0x82006f1] /usr/sbin/mysqld(handle_one_connection+0x7b1)[0x81f0a31] /lib/libpthread.so.0[0x45573b] /lib/libc.so.6(clone+0x5e)[0x3d3cfe] === Memory map: mysql With regards, S K Pradeep kumar, 9980609494
Re: Hi can anybody came across this problem
Hi Bj, Yes i tried to connect by mysql cmd but not able to connect to the mysql. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 9:04 PM, BJ Freeman bjf...@free-man.net wrote: have tried connecting to db though another means S K Pradeep Kumar sent the following on 9/28/2010 8:11 AM: Hi BJ, In ofbiz.log its saying only Can't establish connection with database. thats it. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 8:38 PM, BJ Freemanbjf...@free-man.net wrote: what steps did you perform what is the errors in ofbiz logs S K Pradeep Kumar sent the following on 9/28/2010 5:55 AM: Hi All, Anybody came across this problem and what is the solution. [r...@ip-208-109-170-166 cp123]# *** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x0a253af8 *** === Backtrace: = /lib/libc.so.6[0x36c250] /lib/libc.so.6(__libc_malloc+0x67)[0x36dd87] /usr/sbin/mysqld(my_malloc+0x25)[0x848a495] /usr/sbin/mysqld[0x81e2ae6] /usr/sbin/mysqld(_Z17mysql_lock_tablesP3THDPP8st_tablejjPb+0x5a)[0x81e367a] /usr/sbin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjPb+0x2f1)[0x8232d81] /usr/sbin/mysqld(_Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTb+0x3d)[0x8239d2d] /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x11e)[0x826d29e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x354c)[0x81fa10c] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjPPKc+0x27c)[0x81fee9c] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x658)[0x81ff508] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe1)[0x82006f1] /usr/sbin/mysqld(handle_one_connection+0x7b1)[0x81f0a31] /lib/libpthread.so.0[0x45573b] /lib/libc.so.6(clone+0x5e)[0x3d3cfe] === Memory map: mysql With regards, S K Pradeep kumar, 9980609494
Re: Hi can anybody came across this problem
hi bj Thanks for your help. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 11:43 PM, BJ Freeman bjf...@free-man.net wrote: bases on your first post I am guessing you have a driver problem in the JDBC . suggest you go to the mysql forum to get it worked out. = 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 S K Pradeep Kumar sent the following on 9/28/2010 10:42 AM: Hi Bj, Yes i tried to connect by mysql cmd but not able to connect to the mysql. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 9:04 PM, BJ Freemanbjf...@free-man.net wrote: have tried connecting to db though another means S K Pradeep Kumar sent the following on 9/28/2010 8:11 AM: Hi BJ, In ofbiz.log its saying only Can't establish connection with database. thats it. With regards, S K Pradeep kumar, 9980609494 On Tue, Sep 28, 2010 at 8:38 PM, BJ Freemanbjf...@free-man.net wrote: what steps did you perform what is the errors in ofbiz logs S K Pradeep Kumar sent the following on 9/28/2010 5:55 AM: Hi All, Anybody came across this problem and what is the solution. [r...@ip-208-109-170-166 cp123]# *** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x0a253af8 *** === Backtrace: = /lib/libc.so.6[0x36c250] /lib/libc.so.6(__libc_malloc+0x67)[0x36dd87] /usr/sbin/mysqld(my_malloc+0x25)[0x848a495] /usr/sbin/mysqld[0x81e2ae6] /usr/sbin/mysqld(_Z17mysql_lock_tablesP3THDPP8st_tablejjPb+0x5a)[0x81e367a] /usr/sbin/mysqld(_Z11lock_tablesP3THDP10TABLE_LISTjPb+0x2f1)[0x8232d81] /usr/sbin/mysqld(_Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTb+0x3d)[0x8239d2d] /usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x11e)[0x826d29e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x354c)[0x81fa10c] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjPPKc+0x27c)[0x81fee9c] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x658)[0x81ff508] /usr/sbin/mysqld(_Z10do_commandP3THD+0xe1)[0x82006f1] /usr/sbin/mysqld(handle_one_connection+0x7b1)[0x81f0a31] /lib/libpthread.so.0[0x45573b] /lib/libc.so.6(clone+0x5e)[0x3d3cfe] === Memory map: mysql With regards, S K Pradeep kumar, 9980609494
Re: Auto Suggest
Hi, Auto Suggest already there at https://demo-trunk.ofbiz.apache.org:8443/webpos/control/main With regards, S K Pradeep kumar, 9980609494 On Thu, Sep 2, 2010 at 11:34 AM, Gavin Mabie gavin.ma...@urbannex.co.zawrote: Any ideas on how to implement auto-suggest in Ofbiz?
Re: Problem in PUSH sync
Hi, Put the sequenced-id-prefix in the following tag to differentiate the entity in entityengine.xml delegator name=default entity-model-reader=main entity-group-reader=main entity-eca-reader=main distributed-cache-clear-enabled=false sequenced-id-prefix= group-map group-name=org.ofbiz datasource-name=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=localmysql/ /delegator With regards, S K Pradeep kumar, 9980609494 On Mon, Aug 30, 2010 at 6:31 PM, r...@pal raghunandan.badi...@palindromesoftware.com wrote: Hi All , I am facing the exception POSPUSH instance already running exception, and the DomException: InvalidCharacterERR whenever i am trying to PUSH the Orders from My system to Server machin, Please help me in resolving this. I need details steps to be followed for this. And tell me how to use the Webtools options in resetting the sync status. Please any one reply for this. Thansks Regards r...@pal -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-in-PUSH-sync-tp2400058p2400058.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: How to Add product Specification ?
Hi Gaurav, After creating the feature, u should add that feature for that particular product then you need to create the variants of that product. Before the that see, whether its virtual or variant. in the product main page With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 17, 2010 at 6:44 PM, Gaurav kalia gaurav.ka...@techblue.co.ukwrote: I have tried creating my own Feature Category named tshirt feature and added size small and medium but it is still coming as text not drop down. Please suggest. -- View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-Add-product-Specification-tp2327990p2328331.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: How to Add product Specification ?
that should be virtual only set to Y With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 17, 2010 at 7:37 PM, Gaurav Kalia gaurav.ka...@techblue.co.ukwrote: Hi Pradeep I have created my own Feature Category and added size in that category. and then I added that size in my product and on the live application it is coming as text but i want it to come as drop down. I tried it setting Y to both is product variant and is product virtual but still it is coming as text. Or do you want me to create a new variant product if yes please let me know how can i do this? Please suggest. Thanks Gaurav On Tuesday 17 August 2010 06:57 PM, S K Pradeep kumar [via OFBiz] wrote: Hi Gaurav, After creating the feature, u should add that feature for that particular product then you need to create the variants of that product. Before the that see, whether its virtual or variant. in the product main page With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 17, 2010 at 6:44 PM, Gaurav kalia [hidden email] /user/SendEmail.jtp?type=nodenode=2328352i=0wrote: I have tried creating my own Feature Category named tshirt feature and added size small and medium but it is still coming as text not drop down. Please suggest. -- View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-Add-product-Specification-tp2327990p2328331.html http://ofbiz.135035.n4.nabble.com/How-to-Add-product-Specification-tp2327990p2328331.html?by-user=t Sent from the OFBiz - User mailing list archive at Nabble.com. View message @ http://ofbiz.135035.n4.nabble.com/How-to-Add-product-Specification-tp2327990p2328352.html To unsubscribe from Re: How to Add product Specification ?, click here http://ofbiz.135035.n4.nabble.com/template/NodeServlet.jtp?tpl=unsubscribe_by_codenode=2328331code=Z2F1cmF2LmthbGlhQHRlY2hibHVlLmNvLnVrfDIzMjgzMzF8LTEyMjEwNTkzNzg=.
Re: Recurring tasks?
Hi Study this method createShoppingListFromOrder With regards, S K Pradeep kumar, 9980609494 On Thu, Aug 12, 2010 at 5:39 PM, Olivier Tremblay oliviertrembla...@gmail.com wrote: Is there any way to easily set a task as recurring? Sometimes there are things we need to do periodically. Also, is it possible to get reminded that a given task is coming up? Via mail or something? Thanks! Olivier
Re: authorize.net configuration
Hi, Use the following link. https://cwiki.apache.org/confluence/display/OFBIZ/How+to+configure+authorize.net+certificates And also import your certificate in java also in..\jdk1.6.0_20\jre\lib\security With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 10, 2010 at 11:29 AM, Anurag Walia walia.anu...@hotmail.comwrote: Hi all, Thanks In advance. I need your help regarding authorize.net configuration I am trying to import files using this command keytool -import -trustcacerts -file (path to certificate) -alias AUTHORIZE_NET -keystore ./ofbizssl.jks i have some confussion. what should be (path to certificate)? what is the actual path of ofbizssl.jks ? and is their any more certification required like authorization.net . Looking for your great help... Thanks Anurag Walia -- View this message in context: http://ofbiz.135035.n4.nabble.com/authorize-net-configuration-tp2319337p2319337.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: authorize.net configuration
Hi Anurag Walia, Just import the authorization.net certificate in ofbizssl.jks and also in ..\jdk1.6.0_20\jre\lib\security\cacerts files With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 10, 2010 at 12:06 PM, Anurag Walia walia.anu...@hotmail.comwrote: Thanks Raj Pradeep But their is already a files in base\config folder with the name ofbizssl.jks. can i use this or generate new one by the keytools and authorization.net certificates. -- View this message in context: http://ofbiz.135035.n4.nabble.com/authorize-net-configuration-tp2319337p2319364.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: how to fetch records from two entities
Hi, What ever ur doing either groovy or xml. create one view entity so u can access them very easily. With regards, S K Pradeep kumar, 9980609494 On Tue, Aug 10, 2010 at 12:03 PM, hdv hdvar...@rediffmail.com wrote: hi I want to fetch records such as productId, imageurl etcfrom product entity using some condition and now i want to fetch price for those productids which i got from product entity.so how can i do that?? shud i do coding in groovy or in xml file?which one is better? -- View this message in context: http://ofbiz.135035.n4.nabble.com/how-to-fetch-records-from-two-entities-tp2319358p2319358.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Payment gateway integration
Hi Arthi, Which type of paypal your going to integrate. With regards, S K Pradeep kumar, 9980609494 On Thu, Jul 29, 2010 at 2:48 PM, Arthi Raja arthi.r...@kumaran.com wrote: Hi all, Anyone please suggest some ways to integrate ofbiz with paypal. regards, G.R.Arthi
is there any free dynamic currency converter
Hi All, Is there any free dynamic currency converter? if not, then which one is cheaper and better one... thanks With regards, S K Pradeep kumar,
Re: calling multiple services in ofbiz
Hi Prasanthi, You can create a groups for example: createCreditCardAndAddress With regards, S K Pradeep kumar, On Wed, May 12, 2010 at 7:50 PM, prasanthi_ofbiz prasanthi.sreeramjammise...@tcs.com wrote: Hi Is it possible to call multiple services at a time?? Like while adding a transaction of Financial Account, I want to call two services On click of Add button of Edit Financial Account Transaction. The two services are EditFinAccountTrans, for Addition of financial transaction and createAcctgTrans, for Creattion of an Accounting Transaction. Does it possible?? -- View this message in context: http://ofbiz.135035.n4.nabble.com/calling-multiple-services-in-ofbiz-tp2196098p2196098.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Google base Error
Hi All, I have created new account and generated new developer key and all... I am getting the following error while testing the google base functionality. ==returning with result: [responseMessage=success, newProductsInGoogle=[GZ-2644], productsRemovedFromGoogle=[null]] Service Failure [exportToGoogle]: Google response: Error Invalid item, Google response: Error errors error type=data field=image_link reason=This entry is not of type URL. / /errors Has anybody come across this problem, what is the solution for this.? With regards, S K Pradeep kumar,
which ofbiz release is better for shopping cart website
Hi All, I would like to develop the shopping cart website, which release of ofbiz is better. i.e either ofbiz-release9.04 and ofbiz-release4.0 thanks, With regards, S K Pradeep kumar,
Re: Can any body give the solution to this problem
Hi Shi Jinghai, Can you please With regards, S K Pradeep kumar, Hi Shi jinghai, How can i resolve this, is there any setting changes i need to make. With regards, S K Pradeep kumar On Tue, Mar 2, 2010 at 2:50 PM, Shi Jinghai sh...@langhua.cn wrote: Sounds like a file system problem. MySQL doesn't have any disk management, it's a database on OS/FS. 在 2010-03-02二的 12:51 +0530,S K Pradeep kumar写道: Dear All, Further to the discussion we had just now, please find the details below. Website url: www.compliancepanel.com �C currently up (moving to www.globalcompliancepanel.com) Hosted with: goDaddy on dedicated server Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core processor. Applications: ofBiz 4.0 based website on a red hat fedora linux 8.0 platform Database: MySQL 5.0 Size of database and application: 270MB. The size of database grows on an average of 2MB/day. *History:* The website was running smoothly for the past 9 months. This application was developed by a consultant who is working for another Bangalore based company in part time. *Problem:* The website will be down within 10 to 40 minutes after starting the application. The moment the website is down, the database table that is being accessed at that time is deleted or truncated or corrupted. Even if we turn off the server hit updates, the MySQL system tables will be corrupted. We understand that it is utilizing more cpu time (150% sometimes). * * *Steps taken: * reprovisioning the server several times. Re-installing all applications. Code: identifying loops in the code and changing it using list methods, Upgrading MySQL connector and DBCP, Removing all deprecated methods and resolving the jar conflicts Tests conducted: stress test using Wapt tool. Gradually increasing 20 virtual users every 10 minutes. The number of hits increased upto 70,000 in 10 hours. The application has behaved well. *Expectations:* Resolving the current problem and make the existing application very healthy Enhancement �C currently the application is only 15% of the whole application perceived. Kindly let us know if this can be taken up and if so let us know the quote for the same. Look forward for your support and co-operation. With regards, S K Pradeep kumar,
Can any body give the solution to this problem
Dear All, Further to the discussion we had just now, please find the details below. Website url: www.compliancepanel.com – currently up (moving to www.globalcompliancepanel.com) Hosted with: goDaddy on dedicated server Server: 4GB RAM, 160GB HD, 2GB SWAP, 2.6GHz Quad core processor. Applications: ofBiz 4.0 based website on a red hat fedora linux 8.0 platform Database: MySQL 5.0 Size of database and application: 270MB. The size of database grows on an average of 2MB/day. *History:* The website was running smoothly for the past 9 months. This application was developed by a consultant who is working for another Bangalore based company in part time. *Problem:* The website will be down within 10 to 40 minutes after starting the application. The moment the website is down, the database table that is being accessed at that time is deleted or truncated or corrupted. Even if we turn off the server hit updates, the MySQL system tables will be corrupted. We understand that it is utilizing more cpu time (150% sometimes). * * *Steps taken: * reprovisioning the server several times. Re-installing all applications. Code: identifying loops in the code and changing it using list methods, Upgrading MySQL connector and DBCP, Removing all deprecated methods and resolving the jar conflicts Tests conducted: stress test using Wapt tool. Gradually increasing 20 virtual users every 10 minutes. The number of hits increased upto 70,000 in 10 hours. The application has behaved well. *Expectations:* Resolving the current problem and make the existing application very healthy Enhancement – currently the application is only 15% of the whole application perceived. Kindly let us know if this can be taken up and if so let us know the quote for the same. Look forward for your support and co-operation. With regards, S K Pradeep kumar,
Database problem
Hi All, We have deployed currently our application with the godaddy server. Server Configuration is : Processor : QuadCore Ram : 4 GB OS : Linux Fedora 8 DB : MySql 5.0.45 We were maintaining the server since 9 months, recently we migrated to the new server with the above mentioned configuration af In the new server we were facing the database problem. The problem is when we deploy the application, application starts smoothly and runs smoothly after some time ServerHit, Visit, and Visitor tables become empty and then starts insertion. then onwards application is not catching the css. And showing the not able store serverHit error message in the logs. When we created the database our record count are serverHit : 352672 Visit : 147896 Visitor : 91617 If any one knows the solution could you please help me. = thanks in advance. With regards, S K Pradeep kumar,
Re: Database problem
Hi, Can any body update on this. Some of the tables are also deleted from the database after some time of starting the application With regards, S K Pradeep kumar, On Tue, Feb 23, 2010 at 2:39 PM, S K Pradeep kumar s.k.pradeepku...@gmail.com wrote: Hi All, We have deployed currently our application with the godaddy server. Server Configuration is : Processor : QuadCore Ram : 4 GB OS : Linux Fedora 8 DB : MySql 5.0.45 We were maintaining the server since 9 months, recently we migrated to the new server with the above mentioned configuration af In the new server we were facing the database problem. The problem is when we deploy the application, application starts smoothly and runs smoothly after some time ServerHit, Visit, and Visitor tables become empty and then starts insertion. then onwards application is not catching the css. And showing the not able store serverHit error message in the logs. When we created the database our record count are serverHit : 352672 Visit : 147896 Visitor : 91617 If any one knows the solution could you please help me. = thanks in advance. With regards, S K Pradeep kumar,
How to setup the Tomcat
Hi all, How to configure the tomcat in ofbiz framework, I have two domain names and one dedicated server. I want to run 2 different sites on each domain names. One site is the ofbiz e-commerce web site another one is the static website. How can i achieve this? thanks for help... With regards, S K Pradeep kumar,
How to change the java version in ofbiz
Hi all, How can i change the java version in ofbiz? Which file i need to edit? With regards, S K Pradeep kumar,
Re: how to pass data from one simple-method to another simple-method?
Hi, See the service groups . For example: createCreditCardAndAddress With regards, S K Pradeep kumar, On Tue, Feb 2, 2010 at 12:16 AM, Patrick patrickinminneapo...@gmail.comwrote: I am trying to call updateSecurityGroup simple-method from another method. How do I tell it I want add a security setting for a particular user. If it was a service I would use set-service-fields but since its a method I'm confused. Thanks. Patrick
Re: how to pass data from one simple-method to another simple-method?
result-to-field you can use.. With regards, S K Pradeep kumar, On Tue, Feb 2, 2010 at 12:50 AM, Adrian Crum adri...@hlmksw.com wrote: The called simple method will inherit the context of the calling simple method. Any variables declared in the first will be available to the second. -Adrian Patrick wrote: I am trying to call updateSecurityGroup simple-method from another method. How do I tell it I want add a security setting for a particular user. If it was a service I would use set-service-fields but since its a method I'm confused. Thanks. Patrick
Re: Paypal Payment via PayFlow Pro
try, paypal direct payment, its also doing without an external redirection, and the implementation is also simple, and if you follow the cybersource integration is enough i think, With regards, S K Pradeep kumar, On Sun, Jan 24, 2010 at 7:56 PM, Mahesh Bachchan mahesh.bachc...@googlemail.com wrote: hello ofbiz-users, is it possible to use the payment method Paypal via PayFlow Pro Gateway? I mean, if a customer wants to pay via Paypal this payment should be made via the PayFlow Gateway without an external redirect to Paypal page! Is someone using such a solution!?? Or is paypal payment only via redirect to paypal pages available OOTB? Thanks Mahesh
Re: Conversion of sql query
Hi Santosh , Create the view entity for all your tables and use delegator.findByCondition method. With regards, S K Pradeep kumar, On Wed, Jan 13, 2010 at 6:05 PM, Santosh Malviya santosh.of...@gmail.comwrote: Hi list, I have a sql query and I want to do the same with ofbiz entity model. The query is as follows: select p.* from product_attribute pa1,product_attribute pa2, product p where pa1.attr_name = 'language' and pa1.attr_value ='english' and pa2.attr_name = 'genres' and pa2.attr_value ='Romance' and pa1.product_id = pa2.product_id and pa1.product_id = p.product_id Please help if someone has any idea for doing so. Thanks in advance. Thanks and Regards Santosh Malviya
How to install ssl, in the live dedicated server for ofbiz
Hi all, How to install ssl, in the dedicated server for ofbiz? With regards, S K Pradeep kumar,
Re: How to install ssl, in the live dedicated server for ofbiz
thanks With regards, S K Pradeep kumar, On Wed, Dec 23, 2009 at 8:02 PM, Raj Saini rajsa...@gmail.com wrote: It would depend where your SSL layer terminates. If you are using Apache HTTPd, you will need to configure the SSL in Apache HTTPd. If not, you can configure OFBiz to use SSL. In both cases, you will need to procure a SSL certificate from CA such as Verisign, Thawte, GoDaddy etc. You would receive instructions from CA how to configure SSL certificate based on the platform. Apache Tomcat instructions are also applicable to OFBiz, except the configuration file is different. OFBiz uses ${ofbiz.home}/framework/base/config/ofbiz-containers.xml. Raj S K Pradeep kumar wrote: Hi all, How to install ssl, in the dedicated server for ofbiz? With regards, S K Pradeep kumar,
hi all
Hi all, How to give the application level security in ofbiz. Thanks merry christmas in advance... With regards, S K Pradeep kumar,
Re: I am getting Invalid key store Format
Hi all, I am trying the same procedure to generate the jks, but in the step5 5. Import the Certificate into the keystore by running: keytool -import -alias ssl -trustcacerts -file mysignedcert.cer -keystore [keystore name] i am getting failed. # keytool -import -alias ssl -trustcacerts -file intermediateCA1.cer -keystore skp.jks Enter keystore password:changeit keytool error: java.lang.Exception: Public keys in reply and keystore don't match My server is having a firewall is that going to create a problem for me. thanks, in advance. With regards, S K Pradeep kumar, On Sat, Dec 19, 2009 at 2:45 PM, Jeroen van der Wal jvander...@stromboli.it wrote: Try this document: http://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide On Thu, Dec 17, 2009 at 2:24 PM, S K Pradeep kumar s.k.pradeepku...@gmail.com wrote: Hi all, Am i need to change the apache(httpd) ports, because httpd also using 8080 and 8443 ports, if yes can anybody tell me the steps. thanks in advance. With regards, S K Pradeep kumar, On Thu, Dec 17, 2009 at 11:01 AM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Did you try with the recommended version (ie Sun java 1.6)? Jacques From: S K Pradeep kumar s.k.pradeepku...@gmail.com Hi Jeroen , My Java version details java version 1.7.0 IcedTea Runtime Environment (build 1.7.0-b21) IcedTea Server VM (build 1.7.0-b21, mixed mode) With regards, S K Pradeep kumar, On Wed, Dec 16, 2009 at 8:25 PM, Jeroen van der Wal jvander...@stromboli.it wrote: Looks like you've got the wrong java version What java version are you using? Type java -version on the command line. Ofbiz requires Java 1.6 Jeroen van der Wal Stromboli b.v. +31 655 874050 On Wed, Dec 16, 2009 at 3:26 PM, S K Pradeep kumar s.k.pradeepku...@gmail.com wrote: Hi all, I am trying to run the ofbiz application in the dedicated linux(godaddy) server we have purchased, Simply i have uploaded the application and try to start the application. But i am getting the Invalid Key store Format exception Anybody tell me what might be the problem and how can i resolve this. Logs : 2009-12-16 10:21:04,659 (main) [ Http11Protocol.java:182:INFO ] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080 2009-12-16 10:21:04,683 (main) [SSLImpl.java:64 :ERROR] exception report -- Exception: java.io.IOException Message: Invalid keystore format stack trace --- java.io.IOException: Invalid keystore format sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:651) sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) java.security.KeyStore.load(KeyStore.java:1202) org.ofbiz.base.util.KeyStoreUtil.getSystemTrustStore(KeyStoreUtil.java:110) org.ofbiz.base.util.SSLUtil.getTrustManagers(SSLUtil.java:106) org.ofbiz.catalina.container.SSLImpl$AllowTrustManager.init(SSLImpl.java:62) org.ofbiz.catalina.container.SSLImpl.init(SSLImpl.java:48) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:539) java.lang.Class.newInstance0(Class.java:373) java.lang.Class.newInstance(Class.java:326) org.apache.tomcat.util.net.SSLImplementation.getInstance(SSLImplementation.java:75) org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:152) org.apache.catalina.connector.Connector.initialize(Connector.java:1058) org.apache.catalina.core.StandardService.initialize(StandardService.java:677) org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:215) org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190) org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66) org.ofbiz.base.start.Start.initStartLoaders(Start.java:250) org.ofbiz.base.start.Start.init(Start.java:89) org.ofbiz.base.start.Start.main(Start.java:398) 2009-12-16 10:21:04,684 (main) [ Http11Protocol.java:161:ERROR] Error initializin Please find the full logs in the attachment. With regards, S K Pradeep kumar,
Re: I am getting Invalid key store Format
Hi all, Am i need to change the apache(httpd) ports, because httpd also using 8080 and 8443 ports, if yes can anybody tell me the steps. thanks in advance. With regards, S K Pradeep kumar, On Thu, Dec 17, 2009 at 11:01 AM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Did you try with the recommended version (ie Sun java 1.6)? Jacques From: S K Pradeep kumar s.k.pradeepku...@gmail.com Hi Jeroen , My Java version details java version 1.7.0 IcedTea Runtime Environment (build 1.7.0-b21) IcedTea Server VM (build 1.7.0-b21, mixed mode) With regards, S K Pradeep kumar, On Wed, Dec 16, 2009 at 8:25 PM, Jeroen van der Wal jvander...@stromboli.it wrote: Looks like you've got the wrong java version What java version are you using? Type java -version on the command line. Ofbiz requires Java 1.6 Jeroen van der Wal Stromboli b.v. +31 655 874050 On Wed, Dec 16, 2009 at 3:26 PM, S K Pradeep kumar s.k.pradeepku...@gmail.com wrote: Hi all, I am trying to run the ofbiz application in the dedicated linux(godaddy) server we have purchased, Simply i have uploaded the application and try to start the application. But i am getting the Invalid Key store Format exception Anybody tell me what might be the problem and how can i resolve this. Logs : 2009-12-16 10:21:04,659 (main) [ Http11Protocol.java:182:INFO ] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080 2009-12-16 10:21:04,683 (main) [SSLImpl.java:64 :ERROR] exception report -- Exception: java.io.IOException Message: Invalid keystore format stack trace --- java.io.IOException: Invalid keystore format sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:651) sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56) java.security.KeyStore.load(KeyStore.java:1202) org.ofbiz.base.util.KeyStoreUtil.getSystemTrustStore(KeyStoreUtil.java:110) org.ofbiz.base.util.SSLUtil.getTrustManagers(SSLUtil.java:106) org.ofbiz.catalina.container.SSLImpl$AllowTrustManager.init(SSLImpl.java:62) org.ofbiz.catalina.container.SSLImpl.init(SSLImpl.java:48) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:539) java.lang.Class.newInstance0(Class.java:373) java.lang.Class.newInstance(Class.java:326) org.apache.tomcat.util.net.SSLImplementation.getInstance(SSLImplementation.java:75) org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:152) org.apache.catalina.connector.Connector.initialize(Connector.java:1058) org.apache.catalina.core.StandardService.initialize(StandardService.java:677) org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:215) org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190) org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66) org.ofbiz.base.start.Start.initStartLoaders(Start.java:250) org.ofbiz.base.start.Start.init(Start.java:89) org.ofbiz.base.start.Start.main(Start.java:398) 2009-12-16 10:21:04,684 (main) [ Http11Protocol.java:161:ERROR] Error initializin Please find the full logs in the attachment. With regards, S K Pradeep kumar,