Scan Phone Mac Addresses via Barcode scanner

Answered Question
Nov 1st, 2009
User Badges:

Hello Folks,


How do you scan the mac addresses into an excel / CSV sheet so that these can be imported into via BAT?


I was thinking of buying a USB handheld scanner but not sure of any inexpensive / free OCR application that will help populate the scanned image into text.


Thanks in advance.


dpsharma

Correct Answer by Steven Smith about 7 years 8 months ago

That is exactly what you need to do.  Good luck.

Correct Answer by Steven Smith about 7 years 8 months ago

Actually, mine had no software either.  I think it was detected as a USB keyboard and just worked.  It was a cheapest USB scanner I could find.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Steven Smith Mon, 11/02/2009 - 07:30
User Badges:
  • Gold, 750 points or more

This isn't really the right place for the question because BAT doesn't work with Small Business products.


I do however have some experience with a USB bar code scanner on in Excel.  You don't need anything to convert the image, at least with the one that I used, which was a very cheap scanner.  It would simply read the code and the text was placed into an Excel spreadsheet.  I think I had to hit enter after every scan, but it did save a good amount of time. 

Devinder Sharma Mon, 11/02/2009 - 08:43
User Badges:

Thanks Steven. I needed it for a CME, which I thought was a small business product. But you are right, I should have tried in more appropriate forum.


The cheap USB scanners that I am looking at, do not mention anything as to accompanying application and I am sure the one that you had used in the past, would have come with some software application as well.


Anyone much appreciate your help and I will do some more research to find out a suitable scanner. I am a freelancer supporting some small businesses for Cisco products.


dpsharma

Correct Answer
Steven Smith Mon, 11/02/2009 - 08:46
User Badges:
  • Gold, 750 points or more

Actually, mine had no software either.  I think it was detected as a USB keyboard and just worked.  It was a cheapest USB scanner I could find.

Devinder Sharma Mon, 11/02/2009 - 08:53
User Badges:

Excellent. So I assume that all I need to import that into excel is to select the cell and scan the barcode and it will automatically populate into the cell.


Appreciate again your help and support Steven.


dpsharma

Correct Answer
Steven Smith Mon, 11/02/2009 - 09:02
User Badges:
  • Gold, 750 points or more

That is exactly what you need to do.  Good luck.

arronwall1 Fri, 05/30/2014 - 00:18
User Badges:

Hi,

As for me, I am also testing about excel barcode add-in these days. Do you have any ideas about it? Or any good suggestion? Thanks in advance.

 

Best regards,
Arron

Actions

This Discussion