Issue with import XML

Mr_Avinash · ‎10-22-2020

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

sachin_namjoshi · ‎10-22-2020

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

View solution in original post

Michael Jones - · ‎10-22-2020

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!

I hope this helps!
Michael D. Jones
Proud member of the GlideFast Consulting Team!

Prateek kumar · ‎10-22-2020

Please refer to below thread.

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

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

sachin_namjoshi · ‎10-22-2020

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 · ‎04-08-2021

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.