TASK
task_code status_code wbs_id task_name start_date cstr_type
Activity ID WBS
Activity Status CodeActivity Name (*)Start Primary Constraint
PA100 Layout
Not StartedDISA CLOSE-OUT/ Drill Holes Finish On
PA102 All work
Not StartedDISA CLOSE-OUT complete Finish On
PA103 MC Dean
Not StartedDISA CLOSE-OUT In House Punch Out Finish On
PA104 MC Dean
Not StartedDISA CLOSE-OUT In House Punch Out Finish On
PA105 MC Dean
Not StartedDISA CLOSE-OUT In House Punch Out Finish On
- if this is a start milestone change
Page 1
TASK
cstr_date task_type delete_record_flag activity
Primary Constraint Date (*)Activity Type Delete This Row id
6/27/2010 8:00:00 AM Finish Milestone PA100
8/15/2010 8:00:00 AM Finish Milestone PA102
8/18/2010 8:00:00 AM Finish Milestone PA103
8/15/2010 8:00:00 AM Finish Milestone PA104
6/16/2010 8:00:00 AM Finish Milestone PA105
format must be as shown
- if this is a start milestone change it to Start Milestone
- if this is a start milestone change it to Start On
Page 2
TASK
paste dates from time concatenates
spreadsheet must be date and time
8/2/2010 8:00:00 AM 8/2/2010 8:00:00 AM
8/15/2010 8:00:00 AM 8/15/2010 8:00:00 AM
8/18/2010 8:00:00 AM 8/18/2010 8:00:00 AM
8/15/2010 8:00:00 AM
8/22/2010 8:00:00 AM
--- use formula to combine date and time then
copy & paste as a special value to column G
then delete columns M, N, O and P prior to importing
- 1st format this column as text
then type in your date
Page 3
TASK
r to importing
Page 4
USERDATA
user_data
UserSettings Do Not Edit
DurationQtyType=QT_DayShowAsPercentage=0SmallScaleQtyType=QT_HourDateFormat=d'-'mmm'-'yCurrencyFormat=Dolla
Page 5
USERDATA
at=d'-'mmm'-'yCurrencyFormat=Dollar
Page 6