How to import a file and use the name instead of sys_id as key to avoid " The following columns need to exist in the imported spreadsheet: Sys ID" error? - Support and Troubleshooting

How to import a file and use the name instead of sys_id as key to avoid " The following columns need to exist in the imported spreadsheet: Sys ID" error? Issue When go to the File Shares module and from the list view select option to import a spreadsheet, the spreadsheet only has the Name, Billable Quota (GB) and Quota (GB) fields (no sys_id).

When attempt to import it as update to existing records, it fails because there is no sys_id.

Error reported is "The following columns need to exist in the imported spreadsheet: Sys ID"

How can be made the Name be the unique identifier? There are hundreds of records in the spreadsheet and the end user does not know the sys_ids nor do they want to add them one at a time.

Resolution This can be done using 'Easy import'

1. With the Easy import you can create an Excel template , for updates, which creates an initial excel file with all sys_user table data. This data will include also the row sys_id. 2. Once the file is generated and downloaded, the you may change any piece of data for the rows of interest just using excel. 3. Once the file updated is saved, it can be imported again in the list view and selecting the desired import type. 4. Once the import ends, click on preview to check if there were errors loading the data. Then click on Complete Import to import records into the current table.