Importing equipment model data
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).
You must install the Industrial Process Manager before importing equipment model data.
- If you use the spreadsheet to import the data, you must populate the Microsoft Excel spreadsheet with your existing ISA-95 Equipment Model data and run the SG-Equipment Model Scheduled Import Using Spreadsheet scheduled import. Many legacy record systems contain functions that enable you to export this data to an Excel spreadsheet, which means that you don't have to populate it manually.
- Several ServiceNow partners are also developing integrations to
third-party legacy record systems that store equipment model data.
- When these integrations become available, you can find them on the ServiceNow Store by searching for Operational Technology certified integrations for the Industrial Process Manager.
- Install those integrations that are applicable to your environment, and run them as needed.
By using these import methods, you can update existing equipment models in the ServiceNow AI Platform with the data that is stored in your authoritative source when needed. For newly imported data, the ServiceNow AI Platform automatically creates Equipment Model Entity CI class records in the Configuration Management Database (CMDB).
System properties that affect import processing
The following system properties affect how you populate your Microsoft Excel spreadsheet with the equipment model data and how the Import Equipment Model - ETL process functions.
- sn_isa_model.cmdb_relationships_sync_levels
- Determines how many levels of an equipment model can be imported into the ServiceNow AI Platform and then are synchronized in the Configuration Management Database (CMDB). The default value is 8.
- sn_isa_model.short_code_validation_max_length
- Sets the maximum length for the Short Code column on your spreadsheet. The default value is 3.
- sn_isa_model.user_search_matching_attribute
- Matches the user data references that are imported from your populated spreadsheet to the corresponding user records that are stored in the System Users [sys_user} table. The default is the user's email address, because the email address is unique to each user record.
- glide.scriptable.excel.max_file_size
- Sets the maximum size of an Excel file, expressed in bytes. This property is global.