Difference between revisions of "Family Group Worksheet V10"

From TNG_Wiki
Jump to: navigation, search
(FGW Revision History)
(TNG Websites Using This Add-on)
Line 243: Line 243:
| [[User:Torlund|Tor Lund]]
| [[User:Torlund|Tor Lund]]
| Public site
| Public site
| TNG 10.0.1
| TNG 10.0.1
| EN, NO, DA, FR, DE
| EN, NO, DA, FR, DE

Revision as of 12:51, 11 April 2014

Family Group Worksheet V10
Summary Provides forms for visitors and invited guests to organize and submit family information for inclusion in the website.
Validation n/a
Mod Updated {{{mod_last_update}}}
Download link fgw_v10.0.0.4.zip
TNG 10.0
Download stats view statistics
Author(s) Rick Bisbee
Homepage Bisbee Family Connection
Mod Support Support for Family Group Worksheet V10
Contact Developer Rick Bisbee
Latest Mod
Min TNG V 10.0.0
Max TNG V 10
Files modified
Related Mods
Worksheet is self installing -- does not use Mod Manager


Family Group Worksheet V10 adds a traditional genealogical family group sheet to a TNGv10 website. It differs from previous versions in that it stores worksheets on site and they can be retrieved by both the admin/editor and by the original submitter. Visitors can open an empty worksheet and fill in information about themselves and their families. They can generate a worksheet from a tab on a TNG personal or family group page, pre-filled with information from the page and ready for revision or addition.

New in version 4: the site administrator can allow his editors to process Family Group Worksheets that fall within their assigned trees. Naturally, the FGW setup page is reserved for admins only.

Invited Guests

The admin/editor can generate a family group worksheet, pre-fill it any way he likes, and mail a secure link to someone, say Uncle Harry, and ask him to click on the link and fill in whatever information he can about his family. Uncle Harry is not presumed to have computer skills beyond using email, and he is not required to have an account or log into the website to provide his own family history. This would be similar to mailing a family group sheet to a relative and asking them to mail it back.

When a worksheet is completed and saved, an email notification is sent to the site administrator. A copy is also sent to the submitter containing a secure link for him to re-access it if he wants to add or revise. The admin/editor has a small control panel at the top of each submitted worksheet to manipulate and determine its status.

You Should know

FGW V10 comes with support files for several languages -- Dutch, English, French, German and Spanish. Some of these files were developed using Google Translate. If a native speaker cares to submit files that are more idiomatic, we will be happy to replace them. There is a master help file in English -- others will be provided as/if they become available. There are also help links on the form for some of the data fields.

FGW V10 requires a new table in the TNG database that is created during setup. The default table name is fgw_forms. If you wish to name it something else, you can do so on the initial setup page. There are also Mod Manager files available to add worksheet tabs to personal and family group pages, and to modify TNG to include the new forms table in TNG backups.

Most of the features from previous versions of FGW remain.

Planned Upgrades

FGW V10 is designed to accommodate future upgrades to 1) add one-click merging of data into the TNG database, and 2) automatically create and attach a source-citation to each new fact, for example, "Unsourced information from Family Group Worksheet 216, submitted to this website by Uncle Harry, son of Jerry Smith, 4 July 2014."

FGW Revision History

Version Date Description 28 Mar 2014
  • Initial release of FGW V10 31 Mar 2014
  • Modified to accommodate i/net hosting services that have not yet installed MySQLi -- the improved version of MySQL used by FGW 4 Apr 2014
  • Fixed notification when leaving page without saving changes (IE)
  • Removed residual test mode settings that may have caused inconsequential warnings
  • Improved labels and added placeholders where needed 10 Apr 2014
  • Fixes (we hope) the problem some were having creating the forms table in the database
  • Adds setup functions to name, create, and delete the FGW forms table (admins only)
  • Adds option to allow TNG editors to administer FGW worksheets within their assigned trees
  • Provides Important Notices for configuration and processing results
  • Adds "smart" defaults for living flags based on dates of birth and death


A couple of websites have reported that FGW will not create the forms table. Hopefully this will be fixed in version 4. If not the most likely cause is a file permissions/ownership issue. Unpacking the FGW zip folder on your desktop and using an FTP program like FileZilla to upload it to your website may resolve it, as FileZilla sets the permissions and ownership to the proper values.

