<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/ti/onlinemanual/000396" xml:lang="en">
   <Header>
      <Title>Data mapping: export data from PCS to Microsoft Project</Title>
      <Keyword type="header" order="d1e2031594">
         <Level1>PCS</Level1>
         <Level2>integration with Microsoft Project</Level2>
      </Keyword>
      <Keyword type="header" order="d1e2031599">
         <Level1>Microsoft Project</Level1>
      </Keyword>
   </Header>
   <GeneralSection>
      <Paragraph>To work on PCS projects in Microsoft Project, use the <Link href="/baanerp/ti/pcs/tipcs4172m000" role="session">
            <GUIRef href="/baanerp/ti/pcs/tipcs4172m000" role="session">Export / Import PCS Activities via XML (tipcs4172m000)</GUIRef>
         </Link> session to transfer data
		related to the PCS projects in LN to Microsoft Project . The table shows how data in LN matches the data
		in Microsoft Project.</Paragraph>
      <Paragraph>If no matching field exists, automatically a custom field is
		inserted in Microsoft Project.</Paragraph>
      <ProcedureList>
         <ListIntro>To display custom fields in the Microsoft Project grid, do the
		  following:</ListIntro>
         <ListItem>Right-click on the column header.</ListItem>
         <ListItem>Select insert column.</ListItem>
         <ListItem>In the column definition screen, select field name text3,
		  text4, text5, text6 or text7.</ListItem>
      </ProcedureList>
      <ProcedureList>
         <ListIntro>To modify GLOBAL.MPT, so that custom fields are displayed in
		  the grid by default:</ListIntro>
         <ListItem>Copy GLOBAL.MPT, which is located in C:\Documents and
		  Settings\&lt;user&gt;\Application Data\Microsoft Data\Microsoft\MS
		  Project\11\1033\.</ListItem>
         <ListItem>Perform the steps described above to display customs fields,
		  and save the template file.</ListItem>
         <ListItem>Replace the GLOBAL.MPT file by your modified copy.</ListItem>
      </ProcedureList>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <ProcedureList>
            <ListIntro>You can always recover the original GLOBAL.MPT
			 file:</ListIntro>
            <ListItem>Delete the modified MPT file.</ListItem>
            <ListItem>Create a Microsoft Project file. A new GLOBAL.MPT file is
			 copied from the globally installed template located in C:\Program
			 Files\Microsoft Office\OFFICE11\1033\.</ListItem>
         </ProcedureList>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated">
         <TBODY noTR="27">
            <TR no="1" isLast="false">
               <TH width="226" rowspan="1" colspan="1">LN</TH>
               <TH width="295" rowspan="1" colspan="1">Microsoft
				Project</TH>
               <TH width="401" rowspan="1" colspan="1">Remarks</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD width="226" rowspan="1" colspan="1"> </TD>
               <TD width="295" rowspan="1" colspan="1"> </TD>
               <TD width="401" rowspan="1" colspan="1"> </TD>
            </TR>
            <TR no="3" isLast="false">
               <TH width="226" rowspan="1" colspan="1">PCS Project</TH>
               <TH width="295" rowspan="1" colspan="1">Summary Task</TH>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="4" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.cprj" role="manual">Project</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">Task Name</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="5" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsca" role="manual">Description</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Task Description (custom
				field)</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="6" isLast="false">
               <TD width="226" rowspan="1" colspan="1">The PCS start dates
				and end dates are not exported. Microsoft Project determines the project's
				start date and end date during loading the XML file into Microsoft Project,
				based on the dates of the individual tasks.</TD>
               <TD width="295" rowspan="1" colspan="1"> 
                  <List>
                     <ListItem>StartDate</ListItem>
                     <ListItem>FinishDate</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1"> 
                  <Paragraph>A Microsoft Project file consists of only one project.
				  This project can contain all activities of multiple LN PCS
				  projects.</Paragraph>
               </TD>
            </TR>
            <TR no="7" isLast="false">
               <TD width="226" rowspan="1" colspan="1">PCS <GUIRef href="/baanerp/ti/pcs/tipcs2130m000#tipcs030.plcd" role="manual">Planning Method</GUIRef> 
                  <List>
                     <ListItem>Backward</ListItem>
                     <ListItem>Forward</ListItem>
                  </List>
               </TD>
               <TD width="295" rowspan="1" colspan="1">ScheduleFromStart <List>
                     <ListItem>False</ListItem>
                     <ListItem>True</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="8" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.cprj" role="manual">Project</GUIRef> (selection range) <List>
                     <ListItem>Start Date of first project</ListItem>
                     <ListItem>Completion Date of last project</ListItem>
                  </List>
               </TD>
               <TD width="295" rowspan="1" colspan="1"> 
                  <List>
                     <ListItem>StartDate</ListItem>
                     <ListItem>FinishDate</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1"> 
                  <Paragraph>A Microsoft Project file consists of only one project.
				  This project can contain all activities of multiple LN PCS
				  projects.</Paragraph>
               </TD>
            </TR>
            <TR no="9" isLast="false">
               <TD width="226" rowspan="1" colspan="1"> </TD>
               <TD width="295" rowspan="1" colspan="1">Fixed values: <List>
                     <ListItem>DurationFormat: 5 (=hours)</ListItem>
                     <ListItem>DefaultFixedCostAccrual: 3 (=end)</ListItem>
                     <ListItem>Project ExternallyEdited: 0 (no)</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="10" isLast="false">
               <TH width="226" rowspan="1" colspan="1">Activity</TH>
               <TH width="295" rowspan="1" colspan="1">Task</TH>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="11" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.cact" role="manual">Activity</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">Task Name: &lt;project
				code&gt; - &lt;activity code&gt;</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="12" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsca" role="manual">Description</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Activity Description (custom
				field)</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="13" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.tano" role="manual">Task</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Task (custom field)</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="14" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tirou003.dsca" role="manual">Task</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Task Description (custom field)</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="15" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.acmn" role="manual">Activity Manager</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Activity Manager (custom field)</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="16" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.cwoc" role="manual">Work Center</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">LN Work Center (custom field)</TD>
               <TD width="401" rowspan="1" colspan="1">Refer also to Resource</TD>
            </TR>
            <TR no="17" isLast="false">
               <TD width="226" rowspan="1" colspan="1"> 
                  <Paragraph>Calendar that is valid for the activity's work
				  center:</Paragraph> 
                  <List>
                     <ListItem>Availability as defined in routing
					 parameters</ListItem>
                     <ListItem>Company calendar or work center calendar, dependent on <GUIRef href="/baanerp/ti/rou/tirou0100m000#tirou000.ccal" role="manual">Used Calendar Type</GUIRef> in the routing
					 parameters.</ListItem>
                  </List>
               </TD>
               <TD width="295" valign="top" rowspan="1" colspan="1"> 
                  <Paragraph>Calendar</Paragraph> 
                  <List>
                     <ListItem>Value: &lt;availability&gt; .
					 &lt;calendar&gt;</ListItem>
                     <ListItem>IgnoreResourceCalendar: 1 (=yes)</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">Microsoft Project only uses the task calendar.
				The work center calendar is <Emphasis>not</Emphasis> used.</TD>
            </TR>
            <TR no="18" isLast="false">
               <TD width="226" rowspan="1" colspan="1">---</TD>
               <TD width="295" rowspan="1" colspan="1">Task Type: Fixed Work</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="19" isLast="false">
               <TD width="226" rowspan="1" colspan="1"> 
                  <List>
                     <ListItem>
                        <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsdt" role="manual">Desired Start Date</GUIRef>
                     </ListItem>
                     <ListItem>
                        <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dfdt" role="manual">Desired End Date</GUIRef>
                     </ListItem>
                  </List> If these fields have no dates, other date fields are used: <List>
                     <ListItem>In case of forward planning: <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.esdt" role="manual">Earliest Start Date</GUIRef> and <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.efdt" role="manual">Earliest End Date</GUIRef>
                     </ListItem>
                     <ListItem>In case of backward planning: <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.lsdt" role="manual">Latest Start Date</GUIRef> and <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.lfdt" role="manual">Latest End Date</GUIRef>
                     </ListItem>
                  </List>
               </TD>
               <TD width="295" rowspan="1" colspan="1"> 
                  <List>
                     <ListItem>Start</ListItem>
                     <ListItem>Finish</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="20" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.adur" role="manual">Activity Duration</GUIRef>
               </TD>
               <TD width="295" rowspan="1" colspan="1">Duration</TD>
               <TD width="401" rowspan="1" colspan="1"> 
                  <Paragraph>The duration in LN is the number of
				  working hours between the <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsdt" role="manual">Desired Start Date</GUIRef> and the <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dfdt" role="manual">Desired End Date</GUIRef>. Dependent on the routing parameter,
				  the calendar of the activity's work center or the company calendar is used to
				  calculate the number of hours.</Paragraph> 
                  <Paragraph>Refer also to <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsdt" role="manual">Desired Start Date</GUIRef> and <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dfdt" role="manual">Desired End Date</GUIRef>.</Paragraph> 
                  <Paragraph>Microsoft Project uses Start Date, Duration, and the
				  imported Calendar definition to calculate the task's Finish Date.</Paragraph>
               </TD>
            </TR>
            <TR no="21" isLast="false">
               <TD width="226" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4110m000#tipcs410.pact" role="manual">Preceding Activity</GUIRef> (as defined in <GUIRef href="/baanerp/ti/pcs/tipcs4110m000" role="session">Activity Relationships (tipcs4110m000)</GUIRef>)</TD>
               <TD width="295" rowspan="1" colspan="1">Predecessor</TD>
               <TD width="401" rowspan="1" colspan="1">The float time in days is multiplied by the work center's basic
				capacity to convert the time to hours (working time). <Paragraph>In Microsoft Project, the float time is imported in
				  hours, but the time is displayed in days (working time). The calendar of the
				  current task ( <GUIRef href="/baanerp/ti/pcs/tipcs4110m000#tipcs410.sact" role="manual">Next Activity</GUIRef> in <GUIRef href="/baanerp/ti/pcs/tipcs4110m000" role="session">Activity Relationships (tipcs4110m000)</GUIRef>) is used to offset the time.</Paragraph>
               </TD>
            </TR>
            <TR no="22" isLast="false">
               <TH width="226" rowspan="1" colspan="1">Calendar</TH>
               <TH width="295" rowspan="1" colspan="1">Calendar</TH>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="23" isLast="false">
               <TD width="226" rowspan="1" colspan="1">All
				calendars used for the network planning are exported to Microsoft Project <List>
                     <ListItem>Availability type as defined in the routing
					 parameters</ListItem>
                     <ListItem>Dependent on the routing parameter, the company
					 calendar is exported, or a calendar for each work center. For each calendar the
					 default availability type as defined in the routing parameters is
					 exported.</ListItem>
                     <ListItem>A maximum of three working time blocks per day is
					 exported.</ListItem>
                  </List>
               </TD>
               <TD width="295" rowspan="1" colspan="1">Calendar <List>
                     <ListItem>Value: &lt;availability&gt; .
					 &lt;calendar&gt;</ListItem>
                     <ListItem>Calendars are linked to tasks</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="24" isLast="false">
               <TH width="226" rowspan="1" colspan="1">Work
				Center</TH>
               <TH width="295" rowspan="1" colspan="1">Resource</TH>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="25" isLast="false">
               <TD width="226" rowspan="1" colspan="1">Work Center (used on the activity)</TD>
               <TD width="295" rowspan="1" colspan="1">Resource <List>
                     <ListItem>For each task, a custom field 'LN Work Center' is
					 available</ListItem>
                     <ListItem>During XML import, resources are not formally linked to
					 tasks</ListItem>
                  </List>
               </TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="26" isLast="false">
               <TD width="226" rowspan="1" colspan="1">Code</TD>
               <TD width="295" rowspan="1" colspan="1">Name</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
            <TR no="27" isLast="true">
               <TD width="226" rowspan="1" colspan="1">Calendar</TD>
               <TD width="295" rowspan="1" colspan="1">Calendar</TD>
               <TD width="401" rowspan="1" colspan="1">--</TD>
            </TR>
         </TBODY>
      </TABLE>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/ti/onlinemanual/000395" role="manual">Integration between PCS and Microsoft Project</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/ti/onlinemanual/000397" role="manual">Data mapping: import data from Microsoft Project to PCS</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>