{"id":2694,"date":"2020-08-25T06:38:45","date_gmt":"2020-08-25T13:38:45","guid":{"rendered":"http:\/\/www.projectp.com\/ppblog\/?p=2694"},"modified":"2022-11-17T14:42:57","modified_gmt":"2022-11-17T22:42:57","slug":"freedom-to-read-write-data-with-activity-excel-utility-using-p6-eppm-web-services","status":"publish","type":"post","link":"https:\/\/www.projectp.com\/ppblog\/2020\/08\/25\/freedom-to-read-write-data-with-activity-excel-utility-using-p6-eppm-web-services\/","title":{"rendered":"Freedom to Read &#038; Write Data with Activity Excel Utility Using P6 EPPM Web Services!"},"content":{"rendered":"<p><strong><em><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2701\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280.jpg\" alt=\"\" width=\"1280\" height=\"853\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280.jpg 1280w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280-300x200.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280-768x512.jpg 768w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/office-4776820_1280-1024x682.jpg 1024w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/a><\/em><\/strong><\/p>\n<p><strong><em>Project Partners Blog Author:<br \/>\n<span style=\"color: #3366ff;\">Sachin Gupta | Oracle Primavera Solution Architect &#8211; Application Integration Specialist<\/span><\/em><\/strong><\/p>\n<h1 class=\"post-title entry-title\"><span style=\"color: #000000;\">Activity Excel Utility Using P6 EPPM Web Services<\/span><\/h1>\n<p>P6 EPPM Web Services is a great way of integrating external systems with the P6 EPPM application. Activity excel utility allows reading and writing data to Oracle Primavera P6 EPPM using P6 EPPM Web Services.<\/p>\n<p>Activity excel utility allows the user to:<\/p>\n<ul>\n<li>Maintain activity details<\/li>\n<li>Maintain activity relationship<\/li>\n<li>Assign global and project activity codes to the activity<\/li>\n<li>Assign resource or role to the activity<\/li>\n<li>Maintain activity steps<\/li>\n<li>Maintain activity UDF<\/li>\n<li>Maintain resource assignment UDF<\/li>\n<li>Maintain activity step UDF<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2695\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-1.png\" alt=\"\" width=\"660\" height=\"321\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-1.png 660w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-1-300x146.png 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p>Update Project List \u2013 download the list of projects from the connected P6 EPPM application<\/p>\n<p>Read All Data &#8211; allows downloading all activity data at the click of a button<\/p>\n<p>Clear All Data &#8211; removes data from all worksheets<\/p>\n<p>Read \u2013 Read or download data from P6 EPPM using Web Services<\/p>\n<p>Modify \u2013 Create, Update or Delete the data for the corresponding business object<\/p>\n<p>Screenshots of some of the worksheets are shown here for reference<\/p>\n<p><u>Activity Details<\/u> allows creating of new activity and maintenance of existing activity data. CRUD flag is used to identify the operation to be performed<\/p>\n<p>\u201cC\u201d \u2013 Create, \u201cU\u201d \u2013 Update, \u201cD\u201d \u2013 Delete, \u201cR\u201d \u2013 Read.<\/p>\n<p>Activity data is downloaded with CRUD flag as \u201cR\u201d<\/p>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2696\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-2.png\" alt=\"\" width=\"659\" height=\"87\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-2.png 659w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-2-300x40.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>Activity attributes like Duration Type, % Complete Type, etc., use the same set of values as in the application.<\/p>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2697\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-3.png\" alt=\"\" width=\"681\" height=\"509\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-3.png 681w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-3-300x224.png 300w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/a><\/p>\n<p><u>Activity Relationship<\/u> can be created and updated within the excel utility. Relationship Type has a predefined set of values as used in the application &#8211; Task Dependent, Resource Dependent, Level of Effort, Start Milestone, Finish Milestone, WBS Summary.<\/p>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2698\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-4.png\" alt=\"\" width=\"664\" height=\"124\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-4.png 664w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-4-300x56.png 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p><u>Activity Code Assignment<\/u> allows the user to assign activity code to activities. Both global and project-specific activity codes can be assigned to activities.<\/p>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2699\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-5.png\" alt=\"\" width=\"662\" height=\"131\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-5.png 662w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-5-300x59.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/a><\/p>\n<p><u>Resource Assignment<\/u> allows users to assign resources\/roles to activities. This can be used to maintain resource assignments for activities of the project.<\/p>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-2700\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-6.png\" alt=\"\" width=\"660\" height=\"115\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-6.png 660w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/08\/Activity-6-300x52.png 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p>The user interface for all other worksheets is similar to the one shown above.<\/p>\n<p>Download the evaluation copy <a href=\"https:\/\/github.com\/sacgupta1\/p6excel\/raw\/master\/Activity_V1.1.xlsm\">here<\/a>.<\/p>\n<p style=\"text-align: center;\">\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<\/p>\n<p style=\"text-align: center;\">Project Partners, a long-standing Oracle Partner and global leader in optimizing business processes and IT investments within project-driven organizations.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.projectp.com\/\">www.projectp.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Understand how to use the Activity Excel Utility using the Oracle Primavera P6 EPPM Web Service. Maintain activity levels, activity relationships, activity steps, activity UDF, and more! In this blog, we will walk you through the user interface and what each feature provides for your users: <\/p>\n","protected":false},"author":79,"featured_media":3187,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[75],"tags":[],"class_list":["post-2694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-primavera"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/2694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/comments?post=2694"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/2694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media\/3187"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=2694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=2694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=2694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}