I haven't tried it, but it may also work to resolve the same problem in a desktop WAMPS site.


  • A working installation of TNGv10
  • PHP 5+


The development community is no longer supporting the MySQL Library. In fact most of the MySQL library functions have been deprecated and are replaced by MySQLi (improved MySQL). FGW uses the MySQLi interface, but if it is not present on you server, it reverts to MySQL. That means that during the transition, it should work well, whether your host provider has MySQLi installed yet or not.

Family Group Worksheet

Shown is in the default styling with LDS event fields displayed (configurable by the administrator.) If website has more than one family tree, a drop down selection menu is presented. If the user is an invited guest, the tree list and personID fields are disabled.


Admin Control


After the worksheet has been submitted the Admin can access it with just the ID number or by clicking on the link in the emailed notification. Anyone else must have the security key.

For admins, a control panel will display at the top of the form. If the visitor provides information on a person or family already in the database, but has not supplied the person or family ID, the admin can add them here. After merging the new information to the TNG database, he can mark it merged. If the submitter returns and updates his form, new notification will be sent to the admin, the merged status flag will be reset, and the worksheet will be considered active again. The admin can also mark the worksheet closed, in which case the visitor no longer has access to it. Finally, the admin can can use the control panel to delete the worksheet from the database.

The admin control section also allows navigating through the saved worksheets with an option to ignore those that have been merged and/or closed. You can search for other worksheets using worksheet ID (no prefix), family ID (prefix 'F') or person ID (prefix 'I'), or by clicking on the Search by ID button with no ID, you can display the entire selectable list of worksheets, showing their numbers, titles and status (merged, closed).

There is no separate help file for the setup page.

Please Note: While there is an automated merge capability planned for a future release, currently all merging of new information into the database must be done manually by the admin.

Installing FGW V10 (version 4+)

If you download and install FGW V10, please add your Website to the list of users at the bottom of this article. Future upgrades and maintenance will depend on how much it is being used. --Thanks.

  • Remove previous version of the fgw folder from your extensions folder.
  • Download the fgw_10 package from the TNGWiki.
  • Unzip and place the fgw folder inside your extensions folder.
  • Navigate to extensions/fgw/setup.php.
  • Enter the name of your existing forms table if you want to continue using it, or you want to remove (drop) it from the database. To create a new table, either keep the default name or enter one of your own choosing.
  • Select the other options you want and click on Save Preferences.
  • At the bottom of the setup page, next to the Create Table button, you will see the status of your preferred table; it either exists or does not exist. If the table already exists, look for a link below the button for you to update it if necessary. To Delete it click on Drop Table.
  • Warning! If you choose to create a table that already exists, it will delete all the existing records.
  • Click on Family Group Worksheet button.

Completely Uninstalling FGW V10 (version 4+)

  • Go to the FGW setup page and Drop the forms table (can also be used to remove older FGW tables if present)
  • Remove and discard the fgw folder from the extensions directory
  • Remove and discard the fgw_tabs mod (if installed)
  • Modify or remove the Personal Table Maintenance mod (if installed)

Administrator's Setup Page — Top

When you navigate to extensions/fgw/setup.php you will see a setup screen where you can create the worksheet forms table in the database and set your preferences. You can revert to the default settings at any time. Bookmark this page in your browser for easy access in the future. Also consider adding an admin-only link to one of your drop down menus (see below.)


The top portion of the setup page is where you set the name for your FGW forms table. The default is fgw_forms, but if you want to select a different name, enter it here and save your preferences below. If you are using a table named in a previous version, change it here and save it.

You can check the box to allow anyone logged in as an editor to access the saved worksheets, provided they are associated with his assigned tree. If the editor has not assigned tree, he will be able to access all worksheets. Remember, only the admin can access this site-wide setup page.

Check the box to display forms for submission only to logged in users restricts public visitors from seeing any Family Group Worksheets. There is one exception, however: if a member of the public has been sent an email request for information, and they click on the included link, which contains both an ID and a form key number, they will have access to the specific form to edit and submit it. They will not be able to change the tree or any person IDs on the form.

The third check box at the top will hide LDS fields.

The following fields are used the customize the appearance of the worksheet.

