Sunday, March 6, 2016

[23] Generate XOG XML using Excel Template


I created this Excel Macro based XOG XML Generator originally in 2006 and then evolved it over time. This has limitation that it can't do loops within loops like Projects with multiple Tasks in it. For those kind of nested loop requirements, you can use Pentaho Kettle or any other ETL tool. For non-nested requirements this XOG Generator should be fine.

1. Download XOG Generator v2.01
2. Instructions and Sample available in Excel.