TMG-L Archives

Archiver > TMG > 2006-03 > 1141341101


From: Lee Hoffman <>
Subject: Re: [TMG] List of sources - title?
Date: Thu, 02 Mar 2006 18:11:41 -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>
In-Reply-To: <440736D1.5090004@cleaveland.info>


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.

Hope this helps -

Lee Hoffman/KY
TMG Tips: <http://www.tmgtips.com>;
My website: <http://www.tmgtips.com/lhoffman>;
A user of the best genealogy program, The Master Genealogist (TMG)


This thread: