[jawsscripts] Re: automating commands to extract info from web site?
- From: "Don Marang" <donald.marang@xxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2011 13:52:41 -0500
Pressing Alt + F5 is a shortcut to update all external data. Give it a try.
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: Wednesday, March 02, 2011 7:08 AM
To: <jawsscripts@xxxxxxxxxxxxx>
Subject: [jawsscripts] Re: automating commands to extract info from web
site?
> Hi all,
> Well I downloaded the following spreadsheet:
> StockQuoteTemplate.xls
> I go to data, import data, web query
> but web quiry is only new and edit web query is unavailable. Has anyone
> used this spreadsheet to gather stock info?
>
> I thought this spreadsheet was ready to use but when I go to data menu,
> import from external, I crash.
> ----- Original Message -----
> From: "Reed Poynter" <Reed.Poynter@xxxxxxxxx>
> To: <jawsscripts@xxxxxxxxxxxxx>
> Sent: Wednesday, March 02, 2011 1:00 AM
> Subject: [jawsscripts] Re: automating commands to extract info from web
> site?
>
>
>> It sounds to me that you could really use the Web Query facility in Excel
>> 2003. It is found under data, import data, web query.
>> If you Google "excel 2003 web query", you will find several sites that
>> show
>> you how to use it.
>>
>> Quite often, I will use the record a macro facility to capture the steps
>> taken to create an import. Then I will edit the recorded macro to
>> customize
>> it and/or to edit the data imported.
>>
>> I have found Excel's record a macro feature to be invaluable in learning
>> to
>> use macros. If I want to find out how to do something in a macro, I will
>> start recording, walk through the steps required to do that something on
>> the
>> keyboard, stop recording and go look at the macro created. This process
>> has
>> saved me from many hours of frustration.
>>
>> Good luck.
>>
>> Reed
>>
>> -----Original Message-----
>> From: jawsscripts-bounce@xxxxxxxxxxxxx
>> [mailto:jawsscripts-bounce@xxxxxxxxxxxxx] On Behalf Of Ann Marie Medlar
>> Sent: March-01-11 6:43 PM
>> To: jawsscripts@xxxxxxxxxxxxx
>> Subject: [jawsscripts] Re: automating commands to extract info from web
>> site?
>>
>> 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
>>
>> __________�
>>
>> 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: