TMG-L Archives

Archiver > TMG > 2006-03 > 1141345095


From: Richard Cleaveland <>
Subject: Re: [TMG] List of sources - title?
Date: Thu, 02 Mar 2006 19:18:15 -0500
References: <4405C123.90506@cleaveland.info> <00a401c63d59$47ddf4f0$6501a8c0@charliexvi> <4406195C.4090902@cleaveland.info> <7.0.0.16.2.20060301215101.04dbd940@acm.org> <440736D1.5090004@cleaveland.info> <7.0.0.16.2.20060302133656.04e280c0@acm.org>
In-Reply-To: <7.0.0.16.2.20060302133656.04e280c0@acm.org>


Lee Hoffman wrote:
> Richard Cleaveland wrote:
>
>> Lee Hoffman wrote:
>>
>>> You are on the right track here. What you want is the "M" file after
>>> the export The file name would be (assuming the file is Cleveland)
>>> something like - ClevelandM.XLS.
>>> Open this in Excel. There will be a number of columns of data that
>>> you don't care about but the columns you want will have the following
>>> as column headers :
>>> majnum
>>> abbrev
>>> title
>>> type
>>
>>
>> Lee, I don't find a title field in .M. I do find abbrev.
>
>
> Hmm! I had not looked at that area for a long time. The Title field
> and a few other fields are actually stored in a different file it has
> the same file name but is a different File Type - in this case,
> ClevelandM.FPT (instead of ClevelandM.DBF). Those fields do not get
> picked up when exporting to Excel. I suggest that you have the Excel
> file sorted by Source ID#, go to TMG and create the List of Sources
> report using the Title List type sorted by Source ID# and send that to
> Excel. Now with the other file still open in Excel, open this new
> file. You can now do a Copy/Paste of the Title column from the List of
> Source report to the XLS copy of the M file.
>
> The normal location of the Titler field in the M file would be between
> the default surety (defsure) column and the Source Type (type) column.
>
Well heck - I'll just install my old copy of Foxpro and see what I get.
Wonder if it'll work under XP.

Dick

This thread: