BARCODE READER 1

100dtl · Sep 16, 2003

Hi

Your gonna like this.. not a lot. :-o

I have a barcode reader than scna most codes, what i'd like to do is setup some asp to catch the scan and then match it in match list then just confirm it...is this possible and where do i start, i have it comuicating to my pc so that bit is sorted .

many thxs in advance for any help

Veep · Sep 16, 2003

It's really no differant than receiving typed-in user input. Here's an example page that contains 1 text box. An employee scans his or her ID card, the form submits to itself, checks the value and then does other stuff based on other conditions. This should get you going:

<%Response.Buffer="true"%>


<%
function GetLanID(username)
pos=instr(username,"\&quot

GetLanID=mid(username,pos+1)
end function
strName = request.servervariables("LOGON_USER&quot

strName = GetLanID(strName)
AuthUser()
IF AuthUser = FALSE then
response.Redirect("GotYa.asp?Page=EditPunch&quot

End IF
if request("flag&quot

<> "" then
flag=Request("flag&quot

else
flag=0
end if
PunchOut = FALSE
PunchIn = FALSE
%>
<html>
<head>
<title>Time Clock</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
th{font-family:tahoma;font-weight:bold;font-size:14px;}
td{font-family:tahoma;font-size:14px;}
h1{text-decoration:underline:font-family:tahoma;}
</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table align="center" width="100%" border="0">
<tr><td align="center"><h1>Fulfillment Time Clock</h1></td></tr>
</table>
<br><br><br><br>
<table width="50%" align="center" border="6" bordercolorlight="#F8BF24" bordercolordark="#000000" cellspacing="0" cellpadding="2">
<tr>
<th align="center">Please scan your ID card</th>
</tr>
<tr><td align="center">
<form name="input1" id="input1" action="<%=Request.ServerVariables("SCRIPT_NAME&quot

%>" method="post">
<input type="password" id="ScanValue" name="ScanValue" size="75" maxlength="75" >
<input type="hidden" name="flag" value="1">
</form>
</td>
</tr>
</table>
<script language="vbs">
input1.ScanValue.focus
</script>
<%If request("flag&quot

= 1 then
CardID = trim(cstr(request.form("ScanValue&quot

))

set conn=server.createobject("ADODB.CONNECTION&quot

conn.open myConnString
strSql = "SELECT EmpID, EmpName, Photo From tbl_c_Employees WHERE CardID = '" & CardID & "'"
set rs=conn.execute(strSql)
if not rs.eof then
if not isnull(rs("EmpID&quot

) then
EmpID = cint(rs("EmpID&quot

)
Photo = rs("Photo&quot

end if
EmpName = rs("EmpName&quot

response.write "<table align='center' border='0'><tr><td align='center'><font size='5'><br>" & EmpName & "<br><br><img src=" & Photo & " width='110' height='150'></td></tr></table>"
else
response.write "<table align='center' border='0'><tr><td align='center'><font color='red'>There is something wrong with your card.<br>Please see the administrator</td></tr></table>"
end if
set rs=nothing
strSql = "EXEC tc_sp_PunchTheClock @EmpID = " & EmpID & ",@UserID='" & strName & "'"
SET rs = Conn.execute(strSql)
InOrOut = rs(0)
myPunch = rs(1)
if InOrOut = 1 then ' Punching In
myVar = "In"
elseif InOrOut = 2 then ' Punching Out
myVar = "Out"
elseif InOrOut = 3 then ' Forgot to Punch Out
PunchOut = TRUE
myVar="Out"
elseif InOrOut = 4 then ' Forgot to Punch In
PunchIn = TRUE
end if
set rs=nothing
Conn.close
set conn=nothing
If PunchOut = TRUE then
response.write "<table align='center' border='0'><tr><td align='center'><font size='6'><b>You forgot to punch out yesterday. Please see the Administrator ASAP.</b></td></tr></table>"
elseif PunchIn = TRUE then
response.write "<table align='center' border='0'><tr><td align='center'><font size='6'><b>You forgot to punch IN Today. Please see the Administrator ASAP.</b></td></tr></table>"
else
response.write "<table align='center' border='0'><tr><td align='center'><font size='6'>" & "Punching <b><font color='#FF0000'>" & myVar & "</font><br>" & myPunch & "</b></td></tr></table>"
end if
end IF
%>
</body>
</html>

100dtl · Sep 16, 2003

Yeh but whats doing the scaning.. communication from the reader? calls to system etc..

thxs

Veep · Sep 16, 2003

Standard lazer barcode reader / keyboard wedge.

100dtl · Sep 16, 2003

Still dont know... Must be some call to the serial port or something

TwoOdd · Sep 16, 2003

Do you have a wireless barcode scanner that stores the information in memory? Or do you have a standard barcode reader that is plugged into your keyboard port? Sometimes, the wireless scanners have a base stand that is connected to the serial port. If that is the case, then the scanner should have come with instructions for downloading the data to your pc. It should create a text file and then you would have to import that into your application.

Much easier to use Veep's example with a standard barcode reader. Just use the keyboard wedge to plug both the keyboard and the barcode reader into the keyboard port. Place your cursor in the appropriate textbox and scan the barcode. The data would automatically be typed in the textbox as it is scanned.

Hope this helps answer your question.

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner

100dtl · Sep 17, 2003

No still not... Its basic serial port scanner and what i would like to do is add the code and quantity into XLS sheet at the same time update my database

100dtl · Sep 18, 2003

anymore help peeeeeeez?

medic · Sep 18, 2003

100dtl,

You should make a table containing the list of items with their barcodes. Make an HTML page that has a text field (inside form tags) to contain the barcodes you capture with the scanner. You then pass the barcode value to an ASP page, and then 'select' the right item on the server side.

Medic

medic · Sep 18, 2003

...Also check out this working sample:

<HTML>
<HEAD><TITLE>Barcode</TITLE></HEAD>
<BODY>
<%
barcode=request.form("barcode&quot

if barcode="" then
%>
<form name="frmBarcode" method=post action="<%=Request("SCRIPT_NAME&quot

%>">
Barcode (type-in or scan):<br>
<input name="barcode" maxlength=14>
<input name="OK" type="submit" value="Submit Barcode">
</form>
<script language="JavaScript">
document.frmBarcode.barcode.focus();
</script>
<%
else
Set CN = Server.CreateObject("ADODB.connection&quot

CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\MyDir\MyDB.mdb;"

set RS = CN.execute("select * from BARCODELIST where BARCODE='" _
& request.form("barcode&quot

& "'&quot

if RS.EOF then
%>
Barcode does not yet exist.<br>
<a href="<%=Request("SCRIPT_NAME&quot

%>">Try again</a>
<%
else
response.write("Barcode: " & RS("Barcode&quot

& "<br>&quot

response.write("Description: " & RS("Description&quot

& "<br>&quot

%>
<br><a href="<%=Request("SCRIPT_NAME&quot

%>">Scan another barcode</a>
<%
end if
end if
%>
</BODY>
</HTML>

To make this code work:
1) create a C:\MyDir folder
2) create an MS Access database named MyDB.mdb inside the folder
3) in your database, create a table named BARCODELIST
4) create text fields named Barcode and Description in your table

These could help you start with your barcoding.

Medic

icy111 · Sep 18, 2003

hi,

i'm also doing the barcode program in ASP with Access database. It works ok when it scan only 1 barcode in the textbox.

But, i need a multiple scanning of the barcodes in the textbox or listbox. (notsure which one is good.)
At the sametime, user can manually enter the barcode thru' the listbox/textbox. I have tried using listbox, but it disallowed user to enter.

Secondly, based on the scanning or manually enter, i have to count the no. of items being scanned and display in the another textbox.

All these steps have to be done before i click on the submit button. Which then saved into the Database.

I hope all of you understand what i am trying to say.
I have posted this in the Javascript Forum.

Thanks in advance, i seriously need help in this..urgently

Regards
icy111

medic · Sep 19, 2003

icy111,

You can assign a separate textbox to enter the quantity if you are scanning so many items with the same barcode.

Medic

icy111 · Sep 19, 2003

Medic

i am scanning many barcodes. I need to display how many(number) of barcodes i have scanned in another textbox.

Regards
icy111

Barry1 · Sep 21, 2003

100t,

If you have a serial port barcode scanner, then you will need some sort of software to catch the scnned information and send it to the open application.

If you had a PS/2 barcode scanner tha connected to a keyboard then it would automatically translate the barcode into charictors and inport those charictors into the open text box / text application you are running.

If it is a serial port scanner, the scanned data is lost at the serial port without an application to catch it.

Hope this helps,

Bary Smith
ASP, BKS, HTML, JS & CGI programmer.
BKS Graphic Design

100dtl · Sep 22, 2003

FYI... I got it working thxs...

cheers medic...

Now i need to do this but its the wrong forum

I am Excel basic... I need to scan the product, excel then looks in a function that then matches it with an SKU number and then the cell next to it adds one, if i scan the same product i want the sheet to regonize its in the list then the count is two, i think you can understand the rest...

:-o

G

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

BARCODE READER 1

100dtl

Programmer

Veep

Programmer

100dtl

Programmer

Veep

Programmer

100dtl

Programmer

TwoOdd

Programmer

100dtl

Programmer

100dtl

Programmer

medic

Programmer

medic

Programmer

icy111

Programmer

medic

Programmer

icy111

Programmer

Barry1

Programmer

100dtl

Programmer

Similar threads

Part and Inventory Search

Sponsor