logo

NJP

Import Model and Model category with easy import

Import · Aug 21, 2019 · article

Last time our vendor post an article "Easy Import does not allow inserts to the [alm_asset] or [alm_hardware] tables when Excel or CSV fil...", and said not able to import Model or Model category in ServiceNow. As came up with error message "The following fields have been ignored, because they don't exist on the destination table: Model, Model category".

So... facing up with some many model and model category records, need we add them to system one by one? No, definitely not.

Easy import is a simplified import process that provides a template that contains only the columns you want to import from a list, and it is very usefully to handle large number of data import. It considered security issue as well, to prevent illegal or risk level fields and caused issue. It configured as properties to ignore some field types. That is: glide.import_template.field_types_to_ignore

To include model and model category, or other missing columns in your import, you'll need to remove the field types from that system property.

How to remove the field types from your system property:

  1. In the navigation filter, enter list.
  2. Go to glide.import_template.field_types_to_ignore
  3. In the Valuefield, remove the table_name and glide_list field types (as model refer table_name field type, and model category is a glide_list field type):

Notes: as remove glide_list and table_name from the ignore type list may cause potential risk if not use it correctly. Suggest to rollback when finished import with model and model category.

You can apply the same steps above to remove other field types from this system property. Like work notes and additional comments.

Reference: Why Easy Import Is Ignoring You

View original source

https://www.servicenow.com/community/itsm-articles/import-model-and-model-category-with-easy-import/ta-p/2302929