Datenimport/en

With the help of the importer, resources, measures, controls and check questions for knowledge bases or structure updates for organizational units can be imported. These updates can come from an SAP export, for example, or from a specially created Excel or CSV file. In this way, obsolete structures can be updated or completely new structures can be imported.

If an import is performed, all entities that have been changed are updated, and all entities that do not yet exist in HITGuard are created.

Performing an import

Imports can be performed only by administrators or experts.

To perform an import, first go to "Administration → Data import | Import logs". All created import configurations are now displayed here. To perform an import, either an existing import configuration is selected from the list or a new import configuration is created - in terms of execution, the processes do not differ.

Each import is documented under "Administration → Data import | Import logs".

To use an existing import configuration, double-click on the desired configuration.

To create a new import configuration, click on the green plus. (see figure)

Create new import configuration

Afterwards a mask opens (see figure below), where the name of the configuration has to be set, the type of the configuration has to be selected and the file to be imported has to be uploaded.

The file can be either a CSV file or an Excel file. (Import file structure)

Select import type

Clicking on "Next" opens the mask for assigning the fields (see figure below). Here at least all mandatory fields of the selected import type should be assigned. You can find out what these are from the description of the individual imports.

If an Excel file is imported, care must be taken that column headings exist in the file. If these exist, it is selected that the first row contains column headers and should therefore be ignored.

Assign fields

If all mandatory fields have now been assigned, the import can be saved and is ready for import. All that remains is to click on "Save and import".

Save and import

If the import was successful, you will see how many entities were newly created and how many were modified. In case of erroneous import operations, those rows and columns that contain errors will be listed for you.

Successful organization import

Import logs

Each import attempt is documented under "Administration → Data import | Import logs". Both successful and failed import attempts are recorded.

Overview of the protocols

By double-clicking on an import, you will be redirected to a screen where you can see details such as the reason why the import failed.

Detail view of an import log

Import data categories

To import data categories, the "Data category" type must be selected during import.

There are two options:

• Create new data categories
• Update existing data categories

Only classes created under Risk Management → Risk Policy → Data Classes are allowed for the Data Class field.

Only the values Yes and No are permitted for the fields Protection needs analysis and Person-related. You determine where the data categories can be used.

For information about responsible persons see User management.

Create new data categories

When importing a file, HITGuard uses the data set ID in the import file to check whether it already exists or not. If it does not exist, it is created again.

To create a new data category, you must fill in the mandatory fields

• Record ID
• Name
• Data class (Risk Management → Risk Policy → Data classes)

must be available and filled in. Only if this is the case, the import is feasible.

Furthermore the fields

• description
• Parent record ID (parent data category)
• Protection Needs Analysis (Yes/No)
• Person-related (Yes/No)

can be assigned.

If the parent record ID is assigned to a data category, a data category with this ID must either already exist in HITGuard or be created in this import. Furthermore, no cycles may exist. Cycles are used when, for example, data category A has entered data category B as its parent ID and data category B has entered data category A as its parent ID. The importer detects these cycles, prevents the import and refers to the cycle error.

Update data categories

If the record ID of the data category is found during the import, no new data category is created, but the existing one is updated. That means: The existing fields of the import file update the already existing fields like e.g. designation, data class or person related. This allows the maintenance of individual data category or larger data category structures .

Example:

It is decided to create a new data category that should be parent to already existing data categories. In this case, the already existing data categories can be easily subordinated to this new data category by changing their parent ID.

Template

• Import Vorlage Datenkategorie.xlsx

Import hazard situations

To import hazard situations, the "Hazard situation" type is selected during import.

There are two options:

• Create new hazard situations
• Update existing hazard situations

Creation of new hazard situations

When importing a file, HITGuard uses the data set ID in the import file to check whether it already exists or not. If it does not exist, it is created again.

To create a new hazard situation, you must fill in the mandatory fields

• Record ID
• designation

must be available and filled in. Only if this is the case, the import is feasible.

Furthermore the fields

• Abbreviation
• Description
• Probability of occurrence
• Extent of damage

can be assigned.

If the Damage Extent or Probability of Occurrence fields are assigned, then only content that matches the existing HITGuard classes is valid. For more information, see Probabilities of occurrence or Extensions of damage.

Updating hazard situations

If the record ID of the hazard situation is found during the import, no new hazard situation is created, but the existing one is updated. That means: The existing fields of the import file update the already existing fields such as designation, description, responsible person, etc. This enables the maintenance of individual hazard situations.

Template

• Import Vorlage Gefährdungslage.xlsx

Import business processes

To import business processes, the "Business process" type must be selected during import.

There are two options:

• Create new business processes
• Update existing business processes

For information about responsible persons see User management.

Creation of new business processes

When importing a file, HITGuard checks whether a business process already exists or not based on the record ID in the import file. If none exists, the business process is created.

To create a new business process, you must fill in the mandatory fields

• Record ID
• Designation

must be available and filled in. Only if this is the case, the import is feasible.

Furthermore the fields

• Abbreviation
• description
• parent business process record ID

can be assigned.

If the parent business process record ID is assigned, a business process with this ID must either already exist in HITGuard or be created in this import. Furthermore, no cycles may exist. Cycles exist if, for example, business process A has entered business process B as its parent ID and business process B has entered business process A as its parent ID. The importer recognizes these cycles, prevents the import and refers to the cycle error.

Update business processes

If the record ID of the organizational unit is found during the import, no new business process is created, but the existing one is updated. That means: The existing fields of the import file update the already existing fields like description, abbreviation, responsible person or superior record ID. This enables the maintenance of individual business processes or business process structures.

Example:

It is decided to create a new business process that is parent to already existing business processes. In this case, the already existing business processes can be subordinated to this new business process by changing their parent ID.

Template

