Absent Member.. Absent Member..
Absent Member..

how to export status dependencies to excel


My manager asked me to enter all fileds, fields' visibility, editablelity in each state to an excel file.

Is there any quick way to do this.

I opened case but supporter said that there is not any wway in workbracnh to export a request.


Is there any quick query to obtain all fields and the users can view field, can update field in all statuses.


2 Replies
Established Member..
Established Member..

Re: how to export status dependencies to excel

You can run following report to get all the details; but you cannot export to excel, rather you need to copy the data in excel and need to do some formatiing.


Under Administrative Category: ( in report submission make sure to check all the radio button or as required)


1. Request Type Detail Report

2. Request Header Type Detail Report

Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Absent Member.
Absent Member.

Re: how to export status dependencies to excel

While the Detail Reports will collect the data for you, it doesn't put the data into the format that your manager is looking for.  I was given this spreadsheet with a macro and embedded DB Code that will not only pull the data back that you need, but allow you to update the Status Dependencies from the spreadsheet and push them back to PPM.


This was developed by Mercury, not by me, and I am only providing this as a service.  I am not intimately familiar with the backend code to be able to support anything beyond casual usage of this tool.  I have used this tool with versions 6.0, 7.1, 7.5, 8.0, and 9.1 without any problems.  The first worksheet has a package spec and body that needs to be loaded into the PPM schema and Macros need to be enabled in Excel for this to work correctly.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.