0 Replies Latest reply: May 15, 2014 9:54 AM by stembe _ RSS

    HTML files - Monarch Pro 7.0

    stembe _

      Hello Everyone,

       

      I have just started using Monarch & have a question regarding HTML files. Basically, I am saving the "source" of a web page as a text file. The reason I am saving the file as a .txt and not as a .htm or .html is because Monarch strips out certain data from the .htm/.html file after I open it & I really need that data.

       

      Anyway, here is a sample of how it looks. It's ugly:

       

          • BEGIN SAMPLE ***

       

      <td style="color:black;background-color:#FFFFF0;text-align:left" rowspan="2" width="1"><nobr><a href="mailto:?subject=SupplyWeb Report&body=Part Number: 223010BBL Description: COVER  "REY"USAGE ENDS 2000M%0D%0A Part Status is: Within normal limits."><img border="0" src="../images/mail-smi.gif" alt="Send Email Message"></a><a href="../Purchasing/MPOHeader.asp?Key=W93465"><img border="0" src="../images/po.gif" alt="Purchase Order - W93465"></a><a href="../Purchasing/Rel.asp?FileName=134289%2A223010BBL%2A31012%2AW93465&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289223010BBL31012W93465"></a><a href="Calculation.asp?ADU=376&QTYOH=568&INTRANSIT=0&MIN=450&MAX=600&STANDARDPACK=450&DAY1=0&DAY2=0&QTY1=0&QTY2=0&INTRANSITDAYS=1&PartNumber=223010BBL&RECDAYS=0&ADRCALCDATE=2003%2D10%2D12T00%3A00%3A0 0%2E000Z&CUMCALCDATE=&** =0&SMICALCMETH=1&REQUIREDSHIPDAY=&REQUIREDSHIPQTY=0"><img border="0" src="../images/calculation.gif" alt="Calculation"></a></nobr></td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Part Number">223010BBL</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" colspan="5" title="Part Description">COVER  "REY"USAGE ENDS 2000M</td>

      </tr>

      <tr>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Engineering Change Level"> </td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Unit of Measure">EA</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Expected Receipt Quantity">0</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Expected Receipt Date"><nobr> </nobr><input name="" type="hidden" value=""><img alt="" id="_icon" name="_icon" src="../images/blank.gif" style="display : none"></td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="In-Transit Quantity">0</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Average Daily Release">376</td>

      </tr>

      <tr>

      <td style="background-color:Blue;color:White;">Production :

                  Normal</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" colspan="6">

      <table bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%">

      <tr>

      <td>

      <table border="1" bordercolor="black" cellpadding="0" cellspacing="0" frame="below" rules="cols" width="100%">

      <tr>

      <td align="right" width="75%" title="Minimum Inventory Level">450</td>

      <td align="right" width="25%" title="Maximum Inventory Level">600</td>

      <td></td>

      </tr>

      </table>

      </td>

      </tr>

      <tr>

      <td>

      <table border="0" bordercolor="black" cellpadding="0" cellspacing="0" frame="void" rules="cols" width="100%">

      <tr>

      <td align="right" style="background-color : Green; color : White" width="95%" title="Quantity on Hand

      Extract Date and Time  10/16/2003 8:05:15 AM EST"><nobr>568</nobr><input name="" type="hidden" value="568"><img alt="" id="_icon" name="_icon" src="../images/blank.gif" style="display : none"></td>

      <td></td>

      </tr>

      </table>

      </td>

      </tr>

      </table>

      </td>

      </tr>

      <tr>

      <td style="color:black;background-color:#FFFFF0;text-align:left" rowspan="2" width="1"><nobr><a href="mailto:?subject=SupplyWeb Report&body=Part Number: 223010BEBY Description: 0COVER               EBONY%0D%0A Part Status is: Over the maximum quantity %0D%0A Maximum Quantity: 450%0D%0A Quantity On Hand: 720"><img border="0" src="../images/mail-smi.gif" alt="Send Email Message"></a><a href="../Purchasing/MPOHeader.asp?Key=W93465"><img border="0" src="../images/po.gif" alt="Purchase Order - W93465"></a><a href="../Purchasing/Rel.asp?FileName=134289%2A223010BEBY%2A31012%2AW93465&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289223010BEBY31012W93465"></a><a href="StatusOver.asp?PassedPartNum=223010BEBY"><img border="0" src="../images/Arrow-U.gif" alt="Status - Over"></a><a href="Calculation.asp?ADU=432&QTYOH=720&INTRANSIT=0&MIN=400&MAX=450&STANDARDPACK=450&DAY1=0&DAY2=0&QTY1=0&QTY2=0&INTRANSITDAYS=1&PartNumber=223010BEBY&RECDAYS=0&ADRCALCDATE=2003%2D10%2D12T00%3A00%3A 00%2E000Z&CUMCALCDATE=&** =0&SMICALCMETH=1&REQUIREDSHIPDAY=&REQUIREDSHIPQTY=0"><img border="0" src="../images/calculation.gif" alt="Calculation"></a></nobr></td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Part Number">223010BEBY</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" colspan="5" title="Part Description">0COVER               EBONY</td>

      </tr>

      <tr>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Engineering Change Level"></td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Unit of Measure">EA</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Expected Receipt Quantity">0</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Expected Receipt Date"><nobr></nobr><input name="" type="hidden" value=""><img alt="" id="_icon" name="_icon" src="../images/blank.gif" style="display : none"></td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="In-Transit Quantity">0</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" title="Average Daily Release">432</td>

      </tr>

      <tr>

      <td style="background-color:Blue;color:White;">Production :

                  Over</td>

      <td style="color:black;background-color:#FFFFF0;text-align:left" colspan="6">

      <table bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%">

      <tr>

      <td>

      <table border="1" bordercolor="black" cellpadding="0" cellspacing="0" frame="below" rules="cols" width="100%">

      <tr>

      <td align="right" width="56%" title="Minimum Inventory Level">400</td>

      <td align="right" width="7%" title="Maximum Inventory Level">450</td>

      <td></td>

      </tr>

      </table>

      </td>

      </tr>

      <tr>

      <td>

      <table border="0" bordercolor="black" cellpadding="0" cellspacing="0" frame="void" rules="cols" width="100%">

      <tr>

      <td align="right" style="background-color : #FFFF00; color : Black" width="100%" title="Quantity on Hand

      Extract Date and Time  10/16/2003 8:05:15 AM EST"><nobr>720</nobr><input name="" type="hidden" value="720"><img alt="" id="_icon" name="_icon" src="../images/blank.gif" style="display : none"></td>

      </tr>

      </table>

      </td>

      </tr>

      </table>

      </td>

      </tr>

      <tr>

       

          • END SAMPLE ***

       

      I am trying to capture the value(s) that occur right after the following "traps" & I am using the "Floating Trap" feature.

       

      alt="Purchase Order -

      title="Part Number">

      title="Part Description">

      title="Engineering Change Level">

      title="Unit of Measure">

      title="Expected Receipt Quantity">

      title="Expected Receipt Date">

      title="In-Transit Quantity">

      title="Average Daily Release">

      title="Minimum Inventory Level">

      title="Maximum Inventory Level">

      Extract Date and Time  10/16/2003 8:05:15 AM EST"><nobr>

       

      I start off with the "Part Number" trap as the "Detail" & then work my way by "Appending" until I get to the "Extract" trap & define it as "Footer". Later, I define the "Purchase Order" trap as the "Page Header". Everything shows up correctly in Table view, except the Purchase Order, which is blank. I have tried every possible combination to get this working, but so far have been unsuccessful.   :confused: 

       

      Can anyone point me in the right direction?

       

      Thanks,

      Suhas