cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

ptc-5503860
1-Newbie

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

2 REPLIES 2

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.

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

Top Tags