Need entitlement import to populate values on a custom field on alm_license table.

[iamkurt]

I am migrating some software licenses from a legacy ITAM tool to ServiceNow SAM Pro.

As people working in SAM might be aware, I need to import entitlements first and then allocations.

I have done some work on the raw extract provided by them

For this process, I am leveraging a key which I have created in my excel sheet.

I need to have this key imported on the alm_license (entitlement/ license) table so that I can further leverage it while creating allocations.

I have created a custom field on alm_license table for this key.

Problem is - in the entitlement import template in excel, when I create a column for the custom key field, and try to run the import from License Operations in Software Asset Workspace, I get this error → "Multiple reasons for error: Import template customized resulting in one or many fields being invalid; These custom columns do not exist on the Entitlement table: u_staging_key."

How can I get the import to accept the values I am passing to the custom field?

[Mark Manders]

The error is that the field doesn't exist. Are you sure you are importing to the correct table? Are you sure the field is set correctly (typos and that kind of stuff)? What kind of field is it? Is the field type compatible with the data you want to put in it? 
The error also states that the import template is customized. What has changed and are those changes also reflected in the transform?

[dreinhardt]

Hi @iamkurt,

please check the following ServiceNow Whitepaper about the SAM Pro Entitlement Upload. The last section is about custom fields - ServiceNow SAM Entitlement Import User Guide - ServiceNow Community

Best, Dennis