This page is intended to be the root of cookbooks and/or FAQ (work in progress FAQ and cookbook Cookbook, FAQ, Tips, Tricks, HowTo, etc. (will perhaps be separated later).

I'm in the process of  integrating interesting points fromhttp://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ&nbsp

I would to integrate interesting points from http://www.opensourcestrategies.com/ofbiz/tutorials.php (OFBiz Cookbooks part)

...

but I don't know the licence status.

Tables of content  

Ajax - Javascript - Json

• Disable Browser Cache for Module
• Integrate OFBiz with Yui-Ext
• An easy way to get a data structure from server to Javascript in client browser

Birt

• How to integrate in OFBiz

DataBases

        Derby

• Change a field type in Derby
• Working with multiple Derby databases
• Browse a Derby database and more using SQuirrel

       Oracle

• Some tips from Jacopo

        OFBiz's Data File Tools

• Some tips from Jacopo

Eclipse

• Running and Debugging OFBiz in Eclipse
• Useful tips

Lamba Probe

• Adding Lamba Probe in OFBiz for monitoring Tomcat

Miscellaneous

• VeriSign PayFlow Pro set up
• Use cvv codes in OFBiz

Nabble 

• Search in Nabble OFBiz forum from Firefox 

Netbeans

• OFBiz in NetBeans
  This page may be a bit outdated but most informations are still relevant. You should also look at the nbproject.zip file in https://issues.apache.org/jira/browse/OFBIZ-3

Production Tips

• Monitoring and Maintaining the database
• Cleaning the database from unimportant data

Quick Start Guides

• Getting and Running OFBiz in 5 steps

Selenium

• Some Selenium tips

Windows

• Patch on Windows
• Run OFBiz as a Windows service
• Export to Excel

FAQ - TIPS - Cookbook - How to 

Change a field type in Derby 

1. Export the table to xml
2. Drop the table
3. Start OFBiz - table recreated with new structure
4. Import xml data from #1

Advice from Adrian Crum.

Browse a Derby database and more using SQuirrel

http://db.apache.org/derby/integrate/SQuirreL_Derby.html#N101C7
For the URL use something like jdbc:derby:c:/ofbiz/runtime/data/derby/ofbiz (of course using your right path)

Link from Sundeep Ray. There is an alternative to this solution : http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse#RunningandDebuggingOFBizinEclipse-Connectingthedatabase

Use CVV (also called CV2 and more acronyms) codes in OFBiz

As of rev. 585172 (date 2008-10-16) the changes mentioned below have been officially included in the OFBiz trunk.

...

Ajax : Disable Browser Cache for Module

http://docs.ofbiz.org/x/CAo

A tip from Krzysztof Podejma

Ajax : Integrate OFBiz with Yui-Ext

http://www.nabble.com/Re%3A-integrate-OFBiz-with-Yui-Ext-p11131937.html

...

Patch on Windows

Creating patches

Using Eclipse => Subclipse (Create Patch, Apply Patch context menu options)

...

I let you find the tools (Eclipse/Subclipse, Tortoise, Subversion client, patch.exe, todos.exe with google ;o)

Applying patches

To patch on Windows you have to download patch.exe. But you may encouter EOL problems with patch.exe.

...

Run OFBiz as a Windows service

• You need JavaService.exeThis is freely available at http://javaservice.objectweb.org/.
  Documentation and example code are also available
  Unzip the JavaService-bin-1.2.x.zip (or JavaService-2.0.x.zip)
• Where should the expanded files be located?
  Set up and run your script with the appropriate path. Ex:

  Code Block
  javaservice -install OFBiz %java_home%\jre\bin\server\jvm.dll -Xms256M -Xmx512M -Djava.class.path=%java_home%\lib\tools.jar;%ofbiz_home%\ofbiz.jar -start org.ofbiz.base.start.Start -out %ofbiz_home%\logs\serviceLog.txt -err %ofbiz_home%\logs\serviceErr.txt -current %ofbiz_home% -manual

  
  
  
  Note: If your java sdk is installed under a directory with a space in it, the service will install, but not start properly, unless you change java_home to the DOS 8.3 name. For example, if your java sdk is installed in C:\Program Files\Java\j2sdk1.4.2_xx then you would set java_home=C:\PROGRA~1\Java\j2sdk1.4.2_xx* Go to the win2k services app and you should now find a service 'OFBiz' set up to run manually (this of course can be changed to run automatically if so desired).

...

Some Selenium tips

Due to some license issues with external libraries used in Selenium we cannot include this in the Apache trunk. However, a new component has been created which is free to download and use, but lives in an ofbizext repository.
https://svn.hotwaxmedia.com/svn/ofbizext/selenium Drop this in hot-deploy. If you want to know more, please look at https://issues.apache.org/jira/browse/OFBIZ-680

1) For running "successive" test cases I used browser "Refresh" button but I think there might be some better option to handle this. Is there any option exists in Selenium IDE ?
If you want to chain execution of different tests, there is the notion of test suite. A list of tests to run one after the other (see http://labs.libre-entreprise.org/plugins/scmcvs/cvsweb.php/ofbizNeogia/neogia/manufacturing/webapp/manufacturing/tests/ManufacturingTestSuite.html?rev=1.9;content-type=text%2Fplain;cvsroot=neogia)

...