Posted on Jul 15, 2016
SGT Laura Delgadillo
28.6K
25
19
9
9
0
So this is a long shot but I just took over the DTMS for my company and have been adding training and certs and weapon qualifications one by one on each individual soldier. Is there a way I could bulk add weapons quals or APFT to soldiers. Or is there any easier way to to add weapon quals other than going to soldier management, last name, clicking soldier and clicking weapons? Thanks in advance!
Avatar feed
Responses: 14
Votes
  • Newest
  • Oldest
  • Votes
SGT Training Nco
6
6
0
F806d029
Yes there is actually! One of my favorite features. Note that you can also do this with APFT and more. But you have to do anyone who has profiles seperate. They have a mass input form as well. See picture below for instructions.
(6)
Comment
(0)
SGT Laura Delgadillo
SGT Laura Delgadillo
9 y
Thanks! I'll definitely try Monday. Hope it works!
(0)
Reply
(0)
SFC Human Resources Specialist
SFC (Join to see)
9 y
Just saw this but perfect. As a side note if you add personnel to the spreadsheet later you can reuoad same sheet and the only changes that will occur in the system are the new additions so you can maintain one spreadsheet and not several different ones.
(0)
Reply
(0)
SPC S3 Training Clerk
SPC (Join to see)
9 y
I work DTMS for my BN and have contacted the help desk multiple times via phone and email regarding the batch upload. They told me it was supposed to be feature, but for now those options are only a placeholder and do not work. If you have any luck with it, please let me know.
(0)
Reply
(0)
Avatar small
SFC Education And Training Manager
3
3
0
No it is all individual for every Soldier. It its done any different then the system can crash.
(3)
Comment
(0)
Avatar small
SSgt Carpenter
2
2
0
Don't know a darn thing about DTMS, and hope I never have to learn either, just commenting because this is the kind of useful conversation I'd like to see on RP instead of name calling and ranting over politics
(2)
Comment
(0)
Avatar small
Avatar feed
Is there any way to bulk add Weapons Quals to DTMS?
SFC Platoon Sergeant
1
1
0
You have to enter all fields. Date, wpn, score, night nbc and optic etc. You can leave people who have no stats blank but once you fill in data you must complete that SM's data. I just updated everyone's weapon qual.
(1)
Comment
(0)
Avatar small
LTC Paul Labrador
1
1
0
DTMS sucks. That is all....
(1)
Comment
(0)
Avatar small
SSG John Erny
1
1
0
If it is a database yes there in fact is a way; however, will the DB Admin permit it is another matter. Databases can pull data from text flat files, csv files, spread sheets, or other databases. Proper Programming prevents piss poor processing. :-)
(1)
Comment
(0)
Avatar small
SPC Unscheduled Services Team Leader
1
1
0
Unfortunately DTMS is completely individual. I remember my old training nco sitting at the scanner for hours scanning weapons and pt cards (had over 250 soldiers)
(1)
Comment
(0)
Avatar small
SFC Readiness Nco
0
0
0
Sure is, a few people said no and it's not the case, you need to make DTMS your friend as it's not going away any time soon. I have been a DTMS Master Trainer since it first came out back in like 2006 or something. Knowing how to use and make dtms work is a great tool and will make you an asset to unit who are lost in the sauce. Batch upload is easy. Make your all your soldiers have a weapon assignment or it wont count towards USR reporting. Another good skill to master is USR
(0)
Comment
(0)
Avatar small
SFC Instructor
0
0
0
Yes, there is that option...you had the whole list and whoever that did not qualify uncheck the list and update...first you have to have admin rights for all the UICs under your Company...
(0)
Comment
(0)
Avatar small
SFC Human Resources Specialist
0
0
0
Yes there is. It is called. batch upload. In the upper right corner next to logout there is a drop down with batch upload make the selection and pull the spreadsheet out and save to desktop. DO NOT change any information in the spreadsheet that is prefilled. Once you enter your data save it to desktop and upload it the same way you took the spreadsheet from DTMS. There is a step by step on ATN Army Training Network which can be accessed they the help tab... It works well. Hit me back if you need help. Good luck!
(0)
Comment
(0)
Avatar small
SGT Training Nco
0
0
0
There is also a week long DTMS course your ATRRS operator can out you in for if there is funding. If you have any other questions let me know. Glad to help any way I can.
(0)
Comment
(0)
Avatar small
SFC Motor Transport Operator
0
0
0
no there is not
(0)
Comment
(0)
SGT Training Nco
SGT (Join to see)
9 y
Check my comment to see how it's done! Great feature.
(0)
Reply
(0)
Avatar small
SFC Human Resources Specialist
0
0
0
I have emailed the help desk a few times (as well as ALMS), to ask them to add a "view all Soldiers" "input by unit/roster" and "search by UIC"... so far no response
(0)
Comment
(0)
SFC Human Resources Specialist
SFC (Join to see)
9 y
SFC, if you email next Tuesday I can help you out. I teach a DTMS course for my command. [login to see]
(1)
Reply
(0)
Avatar small
MSG Military Police
0
0
0
You mean entire units at one time?
(0)
Comment
(0)
Avatar small

Join nearly 2 million former and current members of the US military, just like you.

How are you connected to the military?
  • Active Duty
  • Active Reserve / National Guard
  • Pre-Commission
  • Veteran / Retired
  • Civilian Supporter