If you need to upgrade your PGV installation, then hopefully you will also consider that you can conveniently move to webtrees with our PGV-to-webtrees wizard. It will move ALL your users, news, favorites and family trees to webtrees in a matter of minutes.

TOPIC: Problem importing place locations from PGV

Problem importing place locations from PGV 3 years 3 weeks ago #1

  • james-l
  • james-l's Avatar
Hello all,

I've been trying to get the Google Maps module working with webtrees.

I tried copying the placelocation table from pgv_placelocaiton to wt_placelocaiton, and it seems to work - I can see all the places when browsing the table, and when I run 'Place Check' on the Google Maps module it lists the places found correctly.

However, when I click on the Google Maps tab for an individual, webtrees hangs loading the page and nothing is displayed.

One point that is strange is that when I click on "Geographic Data" in the Google Maps module, nothing is displayed. Is this normal?

Any ideas what I'm doing wrong?
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
> I tried copying the placelocation table from pgv_placelocaiton to wt_placelocaiton

Why? The PGV->webtrees import wizard would have done that for you.

The two table structures are similar, but not the same.

> nothing is displayed

"nothing displayed" often indicates that a fatal error occurred - and that your server is configured to write errors to a log file, rather than display them on screen. Your webserver error logs probably contain a helpful message.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #3

  • james-l
  • james-l's Avatar
fisharebest wrote:
> I tried copying the placelocation table from pgv_placelocaiton to wt_placelocaiton

Why? The PGV->webtrees import wizard would have done that for you.

The two table structures are similar, but not the same.

> nothing is displayed

"nothing displayed" often indicates that a fatal error occurred - and that your server is configured to write errors to a log file, rather than display them on screen. Your webserver error logs probably contain a helpful message.

I didn't actually use the import wizard, I couldn't get it to work correctly.
I checked the structure of PGV_placelocation and wt_placelocation and I couldn't see any differences.

Unfortunately I can't access the web server error log on my web hosting provider.
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
> However, when I click on the Google Maps tab for an individual, webtrees hangs loading the page and nothing is displayed.

Javascript error log?
Errors embedded in HTML output?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #5

  • james-l
  • james-l's Avatar
fisharebest wrote:
> However, when I click on the Google Maps tab for an individual, webtrees hangs loading the page and nothing is displayed.

Javascript error log?
Errors embedded in HTML output?

I turned on Firebug, and there was an 'internal server error 500' for the following request:
loveluck.net/webtrees/individual.php?pid...jax&module=googlemap

I even emptied the placelocation table, in which case Google Maps should just report that there is no data, but I still got the error return to the Google Maps request.
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
That URL actually gives some partial content (view the source).

So, it is quite clear that an fatal error occurred.

It would be really helpful if you could persuade your web host to let you have access to your error logs.

Without it, the only option is some very tedious trial-and-error debugging - e.g. adding "echo 'got here';" at various points to narrow down the line of code that gives the error...

> I checked the structure of PGV_placelocation and wt_placelocation and I couldn't see any differences.

Well, the only difference between your system and everyone elses would be this change, so I'd double check this.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #7

  • james-l
  • james-l's Avatar
fisharebest wrote:
That URL actually gives some partial content (view the source).

So, it is quite clear that an fatal error occurred.

It would be really helpful if you could persuade your web host to let you have access to your error logs.

Without it, the only option is some very tedious trial-and-error debugging - e.g. adding "echo 'got here';" at various points to narrow down the line of code that gives the error...

> I checked the structure of PGV_placelocation and wt_placelocation and I couldn't see any differences.

Well, the only difference between your system and everyone elses would be this change, so I'd double check this.

I understand now the difference between the placelocation table structure. I copied the table from PGV, and this copies the table structure as well as the contents, which is why the additional fields were missing.

I didn't really explain clearly my motivation for trying to copy the placelocaiton table. I have PGV running on one web host but can't upgrade to webtreees because it doesn't support a recent version of PHP. So I installed webtrees on a different web host, but I wanted to copy the placelocation table from the old host because I didn't want to re-enter all the place locations. There must be a way of copying the data from the PGV table to the webtrees one without modifying the structure.

I'm going to try again with a web server on my local machine, where I can see the log files etc.

Thanks for all the help so far.
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #8

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
> There must be a way of copying the data from the PGV table to the webtrees one without modifying the structure.

I haven't looked at PGV for years, but I'm pretty sure the google-maps module (in both PGV and webtrees) has an "export place location data to .CSV" option and an "import place location data from .CSV" option...
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

Problem importing place locations from PGV 3 years 3 weeks ago #9

  • james-l
  • james-l's Avatar
fisharebest wrote:
> There must be a way of copying the data from the PGV table to the webtrees one without modifying the structure.

I haven't looked at PGV for years, but I'm pretty sure the google-maps module (in both PGV and webtrees) has an "export place location data to .CSV" option and an "import place location data from .CSV" option...

That's correct, and I've exported my PGV place locaitons to a csv file. Now how do I import this to webtrees?
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #10

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
> Now how do I import this to webtrees?

Control panel -> modules -> google maps -> geographic data -> upload geographic data
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #11

  • james-l
  • james-l's Avatar
fisharebest wrote:
> Now how do I import this to webtrees?

Control panel -> modules -> google maps -> geographic data -> upload geographic data

I tried this, and got the following error messages"

#0 /app/Module/GoogleMapsModule.php:4379 ErrorException("Undefined offset: 7")
#1 /app/Module/GoogleMapsModule.php:104 adminPlaces()
#2 /module.php:26 modAction()
The administrator has disabled public write access.

Problem importing place locations from PGV 3 years 3 weeks ago #12

  • james-l
  • james-l's Avatar
I finally did manage to import the Google Maps place locations from the pgv_placelocation table to the wt_placelocation table, using the Export and Import functions og PhpMyAdmin.
The only complications were:
  • The export function from the pgv_placelocation table produces an SQL file with commands like:
    INSERT INTO `pgv_placelocation` (`pl_id`, `pl_parent_id`, `pl_level`, `pl_place`, `pl_long`, `pl_lati`, `pl_zoom`, `pl_icon`) VALUES
    These have to be changed to
    INSERT INTO `wt_placelocation` (`pl_id`, `pl_parent_id`, `pl_level`, `pl_place`, `pl_long`, `pl_lati`, `pl_zoom`, `pl_icon`) VALUES
  • My place location table was very big and the file produced was over the limit for import, so I had to do the operation in two stages
It didn't seem to matter that the webtrees table has additional fields - these were all jsut set to NULL or 0.

Now I'll have to see whether this works on the web hosting service I want to use.
The administrator has disabled public write access.
Moderators: makitso
Powered by Kunena Forum