{"id":7548,"date":"2014-07-21t10:02:01","date_gmt":"2014-07-21t14:02:01","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=7548"},"modified":"2019-10-09t13:30:36","modified_gmt":"2019-10-09t17:30:36","slug":"primavera-p6-calendar-print","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/","title":{"rendered":"how to print a calendar from primavera p6, with some help"},"content":{"rendered":"

in this quick tutorial we show how to create a 12-month formatted calendar in excel based on the data extracted from an xer file using the handy xer-reader utility<\/a>.<\/p>\n

hopefully i will soon provide a more technical explanation on how the code works in the xer reader\u00a0wiki<\/a>.<\/p>\n

michael has written excellent article<\/a> about calendars and the biggest problem with primavera p6 calendars, and how you can fix it<\/a> – go and read it.<\/p>\n

1) get a copy of\u00a0the\u00a0xer-reader\u00a0utility<\/strong><\/h3>\n

if you don’t have a copy of the excel-based xer-reader utility, get it now<\/a>. we are going to use the abp cst p6 schedule file v1.6.xer (included in the xer-reader files) as an example file for our calendar print. so you can try it too.<\/p>\n

2) load your primavera p6 xer project in xer-reader<\/h3>\n

click “load xer” and browse to your xer file to get it loaded in xer-reader.<\/p>\n

3) select a calendar to view<\/strong><\/h3>\n

click on the calendars button, and select the calendar to view. the year will default to the current year, but you can overwrite it.<\/p>\n

\"input-calendar\"<\/p>\n

4) click show<\/strong><\/h3>\n

\"calendar-in-excel\"<\/p>\n

when you hover the mouse over the cells for exception and inheritance from global calendar, you can see the hours per day.<\/p>\n

as an example the day 21\/2\/2014 is an exception as it has\u00a0only 6 hours, as you can see from p6 view<\/p>\n

\"p6-view-of-calendar\"<\/strong>wrap up<\/strong><\/h3>\n

it is only a proof of concept, i am sure the printout can be improved.<\/p>\n

now if you are reading this, probably you are asking yourself, how come we still can not print a calendar from p6?<\/p>\n


\n\"\"<\/a><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

