Back to Support
 
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.end_date

task.Finish
task.Finish1

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


task.estimated_hours


Task Grid - Estimated Hours

Resources:
First listed resource
All subsequent

Resource.primary
Other Resources

Primary Resource

Participant

Note 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.

Top of Page