montecas Posted October 3, 2006 Share Posted October 3, 2006 Hey everyone, I am trying to write a script to grab data from one window specifically a program used at work to display the sales from the day, and then input that data into an excel workbook. I have no idea where to begin, any help would be greatly appriciated! Link to comment Share on other sites More sharing options...
Kickassjoe Posted October 3, 2006 Share Posted October 3, 2006 Search the scripts and scrapts forum for "OCR" (without the quotes) What goes around comes around... Payback's a bitch. Link to comment Share on other sites More sharing options...
Thatsgreat2345 Posted October 3, 2006 Share Posted October 3, 2006 is it in text or picture format and there is an excel UDF in scripts and scraps Link to comment Share on other sites More sharing options...
Confuzzled Posted October 5, 2006 Share Posted October 5, 2006 What is the program that displays the sales called? Does it have a particualr layout on the screen or a report writer interface? Does it use a web browser to see the results? Does it support C.O.M.? You may be able to 'screen scrape' the contents and paste into Excel or pass it through an intermediatary file in something like CSV format. Link to comment Share on other sites More sharing options...
montecas Posted October 5, 2006 Author Share Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window. Link to comment Share on other sites More sharing options...
Xenobiologist Posted October 5, 2006 Share Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window.Hi,take Autoit Window Info to check whether you can read the text.So long,Mega Scripts & functions Organize Includes Let Scite organize the include files Yahtzee The game "Yahtzee" (Kniffel, DiceLion) LoginWrapper Secure scripts by adding a query (authentication) _RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...) Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc. MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times Link to comment Share on other sites More sharing options...
Skizmata Posted July 4, 2007 Share Posted July 4, 2007 (edited) Hi,take Autoit Window Info to check whether you can read the text.So long,MegaWhat if you can read the text how would you then get it? I need something similar to read a string of numbers out of an AS400 Emulator for work. I need to be able to pull a number from the screen add it to a number I enter in the program and put it back in place of the number I took from the screen.Thanks,-Skizmata Edited July 4, 2007 by Skizmata AutoIt changed my life. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now