Import data for readonly fields

[tkrishna29]

Hello Team,

I'm trying to use import data feature to import legacy data to my new table. When I created the template using ServiceNow, it skipped certain columns when creating the template. Those are the readonly fields for my table. While I do understand that we are not allowed to update readonly fields through import data, I believe the template should allow for data insertion.

Tried manually adding the fields to the excel and imported. But the system ignores them saying the fields not available. I'm using Helsinki.

Checked online in Hi support - ServiceNow KB: Import - Additional columns are visible in templates on Inserts and Updates. (KB05948...

I tried this approach, Still didn't work. Article suggests to set a system property   - glide.import_set_row.dynamically_add_fields to true. This property is not available in Helsinki. I manually created one and retried again. It still didnt work.

Highly appreciate if anyone can help.

Thanks,

Krishna

[lasse3]

Hi Krishna,

When you say "read only" is that then because the fields are marked as "read only" in the dictionary or because they are logged with an ACL?

Have you considered altering the table in a development instance so that the fields are not "read only" and then try to do the import? If that works you can do an XML export and see if you can import this. If this fails, then you know, that the format is correct and you may want to consider temporarily make the fields readable, then do the import and make them read only again.

Kind regards

Lasse

[tkrishna29]

Hi Lasse,

Changing the field ReadOnly to false works fine. I was able to see that field in the template and import data.

While I appreciate the short cut method of temporarily unchecking the fields and importing data, I'm looking for a permanent solution without changing the field status.

Regards,

Krishna

[Pradeep Sharma]

Hello Krishna,

Importing data on the read-only field should work. Is there any data policy defined?

For testing can you uncheck the "Run business rule" flag on transformation map and try once.

[tkrishna29]

Hello Pradeep,

Thanks for the response.

It was not a data policy issue. My problem is solved by uploading the items using Transformation map.

However, I wanted to try the simple approach of import data. My understanding - there is a bug in the Helsinki version for inserting Readonly fields (As I stated from the Hi Support KB document).

I'm looking to see for knowledge sake on what am I doing wrong in creating the system variable as mentioned and make this happen using import data.

Regards,

Krishna