Administrator's Setup Page — Bottom


The bottom of the setup page has controls to save your preferences after you've changed them. There is also a control to restore the worksheet to its original default configuration.

Finally, there are controls for creating or removing the FGW table from the TNG database. These controls work on the file name you've entered at the top and saved in your preferences.

If this is your first installation and are happy to keep the default table name, just click on the Create Table button.

If you have installed a new version of FGW and want to keep your old table with all of its records, enter the name of your table at the top and save the preferences. The table is not modified in any way.

The status next to the Create Table button should tell you if the table exists or must be created. If it exists, there may also be a link telling you to update the structure. It will only appear if your table needs updating. Clicking on this link will safely update the table without harming any of the worksheet records you already have.

Be aware that the LDS viewability setting for the worksheet does not override your TNG setup. If you have LDS turned off for the website, you can not turn it on in the Family Group Worksheet. The same holds true for individual user settings.

Linking to the Worksheet

You will need to add a link to the worksheet (extensions/fgw/fgw.php) for users to access it. TNGv10 allows you to add links to the TNG drop down menus or to a custom menu you have created. To use this feature you must define your link in your customconfig.php file. In the following example, we add a worksheet link to the TNG *Find* menu.

$link_nr = 0; // first add-on link_nr must be zero 
$findmenulinks[$link_nr]['target'] = "extensions/fgw/index.php";
$findmenulinks[$link_nr]['sprite'] = "";
$findmenulinks[$link_nr]['icon'] = "extensions/fgw/img/families.gif";
$findmenulinks[$link_nr]['label_text'] = "Submit Family";
$findmenulinks[$link_nr]['admin'] = false;

FGW V10 will list existing worksheets with the following URL: extensions/fgw/fgw.php?id=index. To add an admin-only link to a custom menu that you have already defined and populated with other links:

$link_nr++; // subsequent add-on links must be incremented (++) 
$custommenulinks[$link_nr]['target'] = "extensions/fgw/fgw.php?id=index";
$custommenulinks[$link_nr]['sprite'] = "";
$custommenulinks[$link_nr]['icon'] = "extensions/fgw/img/families.gif";
$custommenulinks[$link_nr]['label_index'] = "ws_list";
$custommenulinks[$link_nr]['admin'] = true;

Notice in the last example we used a $cust_text.php definition for the link's label in support of multiple languages. Of course, you must provide that label yourself in your cust_text.php files for each language; for example, in English-UTF8/cust_text.php: $text['ws_list'] = 'FGW Index';

For greater detail about how to customize your drop down menus, see the TNGv10 Custom Menu Hook

FGW Tabs Mod

For those who would like to have a tab at the top of each personal and family page to open a Family Group Worksheet pre-populated with data from the source page, see the companion FGW Tabs Mod. There is no change to this mod from TNGv9, so if you already have it installed, there is no need to replace it.

Personal Table Maintenance Mod

Install the Personal Table Maintenance mod by Bart Degryse if you would like to have the FGW forms table included in those that are backed up using the TNG Admin backup utility. If you are already using this mod, add the FGW forms table name to your list of personal tables.

For those who use a third party backup utility such as MySQLDumper, the new table will automatically be included in your SQL backup files. These SQL files are also useful for downloading to a WAMPS site and restoring the database as an exact copy of what is on line.

Using a Captcha

The captcha was removed in version 4 as it was problematic and thought to be unnecessary. If you disagree, please let the developer know about it.

TNG Websites Using This Add-on

If you download and install this add-on, please add your TNG site to the table below to let us know if there is enough interest in it to warrant active maintenance.

URL Admin Note Mod-Version/TNG-Version User-language(s)
A Bisbee Family History Rick Bisbee Public site (FGW developer) TNG 10.0.1 EN
Mitchell Families Online Roger Mitchell Rick's continuing development of this add-on takes it from strength to strength! TNG 10.0.1 EN
Farnham & Paradise Ohana Barbara Farnham Paradise beta test site TNG 10.0.1 EN
Our Family History Tor Lund Public site TNG 10.0.1 EN, NO, DA, FR, DE


There is no warranty. Use the add-on at your own risk. It has been tested in many of the TNG template styles without any particular problems. If you experience difficulty or would just like to comment, please Contact us here