staff-mapping-management

What problem does it solve?

This Skill provides a structured approach to managing the staff-to-institution mapping table, which is crucial for accurate business attribution. It automates the conversion of Excel mapping files to JSON, detects conflicts, and verifies coverage, ensuring data consistency and reliability.

Core Features & Use Cases

• Excel to JSON Conversion: Automates the process of converting the 业务员机构团队对照表 Excel file into a JSON format suitable for system use.
• Conflict Detection: Identifies various conflict types, including same staff name with different institution assignments, missing institution information, and duplicate staff keys.
• System Mapping Update: Guides through backing up the current mapping, validating the new version, and applying the update to the system.
• Coverage Verification: Checks how many staff in the actual business data are covered by the mapping table and reports unmapped staff.
• Use Case: The HR department provides an updated staff-institution Excel file. This skill can be used to convert the new Excel to JSON, detect any inconsistencies or missing data, and then safely update the system's mapping, ensuring all business data is correctly attributed.

Quick Start

Convert the attached Excel file 'new_staff_mapping.xlsx' to JSON format and detect any conflicts within the new mapping.