I have shifted to the excel format for data entry and it has sped up the entry task. Thanks!

How does one set a filter on gender?

I tried check and repair of the database and it came back and said one corrupted family was fixed. but it does not say which family it fixed.  Is there a way to figure out which family was corrupted?

Also is there a way to tell the (Reports->Graphs->Relationship Graph) to preserve the order of the children? I am in the veritcal top to bottom mode and would like to see the eldest to the youngest should be in order. Currently the graph that comes out randomizes the kids with no apparent order.


From: Benny Malengier <benny.malengier@gmail.com>
To: Bobby Singh <b_bobby_singh@yahoo.com>
Cc: "gramps-users@lists.sourceforge.net" <gramps-users@lists.sourceforge.net>
Sent: Wednesday, November 30, 2011 5:17 PM
Subject: Re: [Gramps-users] text file to gramps database and misc questions

2011/11/26 Doug Blank <doug.blank@gmail.com>
On Sat, Nov 26, 2011 at 5:23 AM, Bobby Singh <b_bobby_singh@yahoo.com> wrote:
> Thanks Benny and Doug. I used the gramplet and it worked fine.

Your'e welcome!

> Few more questions:
> a) Is there a  textfile interface from which gramps database can be
> populated?
>     This can potentially help speed up the task when a lot of entries need
> to be added. Adding them one by one becomes very slow with all the clicking
> that needs to take place.

There are three things:

a) All of the imports are essentially textual imports. Gramps XML,
GEDCOM, and all of the rest can be written by hand if you wish and
imported. Not easy, but possible.

b) There is a Spreadsheet import that is specifically designed for
exactly for this purpose:

> b) Is there a limitation on the size of the database that gramps uses? I am
> running it on mac book air.

No practical limit:

> c) One question from my previous email was about how to count number of
> girls (or boys or dads) in each generation starting from the leaf node
> (assume birthdates are not known).

There are many options:

* you can set a filter on gender

In case you did not see, the bottom bar on a listview shows the amount of rows presents in the view over the total, so eg 25/400, indicating you have 25 entries that satisfy the filter, on 400.


* you can run the statistic report

* the Statistics Gramplet shows you the count; double-click it to see a list.

Hope this helps,


> Thanks and Regards,
> -Bobby
> ________________________________
> From: Doug Blank <doug.blank@gmail.com>
> To: Benny Malengier <benny.malengier@gmail.com>
> Cc: Bobby Singh <b_bobby_singh@yahoo.com>;
> gramps-users@lists.sourceforge.net
> Sent: Thursday, November 17, 2011 4:59 PM
> Subject: Re: [Gramps-users] (no subject)
> On Thu, Nov 17, 2011 at 4:06 AM, Benny Malengier
> <benny.malengier@gmail.com> wrote:
>> You would need some code to do this.
>> Some options:
>> 1/open the top surnames gramplet and safe it as a new gramplet. Your idea
>> of
>> frequency of first names would be a great new gramplet. Also as a new
>> report
>> type this is interesting
> There is a Given name Cloud Gramplet that already does much of what
> you would need.
> -Doug
>> 2/If you want to avoid learning a bit of the internals of Gramps, then you
>> can use spreadsheet. This goes as follows:
>> Via the Preferences->Display, set the name type to Given, so that only the
>> first name shows in the person views. Then go the flat person view (so not
>> grouped per surname), via the configuration make first name and birth date
>> the first columns, sort on first name (click on column header) and export
>> to
>> a csv file using the menu option Family Tree->Export View, which you open
>> in
>> a spreadsheet (if you have LibreOffice you can directoy export the view as
>> an opendocument spreadsheet, which is faster). Then use the spreadsheet
>> functions to calculate and plot the frequencies. So, a function to add a
>> column with the number of equal names in column 1 would be:
>> =COUNTIF(A1:A955, A1)
>> and then copy this formula from the first row down to the last by
>> selecting
>> and dragging it down.
>> This gives you a column with the frequency, then you remove duplicate rows
>> and insert eg a pie chart with this frequency. I'm not a spreadsheet guru,
>> for frequency per time period, writing it as a gramplet would be faster
>> for
>> me :-)
>> The second is fastest if you need a quick idea. The first is best to share
>> with the Gramps community and make it really usefull with some options.
>> Greetings,
>> Benny
>> 2011/11/15 Bobby Singh <b_bobby_singh@yahoo.com>
>>> Hello There,
>>> I am trying to solve two problems and perhaps the list already knows a
>>> solution.
>>>     a) If I want to get a frequency of first names in a database how can
>>> I
>>> do this?
>>>     b) If I want to get the same statistics as in a) but generation by
>>> generation starting from the youngest to the oldest generation how would
>>> I
>>> do this?
>>> Thanks and Regards,
>>> -Bobby
>>> ------------------------------------------------------------------------------
>>> RSA(R) Conference 2012
>>> Save $700 by Nov 18
>>> Register now
>>> http://p.sf.net/sfu/rsa-sfdev2dev1
>>> _______________________________________________
>>> Gramps-users mailing list
>>> Gramps-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/gramps-users
>> ------------------------------------------------------------------------------
>> All the data continuously generated in your IT infrastructure
>> contains a definitive record of customers, application performance,
>> security threats, fraudulent activity, and more. Splunk takes this
>> data and makes sense of it. IT sense. And common sense.
>> http://p.sf.net/sfu/splunk-novd2d
>> _______________________________________________
>> Gramps-users mailing list
>> Gramps-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gramps-users