Apache OfBiz Cookbook

Apache OfBiz Cookbook

Overview of this book

Apache Open For Business (OFBiz) is an enterprise resource planning (ERP) system that provides a common data model and an extensive set of business processes. But without proper guidance on developing performance-critical applications, it is easy to make the wrong design and technology decisions. The power and promise of Apache OFBiz is comprehensively revealed in a collection of self-contained, quick, practical recipes in this Cookbook. This book covers a range of topics from initial system setup to web application and HTML page creation, Java development, and data maintenance tasks. Focusing on a series of the most commonly performed OFBiz tasks, it provides clear, cogent, and easy-to-follow instructions designed to make the most of your OFBiz experience. Let this book be your guide to enhancing your OFBiz productivity by saving you valuable time. Written specifically to give clear and straightforward answers to the most commonly asked OFBiz questions, this compendium of OFBiz recipes will show you everything you need to know to get things done in OFBiz. Whether you are new to OFBiz or an old pro, you are sure to find many useful hints and handy tips here. Topics range from getting started to configuration and system setup, security and database management through the final stages of developing and testing new OFBiz applications.

Apache OFBiz Cookbook

Credits

About the Author

About the Reviewers

Preface

Free Chapter

Getting Started

Introduction

Getting the project code

Getting code from the Subversion repository

Fixing IP port collision errors

The JAVA_HOME setting

"Class Not Found" errors

Installation verification

SSL verification

Running JUnit tests

Locating an OFBiz Component

Locating an OFBiz Application

Java Development

Introduction

Java runtime CLASSPATH

Java compile time CLASSPATH

Naming conventions

Writing OFBiz Java Events

Writing OFBiz Java Services

Debugging using the logfile

Calling OFBiz Services from a Java program

Getting and validating request parameters (Events)

Getting and validating request parameters (Services)

Managing error messages

Using Java properties files

Sending e-mail from an OFBiz Event or Service

Handling XML files

The User Interface

Introduction

Creating HTML web pages

Adding actions to Screen widgets

HTML markup in Screen widgets

CSS styling in Screen widgets

Platform-specific widgets

OFBiz Tree widgets

OFBiz Menu widgets

OFBiz Form widgets

Creating web pages using FreeMarker

Passing Screen widget parameters to FreeMarker

Calling Java methods from FreeMarker

Forcing FreeMarker to render HTML markup

Uploading files in FreeMarker forms

OFBiz Services

Introduction

Managing existing OFBiz Services

Calling a Service from an HTML form

Calling asynchronous Services from HTML forms

Calling a Service many times from an HTML form

Creating a new Service definition file

Creating a new Service definition

Implementing Services

Defining Service attributes (INPUT/OUTPUT)

Service Event Condition Actions

Service groups

Handling Service errors

Writing Groovy Services

Mail Event Condition Actions

Entity Event Condition Actions

The OFBiz Entity Engine

Introduction

Changing the default database

Connecting to a remote database

Connecting to multiple databases

Creating entity groups

Disabling automatic database checks

Mapping database data types

Creating a new entity model

Modifying an existing entity model

Building a view-entity

OFBiz Security

Introduction

Securing communications ports

Disabling demonstration user accounts

Protecting OFBiz web pages

Creating user accounts

Protecting applications using security groups

Protecting views ("Tarpitting")

Retrieving forgotten passwords

Changing your password

Adding or changing SSL certificates

OFBiz single sign-on and the external login key

WebTools

Introduction

Cache maintenance

Changing debug settings

Exporting database data to XML documents

Loading database(s) from XML documents

Managing internationalization labels

Using the SQL processor

Exploring the entity reference tool

Viewing OFBiz usage statistics

Uncovering artifact information

Working with temporal expressions

Web Services

Introduction

Requesting web services using URL parameters

Requesting web services using an HttpClient

Creating HttpClients and passing XML documents

Creating XML-RPC web service clients

Becoming an XML-RPC web service provider

OFBiz SOAP messaging clients

Generating a WSDL document

Creating SOAP-compliant web services

OFBiz Tips and Tricks

Introduction

Fixing Java memory allocation errors

Reloading OFBiz seed and demo data

Creating new seed data files

Changing the administrative user's password

Creating a new administrative user

Getting the OFBiz version number

Building an OFBiz instance

Building a single OFBiz Component

Creating a new OFBiz Component or Application

Creating a FreeMarker transform

Preparing data using Groovy

Pop-up new browser windows

Installing an OFBiz Visual Theme

Creating an OFBiz Visual Theme

Entity Engine by Example

Introduction

Putting it all together with a data model example

Reading data from an OFBiz data source

Working with large result sets (EntityListIterator)

Removing data from the database (Java)

Writing data to the database (Java)

Using the automatic sequence generator

EntityUtil

EntityOperator reference

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Appendix A. Entity Engine by Example

In this chapter, find the following topics discussed:

Putting it all together with a data model example
Reading data from an OFBiz data source
Working with large result sets
Removing data from an OFBiz data source
Writing data to an OFBiz data source
Using the EntityUtil utility programmatically
The OFBiz automatic sequence generator
An entity operator reference

Introduction

In this chapter, we depart from the usual book format to offer useful Entity Engine hints and tips by way of examples. Each example is designed to help you master some aspect of the OFBiz Entity Engine. Intended for Java developers (and Groovy/BeanShell enthusiasts), you will find many details here offered to optimize your use of the OFBiz Entity Engine and add data-driven features to your own OFBiz Applications.

Note

Before we get started, a few ground rules:

The Entity Engine deals with "data sources" and "entities". In many cases, we shall be referring to the concrete instantiation of a "data source" as a database and "entities" as database tables respectively. This is intentional as in the real world you are not likely to encounter a "data source", but rather a database.

Similarly, OFBiz entities only have meaning within the context of OFBiz. For all practical purposes, an OFBiz entity is the model of a relational database table. In a relational database, tables have column names that are referred to here as "fields". Data is stored in database table records. Records and the term "rows" are used interchangeably here.

Apache OfBiz Cookbook

Apache OfBiz Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Apache OfBiz Cookbook

Appendix A. Entity Engine by Example

Introduction

Note