TMG-L Archives

Archiver > TMG > 2006-08 > 1154706270


From: "Laurie Williams" <>
Subject: Re: [TMG] Newbie question - List of People increasing number of columns?
Date: Fri, 4 Aug 2006 11:44:30 -0400
References: <002201c6b7da$b4cc01a0$d698403e@delle309ea0577>
In-Reply-To: <002201c6b7da$b4cc01a0$d698403e@delle309ea0577>


On 8/4/06, Kelly <> wrote:
>
> I've just discovered that I can export data from TMG into Excel rather
> than
> maintain my Excel spreadsheet myself. I'm using the List of People report
> but it only has 9 columns, is there any way of increasing this number? Or
> can anyone tell me a better report to use?


Hi Kelly,

Not that I'm aware of, but those more experienced may know. What I do to get
more columns is to run the report twice or more. The first reports has the
columns that would fit. The second report has some common column(s) with the
first and then the rest of the columns you want. Then I just combine the two
in Excel, making sure the people line up, which they should as long as you
use the same filter or group of people. Then just hide or delete the
duplicated columns.

I'm trying to export a list of everyone in my dataset. Ideally I would like
> it in generation order e.g. me first, then my parents and then all my
> aunts
> and uncles followed by my grandparents and then all their brothers and
> sisters, next my great grandparents etc. I appreciate to do this I might
> need to add my only numbering flag and sort by that, is there any data
> within TMG I could use instead?


I think the flag or a reference number is the only way.

The data I then want to export is whether or not I have the birth, marriage,
> death certificates and the relevant census entries. I have already set up
> flags for these.
>
> Within Excel I would expect to see something like:
>
> Name Birth Marriage Death
> 1901 1891 1881 1871
> 1861 1851 1841
> Me Y ? ? N N N N
> N N N
>
> Mum Y Y ? N N N N
> N N N
> Dad Y Y ? N N N N
> N N N
>
> Uncle Y Y ? N N N N
> N N N
>
>
> Grandparent Y Y Y Y N N N
> N N N
>
>
> In this instant N=N/A but I don't seem to be able to set this value as a
> flag.


As far as I know, all flags, except birth order, only allow one character.

Laurie

This thread: