5 Replies Latest reply: May 15, 2014 9:56 AM by Rhack _ RSS

    Can Monarch parse this?

    Rhack _

      Hi all, have not purchased Monarch yet, would like to get an idea if Monarch will meet my needs before purchasing.

       

      Baiscally, I've got two different "reports" that I would like to be able to turn into a delimited format.

       

      The examples show a couple of iterations of each type of data that may be seen in the report.  Each iteration has good seperators to indicate start and end of each "record".  Each record has alot of similar information, but some have more than others. I appreciate any feedback that can be provided.

       

      Report 1[/b]

      DIRECTORY NUMBER or ?........................ => 42115

      USER GROUP................................... => 1

       

        • VOICE LINE DEFINITION                12/16/04     11:42:07

      DRN...DIRECTORY NUMBER...................42115

      UGP...USER GROUP NUMBER..................1

      COS...CLASS OF SERVICE...................2

      CPG...CALL PICKUP GROUP NUMBER...........201

      TYP...CALL PICKUP TYPE...................B

      HNC...HOME NNP NUMBER....................(NONE)

      ACD...ACD PILOT NUMBER...................NONE

      HUN...HUNT PILOT NUMBER..................NONE

      APR...AUTOMATIC PRIVACY RELEASE..........NO

      CAD...100 NUM ABBREVIATED DIALING........NO

      DIA...STATION DIAGNOSTIC ALLOWED.........NO

      FIE...CALL FORWARD - INTERNAL/EXTERNAL...NO

      CFN...CALL FORWARD - NO ANSWER...........45400

      CFB...CALL FORWARD - BUSY................IMMEDIATE

      ......BUSY DIRECTORY NUMBER..............45400

      CFA...CALL FORWARD - ALL.................INACTIVE

      HOT...HOT LINE DIRECTORY NUMBER..........INACTIVE

      OHA...OFFHOOK ALERT DESTINATION NUMBER...INACTIVE

      TOD...TIME OF DAY RESTRICTIONS...........NO

      VID...InteMail ID FOR VOICE LINE.........NONE

      STATION     TYPE  BUTTON     RING OPTION

      RETURN CONTINUES DISPLAY..... =>

      01.3.09.04 ITES     2        RING

      END OF DISPLAY

       

       

      DIRECTORY NUMBER or ?........................ => 42119

      USER GROUP................................... => 1

       

        • VOICE LINE DEFINITION                12/16/04     11:42:12

      DRN...DIRECTORY NUMBER...................42119

      UGP...USER GROUP NUMBER..................1

      COS...CLASS OF SERVICE...................2

      CPG...CALL PICKUP GROUP NUMBER...........210

      TYP...CALL PICKUP TYPE...................B

      HNC...HOME NNP NUMBER....................(NONE)

      ACD...ACD PILOT NUMBER...................NONE

      HUN...HUNT PILOT NUMBER..................NONE

      APR...AUTOMATIC PRIVACY RELEASE..........NO

      CAD...100 NUM ABBREVIATED DIALING........NO

      DIA...STATION DIAGNOSTIC ALLOWED.........NO

      FIE...CALL FORWARD - INTERNAL/EXTERNAL...NO

      CFN...CALL FORWARD - NO ANSWER...........45400

      CFB...CALL FORWARD - BUSY................IMMEDIATE

      ......BUSY DIRECTORY NUMBER..............45400

      CFA...CALL FORWARD - ALL.................INACTIVE

      HOT...HOT LINE DIRECTORY NUMBER..........INACTIVE

      OHA...OFFHOOK ALERT DESTINATION NUMBER...INACTIVE

      TOD...TIME OF DAY RESTRICTIONS...........NO

      VID...InteMail ID FOR VOICE LINE.........46610

      STATION     TYPE  BUTTON     RING OPTION

      RETURN CONTINUES DISPLAY..... =>

      02.1.05.23 ITE      3        NO RING

      01.2.05.03 ITE      4        NO RING

      01.3.07.24 ITES     2        RING                 InteMail-MSG DISP

      02.1.09.11 ITES     2        NO RING

      END OF DISPLAY

       

      DIRECTORY NUMBER or ?........................ => 42122

      USER GROUP................................... => 1

       

       

      Report 2[/b]

       

        • STATION DEFINITION:         12/16/04  14:13:08

       

      ***...STATION.......................PORT 01.2.11.12

      RETURN CONTINUES DISPLAY..... =>

      ***...STATION EQUIPMENT TYPE.............ITE

      BTP...BUTTON TEMPLATE NUMBER.............2

      DND...DO NOT DISTURB ALLOWED.............NO

      VMC...InteMail MESSAGE DESK OPERATOR.....NO

      AND...ALPHANUMERIC DISPLAY...............NO

      AHL...AUTOMATIC HOLD.....................NO

      HRC...SWITCHHOOK RINGER CUTOFF...........NO

      DPT...DTMF PASSTHROUGH TIMING INDEX......NONE

      ADD...ADT ANALOG SIDE DTMF DIALING.......NO

      LPR...LINE PRESELECT TYPE................PRIME

      PLB...PRIME LINE PRESELECT BUTTON #......1

      RETURN CONTINUES DISPLAY..... =>

      BUTTON     TYPE              LINE/FEATURE ID

        1.PL.....VOICE LINE.....DRN:46476 - UGP:1...RING           Mail-MSG

        2........VOICE LINE.....DRN:63605 - UGP:1...RING

        3........LINE SELECT....UNASSIGNED

        4........LINE SELECT....UNASSIGNED

        5........LINE SELECT....UNASSIGNED

        6........LINE SELECT....UNASSIGNED

        7........FEATURE........InteMail - DIRECT ACCESS

        8........FEATURE........CALL FORWARD

        9........FEATURE........CALL PICKUP

      10........FEATURE........CALLBACK

      11........FEATURE........CALL TRANSFER

      12........FEATURE........HOLD

      END OF DISPLAY

       

        • STATION DEFINITION:         12/16/04  14:13:11

       

      ***...STATION.......................PORT 01.2.11.13

      ***...STATION EQUIPMENT TYPE.............ITES

      BTP...BUTTON TEMPLATE NUMBER.............81

      DND...DO NOT DISTURB ALLOWED.............NO

      VMC...InteMail MESSAGE DESK OPERATOR.....NO

      AND...ALPHANUMERIC DISPLAY...............YES

      RETURN CONTINUES DISPLAY..... =>

      AHL...AUTOMATIC HOLD.....................NO

      HRC...SWITCHHOOK RINGER CUTOFF...........NO

      DPT...DTMF PASSTHROUGH TIMING INDEX......NONE

      ADD...ADT ANALOG SIDE DTMF DIALING.......NO

      LPR...LINE PRESELECT TYPE................PRIME

      PLB...PRIME LINE PRESELECT BUTTON #......1

      BUTTON     TYPE              LINE/FEATURE ID

        1.PL.....VOICE LINE.....DRN:45953 - UGP:1...RING           Mail-MSG

                                HFA - INACTIVE

        2........LINE SELECT....UNASSIGNED

        3........LINE SELECT....UNASSIGNED

        4........LINE SELECT....UNASSIGNED

        5........LINE SELECT....UNASSIGNED

        6........LINE SELECT....UNASSIGNED

        7........LINE SELECT....UNASSIGNED

        8........LINE SELECT....UNASSIGNED

        9........LINE SELECT....UNASSIGNED

      10........LINE SELECT....UNASSIGNED

      11........LINE SELECT....UNASSIGNED

      12........LINE SELECT....UNASSIGNED

      13........LINE SELECT....UNASSIGNED

      14........LINE SELECT....UNASSIGNED

      15........LINE SELECT....UNASSIGNED

      RETURN CONTINUES DISPLAY..... =>

      16........LINE SELECT....UNASSIGNED

      17........LINE SELECT....UNASSIGNED

      18........LINE SELECT....UNASSIGNED

      19........FEATURE........ANSWER/RELEASE

      20........FEATURE........HANDS FREE AUTOANSWR

      21........FEATURE........CONFERENCE

      22........FEATURE........CALL PARK

      23........FEATURE........CALL FORWARD

      24........FEATURE........CALL PICKUP

      25........FEATURE........CALLBACK

      26........FEATURE........InteMail - DIRECT ACCESS

      27........FEATURE........CALL TRANSFER

      28........FEATURE........DISPLAY

      29........FEATURE........HOLD

      30........FEATURE........LAST NUMBER REDIAL

      END OF DISPLAY

        • Can Monarch parse this?
          Grant Perkins

          When you say you need to turn the reports into delimited format, what exactly do you need to create? I understand delimited, but delimited by what criteria?

           

          Grant

           

           

          Originally posted by Rhack:

           

          [font="courier"] Report 1[/b]

          DIRECTORY NUMBER or ?........................ => 42115

          USER GROUP................................... => 1

           

            • VOICE LINE DEFINITION                12/16/04     11:42:07

          DRN...DIRECTORY NUMBER...................42115

          UGP...USER GROUP NUMBER..................1

          COS...CLASS OF SERVICE...................2

          CPG...CALL PICKUP GROUP NUMBER...........201

          TYP...CALL PICKUP TYPE...................B

          HNC...HOME NNP NUMBER....................(NONE)

          ACD...ACD PILOT NUMBER...................NONE

          HUN...HUNT PILOT NUMBER..................NONE

          APR...AUTOMATIC PRIVACY RELEASE..........NO

          CAD...100 NUM ABBREVIATED DIALING........NO

          DIA...STATION DIAGNOSTIC ALLOWED.........NO

          FIE...CALL FORWARD - INTERNAL/EXTERNAL...NO

          CFN...CALL FORWARD - NO ANSWER...........45400

          CFB...CALL FORWARD - BUSY................IMMEDIATE

          ......BUSY DIRECTORY NUMBER..............45400

          CFA...CALL FORWARD - ALL.................INACTIVE

          HOT...HOT LINE DIRECTORY NUMBER..........INACTIVE

          OHA...OFFHOOK ALERT DESTINATION NUMBER...INACTIVE

          TOD...TIME OF DAY RESTRICTIONS...........NO

          VID...InteMail ID FOR VOICE LINE.........NONE

          STATION     TYPE  BUTTON     RING OPTION

          RETURN CONTINUES DISPLAY..... =>

          01.3.09.04 ITES     2        RING

          END OF DISPLAY

           

           

          DIRECTORY NUMBER or ?........................ => 42119

          USER GROUP................................... => 1

           

            • VOICE LINE DEFINITION                12/16/04     11:42:12

          DRN...DIRECTORY NUMBER...................42119

          UGP...USER GROUP NUMBER..................1

          COS...CLASS OF SERVICE...................2

          CPG...CALL PICKUP GROUP NUMBER...........210

          TYP...CALL PICKUP TYPE...................B

          HNC...HOME NNP NUMBER....................(NONE)

          ACD...ACD PILOT NUMBER...................NONE

          HUN...HUNT PILOT NUMBER..................NONE

          APR...AUTOMATIC PRIVACY RELEASE..........NO

          CAD...100 NUM ABBREVIATED DIALING........NO

          DIA...STATION DIAGNOSTIC ALLOWED.........NO

          FIE...CALL FORWARD - INTERNAL/EXTERNAL...NO

          CFN...CALL FORWARD - NO ANSWER...........45400

          CFB...CALL FORWARD - BUSY................IMMEDIATE

          ......BUSY DIRECTORY NUMBER..............45400

          CFA...CALL FORWARD - ALL.................INACTIVE

          HOT...HOT LINE DIRECTORY NUMBER..........INACTIVE

          OHA...OFFHOOK ALERT DESTINATION NUMBER...INACTIVE

          TOD...TIME OF DAY RESTRICTIONS...........NO

          VID...InteMail ID FOR VOICE LINE.........46610

          STATION     TYPE  BUTTON     RING OPTION

          RETURN CONTINUES DISPLAY..... =>

          02.1.05.23 ITE      3        NO RING

          01.2.05.03 ITE      4        NO RING

          01.3.07.24 ITES     2        RING                 InteMail-MSG DISP

          02.1.09.11 ITES     2        NO RING

          END OF DISPLAY

           

          DIRECTORY NUMBER or ?........................ => 42122

          USER GROUP................................... => 1

           

           

          Report 2[/b]

           

            • STATION DEFINITION:         12/16/04  14:13:08

           

          ***...STATION.......................PORT 01.2.11.12

          RETURN CONTINUES DISPLAY..... =>

          ***...STATION EQUIPMENT TYPE.............ITE

          BTP...BUTTON TEMPLATE NUMBER.............2

          DND...DO NOT DISTURB ALLOWED.............NO

          VMC...InteMail MESSAGE DESK OPERATOR.....NO

          AND...ALPHANUMERIC DISPLAY...............NO

          AHL...AUTOMATIC HOLD.....................NO

          HRC...SWITCHHOOK RINGER CUTOFF...........NO

          DPT...DTMF PASSTHROUGH TIMING INDEX......NONE

          ADD...ADT ANALOG SIDE DTMF DIALING.......NO

          LPR...LINE PRESELECT TYPE................PRIME

          PLB...PRIME LINE PRESELECT BUTTON #......1

          RETURN CONTINUES DISPLAY..... =>

          BUTTON     TYPE              LINE/FEATURE ID

            1.PL.....VOICE LINE.....DRN:46476 - UGP:1...RING           Mail-MSG

            2........VOICE LINE.....DRN:63605 - UGP:1...RING

            3........LINE SELECT....UNASSIGNED

            4........LINE SELECT....UNASSIGNED

            5........LINE SELECT....UNASSIGNED

            6........LINE SELECT....UNASSIGNED

            7........FEATURE........InteMail - DIRECT ACCESS

            8........FEATURE........CALL FORWARD

            9........FEATURE........CALL PICKUP

          10........FEATURE........CALLBACK

          11........FEATURE........CALL TRANSFER

          12........FEATURE........HOLD

          END OF DISPLAY

           

            • STATION DEFINITION:         12/16/04  14:13:11

           

          ***...STATION.......................PORT 01.2.11.13

          ***...STATION EQUIPMENT TYPE.............ITES

          BTP...BUTTON TEMPLATE NUMBER.............81

          DND...DO NOT DISTURB ALLOWED.............NO

          VMC...InteMail MESSAGE DESK OPERATOR.....NO

          AND...ALPHANUMERIC DISPLAY...............YES

          RETURN CONTINUES DISPLAY..... =>

          AHL...AUTOMATIC HOLD.....................NO

          HRC...SWITCHHOOK RINGER CUTOFF...........NO

          DPT...DTMF PASSTHROUGH TIMING INDEX......NONE

          ADD...ADT ANALOG SIDE DTMF DIALING.......NO

          LPR...LINE PRESELECT TYPE................PRIME

          PLB...PRIME LINE PRESELECT BUTTON #......1

          BUTTON     TYPE              LINE/FEATURE ID

            1.PL.....VOICE LINE.....DRN:45953 - UGP:1...RING           Mail-MSG

                                    HFA - INACTIVE

            2........LINE SELECT....UNASSIGNED

            3........LINE SELECT....UNASSIGNED

            4........LINE SELECT....UNASSIGNED

            5........LINE SELECT....UNASSIGNED

            6........LINE SELECT....UNASSIGNED

            7........LINE SELECT....UNASSIGNED

            8........LINE SELECT....UNASSIGNED

            9........LINE SELECT....UNASSIGNED

          10........LINE SELECT....UNASSIGNED

          11........LINE SELECT....UNASSIGNED

          12........LINE SELECT....UNASSIGNED

          13........LINE SELECT....UNASSIGNED

          14........LINE SELECT....UNASSIGNED

          15........LINE SELECT....UNASSIGNED

          RETURN CONTINUES DISPLAY..... =>

          16........LINE SELECT....UNASSIGNED

          17........LINE SELECT....UNASSIGNED

          18........LINE SELECT....UNASSIGNED

          19........FEATURE........ANSWER/RELEASE

          20........FEATURE........HANDS FREE AUTOANSWR

          21........FEATURE........CONFERENCE

          22........FEATURE........CALL PARK

          23........FEATURE........CALL FORWARD

          24........FEATURE........CALL PICKUP

          25........FEATURE........CALLBACK

          26........FEATURE........InteMail - DIRECT ACCESS

          27........FEATURE........CALL TRANSFER

          28........FEATURE........DISPLAY

          29........FEATURE........HOLD

          30........FEATURE........LAST NUMBER REDIAL

          END OF DISPLAY /font[/quote][/b][/quote]

          • Can Monarch parse this?
            Rhack _

            I need to bring into excl and access.  So for example, Report 1 would be something similar:

             

            Table Field Names:

            Directory Number,CPG,CFN,CFB,CFBDN,Set Type 1,Port 1,Button1,Set Type 2,Port 2,Button 2 etc...

             

            Result Data:

            42115,201,45400,IMMEDIATE,45400,ITES,"01.03.09.04",2,,,,

            42119,210,45400,IMMEDIATE,45400,ITE,"02.01.05.23",3,,,,

             

            Report 2 Field names:

            Port, Station Type,Button1, Type1, Feature1,..Button30,Type 30,Feature30

             

            Report 2 result data:

            "01.02.11.12",ITE,1,VOICE LINE,46476,2,VOICE LINE,63605,....12,FEATURE,HOLD

            "01.02.11.12",ITE,1,VOICE LINE,45953,2,LINE SELECT UNASSIGNED,.....30,FEATURE,HOLD

            • Can Monarch parse this?
              Grant Perkins

              In principle Monarch should be able to do a great job on the reports. But I am always slightly cautious just in case there can be records which are so extreme in content - number of rows for example - that problems might arise. At first site the samples look OK.

               

              I assume that some of the fields are from screen copies rather than a printed file? Is it safe to ignore those? If so I will experiment and see how it goes.

               

              Grant

               

              Originally posted by Rhack:

              I need to bring into excl and access.  So for example, Report 1 would be something similar:

               

              Table Field Names:

              Directory Number,CPG,CFN,CFB,CFBDN,Set Type 1,Port 1,Button1,Set Type 2,Port 2,Button 2 etc...

               

              Result Data:

              42115,201,45400,IMMEDIATE,45400,ITES,"01.03.09.04",2,,,,

              42119,210,45400,IMMEDIATE,45400,ITE,"02.01.05.23",3,,,,

               

              Report 2 Field names:

              Port, Station Type,Button1, Type1, Feature1,..Button30,Type 30,Feature30

               

              Report 2 result data:

              "01.02.11.12",ITE,1,VOICE LINE,46476,2,VOICE LINE,63605,....12,FEATURE,HOLD

              "01.02.11.12",ITE,1,VOICE LINE,45953,2,LINE SELECT UNASSIGNED,.....30,FEATURE,HOLD /b[/quote]

              • Can Monarch parse this?
                Steve Caiels

                Hi Rhack,

                 

                Yep - this should be no problem for Monarch.

                 

                Here is the principle to look at when you get it.  I’ve added line numbers to make the explanation easier, but they are not needed for the solution

                [font="courier"]1 Record 1 starts here

                2 Here is some standard stuff that is on every records

                3 And another line

                4 A 3rd line makes it even easier!!!

                 

                5 ABC...But these lines may or may nor be on each record

                6 XYZ...Who knows if it’s here?

                7 123...Maybe a number is used as an identifier

                8 Record 1 ends here

                 

                 

                 

                1 Record 2 starts here

                2 Here is some standard stuff that is on every records

                3 And another line

                4 A 3rd line makes it even easier!!!

                 

                5 DEF...This is here, but not above

                6 XYZ...This is on both records

                7 ......Hmm, a bit trickier as there is no identifier

                8 JJJ...And this record has more lines than the other

                9 Record 2 ends here[/font][/quote][b]Stage 1[/b]

                Create a 4 line detail template from line 1 to line 4. 

                Trap on something specific to the constant data (e.g. starts here)

                Highlight the constant info that you need

                 

                Stage 2[/b]

                Create a 4 line append, but use the same selection and trap as you used for the detail template in stage 1.  

                Using the first line of the sample (it will say "record 1 starts here"), highlight the start and end position of the “5 ABC...But these lines may or may not be on each record” field. The highlight will be in the wrong place at the moment

                Double click on the highlight you just created and go onto the advanced tab.

                Use the Preceding string (on current line) option and type ABC into the box

                Repeat the process on the 2nd line of the sample, this time using XYZ as the preceding string.

                Keep doing this until you have used up all the lines.

                Line 7 on record 2 is not a problem as it has 6 dots rather than 3 (as in your example as well, so just use 6 dots for the preceding string.

                 

                Stage 3 to stage 10 (possibly 11?) if needed[/b]

                Create new templates as in stage 2.  You can have up to 9 appends, and you can probably use a page header template to do the same thing if you have to.  So in this short example, you can extract all the fixed data, plus up to 4 variable fields for each of the 10 or 11 extra templates

                 

                Final stage[/b]

                Export the data to Excel or Access.  Both of these are supported, so there is no need to create a delimited file.  Just open the results for a neatly formatted excel sheet with column headings and correctly formatted dates etc. 

                 

                Monarch Professional has Project Exports that will allow you to create a complex export job to insert data into existing sheets (i.e. report 1 on tab 1, report 2 on tab 2,   or add a new month to a rolling database)

                 

                For high end automation and automatic distribution via email, rss feed etc or upload to a SQL database, take a look at Datapump.

                 

                Hope this all makes sense?

                 

                Private message me with you email address if you like and I can send you the text file and model for the above.

                 

                Cheers

                Steve (in damp South West UK - looks like no snow again for Xmas this year     )

                • Can Monarch parse this?
                  Rhack _

                  Thank you both for the responses. Excellent information.  Grant, to your question in regards to screen copies - This is an old phone system that is not very report friendly.  I have a script in Procomm that sends the telephone number I need to display, waits for a "Return Continues Display" then sends enter.  So it is an automated screen capture.  In the file, the data lines up better than the cut & paste.

                   

                  Steve, the line you have the Hmmm...  This is what I am worried about, I was hoping I could define all possible fields and if they were not found processing would continue to next record.  I wrote a VB program years ago that did something similar but I wanted to avoid that route.  I am very very rusty with my programming.

                   

                  What I am wanting to do this for is a large project where I am replacing some old telephone systems.  I want to automate the data review as much as possible without having to key in everything off of the captured data.