Page History

This page is intended to be the root of Cookbook, FAQ, Tips, Tricks, HowTo, etc.
You may find supplementary useful informations at Old OFBiz wiki and Opentaps's OFBiz cookbooks part but note that this information may be outdated...

...

• MISC Accounting Links
• Billing Account
• If you get accounting related issues and are not interested in posting accounting transactions, see here
• Show prices with VAT included in including VAT in eCommerce (retail, B2C)
• How are managed transactions in different currencies from the one of GL ?
• glAccountClass vs glAccountType : follow the links
• A thread about glAccountType
• Sage payment integration

Apache HTTPD (Apache Web server)

• How to use mod_proxy_ajp

• Apache ProxyPassReverse Directive advices
• Beware of HTTP ETag
• Sticky session load balancing with Apache and mod_balancer on Ubuntu Linux
• Install OFBiz with MariaDB, Apache2 Proxy and SSL

Ajax - Javascript - Json

• Take a look at DWR. I found this really easy to integrate with OFBiz. No complicated Javascript/JSON. Also, its Apache V2 licensed.
• Disabling right click: document.oncontextmenu=new Function("return false")
• Restrict your user to go back: window.history.forward(0

...

• Some details about SSL and X.509
• How to configure authorize.net certificatesGoogle Checkout Integration
• Here is a pretty good tutorial on getting your SSL certificate setup

...

• OFBiz HTML Element Collection Styles
• If you get this problem The horizontal menu in the right column is causing the HTML elements below it to drop down to the bottom of the screen

DataBase

• Derby

  • Change a field type in Derby

  • Browse a Derby database and more using SQuirrel

• Miscellaneous

  • OFBiz's Data File Tools Some tips from Jacopo

  • How to use EntityWhereString A tip from GrimTim
  • How to troubleshoot SQL errors A tip from Chris Lombardi
  •  How to measure SQL queries durations
  •  How to use OFBiz on read only database
    
  • Tips for View Entities A tip from SkipDever
  • How to connect to an External Database A tip from Adrian Crum
  • How to save customised data for import as demo data A tip from Raj Saini
  • Is it possible to delete products, categories, catalogs, etc., that are no longer needed?
  • About lastUpdatedStamp, lastUpdatedTxStamp (transaction), createdStamp, and createdTxStamp
  • Why primary keys are VAR_CHAR type in OFBiz ? A tip from David E. Jones

• MySQL

  • MySQL Issues

• Oracle

  • Some tips from Jacopo

• PostgreSQL

  • Tune your PostgreSQL installation a tip from Mike <mz4wheeler@gmail.com>

  • Setup OFBiz version 16.11.02 with PostgresSQL on Windows (from Do Nhu Vy)

• MariaDB

  • Install OFBiz with MariaDB, Apache2 Proxy and SSL

Development tips

• From Ant to Gradle

• How to run multiple ofbiz instances on one PC: see technical production setup guide, section URL and Port Settings

• What is the best practice to modify an existing component or create a new one?

• What is considered the best practice in creating a custom web application with OFBIZ?
• How to Extend an existing component in customized application?
• How to manage your source differences?
• Variables always available in screen context
• Tips & Tricks while working with Groovy
• Deprecating entities
• Add a WAR file
• Using locale XSD files instead of OFBiz remote (at http://ofbiz.apache.org/dtds) for validation and content completion
• UBPL Introduction
• Ofbiz as a development framework - release 9.04
• Ofbiz as a development framework - upcoming release 10.04
• Field Description tooltip help
• How to not have a string escaped for html : org.ofbiz.base.util.StringUtil.wrapString(uiLabelMap.yourString)
• Turning Firefox cache on/off (mostly for javascript testing)
• Validation in forms
• How to change the default messages
• Profiling Ofbiz with YourKit in Eclipse
• Note on creating a view-entity using entity or view-entity from other components
• When and when not restarting
• What is the difference between [+0] and [] in a widget screen file?

Eclipse IDE

• Running and Debugging OFBiz in Eclipse

• Eclipse Tips
• Browsing Derby Database in Eclipse
• Profiling Ofbiz with YourKit in Eclipse

...

• Setup Intellij IDEA IDE for OFBiz Framework - Guide applicable for OFBiz 16.11.x and above, and for Linux-based or Mac working environment.

• Running and Debugging OFBiz in Intellij IDEA - Guide applicable for OFBiz 16.11.x and above.

Known issues

• Dash vs "en dash" in Gradle commands

Licences

• Apache Software Foundation

...

• VeriSign PayFlow Pro set up
• Use cvv codes in OFBiz
• Using gift-card in OFBiz

POS (the POS is deprecated and has been put in Attic)

...

• Monitoring and Maintaining the database
• Cleaning the database from unimportant data
• Users with disabled accounts are still able to login
• How to make redirection inside an application server without using mod_rewrite
• Handling of External data
• OAGIS
• How to hide products in eCommerce ?
• Performance : Server Hardware for Ofbiz hosting
• Load balance across multiple instances of OFBiz
• Custom Components in OFBiz
• Take advantages of a custom component
• How to use the Setup application It's a bit long ot load has it must create dynamically the documentation. You may prefer to simply use the Help in OFBiz itself...
• how to set the Distributed Entity Cache Clear Mechanism

...

• Getting and Running OFBiz in 5 steps (look, there are more Quick Start Guides under Jacopo's Wiki space)

RMI

• This RMI error on client side?, click to see the tip

  Code Block
  Caused by: java.util.MissingResourceException: Can't find bundle for base name cache, locale en_US

  
  

  
  

• How to use RMI without SSL
• How to test easily if RMI is working (using a simple client)
• Somethings you should know about RMI

Reporting tools

• Birt Flexible Reports
• Birt : how to integrate in OFBiz
• Jasper : how to integrate in OFBiz

...

• Plugin search tools for Firefox using Nabble or Mark Mail
• To search in OFBiz spaces instead of all Apache Wiki (Apache cwiki is shared among Apache projects) use the OFBiz wiki search

Selenium

• Some Selenium tips

Soap / XML-RPC / REST

...

• To unsubscribe You certainly forgot how you subscribed, it's easy to forgot if you use a Nabble forum to subscribe.

Windows

• Patch on Windows

• Run OFBiz as a Windows service
• Export to Excel
• Import from Excel
• Windows 10

Workflow Engines

• What's the recommended workflow engine in OFBiz? Is it Shark?

XSL:FO (FOP)

• Is there any WYSIWYG editors for XSL:FO ?

• Fonts in FOP

ZK (work in progress)

A tuto (screencast) for a ZK view handler

...

If you really need to do it, think about these 4 points before...

Show prices with VAT included in eCommerce (B2C)

For that in your store (Tax section) you must :

...

In order to show the prices including VAT in the store for consumers, you need to take following steps:

1. in the accounting component:
   1. adjust the data for the appropriate Tax Authority so that 'Include Tax in Price' = 'Y'
   2. associate the appropriate product categories under the 'Categories' tab of the Tax Authority
   3. set the appropriate product rate (for Value Added Tax)
   4. optionally set the flag for 'Tax Promotions'
   5. optionally set the flag for 'Tax Shipping'
2. in the catalog component for the appropriate store (in the section 'TAX':
   1. set the flag 'Show prices with VAT tax included' to 'Y'
   2. set the appropriate Vat Tax Auth Geo ID
   3. set the appropriate Vat Tax Auth Party ID

For

...

now you can't set a different VAT rate for shipping, see last

...

comment of

...