{"id":7915,"date":"2021-11-03t13:00:39","date_gmt":"2021-11-03t17:00:39","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1746"},"modified":"2021-11-08t10:53:47","modified_gmt":"2021-11-08t15:53:47","slug":"how-to-clean-an-xer-file-using-the-parser","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/","title":{"rendered":"how to clean a primavera p6 xer file using the xer file parser"},"content":{"rendered":"<p><span style=\"color: #ffffff;\">in the third part of our\u00a0primavera p6 databases and\u00a0data cleansing series, we will show how to use the parser to clean an xer file<\/span><\/p>\n<p>in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file. \u00a0but if you haven&#8217;t read them go back and read: xer file parser excel utility<\/p>\n<ul>\n<li>part 1: <a href=\"\/\/www.deco-dalles.com\/clean-up-primavera-p6-database\/\">6 ways to clean up your primavera database nightmare<\/a><\/li>\n<li>part 2: <a href=\"\/\/www.deco-dalles.com\/understanding-primavera-xer-files\/\">understanding primavera xer files<\/a><\/li>\n<\/ul>\n<h2>cleaning an xer file for import<\/h2>\n<p><i class=\"icon-warning-sign icon-2x\" style=\"color: red;\"><\/i> notice: the primavera xer file parser is not an officially supported utility. it may:<\/p>\n<ol>\n<li>be prone to errors<\/li>\n<li>break your xer files.<\/li>\n<li>cause other problem you or we didn&#8217;t even think about<\/li>\n<\/ol>\n<p>use it at your own risk. make lots of backups.<\/p>\n<p>if you are finding that importing xer files are slow, then you might want to check out <a href=\"\/\/www.deco-dalles.com\/clean-pobs-xer-file\/\">this article about pobs data<\/a>.<\/p>\n<h2>altering or removing an xer&#8217;s activity codes<\/h2>\n<p>important notes about activity codes in p6 :<\/p>\n<ul>\n<li>the eps activity codes need to exist in the database before you can import them, and they need to be defined in parent node where you are going to import your project, otherwise they will not be imported.<\/li>\n<li><span style=\"color: #000000;\">there is no way to import eps activity codes with a project unless you use the parser, or other tools like <a href=\"http:\/\/executiveportlets.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">xer manager<\/a>.<\/span><\/li>\n<li>using p6, global activity codes can be changed to project activity codes by copying the code and re-assigning them to activities &#8211; (a lot of work!) &#8211; or you can do that in the parser by changing one line &#8211; handy!<\/li>\n<\/ul>\n<p>we create a test project with three tasks; every task was assigned global code, project code and eps codes.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering or removing an xer's activity codes\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/1.jpg\" alt=\"altering or removing an xer's activity codes\" width=\"509\" height=\"108\" \/><\/p>\n<p>in the xer file, three tables are related to activity codes.<br \/>\nactvtype : activity codes<br \/>\nactvcode: activity code values<br \/>\ntaskactv: activity codes assigned to activities<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering or removing an xer's activity codes\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/2.jpg\" alt=\"altering or removing an xer's activity codes\" width=\"610\" height=\"288\" \/><br \/>\n1) click on project<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering or removing an xer's activity codes\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/4.jpg\" alt=\"altering or removing an xer's activity codes\" width=\"610\" height=\"67\" \/><br \/>\n2) note here the project_id is 3734.\u00a0click on actvtype.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering or removing an xer's activity codes\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/3.jpg\" alt=\"altering or removing an xer's activity codes\" width=\"482\" height=\"110\" \/><\/p>\n<h3>what can you change?<\/h3>\n<p>now you can change the activity code type.as an example, we will change<\/p>\n<p><strong>test1 from global to project<\/strong><\/p>\n<p>3) assign the project id 3734 under proj_id, and change the as_global to as_project.<\/p>\n<p><strong>test2 from eps to project<\/strong><\/p>\n<p>4) assign the project id and remove wbs_id, and change from as_eps to as_project.<\/p>\n<p>you can also remove all activity codes by deleting the rows in the table\u00a0actvtype.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering or removing an xer's activity codes\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/5.jpg\" alt=\"altering or removing an xer's activity codes\" width=\"398\" height=\"104\" \/><\/p>\n<h2>altering an xer&#8217;s calendars<\/h2>\n<ul>\n<li>p6 has three different types of calendar; global, project and resource.<\/li>\n<li>世界杯时间比赛时间
 in p6 can be assigned either a global or a resource calendar. (not a project calendar).<\/li>\n<li>if your project calendar inherits from the global calendar it will be exported too.<\/li>\n<\/ul>\n<p>in the sample xer we used all the types of calendar to showcase what changes you can do.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/18.jpg\" alt=\"altering an xer's calendars\" width=\"513\" height=\"107\" \/><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/6.jpg\" alt=\"altering an xer's calendars\" width=\"591\" height=\"496\" \/><\/p>\n<p>notice here that project_calendar_1 inherits holidays from a global calendar &#8211; standard 5 day workweek.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/7.jpg\" alt=\"altering an xer's calendars\" width=\"597\" height=\"498\" \/><\/p>\n<p>and here, project_calendar_2 does not inherit from a global calendar.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/8.jpg\" alt=\"altering an xer's calendars\" width=\"610\" height=\"200\" \/><\/p>\n<p>a resource can use either a global or resource-specific calendar.<\/p>\n<p>in the xer file, calendars are recorded in three tables:<br \/>\ncalendar: this is the calendar dictionary<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/10.jpg\" alt=\"altering an xer's calendars\" width=\"610\" height=\"78\" \/><\/p>\n<p>task : here you can find calendars assigned to activities.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/12.jpg\" alt=\"altering an xer's calendars\" width=\"610\" height=\"82\" \/><\/p>\n<p>rsrc : here you can find calendars assigned to 世界杯时间比赛时间
.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/11.jpg\" alt=\"altering an xer's calendars\" width=\"610\" height=\"67\" \/><\/p>\n<h3>what can you change?<\/h3>\n<p><span style=\"color: #000000;\">for the calendar is not a simple change of ca_base to ca_project.<\/span><\/p>\n<p>calendars are complicated data for example:<br \/>\nif a global calendar is assigned to a resource and a task, and you want to change it to project, you have to create another copy of the global calendar as a resource calendar and assign it to the resource.<br \/>\nproject calendars inherit only from the global calendars, so you can not simple chane the global to project.<br \/>\nso i think it is just better to add a prefix to all the calendars to make sure they will not clash with the existing calendars in p6 database and latter manually cleaning them in p6 client.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/13.jpg\" alt=\"altering an xer's calendars\" width=\"610\" height=\"115\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>or when you import the xer file make sure to change the template to insert new.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's calendars\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/24.jpg\" alt=\"altering an xer's calendars\" width=\"413\" height=\"164\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>why is this important?<\/h3>\n<p>p6 by default keeps the existing calendar, but p6 checks only the calendar name when importing. \u00a0in the case where you import a file that has the same name calendar but has different working period or holidays, p6 will assume it is the same and keep the existing, and then you end up with a different schedule.<\/p>\n<p><span style=\"color: #000000;\">obviously don\u2019t uses \u201cupdate existing\u201d<\/span> as it will update existing calendar and affect the existing schedule.<\/p>\n<h2>altering an xer&#8217;s 世界杯时间比赛时间
<\/h2>\n<p>resource dictionaries are stored in rsrc table. notice the resource rates are stored in a separate table rsrcrate.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/14.jpg\" alt=\"altering an xer's 世界杯时间比赛时间
\" width=\"387\" height=\"106\" \/><\/p>\n<h3>what can you change?<\/h3>\n<p>it is up to you can add a prefix to the 世界杯时间比赛时间
 and use the default keep existing or use the import option \u201cinsert new\u201d.\u00a0<span style=\"color: #000000;\">(but do not use &#8220;update exiting&#8221;.)<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/15.jpg\" alt=\"altering an xer's 世界杯时间比赛时间
\" width=\"540\" height=\"71\" \/><\/p>\n<h3>why it is important?<\/h3>\n<p>when you import a schedule, p6 will check only against the \u201crsrc_short_name\u201d, so if the imported schedule use the same short name \u201c r-2\u201d, but different price per unit, or even the new resource is non labor and the existing is labor p6 will keep the same.<\/p>\n<p><span style=\"color: #000000;\"> the implication is quite simple: the new imported schedule will have a different total cost.<\/span><\/p>\n<h2>altering an xer&#8217;s user defined fields<\/h2>\n<p>if you have to give only one reason to use the parser, probably it is for the udf, planners tend to use a lot of udf for temporary reason, they can be used as a calculated field in the global change, and some reason, planners use a lot of different names for the same item, for example for a bill item: billitem, pay item, id, item_number.<\/p>\n<p>in the sample xer, there are four udf, three at the activity level (#before start, #before finish, bill quantity)<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's user defined fields\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/18.jpg\" alt=\"altering an xer's user defined fields\" width=\"513\" height=\"107\" \/><\/p>\n<p>and one at the project level (notes).<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's user defined fields\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/19.jpg\" alt=\"altering an xer's user defined fields\" width=\"610\" height=\"108\" \/><\/p>\n<p>in the xer file, udf are recorded in two tables<\/p>\n<p>udftype : udf dictionary<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's user defined fields\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/20.jpg\" alt=\"altering an xer's user defined fields\" width=\"587\" height=\"116\" \/><\/p>\n<p>udfvalue: udf assignment<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's user defined fields\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/21.jpg\" alt=\"altering an xer's user defined fields\" width=\"542\" height=\"153\" \/><\/p>\n<h3>what can you change?<\/h3>\n<p>you have many options:<\/p>\n<ul>\n<li>you can delete udf that you don\u2019t need ( make sure to delete all the reference in all the tables otherwise you end with orphan records, and the xer will not be imported),<\/li>\n<li>add a prefix to those udf, so they can easily clean them later in the database.<\/li>\n<li>map to the existing udf, ( change the name of the udf to the existing one in the database)<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's user defined fields\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/22.jpg\" alt=\"altering an xer's user defined fields\" width=\"610\" height=\"93\" \/><\/p>\n<h2>altering an xer&#8217;s currencies<\/h2>\n<p>p6 export all the currencies in the database even if they are not used by the 世界杯时间比赛时间
, it make sense to delete those unused currencies.\u00a0the data is recorded into two tables:<\/p>\n<p>currtype: currency dictionary<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's currencies\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/16.jpg\" alt=\"altering an xer's currencies\" width=\"543\" height=\"120\" \/><\/p>\n<p>rsrc : currency used by the 世界杯时间比赛时间
<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"altering an xer's currencies\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/17.jpg\" alt=\"altering an xer's currencies\" width=\"414\" height=\"88\" \/><\/p>\n<p>the algerian dinar can be deleted as it is unused<\/p>\n<h2>other things you can alter<\/h2>\n<p>for the remaining data type (expense, project codes, issues, notebook, etc) download and have a look at the <a href=\"http:\/\/docs.oracle.com\/cd\/e16688_01\/technical_documentation\/schema_docs\/pm_70_schema.zip\">p6 database schema\u00a0documentation<\/a> , all tables, and tables interdependencies are detailed there.<\/p>\n<h2>wrap up<\/h2>\n<p>what else can be easier than opening a file? we do it every day instinctively, with dozen of documents (word, excel, pictures &#8230;).<\/p>\n<p>p6, as any database application, is different. when you open an xer file; in reality you are importing a huge number of data into your database. if you are a standalone user, that may be not that harmful, but if it is installation shared by other planners, that\u2019s becoming quite dangerous and inconvenient.<\/p>\n<p>the fundamental issue here is that the import of an xer file brings in all sorts of global data associated with the project you&#8217;re importing. what can be worst and a pure waste of time than if someone unintentionally alters that shared calendar or resource price\/unit after <a href=\"\/\/www.deco-dalles.com\/remove-resource-costs-from-xers-primavera-p6\/\" rel=\"noopener noreferrer\" target=\"_blank\">importing an xer file<\/a> &#8211; and you&#8217;re left trying to figure out why your data has changed?<\/p>\n<p>p6 is a power database application, and to maintain your database integrity, and avoid a huge waste of time and money, simple rules apply.<\/p>\n<ul>\n<li>implement a draconian security policy and ensure the privilege to import xer is governed by a clear procedure.<\/li>\n<li>limited access rights for the users &#8211; make different security profiles based on skills, planner, senior planner, etc.<\/li>\n<\/ul>\n<p>the xer fileparser is a handy tool, but it is manual and complicated as you need to understand how p6 record the data. if you import project occasionally, it is a perfect little utility. \u00a0but if you deal with a lot of external schedules, you may have a look at some commercial software that does this process in an automated way. i use xer manager myself.<\/p>\n<h2>download<\/h2>\n<p>download the xer file parser excel utility here:<\/p>\n<ul>\n<li><a href=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/01\/p6xerfileparserbuilder.xls\">p6xerfileparserbuilder.xls<\/a>\u00a0&#8211; ms excel 2003 and prior<\/li>\n<li><a href=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/01\/xerfileparserbuilder_2007.xlsm\">xerfileparserbuilder_2007<\/a>\u00a0&#8211; ms excel 2007 and later<\/li>\n<\/ul>\n<p><!--hubspot call-to-action code --><span id=\"hs-cta-wrapper-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-node hs-cta-3aeba69a-3395-4c7d-bcf9-21c89d3da072\"><!-- [if lte ie 8]>\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"http:\/\/cta-redirect.hubspot.com\/cta\/redirect\/297539\/3aeba69a-3395-4c7d-bcf9-21c89d3da072\"><img decoding=\"async\" id=\"hs-cta-img-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/297539\/3aeba69a-3395-4c7d-bcf9-21c89d3da072.png\" alt=\"\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\">\/\/ <![cdata[ hbspt.cta.load(297539, '3aeba69a-3395-4c7d-bcf9-21c89d3da072'); \/\/ ]]><\/script><\/span><!-- end hubspot call-to-action code --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>in the third part of our\u00a0primavera p6 databases and\u00a0data cleansing series, we will show how to use the parser to&#8230;<\/p>\n","protected":false},"author":10,"featured_media":53945,"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":[203],"content-topics":[],"class_list":["post-7915","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-primavera-p6-tutorials","tag-xer-file-parser"],"acf":[],"yoast_head":"<!-- this site is optimized with the yoast seo premium plugin v23.1 (yoast seo v23.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>how to clean a primavera p6 xer file using the xer file parser<\/title>\n<meta name=\"description\" content=\"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.\" \/>\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\/how-to-clean-an-xer-file-using-the-parser\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how to clean a primavera p6 xer file using the xer file parser\" \/>\n<meta property=\"og:description\" content=\"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\" \/>\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=\"2021-11-03t17:00:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-08t15:53:47+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\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=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\"},\"author\":{\"name\":\"mimoune djouallah\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5\"},\"headline\":\"how to clean a primavera p6 xer file using the xer file parser\",\"datepublished\":\"2021-11-03t17:00:39+00:00\",\"datemodified\":\"2021-11-08t15:53:47+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\"},\"wordcount\":1463,\"commentcount\":11,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg\",\"keywords\":[\"xer file parser\"],\"articlesection\":[\"excel\",\"primavera p6 tutorials\"],\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"commentaction\",\"name\":\"comment\",\"target\":[\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#respond\"]}]},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\",\"url\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\",\"name\":\"how to clean a primavera p6 xer file using the xer file parser\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg\",\"datepublished\":\"2021-11-03t17:00:39+00:00\",\"datemodified\":\"2021-11-08t15:53:47+00:00\",\"description\":\"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg\",\"width\":640,\"height\":480},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"how to clean a primavera p6 xer file using the xer file parser\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间
\",\"description\":\"project controls training &amp; 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\":\"required name=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 clean a primavera p6 xer file using the xer file parser","description":"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.","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\/how-to-clean-an-xer-file-using-the-parser\/","og_locale":"en_us","og_type":"article","og_title":"how to clean a primavera p6 xer file using the xer file parser","og_description":"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.","og_url":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/","og_site_name":"世界杯2022亚洲比赛时间
","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2021-11-03t17:00:39+00:00","article_modified_time":"2021-11-08t15:53:47+00:00","og_image":[{"width":640,"height":480,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/"},"author":{"name":"mimoune djouallah","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/d74132ed24e47694cf7c53c49e9e24a5"},"headline":"how to clean a primavera p6 xer file using the xer file parser","datepublished":"2021-11-03t17:00:39+00:00","datemodified":"2021-11-08t15:53:47+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/"},"wordcount":1463,"commentcount":11,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg","keywords":["xer file parser"],"articlesection":["excel","primavera p6 tutorials"],"inlanguage":"en-ca","potentialaction":[{"@type":"commentaction","name":"comment","target":["\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#respond"]}]},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/","url":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/","name":"how to clean a primavera p6 xer file using the xer file parser","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg","datepublished":"2021-11-03t17:00:39+00:00","datemodified":"2021-11-08t15:53:47+00:00","description":"in the third part of our primavera p6 databases and data cleansing series, we will show how to use the parser to clean an xer file.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/04\/desk-931016_640.jpg","width":640,"height":480},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/how-to-clean-an-xer-file-using-the-parser\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"how to clean a primavera p6 xer file using the xer file parser"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间
","description":"project controls training &amp; 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":"required name=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\/7915"}],"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=7915"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7915\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/53945"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=7915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=7915"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=7915"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=7915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}