Macro Express Pro Screen Scraping

[sathiya Sugumaran]

Hi ,

I am using Macro Express 4.4.1.1 how to do screen Scraping by using Macro ?

Source is from Web Page

[Look_Up]

If the text is selectable use hold left mouse down, select the text with mouse move, release the left mouse key and save the content into clipboard.

 

Sample:

 

Mouse Move: 309, 356 Relative to Screen
Delay: 500 milliseconds
Mouse Left Button Down
Delay: 500 milliseconds
Mouse Move: 340, 356 Relative to Screen
Delay: 500 milliseconds
Mouse Left Button Up
Delay: 500 milliseconds
Clipboard Copy
Delay: 500 milliseconds
Variable Set String %content_clipboard% from the clipboard contents

Source:

<MOUSE MOVE Option="\x01" X="309" Y="356" _PROMPT="0x000A"/>
<DELAY Flags="\x02" Time="500"/>
<MOUSE LEFT BUTTON DOWN/>
<DELAY Flags="\x02" Time="500"/>
<MOUSE MOVE Option="\x01" X="340" Y="356" _PROMPT="0x000A"/>
<DELAY Flags="\x02" Time="500"/>
<MOUSE LEFT BUTTON UP/>
<DELAY Flags="\x02" Time="500"/>
<CLIPBOARD COPY/>
<DELAY Flags="\x02" Time="500"/>
<VARIABLE SET STRING Option="\x02" Destination="%content_clipboard%" NoEmbeddedVars="FALSE"/>

Another read out technique is to work with (external) scripts, eg javascript.

 

Look_Up

[terrypin]

Or:

 

Mouse move, to right hand end of text box

Text Type Shift Home, to select all the text

Clipboard Copy

 

Terry, East Grinstead, UK

[Cory]

I used to do a lot of scraping with MEP but it's very difficult with large batches and I moved on to writing proper applications to do this instead. But before then I often found that downloading the raw HTML file and processing it as a text file was much faster and less prone to error. I simply had a VBScript I would use to download the file then process with MEP.

 

If you're serious about a scraping solution feel free to contact me via PM as I am available for hire.