How to import and export data in SIMS

How to Import and Export Data Through Excel

Importing and Exporting Data Using Excel

Exporting Data Using Excel

You can export data to Excel as follows:
  1. Navigate to: Support > Stock Cards.
  2. Right-click the blue box button in the top-left corner of the data grid, near the column headers.
  3. Select Export to Microsoft Excel
    and choose the required fields. (You can define which columns and fields will be included in the spreadsheet. This allows you to tailor the exported file to your requirements.)




    NotesNote that the STOCK CODE field, which serves as the unique key, must always be selected.


This will generate an Excel sheet containing the required data.
Once the export is complete, update the stock information in the Excel sheet as needed. After making your amendments, the data can be imported back into SIMS following the same steps as the export process, but instead selecting Import from Microsoft Excel at step 3.

Importing Using Excel

  1. Begin by using the Excel template: :Stock Cards Import.xlsm. Open the template.
  2. Note that the mandatory columns are colour-coded, and most columns include supplementary header information on hovering over them. Complete all required fields carefully to ensure the data is accurate before importing.



  3. After completing the spreadsheet, save the file on your computer.
  4. Verify that all entries are correct.
  5. To import the data into SIMS:
    1. Open the Stock Card window.
    2. Right-click the top-left corner of the grid.
    3. Select the import options.
    4. Choose the completed Excel file.
    5. Proceed with the import.

        



WarningWe recommend that you create a backup of the full stock list before importing the updated file, as a precaution.