search

mattgwagner / Battery-Commander

A digital "leader book" for tracking Army unit members, qualifications, evaluations, and vehicle convoys.
MIT License
2 stars 0 forks source link

DTMS Roster Sync? #27

Open mattgwagner opened 7 years ago

mattgwagner commented 7 years ago

If DTMS (or another similar system of record) has a readable export, we could scan it for new/update Soldier information to batch add into the system.

mattgwagner commented 7 years ago

The "Soldier Roster Report" out of DTMS, exported to Excel, has the following column headings:

LastName MiddleName FirstName RankShort Last4 PayGradeCode MOS SMOS DateOfRank BASD UnitAssigned UnitAssigned Status

mattgwagner commented 7 years ago

We need something with date of birth in there, since we use that to calculate age for APFT/ABCP/etc.

mattgwagner commented 7 years ago

They have the long unit name in there, doesn't necessarily direct map to names in system, and soldiers require a unit of assignment.

i.e. BTRY A 2ND BN 116TH FA => A/2-116 FA. Perhaps long/short name?

mattgwagner commented 6 years ago

I think what might be more useful is to upload a DTMS roster and have it call out differences, rather than trying to apply them automatically.