?
Solved

Barcode scanning applications and asset recording

Posted on 2016-10-18
7
Medium Priority
?
103 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 58
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 58
ID: 41856333
What make/model scanner are you using now?

Jim.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

777 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