tAddLocationFromIP

Schema and Edit schema

• A schema is a row description, it defines the fields to be processed and passed on to the next component. The schema of this component is read-only.

• Built-in: You create and store the schema locally for this component only. For more information about a component schema in its Basic settings tab, see Basic settings tab.

• Repository: Select the Repository file where Properties are stored. When selected, the fields that follow are pre-defined using fetched data.

Database Filepath

The path to the IP address lookup database file.

Input parameters

• Input column: Select the input column from which the input values are to be taken.

• input value is a hostname: Check if the input column holds hostnames.

• input value is an IP address: Check if the input column holds IP addresses.

Location type

• Country code: Check to replace IP with country code.

• Country name: Check to replace IP with country name.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables

NB_LINE: the number of rows processed. This is an After variable and it returns an integer.

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage rule

This component is an intermediary step in the data flow allowing to replace IP with geolocation information. It can not be a start component as it requires an input flow. It also requires an output component.

Limitation

Due to license incompatibility, one or more JARs required to use this component are not provided. You can install the missing JARs for this particular component by clicking the Install button on the Component tab view. You can also find out and add all missing JARs easily on the Modules tab in the Integration perspective of Talend Studio. For details, see Installing external modules.

• geoip.jar