While trying to transfer some data from MySQL into OFBiz, I had to format these in XML. MySQL options came to the rescue.

The command line tool from MySQL have this cool option (mysql -X …)  that helps formatting any resultset into XML. I just had to do some text replacements and encoding then uploaded the data into OFBiz.