Using import sets to update existing data records

khabibulan
Kilo Contributor

I am a new user and am working on understanding the use of import sets to update existing records. in this case i've added a field called "room number" to the ci_computer table so I can tell where a computer is located. In a typical move situation we would need to update the room location of any computers that were moved from one place to another.

My general approach in the old system is to export data records based on their asset tag number (which is unique). Then i modify the records in Excel and reimport to overwrite/update the existing records with the new information.

When I look at the computer table in SNC i can't find the sys_id field. I'm guessing that this is the OOB unique ID for the record, but can't locate it in the available or used fields. So when I export my records and import them again they are duplicated instead of updated.

Does this make sense? Has anybody seen this happen or know how to replace the GUID field in an existing table?

7 REPLIES 7

marcguy
ServiceNow Employee
ServiceNow Employee

the best option is to upload the file again after changes are made, this will create a new imprt set but you can still choose to use the same mapping. that should then modify the records changed.

Marc


That worked exactly as advertised! OK - one last question now that I have the ability to make these changes how can I set this whole process up so that someone who only comes into the system to update record can run this import and validate that these asset changes are done? I am currently running this but I have admin permissions - i want to be able to let an asset support team run this and have them be the only non-admins to have permissions. Thanks again for all the help!


marcguy
ServiceNow Employee
ServiceNow Employee

Currently, that application (system import sets) is only acessible by someone with the admin role, but if you edit the applicatons role, right-click on System Import Sets - EDIT Application, add ITIL role or role you wish to have access:

then impersonate one of those users and see how you get on.

here are some wiki articles to help you out:
http://wiki.service-now.com/index.php?title=Enabling_Application_Modules
http://wiki.service-now.com/index.php?title=Impersonating_a_User

Marc