Uploaded image for project: 'Liferay Apps'
  1. Liferay Apps
  2. LRA-152

Add GeoIP features to Tout app

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Component/s: Tout
    • Labels:
      None

      Description

      We want to use Maxmind GeoLite2 CSV DBs to know from which country the visitor is. We need an admin page were the user can upload these DBs. We can have 2 different uploads, one for the Locations CSV and another for the Blocks CSV file. Each time a CSV file is uploaded a DB table will be populated with the info in the CSV file. We don't need all the fields in the Maxmind CSV files.

      Of the Locations CSV file we just need these fields:
      + geoname_id: generate a DB field of it.
      + country_iso_code: generate a DB field of it (this is 2 chars ISO 3166-1 value)

      Of the Blocks CSV file just need to create these fields:
      + start_ip: long field, we will create it once we know the network range initial ip.
      + end_ip: long file, we will create it once we know the network range final ip.
      + geoname_id: generate a DB field of it.

      Contact Manuel if you need help generating this field from Maxmind CSV files. Specially how to convert Blocks records into a network range, and IP string values into a long field.

      Basically we need to generate a service that will make use of this tables. This service will be provided an IP and will return the country ISO code associated to it.

      We want to modify the Tout app, so you can define which content to show based on visitor's country.

      First take a look at this app, and see how they are doing it there:
      https://www.liferay.com/marketplace/-/mp/application/15197657

        Attachments

          Activity

            People

            • Assignee:
              mcalvo mcalvo
              Reporter:
              mcalvo mcalvo
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support