Easy Import fails to update records

[Sanaz]

There's a custom table in our instance called resolution code, I'm trying to change the description of multiple records and set some records to inactive using easy import from the list view. I select update and download the template.

However when I upload the modified records, the processor sets these to insert instead of update.

I have tried changing the number of records (the attached example has 5 records only) and deleting all columns except description, with no success.

1 out 10 tries I get this error from the processor: "The following columns should not exist in the imported spreadsheet: Sys ID".

Has anyone come across this issue and found a fix? Thanks in advance

Prod instance: Istanbul Patch 9a

[Shishir Srivast]

You should not pass the sys_id while importing the data, sys_id is a system generated unique id which will be assigned automatically when the record gets created.

I think, using list view -> Import will insert the new record instead of updating the existing ones, you should try with the import set to update the record by make the unique column as coalesce.

[Sanaz]

the sys_id is part of the template provided by servicenow when you select update records in the import page. I've used this for updating records on other tables before, is this no longer functional?

The particular table I want to update doesn't have a unique column to coalesce.

[Shishir Srivast]

I understand it now, just tested and i am able to update the existing records. Let me know if it's your personal instance, I can have a quick look.

[Sanaz]

No I"m afraid it's not. I tried this in both prod and dev instances but it continues to insert instead of update.