GENBOX-L ArchivesArchiver > GENBOX > 2007-06 > 1181648357
From: Shelley French <>
Subject: Re: [GENBOX] Printing source templates
Date: Tue, 12 Jun 2007 21:39:17 +1000
> Shelley French wrote:> > Just a quick question - is there any way to print a simple list of> > the three source templates for each source type? The best way I can> > see is to print a source report with the source type and templates as> > content but of course you get a line for every source you have, not> > just one for each type.> > Don Zochert wrote:> I was able to do this by creating a custom source report with the > following fields selected as content:> Type> Template> Sec. Template> Bib. Template> > In selecting a key for this report, I sorted the list of sources on the > Type column, then went through and selected one example of each type > (this required multiple selections). The result was a list giving the > source type name and each of the three templates with their template codes.> > This produces a list of all source types being used. It doesn't pick up > unused source, since you select your keys from a list of actual sources. > But it may do.>
Thanks Don for the suggestion.
The report is pretty much what I came up with but I hadn't thought of picking out a set of example sources. Following your suggestions I started picking them out but then decided that I wasn't going to use the report often enough. I didn't think I'd remember to add to the list of example sources as I used new source types.
For anyone who's interested, I got from 572 lines down to just one line for each source type (27 in total) with about 30 seconds work in Excel...
- paste the table in with sorted source types in column A (column headings in row 1)
- enter the formula =if(A2=A1,0,1) in row 2 of the next empty column - copy the formula all the way to the bottom by double clicking the little box at the lower right corner of the cell. This puts a 1 in the row with the first instance of each source type and a 0 next to the others.
- use the autofilter (under tools or data or somewhere... sorry I'm being a bit vague. I actually used OpenOffice but am describing what I did in Excel terms) to show only the rows with 0s, then select and delete those rows.
- turn off the autofilter again and you're done.
Now to start work on what I think those templates should look like!
Connect to the next generation of MSN Messenger