4 Replies Latest reply: May 15, 2014 9:59 AM by Grant Perkins RSS

    Problem getting started with models!

    Bo _

      I have been through all the examples in the learning guide and read through the forum for insight on makink templates. Here is what I am trying to extract to database ready format....

       

      [font="courier"]Aspen Medical Group P.A.     

       

       

      "1021 Bandana Blvd. E, Ste. 200"     

      "St. Paul, Minnesota"     

      55108     

      United States     

       

      Tel:           (651) 642-2700

      Fax: FX - USA     (651)637-2970     

       

       

       

      Business     Services: Medical clinics.

      Variant Name     Sundance Medical Clinics - Merger

       

       

       

      SIC Codes     8011 - Offices Of Physicians

      NAICS Codes     621111 - Offices of Physicians (except Mental Health Specialists)

      Annual Sales     "$106.00 M Operating revenue, Estimate"

      Employees     "885, Telephone Interview"

      Sales/Employees     "$119,774.00 "

      Year Founded     1983

      Fiscal Year     31-Dec-00

      SMSA Code     "5120 - Minneapolis-St. Paul, MN-WI"

      Features     "Private Company, Headquarters Location"

      URL          http://www.aspenmed.org/[/url]

      Email Address     hr@aspenmed.org[/email]

       

       

      Officers     Tom Holets - Chief Executive Officer

                "Nancy Everetz - Senior Vice President, Finance"

                "Mark Allen - Vice President, Management Information Systems"

                David Anderson - Vice President[/font][/quote]I am not clear on what my detail template should be. I've tried many times but end up not being able to add append templates after about eight or so templates.

      I need all the feilds. Any direction would be helpful. I am using Monarch pro v5

       

      Thanks

        • Problem getting started with models!
          Grant Perkins

          Bo,

           

          It depends what you want to put in the database and whether your source records are consistently formatted.

           

          To me it looks like the entire record its detail although the Address information at the top is likely to be a special case and the same goes for the 'officers'at the bottom since the number of them (and therefore lines to process) could be different.

           

          If the format is inconsistent life will be more interesting ...

           

          From a quick view I don't see where appends would come into this one - but I may be wrong.

           

          Grant

           

          Originally posted by Bo:

          I have been through all the examples in the learning guide and read through the forum for insight on makink templates. Here is what I am trying to extract to database ready format....

           

          [font="courier"]Aspen Medical Group P.A.     

           

           

          "1021 Bandana Blvd. E, Ste. 200"     

          "St. Paul, Minnesota"     

          55108     

          United States     

           

          Tel:           (651) 642-2700

          Fax: FX - USA     (651)637-2970     

           

           

           

          Business     Services: Medical clinics.

          Variant Name     Sundance Medical Clinics - Merger

           

           

           

          SIC Codes     8011 - Offices Of Physicians

          NAICS Codes     621111 - Offices of Physicians (except Mental Health Specialists)

          Annual Sales     "$106.00 M Operating revenue, Estimate"

          Employees     "885, Telephone Interview"

          Sales/Employees     "$119,774.00 "

          Year Founded     1983

          Fiscal Year     31-Dec-00

          SMSA Code     "5120 - Minneapolis-St. Paul, MN-WI"

          Features     "Private Company, Headquarters Location"

          URL          http://www.aspenmed.org/[/url]

          Email Address     hr@aspenmed.org[/email]

           

           

          Officers     Tom Holets - Chief Executive Officer

                    "Nancy Everetz - Senior Vice President, Finance"

                    "Mark Allen - Vice President, Management Information Systems"

                    David Anderson - Vice President[/font][/quote]I am not clear on what my detail template should be. I've tried many times but end up not being able to add append templates after about eight or so templates.

          I need all the feilds. Any direction would be helpful. I am using Monarch pro v5

           

          Thanks /b[/quote]

          • Problem getting started with models!
            Bo _

            Yes, the format will be consistent and I the relevant database fields to trap(for examples). I finally figured out the addredd "postal" trap but still need assistance.

            [font="courier"] 

            *address block*

            IntegraMed America Inc. (INMD)     

            2 Manhattanville Rd.

            3rd Fl.

            Purchase, New York 10577-2113

             

            *unused*     

            United States     

             

            *fields for inclusion in table*

            Tel:           (914) 253-8000

            (800)458-0044

            Fax: FX - USA     (914)253-8008     

             

             

             

                 Services: Women's health care physician practice management company focusing on infertility and assisted reproductive technology.

                 IVF Australia (USA) Ltd. - Name Change

                      IVF America Inc. - Name Change 1995/07/20

                      "IntegraMed America, Inc. - Legal Name"

             

             

             

                 PricewaterhouseCoopers L.L.P.

                 8011 - Offices Of Physicians

                      8741 - Management Services

                 621111 - Offices of Physicians (except Mental Health Specialists)

                      561110 - Office Administrative Services

                 "$88.20 M Operating revenue, Company Press Release"

                 "660, Company Press Release"

                 "$133,636.00 "

                 1985

                 31-Dec-02

                 "5600 - New York, NY"

                 "Public Company, Headquarters Location"

                 NASDAQ

                 INMD

                      http://www.integramed.com[/url]

                 info@integramed.com[/email]

             

             

                 "Gerardo Canet - Chief Executive Officer, President, Chairman of the Board"

                      "John W. Hlywak Jr. - Senior Vice President, Chief Financial Officer"

                      "Jay Higham - Senior Vice President, Marketing"

                      "Donald S. Wood - Senior Vice President, Chief Operating Officer"

                      "Peter Cucchiara - Vice President, Management Information Systems"

                      Claude White - Secretary[/font][/quote]I have been starting off with highlighting the

            [font="courier"]

            IntegraMed America Inc. (INMD)     

            2 Manhattanville Rd.

            3rd Fl.

            Purchase, New York 10577-2113

            /font[/quote]block and then using the "postal" trap naming each field. Next I start down the list one "append" template for each field data. Before I trap all the fields, I end up only having the option of a footer or header template. I am new and my first time report writing. Basically, the above code would become one record in a database.

            • Problem getting started with models!
              Grant Perkins

              Bo,

               

              Having seen 2 examples now I think part of the problem is that there are a number of fields that have a variable line count and so the format is not quite consistent.

               

              You can try to work around this using the 'preceeding string' option for the field definition for the non-variable fields. Not sure about the variable fields in this case but they maybe can be appends.

               

              If I can make some time this evening (I am a few hours ahead of you being in the UK) I will try to put some real templates around the suggestion. If you let me have your email address via the Private Message feature I will mail you with anything useful I can create.

               

              A word of warning. In my experience there will always be one more anomally to test the model in this sort of file format! Some compromise may be required.

               

              Grant

               

              Originally posted by Bo:

              Yes, the format will be consistent and I the relevant database fields to trap(for examples). I finally figured out the addredd "postal" trap but still need assistance.

              [font="courier"] 

              *address block*

              IntegraMed America Inc. (INMD)     

              2 Manhattanville Rd.

              3rd Fl.

              Purchase, New York 10577-2113

               

              *unused*     

              United States     

               

              *fields for inclusion in table*

              Tel:           (914) 253-8000

              (800)458-0044

              Fax: FX - USA     (914)253-8008     

               

               

               

                   Services: Women's health care physician practice management company focusing on infertility and assisted reproductive technology.

                   IVF Australia (USA) Ltd. - Name Change

                        IVF America Inc. - Name Change 1995/07/20

                        "IntegraMed America, Inc. - Legal Name"

               

               

               

                   PricewaterhouseCoopers L.L.P.

                   8011 - Offices Of Physicians

                        8741 - Management Services

                   621111 - Offices of Physicians (except Mental Health Specialists)

                        561110 - Office Administrative Services

                   "$88.20 M Operating revenue, Company Press Release"

                   "660, Company Press Release"

                   "$133,636.00 "

                   1985

                   31-Dec-02

                   "5600 - New York, NY"

                   "Public Company, Headquarters Location"

                   NASDAQ

                   INMD

                        http://www.integramed.com[/url]

                   info@integramed.com[/email]

               

               

                   "Gerardo Canet - Chief Executive Officer, President, Chairman of the Board"

                        "John W. Hlywak Jr. - Senior Vice President, Chief Financial Officer"

                        "Jay Higham - Senior Vice President, Marketing"

                        "Donald S. Wood - Senior Vice President, Chief Operating Officer"

                        "Peter Cucchiara - Vice President, Management Information Systems"

                        Claude White - Secretary[/font][/quote]I have been starting off with highlighting the

              [font="courier"]

              IntegraMed America Inc. (INMD)     

              2 Manhattanville Rd.

              3rd Fl.

              Purchase, New York 10577-2113

              /font[/quote]block and then using the "postal" trap naming each field. Next I start down the list one "append" template for each field data. Before I trap all the fields, I end up only having the option of a footer or header template. I am new and my first time report writing. Basically, the above code would become one record in a database. /b[/quote]

              • Problem getting started with models!
                Grant Perkins

                Hi Bo,

                 

                I have created a model that should give you some progress in your endeavours. There are however some questions to consider - the two sample layouts do have differences that need to be dealt with by the model.

                 

                If you let me have your email address via the Private message function I will send you my comments and an attachment with the files I have created (Using V5.02) from the posted samples and the model as it is currently. This will be the easiest way for you to see the concepts I have employed and AND the questions that remain.

                 

                Best regards,

                 

                Grant