vB Regex Error Detection

This is a sample of "stub" code using REGEX (regular expressions) to find predefined Error words 

    1. detect and skip  Windows Certificate Errors or similar Error page that IE may surprise the user with
    2. Fill in a Login Form
  • To WORK: it needs you to identify the (login or other) form elements
    1. identify a unique STRING in the unexpected  Error (Certificate) page
'________________________

FunctioncheckForError(strErr,strTag)' returns 1 of 3 strings FULL LARGE INNERTEXT STRING IF ERR FOUND, ELSE "PASS"
Dimnames,ele,innerText,outerText,temp,bFlag' used as string to debug
temp="":bFlag=False' flag True if ERR FOUND, false if ERR NOT FOUND
Setnames=objIE.Document.getElementsByTagName(strTag)

' sample: needs IE page object to be defined and navigated to as current page, having login form elements

' CHECKING for and bypassing MICROSOFT CERTIFICATE WARNING



isUnsafe=findClickOkIfUnsafe("not recommended",testLinks)'bad string is first param signalling certificate error

ifisUnsafe>=0then

testLinks(isUnsafe-1).Click'(1) works if HARD CODED FROM OBSERVATION - code returns (2) ??
' testLinks(isUnsafe).Click ' using index as boolean???? xyz
callwaitForReady(objIE)' do this after each click on menu
endif

' self documenting comments by doing "find" of H4 tag or any desired flag/tag

' LEAVING MICROSOFT CERTIFICATE WARNING INTO LOG IN PAGE



'_________ functions / subroutines _________

FunctionfindClickOkIfUnsafe(strInnerText,someArray)' returns index if any member of someArray has "bad string"
dimk,foundAt,strtmp
foundAt=-1
strtmp=""
'msgbox "array length: " & someArray.length,,"from Function findClickOkIfUnsafe" ' for debugging, tells you where you are
for k = 0 to someArray.length-1'LBound(someArray) to UBound(someArray)
If (boolRegExMatch ( someArray( k ).innerText, trim(strInnerText)) > 0)then
'booltemp = True '( True OR booltemp)
foundAt= k
exit for
end if
next 'k

findClickOkIfUnsafe=foundAt ' if for/next never entered then returns -1 from second line
End Function

'________________________

FunctionboolRegExMatch(regx,strng) ' returns COUNT no it's NOT boolean!!!!
Dim regEx,Match,Matches,n,tmp ' Create variable.
SetregEx=NewRegExp ' Create a regular expression.
regEx.Pattern=regx ' Set pattern.
regEx.IgnoreCase=True ' Set case insensitivity.
regEx.Global=True ' Set global applicability.
SetMatches=regEx.Execute(strng)' Execute search.
boolRegExMatch=Matches.count
setMatches=Nothing
setRegEx=Nothing
End Function

'________________________

FunctioncheckForError(strErr,strTag)' returns 1 of 3 strings FULL LARGE INNERTEXT STRING IF ERR FOUND, ELSE "PASS"
Dimnames,ele,innerText,outerText,temp,bFlag' used as string to debug
temp="":bFlag=False' flag True if ERR FOUND, false if ERR NOT FOUND
Setnames=objIE.Document.getElementsByTagName(strTag)

Foreacheleinnames
innerText=ele.innerText
If(boolRegExMatch(strErr,innerText)>0)Then
'If Instr(1, innerText, strErr) Then
temp="Fail: "&innerText' innerText

exitFor' only reports first error found!?
Else
temp="PASS"
EndIf
Next
checkForError=temp
EndFunction
'________________________
FunctionfnLogin(uid,pwd)
Diminputs,strPageStatus
Setinputs=objIE.Document.getElementsByTagName("INPUT")

' inputs(1).Value = uid
' on Error Resume Next
inputs(2).Value=uid
inputs(3).Value=pwd
inputs(4).Click

' on Error GoTo 0
' If Err.Number then strPageStatus = "FAILERROR: CLOSE DUPLICATE BROWSER SESSION" & vbCrlf & Err.Description else
waitForReady(objIE)
strPageStatus=checkForError(".*password.*incorrect.*|Prohibite.*","DIV")'prefixes "Failed:" to InnerText
' End If
fnLogin=strPageStatus
EndFunction

'________________________

FunctioncheckForError(strErr,strTag)' returns 1 of 3 strings FULL LARGE INNERTEXT STRING IF ERR FOUND, ELSE "PASS"
Dimnames,ele,innerText,outerText,temp,bFlag' used as string to debug
temp="":bFlag=False' flag True if ERR FOUND, false if ERR NOT FOUND
Setnames=objIE.Document.getElementsByTagName(strTag)

Foreacheleinnames
innerText=ele.innerText
If(boolRegExMatch(strErr,innerText)>0)Then
'If Instr(1, innerText, strErr) Then
temp="Fail: "&innerText' innerText

exitFor' only reports first error found!?
Else
temp="PASS"
EndIf
Next
checkForError=temp
EndFunction
'________________________

Leave a Reply

Your email address will not be published. Required fields are marked *