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

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 Iprefer to use Apply PAtch option Tortoise in a 1st step (best SVN and CVS UI existingeither on Linux or Windows, besides Tortoise comes from Tigris too).
Then if I get problems with Tortoise (or Eclipse option wich is nearTortoise for patching but less supple for this option and far more ingeneral) I use patch command. To avoid EOL problems I use a bat filepatchdos.bat :

todos %1
patch -p0 < %1

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