Skip to main content
P
ptc-55038601-Visitor
1-Visitor
February 5, 2014
Solved

Is there an easy way to pull down into a spreadsheet a list of the objects shown in Integrity’s Change Packages tab

  • February 5, 2014
  • 1 reply
  • 2682 views

Is there a way to export the Change Package information for an item in a similar way to exporting the items in a query to excel in MKS Integrity 10.

    Best answer by matt_giltaji

    Hi Anjan,

    While not as easy as the one click export to excel functionality, you can copy paste cp info from the client GUI into an excel sheet.

    Go to Change Package ->Find...

    Switch to the "By ID" tab in the window that pops up.

    Enter the Item ID in the "ID:" field

    (You could also pick a query on the "By Query" tab if you need to pull change packages for multiple items)

    Click "OK"

    This should open up a new tab (or a new window, it depends on your viewset options in the Client) with a list of all the change packages for those item IDs.

    You can right-click on the column headings to add other fields to the view, or left click the column header to sort, just like a query results tab.

    Select all the CPs in the view and press control-C to copy them

    Paste them into an open Excel worksheet.

    This might also work for other spreadsheet programs, but I have only tested it with Excel.

    Hope that helps,

    Matt

    1 reply

    D
    dhegland1-Visitor
    1-Visitor
    February 5, 2014

    Along with some parsing, you can use the command line, si.exe viewcps, and pipe the output to a file. You'll need to use the fieldsDelim option and you'll be vulnerable to the delimiter occurring within fields you select, so watch for that.

    M
    matt_giltaji1-VisitorAnswer
    1-Visitor
    February 5, 2014

    Hi Anjan,

    While not as easy as the one click export to excel functionality, you can copy paste cp info from the client GUI into an excel sheet.

    Go to Change Package ->Find...

    Switch to the "By ID" tab in the window that pops up.

    Enter the Item ID in the "ID:" field

    (You could also pick a query on the "By Query" tab if you need to pull change packages for multiple items)

    Click "OK"

    This should open up a new tab (or a new window, it depends on your viewset options in the Client) with a list of all the change packages for those item IDs.

    You can right-click on the column headings to add other fields to the view, or left click the column header to sort, just like a query results tab.

    Select all the CPs in the view and press control-C to copy them

    Paste them into an open Excel worksheet.

    This might also work for other spreadsheet programs, but I have only tested it with Excel.

    Hope that helps,

    Matt

      Terms & ConditionsAccessibility statement