[jawsscripts] Re: automating commands to extract info from web site?
- From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Tue, 1 Mar 2011 19:35:08 -0500
Hi all,
Well I have Excel 2003 and I googled macro programming and a tutorial is
available for excel so I think I'll try it in the morning. Thanks for all
your help.
Someone recommended macro express but it costs $$ and I rather try the free
stuff first.
----- Original Message -----
From: "Don Marang" <donald.marang@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Tuesday, March 01, 2011 4:48 PM
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> JAWS scripts gets a little more complicated in this scenario since it is
> not for a single application. Therefore, it probably would needed to be
> added to your default scripts. This can easily screw up JAWS if you even
> get a simple compile error due to a mistyped character. I would not
> recommend beginners write default scripts.
>
> Freedom Scientific now has some documentation on their website to write
> rule
> and query files for ResearchIt. It uses some open language built around
> SQL
> type code to generate text in the virtual buffer. You would need to copy
> all then paste the results even after writing the rules file.
>
> I think using Microsoft's tools built into Excel would be your best bet.
> This may include specifying an external data source, internal functions,
> macros and edit it's own Visual Basic that the macros can generate.
>
> One thing to check that might make any automation easier is to check if
> the
> stock symbol, like ARMH, shows up somewhere in the address bar after you
> type in the signal and hit enter on the Go button. If so, you can bypass
> the edit box and go directly to the results page. Copy the entire URL in
> the address bar. I am not familiar with Excel's syntax for grabbing data
> from websites, but this URL will be critical. You can most likely replace
> the symbol text typed into the edit box with a cell coordinate to work
> with
> any symbol. I would attempt to place each piece of information you
> currently append to clipboard to separate cells or areas of cells.
>
> Don Marang
> Vinux Software Development Coordinator (vinux.org.uk)
>
> There is just so much stuff in the world that, to me, is devoid of any
> real
> substance, value, and content that I just try to make sure that I am
> working
> on things that matter.
> Dean Kamen
>
>
> --------------------------------------------------
> From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
> Sent: Tuesday, March 01, 2011 1:32 PM
> To: <jawsscripts@xxxxxxxxxxxxx>
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>> Hi James and all:
>> I typed my keystrokes below after my note that I need to automate. My
>> problem is that I know how to find the info in terms of Jaws but not in
>> terms in a web language. So if you or anyone knows what the web
>> language
>> is for heading, table, copy and append to clipboard,
>> F8 key please let me know so I know what to look for to automate using
>> this
>> utility. I just began reading the documentation. I was a mainframe
>> computer programmer but don't know any PC languages. Any help
>> appreciated.
>> Thanks,
>> Ann
>> Keystrokes:
>> Open site:
>> http://www.barChart.com
>> Note: edit box is part of a table
>> type e for edit and enter ticker symbol
>> I type ARMH for Arm Holdings
>> tab to go and enter
>> type h for heading for company name
>> control+c to copy heading containing company name
>> type t for table containing Stock price info
>> up arrow once
>> press f8 to select all table info
>> windows+c to append table info
>> type t for table
>> up arrow
>> F8 to highlight table info containing 2nd Resistance Point
>> windows+c to append table info
>> Find heading containing Today's Opinion which is a link and enter
>> Literals from web site:
>> Detailed Opinion Show Signal Strength and Direction
>> table has 4 columns and 34 rows
>> F8 to highlight table containing todays opinion
>> windows+c to append
>> alt+F4 to exit site
>> alt+control+N for NotePad
>> Control+v to paste
>> Control+s to save
>> Prompt user for file name
>>
>>
>>
>>
>>
>> http://barchart.com/opinions/stocks/ARMH
>> ----- Original Message -----
>> From: "Homme, James" <james.homme@xxxxxxxxxxxx>
>> To: <jawsscripts@xxxxxxxxxxxxx>
>> Sent: Tuesday, March 01, 2011 12:38 PM
>> Subject: [jawsscripts] Re: automating commands to extract info from web
>> site?
>>
>>
>>> Hi Ann,
>>> To be honest with you, it's going to be difficult unless you absolutely
>>> know you will be putting in the same exact command sequence. If you want
>>> to do it through scripting, you could do it, but if I were you, I would
>>> look into this free tool. http://seleniumhq.org/
>>>
>>> Jim
>>> -----Original Message-----
>>> From: jawsscripts-bounce@xxxxxxxxxxxxx
>>> [mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie Medlar
>>> Sent: Tuesday, March 01, 2011 12:18 PM
>>> To: jawsscripts@xxxxxxxxxxxxx
>>> Subject: [jawsscripts] Re: automating commands to extract info from web
>>> site?
>>>
>>> Hi all,
>>> If I write out a series of windows and jaws commands sequentially to go
>>> to
>>> web, prompt to enter info in edit box, use Jaws to navigate info, copy
>>> and
>>> append info then alt+control+N for NotePad and then paste info and save
>>> text
>>> file.
>>> could some of you give me guidance to script?
>>> I would love to automate this processs because it would save me so much
>>> time.
>>> thanks for any feedback.
>>> I use Jaws 11 or 12 and xP Media.
>>> Thank you so much.
>>> Ann
>>>
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> http://www.freelists.org/list/jawsscripts
>>>
>>>
>>> This e-mail and any attachments to it are confidential and are intended
>>> solely for use of the individual or entity to whom they are addressed.
>>> If
>>> you have received this e-mail in error, please notify the sender
>>> immediately and then delete it. If you are not the intended recipient,
>>> you must not keep, use, disclose, copy or distribute this e-mail without
>>> the author's prior permission. The views expressed in this e-mail
>>> message
>>> do not necessarily represent the views of Highmark Inc., its
>>> subsidiaries,
>>> or affiliates.
>>> __________�
>>>
>>> View the list's information and change your settings at
>>> http://www.freelists.org/list/jawsscripts
>>>
>>
>> __________�
>>
>> View the list's information and change your settings at
>> http://www.freelists.org/list/jawsscripts
>>
>>
> __________�
>
> View the list's information and change your settings at
> http://www.freelists.org/list/jawsscripts
>
__________�
View the list's information and change your settings at
http://www.freelists.org/list/jawsscripts
Other related posts: