Software Entitlement Import functionality in SAM professional

[shank1]

Hi,

OOB we have entitlement import feature in SAM professional. I have few questions:

1. Where can see its Transform maps, so that I can see which fields are set to coalesce true, scripts, error handling etc

2. Is this import functionality only for insert or update

3. Incase I need to import the entitlements for Oracle database, the 'Database Option' field needs to be filled up. I dont see that field in the import sheet. So whats the use of this feature where all the fields are not used.

Thanks!

[Rohit Lobo · Accepted solution]

Shanks,

1. Entitlement import currently doesn't work off transform maps. This is a road map item.

2. Insert only. An error is reported if import encounters a duplicate record.

3. Importing entitlements for Oracle options is a potential release candidate for Orlando release in Q1 2020.

[shank1]

Hi Rohit,

Thanks for the update.

So how is the data validation happening in NewYork verion for entitlement import.

[lileem09]

If the template is only for insert purposes then why does it reference an "Update template"?

[Ashutosh Munot1]

Hi,

Guys there are two things to look into:

1) INSERTION:

When you use import entitlements and download template, fill it and import then it will insert records.

2) Updation:

When you download template you will see a note that use update template to update data.

So what you should do to update the entitlement is follow below process:

1) Open table i.e. Software Entitlement

2) Right Click on any column as below and click on import:

3) If you want to update the data then click on update as below:

Once you click on Create Excel Template then you will find that it will download all records and will have sysid column as the last column in downloaded excel sheet. When you again load it, it will use the sys id to update the record in table. 

Dont edit the sysid column

Thanks,
Ashutosh