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.