CaptainBeardsEyesBeard Posted September 6, 2018 Posted September 6, 2018 (edited) Hi So I have a website with a simple grid layout. Clciking into each folder will either produce more folders or a report (in a same grid setup). There's different amounts of folders and reports in each folder ranging from 0 to lots. I was wondering if there is a way to automate this in a better way than I'm currently doing At the moment I'm going into each folder and seeing how many reports are in there then doing something like this For $Y = 0 To 1 For $X = 0 To 4 User_Reporting_WAA_WAA_Reporting_Querying(($X * 202) + 141, ($Y * 76) + 330) Next Next where the function looks like this Func User_Reporting_WAA_WAA_Reporting_Querying($Xin, $Yin) OpenIE("http://devsite/folder1") Click_UserReporting() Click_Grid_1_5() Click_Grid_1_2() MouseClick('primary', $Xin, $Yin, 1) EndFunc So essentially I'm just using mouse clicks to run these reports. Is there a more sensible/quicker way to automate this. Edited September 6, 2018 by CaptainBeardsEyesBeard
FrancescoDiMuro Posted September 6, 2018 Posted September 6, 2018 @CaptainBeardsEyesBeard Without seeing the webpage, I think that it could be a bit difficult By the way, if you're automating Web stuffs, use _IE* functions ( as @jdelaney suggested you here ), or use one of these UDF. Cheers Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette
CaptainBeardsEyesBeard Posted September 6, 2018 Author Posted September 6, 2018 OK so here's a pic of the inside of one folder which has both folders and reports in. If you clicked into a new folder they'd be either more folders/more reports or nothing. (3.png) The home page would just be a similar layout of grids of folders (similar in spacing to the pic)
FrancescoDiMuro Posted September 6, 2018 Posted September 6, 2018 @CaptainBeardsEyesBeard Did you try to automate this with _IE* functions? Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette
CaptainBeardsEyesBeard Posted September 6, 2018 Author Posted September 6, 2018 Hmm I'm looking at the IE functions but the site is basically all javascript generated.
AutoBert Posted September 6, 2018 Posted September 6, 2018 (edited) 1 hour ago, CaptainBeardsEyesBeard said: Hmm I'm looking at the IE functions but the site is basically all javascript generated. you can insert additional code also to handle the existing scrpts. Quote _IEHeadInsertEventScript Inserts a Javascript into the Head of the document Edited September 6, 2018 by AutoBert
jdelaney Posted September 6, 2018 Posted September 6, 2018 (edited) As long as you can see the nodes in the dom object, it doesn't matter how the page is built. it might be that you will have to loop until the page fully updates. the exception would be things like flash. Edited September 6, 2018 by jdelaney IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now