MDSoft: Entity Field Standardization Module (Activity)

What this solution does

The Activity Entity Field Standardization Module is designed to normalize client database records to a unified standard and monitor data entry quality by staff. It addresses the issue of heterogeneous information originating from multiple sources, including manual entry by managers, imports from web forms, and data extracted from incoming emails.

The tool normalizes phone numbers by removing extraneous characters such as parentheses, hyphens, and spaces, while identifying the number type (landline or mobile) and region. It ensures the completeness of address data by requiring the entry of postal codes and validating city and street names, as well as map coordinates.

For contact names (First Name, Last Name, Patronymic), the module verifies the correspondence of names, corrects spelling errors, applies proper grammatical declensions, and validates the accuracy of gender specification.

The Activity module standardizes company data by converting incomplete or erroneous records into a unified format. The service leverages Dadata to process the following data fields on input and output:

Full Name:

- Original Surname, First Name, Patronymic.

- Formatted full array in JSON.

- Full Name in the dative case.

- Full Name in the genitive case.

- Gender.

- Surname, First Name, Patronymic as separate fields.

Address:

- Full address, region, postal code.

- Country and region codes in international format.

- Flag indicating if the address is within a ring road.

- GPS coordinates (latitude, longitude).

- Average price per square meter.

- Estimated property value.

- Property area.

- Full data array in JSON format.

Phone:

- Phone number.

- Line type (mobile or landline).

- Country.

- Subscriber operator.

- Subscriber time zone.

- Full data array in JSON format.

Use cases:

- Automatic data correction during employee entry: fixing swapped first names and patronymics, filling in missing gender, and other fields.

- Preparation of data for mass mailings: automatic declension of full names and generation of subject line salutations based on the recipient's gender.

MDSoft Standardization Module for Activity Entities. When address data is incomplete, the module generates complete data in a standard format, identifying the country and postal code. This is essential for automated mailing of physical letters.

For automated SMS sending, the module determines the subscriber's time zone and mobile operator, standardizes the phone number, and schedules delivery at a convenient time for the recipient.

The module also supports returning the full data array in JSON format. This data can be processed by other marketplace activities, helping to reduce the number of requests to the Dadata service.

General iT can install and configure this module and check how it works on your website.