FAQ - Cookbook (work in progress)

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

I hope to integrate interesting points from
http://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ 
and http://www.opensourcestrategies.com/ofbiz/tutorials.php (OFBiz Cookbooks part). For the later it depends on OpenSource Strategies agreement (still waiting for it ;o)

But perhaps links to them may be sufficient... Until they diseappear... then I will see...

Changing a field type in Derby
Use cvv codes in OFBiz
Patching on Windows

Changing 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.

---- 

Use cvv codes in OFBiz

https://issues.apache.org/jira/browse/OFBIZ-767#action_12476855

Patching on Windows

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

That's why I prefer to use Tortoise's "Apply Patch" option in a 1st step. Tortoise is the best SVN and CVS UI existing, either on Linux or Windows. Besides Tortoise comes from Tigris too.
Then if I get problems with Tortoise (or Eclipse's "Apply Patch" option wich is near Tortoise for patching but less supple for this option and far more ingeneral) I use the patch command. Something to understand is that Tortoise actually use "SVN merge" so in certains cases problems arise.
To avoid EOL problems with the patch command, I use a bat file patchdos.bat :

todos %1
patch -p0 < %1

where todos is and exe to download. Of course you will have to deal with path. But at this stage I guess it's easy...