Skip to content

Data Entity Template Generator

Business Purpose & Overview

This extension adds the Data Entity Template Generator to the Data Management workspace. The generator allows the user to select a data entity and whether they want to include sample data, and creates an Excel sheet with key questions for data mapping in the overview, a list of the fields, a template with the sample data to show what values go to which fields, and a list of the fixed values in drop-downs for that entity.

Overall, the extension makes data mapping activities more relatable and easier for the client to understand going into data migration exercises.

Functionality

The user can access the generator through the Data Management workspace, either from the Home page dashboard, or in System administration > Workspaces > Data management.

In the workspace, the Data Entity Template Generator is a tile on the left hand side of the screen.

Generate the template

When the user selects the tile, a form comes up with a drop-down to select the data entity to generate, and a toggle for whether to include sample data.

Excel Template contents

The data entity template contains 4 tabs:

  • Overview: Key information and questions to answer about the entity during data migration.

  • Fields: A list of fields in the data entity with space for information about data migration and to map the fields from the legacy system.

  • Export Template: Shows where the sample data landed in the entity.

  • Fixed drop downs: Shows the values for fields where there are fixed values in the drop-downs.

Example:

Suggested Updates

Notes about the functionality of the extension upon review. May include suggestions for enhancement, or bug fixes.

Technical Design Information

Technical Solution Architect comment / summary goes here. This is meant to define the “direction” that the developer should take during development.

View in Microsoft Word

Data Entity Template Generator


Last update: January 19, 2022