5 Replies Latest reply: May 15, 2014 10:03 AM by Grant Perkins RSS

    .RPT files

    Lesa T

      I am new to both Monarch and the Monarch forum.

      I am currently trying to extract a report from our operating system.

      It sames the files in a print only format with the extention of .rpt.

      I was told I could use Monarch to pull this into a excel spreadsheet.

      However, when I try to open the report in Monarch I am gettting a lot of symbols.

      I am very confused and not certain how to even view my report in Monarch.

      Please help.

      Lesa

        • .RPT files
          Olly Bond

          Hello Lesa,

           

          Monarch will let you do exactly that - convert a text report file into a spreadsheet - but it sounds like the format you're saving isn't ASCII or ANSI text. What operating system are you using? Is it possibly producing a file in EBCIDIC? Could you perhaps email a fragment of it to me at olly@greenbar.info[/email] and I'll try to spot what's going on?

           

          Best wishes,

           

          Olly

          • .RPT files
            Data Kruncher

            Hi Lesa and welcome to the forum.

             

            Are you by chance opening .RPT files that were created with Crystal Reports?

             

            Monarch expects to handle plain text files, like something that you'd create with the Windows Notepad, and it sounds like your RPT file is a binary file that is meant to be a definition of a report and not an individual report that was exported.

             

            Can you see if you can create .txt or .prn files that you can open with Monarch with your system?

              • .RPT files
                Lesa T

                Thanks guys.

                I am using a window based operating system for our pharmacy called "Framework" it was written by Softwriters.

                I do not have a choice when I save the report.

                When I try to open it, it looks like this:

                 

                  €}  ̧K      Pg.emfz       

                4¶´¥»i                           

                åáfáÒn                           

                kel|ld¼‰z}yÉwˆã                  

                ¿a¢¤–                            

                ¡òc†*RCT7�g4¥—                   

                cÛöŒ}Ý1çá×’                      

                cÛŠc™«¶2x´ÇÂܘ                

                øJ¶²°                           

                0J÷Æ                             

                »¼üã                             

                v$_¯                             

                çíÞ'ž4~®nò<ùâx¹2-'T®7Q}          

                  €}  ̧K      Pg.emf¹”

                  • .RPT files
                    Olly Bond

                    Hello Lesa,

                     

                    Just had a look at:

                     

                    http://www.softwriters.com/FormsDivision/PDFs/TAR003%20Samples.pdf[/url]

                     

                    Unfortunately, I can't even browse the support forums at softwriters without registering...

                     

                    Can you print from the Framework application to either a TXT file, a PDF file or an XPS file? If you have Monarch Pro, either of the latter will be (fairly) easy to handle.

                     

                    Best wishes,

                     

                    Olly

                    • .RPT files
                      Grant Perkins

                      Thanks guys.

                      I am using a window based operating system for our pharmacy called "Framework" it was written by Softwriters.

                      I do not have a choice when I save the report.

                      When I try to open it, it looks like this:

                       

                      €} ̧K Pg.emfz

                      4¶´¥»i

                      åáfáÒn

                      kel|ld¼‰z}yÉwˆã

                      ¿a¢¤–

                      ¡òc†*RCT7�g4¥—

                      cÛöŒ}Ý1çá×’

                      cÛŠc™«¶2x´ÇÂܘ

                      øJ¶²°

                      0J֮

                      »¼üã

                      v$_¯

                      çíÞ'ž4~®nò<ùâx¹2-'T®7Q}

                      €} ̧K Pg.emf¹”[/quote]

                       

                      Lesa,

                       

                      After you have saved the report from Framework what would you have to do to see the results? Would you need to print it out?

                       

                      I suspect that Kruncher has provided a good clue here. Whilst files with name extension .rpt were traditionally plain text based report files the name extension (.RPT) has been used by some for slightly different purposes.

                       

                      If you would normally print the report to be able to see it then you may need to do the same 'printing' action before Monarch can read it. However in the Monarch's case an electronic file will be required, not printed paper. If you set up a Print to File (Generic/Text only) type printer in Windows and print to that you should get an electronic file that Monarch can use. This would be my preferred route in the situation I have described.

                       

                      The alternative, as Olly has also mentioned, is to print the RPT definition to PDF or XMS but at this time my personal preference for keeping things as simple as possible would be to go with the Text output using the Generic/Text printer facility available in Windows.

                       

                      HTH.

                       

                       

                      Grant