Thanks Benny and Doug. I used the gramplet and it worked fine.

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.

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

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).

Thanks and Regards,

From: Doug Blank <>
To: Benny Malengier <>
Cc: Bobby Singh <>;
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
<> 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.


> 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 <>
>> 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
>> _______________________________________________
>> Gramps-users mailing list
> ------------------------------------------------------------------------------
> 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.
> _______________________________________________
> Gramps-users mailing list