Country, and city not showing in UI

[neilgd72]

Hi, I've set up geo custom fields of country and city, and have populated them programatically. They show up fine in the list:




But when I click through to a subscriber, they all (every single one has the same details) look like this:



Any ideas?

 

[twisted1919]

I've set up geo custom fields of country and city, and have populated them programatically.

Did you properly setup the maxmind database? Follow the steps at https://www.mailwizz.com/kb/enable-campaign-geolocation-tracking-for-opens/ and download and place the file in the required location.

But when I click through to a subscriber, they all (every single one has the same details) look like this:

These seems to be yours, when another subscriber will visit, their details will show up.

 

[neilgd72]

Ah, I see. Thank you. Can I manually populate the internal geo data (I have tried setting the SUBSCRIBER_GEO_CITY custom field, but that doesn't seem to work)? I have access to the database.

 

[twisted1919]

Unfortunately no, you need to use the maxmind database as suggested above.

 

[neilgd72]

Thank you! Any downside to modifying the ip address in the list_subscriber table and upserting into the ip_location one?

 

[twisted1919]

Any downside to modifying the ip address in the list_subscriber table and upserting into the ip_location one?

None I can think of, except if the data is not correct, but I assume that can be corrected.

 

[neilgd72]

Thank you! I have updated the IP addresses in the list_subscriber table:



And added details in the ip_location table:



And added a geo-data custom field, but it's still being populated with the record from the very first record in the ip_location table:



Any ideas?

Thank you!

 

[neilgd72]

This is also true for customers who are having their locations updated from clicks and the MaxMind database.

 

[twisted1919]

Are you sure the IP address is not a duplicate in that table? If it is, make sure you only keep one single instance.

 

[neilgd72]

100% positive. Maybe I am misunderstanding how the geo location works. Is it enough to add eg a Geo Location City field to the users, and it will then pull it in from the database?

 

[twisted1919]

I took a look in the code and it looks like:

$geoCity = '';
if ($location = IpLocation::findByIp(request()->getUserHostAddress())) {
    $geoCity = $location->city_name;
}

So it will check the IP against the local database, and if it does not find it, will check against maxmind database.

So yes, it is enough to add the field.

 

[neilgd72]

That code looks like it comes from something which picks up where a subscriber is coming from when they eg click on a link? Which does seem to be working.

I think the issue that the correct information isn't being displayed on the subscriber details page, although it *is* displayed on both the summary grid and being populated when campaigns are sent.

Here are the grid items:



(The first 2 fields are text custom fields, and the second two are Geo fields).

And here is the subscriber details screen:

 

[twisted1919]

That code is taken exactly from the public subscribe page for a subscriber. Again, you see this because your IP matches it at the time when you load the page.