14 Replies Latest reply: May 15, 2014 10:01 AM by Grant Perkins RSS

    Skipping footers

    nelson _

      I'm using V8.02 and I have data that is not being captured correctly when the data "crosses over" footer.

       

      The footer basically consists of about 4 blank lines.  How can I set my trap to ignore these 4 blank lines and continue the trap?

       

      I can do it with the page header by identifying it but not the footer.

       

      Thanks

        • Skipping footers
          Data Kruncher

          Hi Nelson, and welcome to the Monarch forum.

           

          It would help a lot if you could post a [URL="http://www.monarchforums.com/showthread.php?t=2290"]sample of your report[/URL]; changing any confidential information, of course.

           

          Kruncher

            • Skipping footers
              nelson _

              01234     ABC Company

              OPN-ITEM

              Totals:      $1,000,000.00        $800,000.00     $200,000.00                 0.00

                                                                                 

               

              01458     XYZ Company

               

               

               

              Page 2

              Aging Report                     Name of Company    3/31/08

               

              OPN-ITEM

              Totals:       $500,000.00          $250,000.00                       50,000.00

               

               

               

               

              So in the sample above my append trap for the customer name I had to trap "OPN-ITEM".  Let's just assume that's the only way to get the trap to work, I don't have the actual file available from home.  Basically when the footer splits the name, it no longer traps the name because now there's nothing above "OPN-ITEM"

                • Skipping footers
                  Grant Perkins

                  A Page Header append allows Monarch to skip over the lines it contains. If you include the blanks lines at the bottom of a page in the header the first page may be an issue (or maybe not) but the rest shoudl work.

                   

                  An alternative would be to set the Page Header as a page header withouth the 'footer' lines and for the fields below the  OPN-ITEM trap line set up the advanced properties to use a Preceding String  -  Totals:   .

                   

                  Assuming that Totals: would be unique enough to work (based on your sample) Monarch will simply continue reading lines, with the page header 'invisible' to the Detail or Append processing, until it finds Totals on the line before the field(s) you want.

                   

                  Unless there is something else in the full report that compromises these ideas, either should work.

                   

                  HTH.

                   

                   

                  Grant

                    • Skipping footers
                      nelson _

                      A Page Header append allows Monarch to skip over the lines it contains. If you include the blanks lines at the bottom of a page in the header the first page may be an issue (or maybe not) but the rest shoudl work.

                       

                       

                      Grant[/QUOTE]

                       

                      i actually tried doing this and for some reason it didn't let me "identify" the blank lines i was trying to trap.

                       

                      so for example i highlighted the following 6 lines and then New Template, clicked Page Header then OK.  All it did was identify the last 2 lines as a header. so when i look on the left of the report only the last 2 lines had ">>" next to them.

                       

                       

                      Page 2

                      Aging Report Name of Company 3/31/08

                       

                      I tried attaching the actual report but i'm not too sure how to make it fit because it's pretty wide.  Is there a special way to do it?

                        • Skipping footers
                          Grant Perkins

                          Nelson,

                           

                          That sounds strange. I wonder if there is something in the report (hidden page formatting or the like) that is making things difficult. If so posting it may not work very well but ... use the CODE tags. There is a sticky post at the top of the forums describing what to do.

                           

                           

                          HTH.

                           

                           

                           

                          Grant

                            • Skipping footers
                              nelson _

                              here's an excerpt:

                               

                               

                              XYZ        XYZ TECHNOLOGY                                                                               

                              Opn-Itm      GREG DOYLE                                                                               

                              NET 45           MA      A     A   FG         200,000                                                                               

                              Doc-No Doc-Date   Tp Aply-To Due-Date      Amount-1       Amount-2      Doc Total  Apply-To Balance       Reference                  

                                 92547 11/05/2007 I    92547 12/20/07     12,791.25            .00      12,791.25       12,791.25  Po: PO0578    Our Ord:   82519    

                                 92550 11/05/2007 I    92550 12/20/07      4,991.25            .00       4,991.25        4,991.25  Po: PO0590    Our Ord:   82573    

                                 92586 11/05/2007 I    92586 12/20/07      2,160.00            .00       2,160.00        2,160.00  Po: PO0591    Our Ord:   82603    

                                 92615 11/08/2007 I    92615 12/23/07     17,586.00            .00      17,586.00       17,586.00  Po: PO0575    Our Ord:   82322    

                                 92621 11/01/2007 I    92621 12/16/07        255.00            .00         255.00          255.00  Po: PO0565    Our Ord:   82896    

                                 92628 11/05/2007 I    92628 12/20/07        323.00            .00         323.00          323.00  Po: PO0626    Our Ord:   83193    

                                 92946 11/20/2007 I    92946 01/04/08     17,542.80            .00      17,542.80       17,542.80  Po: PO0582    Our Ord:   82569    

                                 93230 11/26/2007 I    93230 01/10/08        323.00            .00         323.00          323.00  Po: PO0634    Our Ord:   83676                                                                               

                              Customer Total:                55,972.30           55,972.30                           .00                                                                               

                              .00                           .00                                                                               

                              SKIPPED      SKIPPED NAME ENGINEERS                                                                               

                              Jan 22, 2008 - 12:47pm                   ABC TELECOM, INC.                                                             Page   4                                                                               

                              A C C O U N T S   R E C E I V A B L E   A G I N G   R E P O R T                                                                               

                              Cust-No      Name                                                                               

                              Bal-Mthd     Contact                                                       ***************** Aged Customer Balance ****************    

                              Phone-No     Terms         Slsman  Cllectr Terr Loc       Crdt-Lmt        CURRENT        1 TO 30 DAY    31 TO 60 DAY   61 OR ABOVE     

                              ====================================================================================================================================   

                              Opn-Itm      PHONE 5555558118 JAHANGIR AHMAD                                                                               

                              TT BEFORE SHIP   NE      A     A   FG                                                                               

                              Doc-No Doc-Date   Tp Aply-To Due-Date      Amount-1       Amount-2      Doc Total  Apply-To Balance       Reference                  

                                118062 01/18/2006 P        0 01/18/06         52.83-           .00          52.83-          52.83- Open Credit On Account            

                                228063 03/01/2006 P        0 03/01/06        252.75-           .00         252.75-         305.58- OPEN RMA ORDER                    

                                 91206 09/12/2006 P        0 09/12/06         13.41-           .00          13.41-         318.99- Open Credit On Account            

                                 90668 08/30/2007 I    90668 09/04/07     55,516.50       4,154.17      59,670.67       59,670.67  Po: PO#42     Our Ord:   80794    

                                710043 10/04/2007 P    90668 10/04/07     56,716.50-        465.00-     57,181.50-       2,489.17  Cus:NA****L      Wire  710043    

                                 93270 11/30/2007 I    93270 12/05/07     12,960.00         850.00      13,810.00       13,810.00  Po: 1937      Our Ord:   83416    

                              1128071 11/28/2007 P    93270 11/28/07      6,885.00-           .00       6,885.00-       6,925.00  COP 83416                         

                              1128072 11/28/2007 P    93270 11/28/07      6,885.00-           .00       6,885.00-          40.00  COP 83416                                                                               

                              Customer Total:                 2,210.18               40.00                           .00                                                                               

                              .00                      2,170.18

                               

                               

                               

                               

                              Basically the trap I set is not pulling "Skipped Name Engineers" because "Opn-Itm" was cut off by the header.

                                • Skipping footers
                                  Grant Perkins

                                  here's an excerpt:

                                   

                                  XYZ        XYZ TECHNOLOGY                                                                               

                                  Opn-Itm      GREG DOYLE                                                                               

                                  NET 45           MA      A     A   FG         200,000                                                                               

                                  Doc-No Doc-Date   Tp Aply-To Due-Date      Amount-1       Amount-2      Doc Total  Apply-To Balance       Reference                  

                                     92547 11/05/2007 I    92547 12/20/07     12,791.25            .00      12,791.25       12,791.25  Po: PO0578    Our Ord:   82519    

                                     92550 11/05/2007 I    92550 12/20/07      4,991.25            .00       4,991.25        4,991.25  Po: PO0590    Our Ord:   82573    

                                     92586 11/05/2007 I    92586 12/20/07      2,160.00            .00       2,160.00        2,160.00  Po: PO0591    Our Ord:   82603    

                                     92615 11/08/2007 I    92615 12/23/07     17,586.00            .00      17,586.00       17,586.00  Po: PO0575    Our Ord:   82322    

                                     92621 11/01/2007 I    92621 12/16/07        255.00            .00         255.00          255.00  Po: PO0565    Our Ord:   82896    

                                     92628 11/05/2007 I    92628 12/20/07        323.00            .00         323.00          323.00  Po: PO0626    Our Ord:   83193    

                                     92946 11/20/2007 I    92946 01/04/08     17,542.80            .00      17,542.80       17,542.80  Po: PO0582    Our Ord:   82569    

                                     93230 11/26/2007 I    93230 01/10/08        323.00            .00         323.00          323.00  Po: PO0634    Our Ord:   83676                                                                               

                                  Customer Total:                55,972.30           55,972.30                           .00                                                                               

                                  .00                           .00                                                                               

                                  SKIPPED      SKIPPED NAME ENGINEERS                                                                               

                                  Jan 22, 2008 - 12:47pm                   ABC TELECOM, INC.                                                             Page   4                                                                               

                                  A C C O U N T S   R E C E I V A B L E   A G I N G   R E P O R T                                                                               

                                  Cust-No      Name                                                                               

                                  Bal-Mthd     Contact                                                       ***************** Aged Customer Balance ****************    

                                  Phone-No     Terms         Slsman  Cllectr Terr Loc       Crdt-Lmt        CURRENT        1 TO 30 DAY    31 TO 60 DAY   61 OR ABOVE     

                                  ====================================================================================================================================   

                                  Opn-Itm      PHONE 5555558118 JAHANGIR AHMAD                                                                               

                                  TT BEFORE SHIP   NE      A     A   FG                                                                               

                                  Doc-No Doc-Date   Tp Aply-To Due-Date      Amount-1       Amount-2      Doc Total  Apply-To Balance       Reference                  

                                    118062 01/18/2006 P        0 01/18/06         52.83-           .00          52.83-          52.83- Open Credit On Account            

                                    228063 03/01/2006 P        0 03/01/06        252.75-           .00         252.75-         305.58- OPEN RMA ORDER                    

                                     91206 09/12/2006 P        0 09/12/06         13.41-           .00          13.41-         318.99- Open Credit On Account            

                                     90668 08/30/2007 I    90668 09/04/07     55,516.50       4,154.17      59,670.67       59,670.67  Po: PO#42     Our Ord:   80794    

                                    710043 10/04/2007 P    90668 10/04/07     56,716.50-        465.00-     57,181.50-       2,489.17  Cus:NA****L      Wire  710043    

                                     93270 11/30/2007 I    93270 12/05/07     12,960.00         850.00      13,810.00       13,810.00  Po: 1937      Our Ord:   83416    

                                  1128071 11/28/2007 P    93270 11/28/07      6,885.00-           .00       6,885.00-       6,925.00  COP 83416                         

                                  1128072 11/28/2007 P    93270 11/28/07      6,885.00-           .00       6,885.00-          40.00  COP 83416                                                                               

                                  Customer Total:                 2,210.18               40.00                           .00                                                                               

                                  .00                      2,170.18

                                   

                                  /code

                                  Basically the trap I set is not pulling "Skipped Name Engineers" because "Opn-Itm" was cut off by the header.[/quote]

                                   

                                  Using the CODE tag combination it looks like this. Is that about right?

                                   

                                   

                                  Grant

                                    • Skipping footers
                                      nelson _

                                      Using the CODE tag combination it looks like this. Is that about right?

                                       

                                       

                                      Grant[/QUOTE]

                                       

                                       

                                      Yes exactly!  What is the "Code tag combination"? and how do I use that?

                                       

                                      Any ideas as to why my trap is not picking up the name when it's split but a header?

                                        • Skipping footers
                                          Grant Perkins

                                          Yes exactly!  What is the "Code tag combination"? and how do I use that?

                                           

                                          /quote

                                           

                                          Right down at the bottom of your Forum Window you should find a little box called "Posting Rules"

                                           

                                          Click on the "vb code" link in that and see the list of display enhancement options. Click on any of those links to see how to use them.For this specific question you need the link.

                                           

                                          HTH.

                                           

                                           

                                          Grant

                                            • Skipping footers
                                              Grant Perkins

                                              Nelson,

                                               

                                              Based on the brief sample data you need 9 lines for the Page Header template with the first line being blank. HOWEVER  to get that blank line you may need to start your sample above the page break line by a line or two as they appear on screen.

                                               

                                              For the 3 line append it would be best if you could trap on line one since "Opn-Itm" is really data. However it you only want Opn-Itm  method then trap on Opn-Itm on line 2 of your 3 line sample for the template.

                                               

                                              You could also consider a 2 line append template starting with Opn-Itm and a separate append for the Cust-No and name.

                                               

                                              The best opiton is rather dependent on what will fit the entire report and whether there are clear ways of trapping the Cust-No line and lines for other Balance Methods if required.

                                               

                                              HTH.

                                               

                                               

                                              Grant

                                                • Skipping footers
                                                  nelson _

                                                  When I identify the page header, Monarch adds a page break with several blank lines.  How can I get it not to add these lines?  If I can make it not add the lines, my trap should work.

                                                   

                                                  All I'm trying to do now is to trap the customer number and name.  I have everything else I need.

                                                    • Skipping footers
                                                      Grant Perkins

                                                      Nelson,

                                                       

                                                      Based on a text file I created, using cut and paste from the sample data you posted on the forum, your page header template requires 9 lines starting with the blank line above the  Date/Title/Page  line and ending with the  ======== line. I trapped that using the word "Page" and told Monarch to look for that on (or rather understand that it is on) the second line of the 9 line sample.

                                                       

                                                      Your real and full report may not be quite the same. In that case you may need to adjust the number of lines. However I could guess that the programmer might not have built in any predefined rules about how to split the data so the 3 lines may, in other parts of the report, be split after 2 lines. In which case your template will need to deal with that possibility as well.

                                                       

                                                      The extra lines and the page break marker can be ignored as far as I am aware - they are on-screen presentation formating and do not get processed as data lines.

                                                       

                                                      If you can separate the Cust-No line into its own template that might be the easiest thing for you to do. However, based on the sample, I can imagine that obtaining a unique and reliable trap might not be easy through an entire report.

                                                       

                                                      If you are seeing different behaviour that does not fit my suggestions when using the full report then it might be best, if you can, to prepare a version of the real report that can be provided as a full sample for investigation. Real data content might be important in this situation so if you need to edit the data to make it anonymous the edit should be realistic rather than just strings of characters all the same record by record just to indicate data positions.

                                                       

                                                      HTH.

                                                       

                                                       

                                                      Grant

                                                        • Skipping footers
                                                          nelson _

                                                          Hi Grant,

                                                           

                                                          The sample I posted is actually identical to the original except I changed the names.  Everything else is the same.  I've tried building a model based on the sample text and I'm having the same problem.

                                                           

                                                          I don't know why Monarch is not ignoring the page header and footer.

                                                           

                                                          I tried the three line trap but that didn't work either.  If you can get a model to work with the sample text that would be great.  I ended up manually going back and filling in the names that didn't get trapped in my report.  There were only a handful.  It was more of a personal challenge that I wanted to figure it out.

                                                           

                                                          I appreciate all your efforts. 

                                                           

                                                          Thanks!

                                                           

                                                          Nelson

                                                            • Skipping footers
                                                              Grant Perkins

                                                              Nelson,

                                                               

                                                              Get rid of the footer template. Either delete it or change it to an append but I don't think you have any fields from it do you - so deletion might be the best option. You may need to adjust some of the other stuff once the footer no longer exists.

                                                               

                                                              If that does not work PM me with an email address that will accept attachments and I will send you the model I have.

                                                               

                                                               

                                                              Grant