Training Tracker for USAF Ancillary Training
Current version is 6.0, released 17 May 2013. For issues or feature requests, contact Maj Dan Riley, 413 FLTS, Hurlburt Field, FL (find me on the global!).
Version 6.0 fixes the Training Tracker to work with new security measures introduced in ADLS. This version is not as robust as the previous version due to the way everything has to be scripted, but as long as you leave the computer alone after you hit Update Stats (except to enter your PIN if it asks you), it should work ok. If you get an error, check step 7a below!
OK, so here's the details on how to use v6.0!
1. Save the attached Training Tracker v6.txt to your computer and rename it
from .txt to .xlsm. The filters through Hurlburt won't let it go through
otherwise, so this should get it to the most people at once.
2. On the Setup tab, either click "Migrate Data" to transfer your old
settings, or just enter your Organization ID (from ADLS, see previous
instructions in the changelog if you forgot). Organization PAS is needed if
you are tracking Continuous Learning Points.
3. IMPORTANT!! Click the Enter ADLS Access Code button and enter the
Access Code for your UTM access to ADLS. This is the really long and
convoluted password you use when you go to "UTM/UDM Administration". This
is needed because of the new security measures. It is stored as an
encrypted string...not completely secure, but should be plenty secure for
most of us.
4. Now go to Stats and run "Update Stats" as normal. Shortly after
Internet Explorer is opened, you may have to enter your CAC pin, but that
should be the only thing you have to enter. It only pops up on occasion,
for no real rhyme or reason, but just pauses the run until you enter it.
5. DO NOT TOUCH ANYTHING! Let it run without using your computer,
especially the first time to see if everything works properly. Like I said
before, it's much more touchy. I can usually browse my email lightly while
it's running, but if you click around too much, you can interrupt the
6. If everything goes well, after the first half finishes (downloading the
files), it should run just like it always did. There are a couple of
smaller changes you can see in the changelog, mostly adding the new ADLS
courses (but those won't stick if you migrate your data!).
7. If you do have an issue here's the troubleshooting steps:
a. If you get a "debug" error that says "file not found" and something like
"DOD.xls", go to the setup sheet, and click on the "Fix Save" button. This
uses an alternate method of dealing with the files that isn't as ideal, but
it seems to be what works for some computers. After clicking that, just go
run Update Stats again.
b. If some windows are staying open and either never closing, or the Excel
just seems to lockup, play around with the "Timer Modifier" setting, and
change the '1' to something bigger. Basically it makes everything take
longer, but it may be needed due to speed differences on some computers.
You can put "1.2" or "1.5" or "2" or "5" to slow it down a little. If you
get as high as 5 or so, going higher probably won't do much good.
Conversely, if everything is working smoothly, you can try lowering the
value to something less than 1 but greater than 0, ie "0.7" to speed it up a
little. It probably won't work though! But you can tinker with it.
c. If you don't put the right Access Code in, you will either get a prompt
saying there is none entered, or you will get blank data. Make sure you
enter it correctly! For security measures, there's no way for you to check
it after you hit "OK".
d. Any other errors, contact me!
Found an error with adding new courses on the Setup sheet. The latest download below has it, but if you have v5.0, use these instructions to update:
Go to "View", "Macros", and just click "Edit". Do a search (ctrl-f) for "InsertCourseForm.Show". On the line ABOVE that, add this:
So that block should look like this:
If Not noAlerts Then
Application.ScreenUpdating = True
Found an error with supervisory courses. This is updated as of the 2nd v5.0 release. If your supervisors aren't getting the correct courses assigned, please update and migrate your data!
Training Tracker Changelog.txt
Training Tracker.xls (same as .xlsm above but may get through IT filters...rename to .xlsm before using!)
Training Tracker.zip (contains .xlsm and the changelog, again may defeat IT filters)
Training Tracker v5.1.xlsm
Training Tracker v5.0.xlsm
Release Notes and Instructions
(also found in the Changelog above)