ClearCase and ClearQuest

Expand all | Collapse all

Can I get data from CC into Excel?

  • 1.  Can I get data from CC into Excel?

    Posted Wed February 10, 2016 06:38 PM

    I recently upgraded to CC v8. I want to display some information about CC into an Excel dashboard, so I’m trying to automatically pull information from the back-end DB into Excel. I figured I should do this through ODBC or some API tool. I’m also investigating as to if it’s a possibility to query the CC database from Visual Studio or Microsoft SQL Server Development Studio. Any help is appreciated!



  • 2.  RE: Can I get data from CC into Excel?

    Posted Wed February 10, 2016 10:18 PM

    Yes, that is possible using VBA and the ClearCase Automation Library (CAL):

    http://www-01.ibm.com/support/docview.wss?uid=swg21123249

    I created Excel spreadsheets with menus that generate various ClearCase reports. Works great (although slow).

    Example:

    Set ctObj = CreateObject("ClearCase.ClearTool")
    rCode = ctObj("startview " & viewName)
    rCode = ctObj("mount " & pvobTag)
    rCode = ctObj("cd M:" & viewName & pvobTag)
    projectList = Split(ctObj("lsproject -fmt ""%[name]p\n"""), vbCrLf)

    ...gives you an array with all the projects in your PVOB.

    Jozef