[jawsscripts] Re: automating commands to extract info from web site?
- From: "Ann Marie Medlar" <amedlar1@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Tue, 1 Mar 2011 21:43:16 -0500
Hi Don,
Thanks for all your help so far. No money yet but maybe after I get my
procedure automated. LOL
Anyway here is link for a tutorial. I did lesson 1 and hope I can follow
directions without the pictures. I really should learn some Visual Basic.
http://www.excel-vba.com/excel-macros-beginners.htm
----- Original Message -----
From: "Don Marang" <donald.marang@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Tuesday, March 01, 2011 8:06 PM
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> Try hitting F1 in Excel for help and typing something similar to "web
> data"
> in the search box. I have Office 2007, so I do not know if all of the
> great
> features are available in 2003. What you want is some type of web query.
> I
> attempted to follow the directions in the help, but not all of the steps
> in
> the help were easily accessible. You should be able to select a table on
> the webpage and Excel helps you create a new web query. In Excel 2007,
> You
> can also create a web query through the ribbon: Data > Web Source >
> (probably available in the 2003 menus).
>
> It may be easier to copy one of the examples of web queries that come with
> Excel. Some of them are also to look up stock quotes. Then you can edit
> the query and change it's properties. In the properties, there are
> interesting features such as determining when the data is refreshed or
> continually updated. I think Alt + F5 will manually ask if you want to
> update the external sources.
>
> If I give you any more help, you will need to provide me a percentage of
> everything you make on the market (not the losses)! <grin>
>
> 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 7:35 PM
> To: <jawsscripts@xxxxxxxxxxxxx>
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>> 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
>>
>>
> __________�
>
> 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: