5 Replies Latest reply: May 15, 2014 9:52 AM by lklinstra _ RSS

    Missing data when opening report

    lklinstra _

      When we open this flat text file with 5 records in Monarch 8, we do not get all of the fifth record to display.  All we get is the REPORT NUMBER heading and the report number with the rest of the line blank.  Any ideas why and what we need to change to get it all?  I have tried using the input options to ignore form feed and print control characters, but that did not help.  We tried adding the character   and it fixed the problem, but when we removed it again, it stayed fixed and we did not understand why it didn't go back to broken.  We need to know how to process without manually adding this character.  Please help.  Thanks.

       

       

      REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


          -


          -


          -


          -


          -


          -


          -


          -


          -


        00000990900009909903/23/2005$              472.640000001000      DJCA    567650300000090900009909900099                                                                               

      REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


          -


          -


          -


          -


          -


          -


          -


          -


          -


        00000990900009909903/23/2005$            1,890.450000001000      DJCA    567650300000090900009909900099                                                                               

      REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


          -


          -


          -


          -


          -


          -


          -


          -


          -


        00000990900009909903/23/2005$               31.150000001000      DJCA    567650300000090900009909900099                                                                               

      REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


          -


          -


          -


          -


          -


          -


          -


          -


          -


        00000990800009909903/23/2005$              647.870000001000      DJCA    567650300000090900009909900099                                                                               

      REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


          -


          -


          -


          -


          -


          -


          -


          -


          -


        00000990900009909903/23/2005$            2,396.140000001000      DJCA    567650300000090900009909900099

        • Missing data when opening report
          lklinstra _

          When we open this flat text file with 5 records in Monarch 8, we do not get all of the fifth record to display.  All we get is the REPORT NUMBER heading and the report number with the rest of the line blank.  Any ideas why and what we need to change to get it all?  I have tried using the input options to ignore form feed and print control characters, but that did not help.  We tried adding the character   and it fixed the problem, but when we removed it again, it stayed fixed and we did not understand why it didn't go back to broken.  We need to know how to process without manually adding this character.  Please help.  Thanks.

           

           

          REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


              -


              -


              -


              -


              -


              -


              -


              -


              -


            00000990900009909903/23/2005$              472.640000001000      DJCA    567650300000090900009909900099                                                                               

          REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


              -


              -


              -


              -


              -


              -


              -


              -


              -


            00000990900009909903/23/2005$            1,890.450000001000      DJCA    567650300000090900009909900099                                                                               

          REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


              -


              -


              -


              -


              -


              -


              -


              -


              -


            00000990900009909903/23/2005$               31.150000001000      DJCA    567650300000090900009909900099                                                                               

          REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


              -


              -


              -


              -


              -


              -


              -


              -


              -


            00000990800009909903/23/2005$              647.870000001000      DJCA    567650300000090900009909900099                                                                               

          REPORT NUMBER:  R09774          SHORT TERM TRADER AS-OF TRANSACTIONS FOR MANUAL ADJUSTMENT                         PAGE:           1SOURCE PROGRAM: B18563                                                                                SUPER SHEET DATE:  06/21/2006JOB:            MBDMF043                                                                                CURRENT DATE:  06/22/2006                                                                                TIME:    00:12:44  TRANSACTION TYPE:  CANCEL                                                                                FUND       ACCOUNT     TRADE DATE          AMOUNT            DEALER     BRANCH    OPERATOR    BATCH    FROM FUND   FROM ACCOUNT     -


              -


              -


              -


              -


              -


              -


              -


              -


              -


            00000990900009909903/23/2005$            2,396.140000001000      DJCA    567650300000090900009909900099

          • Missing data when opening report
            debijo _

            Have you tried using Monarch's msrp utility to strip out the boxy little characters?

             

            start /wait msrp " " "" c:     empezall2.csv c:     empezall1.csv

             

            Thanks,

            Debi

            V8.01 Pro

            • Missing data when opening report
              debijo _

              Have you tried using Monarch's msrp utility to strip out the boxy little characters?

               

              start /wait msrp " " "" c:     empezall2.csv c:     empezall1.csv

               

              Thanks,

              Debi

              V8.01 Pro

              • Missing data when opening report
                lklinstra _

                I am not familiar with the msrp utility.  I looked in my learning guide and some of the HELP topics and I cannot find where it is referenced.  Is it in Monarch Pro Prep?  I opened that and could not figure out what to do once I was there.  Do we put the text file through the facility first then through the model? I appreciate any guidance you can give.  Thanks, Laura

                • Missing data when opening report
                  lklinstra _

                  I am not familiar with the msrp utility.  I looked in my learning guide and some of the HELP topics and I cannot find where it is referenced.  Is it in Monarch Pro Prep?  I opened that and could not figure out what to do once I was there.  Do we put the text file through the facility first then through the model? I appreciate any guidance you can give.  Thanks, Laura