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....


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/
Email Address hr@aspenmed.org


Officers Tom Holets - Chief Executive Officer
"Nancy Everetz - Senior Vice President, Finance"
"Mark Allen - Vice President, Management Information Systems"
David Anderson - Vice PresidentI 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

[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....


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/
Email Address hr@aspenmed.org


Officers Tom Holets - Chief Executive Officer
"Nancy Everetz - Senior Vice President, Finance"
"Mark Allen - Vice President, Management Information Systems"
David Anderson - Vice PresidentI 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

[Bo]

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


**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



[Business] Services: Women's health care physician practice management company focusing on infertility and assisted reproductive technology.
[Variant Names] IVF Australia (USA) Ltd. - Name Change
IVF America Inc. - Name Change 1995/07/20
"IntegraMed America, Inc. - Legal Name"



[Auditors] PricewaterhouseCoopers L.L.P.
[SIC Codes] 8011 - Offices Of Physicians
8741 - Management Services
[NAICS Codes] 621111 - Offices of Physicians (except Mental Health Specialists)
561110 - Office Administrative Services
[Annual Sales] "$88.20 M Operating revenue, Company Press Release"
[Employees] "660, Company Press Release"
[Sales/Employees] "$133,636.00 "
[Year Founded] 1985
[Fiscal Year] 31-Dec-02
[SMSA Code] "5600 - New York, NY"
[Features] "Public Company, Headquarters Location"
[Stock Exch] NASDAQ
[Ticker] INMD
[url]http://www.integramed.com
[email]info@integramed.com


[Officers] "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 - SecretaryI have been starting off with highlighting the


IntegraMed America Inc. (INMD)
2 Manhattanville Rd.
3rd Fl.
Purchase, New York 10577-2113
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.

[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 [bracketed] the relevant database fields to trap(for examples). I finally figured out the addredd "postal" trap but still need assistance.


**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



[Business] Services: Women's health care physician practice management company focusing on infertility and assisted reproductive technology.
[Variant Names] IVF Australia (USA) Ltd. - Name Change
IVF America Inc. - Name Change 1995/07/20
"IntegraMed America, Inc. - Legal Name"



[Auditors] PricewaterhouseCoopers L.L.P.
[SIC Codes] 8011 - Offices Of Physicians
8741 - Management Services
[NAICS Codes] 621111 - Offices of Physicians (except Mental Health Specialists)
561110 - Office Administrative Services
[Annual Sales] "$88.20 M Operating revenue, Company Press Release"
[Employees] "660, Company Press Release"
[Sales/Employees] "$133,636.00 "
[Year Founded] 1985
[Fiscal Year] 31-Dec-02
[SMSA Code] "5600 - New York, NY"
[Features] "Public Company, Headquarters Location"
[Stock Exch] NASDAQ
[Ticker] INMD
[url]http://www.integramed.com
[email]info@integramed.com


[Officers] "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 - SecretaryI have been starting off with highlighting the


IntegraMed America Inc. (INMD)
2 Manhattanville Rd.
3rd Fl.
Purchase, New York 10577-2113
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.

[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