Can Dictionary excel utility based on P6 EPPM Web Services replace
Dictionary.xls P6 SDK? Lets find it out.
Dictionary excel utility allows reading and writing data to
P6 EPPM using P6 EPPM Web Services. Supported business objects are shown in the
screenshot below.
Read All Data - allows downloading all data at the click of
button.
Clear All Data - removes data from all worksheet
Read – Read or download data from P6 EPPM using Web Services
Modify – Create, Update or Delete the data for the
corresponding business object
Screenshots of some of the worksheet are shown here for
reference.
Resources can be created, updated and deleted from the excel utility.
CRUD flag is used to identify the operation to be performed.
“C” – Create, “U” – Update, “D” – Delete, “R” – Read.
When the data is downloaded all resources will have CRUD flag
as “R”
Resource Curve can be created and updated within excel utility including
updating values for the curve.
User information includes global profile which can be modified in
excel utility. Module access information is read only and for information
purpose only.
Cost Account hierarchy can be developed in the excel utility as well.
User interface for all other worksheets are similar to the
one shown above. Data can be read and maintained offline in this excel utility and synchronized with the application after it is finalized.
Click here for evaluation copy. Drop me a message, if you are unable to download the evaluation copy.
Click here for evaluation copy. Drop me a message, if you are unable to download the evaluation copy.
Next article will cover WBS excel utility.
No comments:
Post a Comment