Configuration > TPG PSLink > Pre-defined Jobs > Synchronize the MS Project project plan with PPP

This job publishes the schedule from MS Project Desktop to the assigned TPG ProjectPowerPack project. In the process, tasks, task links, and the corresponding mapped scheduling information are transferred to PPP.

TPG PSLink uses the PPP_ID stored in the project information to uniquely identify the appropriate TPG ProjectPowerPack project and transfer the data there.

The job is typically started using the corresponding menu button, such as Publish Schedule to PPP (See Execute Integration Jobs via the Add-In)

Task Field Mapping

Task Field Mapping determines which task fields from MS Project Desktop are transferred to which target fields in PPP. As a result, both systems use the same planning information.

MS Project	PPP	PPP internal Column Name	PPP internal Table Name
	Actual Hours	tpg_actualhrs	tpg_projecttask
BaselineFinish	Baseline Finish	tpg_baselinefinish	tpg_projecttask
BaselineStart	Baseline Start	tpg_baselinestart	tpg_projecttask
	Bucket	tpg_bucket	tpg_projecttask
	Task Calendar	tpg_calendar	tpg_projecttask
	Color	tpg_color	tpg_projecttask
ConstraintDate	Constraint Date	tpg_constraintdate	tpg_projecttask
ConstraintType	Constraint Type	tpg_constrainttype	tpg_projecttask
Deadline	Deadline	tpg_deadline	tpg_projecttask
Notes	Notes	tpg_description	tpg_projecttask
Duration	Duration	tpg_duration	tpg_projecttask
'days'	Duration Unit	tpg_durationunit	tpg_projecttask
	Effort (DEPRECATED)	tpg_effort	tpg_projecttask
	Expanded	tpg_expanded	tpg_projecttask
GUID	External UID	tpg_external_uid	tpg_projecttask
Finish	Finish	tpg_Finish	tpg_projecttask
	Indicators	tpg_icon	tpg_projecttask
	Ignore resource calendar	tpg_ignorerescalendar	tpg_projecttask
Active	Inactive	tpg_inactive	tpg_projecttask
Critical	Critical	tpg_iscritical	tpg_projecttask
EffortDriven	Effort Driven	tpg_iseffortdriven	tpg_projecttask
Manual	Manually Scheduled	tpg_ismanual	tpg_projecttask
Milestone	Is Milestone	tpg_ismilestone	tpg_projecttask
Rollup	Rollup	tpg_isrollup	tpg_projecttask
Summary	Summary Task	tpg_issummary	tpg_projecttask
	Is Variant	tpg_isvariant	tpg_projecttask
	Key Milestone	tpg_keymilestone	tpg_projecttask
	Link	tpg_link	tpg_projecttask
	Locked	tpg_locked	tpg_projecttask
OutlineLevel	Outline Level	tpg_outlinelevel	tpg_projecttask
implicitly set by nav property	Parent Index	tpg_parentindex	tpg_projecttask
implicitly set by nav property	Parent Task	tpg_parenttask	tpg_projecttask
	Predecessors placeholder	tpg_predecessorsplaceholder	tpg_projecttask
Priority	Priority	tpg_priority	tpg_projecttask
PercentComplete	% Complete	tpg_progress	tpg_projecttask
implicitly set	Project	tpg_project	tpg_projecttask
	Resource Names	tpg_resourcesplaceholder	tpg_projecttask
Type Always Set to 'Normal'	Scheduling Mode	tpg_schedulingmode	tpg_projecttask
	Show in Timeline	tpg_showintimeline	tpg_projecttask
	Source Reference	tpg_sourceref	tpg_projecttask
Start	Start	tpg_start	tpg_projecttask
Name	Name	tpg_subject	tpg_projecttask
	Todos	tpg_todos	tpg_projecttask
WBS	WBS	tpg_wbs	tpg_projecttask
	Weight	tpg_weight	tpg_projecttask
Work	Effort	tpg_work	tpg_projecttask
'hour'	Effort Unit	tpg_workunit	tpg_projecttask

Job Configuration Template

The Job Configuration Template defines how the Schedule Sync job is executed. It contains the technical job definition, the mappings used, and the logic for transferring the transactions to PPP.

▶ You can obtain a template for job configuration from your TPG consultant.