Jump to content
yjing1982

IE form auto fill

Recommended Posts

yjing1982

I would like to perform the Auto-fill on IE. but when I use _IEFormGetCollection(), it just returns 30 forms, but all name is "0". Now I want to get the handle for the form and filled into the data, What should I do for the next step. the below forum is for returning the quantity and form. name, and the attached files is for what I want to fill in, and the HTML source code.

$oForms = _IEFormGetCollection($oIE)
MsgBox(0,"",@extended)
For $oForm In $oForms
    MsgBox(0,"",$oForm.name)
Next

 Desktop.rar

Edited by yjing1982

Share this post


Link to post
Share on other sites
yjing1982

I would like to perform the Auto-fill on IE. but when I use _IEFormGetCollection(), it just returns 30 forms, but all name is "0". Now I want to get the handle for the form and filled into the data, What should I do for the next step. the below forum is for returning the quantity and form. name, and the attached files is for what I want to fill in, and the HTML source code.

$oForms = _IEFormGetCollection($oIE)
MsgBox(0,"",@extended)
For $oForm In $oForms
    MsgBox(0,"",$oForm.name)
Next

 Desktop.rar

parts of  the source code

 
<style> 
INPUT { BACKGROUND: #ffffff; BORDER-BOTTOM: #305B8B 1px solid; BORDER-LEFT: #305B8B 1px solid; BORDER-RIGHT: #305B8B 1px solid; BORDER-TOP: #305B8B 1px solid; COLOR: #305B8B; FONT-SIZE: 12px; HEIGHT: 20px; PADDING-TOP: 3px}
A {
    COLOR: #000000; TEXT-DECORATION: underline
}
A:hover {
    TEXT-DECORATION: none
}
body { 
SCROLLBAR-FACE-COLOR: #396DA5; SCROLLBAR-HIGHLIGHT-COLOR: #305B8B; 
SCROLLBAR-SHADOW-COLOR: #799AE1; SCROLLBAR-DARKSHADOW-COLOR: #799AE1; 
SCROLLBAR-3DLIGHT-COLOR: #FFFFFF; SCROLLBAR-ARROW-COLOR: #FFFFFF;
SCROLLBAR-TRACK-COLOR: #FFFFFF;
}
SELECT {
    BORDER-RIGHT: 0.2em groove; BORDER-TOP: 0.2em groove; FONT-SIZE: 0.7em; BORDER-LEFT: 0.2em groove; BORDER-BOTTOM: 0.2em groove; FONT-FAMILY: tahoma,verdana,geneva,sans-serif
}
a.INPUT { }
</style>
<html>
<head>
<title>Magnum2x</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style> 
INPUT.text { BACKGROUND: #ffe0b3; BORDER-BOTTOM: #af6700 1px solid; BORDER-LEFT: #af6700 1px solid; BORDER-RIGHT: #af6700 1px solid; BORDER-TOP: #af6700 1px solid; COLOR: #af6700; FONT-SIZE: 12px; HEIGHT: 18px; PADDING-TOP: 3px}
INPUT.ipDisableStyle { BACKGROUND: #f5f5f5; BORDER-BOTTOM: #a9a9a9 1px solid; BORDER-LEFT: #a9a9a9 1px solid; BORDER-RIGHT: #a9a9a9 1px solid; BORDER-TOP: #a9a9a9 1px solid; COLOR: #af6700; FONT-SIZE: 12px; HEIGHT: 18px; PADDING-TOP: 3px}
.button1 {
    BORDER-RIGHT: #af6700 1px solid; BORDER-TOP: #ffd16e 1px solid; FONT-SIZE: 12px; BACKGROUND: #ff9600; BORDER-LEFT: #ffd16e 1px solid; COLOR: #964700; PADDING-TOP: 3px; BORDER-BOTTOM: #af6700 1px solid; HEIGHT: 21px
}
.button
    {
        border-right: #af6700 1px solid;
        padding-right: 2px;
        border-top: #af6700 1px solid;
        padding-left: 2px;
        font-size: 12px;
        FILTER: progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=#ffe4e1, EndColorStr=#ff8c00);
        border-left: #af6700 1px solid;
        cursor: hand;
        color: #964700; 
        padding-top: 2px;
        border-bottom: #af6700 1px solid;
    }
SELECT.stext { BACKGROUND: #ffe0b3; BORDER-BOTTOM: #af6700 1px solid; BORDER-LEFT: #af6700 1px solid; BORDER-RIGHT: #af6700 1px solid; BORDER-TOP: #af6700 1px solid; COLOR: #af6700; FONT-SIZE: 12px; HEIGHT: 18px; PADDING-TOP: 3px}
.DisabledTextarea{
    border:1px solid #999;
    width: 226px;
    FONT-SIZE: 12px; 
    SCROLLBAR-FACE-COLOR: #a9a9a9;
    SCROLLBAR-HIGHLIGHT-COLOR: #a9a9a9;
    SCROLLBAR-ARROW-COLOR: #a9a9a9;
}
</style>
</head>
 
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" align="center" border="0" bgcolor="black" cellspacing="1" cellpadding="3" name="PM SHEET" style="font-size:9pt">
  <tr bgcolor="#FFFFFF"> 
    <td colspan="4" style="font-size:10pt"> <b><font color="#FF0000">PM SHEET 
      (Magnum2x)</font></b> </td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td colspan="4"><font color="#0000FF">YEAR 2015</font></td>
  </tr>
  <tr align="center"  bgcolor="#dddddd"> 
    <td><strong>MODEL</strong></td>
    <td><strong>SERIAL NO</strong></td>
    <td><strong>INSTALL DATE</strong></td>
    <td><strong>MACHINE NO</strong></td>
  </tr>
  <tr align="center" bgcolor="#FFFFFF"> 
    
    <td>Magnum 2X</td>
    <td>847108</td>
    <td>2013-1-18</td>
    <td>TS-MAG-010</td>
    
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td colspan="4">
    
         
      <p><font color="#0000FF">
       
           WEEKLY
        <br>
       
          N/A
          
       
       </font>
      </p>
      <p>
      
      </p>
      
     
         
      <p><font color="#0000FF">
       
           A.MONTHLY
        <br>
       
       &nbsp;&nbsp;1..Air filter cleaning<br>
       
       &nbsp;&nbsp;2.System critical files backup to server<br>
       
       &nbsp;&nbsp;3.Run systemdiag<br>
       
       &nbsp;&nbsp;4.Run Voltage calibration / verification<br>
       
       &nbsp;&nbsp;5..ESD check between tester shell and facility GND less than 10ohm<br>
       
       &nbsp;&nbsp;6.Inspect if there is any broken,loosen,stuck pogo pins, replace bad one<br>
       
       &nbsp;&nbsp;7.Input EPM system <br>
              
      <table border="0" width="100%"  bgcolor="black" cellspacing="1" cellpadding="3" style="font-size:9pt">
        <tr align="center" bgcolor="#CCCCCC"> 
          <td></td>
          <td><b>ITEM</b></td>
          <td><b>PMDATE</b></td>
          <td><b>SCHEDULED DATE</b></td>
          <td><b>RESULTS</b></td>
          <td><b>ACTION</b></td>
          <td><b>PM SORT</b></td>
          <td><b>CAL.DATA</b></td>
          <td><b>REMARK</b></td>
          <td><b>RESPONSIBILITY</b></td>
          <td><b>EFFECTIVE DATE</b></td>
        </tr>
 
        <form action="GroupCheck.asp" method="post">
        <input type="hidden" value="3650" name="machineId"> 
        <input type="hidden" value="7" name="itemCount">
        <input type="hidden" value="1" name="itemType">
        <input type="hidden" value="TS-MAG-010" name="machineno">
        <input type="hidden" value="14230" name="scheduleId">
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <td rowspan="7"><font color="red"> 
              
              M1
              </font></td>
            
            <td rowspan="7"> 
              
              <input type="SUBMIT" class="button" value="SUBMIT101" name="SUBMIT"> 
              <a name="#1"></a><input type="hidden" value="1" name="z_id">
              <input type="hidden" value="627970" name="check_id"> <input type="hidden" value="1" name="type_id"> 
              <input type="hidden" value="3650" name="id"> <input type="hidden" value="271" name="pid"><input type="hidden" value="1" name="frequency"> 
              <input type="hidden" value="Magnum2x" name="pmtype"><input type="hidden" value="mod" name="upType"> </td>
            
            <td rowspan="7">
              <input type="text" value="2015-1-16" class="text" size="8" name="pmdate" readonly>
            </td>
            <td rowspan="7">             
              2015-1-16
              <input type="hidden" value="2015-1-16" class="text" size="8" name="scheduled_date">
            </td>
            
            <input type="hidden" value="627970" name="historyPMId1">
            <input type="hidden" value="1" name="itemNo1">
            <td><font color="#0000FF">1</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results1"></td>
            <td><textarea name="action1" cols="30" rows="2" wrap="VIRTUAL" class="text" >cleaned</textarea></td>
            <td>
                <select name="selectCalibrationSort1" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark1" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility1"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627971" name="historyPMId2">
            <input type="hidden" value="2" name="itemNo2">
            <td><font color="#0000FF">2</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results2"></td>
            <td><textarea name="action2" cols="30" rows="2" wrap="VIRTUAL" class="text" >backup</textarea></td>
            <td>
                <select name="selectCalibrationSort2" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark2" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility2"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627972" name="historyPMId3">
            <input type="hidden" value="3" name="itemNo3">
            <td><font color="#0000FF">3</font>&nbsp;<input type="text" value="pass" class="text" size="24" name="results3"></td>
            <td><textarea name="action3" cols="30" rows="2" wrap="VIRTUAL" class="text" >Run systemdiag
</textarea></td>
            <td>
                <select name="selectCalibrationSort3" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark3" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility3"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627973" name="historyPMId4">
            <input type="hidden" value="4" name="itemNo4">
            <td><font color="#0000FF">4</font>&nbsp;<input type="text" value="pass" class="text" size="24" name="results4"></td>
            <td><textarea name="action4" cols="30" rows="2" wrap="VIRTUAL" class="text" >Run Voltage calibration / verification
</textarea></td>
            <td>
                <select name="selectCalibrationSort4" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark4" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility4"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627974" name="historyPMId5">
            <input type="hidden" value="5" name="itemNo5">
            <td><font color="#0000FF">5</font>&nbsp;<input type="text" value="1.2ohm" class="text" size="24" name="results5"></td>
            <td><textarea name="action5" cols="30" rows="2" wrap="VIRTUAL" class="text" >checked</textarea></td>
            <td>
                <select name="selectCalibrationSort5" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark5" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility5"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627975" name="historyPMId6">
            <input type="hidden" value="6" name="itemNo6">
            <td><font color="#0000FF">6</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results6"></td>
            <td><textarea name="action6" cols="30" rows="2" wrap="VIRTUAL" class="text" >inspected</textarea></td>
            <td>
                <select name="selectCalibrationSort6" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark6" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility6"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="627976" name="historyPMId7">
            <input type="hidden" value="7" name="itemNo7">
            <td><font color="#0000FF">7</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results7"></td>
            <td><textarea name="action7" cols="30" rows="2" wrap="VIRTUAL" class="text" >input</textarea></td>
            <td>
                <select name="selectCalibrationSort7" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark7" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility7"></td>
            <td>2012-10-16</td>
          </tr>
        
        
        </form>

--------------------------------------------------------------------------------------------------------------------------------------------------

       B.QUARTERLY
        <br>
       
       &nbsp;&nbsp;1.DC power supply voltage measure and adjust<br>
       
       &nbsp;&nbsp;2.Run voltage calibration/verification<br>
       
       &nbsp;&nbsp;3.Run timing calibration/verification<br>
       
       &nbsp;&nbsp;4.Run TDR calibration for DUT board <br>
              
      <table border="0" width="100%"  bgcolor="black" cellspacing="1" cellpadding="3" style="font-size:9pt">
        <tr align="center" bgcolor="#CCCCCC"> 
          <td></td>
          <td><b>ITEM</b></td>
          <td><b>PMDATE</b></td>
          <td><b>SCHEDULED DATE</b></td>
          <td><b>RESULTS</b></td>
          <td><b>ACTION</b></td>
          <td><b>PM SORT</b></td>
          <td><b>CAL.DATA</b></td>
          <td><b>REMARK</b></td>
          <td><b>RESPONSIBILITY</b></td>
          <td><b>EFFECTIVE DATE</b></td>
        </tr>
 
        <form action="GroupCheck.asp" method="post">
        <input type="hidden" value="3650" name="machineId"> 
        <input type="hidden" value="4" name="itemCount">
        <input type="hidden" value="2" name="itemType">
        <input type="hidden" value="TS-MAG-010" name="machineno">
        <input type="hidden" value="14230" name="scheduleId">
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <td rowspan="4"><font color="red"> 
              
              Q1
              </font></td>
            
            <td rowspan="4"> 
              
              <input type="SUBMIT" class="button" value="SUBMIT201" name="SUBMIT"> 
              <a name="#92"></a><input type="hidden" value="92" name="z_id">
              <input type="hidden" value="668548" name="check_id"> <input type="hidden" value="2" name="type_id"> 
              <input type="hidden" value="3650" name="id"> <input type="hidden" value="271" name="pid"><input type="hidden" value="1" name="frequency"> 
              <input type="hidden" value="Magnum2x" name="pmtype"><input type="hidden" value="mod" name="upType"> </td>
            
            <td rowspan="4">
              <input type="text" value="2015-3-29" class="text" size="8" name="pmdate" readonly>
            </td>
            <td rowspan="4">             
              2015-3-29
              <input type="hidden" value="2015-3-29" class="text" size="8" name="scheduled_date">
            </td>
            
            <input type="hidden" value="668548" name="historyPMId1">
            <input type="hidden" value="1" name="itemNo1">
            <td><font color="#0000FF">1</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results1"></td>
            <td><textarea name="action1" cols="30" rows="2" wrap="VIRTUAL" class="text" >measure and adjust
</textarea></td>
            <td>
                <select name="selectCalibrationSort1" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark1" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility1"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="668549" name="historyPMId2">
            <input type="hidden" value="2" name="itemNo2">
            <td><font color="#0000FF">2</font>&nbsp;<input type="text" value="pass" class="text" size="24" name="results2"></td>
            <td><textarea name="action2" cols="30" rows="2" wrap="VIRTUAL" class="text" >Run voltage calibration/verification</textarea></td>
            <td>
                <select name="selectCalibrationSort2" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark2" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility2"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="668550" name="historyPMId3">
            <input type="hidden" value="3" name="itemNo3">
            <td><font color="#0000FF">3</font>&nbsp;<input type="text" value="pass" class="text" size="24" name="results3"></td>
            <td><textarea name="action3" cols="30" rows="2" wrap="VIRTUAL" class="text" >Run timing calibration/verification</textarea></td>
            <td>
                <select name="selectCalibrationSort3" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark3" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility3"></td>
            <td>2012-10-16</td>
          </tr>
        
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <input type="hidden" value="668551" name="historyPMId4">
            <input type="hidden" value="4" name="itemNo4">
            <td><font color="#0000FF">4</font>&nbsp;<input type="text" value="pass" class="text" size="24" name="results4"></td>
            <td><textarea name="action4" cols="30" rows="2" wrap="VIRTUAL" class="text" >Run TDR calibration</textarea></td>
            <td>
                <select name="selectCalibrationSort4" class="stext" >
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                N/A
            
            </td>
            <td><input type="text" value="" class="text" size="12" name="remark4" ></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility4"></td>
            <td>2012-10-16</td>
          </tr>
        
        
        </form>
        
        <form action="GroupCheck.asp" method="post">
        <input type="hidden" value="3650" name="machineId"> 
        <input type="hidden" value="4" name="itemCount">
        <input type="hidden" value="2" name="itemType">
        <input type="hidden" value="TS-MAG-010" name="machineno">
        <input type="hidden" value="14230" name="scheduleId">
        --------------------------------------------------------------------------------------------------------------------------------

   E.Post PM Check

  <br>

  

  &nbsp;&nbsp;1.Post PM check for data validation<br>

    

      <table border="0" width="100%"  bgcolor="black" cellspacing="1" cellpadding="3" style="font-size:9pt">

        <tr align="center" bgcolor="#CCCCCC"> 

          <td></td>

          <td><b>ITEM</b></td>

          <td><b>PMDATE</b></td>

          <td><b>SCHEDULED DATE</b></td>

          <td><b>RESULTS</b></td>

          <td><b>ACTION</b></td>

          <td><b>PM SORT</b></td>

          <td><b>CAL.DATA</b></td>

          <td><b>REMARK</b></td>

          <td><b>RESPONSIBILITY</b></td>

          <td><b>EFFECTIVE DATE</b></td>

        </tr>

 

        <form action="GroupCheck.asp" method="post">

        <input type="hidden" value="3650" name="machineId"> 

        <input type="hidden" value="1" name="itemCount">

        <input type="hidden" value="5" name="itemType">

        <input type="hidden" value="TS-MAG-010" name="machineno">

        <input type="hidden" value="14230" name="scheduleId">

        

            

          <tr align="center" bgcolor="#E8E8E8"> 

            

            <td rowspan="1"><font color="red"> 

              

              M1

              </font></td>

            

            <td rowspan="1"> 

              

              <input type="SUBMIT" class="button" value="SUBMIT501" name="SUBMIT"> 

              <a name="#108"></a><input type="hidden" value="108" name="z_id">

              <input type="hidden" value="627977" name="check_id"> <input type="hidden" value="5" name="type_id"> 

              <input type="hidden" value="3650" name="id"> <input type="hidden" value="271" name="pid"><input type="hidden" value="1" name="frequency"> 

              <input type="hidden" value="Magnum2x" name="pmtype"><input type="hidden" value="mod" name="upType"> </td>

            

            <td rowspan="1">

              <input type="text" value="2015-1-16" class="text" size="8" name="pmdate" readonly>

            </td>

            <td rowspan="1">             

              2015-1-16

              <input type="hidden" value="2015-1-16" class="text" size="8" name="scheduled_date">

            </td>

            

            <input type="hidden" value="627977" name="historyPMId1">

            <input type="hidden" value="1" name="itemNo1">

            <td><font color="#0000FF">1</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results1"></td>

            <td><textarea name="action1" cols="30" rows="2" wrap="VIRTUAL" class="DisabledTextarea" disabled>N/A</textarea></td>

            <td>

                <select name="selectCalibrationSort1" class="stext" disabled>

                    <option value="0" >--SELECT--</option>

                    <option value="1" selected>Normal PM item</option>

                    <option value="2" >Calibrate PM item</option>

                </select>

            </td>

            <td>

            

                <font color="#a9a9a9">N/A</font>

            

            </td>

            <td><input type="text" value="N/A" class="ipDisableStyle" size="12" name="remark1" disabled></td>

            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility1"></td>

            <td>2012-10-16</td>

          </tr>

        

        

        </form>

        E.Post PM Check
           <br>
       
       &nbsp;&nbsp;1.Post PM check for data validation<br>
              
      <table border="0" width="100%"  bgcolor="black" cellspacing="1" cellpadding="3" style="font-size:9pt">
        <tr align="center" bgcolor="#CCCCCC"> 
          <td></td>
          <td><b>ITEM</b></td>
          <td><b>PMDATE</b></td>
          <td><b>SCHEDULED DATE</b></td>
          <td><b>RESULTS</b></td>
          <td><b>ACTION</b></td>
          <td><b>PM SORT</b></td>
          <td><b>CAL.DATA</b></td>
          <td><b>REMARK</b></td>
          <td><b>RESPONSIBILITY</b></td>
          <td><b>EFFECTIVE DATE</b></td>
        </tr>
 
        <form action="GroupCheck.asp" method="post">
        <input type="hidden" value="3650" name="machineId"> 
        <input type="hidden" value="1" name="itemCount">
        <input type="hidden" value="5" name="itemType">
        <input type="hidden" value="TS-MAG-010" name="machineno">
        <input type="hidden" value="14230" name="scheduleId">
        
            
          <tr align="center" bgcolor="#E8E8E8"> 
            
            <td rowspan="1"><font color="red"> 
              
              M1
              </font></td>
            
            <td rowspan="1"> 
              
              <input type="SUBMIT" class="button" value="SUBMIT501" name="SUBMIT"> 
              <a name="#108"></a><input type="hidden" value="108" name="z_id">
              <input type="hidden" value="627977" name="check_id"> <input type="hidden" value="5" name="type_id"> 
              <input type="hidden" value="3650" name="id"> <input type="hidden" value="271" name="pid"><input type="hidden" value="1" name="frequency"> 
              <input type="hidden" value="Magnum2x" name="pmtype"><input type="hidden" value="mod" name="upType"> </td>
            
            <td rowspan="1">
              <input type="text" value="2015-1-16" class="text" size="8" name="pmdate" readonly>
            </td>
            <td rowspan="1">             
              2015-1-16
              <input type="hidden" value="2015-1-16" class="text" size="8" name="scheduled_date">
            </td>
            
            <input type="hidden" value="627977" name="historyPMId1">
            <input type="hidden" value="1" name="itemNo1">
            <td><font color="#0000FF">1</font>&nbsp;<input type="text" value="ok" class="text" size="24" name="results1"></td>
            <td><textarea name="action1" cols="30" rows="2" wrap="VIRTUAL" class="DisabledTextarea" disabled>N/A</textarea></td>
            <td>
                <select name="selectCalibrationSort1" class="stext" disabled>
                    <option value="0" >--SELECT--</option>
                    <option value="1" selected>Normal PM item</option>
                    <option value="2" >Calibrate PM item</option>
                </select>
            </td>
            <td>
            
                <font color="#a9a9a9">N/A</font>
            
            </td>
            <td><input type="text" value="N/A" class="ipDisableStyle" size="12" name="remark1" disabled></td>
            <td><input type="text" value="yjing1982" class="text" size="16" name="responsibility1"></td>
            <td>2012-10-16</td>
          </tr>
        
        
        </form>

Share this post


Link to post
Share on other sites
yjing1982

Bump by myself

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • rm4453
      By rm4453
      I have a table I am parsing, to find specific vehicle information. I am unable to get _ArrayFindAll to return the only valid result with my test data.
      Below is a sample of the table's HTML:
      <td class="textCenter">2010</td> <td>TOYOTA</td> <td>TACOMA 4X4 DB</td> <td></td> <td>BLACK</td> <td class="textCenter">C</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">80,975</td> <td class="textRight" nowrap="nowrap">$16,800</td> </tr> <tr><!-- 308 --> <td class="textCenter">2010</td> <td>TOYOTA</td> <td>TACOMA 4X4 RG</td> <td></td> <td>BLACK</td> <td class="textCenter">R</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">5</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">95,224</td> <td class="textRight" nowrap="nowrap">$9,500</td> </tr> <tr><!-- 309 --> <td class="textCenter">2011</td> <td>BUICK</td> <td>REGAL</td> <td>CXL RL4</td> <td>BLACK</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">102,694</td> <td class="textRight" nowrap="nowrap">$5,000</td> </tr> <tr><!-- 310 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>AVALANCH 4X4 CR</td> <td>LS</td> <td>GRAY</td> <td class="textCenter">C</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">64,759</td> <td class="textRight" nowrap="nowrap">$16,300</td> </tr> <tr><!-- 311 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>EQUINOX AWD 4C</td> <td>LT W/2LT</td> <td>BLACK</td> <td class="textCenter">S</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">AWD</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">91,896</td> <td class="textRight" nowrap="nowrap">$4,400</td> </tr> <tr><!-- 312 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>TAHOE 4X4 V8</td> <td>LTZ</td> <td>WHITE</td> <td class="textCenter">S</td> <td class="textCenter">8</td> <td>C</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>N</td> <td class="textCenter">MR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">126,982</td> <td class="textRight" nowrap="nowrap">$17,800</td> </tr> <tr><!-- 313 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LT</td> <td>GRAY</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>GAS</td> <td class="textCenter">O</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">60,303</td> <td class="textRight" nowrap="nowrap">$18,100</td> </tr> <tr><!-- 314 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LT</td> <td>SILVER</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">O</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">89,403</td> <td class="textRight" nowrap="nowrap">$15,900</td> </tr> <tr><!-- 315 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LTZ</td> <td>BLUE</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">53,087</td> <td class="textRight" nowrap="nowrap">$17,700</td> </tr> <tr><!-- 316 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>3500 CUTAWAY</td> <td>WORK VAN</td> <td>WHITE</td> <td class="textCenter">S</td> <td class="textCenter"></td> <td></td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter"></td> <td>N</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">202,477</td> <td class="textRight" nowrap="nowrap">$2,700</td> </tr> <tr><!-- 317 --> <td class="textCenter">2011</td> <td>CHRYSLER</td> <td>TOWN &amp; COUNTRY</td> <td>TOURING</td> <td>BLACK</td> <td class="textCenter">4</td> <td class="textCenter">6</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter"></td> <td class="textRight" nowrap="nowrap">198,541</td> <td class="textRight" nowrap="nowrap">$1,900</td> </tr> <tr><!-- 318 --> <td class="textCenter">2011</td> <td>DODGE</td> <td>DURANGO AWD V6</td> <td>CREW</td> <td>BLUE</td> <td class="textCenter">S</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">AWD</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">176,036</td> <td class="textRight" nowrap="nowrap">$2,800</td> </tr> <tr><!-- 319 --> <td class="textCenter">2011</td> <td>FORD</td> <td>FOCUS</td> <td>SE</td> <td>SILVER</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">101,929</td> <td class="textRight" nowrap="nowrap">$3,100</td> </tr> <tr><!-- 320 --> <td class="textCenter">2011</td> <td>FORD</td> <td>FUSION FWD 4C</td> <td>SEL</td> <td>WHITE</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">78,290</td> <td class="textRight" nowrap="nowrap">$5,500</td> </tr> <tr><!-- 321 --> <td class="textCenter">2011</td> <td>FORD</td> <td>F150 4X4 CR</td> <td>XLT</td> <td>BLACK</td> <td class="textCenter">C</td> <td class="textCenter">8</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">70,909</td> <td class="textRight" nowrap="nowrap">$16,000</td> </tr> <tr><!-- 322 --> <td class="textCenter">2011</td> <td>FORD</td> <td>MUSTANG V6 CPE</td> <td>V6 PREMIUM</td> <td>BLACK</td> <td class="textCenter">2</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">92,531</td> <td class="textRight" nowrap="nowrap">$2,700</td> </tr> <tr><!-- 323 --> <td class="textCenter">2011</td> <td>GMC</td> <td>ACADIA FWD</td> <td>SLE</td> <td>RED</td> <td class="textCenter">4</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">79,199</td> <td class="textRight" nowrap="nowrap">$10,700</td> A picture of the table test data is attached here:

      Here is the _query function, and all other relevant code that I can share.
       
      Func _query($aSel, $aUrls) $oIE = _login() If $oIE = "Return" Then Return EndIf $j = 0 While $j < UBound($aSel) - 1 $i = 1 $aucID ;Unable To Share What This Is Other Than Var Name. _IENavigate($oIE, "Something" & $aucID[0] & "Something") _IELoadWait($oIE, 100, 2000) $oObj = _IETableGetCollection($oIE, 3) $cars = _IETableWriteToArray_ProgressBar($oObj, True, "Processing Requested Information!") ;<---- Modified Version See Post For It: https://www.autoitscript.com/forum/topic/195335-solved-how-to-add-a-progress-bar-to-_ietablewritetoarray/?tab=comments#comment-1400699 $carsYear = _filter($cars, 0, 0, GUICtrlRead($year)) $carsMake = _filter($carsYear, 0, 1, GUICtrlRead($make)) Global $carsModel = _filter($carsMake, 0, 2, GUICtrlRead($model)) $i = 0 $engine = GUICtrlRead($engine) If $engine <> "" Then While $i < StringLen($engine) $carsEngine = _filter($carsModel, 0, 6 + $i, StringLeft($engine, 1)) ;_ArrayDisplay($carsModel, "Cars Model Before Array Delete") $x = 1 While $x <= UBound($carsModel) _ArrayDelete($carsModel, $x) $x += 1 WEnd ;_ArrayDisplay($carsModel, "Cars Model After Array Delete") ;_ArrayConcatenate($carsModel, $carsEngine) ;_ArrayDisplay($carsModel, "Cars Model After Concatenate") $engine = StringTrimLeft($engine, 1) $i += 1 WEnd Else Dim $carsEngine[1][16] EndIf _ArrayConcatenate($carsEngine, $carsModel) _ArrayDisplay($carsEngine, "Cars Engine") Dim $carsDriveTrain[1][16] Dim $carsDriveTrain2[1][16] $driveTrainVal = GUICtrlRead($driveTrain) If $driveTrainVal = "4x4" Or $driveTrainVal = "awd" Then $carsDriveTrain = _filter($carsEngine, 0, 9, "4") $carsDriveTrain2 = _filter($carsEngine, 0, 9, "a") ;~ _ArrayDisplay($carsDriveTrain, "Drive Train Before") ;~ If @error Then ;~ MsgBox("", "", "Cars Drive Train Error: " & @error) ;~ EndIf ;~ _ArrayDisplay($carsDriveTrain2, "Drive Train2 Before") ;~ If @error Then ;~ MsgBox("", "", "Cars Drive Train 2 Error: " & @error) ;~ EndIf _ArrayConcatenate($carsDriveTrain, $carsDriveTrain2) _ArrayDisplay($carsDriveTrain, "Drive Train After Concat") ElseIf $driveTrainVal = "" Then _ArrayConcatenate($carsDriveTrain, $carsEngine) Else $carsDriveTrain = _filter($carsEngine, 0, 9, $driveTrain) EndIf Dim $carsOdom[1][16] $min = GUICtrlRead($odomMin) $max = GUICtrlRead($odomMax) For $i = 0 To UBound($carsDriveTrain) - 1 If $carsDriveTrain[$i][14] > $min And $carsDriveTrain[$i][14] < $max Then _ArrayAdd($carsOdom, $carsDriveTrain[$i]) MsgBox("", "", "ADDED!") EndIf Next _ArrayDisplay($carsOdom, "Cars Odom") $j += 1 WEnd _IEQuit($oIE) EndFunc ;==>_query Func _filter($tofilter, $xpos1, $ypos1, $str) ;~ If UBound($tofilter, 1) <= 1 Then ;~ $endx = 0 ;~ Else ;~ $endx = UBound($tofilter, 1) - 1 ;~ EndIf ;~ $cars = _ArrayFindAll($tofilter, $str, $tofilter[$xpos1][$ypos1], $tofilter[$endx][$ypos1], 0, 1, $ypos1, False) $cars = _ArrayFindAll($tofilter, $str, Default, Default, 0, 1, $ypos1) Dim $carsFiltered[1][16] = [["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p"]] ;_ArrayDisplay($carsFiltered) $i = 0 $uBound = UBound($cars) - 1 While $i < $uBound $filtered = _ArrayExtract($tofilter, $cars[$i], $cars[$i], 0, 15) ;_ArrayDisplay($filtered, "_filter Array of Filtered") _ArrayConcatenate($carsFiltered, $filtered) $i += 1 WEnd _ArrayDelete($carsFiltered, 0) Return $carsFiltered EndFunc ;==>_filter  
      If you know of a more efficient way of doing this please let me know would be more than happy to chew down my inefficiency while learning! (It's like my grandpa used to say, "The only criticism I can't use is that which is not given to me.")
       
      The Item an I am using to test the filter is:

       
    • rm4453
      By rm4453
      Hello,
       
      I am currently writing a program that parses a massive table from a website, and need a way to add a progress bar while parsing.
      I am currently using the function _IETableWriteToArray($oObj, True) to parse the array. I need the progress bar to update as the table is parsed, not just at the end of the parsing.
      Any help at all would be very much appreciated!
       
      *EDIT --> The array I am left with after parsing is $array[0-50000][16]
    • SkysLastChance
      By SkysLastChance
      I have a goofy problem. I am hoping someone could shed some light. The example is not going around the text box. It is way off. 
      I have seen some post blaming IE 11, however I have IE11 on my desktop and it works fine.
      Is there anything I can do that might fix this? 
       
      ; Open a browser with the form example and get a reference to the form ; textarea element. Get the coordinates and dimensions of the text area, ; outline its shape with the mouse and come to rest in the center #include <IE.au3> Local $oIE = _IE_Example("form") Local $oForm = _IEFormGetObjByName($oIE, "ExampleForm") Local $oTextArea = _IEFormElementGetObjByName($oForm, "textareaExample") ; Get coordinates and dimensions of the textarea Local $iScreenX = _IEPropertyGet($oTextArea, "screenx") Local $iScreenY = _IEPropertyGet($oTextArea, "screeny") Local $iWidth = _IEPropertyGet($oTextArea, "width") Local $iHeight = _IEPropertyGet($oTextArea, "height") ; Outline the textarea with the mouse, come to rest in the center Local $iMousespeed = 50 MouseMove($iScreenX, $iScreenY, $iMousespeed) MouseMove($iScreenX + $iWidth, $iScreenY, $iMousespeed) MouseMove($iScreenX + $iWidth, $iScreenY + $iHeight, $iMousespeed) MouseMove($iScreenX, $iScreenY + $iHeight, $iMousespeed) MouseMove($iScreenX, $iScreenY, $iMousespeed) MouseMove($iScreenX + $iWidth / 2, $iScreenY + $iHeight / 2, $iMousespeed)  
       
    • ur
      By ur
      Is there any UDF to remove all anchor tags <a> with a particular class (and also its sub elements completely) in a html document.
      Here the classes are browse and breadcrumbs
      Like in the below image.


       
      I am not able to find that option in IE.au3
       
      Please suggest.
    • milkmoron
      By milkmoron
      I am trying to automate something in a web browser but i need some help with finding the html code to a web applet. How do I access the code.
×