azurtem

Hi

Thanks for your responses

Does anyone have a sample macro that deals with raw html pages ?

regards

yann

Hi

 

I have a list of data in a table on a web page which I'd like to select and copy

 

I first place my mouse cursor at the beginning of the range (upper left hand corner),

I then hold down the left button,

and I move to the mouse cursor to the diagonnaly opposite (lower right hand corner)

and then I let go of the left mouse button

Finally I execute a clipboard copy

 

<MOUSE MOVE Option="\x01" X="800" Y="1111" _PROMPT="0x000A"/>
<DELAY Flags="\x02" Time="50"/>
<MOUSE LEFT BUTTON DOWN/>
<DELAY Flags="\x02" Time="50"/>
<MOUSE MOVE Option="\x01" X="2110" Y="370" _PROMPT="0x000A"/>
<DELAY Flags="\x02" Time="50"/>
<MOUSE LEFT BUTTON UP/>
<DELAY Flags="\x02" Time="50"/>
<CLIPBOARD COPY/>
<DELAY Flags="\x02" Time="50"/>

When I execute this, the selection heads in the opposite direction

I tried "[upper left] to [lower right]" as well as "[lower right] to [upper left]" : same result

What am I not understanding ?

 

regards

yann

 

 

Thanks again for your reply

 

The routine which can detect a mouse cursor change when a new clickable "zone" is detected could do the trick since they are all in the same column

I will have to determine the maximum number of pixels by which to move so as to avoid running up the list too fast or too slow

 

regards

yann

 

Thanks for sharing your code with me

 

I am using Edge to extract my data; since I don't use this browser for anything else

 

Since posting my request I have managed to control Edge's search tool to repeatedly find and click on the "next page" link; so now all the sought transactions are visible on the web page

 

The remaining issue isn't as easy to figure out

 

The bank's developpers also 'hid' the details of each transaction : 

 

 

Thus if I want to include the hidden details with my extraction I will have to click on every "v" symbol on each line 

 

The "v" symbol however isn't 'selectable'

 

Once clicked the details become visible : 

 

 

I had initially planned to use a repeat routine in order to move the mouse cursor from line to line in order to click on the symbol so as to display the hidden details 

 

Unfortunately, as you can tell from the screen capture, some transactions have two lines, while others have up to four lines of details

Thus the mouse move is not an option

 

A bubble appears when hovering over the "v" symbol with the word "Déplier"

 

This word "Déplier" is searchable via Edge's search tool so I could once again use it to go through each "v" occurence 

 

The thing is, I don't see how to obtain mouse coordinates of, or even how to set focus on, the result of the Edge 'search' result

 

Any ideas ?

 

regards

yann

 

 

 

 

Hi

 

I wish to display all bank wire transactions, present in my bank account, in a browser window 

 

Unfortunately, my bank's web site only displays a page length at a time; you have to click a link situated at the bottom of the page in order to display more transactions :

 

 

Therefore, one has to navigate to the end of the list on the current display in order to click on a "next page" link [::after == $0]

This will extend the display, towards the bottom, with an additional page full of bankwire transactions

You must repeat this process until there are no more available transactions to display 

 

Is it possible to search for the string "next page" using macro commands ?

    If so then what will Macro Express provide ? Focus on the searched text (first occurrence found) ?

    Or must I control/pilot the browser's own search function ?

 

regards

yann

 

 

 

 

The issue, I discovered a few minutes ago is that the server expects sftp connexions 

I'm trying to setup a batch fine, as suggested, in order to use Winscp instead

 

thanks rberq

 

I was thinking that since I'm using the free version maybe not all the commands are fully functional

Thanks acantor

I can already view the response since it is stored in a variable :

Name	Value
FTP_transfer	macex.txt - 200 Type set to A
200 PORT command successful

Hi

 

I have the following lines in a script : 

<FTP SEND FILE Filename="C:\\temp\\macex.txt" Mode="\x00" Log_To="%FTP_transfer%"/>
<DELAY Flags="\x01" Time="5"/>

 

The log file confirms execution : 

jeudi 22 septembre 2022 09:56:26:463: Line 15: FTP Send File

 

The variable indicates success :

Name	Value
FTP_transfer	macex.txt - 200 Type set to A
200 PORT command successful

 

Yet the resulting transfered file is empty :

 

I've checked the knowledge base : no entries when searching on "FTP"

The user forum doesn't seem to contain anything similar either

 

It's probably a silly newbie mistake but I can't see where I'm going wrong

 

Any tips, ideas, recommendations ?

 

regards

yann