in this quick tutorial we show how to create a 12-month formatted calendar in excel based on the data extracted…<\/p>\n","protected":false},"author":10,"featured_media":7556,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[26,55],"tags":[214],"content-topics":[],"class_list":["post-7548","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-primavera-p6-tutorials","tag-primavera-p6-calendars"],"acf":[],"yoast_head":"\nhow to print a calendar from primavera p6, with some help<\/title>\n<meta name=\"description\" content=\"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how to print a calendar from primavera p6, with some help\" \/>\n<meta property=\"og:description\" content=\"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\" \/>\n<meta property=\"og:site_name\" content=\"世界杯2022亚洲比赛时间 \" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/planacademy\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-21t14:02:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-09t17:30:36+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"240\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"mimoune djouallah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@planacademy\" \/>\n<meta name=\"twitter:site\" content=\"@planacademy\" \/>\n<meta name=\"twitter:label1\" content=\"written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mimoune djouallah\" \/>\n\t<meta name=\"twitter:label2\" content=\"est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\"},\"author\":{\"name\":\"mimoune djouallah\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5\"},\"headline\":\"how to print a calendar from primavera p6, with some help\",\"datepublished\":\"2014-07-21t14:02:01+00:00\",\"datemodified\":\"2019-10-09t17:30:36+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\"},\"wordcount\":274,\"commentcount\":17,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg\",\"keywords\":[\"calendars\"],\"articlesection\":[\"excel\",\"primavera p6 tutorials\"],\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"commentaction\",\"name\":\"comment\",\"target\":[\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#respond\"]}]},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\",\"url\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\",\"name\":\"how to print a calendar from primavera p6, with some help\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg\",\"datepublished\":\"2014-07-21t14:02:01+00:00\",\"datemodified\":\"2019-10-09t17:30:36+00:00\",\"description\":\"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg\",\"width\":300,\"height\":240,\"caption\":\"primavera p6 print calendar\"},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"how to print a calendar from primavera p6, with some help\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间 \",\"description\":\"project controls training & courses\",\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"potentialaction\":[{\"@type\":\"searchaction\",\"target\":{\"@type\":\"entrypoint\",\"urltemplate\":\"\/\/www.deco-dalles.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"propertyvaluespecification\",\"valuerequired\":true,\"valuename\":\"search_term_string\"}}],\"inlanguage\":\"en-ca\"},{\"@type\":\"organization\",\"@id\":\"\/\/www.deco-dalles.com\/#organization\",\"name\":\"世界杯2022亚洲比赛时间 \",\"url\":\"\/\/www.deco-dalles.com\/\",\"logo\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"width\":500,\"height\":159,\"caption\":\"世界杯2022亚洲比赛时间 \"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\"},\"sameas\":[\"https:\/\/www.facebook.com\/planacademy\",\"https:\/\/x.com\/planacademy\",\"https:\/\/www.linkedin.com\/company\/plan-academy\",\"https:\/\/www.youtube.com\/planacademy\"]},{\"@type\":\"person\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5\",\"name\":\"mimoune djouallah\",\"image\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ca40aff0de21819f129bea74d07ebbce?s=96&d=mm&r=pg\",\"contenturl\":\"https:\/\/secure.gravatar.com\/avatar\/ca40aff0de21819f129bea74d07ebbce?s=96&d=mm&r=pg\",\"caption\":\"mimoune djouallah\"},\"description\":\"mimoune is a project controls engineer with solid planning and cost experience in oil\/gas epc projects, drop him a line at mimoune.djouallah@gmail.com\",\"sameas\":[\"http:\/\/www.twitter.com\/mdjouallah\"],\"url\":\"\/\/www.deco-dalles.com\/author\/mimoune-djouallah\/\"}]}<\/script>\n<!-- \/ yoast seo premium plugin. -->","yoast_head_json":{"title":"how to print a calendar from primavera p6, with some help","description":"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/","og_locale":"en_us","og_type":"article","og_title":"how to print a calendar from primavera p6, with some help","og_description":"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.","og_url":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/","og_site_name":"世界杯2022亚洲比赛时间 ","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2014-07-21t14:02:01+00:00","article_modified_time":"2019-10-09t17:30:36+00:00","og_image":[{"width":300,"height":240,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg","type":"image\/jpeg"}],"author":"mimoune djouallah","twitter_card":"summary_large_image","twitter_creator":"@planacademy","twitter_site":"@planacademy","twitter_misc":{"written by":"mimoune djouallah","est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/"},"author":{"name":"mimoune djouallah","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5"},"headline":"how to print a calendar from primavera p6, with some help","datepublished":"2014-07-21t14:02:01+00:00","datemodified":"2019-10-09t17:30:36+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/"},"wordcount":274,"commentcount":17,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg","keywords":["calendars"],"articlesection":["excel","primavera p6 tutorials"],"inlanguage":"en-ca","potentialaction":[{"@type":"commentaction","name":"comment","target":["\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#respond"]}]},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/","url":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/","name":"how to print a calendar from primavera p6, with some help","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg","datepublished":"2014-07-21t14:02:01+00:00","datemodified":"2019-10-09t17:30:36+00:00","description":"using the xer-reader tool, we can get a quick printout of any primavera p6 calendar. handy for viewing an entire calendar all at once and printing it.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2014\/07\/how-to-print-calendars-primavera-p6-featured.jpg","width":300,"height":240,"caption":"primavera p6 print calendar"},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/primavera-p6-calendar-print\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"how to print a calendar from primavera p6, with some help"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间 ","description":"project controls training & courses","publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"potentialaction":[{"@type":"searchaction","target":{"@type":"entrypoint","urltemplate":"\/\/www.deco-dalles.com\/?s={search_term_string}"},"query-input":{"@type":"propertyvaluespecification","valuerequired":true,"valuename":"search_term_string"}}],"inlanguage":"en-ca"},{"@type":"organization","@id":"\/\/www.deco-dalles.com\/#organization","name":"世界杯2022亚洲比赛时间 ","url":"\/\/www.deco-dalles.com\/","logo":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","width":500,"height":159,"caption":"世界杯2022亚洲比赛时间 "},"image":{"@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/"},"sameas":["https:\/\/www.facebook.com\/planacademy","https:\/\/x.com\/planacademy","https:\/\/www.linkedin.com\/company\/plan-academy","https:\/\/www.youtube.com\/planacademy"]},{"@type":"person","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5","name":"mimoune djouallah","image":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ca40aff0de21819f129bea74d07ebbce?s=96&d=mm&r=pg","contenturl":"https:\/\/secure.gravatar.com\/avatar\/ca40aff0de21819f129bea74d07ebbce?s=96&d=mm&r=pg","caption":"mimoune djouallah"},"description":"mimoune is a project controls engineer with solid planning and cost experience in oil\/gas epc projects, drop him a line at mimoune.djouallah@gmail.com","sameas":["http:\/\/www.twitter.com\/mdjouallah"],"url":"\/\/www.deco-dalles.com\/author\/mimoune-djouallah\/"}]}},"_links":{"self":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7548","targethints":{"allow":["get"]}}],"collection":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/comments?post=7548"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7548\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/7556"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=7548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=7548"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=7548"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=7548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}