So, the barcode on a 101 card....

Started by Hawk200, May 21, 2008, 03:47:36 AM

0 Members and 1 Guest are viewing this topic.

Hawk200

... is there anything yet that uses it to sign people in with it yet?

And what do you need to make it work? Need specifics, such as the ACME model 7120 barcode reader scanner with the USB cable , and a copy of the Super Barcode interpreter software from ABC Data.

Our unit is getting a lot of stuff done, and even hoping to host a SAREX or two. Would be a lot easier if all someone has to do is to walk in, run their 101 through a bar code scanner, and move to a staging area.

Anyway we could do this with no muss, fuss, or bathroom soap scum?

Pylon

It's the same barcode as your membership card and the new CAP Photo ID card.  It is simply your CAPID in a standard barcode format.  Pretty much any barcode reader peripheral for a computer will read the barcode and enter it into the computer as if somebody had just typed the CAPID numbers. 

SIMS allows for barcode reading to check-in people for attendance at an activity or meeting... simply check the "Activate Barcode CAPID Scan" checkbox and as you scan ID's you'll get a brief popup incidating "JOHN M. DOE has been marked as in attendance" (I'm paraphrasing here; probably not the exact wording).

Our squadron got a CueCat barcode reader off eBay, modified with a USB hookup, for approximately $10.  We use it to check in our members for attendance in SIMS.  It also reinforces for members the important of bringing their cards to the meeting.

I don't recall if the Encampment Management Program utilizes the barcode input at all.
Michael F. Kieloch, Maj, CAP

SJFedor

I believe Maj. Bob Koob from KYWG wrote a program that does that as well. I believe it's excel-based (used at NESA to keep track of us Aircrew types.)

Steven Fedor, NREMT-P
Master Ambulance Driver
Former Capt, MP, MCPE, MO, MS, GTL, and various other 3-and-4 letter combinations
NESA MAS Instructor, 2008-2010 (#479)

SarDragon

IIRC, the original version of the WMU used the barcodes, too. I'm not sure about IMU.
Dave Bowles
Maj, CAP
AT1, USN Retired
50 Year Member
Mitchell Award (unnumbered)
C/WO, CAP, Ret

JoeTomasone

Most bar code readers have what is called a "wedge" option -- which means a driver that converts the bar code read into simulated keyboard input.   The result is the same as if you had typed the information contained in the bar code on the keyboard.   This makes it compatible with any software.    So, if you had such a system, any place you needed to type the CAPID you could scan the bar code.


Eclipse

Excel does this out of the box with no extra drivers, macros or software - I didn't believe it either - try it.

Not, what you >do< with it once you read it is a different story.

"That Others May Zoom"

Hawk200

I've never actually played with SIMS at all, so I can't even begin to draw any conclusions as to how it might even work for us.

I'm probably a little over my head on what I'm thinking about, but I pretty much want something to update the National SQTR with the mission number. We could punch in the assignment stuff later, but the mission number would be logged for the individual. I know the SQTR allows multiple individual entry, it seems handy to just use it directly if possible.

I'm probably dreaming as far as what I'd like to see, but I figured the worst anyone could tell me is "That won't work." Am I dreaming, or is this something that could possibly work?

Psicorp

Does the barcode on the 101 contain the information on the 101 card or is it the same barcode that's on the membership card? 

We've been scanning people into Mission Base using the membership cards, but I've never seen the 101 card used for anything more than visual verification that someone is qualified for the position they seek to fill.
Jamie Kahler, Capt., CAP
(C/Lt Col, ret.)
CC
GLR-MI-257

Shotgun

OK . . . Real basic question:

What is SIMS?

(I've only been in CAP a year and don't have much practical ES mission experience.)



Eclipse

Quote from: pkloehn on May 21, 2008, 06:41:36 PM
OK . . . Real basic question:

What is SIMS?

(I've only been in CAP a year and don't have much practical ES mission experience.)

The only way to manage a Squadron's admin and records needs.

Available at squadroncommand.com

http://www.squadroncommand.com/filemgmt/index.php

Its an Access-based front end for Capwatch data and a full computer-based unit management system.

"That Others May Zoom"

afgeo4

Quote from: Pylon on May 21, 2008, 04:15:13 AM
It's the same barcode as your membership card and the new CAP Photo ID card.  It is simply your CAPID in a standard barcode format.  Pretty much any barcode reader peripheral for a computer will read the barcode and enter it into the computer as if somebody had just typed the CAPID numbers. 

SIMS allows for barcode reading to check-in people for attendance at an activity or meeting... simply check the "Activate Barcode CAPID Scan" checkbox and as you scan ID's you'll get a brief popup incidating "JOHN M. DOE has been marked as in attendance" (I'm paraphrasing here; probably not the exact wording).

Our squadron got a CueCat barcode reader off eBay, modified with a USB hookup, for approximately $10.  We use it to check in our members for attendance in SIMS.  It also reinforces for members the important of bringing their cards to the meeting.

I don't recall if the Encampment Management Program utilizes the barcode input at all.

I wonder how long it will be til some cadet tattoos his/her CAPID barcode onto his/her wrist or somethingrather.
GEORGE LURYE

Pylon

Quote from: Psicorp on May 21, 2008, 05:24:34 PM
Does the barcode on the 101 contain the information on the 101 card or is it the same barcode that's on the membership card? 

We've been scanning people into Mission Base using the membership cards, but I've never seen the 101 card used for anything more than visual verification that someone is qualified for the position they seek to fill.

The barcode is the same as the membership card and photo ID card: just the member's 6 digit CAPID number as a barcode.  No other special information is contained inherently in the barcode itself.  You could, however, tie that barcode to data stored on members to bring up information in a database.
Michael F. Kieloch, Maj, CAP

Tubacap

When the single CAPWATCH download comes through, won't this be a fairly easy thing to do in regards to ES Quals?
William Schlosser, Major CAP
NER-PA-001

Hawk200

From reading through, it looks like my only option is to have SIMS running at the check-in point, and then sync it with National.

How does that work? We've got a laptop or two that could be used for such a thing. Can we sync it to National records every few minutes? We've got secured wireless to expedite it.

MIKE

Can't upload with SIMS... Download via CAPWATCH only.
Mike Johnston

Hawk200

Quote from: MIKE on May 21, 2008, 10:45:22 PM
Can't upload with SIMS... Download via CAPWATCH only.

Delightful. From the sounds of it, there's no way to do what I'm theorizing. Maybe in a year or so.

sarflyer

For all you newbies in the SIMS world this is a great piece of software.  The only downfall it has is that you can't upload updated information to National's databases.   

That basically means you have to input all ES and Pilot stuff into E Services and also now the cadet achievements below Mitchell.  But when you download the Capwatch and tcapwatch it adds the data to SIMS without overwriting what you have already put in.

It is a a simple easy database program that requires MS Access.  Don't be scared off by it.  It's really not as hard as it might seem.  Easy to set up and can be networked within your squadron.  I have a server running in our unit with the main data files that is networked to all the computers at the unit.  You can have up to 255 users using the same database at the same time.

There is a lot to this program and I am willing to answer any questions that you might have.  There is no other program this well made out there today. 

Codos to Dennis Van der Vieren and all the others in CAP that helped him develop it over the last few years.
Lt. Col. Paul F. Rowen, CAP
MAWG Director of Information Technology
NESA Webmaster
paul.rowen@mawg.cap.gov

Hawk200

Quote from: sarflyer on May 22, 2008, 12:15:28 AM
The only downfall it has is that you can't upload updated information to National's databases. 

That's the problem. What I'd like to put together is something that will update the National SQTR entry when a person checks in. Basically, scan their ID card, and National records will show the mission participation immediately (more or less  ;)).

Having such a program at squadron level doesn't really mean much to me. I've been updating records for cadets for everything they do right after the meeting in e-services(at least as far as tests go). Saves a lot of time, but took me a while to get in all the cadets previous achievements.

RickFranz

At our last SAREX the USAF folks said it would be nice if we had some way of tracking, not only the members checking in, but also the where abouts of those members.  Say 6 people came in and 4 of them turned around and went out on a ground team and the other two got in a plane.  Other than going through all the paperwork how would we know.

I guess if we used the barcode system for check in, then on their way out have them swipe there card and then put a note as to where they where going, van XXXXX or aircraft XXXXX or lunch, we could keep track of who is out and who would be available for a mission.
Rick Franz, Col, CAP
KSWG CC
Gill Rob Wilson #2703
IC1

CadetProgramGuy

I knwo at one point in time Dennis was in front of TP with SIMS and he liked it.  There was also talk at one point in time to make SIMS "talk" to CAPWATCH and make it uploadable as well. 

Pretty sure nothing came of it though.