upload image

Quebec Catholic Parish Register - Year Index Project

Privacy Level: Open (White)
Profile manager: Greg Clarke private message [send private message]
This page has been accessed 192 times.

This project falls under the purview of the Québec Team part of Canada Project

The goal of this project is to create a series of Google Spreadsheets to act as an Index of Years for the FamilySearch collection of Quebec Catholic Parish Registers.

Currently, the Quebec Catholic Parish Registers collection on FamilySearch (free to access, thus ideal for linking primary records to WikiTree profiles) is not fully indexed and searchable. If you know the date of a record, you have to search through a register containing multiple years, and multiple images per year.

The purpose of this project is to create a spreadsheet for each parish that will indicate the starting image for each year in the register as well as a direct link to it. Some parish registers also contain an Index of Names for people in a given year, and a link to that index image will also be recorded.

The two founding members of this project are Paul Chisarik and Greg Clarke based on advice from Danielle Liard, Karen Tobo and others who contributed to Paul's initial post on the G2G forum.


Outline of Project

Here are the phases of the task that need to be done. Greg is doing the original spreadsheet creation and linking and Paul is coordinating the setup phase. We welcome all volunteers who would like to help out.

  • Phase 0 : create Master Index spreadsheet and decide on Template for individual parish spreadsheets.
  • Phase 1 : create individual parish spreadsheets and link to Master Index
  • Phase 2 : setup parish spreadsheets with additional info and links so they function properly and are ready for data input
  • Phase 3 : input data for starting image for years in parish spreadsheets

How You Can Help !

  • Anyone can help out and add links to help us fill out the Index of Years. See below for Detailed Description (Phase 3), but the short version is this:
    • Open up an individual parish spreadsheet from the Master Index
    • When you are on the FamilySearch website, and find the beginning of a year (any year),
      • Click the COPY CITATION button (at the bottom of the Information pane)
      • Switch to the parish spreadsheet, and in the appropriate row, find the StartCitation column and paste the citation (CTRL + V or something similar)
    • Rinse, lather, repeat.
  • If you are very comfortable with using Google Spreadsheets, and would like to help with the setup of the individual parish spreadsheets, contact Paul Chisarik .

Detailed Descriptions of Phases

Phase 0 : create Master Index

Phase 1 : create individual parish spreadsheets

  • Phase 1 : create individual parish spreadsheets and link to Master Index
    • for each parish:
      • copy template to create unique parish spreadsheet
      • substitute parish name for template text,
      • add years in column A for those included in register records
      • link to Master Index
        • fill out parish name beside town as it is written in FamilySearch collection (even if that is technically incorrect - so that it can be found by those who only know it by that name),
        • add URL,
        • add WikiTree category if exists
        • if town associated with parish is different from FamilySearch name for it, create duplicate row in Master Index with proper town name (so it can be found by those who search for the true name).
    • Status : Beginning. 82 of 800 created.
    • Who: Greg

Phase 2 : setup parish spreadsheets

  • Phase 2 : setup parish spreadsheets with additional info and links so they function properly and are ready for data input
    • for each parish:
      • verify parish name and town are accurate
      • update URL for Map from LaFrance (edit number at end after /map/)
      • add proper link to www.originis.ca for parish information
      • link to Master Index
      • apply formatting (use paint icon to copy format) for parish register headings in column A.
      • delete formulas in those heading rows in columns B, C, D so register heading can be read in its entirety, if needed
      • verify formulas in columns B,C,D,E exist to bottom of years as needed. IF there are more than 400 rows in spreadsheet, copy formulas from row 400 down to bottom of file
      • setup the Jump To quick links to allow easy navigation (adjust years for jumps as needed)
      • add a link for the first register (at least)
      • once setup steps are complete, fill out entry in Master Index
        • add AKA (also known as) entries for parish, alternatives parish was renamed over the years, and/or the sometimes incorrect name used for it in FamilySearch collection
        • add Record Years, and Index Years if applicable
        • add Y to the Setup column of Master Index for this parish
        • if the parish row was duplicated (because of proper town name vs FamilySearch town name) - do the same thing for duplicate so info is complete there as well
    • Status : Very Beginning. 42 of 800 setup and ready for data input.
    • Who: Paul & his volunteers

Phase 3 : populate parish spreadsheets

  • Phase 3 : input data for starting image for years in parish spreadsheets
    • open up parish spreadsheet by clicking on Google Sheet link in Master Index spreadsheet
      • open up FamilySearch register by clicking on link in parish spreadsheet if you don't already have FamilySearch open
      • add an entry for a year that doesn't have a Starting Image entry
        • navigate to that image in the register. (Note - some years start in the middle or even at the end of a page - we want that image URL, even if the beginning entries on the page are for the previous year)
        • at the bottom of the FamilySearch page, open up the Information pane if it's not already open, and scroll down to click on the COPY CITATION button
        • switch to the parish spreadsheet - and PASTE the citation exactly as is in the column marked StartCitation for the appropriate year's row
        • immediately, the columns to the left for Starting Image and URL should be populated
      • if you find a page that begins an Index for a year (sometimes called the Repetoire, or Directory), follow a similar process
        • go to bottom of page where Index begins, click on COPY CITATION from Information pane
        • paste the citation in the column marked IndexCitation for the appropriate year's row
      • some registers organize their index by last name and not by year. (e.g. an index for all those whose surname starts with A and were baptised in the parish over a range of years).
        • use the same process as described above, but enter this information on the second tab in the spreadsheet titled "Letter Index"
      • Suggestion: Start off by adding links for Starting Images at strategic places, always put in the first starting image per register, then a quarter through the register, half way, three-quarters. As time permits, sub-divide the task further until eventually every year is covered.
      • If you finish ALL the years for a parish spreadsheet, and all the indexes (if they exist) - then update the Master Index by adding a Y in the Complete column for that parish.
    • Status : Very Beginning. 42 of 800 setup and ready for data input.
    • Who: Every WikiTreer is welcome to contribute to this resource! Please help.

Will you join us? Please post a comment here on this page, in G2G using the project tag, or send Greg a private message. Thanks!

  • Login to edit this profile and add images.
  • Private Messages: Send a private message to the Profile Manager. (Best when privacy is an issue.)
  • Public Comments: Login to post. (Best for messages specifically directed to those editing this profile. Limit 20 per day.)
Comments: 4

Leave a message for others who see this profile.
There are no comments yet.
Login to post a comment.
Is anyone still working on this? I’m looking for some way to help in the Quebec project. I am familiar with these records for multiple churches.
posted by Liza (Macklem) Gervais
I do apologize for being so slow and at this point, almost at a stand still. My computer broke down so now I'm stuck doing all my stuff through my phone. I'm really saddened by this, but do know that when able, I'll definitely continue to help. This project is very close to my heart.
posted by Andréa Boudreau
Welcome Andréa! Always happy to have new members join this project. Bienvenue!

Anyone else out there interested? Leave a message here, or send me a personal message.

posted by Greg Clarke
I've just found my calling with this project. I spend my entire days in the FamilySearch Québec Parish books. You'll have the South shore of Montréal filled soon! LOL. I want to join in.
posted by Andréa Boudreau