---
sourceDocument: Xanadu Operational Technology Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/operational-technology

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Add a custom field mapping in the staging table for Service Graph

# Add a custom field mapping in the staging table for Service Graph {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Add a custom field to the staging table and map the custom field from the staging
table to the CI field through Excel SGC.

## Before you begin

To configure the form layout, see
[Configure the form
layout](https://www.servicenow.com/docs/access?context=configure-form-layout&version=xanadu&pubname=xanadu-platform-administration&ft:locale=en-US).

To create a custom field on the staging table, see [Add and customize a field in
a table](https://www.servicenow.com/docs/access?context=t_CreatingNewFields&version=xanadu&pubname=xanadu-platform-administration&ft:locale=en-US).  
Roles required:

* admin - Can make changes in the script include, and add class or field mappings and make changes in the ETL.
* cmdb_inst_admin - Can only add new class or field mappings and make changes in the ETL.
{#add-new-column-mappings-excel-service-graph__ul_its_vls_c5b}

## Procedure

1. After a custom column is created in the staging table, navigate to AllIndustrial Workspace AdminOT ManagerImport OT Devices - Staging table.
2. Download the Excel template.  
   For more information, see [Download Excel template](https://servicenow-prod.fluidtopics.net/HF0P1zPDliZ8_anUfWD6iA "Download the Microsoft Excel template to create and populate a Microsoft Excel spreadsheet with your existing Operational Technology data.").

   If records are present in the staging table, you can edit the value for the column in the existing records.
3. Prepare the Excel template.  
   For more information, see [Preparing your Pre-import OT worksheet entry review tool for Service Graph Connector import](https://servicenow-prod.fluidtopics.net/l5fTQ~pypOFHymWa3iAqtQ "Prepare your spreadsheet by positioning your existing data in the correct columns is crucial to the success of your upload.").
4. Import the Excel template.  
   For more information, see [Import Excel template](https://servicenow-prod.fluidtopics.net/QxscY8cnsIu6KZ8Dj_1WGA "After updating the import template with the new data, import the template to your instance to validate and find missing, duplicate, and invalid data.").
5. Navigate to AllIndustrial Workspace AdminOT ManagerImport OT Devices - Script Includes and select the SGOTAssetImportExcelConstants script include.
6. In the script, update the new column name from the staging table, and the new ETL column name inside the SGOTAssetImportExcelConstants.importSetColumnsVsStagingColumnsMap object in the format "\<ETL Column Name\>": "\<Column Name from staging table\>".  
   In this example, the "u_my_custom_field" before the colon ( : ) indicates the
   ETL column name (shown as a column in the ETL preview step), and the
   "u_my_custom_field" after the colon indicates the column name in the staging
   table.

   Make sure that there is a comma (,) added at the end of the line above the
   new line. In this example, a comma is added after the "custom_fields":
   "custom_fields" line.
7. Select Update to save your changes.
8. Navigate to AllConfigurationIntegrationHub ETL.
9. Select the CMDB Application: SG-OT Excel Import ETL.
10. If the Invalid Mapping Data Detected page is displayed, select Close.
11. From the ETL Transform Map Assistant, in the Specify Basic Details section of the guided setup, select Import Source Data and Provide Basic Details.  

12. In the Sample Import Set field, select Auto-pull a new import set.  

13. Select Save.  
    The basic information saved successfully banner is displayed.
14. Select Mark as Complete.
15. From the ETL Transform Map Assistant page, in the Prepare Source Data for Mapping section, select Preview and prepare data.  

    If the column is not visible, repeat the steps 11 through 14.
16. Select Mark as Complete.
17. From the ETL Transform Map Assistant page, in the Map Data to CMDB and Add Relationships section, select CMDB Classes to Map Source Data.
18. Map the column to the target class and attribute.  
    For example, the "comments" field is present on the Hardware
    cmdb_ci_hardware class. After this field is mapped,
    the "comment" field on Hardware child classes is updated as well, as long as
    the value for the "comments" column in the staging table for that row is not
    empty. If you're adding a mapping for a new field that is not present, or
    for a field that is not specific to the Hardware
    cmdb_ci_hardware class, but instead is a field in the
    Operational Technology (cmdb_ci_ot) class, you would add
    the field mapping in the Operational Technology (OT) 1 stub.
    1. Add a field mapping to the Hardware 1 class.
    2. For the Hardware 1 class, select Edit Mapping.  

    {#add-new-column-mappings-excel-service-graph__substeps_tqd_tt1_mrb}
19. In the Add Attribute dialog box that appears, from the Attribute list, select Comments.  

20. Select Save.  
    A new field named "Comments" is displayed. You may need to scroll to see the field.  

21. From the Data pane, drag the data pill to the Comments Source Column field.  

    You can also select the source column icon ( ![Source column icon.]() ) to select the data mapping field for it.  
    The Source Column includes the data pill.  

22. Navigate back to the CMDB Classes to Map Source Data of the Map Data to CMDB and Add Relationships section in the ETL Transform Map Assistant page.  

23. Select Mark as Complete.
24. Follow these steps to verify the new field mappings.
    1. Navigate to the home page of the ETL Transform Map Assistant.
    2. In the Preview Sample Integration Results and Schedule Import section of the guided setup, select Test and Rollback Integration Results.  

    3. Select Run Integration.
    4. After the run finishes successfully, confirm that the Comments field of the CI that you provided a comments value for is updated in the staging table.
    5. Select Mark as Complete.  

    6. Select Perform Rollback.  

    7. If the ETL is not activated, select Activate.

    {#add-new-column-mappings-excel-service-graph__substeps_vtl_gzj_nrb}  
    The new column field mapping is successfully added and verified.

*[\>]: and then