Solved

Barcode scanning applications and asset recording

Posted on 2016-10-18
7
80 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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