Geo report

[AHK]

Hello,
My Geo report is showing as bellow

same country some are in code and some are in full country name.
does any one have like this or I am doing some thing wrong.
in my extension only MaxMind.com is active, all other IP location extensions are not active. and MaxMind.com Sort order is 1.
Thanks

 

[twisted1919]

Most likely you have records in the database, created by other location services, which have these names.
Just remove them from the ip_location table.

 

[AHK]

@twisted1919,
thanks for reply
how to remove these records or is there a way to generate clean ip_location table or sql statement.
if I truncate ip_location table, this will solve this ?

 

[twisted1919]

if I truncate ip_location table, this will solve this ?

Nope, that's not a good option. You could create a script to read all those records and update them with proper info based on maxmind.
Look at the /apps/console/commands/UpdateIpLocationForCampaignOpensCommand.php file to get an idea.