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?
