Legacy columns to target fields. The mapping table is the specification.
Mapping applied, default. Change a row to run again.
The legacy tool exports dates as dd/mm/yyyy text. Switch one date column to dateMDY and run the check: every day from 1 to 12 swaps with the month, every day above 12 becomes empty, and the ledger shows the cost.
WBS, legacy_wbs.csv, 54 rowsSample data
Legacy field
Target field
Type
Transform
Required
Rows changed
wbs
text
0
parent_wbs
text
0
prog_cd
text
0
wbs_nm
text
0
wbs_lvl
number
0
cc
text
0
bud
number
0
cur
text
0
Activities, legacy_activity.csv, 144 rowsSample data
Legacy field
Target field
Type
Transform
Required
Rows changed
act_id
text
0
prog_cd
text
0
act_nm
text
0
wbs
text
0
start_dt
date
0
finish_dt
date
0
owner
text
0
Milestones, legacy_milestone.csv, 41 rowsSample data
Legacy field
Target field
Type
Transform
Required
Rows changed
ms_id
text
0
prog_cd
text
0
ms_nm
text
0
ms_dt
date
0
bl_dt
date
0
gate_flg
boolean
0
gate_cd
text
0
owner
text
0
wbs
text
0
Dependencies, legacy_dependency.csv, 193 rowsSample data
Legacy field
Target field
Type
Transform
Required
Rows changed
dep_id
text
0
pred
text
0
succ
text
0
dep_typ
text
0
lag
number
0
Assignments, legacy_assignment.csv, 134 rowsSample data