Importing Assets into the 27k1 ISMS

LAST UPDATED 6th July 2020

About the procedure

This is the procedure for safely importing your company personnel, hardware, software and outsourced services into the 27k1 ISMS.

Prerequisites

To get started you will need to install the latest version of the Microsoft SQL Server Management Studio and connect to your Azure SQL Database or SQL Server (Express).

Principles

There are four special tables located at the bottom of the table list and prefixed with a “Z”. These are the tables your data is imported into for an external Excel or CSV file.

The data imported into these table will be selected within the 27k1 ISMS app and transferred to the ISMS tables.
The 27k1 ISMS does not use these tables other than for importing.

SQL Database Import Tables

The fields available to import data into are shown below.

Hardware – ZHardwareInventorys

Software – ZSoftwareInventorys

Outsourced services – ZOutsourcedServiceInventorys

Personnel – ZPeopleInventorys

Import procedure

It is highly recommended that the source file (from where data is imported from) is a flat file such as a comma delimited CSV file. It is highly recommended not to import from Excel.
Open the Management Studio and connect to your server.

Step 1

Right click the database e.g. ISMSRiskManager and select Import Data (not Flat File).

Step 2

Select Flat File as the source

Step 3

Browse for the File name to be imported. Select All files *.* to view all files in the folder.

Step 4

Click on the Advanced option and select each data field in turn and set the corresponding Data Type to data {DT_DATE]

Step 5

Choose the Destination as SQL Server Native Client, at the bottom off the list.
Enter your SQL Database user name and password. Ensure ISMSRiskManager is the selected database.

Step 6

Check the source is correct.
VERY IMPORTANT: Select the table with the Z prefix for the data to me imported to. We have chosen hardware in the example.
If you click Back this selection could reset when you revisit this dialog page.

Click Edit Mappings… to check all looks good.

Step 7

Review Data Type Mapping.
It is important to check the Destination is set correctly and also change the On Error and On Truncation to “Ignore”.

Step 8

If importing the data was successful you should see a dialog something similar to this.

The imported data can be checked in the Management Studio, then open the 27k1 ISMS app and transfer the required assets to the Asset Manager.