<h2>Import your equipment model data using the data source and scheduled import</h2><br/><div style="overflow-x:auto"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta content="text/html; charset=UTF-8" /><meta name="copyright" content="(C) Copyright 2025" /><meta name="DC.rights.owner" content="(C) Copyright 2025" /><meta name="generator" content="DITA-OT" /><meta name="DC.type" content="task" /><meta name="DC.title" content="Import your equipment model data using the data source and scheduled import" /><meta name="abstract" content="After you complete your Microsoft Excel spreadsheet with your equipment model data, import it into the Now Platform by using the data source and scheduled import." /><meta name="description" content="After you complete your Microsoft Excel spreadsheet with your equipment model data, import it into the Now Platform by using the data source and scheduled import." /><meta name="DC.relation" scheme="URI" content="../../../product/mftg-manufacturing-process-mgr/concept/importing-isa95-equipment-model-etl.html" /><meta name="DC.relation" scheme="URI" content="../../../product/operational-technology-management/concept/operational-technology-overview.html" /><meta name="DC.relation" scheme="URI" content="../../../product/mftg-manufacturing-process-mgr/concept/industrial-process-manager-overview.html" /><meta name="DC.relation" scheme="URI" content="../../../product/mftg-manufacturing-process-mgr/concept/configuring-manufacturing-process-mgr.html" /><meta name="DC.creator" content="ServiceNow" /><meta name="DC.date.created" content="2024-01-22T14:59:20-05:00" /><meta name="DC.date.modified" content="2025-01-30" /><meta name="DC.format" content="XHTML" /><meta name="DC.identifier" content="import-equipment-model-data-using-data-source-and-scheduled-import" /><link rel="stylesheet" type="text/css" href="../../../CSS/commonltr.css" /><title>Import your equipment model data using the data source and scheduled import</title></head><body id="import-equipment-model-data-using-data-source-and-scheduled-import"> <div class="breadcrumb"><a class="link" href="../../../product/operational-technology-management/concept/operational-technology-overview.html" title="Use ServiceNow for Operational Technology to help your organization streamline operations, boost productivity, and maximize your Operational Technology uptime on the production floor through digital workflows.">Operational Technology</a> > <a class="link" href="../../../product/mftg-manufacturing-process-mgr/concept/industrial-process-manager-overview.html" title="Use the Industrial Process Manager application to create the ISA-95 Equipment Model data foundation that is required for the ServiceNow Operational Technology solution. The Industrial Process Manager enables you to create your own version of the equipment models in each of your sites.">Industrial Process Manager</a> > <a class="link" href="../../../product/mftg-manufacturing-process-mgr/concept/configuring-manufacturing-process-mgr.html" title="Configure the Industrial Process Manager application so that you can create the Equipment Model data foundation that is required for the ServiceNow Operational Technology solution.">Configuring the Industrial Process Manager</a> > </div> <h1 class="title topictitle1" id="ariaid-title1">Import your equipment model data using the data source and scheduled import</h1> <div class="body taskbody"><p class="shortdesc">After you complete your Microsoft Excel spreadsheet with your equipment model data, import it into the <span class="ph">Now Platform</span> by using the data source and scheduled import.</p> <div class="section prereq p"> <p class="p">Before you perform this process, you must prepare a Microsoft Excel spreadsheet for import. To learn more, see <a class="xref" href="../concept/populate-excel-spreadsheet-with-isa-equipment-model-data.html" title="Create and populate a Microsoft Excel spreadsheet with your existing ISA equipment model data. Positioning your existing data in the correct columns is crucial to the success of your upload.">Populating your Microsoft Excel spreadsheet with equipment model data</a>.</p> <p class="p">Role required: cmdb_inst_admin, import_admin</p> </div> <div class="section context" id="import-equipment-model-data-using-data-source-and-scheduled-import__context_md4_dm4_21c"> <p class="p">By running this process, you create unique Equipment Model Entity CI class records in the <span class="ph">Configuration Management Database (CMDB)</span> for the equipment model records that are included in your spreadsheet.</p> </div> <ol class="ol steps"><li class="li step stepexpand"> <span class="ph cmd">Navigate to <span class="ph menucascade"><span class="ph uicontrol">All</span> > <span class="ph uicontrol">Equipment Model - ISA</span> > <span class="ph uicontrol">Import Equip. Model - Data Source</span></span>.</span> </li><li class="li step stepexpand"> <span class="ph cmd">In the <span class="ph uicontrol">SG Equipment Model</span> data source record, attach the Microsoft Excel spreadsheet that you created:</span> <div class="itemgroup info"> <ol class="ol" type="a" id="import-equipment-model-data-using-data-source-and-scheduled-import__ol_kmx_4m4_21c"><li class="li">Select <span class="ph uicontrol">Manage Attachments</span>.</li><li class="li">In the Attachments dialog box, select <span class="ph uicontrol">Choose File</span>.</li><li class="li">Select the Microsoft Excel spreadsheet that you created, and then close the Attachments dialog box.</li><li class="li">After attaching the spreadsheet, select the <span class="ph uicontrol">Load All Records</span> related link to load all records from the spreadsheet to the import table. Once the operation is complete, you should see the following confirmation message with the <span class="ph uicontrol">Success</span> completion code if the data is loaded without any errors.<img class="image" id="import-equipment-model-data-using-data-source-and-scheduled-import__image_rgt_zn4_21c" src="../image/load-records-success.png" alt="Confirmation message that says State Complete and Completion Code Success if the record loading completed without any errors." /></li><li class="li">In the confirmation message, select the <span class="ph uicontrol">Run Robust Transform</span> related link.</li><li class="li">Select <span class="ph uicontrol">Transform</span>. If the import is successful, you should see the following confirmation message with the <span class="ph uicontrol">Success</span> completion code.<img class="image" id="import-equipment-model-data-using-data-source-and-scheduled-import__image_nh1_444_21c" src="../image/run-rte-success.png" alt="Confirmation message that says State Complete and Completion Code Success if the import is completed without any errors." /></li></ol> </div> </li></ol> </div> <div class="related-links"> <div class="familylinks"> <div class="parentlink"><strong>Parent Topic:</strong> <a class="link" href="../../../product/mftg-manufacturing-process-mgr/concept/importing-isa95-equipment-model-etl.html" title="The scheduled import function enables you to import your existing equipment model data from a populated Microsoft Excel flat-file spreadsheet. You can use it to import your ISA-95 Equipment Model data to the Configuration Management Database (CMDB).">Importing equipment model data</a></div> </div> </div></body></html></div>