Retrieve div value based on name

[sammy1983]

17 minutes ago, iamtheky said:

add is the layperson term, for offering as an addendum.  He means quite literally copy that function and paste it into your script (at the very bottom would probably be the most logical place) prior to hitting F5/F7.

Thanks for clarifying iamtheky. I did that now.  

[sammy1983]

46 minutes ago, mLipok said:

As I said add this function to your main script.

mLipok, I added the function at the bottom of the main script and received outputs, however, I didn't get anything having folderid value.  

[MichaelHB]

15 minutes ago, sammy1983 said:

My apologies MichaelHB.

I tried this earlier and no success.  

Make sure you are attaching to the right "instance" of the IE. I tested that code here in differents websites, always work.

Have you tried again with that code ? What are the error(s) it gives?

Can you share the website you are trying to do that?

[mLipok]

I'm sorry but I'm a little busy today.
By this, even I misread your opening post.

Now I think the example from @MichaelHB is easier way.
Keep following his sugestion to this case.

Sorry for confusion.

btw.

 did you read:    How to use IE.au3  UDF with  AutoIt v3.3.14.x 

[sammy1983]

15 minutes ago, MichaelHB said:

Make sure you are attaching to the right "instance" of the IE. I tested that code here in differents websites, always work.

Have you tried again with that code ? What are the error(s) it gives?

Can you share the website you are trying to do that?

Here is my complete code. Due to security reasons, I will not be able to reveal the actual site.

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(5000)

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

$oIEF = _IEAttach("Talent Record", "instance", 1)
$Elements = $oIEF.document.getElementsByName("folderid")
MsgBox(0, "Number of Elements", $Elements.length)
For $i = 0 to $Elements.length - 1
    MsgBox(0, "Element number: " & $i+1, $Elements.item($i).value)
Next

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

[MichaelHB]

Try this way. Look at the comments in the code.

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

;$oIEF = _IEAttach("Talent Record", "instance", 1) ; why are you attaching again? this is the same website in $oIE right?

$Elements = $oIE.document.getElementsByName("folderid")
MsgBox(0, "Number of Elements", $Elements.length) ;tell me how many elements this returns? 5?

For $Element In $Elements
    MsgBox(0, "Element Value", $Element.value) ;if this gives you any error, paste the error.
Next

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

[sammy1983]

9 minutes ago, MichaelHB said:

Try this way. Look at the comments in the code.

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

;$oIEF = _IEAttach("Talent Record", "instance", 1) ; why are you attaching again? this is the same website in $oIE right?

$Elements = $oIE.document.getElementsByName("folderid")
MsgBox(0, "Number of Elements", $Elements.length) ;tell me how many elements this returns? 5?

For $Element In $Elements
    MsgBox(0, "Element Value", $Element.value) ;if this gives you any error, paste the error.
Next

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

Here you go....

No. of elements - 10

Error below

 

[MichaelHB]

This probably mean that some elements with that name "folderid" does not have any value, we could check one by one looking with ".hasAttributes()", but lets try a different approach. Try this:

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

Local $aFolderID = StringRegExp($sHTML, '(?i)<div value="(.*?)" name="folderid"></div>', 3)
_ArrayDisplay($aFolderID) ;tell me with this shows the result that you want

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

Edited March 29, 2016 by MichaelHB
Changed the StringRegExp to global (i dont know if theres more than one match)

[sammy1983]

1 hour ago, MichaelHB said:

This probably mean that some elements with that name "folderid" does not have any value, we could check one by one looking with ".hasAttributes()", but lets try a different approach. Try this:

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

Local $aFolderID = StringRegExp($sHTML, '(?i)<div value="(.*?)" name="folderid"></div>', 3)
_ArrayDisplay($aFolderID) ;tell me with this shows the result that you want

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

Nope. No output. I even tried with the below format. Any problem with the StringExpression?

$sHTML = _IEDocReadHTML($oIE)
$array6 = StringRegExp($sHTML, '(?i)<div value="(.*?)" name="folderid"></div>', 3)
For $q = 0 To UBound($array6) - 1
    $FolderID = $array6[$q]
    MsgBox(0, "", $FolderID)
Next

 

[mLipok]

_IEFrameGetCollection($oIE, -1)
MsgBox(0, 'Frame count', @extended)

What you see ?

[sammy1983]

2 minutes ago, mLipok said:

_IEFrameGetCollection($oIE, -1)
MsgBox(0, 'Frame count', @extended)

What you see ?

 

[mLipok]

So this should help you:

Local $oIE2 = _IEFrameGetCollection($oIE, 1)

Now try to use this new $oIE2.

HINT: Each frame is different document.

EDIT:
You can also try to use:

