Re: OFBiz Multi-tenancy
Just my 0.02 here: My understanding is still that the delegator handling might not be robust enough on OOTB OFBiz. When it comes to backend access every too often I have issues to see proper data or even logging in. Respective JIRA is open. Multiple DB needs to be the solution. Such is also leveraging a depend-nothing concept better than shared DB. Sharding multiple OFBiz instances to manage the traffic will be also easier, not speaking about upgradding ti dedicated instances etc. Re postgres I feel tenant-level backups into XML using OFBiz on-board tools might anyways be more efficient. The subset of entities that are populated into OFBiz by Tenant use are pretty clear. Regards Carsten Gesendet von unterwegs mit BlackBerry® Webmail. -Original Message- From: Pierre Smits pierre.sm...@gmail.com Date: Thu, 27 Feb 2014 12:57:54 To: user@ofbiz.apache.org Reply-To: user@ofbiz.apache.org Subject: Re: OFBiz Multi-tenancy Hi all, Thank you for submitting links to documents related to the subject. Of course, for each the criteria might vary and weigh differently, and the options available in current feature set of OFBiz are limited. But in whole, the cost of operations are key. These cost of operations not only include the hardware and software cost, but also the effort of maintaining the environment. While setting up a new tenant is easy, and maintaining the happy flow (uptime and backup), the crucial factors in this are the performance of the persistence engine and recovery cost in case of unexpected data loss. As many (on the internet) seem to be agreeing on the recovery cost in the case of a shared database-shared schema approach can be expected to be high due to the intricacies of the beast as opposed to a 'separate database-separate schema' setup. Yes, multiple databases might lead to a performance overhead and higher maintenance cost, but a side-by-side comparison of the various aspects of each approach (separate db-separate schema vs shared db-separate schema vs shared db-shared schema) is something that would surely help in assessing what would be the best approach in various scenarios. If that would be available, then a sound roadmap could be devised for this subject. Regards, Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com
AW: multitenant users?
Dale, This seems to be a manifest bug which I have reported on last week on this list. I have done some issue analysis and will open a Jira next thing. Imho the issue is caused by wrong assumptions in ContextFilter.java which defines the delegator to use and - even with multitenant databases - results in default delegatorr instead of the tenant's . @Jacques + other committers: I definitely require assistance to fix this since my knowledge and understanding of session parameter handling does not suffice. Along with the Jira ticket, I shall post my draft solution. Regards Carsten --Originalnachricht-- Von: Dale E. Moore An:user@ofbiz.apache.org Antwort an:user@ofbiz.apache.org Betreff: multitenant users? Gesendet: 28. Aug. 2012 16:20 I'm having a spot of problem logging in and using tenant DEMO1 and DEMO2. If I log in to DEMO1 or DEMO2 tenant as admin and create users I get errors when I try to use those users. If I run ./ant load-tenant-admin-user-login -DdelegatorId=DEMO1 -DuserLoginId=adminDemo which seems to run fine I get The Following Errors Occurred: following error occurred during login: User not found. I created my ofBiz install via: svn co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz.12.04-tenants cd ofbiz.12.04-tenants ./ant load-demo-multitenant vi framework/common/config/general.properties Change multitenant to Y ./ant start http://localhost:8080/catalog Are there instructions, documentation or hints somewhere that I am overlooking that guide me in the setup of multitenant installation, setup and configuration? If I can get past this step my next step will be to add a new tenant, over which I've already started scratching my head. I appreciate any suggestions, guidance or help! Would somebody please tell me where to go (grin?) I look forward to hearing from you, daleemo...@gmail.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/multitenant-users-tp4635997.html Sent from the OFBiz - User mailing list archive at Nabble.com. Gesendet mit BlackBerry® Webmail von Telekom Deutschland
AW: Process to remind sales invoice not paid
I would aproach this via a nightly job fetching all unaid invoices and sending a mail (or put a letter on a printer queue). Check Service Engine, ECAs and minilanguage to build that. That's theory so far. I need to build something very similar and I am about to implement. Any guidance from the more experienced is pf course appreciated: + where have respective ECAs already been defined? + is there a nice example lookup service defined in minlang that we could use to derive our respective ones? + where would I place related E-Mail (.ftl) and PDF (.fo.ftl) templates? Thanks for yozr comments. Regards Carsten --Originalnachricht-- Von: Nicolas Malin An:user@ofbiz.apache.org Antwort an:user@ofbiz.apache.org Betreff: Process to remind sales invoice not paid Gesendet: 14. Jun. 2012 09:20 Hi, I checked with OFBiz if is possible to have a process to remind to a customer by letter an invoice that the due date is past and isn't paid. I don't found with ootb, this process exist in OFBiz ? Else I made on enhancement : * Add an entity CommunicationEventInvoice * Add entry menu Reminder Invoice on invoice menu when not paid and due date past * Add screenlet on invoiceOverview to list all reminder do on this invoice * Add print button to keep the letter to post Idea, When an accountant click on Reminder Invoice button, a service create a communicationEvent with reasonEnumId REMINDER_INVOICE and associate it with invoice. When you list all reminder, you list communicationEvent associate. The first version works only on one invoice, but it possible to improve with many invoice on one communication Event or use a dedicate screen to write a specific reminder. if it interests, I will open an issue Nicolas -- Nicolas MALIN Consultant Tél : 06.17.66.40.06 Site projet : http://www.neogia.org/ --- Société LibrenBerry Tél : 02.48.02.56.12 Site : http://www.librenberry.net/ Gesendet mit BlackBerry® Webmail von Telekom Deutschland
AW: Re: Process to remind sales invoice not paid
Hi Pierre, I was just assuming that some old-school businesses (like I have 3+) would rather want to print out and 'snail mail' I.e. Use Post Service instead of e-mail (you won't believe how conservative people are getting over here these days ...) The 'print queue' could very well be a Communication Event withint ofbiz assigning a print task to an agent who will print the invoices out, envbelope and carry to the Mail Office :) ... Just an Idea. Regards Carsten PS: I was really not imagining to enable a local print queue through the OFBIz platform. Gesendet mit BlackBerry® Webmail von Telekom Deutschland -Original Message- From: Pierre Smits pierre.sm...@gmail.com Date: Thu, 14 Jun 2012 11:35:15 To: user@ofbiz.apache.org; c.schin...@googlemail.com Subject: Re: Process to remind sales invoice not paid Carsten, I agree that such a solution might be useful to organisations with large volumes of invoices. Question I have though is: how do we enable management of this solution? Meaning, end users need to be able to setup (a) print queue(s) themselves. Or did you have a programmatic solution in mind, whereby a system admin or a programmers modifies a config file in the system? Regards, Pierre 2012/6/14 c.schin...@googlemail.com I would aproach this via a nightly job fetching all unaid invoices and sending a mail (or put a letter on a printer queue). Check Service Engine, ECAs and minilanguage to build that. That's theory so far. I need to build something very similar and I am about to implement. Any guidance from the more experienced is pf course appreciated: + where have respective ECAs already been defined? + is there a nice example lookup service defined in minlang that we could use to derive our respective ones? + where would I place related E-Mail (.ftl) and PDF (.fo.ftl) templates? Thanks for yozr comments. Regards Carsten --Originalnachricht-- Von: Nicolas Malin An:user@ofbiz.apache.org Antwort an:user@ofbiz.apache.org Betreff: Process to remind sales invoice not paid Gesendet: 14. Jun. 2012 09:20 Hi, I checked with OFBiz if is possible to have a process to remind to a customer by letter an invoice that the due date is past and isn't paid. I don't found with ootb, this process exist in OFBiz ? Else I made on enhancement : * Add an entity CommunicationEventInvoice * Add entry menu Reminder Invoice on invoice menu when not paid and due date past * Add screenlet on invoiceOverview to list all reminder do on this invoice * Add print button to keep the letter to post Idea, When an accountant click on Reminder Invoice button, a service create a communicationEvent with reasonEnumId REMINDER_INVOICE and associate it with invoice. When you list all reminder, you list communicationEvent associate. The first version works only on one invoice, but it possible to improve with many invoice on one communication Event or use a dedicate screen to write a specific reminder. if it interests, I will open an issue Nicolas -- Nicolas MALIN Consultant Tél : 06.17.66.40.06 Site projet : http://www.neogia.org/ --- Société LibrenBerry Tél : 02.48.02.56.12 Site : http://www.librenberry.net/ Gesendet mit BlackBerry® Webmail von Telekom Deutschland
AW: Moving/deleting blocks in the ecommerce layout
Start learning! You need to modify ecommerce/widget/CommonScreens.xml and simply comment in the screen definitions for left and right column the screenlets you don't want. You should be somewhat familiar with XML though, but I assume you are. Enjoy. Carsten --Originalnachricht-- Von: Bernat Arlandis An:ofbiz-user Antwort an:user@ofbiz.apache.org Betreff: Moving/deleting blocks in the ecommerce layout Gesendet: 8. Mrz. 2012 18:48 Hi: I want to hide and reorder some blocks in the left and right columns of the main layout in the ecommerce site. Is there a way to do it without modifying template files? I know it has to be easy to do in the templates but I'm still new to ofbiz and I'd like to learn best practices. In case I need to edit the templates, is there a way to override the default ones so that I don't have to apply patches when I update ofbiz? Thanks! -- Bernat Arlandisber...@tsolucio.com JPL TSolució S.L. Gesendet mit BlackBerry® Webmail von Telekom Deutschland
AW: Re: vendors and suppliers
Hello David, Actually, such could make it's way to the help documents being provided online. I am fully with you, that a lot of fuzzy writing is on this (and other) trails. It should be clear to everyone that the common grounds are in the Data Model book. The second issue is for sure with tranlations, as in DE the same is the case as with NL: Vendor and Supplier are translated to the same term, which obviously makes it very difficult to keep the two concepts separate. I shall take a look at the german translations an d make sure they will be separated. I recommend the same for any other language translation where the two, vendor and supplier, fall into the same translated term. (Heidi, is that you for NL? Or are you still confused? Let me know and I can assist with the Label files) As for the first issue I shall review the online help documents and update if necessary. Kind regards Carsten Gesendet mit BlackBerry® Webmail von Telekom Deutschland -Original Message- From: David E Jones d...@me.com Date: Fri, 09 Dec 2011 18:31:29 To: user@ofbiz.apache.org Reply-To: user@ofbiz.apache.org Subject: Re: vendors and suppliers Ruth Hoffman wrote: Hi David: Nice to hear from you again. Thanks for your input. I have some responses. Please see below: On 12/9/11 4:44 PM, David E Jones wrote: Ruth Hoffman wrote: 2) If you look at how vendor/supplier is used in some of the OFBiz applications, you might observe that: A vendor supplies goods or services to the Company of record for the OFBiz instance. Those goods or services may be raw materials for manufacturing, products for resale on the ecommerce site or computers to run your business. When a vendor (with a record in the VENDOR table) supplies you with something, they are acting in a role called a SUPPLIER. So, in the OFBiz world, my interpretation is: A vendor is a supplier. It is as simple as that. Anything more is making it too complicated :-) Anyone care to comment on my interpretation? Actually a Supplier is a Party the sells things to the company running OFBiz, hence the SupplierProduct entity. In other words, a purchase order is sent to a Supplier. A vendor is also a Party that could sell things to the company running OFBiz. Just depends on how you set up your accounting system and how you name your accounts. The term vendor doesn't mean much in OFBiz, but has been used for any Party that sells something. For example, if you have multiple stores in your OFBiz instance you may have a vendor per store. You could also have multiple vendors selling through a single store. Seems to me if the Party sells something and the term vendor is used to express that activity, then the term DOES have lots of meaning. OFBiz e-commerce, after all, is all about selling products. That said, there is also an entity named VendorProduct that when coupled with the Vendor entity may be used in the same way as the SupplierProduct entity. Perhaps I should have said a vendor is a type of supplier? Unfortunately (or maybe fortuneately - who is to say?), the data model does not enforce this relationship. Okay, so did you ask to get an answer, or did you ask to start a discussion? It's not like this is open to interpretation, this was discussed and decided on a long time ago. A supplier sells stuff to the company running OFBiz. A vendor sells stuff to the customers of the company, and a vendor could be an affiliate or consignment seller sort of thing. The SupplierProduct and VendorProduct entities are VERY different and meant to model these 2 totally different things. I'm sorry, but looking at them again to make sure, I'm not even sure how they could possibly be confused. They are not really equivalent terms. Maybe, maybe not, but I would argue, based on the data model, that they ARE equivalent terms when a vendor acts in the role of supplier. Regardless, there is really no need to make this more confusing or complex than it already is. There is a clear distinction here. It's not making things complex, it's two different concepts. It's not one concept, that would be over-simplifying it. It is two separate, distinct concepts that need different words, and have them. Damn, with all the mis-information buzzing around these lists no wonder people have so many issues with OFBiz. Of course, OFBiz itself is admittedly complex and often unclear or just plain buggy and inconsistent, so this is understandable. I don't know exactly what we can do about all of this, but being more careful and detailed might be a good start for all of us. -David
AW: ofbiz multiple domain + multiple database
Ted, Sounds like multi-tenancy could help you here. I am on a trip and do not have the link at hand. Search for ofbiz + multitenancy and you will get the page on the wiki. Is your term 'domains' indicating mutliple URL domain names? If so, you'd need to use ofbiz' (tomcat's) virtualhost feature on top. Regards Carsten --Originalnachricht-- Von: Ted Vesel An:user@ofbiz.apache.org Antwort an:user@ofbiz.apache.org Betreff: ofbiz multiple domain + multiple database Gesendet: 5. Aug. 2011 21:11 I'm wandering if ofbiz can support multiple domains with multiple database back ends, each domain would have a different set of configurations such as different themes, different apps and so on. sites would be independent of each other, or would I have to run multiple tomcat instances to accomplish this.? Thanks Gesendet mit BlackBerry® Webmail von Telekom Deutschland
AW: Re: Reflect Inventory availability w/o concrete figures
Hi BJ and thanks for your comment. I realize, I had a typo in my requirements as it is rather the product supplier who handles fulfillment after we drop orders to their end. Not the reseller. However I do not feel this will change your comments. Will need to get that on a sheet of paper though and digest. Thanks again. Regards Carsten Gesendet mit BlackBerry® Webmail von Telekom Deutschland -Original Message- From: BJ Freeman bjf...@free-man.net Date: Fri, 08 Jul 2011 07:50:13 To: user@ofbiz.apache.org Reply-To: user@ofbiz.apache.org Subject: Re: Reflect Inventory availability w/o concrete figures your describing Dropship with a customization for inventory levels. Normally in Dropship the code does not look for inventory. the way I handle it is a component for the dropshipper or fulfillment company. I define an entity that fits their data. once this is imported, I use the custom code to read their data and set the dates based on their inventory. if discontinued then use the through date to disable product. if out of stock change the from date to when the product will be in-stock. the custom code creates a product in catalog for the supplier of new products that a employee can then copy in their store catalog. Custom code copies the product then adds a supplier product in inventory linked to the catalog product they copied. The custom code looks for products that are linked to the supplier product by partyID to change the dates. this should get you going in the right direction. Carsten Schinzer sent the following on 7/8/2011 12:34 AM: All, I'd like to find a way to build the following requirements into the standard product / facility mechanisms of OFBiz: * Inventory is not kept in the store, actually the stite is a reseller platform (orders collected and forwarded to reseller who does all handling includung shipping) * Availability of Inventory is communicated nightly by the Product Supplier; this is not figures of QoH but rather an info of type: {we have it; we won't have it any more; will be available as of date} I am currently slightly confused about the Product and Inventory data model and how I should set flags on Product: * Is it enough to Create an InventoryItem per product and set the 'statusId' to a proper value? A nightly job would then check the status and change it? How can I -- in this aproach -- reflect projected available-again dates? * Is it required to go the InventoryItemDetail path and create a detail for each availability-period of a product? * How do I handle QoH? Can I just set to value 1 and switch off the requires QoH flag on the Product? What would I then select as Inventory Method? Thanks for any hint ! Regards Carsten
AW: Re: Using CMS Elements in FTL
Hi Ruth, Thanks for that bit. Any groovy script you would be able to point me to in order to understand how the lookup would work? Regards Carsten Gesendet mit BlackBerry® Webmail von Telekom Deutschland -Original Message- From: Ruth Hoffman rhoff...@aesolves.com Date: Fri, 25 Mar 2011 12:54:35 To: user@ofbiz.apache.org Reply-To: user@ofbiz.apache.org Subject: Re: Using CMS Elements in FTL Hi Carsten: Are you referring to ElectronicText.textData? Usually content - like email body values - is either in an ElectronicText.textData record pointed to by a DataResource.dataResourceId and/or Content.dataResourceId or in a disk file somewhere and the DataResource.dataResourceId points to that location. To get the content and have Freemarker render it (and not just put up literal values), you can use something like: #assign renderedContent = StringUtil.wrapString(blog.textData) / Where blog was placed into the context via a Groovy data prep script. Is that what you are looking for? Regards, Ruth On 3/25/11 12:27 PM, Carsten Schinzer wrote: All, I am trying to customize the E-Mails and PDFs generated by OFBiz to contain managed content (like e.g. an opening text addressing the user and explaning the terms of the offer / order etc. or a closing remark including a greeting and a signature). I see that most of these contents -- especially the Formatting Object ones -- are handled and created using FTL parts. How would I thus reference a piece of managed content? Do I need to load it using a groovy script? Does anyone know a place where this is already done in the OFBiz framework? Any hint would be greatly appreciated. Thanks a lot in advance. Cheers Carsten
AW: Re: VAT is not applied for the shipping
Raj, Jacques, Thanks for your suggestions. I have found a config error I had taken over the _NA_ Tax Authority which was configured to add another 19 percent of VAT to my store prices. Clearing this away helped. Apologies for the long delay. It took a while :-) Regards Carsten Gesendet mit BlackBerry® Webmail von Telekom Deutschland -Original Message- From: Jacques Le Roux jacques.le.r...@les7arts.com Date: Wed, 2 Feb 2011 10:52:53 To: user@ofbiz.apache.org Reply-To: user@ofbiz.apache.org Subject: Re: VAT is not applied for the shipping To be more clear, what have changed in trunk is the possibilit to have prices with VAT included and code was changed accordingly. So the ProductPrice and OrderAdjustment entities have changed but not The TaxAuthority data model, see http://svn.apache.org/viewvc?view=revisionrevision=1042542 IIRW there have been some code amendements after Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com It's the same in trunk Jacques From: biletnikov biletni...@gmail.com Hello Paul, thank you very much for your detailed explanation and solutions. I think the first way is the more appropriate for us for the first time, but I'm confused what we should do if we had in an order some items with shippable tax and some with free shipping tax? Also the each our product relates to the appropriate category. Is this problem actual only for 9.04 release, or the current trunk has it too? Best regards, Sergei On Wed, Feb 2, 2011 at 8:57 AM, Paul Foxworthy [via OFBiz] ml-node+3253480-393799844-170...@n4.nabble.comml-node%2b3253480-393799844-170...@n4.nabble.com wrote: Hi Sergei, The trouble is that in the rateProductTaxCalc method, getTaxAdjustments is called once per product, plus once for shipping and once for adjustments. In trunk these are lines 218, 244 and 228 in https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/tax/TaxAuthorityServices.java?hb=true When we call getTaxAdjustments for shipping and promotion, there's no product, so the product category matching won't work. My change was to look for rows with taxShipping of Y when there's no product. If your shipping is always calculated for an order and not by individual order items, you could set taxShipping to Y for one row in TaxAuthorityRateProduct (TARP) and N for the others. A bit of a hack, but it would work. Another possibility is to define a new TAXABLE product category independent of any other, so you only need one row in TARP. The problem with this is you need to assign a product to the TAXABLE category as you create the product. For me in Australia, pretty well everything is taxed, so most products would need the category set. A third way, again a hack, is to create a dummy product category that no product has, and add a row to TARP with taxShipping of Y. All other TARP rows would have taxShipping of N. A better fix would need more consideration and more work. Some possibilities I can think of: - Add a new column to TARP, perhaps called something like taxRuleType or taxScope. It would have values PRODUCT, SHIPPING, PROMOTION. You would add separate rows for tax rules for shipping and promotion. Each of the three calls to getTaxAdjustment would supply a parameter to say which taxRuleType to search for. - Define entirely separate entities for tax rules for shipping and promotions rather than overload TARP Cheers Paul Foxworthy -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/VAT-is-not-applied-for-the-shipping-tp3234699p3253480.html To unsubscribe from VAT is not applied for the shipping, click herehttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3234699code=YmlsZXRuaWtvdkBnbWFpbC5jb218MzIzNDY5OXwyMDcwNzk3NDQ4. -- Best regards, Sergei Biletnikov -- View this message in context: http://ofbiz.135035.n4.nabble.com/VAT-is-not-applied-for-the-shipping-tp3234699p3253536.html Sent from the OFBiz - User mailing list archive at Nabble.com.