Generating a 45

[Eclipse]

Is there any quick way, short of SIMS, to generate an electronic 45 without manually filling every field?

[PWK-GT]

Ask my ITO...he did it quick prior to our last SUI.

[Cliff_Chambliss]

I too would like to know

[Ed Bos]

Out of curiosity, why not just use the Member Search Report tool on eServices? It has most of the pertinent information, just not some of the awards and the outside-CAP education block.

[Eclipse]

Out of curiosity, why not just use the Member Search Report tool on eServices? It has most of the pertinent information, just not some of the awards and the outside-CAP education block.

Member search is fine, but a 45 is still required to be in the file.   I agree that this should be enough for an inspection, but as written today, it isn't.

PWK-GT's 45's mentioned above were likely generated with SIMs.  I'm in the process of digitizing records and trying to put a spec together for
an all-digital personnel file.  The ability to generate a good 45 without SIMS would be nice.

[Cliff_Chambliss]

Right now I am in the process of generating electronic 45s for our entire Sqdn (Not really that big a mess as we are only talking about 25 people).    Basically I am using the Member Search and then copying all relevant data onto the CAPF 45, and then going through the old paper files and scanning and entering other data.  We are a very old squadron, and some member files are several inches thick.  (In one members file I found a copy of orders sending (as a cadet) me to Summer encampment at Maxwell AFB in 1963).
  Even with this I expect to have some holes to fill in order to get ready for our SUI.

At the end of the day my plan is to have everything on digits and nothing on paper. 

[Ed Bos]

Looks like it might be something that could be done with a 1-off programming project using something like Microsoft Access, CAPWATCH downloads, and PDF versions of the forms.

Too bad I can't program worth a darn. Any takers out there?

[Eclipse]

At the end of the day my plan is to have everything on digits and nothing on paper.

Ditto, and this >is< acceptable as long as you have a plan and adhere to the retention regs, etc.  A standardized naming convention with a key should be part of your formal file plan.

Most likely you can dispose of the majority of the stuff in the older files, and if it isn't CAP related it probably shouldn't be in there.  I have had CC's who encouraged their people to put anything remotely "military/aviation/community service/public service/where I had lunch related" which resulted in 4 inch thick folders for members without ES ratings who never got past LII.  Anything not needed was returned to the member during the cleanout.

[Phil Hirons, Jr.]

Looks like it might be something that could be done with a 1-off programming project using something like Microsoft Access, CAPWATCH downloads, and PDF versions of the forms.

Too bad I can't program worth a darn. Any takers out there?

I had this working with Access 97, CAPTWATCH and a hand constructed Word template. The app was able to store those items on the 45 not on e-Services would update from CAPWATCH. Got a nice write up on a CI

Then CAPWATCH became a bunch of text files. I've not tested with later versions of Access but would think they would be OK

If someone is interested in the code I believe I have all of it. PM and I'll look.

[SarDragon]

Access will handle the text (CSV) files just as easily as it did the olde MDB files. There are just a couple of more steps to using them.

[EMT-83]

I did mine in FileMaker Pro.

It doesn't meet your requirements of being quick and non-manual, but having a searchable database comes in handy.

[Spaceman3750]

I did mine in FileMaker Pro.

It doesn't meet your requirements of being quick and non-manual, but having a searchable database comes in handy.

Or cheap .

[johnnyb47]

Is there any quick way, short of SIMS, to generate an electronic 45 without manually filling every field?

Cadet Information Technology Officer

[Ed Bos]

^  Or a 2d Lt IT Officer 

[johnnyb47]

^  Or a 2d Lt IT Officer 

It would be a pleasure, sir.

(set myself up for that one. HA!)

[johnnyb47]

^  Or a 2d Lt IT Officer 

After looking over the 45, member search report and member reports in eservices I've decided to accept this as a challenge. Really it's just a geek thing. 
I will see what I can do.

[Ed Bos]

I will see what I can do.

Awesome, I'm really looking forward to seeing what you come up with.

I had this working with Access 97, CAPTWATCH and a hand constructed Word template.
If someone is interested in the code I believe I have all of it. PM and I'll look.

I'm sure your method worked well, but I know I'm not in a position to take your code and work with it.

[Extremepredjudice]

Is there any quick way, short of SIMS, to generate an electronic 45 without manually filling every field?

Cadet Information Technology Officer

I'm not the IT officer...

Is something like this what is needed?
http://imageshack.us/photo/my-images/41/examplemw.png/
That generates a report like this
http://imageshack.us/photo/my-images/205/examplereport.png/

If something like that is what is needed I can spend more time on that and make it better.... Then I'll upload a copy so you guys can get it 
Or if I am doing it completely wrong, lemme know... Maybe I can still figure something out for you guys...

[Eclipse]

What is needed is a CAPF45.

www.capmembers.com/media/cms/capf045_AABAD294AD767.doc

[Extremepredjudice]

Those are some fields I set up, it allows you to put in decorations, and dates, ratings, FAA info, etc. I was using CAPF 45 as a template for what needs to be added.

As you can see it has a lot of the stuff (I couldn't show all of it cause it went off the screen. 

Basically you enter the stuff into the table, and then it prints out on the report. I will have to work on it, but that is my first [speedy] revision.