I'm doing these exercises to gain proficiency in ServiceNow. In section 6 for import sets, I'm asked to export data from the 'Windows Servers' list (the cmdb_ci_win_server table), make some changes to existing entries, add a few more entries, and then "Using this modified data, create a data source and transform map to import the CSV data back into the instance. Make sure that the correct CIs were updated and the correct CIs were inserted. Did you set up the correct coalesce value?" I have created a transform map with a source table of Computer[imp_computer] and a target table of Windows Server[cmdb_ci_win_server]. which coalesces on the field model_id (for which a database index already existed, leading me to think there's a pretty good chance that was a good choice). I have auto mapped the matching fields for this transform map, and have left the fields that didn't match up alone. When I click the Transform related link it always says "No import set available. Create and load an import set first." I click on the link to create a new import set, use the existing import set table Computer[imp_computer] and then upload the csv file I created and modified earlier from the Windows server list. I leave both the sheet number and header row set to 1 and click Submit. I then click Run Transform and select the transform map I've created. Then when I go to the import set, all the rows have a state of Skipped and the import set run time is 0 seconds. Of course, this means when I go back to the Windows servers list nothing has changed. Could someone please point me in the right direction here?
Thanks.
