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 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 separates here several objects (groups, accounts) in the same field. If you start excel by double clicking the CSV-file, excel shows the semicolon as separator and does not separate between the fields but between the objects within a field. The original authorization structure is thus not created.
The CSV-file must be thus 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 in 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 separator , and not the semicolon. Thus you get the authorization structure.
Hint: The simplest way is 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.
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 do you enter a group, the group’s gets 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 used group names are available in the AD before reading in the AD with migRaven.
4. Insert table in the Bulk-Import
With the desired changes and additions, you can use this table (without column headings) in migRaven as source for the bulk import.
Press “Open file” to import your Excel-table (.xlsx file).
Image 1: With “Open file”, the table is inserted into the gird.
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 occur occasionally while validating in the status column, then these objects 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.