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?