• Import Template Business Process.xlsx

Import organizational units

To import organizational units, the "Organizational unit" type must be selected during import.

There are two options:

• Create new organizational structures
• Update existing organizational structures

For information about responsible persons see User management.

Creation of new organizational units / structures

When importing a file, HITGuard uses the data set ID in the import file to check whether it already exists or not. If it does not exist, it is created again.

To create a new organizational unit, you must fill in the mandatory fields

• Record ID
• designation

must be available and filled in. Only if this is the case, the import is feasible.

Furthermore the fields

• abbreviation
• description
• parent OU record ID
• street
• postal code
• city
• country
• sort order

can be assigned.

If the parent OU record ID is assigned, an organizational unit with this ID must either already exist in HITGuard or be created in this import. Furthermore, no cycles may exist. Cycles exist if, for example, organizational unit A has entered organizational unit B as its parent ID and organizational unit B has entered organizational unit A as its parent ID. The importer recognizes these cycles, prevents the import and refers to the cycle error.

Update organizational units / structures

If the record ID of the organizational unit is found during the import, no new organizational unit is created, but the existing one is updated. That means: The existing fields of the import file update the already existing fields like e.g. country, address or person in charge. This enables the maintenance of individual organizational units or larger organizational structures.

Example:

It is decided to create a new department that is superior to already existing organizational units. In this case, the already existing organizational units can be subordinated to this new department by changing their parent ID.

Template

• Import Vorlage OrgEh.xlsx

Import resources

To import resources, the "Resource" type is selected during import.

There are two options:

• Create new resources
• Update existing resources

For information about responsible persons see User management.

Create new resources

When importing a file, HITGuard uses the record ID in the import file to check whether it already exists or not. If it does not exist, it is created again.

To create a new resource, you must fill in the mandatory fields

• Record ID
• and Description

must be available and filled in. In addition, all prerequisites of the user administration apply if responsible persons are entered (see User administration).

Furthermore, the fields:

• Description
• and model segment

can be assigned.
In the model segment, the following values are allowed: "Application Level", "IT Infrastructure Level", "Physical Security" and "Process Level". If the field is not assigned, the resources are assigned to the model segment "Application Level".

Update resources

If the record ID of the resource is found during the import, no new resource is created, but the existing one is updated. That is: the existing fields of the import file update the already existing fields.

Template

• Import Vorlage Ressource.xlsx

Import measures, controls and test questions into knowledge databases (WDB)

The importer offers the possibility to import measures, controls and/or test questions into an existing knowledge database. For this purpose, the type "WDB" is selected for the importer. Then, the knowledge database into which the measures, controls and test questions are to be imported is specified. This must be a knowledge database that has not been published.

In order to import measures, controls and or check questions, the fields

• Title
• Record ID

must be assigned.

Caution: If the record ID already exists in the WDB, no new record is created, but the old one is updated.

Furthermore, in all tabs there are the fields:

• Outline
• Description
• Status : Date value

In the Question tab, there are also the fields:

• Question
• Type of question : This defines the type of the test question. Allowed values of the field are: "process question" or "technique question. Process questions can be answered with score 1 - to score 5, technology questions with Yes/No/Partial. If the column is not filled, all test questions will be imported as technique questions.

Note: For an import, columns from all three tabs do not have to be assigned. So you can import test questions, measures or controls separately.

Templates

• Import Vorlage Prüffrage.xlsx
• Import Vorlage Maßnahme.xlsx
• Import Vorlage Kontrolle.xlsx
• Import Vorlage PF M K.xlsx

User management

When importing organizational units, data categories and resources, a responsible person can optionally be specified.

If only the user name is specified, the responsible person is only assigned, but not changed. So if the user already exists and does not need to be updated. In the "Responsible" tab, all fields except for the user name can be ignored. However, with the help of the importer it is possible to update or create users.

Creation of a new user

If a responsible person is entered during import that has not yet been created in HITGuard, there are two variants of how HITGuard handles this:

1. Active Directory Integration is disabled:

   The user is created completely new, so that this can be performed, the mandatory fields of the responsible person must be present and entered in the import file. These are:

   • Username
   • E-mail
   • Password (between 10 and 20 characters, with at least 3 of the 4 criteria special characters, upper case, lower case and digits)

   

   mandatory fields when creating a new user

   
   

2. Active Directory integration is enabled:

   If Active Directory Integration is enabled, only users that exist in Active Directory can be created. However, the first name, last name and email fields can still be assigned. This means that it is possible to change the user's data during import and thus add or correct any errors or information from the Active Directory that is not maintained in HITGuard.

Update users

It is possible to update users with the help of the importer. This is useful, for example, if the e-mail or last name of a user changes. The importer checks at each import, if a user is entered, if additional fields like e-mail, last name, etc. exist in the import file, if yes, the content of these fields will be updated with the new content.

This makes it possible to keep information in HITGuard about users that do not exist or are not maintained in the Active Directory. It should be noted that HITGuard does not update the Active Directory!

Deactivated users

If a deactivated user is entered or updated as the responsible person during an update, this user is not activated as a result, i.e. he does not change status. However, he will be updated and entered as the responsible person.

Structure of an import file

The importer supports two format types:

• CSV
• Excel files

Excel

The structure of an Excel file consists of a table in which all relevant data is represented as a column in a table. Each row corresponds e.g. to a new organizational unit or other structure to be imported. During import, depending on the structure, the first row can or must be skipped if this row is the column header.

Example of an Excel import

CSV

The structure of a CSV file usually consists of one line, in which the column headings are separated by semicolons. Each additional line contains information about the structure to be imported. It is important that each line has the same number of columns (i.e. the same number of semicolons). Depending on the structure, the first line can or must be skipped during the import if this line contains the column headings.

Example of CSV importt