Issue while importing excel sheet in ServiceNow table(Not using Transform Map)-Direct import

[sattar3]

Hello Everyone,

I'm trying to import a excel sheet by using Import option in a ServiceNow table.

We have a field called "DEP registered" which is a read-only field and the type is boolean(true/false).

When i'm importing it is not working, its showing disable instead enable, is this OOTB behavior?

Field details:

why it is not setting the value from excel sheet? in excel the field value is true.

We are not allowed to do via Transform maps, this is the only way to import the data?

From the excel sheet.

Please help me on this to fix issue so that the DEP registered field set to True(enable).

We are manually not allowed to update also.

@Ankur Bawiskar @Sandeep Rajput 

Thanks,

Shaik

[Sandeep Rajput · Accepted solution]

@sattar3 Easy import will not work for Read only fields, a similar topic is discussed on this thread here https://www.servicenow.com/community/now-platform-articles/easy-import-functionality-don-t-work-when...

To address this issue, make the field editable and enforce the Read only behaviour via field level write ACL.

[Sandeep Rajput]

@sattar3 Thanks for marking the response helpful. Could you please also mark my response an accepted solution

[Juhi Poddar]

Hello @sattar3 

• As @Sandeep Rajput  mentioned, the issue you're encountering is due to the 'DEP registered' field being marked as read-only.
• Because of this, even though you're importing data directly into the table, ServiceNow does not allow updates to the field.
• To resolve this, you’ll need to temporarily make the field writable during the import process.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar