| CS/10,000 -> MS Project Mapping Chart |
CS/10,000 Export of Schedule Data to MS Project
| CS/10,000 Database Field | MS Project Field | CS/10,000 User Interface Component |
| if
task.scheduled_start > 0 then task.scheduled_start task.scheduled_start elseif task.start_date > 0 then task.start_date task.start_date |
task.Start task.BaselineStart task.Start task.BaselineStart |
Timesheet - Scheduled Start Date
OR Timesheet - Actual Start Date |
| if task.start_date
> 0 then task.start_date |
task.ActualStart |
Timesheet - Actual Start Date |
|
task.end_date |
task.Finish |
Task Grid - End Date |
| if
resource_work.scheduled_hours > 0 then max(resource_work. scheduled_hours) |
task.Duration |
Timesheet - Scheduled Hours |
| max(resource_work.actual_hours) | task.ActualDuration | Timesheet - Actual Hours |
| if selected
"export estimated" then task.estimated_hours elseif selected "export scheduled" then task.scheduled_hours |
task.BaselineDuration task.BaselineDuration |
Task Grid - Estimated Hours Task Grid - Scheduled Hours |
| if selected
"export estimated" then if task.scheduled_hours > 0 task.estimated_hours else task.scheduled_hours |
task.BaselineWork task.BaselineWork |
Task Grid - Estimated Hours Task Detail - Scheduled Hours |
| resource_work.scheduled_hours | assignment.BaselineWork | Timesheet - Scheduled Hours |
| resource_work.duration | assignment.ActualWork | Timesheet - Actual Hours |
| resource_work.remaining_hours | assignment.RemainingWork | Timesheet - Remaining Hours |
| primary resource | assignment.resource | Timesheet- Primary Resource |
| participants | assignment.resource | Timesheet- Participant |
Note from Microsoft Project Help on how MSP calculates % Complete (we do not export it):
% Complete = ((Duration - Remaining Duration) / Duration) * 100
% Complete = (Actual Duration / Duration) * 100
Note on the calculation of work fields:
CS/10,000 is now ONLY exporting the baseline work field. We used to export the actual_ and remaining_work fields). Other fields that were being exported did not make any difference because project resets them based on the assignment fields.
Note on recalculating the project before export to MS Project:
You should recalculate the project before exporting it to MS Project. This can be done by clicking the Recalc button on the toolbar while viewing the Task Grid.Note on End Date - Finish and Finish 1
When you export a CS/10,000 Project to Microsoft Project, the CS/10,000 End Date is transferred into the MIcrosoft Project Finish column. MSP automatically updates the data in the Finish column and changes the end date of the task group header to the last date listed for that task group. It may also recalculate some data according to your actual hours and start and end dates. If you want to view the end dates as they were set in CS/10,000, they can be viewed in the 'Finish1' column. To display the Finish1 column, right click on any column header and select 'Insert Column' - this will open the Column Definition dialog box. Select 'Finish1' from the 'Field_name' drop down box . The column Finish1 will appear with your original end dates.
CS/10,000 Import of Schedule Data from MS Project
| MS Project Field | CS/10,000 Database Field | CS/10,000 User Interface Component |
| assignment.BaselineWork | resource_work.scheduled_hours | Timesheet - Scheduled Hours |
| assignment.ActualWork | resource_work.duration | Timesheet - Actual Hours |
| assignment.RemainingWork | assignment.remaining_hours | Timesheet - Remaining Hours |
| assignment.Start | resource_work.work_date | Timesheet - Actual Start Date |
| task.ActualWork | task.actual_hours | Task Grid - Hours Done |
| task.RemainingWork | task.scheduled_hours | Task Detail - Scheduled Hours |
| task.Start | task.scheduled_start | Task Detail - Scheduled Start Date |
| task.Finish | task.end_date | Task Grid - End Date |
| if
task.ActualStart > 0 then task.ActualStart else task.Start |
task.start_date task.start_date |
Task Grid - Actual Start Date Task Grid - Actual Start Date |
| if
selected "import baseline" then task.BaselineWork |
|
|
| Resources: First listed resource All subsequent |
Resource.primary Other Resources |
Primary Resource Participant |
Top of PageNote on Importing Resources from MS Project to CS/10,000:
CS/10,000 will only import resources which have already been created in CS/10,000 . It is very important to make sure that the name spelling is EXACTLY the same, including spaces.
You must assign the resource to the project which you are importing before beginning the import procedure.