How to Make Over 800 Resource Updates in 2 Minutes

Posted @ 10/26/2016  12:51 PM By Marc Latreille

CA PPM Excel Interface TutorialsAs staff roles and positions change, the impact and work required to make those changes throughout all of the resources in CA PPM projects are traditionally very time consuming and costly.

 


The PPM Excel Interface allows those changes to be made much more efficiently because everyone is used to using Microsoft Excel’s familiar UI. Also the technical know-how normally required to do the job is removed with IT-ROI’s automated XOG technology that the PPM Excel Interface provides for data extracts and pushes with CA PPM.

Watch the brief video and see how it’s done in under 2 minutes.

 


This work was performed using IT-ROI’s PPM Excel Interface, by simply following a few steps and using Excel’s native Drag & Drop, Cut & Paste, and Auto Complete functionality.

Steps Performed to Update Over 800 Resources in CA PPM.

1) Get all the Resource data from your CA PPM environment by selecting the Resources Interface from the “Get” drop down button. This will populate all the resource data in CA PPM for you by displaying it in an Excel sheet to edit and update.

2) Update the Resource Manager data you desire, you can filter the resources by using Excel’s out-of-the-box functionality. Save time by using Excel’s native Drag & Drop, Cut & Paste, and Auto Complete functionality.

3) Validate the data, and correct any typo mistakes that are highlighted in yellow.

4) Load your work back into CA PPM by simply clicking on the “Load” button.

5) Done.

Check out other business challenges and roles that the PPM Excel Interface solves.

We are happy to provide a customized demo on how the PPM Excel Interface can perform in your CA PPM environment.