How can I upload MS Project Manager file directly in to QV? Is it possible at all?
For now, I just copy-paste the data from MS PM into Excel and upload that to QV - this however, is not 100% reliable as I am missing daily "resource allocation" - i.e. a project may last for 5days but those 5 days could be spread over 30 days period, therefore cannot see when a resource is available on day-to-day basis.
I don't think a direct import can be possible... However, there must be a better way than "copy-paste". I think MS Project can extract data into a text file, and then the text file can be loaded into QlikView. You should be able to determine what MS Project data elements should be extracted into the text file.
The only way to do anything "directly" could be if there was an ODBC driver or an OLE DB provider capable of reading MS Project files directly.
1. If using versions earlier then MS Project 2007, ODBCconnector is available through which we can extract.
2. If using MS Project 2007 you can save your work on a format useable by earlier versions of MS Project, and then these files could be accessible via OBDC. Because OBDC is eliminated in MS Project 2007 because ofsome security issues, 2007 uses SOAP over Http and Https. SOAP is in XMLformat( access able through QV)
3. Or upgrade to either EPM(Enterprise Project Management) or MS Project Server 2007 or ProjectProfessional 2007, and the files can be saved a XML, that is readable byQV.
4. Or they can use visual reports for OBDC Solution, that can be saved as text files(also readable by QV).
