Jump to content

Send barcode input to 2 different applications


Recommended Posts

Needed a script that can do the following. Using a barcode scanner read a 6 digit number and then pass that number to 2 different applications that are on a 2 screen setup. Monitor one runs a Excel file that is looking for the 6 digit number to verify "membership"  Monitor 2 is used to send that same number to a chrome webpage that verifies "membership" to a different group.  Also (not needed but would be nice) is this. Monitor 2 screen needs to be "reset" after it verifies its membership. this is done by clicking on a input field displayed on the screen after the verify process. 

Sad to say I am not a programmer but have had some limited experience with Basic many years ago which is somewhat of a help. Perhaps there is a script out there that can be modified to do the task I have outlined above.  Thanks for looking at my problem.  

Link to post
Share on other sites

Hi @rbabler, and :welcome: to the AutoIt forum :)

Here we can assist you with your script, but to get you started, you may look at Excel UDF (list of functions here) to automate the Excel part, and IE UDF or WebDriver UDF to deal with the webpage.

You'll find a lot of examples which you can play with, so, just modify and test them to see if they fit your needs.

If you have any question or issue with your script, please don't be afraid and post it with the related question(s) :)

Click here to see my signature:

Spoiler

ALWAYS GOOD TO READ:

 

Link to post
Share on other sites

It depends what kind of output the barcode scanner generates. I purchased one several years ago, it sent the output to stdin as though the barcode had been typed on the keyboard. I imagine yours would be the same. I don't think you can easily split that to two different applications.

It would probably be easier to have one of your scripts handle the barcode and when it receives a valid code it can write the code to a local semaphore file which the second script would then read.

Phil Seakins

Link to post
Share on other sites
  • 2 weeks later...
On 3/30/2021 at 1:05 PM, FrancescoDiMuro said:

Hi @rbabler, and :welcome: to the AutoIt forum :)

Here we can assist you with your script, but to get you started, you may look at Excel UDF (list of functions here) to automate the Excel part, and IE UDF or WebDriver UDF to deal with the webpage.

You'll find a lot of examples which you can play with, so, just modify and test them to see if they fit your needs.

If you have any question or issue with your script, please don't be afraid and post it with the related question(s) :)

I thought I would be informed when a reply was posted but am not sorry for the late response.  From your post as of now the Excel portion is set so we can verify that half of the task. Want to clarify your links  IE UDF  this only works with Internet Explorer right, 

Link to post
Share on other sites
7 minutes ago, rbabler said:

Want to clarify your links  IE UDF  this only works with Internet Explorer right, 

Yes.
but you was pointed also to :
 WebDriver UDF 

Signature beginning:
Please remember: "AutoIt".....  Wondering who uses AutoIt and what it can be used for ?
* GHAPI UDF - modest beginning - communication with GitHub REST API Forum Rules *
Include Dependency Tree (Tool for analyzing script relations)
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST APIErrorLog.au3 UDF - A logging Library *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskSchedulerIE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) *

PDF Related:How to get reference to PDF object embeded in IE *

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

I also encourage you to check awesome @trancexx code:  * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuffOnHungApp handlerAvoid "AutoIt Error" message box in unknown errors  * HTML editor

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2021-03-17

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...