Export access rights structures as .csv file

1. Export CSV file

Under the work step "Design & Work" after "Validate" and before "Store", you can display your read authorization structure in a CSV file.

After "Validate" and before "Store", you can display your output-authorization structure in the form of a CSV-file with the button "Export to csv-file".

2. Read CSV file in excel

In this CSV file, the fields must be separated by comma.

Do not use the semicolon, which is the standard separator for excel, as it is separate here several objects (groups, accounts) in the same field. If you start excel by double clicking the CSV file, excel shows the semicolon as the separator and does not separate between the fields within a field. The original authorization structure is thus Note created.

The CSV file must be opened with an editor or viewer. The data is completely taken into the clipboard. Then we start excel and the content of the clipboard is copied to a field, for example in A1.
All data then lands in the first column, and nothing appears in the subsequent columns! The first column is marked and is distributed with the function "Text in columns" under "Data" on the next columns. In addition to this, the coma has to be selected as a separator , and not the semicolon. Thus you get the authorization structure.

Hint: The simplest way to attach a line to the CSV file at the beginning with the content: sep .
With this parameter Excel is told that the comma is to be considered in place of the semicolon as a separator (field separator). Thereby the fields are distributed in the columns, without the detour to the cache.

With the following column superscript the table becomes readable:
Depth, path, inheritance interrupted, empty, read & execute, write, modify, modify plus, full control. These headers can be distributed likewise with the function "text in column" and the comma as a separator on the column.

3. Edit authorization structure

Now you can make changes in the authorizations. You can delete available directories and create new one. You can assign groups to these directories. Depending on the fact, in which column read-execute-rights (2nd column), read-write-rights (3rd column), modify-rights (4th column) or full control-rights ( 5the column). Several groups and / or accounts in a field are separated by a semicolon without space. It is important that the names are available in the AD before reading in the AD with migRaven.

4. Insert table into the bulk import

With the desired changes and additions, you can use this table (without column headings) in migRaven the source for the bulk import.

Press "Open file" to import your Excel table (.xlsx file).

Table import

Image 1: With "Open file", the table is inserted into the gird.

5. Requirements

It is a prerequisite that the entered objects (groups, users) were created before in the AD and migRaven has already scanned these entries. If errors occasionally occur while validating in the status column, then these are missing in the AD or are wrongly written. If the status column shows the error message "No connection to the share", please remove the checkmark for "Paths are checked for their existence".

Before the validation, the checkmark should be removed from the field "Paths are checked for their existence".

The inserted table is the basis for structuring a new authorization structure in accordance with the best practice recommendations of Microsoft.

Permanent link to this post: https://help.migraven.com/en/export-access-right-structures-as-csv-file/