Supplemental user data for Profiles 

When you map LDAP data to the Profiles database, you can use that data to create additional tables.

Mapping user data

You 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 tables are populated.

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

Fill countries

Add country data to each profile.

Fill departments

Add department data to each profile.

Fill organization

Add organization data to each profile.

Fill employee types

Add employee-type data to each profile.

Fill work locations

Add location data to each profile.

CSV files

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

The following sample shows common properties of a CSV file:

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 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 your mapping can be omitted from the file; the example above uses only one addr field.

The mapping relationship between the CSV files and keys is shown in the following list:

countryCode

isocc.csv

deptNumber

deptinfo.csv

orgId

orginfo.csv

employeeTypeCode

emptype.csv

workLocationCode

workloc.csv

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

You 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 Microsoft™ Windows™ version of the directory.

For information on configuring the display of the report-to field for your organization, see Enable the display of organizational structure information.

Parent topic

Report-to chains for Profiles

Related reference
The tdisettings.properties file

   

 

});

+

Search Tips   |   Advanced Search