Issue with import XML

[Mr_Avinash]

Hi All,

we are facing issue with import xml.

we have a role called data admin and has a context menu created called Import XML(data admin).. the user with data admin role can do import xml by this context menu only. But when getting the below error while doing.

the script in the context menu is as below:

unable to find out what is the issue is.

Thanks in Advance

[Michael Jones -]

Just to validate, does the user have access to the table that the XML file is referencing? That error would typically indicate that the user would not have permission to perform the action (insert or update) on the table referenced in the XML. 

Is this occurring on other tables, or only the sys_user table?

If this was helpful or correct, please be kind and click appropriately!

Michael Jones - Proud member of the CloudPires Team!

[Prateek kumar]

Please refer to below thread.

https://community.servicenow.com/community?id=community_question&sys_id=41ffe8bddb23d344fff8a345ca96...

[sachin_namjoshi · Accepted solution]

The solution is to add a property (sys_properties) called glide.ui.security.upload.roles. In the value field, include the roles you would like to be allowed to upload XMLs. You don't need to add 'admin', just the other roles that you want to grant this permission to.

This will not show the import XML option on context menus for the roles you entered. This just simply allows those roles to import XML to tables that they have access to do so.

For our case, we updated contenxt menus to show the import XML option where need be for the new role. Added that role to the property. The users with that role were able to upload to tables that they can create/write to, but not to tables where they don't have access to.

Regards,

Sachin

[Robert Balala]

The context menu import xml does not limit you to only importing xml for that table.  Problem I am running into is preventing import xml into a table even though the user does not have create or write to the table that the xml is for.