Readme Version 4 1
===========================================
PhpGedView
Version 4.1 Copyright 2005 John Finlay and others
This and other information can be found online at http://www.PhpGedView.net
The installation instructions can also be found in the wiki at:
http://wiki.phpgedview.net/en/index.php/Installation_Guide
# $Id: readme.txt 1970 2007-10-19 21:25:17Z yalnifj $
===========================================
CONTENTS
1. LICENSE
2. INTRODUCTION
3. SYSTEM REQUIREMENTS
4. QUICK INSTALL
5. INSTALLATION
6. UPGRADING
7. UPDATING GEDCOMS
8. THEMES
9. MULTIMEDIA OBJECTS
10. RSS FEED
11. DATABASE TABLE LAYOUT
12. MANUAL CONFIGURATION
13. SECURITY
14. LANGUAGES
15. NON-STANDARD GEDCOM CODES
16. LANGUAGE EXTENSION FILES
17. MIGRATING FROM SQL TO INDEX MODE AND VICE VERSA
18. POSTNUKE AND PHPNUKE INTEGRATION
19. BACKUP
LICENSE
PhpGedView: Genealogy Viewer Copyright (C) 2002 to 2007 John Finlay and Others
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
See the file GPL.txt included with this software for more detailed licensing information.
INTRODUCTION
PhpGedView is a revolutionary genealogy program which allows you to view and edit your genealogy on your website. PhpGedView has full editing capabilities, full privacy functions, and supports multimedia like photos and document images. PhpGedView also simplifies the process of collaborating with others working on your family lines. Your latest information is always on your web site and available for others to see. For more information and to see working demos, visit http://www.PhpGedView.net/
PhpGedView is Open Source software that has been produced by people from many countries freely donating their time and talents to the project. All service, support, and future development is dependent on the time developers are willing to donate to the project, often at the expense of work, recreation, and family. Beyond the few donations received from users, developers receive no compensation for the time they spend working on the project. There is also no outside source of revenue to support the project.
SYSTEM REQUIREMENTS
PhpGedView requires a web server with at least PHP v4.3 and around 20MB of web space. The default installations of PHP on most servers should provide you with all of the PHP functionality you should need.
Database
You will need at least 1 database and a username and password to access it. PhpGedView primarily supports MySQL, but has also been tested and shown to work with Postgresql, SQLite, and SQL-Server. The versions required for each of these databases is outlined below: MySQL 3.23+ PostgresQL 8.0+ SQLite available through PDO-SQLite which is included in PHP 5 MS SQL-Server 2003+
Web space
At least 20MB of web space on the web server. You will need more than this if you intend to store multimedia linked to individuals.
To use the reporting engine, PHP needs to be compiled with XML support. This is compiled into PHP by default unless it is specifically disabled. See http://us3.php.net/manual/en/ref.xml.php
Some features of PhpGedView require the GD library and that PHP be compiled with GD support. Most precompiled versions of PHP include GD support. If you are compiling PHP yourself you will need to configure it with the
--with-gd
option. See http://us3.php.net/manual/en/ref.image.php
The advanced calendar features of PhpGedView for converting Gregorian dates to the Hebrew or Jewish calendars require that PHP be compiled with the
--enable-calendar
configuration option. See http://us2.php.net/manual/en/ref.calendar.php for more information.
For GEDCOMs larger than 2MB, you will likely need to research different hosting options and find one that will accept a request to modify the default memory and time limits built into PHP. See the FAQ at http://www.phpgedview.net/faq.php for more information about large GEDCOMs.
QUICK INSTALLATION
These instructions can also be found in the wiki at: http://wiki.phpgedview.net/en/index.php/Installation_Guide
Follow the instructions in this section to install PhpGedView if you are already familiar with the program or are familiar with installing other PHP web applications.
1. Upload the files to your web server.
2. Set Write permissions on config.php and the "index" directory. For
optimal security, you should move the "index" directory to a location
where it is not accessible from the Internet.
3. Point your browser to the directory where you uploaded your PhpGedView
files (for example, http://www.yourserver.com/PhpGedView/).
4. Enter your configuration settings. If you moved the index directory,
be sure to specify the correct location to it on this page. Save the
configuration parameters.
5. Enter the default administrator user.
6. Login as this user and upload your GEDCOM file.
7. Save the GEDCOM configuration settings.
8. Import the GEDCOM.
Optional Steps
9. If you want to use the language editing features you will need to set
Write permissions for all of the files in the ./languages folder.
10. If you want to upload media files using the Upload Media section of
the Admin menu then you need to set Write permissions for your ./media
and ./media/thumbs directories.
11. If you want to edit your GEDCOM file online, the GEDCOM file must have
Write permissions set for the PHP user.
12. If you want to use the Backup feature of the Upgrade utility in
PhpGedView you will need to either set Write permission on the
PhpGedView folder itself or create a folder named "backup" with Write
permissions. Write permissions for the PhpGedView folder can be
removed as soon as the backup folder is in place and has the
appropriate permissions.
13. For security you should set the permissions back to Read-only when you
are done editing or uploading files.
INSTALLATION
These instructions can also be found in the wiki at: http://wiki.phpgedview.net/en/index.php/Installation_Guide
Follow these instructions if you are not familiar with PhpGedView or installing PHP applications.
- A. Upload Program Files:
To install PhpGedView, unzip the compressed package and upload the files to a directory on your web server. If you have limited space on your server, you can save space in the following ways: 1. Delete the themes from the themes folder that you do not plan to use. 2. Delete some of the language files that you do not want. English files
are named configure_help.en.php, countries.en.php, facts.en.php, help_text.en.php and lang.en.php. French files, for example, are named with ".fr." in place of ".en.". Hebrew files use ".he." in place of ".en.", and so on. The English language files cannot be deleted. They are always loaded before the files for the selected language are loaded. This ensures that all language variables are defined, and that the English version will be used when a given variable is missing in the new language.
3. Do not upload the "places" folder. This folder contains maps for some
countries. It also contains text files containing state, county, and place names. Its purpose is to allow you to enter place names by picking them from lists.
For optimal security, you may want to move the "index" directory to a different location outside of your Internet accessible space. You will specify the location of this directory during the online configuration. See the SECURITY section for more information.
- B. Required File Permissions:
PhpGedView requires that Read permissions be set for all files in the PhpGedView directory tree. Some hosts also require Execute permissions (chmod 755). PhpGedView requires full Write permissions on the index directory (chmod 777 under most hosting configurations). PhpGedView also requires that Write permissions (chmod 777) be set temporarily for the config.php file.
To help with the setting of permissions a file called setpermissions.php has been included with the project. This file will attempt to set 777 permissions to the config.php, ./index, and all of the files inside the ./index directory. Because host settings vary on the ability of PHP programs to set file permissions, you have to run this file manually.
If at any time you have trouble during configuration, check your permissions again.
There are some advanced features that require more Write permissions to be set. If you want to use the language editing features you will need to set Write permissions for all of the files in the ./languages folder (chmod 777). If you want to upload media files using the Upload Media section of the Admin menu then you need to set Write permissions (chmod 777) for your ./media and ./media/thumbs directories. If you want to edit your GEDCOM file online, the GEDCOM file must have Write permissions set to the PHP user (chmod 777).
- C. Configuration:
Next point your web browser to the PhpGedView folder (for example, http://www.yourserver.com/PhpGedView/) to automatically begin the online configuration process. Information about each of the configuration options can be found online by clicking on the question mark (?) near each label.
PhpGedView has support for importing your GEDCOMs into a PEAR:DB supported database like MySQL or PostgreSQL. Currently, MySQL is the only fully tested database. Using a database requires that an existing user, password, and database already exist.
You may reconfigure PhpGedView at any time by going to PhpGedView/admin.php and logging in as an administrator user and clicking on the "Configuration" link.
If you are having any problems setting up PhpGedView then you should run the sanity_check file. To do this you should type sanity_check.php into your URL (for example, http://www.yourserver.com/PhpGedView/sanity_check.php). If you are not able to view that page then you most likely don't have either the sanity_check file or you do not have PHP installed properly.
- D. Create Admin User
After you click the Save button, you will be asked to create an administrator user and login as this user. Then click on the link labelled "Click here to continue" where you will be taken to the "Manage GEDCOMs" area. In the "Manage GEDCOMs" area you can add GEDCOMs to your site, edit the GEDCOM configuration, edit Privacy settings, and import the GEDCOM into the data store.
- E. Add GEDCOM file
To add GEDCOM files to the system, you can upload your GEDCOM file using the "Upload GEDCOM" option from the Admin menu. All files uploaded using the "Upload GEDCOM" page are saved in your index directory. You can also upload your GEDCOM manually using FTP or any other file upload method. Most hosts limit the size of files that can be uploaded from a web form for security reasons, so you may be forced to use a manual method. You may also upload your GEDCOM in ZIP format, either manually or using the "Upload GEDCOM" option. Make sure to enter the filename of the ZIP file. PhpGedView will automatically unpack the ZIP file and use the GEDCOM file inside it. Be sure to create the ZIP file to contain only one GEDCOM file.
- F. Set GEDCOM Configuration Settings
After uploading your GEDCOM, you will be asked to set the configuration parameters for it. There are too many parameters to list all of their options in this document. Please use the online Help documentation to guide you through the configuration process.
- G. Validate GEDCOM
After you save the GEDCOM configuration PhpGedView will validate your GEDCOM and automatically fix any errors that it can. If any errors found in the GEDCOM require user input, you will be prompted to choose how to proceed. Again use the online Help ? for more information.
- H. Import GEDCOM
You are almost done. This is the final step before you can begin viewing your data. After validating the GEDCOM and fixing any errors, you will need to import the GEDCOM into the data store. During the Import you will see a lot of processing statistics printed on the screen. If the Import completed successfully you will see a blue "Import Complete" message. Everything is now set up and you can begin using PhpGedView with your GEDCOM.
- I. Deleting GEDCOMs
You may delete GEDCOMs from your site from the "Manage GEDCOMs" area. Deleting a GEDCOM from the site will remove it from the database but will not delete the original GEDCOM file that you imported. It will also not delete any of the cache or privacy files related to this GEDCOM. These retained files, which are no longer required by PhpGedView, are all located in the "index" directory.
- J. Reset config.php Permissions
For security you should set the permissions of config.php back to Read-only (chmod 755) when you have finished configuring for the first time. Write permissions will only need to be set for config.php when you use the Admin->Configuration link. Everything else will be stored in the index directory.
- K. Custom Themes
You can customize the look and feel of PhpGedView by modifying one of the provided themes. See the THEMES section of this readme file for more information.
- L. HTTP Compression
Pages generated by PhpGedView can be large and use up a lot of bandwidth. Compression of the data between the server and browser using GZip compression can compress the bandwidth by up to 90% (usually 80% - 90% for PhpGedView that were tested). Add the following 2 lines to your php.ini file:
zlib.output_compression On zlib.output_compression_level 5
If you have no access to the php.ini file and you are using Apache, create a blank file named .htaccess (including the dot) and add the following lines to that file (or add them to an existing .htaccess file and upload the file to your PhpGedView directory.
php_flag zlib.output_compression On php_value zlib.output_compression_level 5
Some hosts do not allow adding this through .htaccess files, but they may allow you to create a partial php.ini file in your phpGedView directory. To this file you would add the same two lines from the php.ini file above:
zlib.output_compression On zlib.output_compression_level 5
Note: If your host is using mod_gzip or an other compression method, using this technique can cause problems. Compression will have no effect on browsers that do not support it. You can test the compression at http://leknor.com/code/gziped.php
If you need help or support visit http://www.PhpGedView.net/support.php
UPGRADING
UPGRADING 4.1 to 4.1.x
1. To upgrade from 4.1 to 4.1.1 or any other 4.1.x version, simply replace
the files on the server with the new files.
2. Some of the internal structures have changed, so you should also delete
your cache files. This can be done from the "Customize Welcome Page" link or by manually deleting the files from the "index" directory.
UPGRADING 4.0.x to 4.1.x
Use the following steps to upgrade to v4.1. These steps assume that you are familiar with PhpGedView and have successfully installed it before.
Version 4.x no longer includes support for index files. If you do not have PHP 5 with built-in SQLite support or a database account then you should not upgrade to PhpGedView 4.x. Maintenance releases will continue for the 3.3.x version.
- Note to SQLite users: Unfortunately SQLite does not support the ALTER TABLE
SQL command. This means that we must first drop the tables and recrate them. It is highly reccomended that you run the backup before upgrading.
1. Upload the new 4.1 files to your server replacing the old files with the new files. Do not replace the config.php file or the index directory. 2. In order to create the data required for the new version, you will
have to re-import your GEDCOM. Please see the section on UPDATING GEDCOMS below.
3. You can now use your upgraded site. 4. If you are using a customized theme you will need to update your theme
with new stylesheets and variables. An excellent tool that can help you to merge themes is the WinMerge project http://winmerge.sourceforge.net/
UPDATING GEDCOMS
When you change your genealogy data outside of PhpGedView, it is not necessary to delete your GEDCOMs from PhpGedView and start over. Follow these steps to update a GEDCOM that has already been imported:
1. The first step is to replace your old GEDCOM on the site with your new
GEDCOM. You can do this using FTP, or by going to the "Upload GEDCOM" page and uploading a new GEDCOM with the same filename as the old one. Please remember that file names are case sensitive.
2. Re-import the GEDCOM file by going to
Admin->Manage GEDCOMs->Import GEDCOM. The GEDCOM will be validated again before importing.
3. The Import script will detect that the GEDCOM has already been imported
and will ask if you want to replace the old data. Click the "Yes" button.
4. You will again see the Import statistics and the Import Complete
message at the bottom of the page when the Import is complete.
If you use a ZIP file to upload the GEDCOM, the only way to do it is by either using the "Upload GEDCOM" option, or the "Add GEDCOM" option. The GEDCOM file in the zipped file has to have exactly the same name as the already existing GEDCOM. This way existing GEDCOM settings will be preserved.
THEMES
PhpGedView uses a theme based architecture allowing you to have greater flexibility over the appearance of the site. The "themes" directory contains the standard themes that come packaged with PhpGedView. You may customize any of these themes to your liking or create your own theme by copying any of the standard themes to a new folder and modifying it. When you configure PhpGedView, you should tell it to look in your new theme directory.
A theme directory must contain at least the following 6 files:
footer.html # PHP/HTML for the bottom of every page header.html # PHP/HTML for the top of every page print_footer.html # PHP/HTML for the bottom of every print preview page print_header.html # PHP/HTML for the top of every print preview page style.css # A CSS stylesheet containing all styles sublinks.html # PHP/HTML to print the links to other places theme.php # The PHP design variables that you may customize toplinks.html # PHP/HTML that appears just below the header.html
For a guide to building your own custom PhpGedView theme, go to: http://www.PhpGedView.net/styleguide.php
If you really like a theme that you have done and would like it included with the project, you should send your theme files to the developers at yalnifj@users.sourceforge.net.
MULTIMEDIA OBJECTS
The GEDCOM 5.5 standard supports multimedia files of all types. Currently PhpGedView supports multimedia objects only as external files. Multimedia embedded in the GEDCOM file itself will be ignored. To use the multimedia support in PhpGedView you must copy the multimedia files external to your GEDCOM to the "media" directory in the folder where you installed PhpGedView.
In choosing which picture to show on charts, PhpGedView will choose the first one with the _PRIM Y marker. If there are no _PRIM tags in your media object records then the first object found will be used. You can disable all photos on charts for a particular person by setting _PRIM N on all media objects. Most genealogy programs will do this for you automatically.
You can find all of the images referenced in your file by opening your GEDCOM in a text editor and looking for the OBJE or FILE tags.
PhpGedView includes a "media/thumbs" directory where you can place thumbnails of your media files for display in lists and on other pages. PhpGedView allows you to create your own thumbnails so that you can maintain artistic control over your media and to avoid the installation of other server side software. Make a copy your images and reduce them to an appropriate thumbnail size somewhere around 100px width and upload them to the "media/thumbs" directory. Keep the filename the same as the original. Thumbnails can be created for non-image media files as well. To do this create a thumbnail image in either gif, jpeg, png or bmp formats and name them the same name as the media file including the file extension (even if the media is a non image such as a PDF or an AVI file, name the thumbnail IMAGE with the PDF or AVI file extension).
There is an Image module that fully integrates with PGV and that will automatically create thumbnails for you if you use it to upload your files. It is not included with the main PhpGedView files because it requires external libraries that not all hosts will have installed. You should be able to get it to work by following the instructions included with it. You can download the ImageModule from: http://sourceforge.net/project/showfiles.php?group_id=55456&package_id=88140
You can configure PhpGedView to recognize subdirectories in your media folder. The subdirectories must be the same names as the subdirectories in your media file paths pointed to in your GEDCOM file. For example, if you have the following media references in your GEDCOM file:
C:\Pictures\Genealogy\photo.jpg C:\Pictures\Scans\scan1.jpg scan2.jpg
With the media depth set to 1 you need to set up your directory structure like this:
media/Genealogy/photo.jpg media/Scans/scan1.jpg media/scan2.jpg media/thumbs/Genealogy/photo.jpg media/thumbs/Scans/scan1.jpg media/thumbs/scan2.jpg
With the media depth set to 2 you need to set up your directory structure like this:
media/Pictures/Genealogy/photo.jpg media/Pictures/Scans/scan1.jpg media/scan2.jpg media/thumbs/Pictures/Genealogy/photo.jpg media/thumbs/Pictures/Scans/scan1.jpg media/thumbs/scan2.jpg
RSS FEED
PGV now includes an RSS feed. RSS is an XML format that allows other sites to get news and other data from your site. The language used is the default language of the site. The language of the feed can be set to any language supported by PGV by changing the URL that your RSS aggregator uses from the default /phpGedView/rss.php to /phpGedView/rss.php?lang=english (or any language supported by PGV such as rss.php?lang=french).
Currently only the default site GEDCOM is supported for the feed info. Other options available in the RSS feed are the ability to specify the feed type via the rssStyle parameter. The PGV default is "RSS1.0". Passing any supported type including "PIE0.1", "mbox","RSS0.91", "RSS1.0", "RSS2.0", "OPML", "ATOM0.3", "HTML", "JS" will change the feed type.
For example, calling /phpGedView/rss.php?rssStyle=HTML will create HTML output suitable for inclusion in an other page via an iFrame. The JS option will output JavaScript that can be included in an other page without using an iFrame.
You can also specify a module that you want to output (only 1) so that only that module will be output. This is done via the module parameter. For example, /phpGedView/rss.php?module=gedcomStats will only output the GEDCOM Stats block.
These parameters can be chained so that /phpGedView/rss.php?lang=hebrew&module=gedcomStats&rssStyle=HTML will output the GEDCOM Stats module in Hebrew in HTML.
DATABASE TABLE LAYOUT
PhpGedView uses a very simple database table layout because it operates primarily on the GEDCOM data and only needs the database for search and retrieval. There are only a few tables in the database:
pgv_blocks # Description of each user's Portal page
pgv_dates # Stores decoded date information from GEDCOM records
pgv_families # All the families in the GEDCOM
pgv_favorites # Stores users favorites
pgv_individuals # All the individuals in the GEDCOM
pgv_messages # Messages to and from users
pgv_names # Stores decoded name information from GEDCOM records
pgv_news # Stores news items for the Index and Portal pages
pgv_other # All other level 0 GEDCOM records (i.e., repositories,
# media objects, notes, etc.)
pgv_placelinks # Cross-reference between places and individuals and
# families
pgv_places # Place hierarchy
pgv_sources # All the sources in the GEDCOM
pgv_users # Table for user data (only exists if using default
# mysql authentication module)
The tables are all very similar. They each have a field for the GEDCOM ID,
a field to tell which GEDCOM file the record was imported from, a few
fields for things like quick retrieval of name information, and a field for
the raw GEDCOM record data.
Following is a more detailed description of each table:
pgv_individuals:
i_id VARCHAR(255) # GEDCOM individual ID
i_file INT # ID number of the GEDCOM file the record is from
i_rin VARCHAR(30) # Individual's RIN number
i_name VARCHAR(255) # Person's primary name taken from the first
# 1 NAME line stored in GEDCOM name format
i_isdead int(1) # Alive/dead status of individual
# -1 = not calculated yet 0 = alive 1 = dead
i_GEDCOM TEXT # Raw GEDCOM record for this individual
i_letter VARCHAR(5) # First letter of the individual's surname
i_surname VARCHAR(100) # Person's surname
pgv_families: f_id VARCHAR(255) # GEDCOM family ID f_file INT # ID number of the GEDCOM file the record is from f_husb VARCHAR(255) # ID of the husband f_wife VARCHAR(255) # ID of the wife f_chil TEXT # List of children IDs, semi-colon (;) delimited f_GEDCOM TEXT # Raw GEDCOM record for this family f_numchil INT # Number of children in this family
pgv_sources: s_id VARCHAR(255) # GEDCOM source ID s_file INT # ID number of the GEDCOM file the record is from s_name VARCHAR(255) # Abbreviated title of the source s_GEDCOM TEXT # Raw GEDCOM record for this source
pgv_other:
o_id VARCHAR(255) # GEDCOM record ID
o_file INT # ID number of the GEDCOM file the record is from
o_type VARCHAR(20) # Type of GEDCOM record
# (REPO, ADDR, NOTE, OBJE, etc)
o_GEDCOM TEXT # Raw GEDCOM record for this item
pgv_names:
n_gid VARCHAR(255) # Individual ID that this name corresponds to
n_file INT # ID number of the GEDCOM file the record is from
n_name VARCHAR(255) # Name in GEDCOM format,
# with / / around the surname
n_letter VARCHAR(5) # First letter of the surname
n_surname VARCHAR(100) # Surname for this name record
n_type VARCHAR(10) # Type of name,
# P = primary, A = additional, C=calculated
pgv_dates:
d_day # The day of month for this date
d_month # The 3 letter abbreviation for month of year
d_mon # Integer 1-12 for the month of year
d_year # The year for this date
d_datestamp # This column is no longer used and will be deleted in 4.2
d_fact # The fact that this date was associated with
d_gid # The gedcom XREF ID where this fact and date were found
d_file # The gedcom file id where this fact was found
d_type # Used if this date uses an alternate calendar type
d_julianday1 # The julian day number for this day (or start of this month/year) d_julianday2 # The julian day number for this day (or end of this month/year)
pgv_blocks:
b_id INT(11) # Record ID
b_username # User name whom block belongs to
VARCHAR(100)#
b_location VARCHAR(30) # Location of the block.
# Main column or right column
b_order INT(11) # Position of the block within the column
b_name VARCHAR(255) # Name of the block
b_config TEXT # Configuration settings for this block
pgv_favorites:
fv_id INT(11) # Record ID
fv_username # User name whom the favorite belongs to
VARCHAR(30) #
fv_gid VARCHAR(10) # ID of the favorite
fv_type VARCHAR(10) # Type of favorite (currently only INDI)
fv_file VARCHAR(100) # File that this favorite belongs to
fv_url VARCHAR(255) # The URL for this favorite if it is not one of
# the basic types
fv_title VARCHAR(255) # A title for URL based favorites
fv_note TEXT # Optional descriptive information about this favorite
pgv_messages:
m_id INT(11) # Record ID
m_from VARCHAR(255) # Name or email address of the sender
m_to VARCHAR(30) # Destination user name
m_subject VARCHAR(255) # Subject of the message
m_body TEXT # Body text of the message
m_created VARCHAR(255) # Time stamp when the message was created
pgv_news:
n_id INT(11) # Unique identifier
n_username VARCHAR(100)# User name or GEDCOM the News item belongs to
n_date INT(11) # Time stamp of last update
n_title VARCHAR(255) # Title of the article
n_text TEXT # Body text of the article
pgv_places:
p_id INT(11) # Unique identifier
p_place VARCHAR(150) # Place name
p_level INT(11) # Level of the place in the hierarchy,
# 0 is the country or state
p_parent_id INT(11) # ID of this item's parent place in the
# hierarchy. A city's parent would be the
# county it is in, a county's parent would be
# a state or province, and a state or province
# would have a country as parent.
p_file INT # ID number of the GEDCOM file the record is from
p_std_soundex # Standard soundex code for searching by place.
VARCHAR(255) #
p_dm_soundex # Daitch-Mokotoff soundex code for searching by
VARCHAR(255) # place.
pgv_placelinks:
pl_p_id INT(11) # Unique identifier
pl_gid VARCHAR(30) # Family or individual ID referencing this place
pl_file INT # ID number of the GEDCOM file the record is from
pgv_soundex:
sx_i_id VARCHAR(255) # Unique identifier (Individuals table)
sx_n_id VARCHAR(255) # Unique identifier (Names table)
sx_file INT # Unique identifier (GEDCOM file)
sx_fn_std_soundex # Standard first name soundex code. Used for
VARCHAR(255) # soundex searching.
sx_fn_dm_soundex # Soundex code for international first names.
VARCHAR(255) # This uses the Daitch-Mokotoff soundex method,
# which is better suited for them.
sx_ln_std_soundex # Standard last name soundex code. Used for
VARCHAR(255) # soundex searching.
sx_ln_dm_soundex # Soundex code for international last names. This
VARCHAR(255) # uses the Daitch-Mokotoff soundex method, which
# is better suited for them.
pgv_users:
u_username VARCHAR(30) # User name
u_password VARCHAR(255) # Encrypted password
u_fullname VARCHAR(255) # User's full name
u_GEDCOMid TEXT # Serialized array representing the GEDCOM IDs
# for this user
u_rootid TEXT # Serialized array representing the root IDs
# for this user
u_canadmin ENUM('Y','N') # Is the user an admin or not
u_canedit TEXT # Serialized array indicating the editing
# privileges a user has for each GEDCOM
u_email TEXT # Email addres
u_verified VARCHAR(20) # User self verified
u_verified_by_admin VARCHAR(20) # User has been verified by the admin
u_language VARCHAR(50) # User's preferred language
u_pwrequested VARCHAR(20) # User requested a new password
u_reg_timestamp VARCHAR(50) # Registration timestamp
u_reg_hashcode VARCHAR(255) # Self-registration hash key
u_theme VARCHAR(50) # User's preferred theme
u_loggedin ENUM('Y','N') # User's login status
u_sessiontime INT(14) # User's last login time stamp
u_contactmethod VARCHAR(20) # User's preferred method of contact
u_visibleonline ENUM('Y','N') # Whether or not the user is visible in
# the logged on users block
u_editaccount ENUM('Y', 'N') # Whether or not the user can edit his
# own account information
u_defaulttab INT(10) # Default tab on the individual page
# for this user
u_comment VARCHAR(255) # Admin's comments on this user
u_comment_exp VARCHAR(20) # Alert date for the admin, for instance
# for temporary accounts.
u_sync_gedcom VARCHAR(2) # If the user has a GEDCOM record ID, then
# should some of the data for the user (name,
# email) be synchronized with the GEDCOM data.
u_relationship_privacy VARCHAR(2) # Should this user use relationship privacy
u_max_relation_length INT # The maximum path that the user is allowed to see
u_auto_accept VARCHAR(2) # Are changes made by this user automatically
# accepted into the database
This table layout has received criticism from some for its simplicity, size, and because it does not follow a genealogy model like GENTECH. We admit that these tables can be hard to interface to because the code has to understand GEDCOM in order to get information out of them. We also admit that storing the raw GEDCOM data could make the tables very large.
Fortunately the GEDCOM standard is not a very complex or large format; it only requires 6 characters per line, which is very good compared to something like XML. However, there are some very compelling reasons why this table structure was chosen: 1. Simpler tables mean fewer and simpler database queries. This takes a
large load off the database and makes the program run faster.
2. Nothing is lost in the Import. Even though GEDCOM is a standard, each
genealogy program interprets the standard a bit differently and adds its own tags. Creating a database model that conforms to all the GEDCOM outputs of different genealogy software programs would be very difficult.
MANUAL CONFIGURATION
Advanced users who understand PHP may want to configure manually by editing the configuration file config.php When you have finished editing config.php make sure that the variable $CONFIGURED=true; so that the program does not try to forward you to the configuration.php script when you launch it for the first time.
You can manually add GEDCOMS to the system by adding them to the $GEDCOMS array in the index/GEDCOMs.php file. The GEDCOM array looks like this:
$gedarray = array(); $gedarray["GEDCOM"] = "surname.ged"; $gedarray["config"] = "./index/surname.ged_conf.php"; $gedarray["privacy"] = "./index/surname.ged_priv.php"; $gedarray["title"] = "Surname Genealogy"; $gedarray["path"] = "./surname.ged"; $GEDCOMS["surname.ged"] = $gedarray;
"surname" above could be anything, for example, "johnson" or "private". You must pay attention to the case of what you enter. PhpGedView is case sensitive.
Each GEDCOM will need a configuration file. You can copy the config_GEDCOM.php file which has all of the default values for each GEDCOM you add manually. Then set the "config" item of the GEDCOMS array to point to the file you copied.
Each GEDCOM also needs a Privacy file. Make a copy the privacy.php file for each GEDCOM and set the "privacy" item of the GEDCOMS array to the location of the new privacy.php file.
SECURITY
Even though PhpGedView gives you the ability to hide the details of living individuals, whenever you post the personal details of living individuals on the Internet, you should first obtain the permission of EACH living person you plan to include. There are many people who would not even want their name linked with their family history made public on the Internet and their wishes should be respected and honored. Most family history programs allow you to choose the people who are exported when you create your GEDCOM file. The most secure option is to deselect all living people in your genealogy program when you export your genealogical data to a GEDCOM file.
If you wish to protect your GEDCOM file itself from being downloaded over the Internet you should place it outside the root directory of your web server or virtual host and set the value of the $GEDCOM variable to point to that location. For example, if your home directory is something like "/home/username" and if the root directory for your web site is "/home/username/public_html" and you have installed PhpGedView in the "public_html/PhpGedView" directory then you would place your GEDCOM file in your home directory at the same level as your "public_html" directory. You would then set the file path to "/home/username/GEDCOM.ged" by editing the GEDCOM configuration.
You can also manually set the location by changing the "path" line in index/GEDCOMs.php:
$gedarray["path"] = "../../GEDCOM.ged";
or
$gedarray["path"] = "/home/username/GEDCOM.ged";
Since your GEDCOM file resides in a directory outside of your web server's root directory, your web server will not be able to fullfill requests to download it. However, PhpGedView will still be able to read and display its contents.
In the end it is YOUR responsibility to guarantee that there has been no violation of an individual's privacy and YOU could be held liable should private information be made public on the web sites that you administer.
For more privacy options visit: http://www.PhpGedView.net/privacy.php
LANGUAGES
PhpGedView has built-in support for multiple languages. PHP does not support unicode (UTF-16). It does support UTF-8 and that is the recommended character encoding for GEDCOMs with PhpGedView. If you have characters in your GEDCOM outside the standard ASCII alphabet, you should probably use the UTF-8 encoding. There are many differences between UTF-8 and UTF-16, but anything that you can encode in UTF-16 you should be able to encode in UTF-8. It is also quite easy to convert from Unicode to UTF-8. Simply open your Unicode GEDCOM file in Windows Notepad and select "File->Save As.." from the menu and choose UTF-8 as the encoding option. You shouldn't lose any of the characters in the translation.
You should check the Patches section of http://sourceforge.net/projects/PhpGedView to get the latest language files.
Discussion and questions about the multiple language features of PhpGedView including translations, should be posted in the Translations forum available from the PhpGedView project page here: http://sourceforge.net/forum/forum.php?forum_id=294245
To translate PhpGedView into another language that is not currently supported you must first login to PhpGedView as an administrator and go to the Language Edit Utility by clicking on "Admin-> Translator Tools". At the bottom of that page is an option to Add a new language. Choose your l anguage from the dropdown list and click on the "Add new Language" button. A popup window will appear that allows you to edit the default settings for your language. Each of the settings has online help available by clicking on the "?". You might want to look at the settings for some of the other languages on the edit language page to see how they are set up. When you have finished editing the settings, click the Save button. This will create a new lang_settings.php file in the index directory. You will notice that your language now appears in the supported languages list.
Next create a copy of the "configure_help.en.php", "facts.en.php", "help_text.en.php", and "lang.en.php" files located in the "./languages/" and change the "en" part to match the two letter language code of your language.
The "facts" file contains all of the translations for the various GEDCOM tags such as BIRT = Birth. The "lang" file contains all of the language variables used throughout the site. The "configure_help.en.php" and "help_text.en.php" provide configuration and help instructions.
You can translate these files using the online Language File Edit utility. Just select your language from the drop-down list and then select the file you want to edit and click the Edit button. Your file will be compared to the English language file so that you can easily translate the files online.
You can also translate these files manually by opening them in any text editor. If you manually edit the files, you must be sure to save them in the UTF-8 character set. Some text editors like Windows Notepad add a 3-byte Byte-Order-Mark (BOM) to files they save in UTF-8. PHP does not like the BOM and it should be removed before testing the files in PhpGedView. PhpGedView's Translator Tools section has a utility program for removing these BOMs.
You should obtain a flag file from http://w3f.com/gifs/index.html and size it to match the other flags in the images/flags directory.
To help maintain languages, a language change log is provided in the languages directory. This change log is named LANG_CHANGELOG.txt. All changes to the English language files are recorded here.
If you make a new translation of PhpGedView or update another translation, and would like to contribute it to the community please post your language files and your index/lang_settings.php file to the Patches section of the SourceForge project site at http://www.sourceforge.net/projects/phpgedview
NON-STANDARD GEDCOM CODES
The GEDCOM 5.5 standard has a defined set of codes. You can read the specification online at http://www.PhpGedView.net/ged551-5.pdf Part of the standard allows for genealogy software to define their own codes, and requests that they begin with an "_" underscore.
When PhpGedView comes across a tag that is not defined it will display an error message. You can disable these error messages by setting $HIDE_GEDCOM_ERRORS=true; in the gedcom configuration settings. PhpGedView can also be customized to work with these codes by adding them to the facts array in a new language file named extra.en.php. If you add it to the English facts file you should also add it to the other facts language files you are using on your site if you want other languages to translate the tag correctly.
The format of the facts file is a PHP associative array. Each tag requires one line in the array. The following line defines the label "Abbreviation" for the ABBR GEDCOM tag.
$factarray["ABBR"] = "Abbreviation";
As an example, if you use a genealogy program that generates the tag "_ZZZZ" you can customize PhpGedView to accept this code by adding the following lines to the extra.en.php file:
<?php $factarray["_ZZZZ"] = "Tag Label goes here"; ?>
LANGUAGE EXTENSION FILES
Language extension files are custom PHP files that you can use to make your own language specific extensions to PhpGedView. To add a language file extension, create a new PHP file called extra.xx.php replacing the "xx" with the code for the language you want to extend. These files are not automatically included with the package so that when you upgrade, your extensions are not overwritten.
If this file exists for the language that is chosen, it is the very last thing that is loaded before the display starts. These files were designed to be language file extensions, but you could easily use them to make settings changes based on the chosen language.
What sort of things can you do with language extensions?
- Customize any of the text that appears on the site, - Change configuration options based on language, - Change to a different GEDCOM when someone views your site in a different language.
The only settings that you should not override in this file are the Privacy settings.
If, for example, you wanted to change the GEDCOM title when you changed the language, you could change the title for each language by adding the following line to your extra.xx.php: global $GEDCOMS;
$GEDCOMS["surname.ged"]["title"] = "Title in Chinese";
In this file you could also change the text on the buttons:
$pgv_lang["view"]="Show";
With this file you could also change the GEDCOM that is displayed when the language is selected. Suppose you had a GEDCOM that was in German and one that was in English. In the extra.de.php file you could add the following lines: global $GEDCOM;
if ($GEDCOM=="english.ged") {
header("Location: $SCRIPT_NAME?$QUERY_STRING&ged=german.ged");
exit;
}
These lines say that if we are using the German language files, but are using the English GEDCOM, then we need to reload the page with the German GEDCOM. You need to reload the page so that the configuration settings for the GEDCOM get loaded. This assumes that you have both "english.ged" and "german.ged" imported into the database and that the english.ged and the german.ged have the same people in them, just in a different language. Thus I0001 in english.ged should refer to the same I0001 in german.ged.
MIGRATING FROM DATABASE TO INDEX MODE AND VICE VERSA
Older of versions of PhpGedView supported and internal "index" mode format which allowed it to run without a database. Since version 4.0, index mode has no longer been supported. If you are running an older version of PGV in index mode then these instructions can help you to upgrade to a new version of PGV which only supports databases.
Basically it's possible to switch a PhpGedView installation from Index to DATABASE mode or vice-versa without losing any settings. The following steps have to be made:
DATABASE to Index
1. Make sure you have all rights in the ./index/ folder on your web site
and on the file ./config.php
2. Copy the file config.php to configsql.php (or any other name) to
backup the old configuration. You may also use the Backup function
from the Admin menu to backup all vital files before switching mode.
3. DO NOT remove any files from your index directory, as some of them
(Privacy and GEDCOM settings) will also be used in Index mode.
4. In DATABASE mode, log in to PhpGedView with Admin rights.
5. Go to the Administration page and select the User Information
Migration tool.
6. Choose the Export function.
7. User Migrate will try to create the following files:
- authenticate.php - user accounts and settings
- favorites.dat - user and GEDCOM favorites
- blocks.dat - block layout of Welcome and MyGedView pages
- news.dat - User and GEDCOM news
- messages.dat - User messages
If any of the files already exist in your index directory, you will be
prompted to overwrite them. If there are problems creating the files,
when, for instance, you don't have sufficient rights, you can always
correct the problem and run the Export function again, as nothing
irreversible has happened.
8. Check that the above files exist in your index directory.
9. Go to Admin, Configuration, change mode to Index and save the
configuration.
10. As all Index mode related files are already present, you should be
able to use your web site in Index mode immediately.
10. Import your GEDCOM files again to build the Index database. You don't
need to change any GEDCOM settings, as they still exist in the index
directory and will be used again.
11. Test all settings and functions thoroughly before you remove your SQL
database from your web site.
Index to DATABASE
1. Make sure you have all rights in the ./index/ folder on your web site
and on the file ./config.php
2. Copy the file config.php to configindex.php (or any other name) to
backup the old configuration. You can also use the Backup function
from the Admin menu to backup all vital files before switching mode.
3. DO NOT remove any files from your index directory, as all of them
(Privacy and GEDCOM settings) will also be used in DATABASE mode, or
will be used to migrate the information to DATABASE mode.
4. Connect to your SQL DBMS with your regular administration tool, and
define a database, without any tables.
5. Create a user in your SQL-DBMS with the following rights on the
database:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER.
6. In PhpGedView, go to Admin, Configuration, and change mode to
DATABASE, fill in the appropriate SQL-DBMS and database name, user and
user password and save the configuration.
7. PhpGedView will ask you to create an admin user. Create one. This
user will be overwritten later with the migrated information.
8. From the admin menu, choose the User Information Migration tool, then
choose Import.
9. PhpGedview will now import all settings from Index mode to DATABASE
mode.
10. Go to Admin, Manage GEDCOMs and Edit Privacy, and then import all your
GEDCOM files again. There is no need to change GEDCOM settings and
Privacy settings, as all settings made in Index mode will be used.
11. Test all settings and functions thoroughly before you remove Index
related files (.\index\*.dat and .\index\authenticate.php) from your
web site.
POSTNUKE AND PHPNUKE INTEGRATION
PhpGedView can integrate with PostNuke and phpNuke so that your users do not have to login twice.
After you have PhpGedView up and running, you should follow the instructions in the readme.txt file in the pgvnuke folder.
The files that make the integration magic happen were donated by Jim Carey.
===============================================
BACKUP
With the Backup function in the administration menu, you can make a simple backup of all important PhpGedview files. With this backup, it's possible to rebuild your PhpGedView site to the situation at backup time.
The backup can contain the following files, as selected on the Backup page:
- config.php with all configuration settings of your installation - all GEDCOM files that were present in your installation - all GEDCOM options and privacy settings for the above files - counters, PhpGedView- and search-logfiles - user definitions and options (block definitions, favorites, messages and news)
The files will be gathered into a ZIP file, which can be downloaded by clicking the link on the page.
Note: The database itself will not be included in the backup, since it can be rebuilt using the files in the backup.
Note: All pending changes (not approved or rejected yet by the administrator) will be present in the GEDCOM files but can no longer be identified as changes. If the database is rebuilt using the GEDCOMs, these changes therefore can no longer be rejected.
The Backup function uses the PclZip library, which is written by Vincent Blavet and can be found at http://www.phpconcept.net/pclzip.
