TMG-L Archives

Archiver > TMG > 2006-03 > 1141350721


From: Richard Cleaveland <>
Subject: Re: [TMG] List of sources - title?
Date: Thu, 02 Mar 2006 20:52:01 -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> <44078B47.7010200@cleaveland.info>
In-Reply-To: <44078B47.7010200@cleaveland.info>


Richard Cleaveland wrote:
> 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.
The answer is yes, but it's too old to handle the dbf's used with TMG.
Sigh.

Dick

This thread: