Solved

Barcode scanning applications and asset recording

Posted on 2016-10-18
7
49 Views
Last Modified: 2016-11-09
I am looking to test Barcode scanning applications and asset recording. Can anyone recommend a good "free" or trial application / software that I can use to test the viability of such systems?

Or have a script that can run in Excel to scan barcode to predetermined columns.
Eg: Using predefined barcodes.
1st barcode - Scan barcode to determine object type
2nd barcode- Scan to determine column to populate
3rd barcode- Scan to enter the barcode information

Any advice gratefully received.
0
Comment
Question by:gavin_d
  • 4
  • 3
7 Comments
 
LVL 57
ID: 41848142
On the bar code scanning, most scanners are "wedge" type devices that get installed between a PC and a keyboard.

In doing that, you can type on the keyboard or scan a bar code whenever the PC is waiting for input, be it in Excel or whatever.  Of course there are more sophisticated setups (ie. wireless, scans stored in a gun, etc) if you need those.

As far as the scans you outlined, typically the way it works is that each asset is given a unique number.  You scan one bar code and then have all the information on it.

In terms of the app, there is a lot more to fixed assets then just the tracking and it depends on what your looking for.   One of the better known ones is Sage Fixed Assets Accounting:

http://www.sage.com/us/sage-fixed-assets

 I don't believe they have a free trial, but there's plenty of info there to show you what I'm talking about.

But given what I said about the scanning, I'd focus on what you want the app to do for you.  The scanning really is just an add on.

Jim.
0
 

Author Comment

by:gavin_d
ID: 41856323
Jim, thanks for the input. I am looking for a "more - sophisticated" solution than what the professional scanner I have at the moment does. Give it a bar code it will scan it, however it does not manage the input into relevant - computer - laptop - smartphone categories - which is what I suspect the professional software would allow me to do.
In theory - as above - I could define an individual bar-code to represent an individual "type" then follow it with the actual items bar-code.
Our fixed assets tend to be x150+ of a particular type - so any additional item information is generic.
Scanning manufacturer bar-codes negates mistakes in part number or serial number input - especially when having to manually input using the keyboard.
Eventually the "spreadsheets" will be rendered ready for input / importing into our asset management system.
But that is a little way off.
0
 
LVL 57
ID: 41856333
What make/model scanner are you using now?

Jim.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:gavin_d
ID: 41876198
Apologies Jim for the tardiness of reply. Usually responses to my questions are sent to my email.
This did not happen.
I will be in work tomorrow and will get the make and model of the scanning device
0
 

Author Comment

by:gavin_d
ID: 41876750
Device:
Honeywell - Hand scanner
Powered by - AdoptUs Imaging Technology
Item: 4600GSF051CE
S/N: 10145B0018
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 41879228
OK, there are a couple of different ways that gun can be programmed and it is not a "wedge" type device.

<<Give it a bar code it will scan it, however it does not manage the input into relevant - computer - laptop - smartphone categories - which is what I suspect the professional software would allow me to do.>>

  Yes and no.   As I mentioned previously, the simplest way to go is with the wedge type scanner.  Using that, you can easily develop your own applications in Excel, Access, etc.  Anything beyond that requires custom programming to some extent to make it work.

 At that point, your stuck with:

a. an Application that has that built-in already (ie:  https://www.waspbarcode.com/asset-tracking )

or

b. doing it yourself using tools available from the mfg of the equipment (ie:  https://www.honeywellaidc.com/products/software)

 My advice would be to shop for the package you want ensuring that it includes the required bar code hooks.

Jim.
0
 

Author Closing Comment

by:gavin_d
ID: 41881338
While this concurs with my thoughts, your additional recommendations and ideas have been invaluable in assisting me.
I am currently exploring Excel (where the scanner will input - straight dig - as the typographers used  to refer), where the scanner will input into a pre-formatted page layout.
Thanks again
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 72
Access MDB/PDF 21 32
Macro 3 21
Insert rows based on cell value vba 3 12
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now