cProjects: Download to MS Project

[Former Member]

Hi,

I am trying to download a cprojects-project to ms project. One phase of my cprojects-project has a fixed start dart ("must start on"). But if exporting to ms project the fixed date is not mapped to ms project. Instead the second phase starts right after the first phase.

e.g.

cProjects:

project definition start date 02.10.2007 end date 27.10.2007 (not constraint)

phase 1 start date 02.10.2007 end date 10.10.2007 (no constraint)

phase 2 must start on 20.10.2007 end date 27.10.2007 (start constraint)

download to ms project:

project definition start date 02.10.2007 end date 27.10.2007

phase 1 start date 02.10.2007 end date 10.10.2007

phase 2 start date <b>11.10.2007 </b> end date 18.10.2007

In the IMG-Activity I maintained the following mapping:

CALENDAR_UID PPCP Phase (cProjects) CALENDAR_ID

CONSTRAINT_TYPE PPCP Phase (cProjects) CONSTR_TYPE_FIN

DURATION PPCP Phase (cProjects) DURATION

DURATION_UNIT PPCP Phase (cProjects) DURATION_UNIT

FINISH PPCP Phase (cProjects) FINISH_DATE_FIX

LATE_FINISH PPCP Phase (cProjects) SCHEDULED_FINISHED_LATE

LATE_START PPCP Phase (cProjects) SCHEDULED_FINISHED_START

NAME PPCP Phase (cProjects) DESCRIPTION

START PPCP Phase (cProjects) START_DATE_FIX

TEXT10 PPCP Phase (cProjects) NUMBER

TEXT2 PPCP Phase (cProjects) CREATED_BY_NAME

TEXT20 PPCP Phase (cProjects) PHA_TYPE

TEXT5 PPCP Phase (cProjects) CONSTRAINT_TYPE

I maintained the mapping of the constrain type but that doesn't help.

System: cpro 4.0, support package 10 (netweaver2004s)

Thanks for your reply

Isabella

[Former Member]

Hi,

I solved my problem.

The following mapping ist needed (to map the contraint type for the start date):

CONSTRAINT_TYPE PTCP Task (cProjects)CONSTRAINT_TYPE

The following mapping ist needed (to map the contraint type for the finish date):

CONSTRAINT_TYPE PTCP Task (cProjects)CONSTRAINT_TYPE_FIN

Maintain the same mapping all other project element (e.g. phase). If you are using summary tasks the fixed dates maintained for phase are not mapped to ms project (althought you defined the mapping for the phase). The fixed dates are then aggregated to the phase.

Now the contraint types are mapped to MS Project.

But there is still another problem. MS Project has only the possibilty to maintain a contraint type for start date OR finish date!!!!! Therefore you have to decide which ones you want to map to MS Project.