Solved

Barcode scanning applications and asset recording

Posted on 2016-10-18
7
56 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

919 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

15 Experts available now in Live!

Get 1:1 Help Now