6 Replies Latest reply: May 15, 2014 9:56 AM by sreedhar _ RSS

    Trapping & Table Window

    sreedhar _

      Hi Experts,

      I'm new to this monarch software...after giving a quick read through manual and online help, i managed to trap required fields in SAP Software spool file which gives details of uploaded records and its corresponding error details, if any.

      Currently i'm having problem in trapping all error fields...though i'm able to trap them all, when i view them in 'Table' window, i'm not able to see all trapped errrors....

       

      format of the error is :

      XOO  X   44071404 30.06.2006 26213964

      W BK             113 Posting date is not within fiscal year 2006

      E BS              14 User status TEBL is active (WBS 0.0113920.001)

       

       

      character '|' denotes start and end of a single line in the file....

       

      WHAT I DID SO FAR:

      I created the field with 'Memo' Type and Start Field on 'Line number 1' and End Field On 'Non blank preceding string of 1 characters' which traps all required lines in the report window. but when i view the table window , i'm getting only one error....

       

      Kindly adivse....

       

      Thanks

        • Trapping & Table Window
          Grant Perkins

          Hi and welcome.

           

          Some thoughts and questions.

           

          How are you trapping the lines you want to start with for the error codes?

           

          Is it fair to assume that your field definition skips the first | and space and starter at the third character? If so I wonder if the End On is actually enforcing a one line field.

           

          The final thought that occurred to me is that the lines may be there but you can't see them on the standard display of a single line for the field contents. The WINDOWS menu has a "Show Field Contents" option which is especially useful for memo fields. However I suspect your problem relates to anomaly concerning either the line trap or the End field definition.

           

          I'll check back for your input later and suggest more based on that if I can.

           

           

          HTH

           

           

          Grant

          • Trapping & Table Window
            sreedhar _

            Originally posted by Grant Perkins:

            Hi and welcome.

             

            Grant /b[/quote]Hi Grant, Thanks for ur reply.. I actually managed to create one 'Detail' & 3 'Append' templates which are as follows:

             

            Detail  -> Traps Error details

            Append1 -> Uploaded Records Count

            Append2 -> Success records count

            Append3 -> Error Records count

             

            As you can expect when the file has errors then only 'detail' template will find some data in the spool report. I tested with a report having errors which is working fine in 'Table' but when i did with without errors, i 'm not getting any 'table' output at all .... is detail mandatory to show the table output ? If so could you suggest me how to overcome this please as i wud like to see append 1-3 information irrespective of 'Erorr Details' ....

             

            'Detail' template is defined as below:

            Type: Memo

            Start Field On - Line number 1

            End Field On - Nonblank preceding of 2 characters as i started trapping from character 'X00' instead of '|'.

             

             

            Thanks in advance

            • Trapping & Table Window
              Grant Perkins

              A detail record is always required, appends are optional. So if you always want to the see the count records and errors do not always exist then the count records need to be in the detail.

               

              Where are they in the report? Above or below the error lines? I assume above if you are using appends which are not footers.

               

              Are these three counts in a block of data? If so treat the block as your detail record and if the error lines are close to it add the error line memo field as well.

               

              If the count lines are separated but ABOVE the error lines, the count line should be fields in a detail template and the error lines probably a footer append for that record. HOWEVER if not all counts have errors you would need to ensure that the the footer trap works even if there are no error lines. Hance it sound like it would be much better and simpler if the counts and the errors can all be captured in a single detail template.

               

              If you can post a couple of pages of a report sample of the sections you need it should be possible to come up with something a little more definitive for you.

               

              HTH.

               

               

              Grant

              • Trapping & Table Window
                sreedhar _

                If you can post a couple of pages of a report sample of the sections you need it should be possible to come up with something a little more definitive for you. /b[/quote]Thanks a ton for ur suggestions ...

                 

                Here is a sample report

                -


                No. of records containing errors:          8

                No. of records read:      1,035

                No. of records saved successfully:      1,027

                -


                -


                Exc. Rev Pers.no. Date       Doc. no.

                Message ID Msg.No. Message text


                XOO  X   44071404 16.06.2006 26213944

                W BK             113 Posting date is not within fiscal year 2006

                I BK              98 Th document date and posting date are in different fiscal years

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                XOO  X   44071404 22.06.2006 26213951

                W BK             113 Posting date is not within fiscal year 2006

                I BK              98 Th document date and posting date are in different fiscal years

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                XOO  X   44071404 26.06.2006 26213955

                W BK             113 Posting date is not within fiscal year 2006

                I BK              98 Th document date and posting date are in different fiscal years

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                XOO  X   44071404 30.06.2006 26213964

                W BK             113 Posting date is not within fiscal year 2006

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                XOO  X   44071404 18.07.2006 26988636

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                XOO  X   44071404 19.07.2006 26988640

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                OOX      44036579 17.10.2006 27623229

                S BK               3 Document is posted under number 0331824422


                OOX      44048996 05.09.2006 29275352

                S BK               3 Document is posted under number 0331824425


                 

                 

                in above, following snippet is counts' header

                -


                No. of records containing errors:          8

                No. of records read:      1,035

                No. of records saved successfully:      1,027

                -


                 

                and following are the error chunks


                XOO  X   44071404 16.06.2006 26213944

                W BK             113 Posting date is not within fiscal year 2006

                I BK              98 Th document date and posting date are in different fiscal years

                E BS              14 User status TEBL is active (WBS 0.0113920.001)


                 

                error chunks can be identified with "XOO" and thats how i created detail template aswell ...

                 

                pls suggest .

                Thanks

                • Trapping & Table Window
                  Grant Perkins

                  Originally posted by sreedhar:

                    /size[quote]quote:[/size]

                  If you can post a couple of pages of a report sample of the sections you need it should be possible to come up with something a little more definitive for you. /b[/quote]Thanks a ton for ur suggestions ...

                   

                  Here is a sample report

                  [font="courier"]----


                  No. of records containing errors:          8

                  No. of records read:      1,035

                  No. of records saved successfully:      1,027

                  -


                  -


                  Exc. Rev Pers.no. Date       Doc. no.

                  Message ID Msg.No. Message text


                  XOO  X   44071404 16.06.2006 26213944

                  W BK             113 Posting date is not within fiscal year 2006

                  I BK              98 Th document date and posting date are in different fiscal years

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  XOO  X   44071404 22.06.2006 26213951

                  W BK             113 Posting date is not within fiscal year 2006

                  I BK              98 Th document date and posting date are in different fiscal years

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  XOO  X   44071404 26.06.2006 26213955

                  W BK             113 Posting date is not within fiscal year 2006

                  I BK              98 Th document date and posting date are in different fiscal years

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  XOO  X   44071404 30.06.2006 26213964

                  W BK             113 Posting date is not within fiscal year 2006

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  XOO  X   44071404 18.07.2006 26988636

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  XOO  X   44071404 19.07.2006 26988640

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)


                  OOX      44036579 17.10.2006 27623229

                  S BK               3 Document is posted under number 0331824422


                  OOX      44048996 05.09.2006 29275352

                  S BK               3 Document is posted under number 0331824425

                  |----


                  |/font[/quote]in above, following snippet is counts' header

                   

                  [font="courier"]----


                  No. of records containing errors:          8

                  No. of records read:      1,035

                  No. of records saved successfully:      1,027

                  -


                  [/font][/quote]and following are the error chunks

                  [font="courier"]|----


                  |

                  XOO  X   44071404 16.06.2006 26213944

                  W BK             113 Posting date is not within fiscal year 2006

                  I BK              98 Th document date and posting date are in different fiscal years

                  E BS              14 User status TEBL is active (WBS 0.0113920.001)

                  |----


                  |/font[/quote]error chunks can be identified with "XOO" and thats how i created detail template as well ...

                  /b[/size][/QUOTE]Is there anything else in the summary count section which can be used to identify one section from another? As it stands from the sample there is no way identify a unique detail record to attache any error records to using a lookup facility (for example).

                   

                  The potential for many error records per summary count section probably mean that it would be unsafe consider capturing the error lines in a footer template - there may be more lines to capture than a footer allows.

                   

                  But equally the lookup could be difficult without some way to connect the sections.

                   

                   

                  Grant

                  • Trapping & Table Window
                    sreedhar _

                    Originally posted by Grant Perkins:

                                                                

                    Grant /b[/quote]Hi Grant,

                     

                    Thanks for your continuous support. Actually there is n't any demarcation  between summary counts and details section. Details section is a combination of success and error details. Error chunks can be identified by XOO. Is there any way that I can send my complete report as an attachment to you pls ?

                     

                    First page of whole report is as follows:

                    -


                    Sort criteria

                    Ascdg

                    Descnd

                    Subtotal


                    X

                    X

                    X

                    -


                    -


                    Data statistics

                    Number of


                    Records passed Header

                    1,035

                    Records passed Item

                    1,056

                    -


                    -


                    No. of records containing errors:          8

                    No. of records read:      1,035

                    No. of records saved successfully:      1,027

                    -


                    -


                    Exc. Rev Pers.no. Date       Doc. no.

                    Message ID Msg.No. Message text


                    XOO  X   44071404 16.06.2006 26213944

                    W BK             113 Posting date is not within fiscal year 2006

                    I BK              98 Th document date and posting date are in different fiscal years

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    XOO  X   44071404 22.06.2006 26213951

                    W BK             113 Posting date is not within fiscal year 2006

                    I BK              98 Th document date and posting date are in different fiscal years

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    XOO  X   44071404 26.06.2006 26213955

                    W BK             113 Posting date is not within fiscal year 2006

                    I BK              98 Th document date and posting date are in different fiscal years

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    XOO  X   44071404 30.06.2006 26213964

                    W BK             113 Posting date is not within fiscal year 2006

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    XOO  X   44071404 18.07.2006 26988636

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    XOO  X   44071404 19.07.2006 26988640

                    E BS              14 User status TEBL is active (WBS 0.0113920.001)


                    OOX      44036579 17.10.2006 27623229

                    S BK               3 Document is posted under number 0331824422


                     

                    Another question - I just added summary count section into a Page Header template type and surprisingly it's coming as a column in row in 'Table' display. Is there anyway that I can get summary count section as a header of the whole report and details (i.e., error details) as a row-wise report ?

                    Thanks

                    Thanks

                     

                    [size="1"][ October 24, 2006, 06:13 AM: Message edited by: sreedhar ][/size]