Blogs - Progeny Genealogy Inc.

Finding events with no source citations; finding multiple events (SQL pt. 4)

The following operations will go a long way to help you clean up your genealogy data. Events with no citations Let’s say you want to want to find all persons with an 1850 Census fact, but with no source citation. It can be any event type, this is just an example. First, make a list…

Tips for safeguarding your family’s Historical Documents

Preserving and safeguarding your family’s historical documents is crucial for maintaining a connection with your heritage. Here are some tips to help you protect these valuable pieces of your family history: Store Documents in a Safe Location: Choose a cool, dry, and dark place to store your historical documents. Avoid areas with fluctuating temperatures or…

How Social Media can help you grow your Family Tree

Social media can be a valuable tool for growing your family tree and connecting with relatives. Here are some ways social media can assist you in this process: Connect with Relatives: Platforms like Facebook, Instagram, and Twitter allow you to search for and connect with relatives. You can join genealogy or family history groups, where…

Charting Companion “SQL query” feature — Part 3

All burials in a certain place, ex: “CT” Connecticut select PIN, FROM_DATE, EV_TYPE, (select NAME from PERSONS as P where P.PIN = E.PIN) as NAME, (select PLACE_NAME from PLACES as PL where PL.PLACE_NO = E.PLACE_NOB and PL.PLACE_NO > 0 ) as PLACE from EVENTS as E where E.EV_TYPE = 4 and PLACE like “%CT%” Burial…

Charting Companion “SQL query” feature — Part 2

Formatting If an alias is assigned (“as…”) that starts with “NAME”, Charting Companion will understand that it is a name column, and will re-format it accordingly. Charting Companion stores the names in an internal format that includes binary delimiters of the name parts. The following aliases can be used. The alias need only begin with…

Charting Companion “SQL query” feature — introduction

New Charting Companion “SQL query” feature Charting Companion 8.2 introduces the SQL query feature, which enables you to extract custom or bespoke information from your genealogy database. “SQL” stands for Structured Query Language. It is a set of general-purpose commands to change or retrieve information from any relational database. CC uses SQLite. The SQL query…

Charting Companion database schema

When Charting Companion imports a GEDCOM file, it creates an auxiliary database as a workfile, in SQLite format. Charting Companion can execute SQL Queries by clicking “Find ➔ SQL Query”. Requires version 8.2 or later. Alternatively, the SQLite file is located in “C:\Users\user-id\AppData\Local\Temp\Progeny\CC\“, has the same name as the GEDCOM file, with the extension .DB….

Exploring Immigration records: Uncovering your family’s history

Passenger lists, Ship’s Manifests, Border Crossings, Customs & Immigration forms are all rich sources of ancestor information. Here are a few Websites wit extensive information to help you tell the story of your family. Algeria Andorra Antigua and Barbuda Argentina Armenia Australia Australia, Queensland Australia, South Australia Australia, Victoria Austria Bahrain Bangladesh Barbados Belarus…

The Role of DNA testing in Family Tree research

Genetic research offers new ways for genealogists to build their family tree, where conventional records and sources are not available. Genealogists are submitting DNA samples to testing companies who can identify unique patterns in the DNA, and match the genealogist to millions of other participants. Adoptees are using DNA to search for biological parents. Distant…

Researching Your Family Tree: How to Use Online Resources

Researching your family history and building a family tree chart can be a fulfilling pastime. It helps you learn your family’s story and understand yourself a little better in the process. But how can you get the best out of the many online resources and software programs now available? Below, we’ve looked at all…

A Beginner’s Guide to Family Tree Research

“In all of us,” writes author Alex Haley, “there is a hunger, marrow-deep, to know our heritage—to know who we are and where we have come from.” Learning about your family history (genealogy) can help build a connection to your past and satisfy your curiosity about distant ancestors. Whether you’re eager to connect with other…

Announcing Charting Companion for Mac

We are pleased to announce that Charting Companion now runs on the Apple Mac. If you are a Mac user, get Charting Companion for Mac, and tell the story of your family with unique and captivating charts and books. If you are a Family Tree Maker user, Charting Companion also runs as a convenient plugin. Buy Charting Companion for Mac. Also…