Information for Specific Steps

In this section:

This topic provides details on steps that require additional explanation or have more complex configuration requirements.


Top of page

x
ValidateVINAlgorithm Dictionary Files

Background information about WMI (World Manufacturer Identifier) and VIN (Vehicle Identification Number) codes is not provided here. For information about those codes, refer to the VIN article on Wikipedia at http://www.wikipedia.org.

The Validate VIN step needs two dictionary files in order to execute successfully.

WMI Dictionary File

The first dictionary file, referred to by the wmiFileName property, is of the MatchingLookup file type. It must contain a WMI code as a matching value and a key name for lookup in the VIN dictionary file. The key name is a string that consists of a WMI code and a mask (optional), followed by the underscore character (_) and a unified manufacturer name (in uppercase and without accents).

The mask starts at the fourth position of the VIN (the first three characters are for the WMI code) and can consist of up to 11 characters. If no mask is defined, a default mask of *********** (11 asterisks) is used. An asterisk is a wild card that represents any character, as opposed to a specific character.

If a character other than an asterisk is placed in any of the mask fields, the specified character will be used at that position. For example, the mask ***6Y defines characters 6Y at the 7th and 8th positions. The whole key name will then look like, for example, TMB***6Y_SKODA (SKODA is the manufacturer name). It will match VIN TMB1236Y234567890 but not TMB12345234567890.

VIN Dictionary File

The second dictionary file, referred to by the vinInfoFileName property, is of the Indexed Table file type. It is indexed by the key names (the same values that are in the WMI dictionary file). It contains, in order, these columns: key name, real name of manufacturer, car model, year that VIN was issued (in four-digit format), position of CRC number (if the VIN code contains any), and position of year number (if any).


Top of page

x
Convert Phone Numbers Step Dictionary Files

The only dictionary file for this step, referred to by conversionTableFileName, is of the Indexed Table file type. The table is indexed by the source prefix, which consists of the old prefix and the beginning of the original number that is going to be replaced by the step. The table contains the source prefix (the value that was indexed from), the length of the number that will not be replaced, and the new prefix.

Example: You need to convert all numbers with the old prefix 02 that start at number 2 (02 22 93 44 23, 02 23 48 79 67) to a 9-digit national format. The table must have a line indexed with 022 (02 as the original prefix, 2 as the start number) and must contain 022 (source prefix), 7 (number length), and 22 (new prefix). The step then replaces 022 from the beginning of a number with 22 from the new prefix and copies 7 numbers from the original phone number.


Top of page

x
Update Gender Step Dictionary Files

Numbers written in the dictionary files are the ratios of males to females with the corresponding name (names are the indexed value). They are INTEGER values calculated as (male_count*1000)/(male_count+female_count). This corresponds to 0 and small numbers for most female names, and 1000 and large numbers primarily for male names.


iWay Software