Project type "Table import"

1. Function

In case of table import, you can insert, migrate and write the authorizations provided in a table (eg Excel table) in a provided share.

2. Table structure

The table structure expected by migRaven looks as follows:



Read and Execute



Modify Plus

Full Control

\ Directory \ project files domain \ gr1; domain \ gr2 domain \ gr3

The Column contents

Depth is the directory depth, ie the depth below the share, the level 0
Path Is the path, which we want to authorize in this line, eg \ 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 the 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, eg \\ server \ share \ directory \ chief accountant.

In the following authorization fields , appear in the groups and / or accounts, which should be 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 available share / or the available sub-directory of a share, in the form \\ server \ share or \\ 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:



Read and Execute



Modify Plus

Full Control


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 sensitive 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 important to take the "depth" column, ie 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 to 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 delete 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 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 to be 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 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.
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 can not see the list here.

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

Permanent link to this post: