«

»

Project typ “Table import”

1. Function

In case of Table-Import, you can insert, migrate and write the authorizations provided in a table (e.g. Excel-table) in a provided share.

2. Table structure

The table structure expected by migRaven looks as follows:

 

Depth

Path

Read and Execute

Write

Modify

Modify Plus

Full Control

\directory\projectfiles domain\gr1;domain\gr2 domain\gr3

The Column contents

Depth                       Is the directory depth, i.e. the depth below the share, the share thereby forms the level 0
Path                          Is the path, which we want to authorize in this line, e.g. \chief accountant

Columns for the authorizations provided
Read and Execute    Read and Execute
Write                            Write and Execute
Modify                         Modify
Modify Plus                Modify, however denied to delete the top most directory
Full Control                Full access

The field “Depth” is blank. We need it as placeholder for the appropriate column in migRaven.

In field “Path” comes the directory, which we want to authorize. Together with the target path specified while starting the project, results the complete directory path, e.g. \\server\share\directory\chief accountant.

In the following authorization fields , appear the groups and/or accounts, which should get rights in accordance with the column heading on this path, in the form:
domain\object;domain\object;domain\object.

Modify Plus works like the permission “Modify”, with the difference that the deletion of the authorization end point is prevented.

3. Project-Start

While starting the table import, a project name and the target path is expected from you. The target path must be an available share and/or the available sub-directory of a share, in the form \\server\share  oder \\server\share\directory.

Then we can start the table import.

Bulk import

Image 2: Project-Start for the Table-Import

4. Project-Authorization management

The project-authorization management opens. In this table, we find the columns:

 

Depth

Path

Read and Execute

Write

Modify

Modify Plus

Full Control

Status

Image 3: Table structure in migRaven

Following column is added:
Status                     while validating, error messages are entered here

Insert authorizations

In the green row with the marking “+ Click here to add new item”, one can manually add single rows with paths and groups.

It is however sensible to insert a prepared table. In the table calculation, the created table is marked and taken over in the buffer with CTRL-C. It is thereby important to take the column “Depth”, also when it is blank. It occupies the first column in the Grid.

With “Click” and “Enter” on the green row, a blank row is generated. There we click the left field and insert the data with “CTRL-V”.

Insert the table

Image 4: Table-Import: Insert a table in the Grid

5. Import from Excel

An easy way to import data is through an Excel table in a .xlsx file format.

Import from Excel

Image 5: Import from Excel

 

Here we can make changes.
We remove the blank rows, in which we mark the rows in extreme left side and delete with the key “del” (delete).

6. Validate

Because the paths are often not yet available, you should remove the checkmark with “Paths are checked for their existence”.
While validating, one checks whether the specified objects are available in the AD. We must create missing or incorrectly written objects in the AD and read in migRaven with a rescan. In case of several Domain Controllers, it can take some time, till the new objects are replicated on all DCs.

7. Save – Migration of the authorization structure

The authorizations are migrated according to the Best Practice-recommendations of Microsoft. Authorization groups are thereby formed, in which the available groups and accounts are nested. List groups are formed for channeling the underlying authorization endpoints.
The parameters defined by you in the group configuration determine the name format and the type of groups, the list group area and other design features.
Subsequently the new authorization structure is written in the database.

8. Work & Design-Control

In this table, the authorization groups planned by you are displayed. You cannot view the list groups here.

After closing the window, migRaven automatically branches out to the View-Target status. From here starts the process of the three project types of the same type.