TMG-L Archives

Archiver > TMG > 2006-03 > 1141587565


From: Richard Cleaveland <>
Subject: Re: [TMG] List of sources - title?
Date: Sun, 05 Mar 2006 14:39:25 -0500
References: <4405C123.90506@cleaveland.info> <00a401c63d59$47ddf4f0$6501a8c0@charliexvi> <4406195C.4090902@cleaveland.info> <7.0.0.16.2.20060301215101.04dbd940@acm.org>
In-Reply-To: <7.0.0.16.2.20060301215101.04dbd940@acm.org>


Lee Hoffman wrote:
> Richard Cleaveland wrote:
>
>> Really what I wanted was a list of titles sequenced by source type.
>> Sorry I neglected to include that in my post.
>
>
> Yes, that is not available in the List of Source report.
>[snip]
>
> You are on the right track here. What you want is the "M" file after
> the export[snip]
> 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
>
> [snip]
>
> Note that the Type column is a numeric value. This corresponds to the
> Sourtype column value in a different file -- specifically the
> ClevelandA.XLS file. You can open it in Excel and convert the number
> there to the name of the Source Type.

Lee, I spent hours on this problem and have found that your method of
relating the two files doesn't work for me. For one thing, the _a file
has three definitions for most source type numbers (SOURTYPE) -
presumably Mills, Custom and the other I can't put a name to at the
moment. Then too, none of these types maps satisfactorily to TYPE
entries in the _m table.

The solution for me (I use custom source types)is:
a. select from table _a only those entries with a RULESET of 3
(corresponds to custom).
b. Relate SOURTYPE in the _a file to CUSTTYPE in the _m table.

Then I can select the NAME from the _a table and the TITLE from the _m
table and get the correspondence I wanted (to see if I had used the
source types consistently).

BTW I did this all in Access, having converted the DBF tables used by
TMG to DBF tables using the program (duh) DBF to MDB from Whitetown Wizards.

Dick

This thread: