Added by Henry Fogwill over 10 years ago
I would like to share something I find very useful with Openproject.
We run Openproject on Ubuntu and we installed an ODBC driver on this server to connect to the Openproject tables.
In Windows I created a new DSN called Openproject and pointed this to my Production Openproject ODBC driver. I ensured to set this connection READ ONLY out of fear of destroying everything in Openproject with a bad update out of Excel.
With this connection I can pull all Openproject data into Excel and start looking at project data in very interesting ways.
Examples would be:
Overall we are pleased with how this works and believe we are just scratcing the surface on how this data can be used in Excel.