+

Search Tips   |   Advanced Search

Supplemental user data for Profiles

We can supplement user profiles data using a mapping table, profiles_tdi.properties, and CSV files.


Mapping user data

We can map additional user data to supplemental tables within the Profiles database, and then display that data in a user's profile.

When the LDAP directory provides a code or abbreviation for a particular setting, the supplemental table can provide extra data. For example, an employeeType of P in the LDAP directory might correspond to Permanent. If the employee-type table is populated with data such as p;permanent, this extra data can be displayed in the profile.

The profiles_tdi.properties file stores the settings that determine how the files are formatted.

These properties are supplied in profiles_tdi.properties. The file path specified is relative to the TDI solution directory.

This step is mandatory if one or more entities have been selected as the Group By filter in Metrics. Otherwise, when we categorize the Metrics report by this entity, the report will show an unknown value, not the descriptive name of the entity in the chart. Metrics have three default Group By attributes: country, organization and title. The country and organization attributes are in the supported list.

The mapping task for Profiles maps the user data to the following entities:


CSV files

A CSV (comma separated value) file is required as input for each of these tasks.

The following properties pertain to the CVS files used by these tasks:

country_table_csv_separator=;
country_table_csv_file=isocc.csv

department_table_csv_separator=;
department_table_csv_file=deptinfo.csv

emp_type_table_csv_separator=;
emp_type_table_csv_file=emptype.csv

organization_table_csv_separator=;
organization_table_csv_file=orginfo.csv

workloc_table_csv_separator=;
workloc_table_csv_file=workloc.csv

The separator character separates the different tokens in each line. The second property is the name of the file, relative to the solution directory.

The first token is the code. The next attributes are read in order for each additional field. No other fields are required.

The data that can be populated in these tables is usually provided as two values per line: code;description. For the workloc code, the values can be code;addr1;addr2;city;state;zip. For example: WSF;FIVE TECHNOLOGY PARK DR;;WESTFORD;MA;01886-3141.

Fields that you do not require in the mapping can be omitted from the file; this example uses only one addr field.

The default file name for each codes is shown in the following list:


Sample CSV file

This sample shows some lines from the isocc.csv file, which can be used to fill countries data:

ad;Andorra, Principality of ae;United Arab Emirates af;Afghanistan, Islamic State of ag;Antigua and Barbuda ai;Anguilla
al;Albania
am;Armenia
an;Netherlands Antilles ao;Angola
aq;Antarctica
ar;Argentina

We can find more sample CSV files in the wizard_files_directory/TDIPopulation/TDISOL/aix|lin|win/samples directory, where the wizard_files_directory is the location of the various Wizard files that you downloaded or received on disk, and aix|lin|win is the AIX , Linux, or Windows version of the directory.


Parent topic:
Populate the Profiles database


Related:

Use the CodesConnector

Related reference:

TDI solution properties for Profiles

The tdisettings.properties file