Local $oIE2 = _IEFrameGetCollection($oIE, 0)

 

Edited March 29, 2016 by mLipok

[sammy1983]

8 minutes ago, mLipok said:

So this should help you:

Local $oIE2 = _IEFrameGetCollection($oIE, 1)

Now try to use this new $oIE2.

HINT: Each frame is different document.

EDIT:
You can also try to use:

Local $oIE2 = _IEFrameGetCollection($oIE, 0)

 

I used the below codes, no output. Am I doing anything wrong?

Local $oIE2 = _IEFrameGetCollection($oIE, 0)
$sHTML = _IEDocReadHTML($oIE2)
$array6 = StringRegExp($sHTML, '<div(?i) value="(.*?)" name="folderid"></div>', 3)
For $q = 0 To UBound($array6) - 1
    $FolderID = $array6[$q]
    MsgBox(0, "", $FolderID)
Next

Local $oIE2 = _IEFrameGetCollection($oIE, 1)
$sHTML = _IEDocReadHTML($oIE2)
Local $aFolderID = StringRegExp($sHTML, '(?i)<div value="(.*?)" name="folderid"></div>', 3)
_ArrayDisplay($aFolderID) ;tell me with this shows the result that you want

 

[MichaelHB]

Lets check something sammy1983, use this code and paste the code in the notepad that look if you can find this expression: name="folderid"

 

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
ConsoleWrite($sHTML)
ClipPut($sHTML)
exit

I used the piece of the html code that is in your first post. The "_IEDocReadHTML($oIE)" should extract the outerhtml and if the element "folderid" exists you should be able to find in the notepad.

[sammy1983]

9 minutes ago, MichaelHB said:

Lets check something sammy1983, use this code and paste the code in the notepad that look if you can find this expression: name="folderid"

 

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
ConsoleWrite($sHTML)
ClipPut($sHTML)
exit

I used the piece of the html code that is in your first post. The "_IEDocReadHTML($oIE)" should extract the outerhtml and if the element "folderid" exists you should be able to find in the notepad.

5 instances as below.

<div name="folderid" value="82992"></div>
<div name="folderid" value="82992"></div>
<div name="folderid" value="82992"></div>
<div name="folderid" value="82992"></div>
<div name="folderid" value="82992"></div>

 

[MichaelHB]

Now i see, the sample you provide in the first post was incorret (as i suspect) . Try this:

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

Local $aFolderID = StringRegExp($sHTML, '(?i)<div name="folderid" value="(.*?)"></div>', 3)
_ArrayDisplay($aFolderID) ;tell me with this shows the result that you want

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

[sammy1983]

17 minutes ago, MichaelHB said:

Now i see, the sample you provide in the first post was incorret (as i suspect) . Try this:

expandcollapse popup

#NoTrayIcon

#include <IE.au3>
#include <Date.au3>
#include <String.au3>
#include <Array.au3>
#include <Debug.au3>
#include <Excel.au3>
#include <Constants.au3>
#include <GUIConstantsEx.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>

Dim $aRecords

Local $FolderID, $HWND, $RKey, $BRID, $oIE, $oIE1, $oFrames, $test
Local $m, $n, $p, $test1, $CandName, $array, $array1, $array2, $array3

Local $RKey = InputBox("Talent Record", "Enter Candidate Ref ID", "", "", 50)

$oIE = _IECreate("https://abcd.com" & $RKey)

Sleep(15000) ;make sure the website is completely loaded

$sHTML = _IEDocReadHTML($oIE)
$array2 = StringRegExp($sHTML, '(?i)pageHeaderCandidateName">\s*(.*?)\s*</(?i)span>', 3)
For $p = 0 To UBound($array2) - 1
    $CandName = $array2[$p]
    ExitLoop
Next

Local $aFolderID = StringRegExp($sHTML, '(?i)<div name="folderid" value="(.*?)"></div>', 3)
_ArrayDisplay($aFolderID) ;tell me with this shows the result that you want

MsgBox(64, "Record Located - " & $RKey, "Found candidate - " & $CandName & ". Preparing Talent Record.")

Exit

 

Awesome!!!!

 

[MichaelHB]

Glad you could do it.

[sammy1983]

25 minutes ago, MichaelHB said:

Glad you could do it.

Hey MichaelHB... Thanks a ton for your help today. No words to express my gratitude. Thanks again. 

$sHTML = _IEDocReadHTML($oIE)
Local $aFolderID = StringRegExp($sHTML, '(?i)<div name="folderid" value="(.*?)"></div>', 3)
For $q = 0 To UBound($aFolderID) - 1
    $FolderID = $aFolderID[$q]
    MsgBox(0, "Success", $FolderID)
Next

 

Edited March 29, 2016 by sammy1983