How to import assets into the 27k1 ISMS
About the procedure
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 from an external TAB DELIMITED text file or CSV.
Using Excel to export to a CSV file is found to be unreliable, if using Excel export to a tab delimited text 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
Hardware table - ZHardwareInventorys
Software table - ZSoftwareInventorys
Outsourced services table - ZOutsourcedServiceInventorys
Personnel table - ZPeopleInventorys
It is 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 direct from Excel.
Open the Management Studio and connect to your server.
Right click the database e.g. ISMSRiskManager and select Import Data (not Flat File).
Click on the Advanced option and select each data field in turn:
- set the corresponding Date data types to date[DT_DATE]
- set the corresponding float data types to float [DT_R4]
Refer to the tables above for the specific data types.
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.
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.
This is a good opportunity to check that your imported data is in the correct format. Click "Preview" and check each row and column is as expected. If the preview is not correct then it is unlikely that the data will be imported.
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”.
Check the data is successfully imported in the Management Studio.
If successful, open the 27k1 ISMS app and transfer the required assets to the Asset Manager.