Category:Henny Savenije - Reports
A set of sample TNG reports contributed by Henny Savenije, updated 25 Feb 2009, can be downloaded from the TNG Download page under TNG Extras.
To install, unzip and copy files to your backups folder, then restore.
(WARNING: the restore will overwrite your previous reports).
Additionally, individual reports are available below.
A set of sample TNG reports contributed by Henny Savenije. The layout is a bit messy but I had two choices. If I leave the wiki markup on, the double quotes ('') were used to change the text into italics. To see a better layout, edit the page and copy the text between < nowiki> < /nowiki> NB: pay close attention that the table names are the same. I used the standard ones with maybe one exception. I used tng_ass instead of tng_associations. Some people might have chosen different names. In that case replace the table names in a simple search and replace action in notepad.
Some servers need the tree name added in the statements, in that case add ,gedcom after the SELECT statement. So if I have
SELECT personID, lnprefix, lastname, firstname, burialdate, burialdatetr FROM
Change that to
SELECT personID, lnprefix, lastname, firstname, burialdate, burialdatetr, gedcom FROM
Pages in category "Henny Savenije - Reports"
The following 221 pages are in this category, out of 221 total.
A
C
I
- Individuals without date of birth/baptism/death/burial
- Individuals without places
- Individuals: age frequency distribution
- Individuals: events: peoples with "empty" residences (check for data plausibility)
- Individuals: events: residences with associated names sorted on residence
- Indivuals ordered by ascending age
- Invalid Dates
- Invisible characters in date field
R
- Report: Admin Report that lists all places having no zoom or place level
- Report: Age of people at the beginning of WW2 (1940) eligable to fight
- Report: Age of people when they died 2
- Report: Ages of people when they died
- Report: all occuring places, including place levels
- Report: all occuring second place name levels p, including frequency
- Report: all occuring second place name levels, including frequency, ordered by frequency
- Report: All occuring third place levels, including frequency, ordered by place level
- Report: All occuring third place name levels, including frequency, ordered by frequency
- Report: All the men in the database sorted on first name
- Report: All the women in the database sorted on first name
- Report: aquarius
- Report: Aries
- Report: Associations between people
- Report: birthday to death, one = equals 10 people
- Report: Born after Baptized
- Report: Branches with associated families, ordered by branch and husband's last name
- Report: Branches with associated families, ordered by branch and wife's maiden name
- Report: Branches with associated families, ordered by husband's last name
- Report: Branches with associated families, ordered by wife's maiden name
- Report: Branches with associated individuals, ordered by branch and individual's name
- Report: Branches with associated individuals, ordered by individual's name
- Report: Branches with number of associated individuals
- Report: branches with their associated families ordered by branch and husbands name
- Report: branches with their associated families ordered by branch and wife's maiden name
- Report: branches, with statistics
- Report: Cancer
- Report: capricornus
- Report: Children born after 9 months after their father's death
- Report: Children born after the death of their mother
- Report: Children born before their mother
- Report: Couples having the same names
- Report: Create a view of families marked living
- Report: Days between death and burial
- Report: DE WET VAN TWAALF
- Report: Different surname as both parents
- Report: Distance between death place and the place burried (in Km)
- Report: Distance in kilometers between birth place and baptism place
- Report: Distance in kilometers between place of birth and place of death
- Report: Documents linked to people not to an event
- Report: Double names
- Report: empty notes
- Report: Families with only one spouse and no children
- Report: families, ordered by husband's name
- Report: families, ordered by wife's maiden name
- Report: families: couples with same last names
- Report: families: frequency distribution of husband's marriage age, by 5-year-steps
- Report: families: frequency distribution of husband's marriage age, by year
- Report: families: frequency distribution of marriage age, by year
- Report: families: frequency distribution of wife's marriage age, by 5-year-steps
- Report: families: frequency distribution of wife's marriage age, by year
- Report: families: husbands
- Report: Families: husbands/wives, sorted by place of marriage
- Report: families: individual with marriage date *after* death date
- Report: families: individuals with father, but without mother (mother is missing)
- Report: families: individuals with marriage date *before* birthdate
- Report: Families: individuals with missing father or missing mother
- Report: families: marriage frequency by calendar month
- Report: families: marriage types with individuals (with personIDs *and* names)
- Report: families: occuring marriage types without names (but with frequency)
- Report: Families: Twins
- Report: Families: twins, triplets..
- Report: families: wifes
- Report: Faulty baptismal dates
- Report: Faulty birth dates
- Report: Faulty birth, baptism, death and burial APROXIMATE dates, e.g. abt1988
- Report: Faulty burial dates
- Report: Faulty dates these are all faulty dates
- Report: Faulty death dates
- Report: faulty even dates
- Report: faulty marriage dates
- Report: Frequency of people's marriage place
- Report: Gemini
- Report: Husband is female
- Report: Incomplete families
- Report: Individuals (not: families!) with number of associated children
- Report: Individuals marked as living
- Report: individuals married with age older than 80 years
- Report: individuals married with age younger than 18 years
- Report: individuals who died on their birthday
- Report: individuals with 100. birthdate this year or next year
- Report: individuals with 50. birthdate this year or next year
- Report: individuals with 60. birthdate this year or next year
- Report: individuals with 65. birthdate this year or next year
- Report: individuals with 70. birthdate this year or next year
- Report: individuals with 75. birthdate this year or next year
- Report: individuals with 80. birthdate this year or next year
- Report: individuals with 85. birthdate this year or next year
- Report: individuals with 90. birthdate this year or next year
- Report: individuals with an unclear date of birth
- Report: individuals with and unclear date of death
- Report: individuals with associated notes
- Report: individuals with different deathplace and place of burial
- Report: individuals with missing father or missing mother
- Report: individuals with mother, but without father (father is missing)
- Report: individuals, by place of baptism
- Report: individuals, by place of birth
- Report: individuals: age frequency per decade
- Report: individuals: baptism frequency by century
- Report: individuals: birth frequency by calendar months
- Report: individuals: birth frequency by century
- Report: individuals: birth frequency by day-of-week
- Report: individuals: birth frequency by decades
- Report: individuals: days between birth and baptism
- Report: individuals: death frequency by calendar months
- Report: individuals: death frequency by century
- Report: individuals: death frequency by day-of-week
- Report: individuals: death frequency by decades
- Report: individuals: events: alias names with associated people, ordered by alias name
- Report: individuals: events: alias names with associated people, ordered by real name
- Report: individuals: events: emigrated persons
- Report: individuals: events: occupations with names
- Report: individuals: events: occupations without names but with frequency
- Report: individuals: events: occupations without names ordered on frequency
- Report: individuals: farmers - with farmer's names, ordered by farmer's name
- Report: individuals: farmers - with farmer's names, ordered by occupation
- Report: individuals: frequency distribution of days from birth to baptism
- Report: individuals: number of days between birth and death
- Report: individuals: titles with corresponding names
- Report: inviduals: birthdays in the current month
- Report: Leo
- Report: Libra
- Report: List eventypes
- Report: List of men who were eligable to fight in the papal wars
- Report: Living People
- Report: Lving People with name sur name
- Report: Media not associated with a tree
- Report: Media overview by media type
- Report: Media statistics
- Report: Media which are *not* set as "default photo"
- Report: Media which are always visible
- Report: Media which are set as "default photo"
- Report: Media with associated people, *with* having media linked to an event
- Report: Media with associated people, *without* having media linked to an event
- Report: Media with coordinates
- Report: Media without coordinates
- Report: Multiple births (even when born on different days)
- Report: Number of people originating from first level birthplace
- Report: Number of people originating from second level birthplace
- Report: Number of people originating from third level birthplace
- Report: Number of people with the same last and first name ordered alphabetically
- Report: Orphaned families
- Report: Orphans
- Report: People *with* associated media, but *without* default photo
- Report: People born after they died
- Report: People born into more families
- Report: People buried before death
- Report: People ordered with the age of their parents
- Report: People sorted according to number of children
- Report: People with a different surname as their father
- Report: People with aproximate birthdates in certain places
- Report: People with non-alphabetic characters in their name
- Report: People with the same first and last name ordered by number
- Report: People with the same surname as their mother
- Report: People without a default image
- Report: People without any dates
- Report: Persons whose last name is the same as the last name of their mother
- Report: persons whose last names are different from last name of father *and* last name of mother
- Report: PHP media
- Report: Pisces
- Report: Placenames in the Netherlands without maps
- Report: Places ordered by the last entered
- Report: Places with an empty description but with coordinates
- Report: Places with no people attached
- Report: Places without coordinates
- Report: Report: individuals: titles with corresponding names
- Report: Sagittarius
- Report: Same sex marriages
- Report: Scorpio
- Report: Show private notes
- Report: sources with citation frequency and number of cited persons, ordered by citation
- Report: sources with citation frequency and number of cited persons, ordered by frequency of people
- Report: Sources with frequency and persons, ordered by sources
- Report: sources with notes, including note contents
- Report: sources without any citations
- Report: Sources: citations associated with families, just the link
- Report: sources: citations with associated individuals, ordered by citation text
- Report: sources: citations with associated individuals, ordered by individual's name
- Report: Statistic of people becoming parents
- Report: Statistics of places where people were baptized
- Report: Taurus
- Report: The wife is male
- Report: Unused place names
- Report: users ordered according to last login
- Report: Virgo
- Report: weeks between birth and death
- Report: Wrong place names for FAMIILIES
- Report: Wrong place names for PERSONS
- Report:individuals: death causes with names
- Report:individuals: death causes without names but with frequency
- Report:individuals: people with nicknames, ordered on nicknames
- Report:Orphans without partner and childeren
- Reports Children with a different sounding surname than their father
- Reports last name prefixes