Dataphin:Batch Import and Export of Valid/Invalid Mappings

Valid Mappings

1. On the Dataphin home page, from the top menu bar, choose Administration > Standard.

2. In the navigation pane on the left, choose Landing Assessment > Mapping. On the Mapping page, click the Valid Mapping tab.

3. On the Valid Mapping page, click Batch Import/Export in the upper-right corner, and then choose Batch Import Mappings.

4. In the Batch Import Valid Mappings dialog box, configure the parameters.

   Parameter	Description
   STEP 1 Download configuration template	If you do not have a template, click the file name or the download icon to download the .xlsx file. If you already have a template, upload the configuration file and import it.
   STEP 2 Upload configuration file	When filling out the template, follow the specifications for each column. During the import process, the system verifies name uniqueness and input validity. Only .xlsx files with a single worksheet are supported. If the file type is inconsistent or contains multiple worksheets, the import fails. If you modify column names, adjust column order, or delete columns, parsing fails, and the import cannot proceed. Header row: Displays column names and instructions. A red asterisk (*) indicates a required field. Asset Type: If it is an in-domain asset, select a supported object type from the drop-down list: physical table, logical dimension table, logical fact table, logical aggregate table, physical view, logical view, or logical tag table. If it is an externally registered asset, enter a custom asset type. Storage Type: If it is an in-domain asset, select the compute engine type of the current tenant. If it is a global table, select the source data source type. If it is an externally registered asset, select Other. Asset Name: Enter a custom name. For physical tables, physical views, real-time metadata tables, and image tables, add a project name prefix. For logical tables and logical views, add a business segment name prefix. For externally registered tables, enter the GUID. Object Type: Select from the drop-down list. If it is an externally registered asset, select Other. Object Name: Enter a custom field name or metric name. For externally registered tables, enter the GUID. Data Standard Code: Enter a custom code. The system identifies the data standard based on this code. Data Standard Name: Optional. This field is not used to identify the data standard. Name input is case-insensitive. The system automatically matches names based on whether the asset's system is case-sensitive.
   STEP 3 Update policy	If the mappings imported in this batch conflict with existing mappings in the Valid Mappings or Invalid Mappings list, the system applies the configured update policy. If an object with a mapped standard already exists in the valid mappings list, you can retain the valid mapping and append this manually added mapping. If the uploaded mapping already exists in the invalid mappings list, you can choose to set the invalid mapping as valid or retain the invalid mapping and skip the update.

5. On the current page, wait for the import to complete and then view the import details. Alternatively, you can close the configuration dialog box. To view the details later, open the Batch Operation Records dialog box.

   If the import includes failed records, you can view the error messages and download the failed records from the import details. Modify the records based on the error messages and import them again. If records are skipped because of the conflict resolution policy, the system provides the reason.

   Parameter	Description
   Import Result	View import progress and running time information.
   Error Records	Displays mapping records that failed validation and could not be imported, including the Row Number, Storage Type, Object, Standard Name, Standard Code, and Error Message corresponding to each record in the original file. You can click Download Abnormal Records to download the corresponding original records as a file, then modify them according to the error prompts and re-import them.
   Execution Log	View and copy the execution log of the import process.

   After the import is complete, you can close the import configuration dialog box. Closing the dialog box does not stop the import task. You can later click Batch Operation Records on the Valid Mapping page to view the details of historical import records.

Invalid Mapping Relationship

1. On the Dataphin home page, from the top menu bar, choose Administration > Standard.

2. In the navigation pane on the left, choose Landing Assessment > Mapping. On the Mapping page, click the Invalid Mapping tab.

3. On the Invalid Mapping page, click Batch Import/Export in the upper-right corner, and then choose Batch Import Invalid Mappings.

4. In the Batch Import Invalid Mappings dialog box, configure the parameters.

   Parameter	Description
   STEP 1 Download configuration template	If you do not have a template, click the file name or the download icon to download the .xlsx file. If you already have a template, upload the configuration file and import it.
   STEP 2 Upload configuration file	When filling out the template, follow the specifications for each column. During the import process, the system verifies name uniqueness and input validity. Only .xlsx files with a single worksheet are supported. If the file type is inconsistent or contains multiple worksheets, the import fails. If you modify column names, adjust column order, or delete columns, parsing fails, and the import cannot proceed. Header row: Displays column names and instructions. A red asterisk (*) indicates a required field. Asset Type: If it is an in-domain asset, select a supported object type from the drop-down list: physical table, logical dimension table, logical fact table, logical aggregate table, physical view, logical view, or logical tag table. If it is an externally registered asset, enter a custom asset type. Storage Type: If it is an in-domain asset, select the compute engine type of the current tenant. If it is a global table, select the source data source type. If it is an externally registered asset, select Other. Asset Name: Enter a custom name. For physical tables, physical views, real-time metadata tables, and image tables, add a project name prefix. For logical tables and logical views, add a business segment name prefix. For externally registered tables, enter the GUID. Object Type: Select from the drop-down list. If it is an externally registered asset, select Other. Object Name: Enter a custom field name or metric name. For externally registered tables, enter the GUID. Data Standard Code: Enter a custom code. The system identifies the data standard based on this code. Data Standard Name: Optional. This field is not used to identify the data standard. Name input is case-insensitive. The system automatically matches names based on whether the asset's system is case-sensitive.

5. On the current page, wait for the import to complete and then view the import details. Alternatively, you can close the configuration dialog box. To view the details later, open the Batch Operation Records dialog box.

   If the import includes failed records, you can view the error messages and download the failed records from the import details. Modify the records based on the error messages and import them again. If records are skipped because of the conflict resolution policy, the system provides the reason.

   Parameter	Description
   Import Result	View import progress and running time information.
   Error Records	Displays the mapping records that failed validation and could not be imported, including the Line Number, Object, Standard Name, Standard Encoding, and Error Message for each record in the original file. You can click Download Abnormal Records to download the corresponding original records as a file, modify the records based on the error messages, and re-import them.
   Execution Log	View and copy the execution log of the import process.

   After the import is complete, you can close the import configuration dialog box. Closing the dialog box does not stop the import task. To view the import results, click Batch Operation Records on the Invalid Mapping page and select the historical import record that you want to view.