stembe
October 17th, 2003, 03:42 PM
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%2AW934 65&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289*223010BBL*31012*W93465"></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&RECDAY S=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%2AW93 465&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289*223010BEBY*31012*W93465"></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&RECDA YS=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
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%2AW934 65&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289*223010BBL*31012*W93465"></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&RECDAY S=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%2AW93 465&action=continue"><img border="0" src="../images/rel.gif" alt="Release - 134289*223010BEBY*31012*W93465"></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&RECDA YS=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