PGV to webtrees migration tool

Registered by fisharebest

We need a utility to import PGV configuration settings, etc. into webtrees

Blueprint information

Status:
Complete
Approver:
webtrees team
Priority:
High
Drafter:
None
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
None
Started by
kiwi
Completed by
kiwi

Related branches

Sprints

Whiteboard

In order to keep the process simple, I propose the following procedure.

1 upgrade to latest release/svn version of pgv
2 accept pending edits and export gedcoms (similar to preparing for an upgrade).
3 install webtrees
4 run new import-pgv.php script, which copies the following data - each of these probably needs expanding.

pgv_users => wt_users
pgv_gedcoms => wt_gedcoms
pgv_user_settings => wt_user_settings
pgv_gedcom_settings => wt_gedcom_settings
pgv_user_gedcom_settings => wt_user_gedcom_settings
pgv_hit_counter => wt_hit_counter
pgv_messages => wt_messages
pgv_news => wt_news
pgv_blocks => wt_blocks
pgv_ip_address => wt_ip_address
pgv_placelocation => wt_placelocation (only if googlemap module installed?)
config.php => wt_site_settings table
index/XX_conf.php => data/XX_conf.php
index/XX_priv.php => data/XX.priv.php
index/XX.ged => wt_gedcoms.import_gedcom
media/XX (copy/move?)

import-pgv.php then redirects to editgedcoms.php which imports each of the gedcoms, populating the remaining genealogy tables.

[ToyGuy-Stephen]
For media, would it be necessary to first configure the gedcom with media firewall disabled, so that all media is contained within the webspace and then transferred to the new webtrees setup? After import, the admin could be reminded to reconfigure media firewall to active.

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.