Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel

ERROR

Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel when you are trying to re-import items that you have amended from Excel.

ENVIRONMENT

1. SIMS
   

SOLUTION

Follow the procedure below:

1. Re-export the needed data (example will be showing Stock Items):

1. It will open the Excel with the fields selected. If you close Excel as soon after the export has been done and you click on "Do Not Save" it will delete what we call the indexes. These are used by SIMS to determine where the amended fields need to be re-imported.
   
2. Reopen the excel and click on the A1 in excel and do not see the index like STK_CODE or STK_DESC you need to regenerate the excel, do your work, and make sure to save before closing. This will keep the indexes
   
3. Below is an example of an excel without indexes
   

1. And here is an example with indexes. The below is the correct export.
   

1. When you have amended your work you can re-import excel from

• Related Articles

• How to import and export data through Excel

  You can export data to Excel by going to Support > Stock cards and right-clicking the blue box button in the top-left corner of the data grid (near the column headers). Then navigate to Export to Microsoft Excel and select the required fields (note ...

• Error: "This action cannot be completed because the other program is busy" is showing up when trying to export replenishment to Excel from SPOS

  PROBLEM Error: "This action cannot be completed because the other program is busy" window is coming up when trying to export the replenishment on Excel on SPOS. The windows will freeze and a message box in the left top corner comes with a message ...

• Creating and Updating Contracted Prices in SIMS using Excel

  Creating New Contacted Prices Scenario 1: Adding a new contracted price for an existing client Go to Support > Clients and choose the client. Click on the Contracted Prices tab. Press + or 'Insert' on the keyboard. Enter the stock code and choose a ...

• Importing details into the system using Excel

  To import details into the system from Excel, you must first generate a template with the column names. This can be done by right-clicking the small blue box at the top-left corner of the grid you wish to populate and pressing the Generate Microsoft ...

• Error: "Missing DSK.dll from..." when opening SFS application

  Problem The error "Missing DSK.dll from......" pops up when trying to launch SFS for the first time after installation of the application on a new machine or when a new user profile has been created on a machine that already has SFS installed. ...