Update/Import Users
Tag: UpdateUsers
The UpdateUsers function updates selected cloud users within the grid.
<UpdateUsers/>
Tag: ImportUsers
The ImportUsers function imports cloud users within the grid from selected file.
<UpdateOnPremUsers/>
Tag: UpdateOnPremUsers
The UpdateOnPremUsers function updates selected on premise users within the grid.
<UpdateOnPremUsers/>
Tag: ImportOnPremUsers
The ImportOnPremGroups function imports on premise users within the grid from selected file.
<ImportOnPremUsers/>
Tag Attributes
Attributes | Attribute Value | Value Description |
---|---|---|
FilePath | N/A | Input file path |
SkipRows | N/A | Integer (defaults to 0) - The number of rows to skip in input file, up to 10 (arbitrary value). |
HasHeaders | TRUE / FALSE (Defaults to TRUE) - Whether the file has column headers or not | N/A |
SkipValue | N/A | Cell value to be interpreted as 'do nothing here'. Nothing is skipped if this is missing - Optional |
KeyField | N/A | [Update only] name of field used for row matching |
KeyValue | N/A | [Update only] index of column used for row matching (see doc below) |
MailboxType | regular/Equipment/Shared/Room | [ImportUsers only] regular/Equipment/Shared/Room |
CheckDuplicates | TRUE / FALSE (Defaults to TRUE) - Search the grid for existing objects (and skip them) | [ImportUsers, ImportGroup, ImportOnPremUsers, ImportOnPremGroups] |
PrefillWithSelection | TRUE / FALSE (Defaults to TRUE) - Use the current selection to prefill new objects | [ImportUsers, ImportGroup, ImportOnPremUsers, ImportOnPremGroups] |
Column mapping works the same as for 'Select / Filter from file'. If not column mapping is specified, default mapping (the one you see if you do the action manually) is used.
For ImportUsers, "forceChangePasswordNextSignIn" and "forceChangePasswordNextSignInWithMfa" can be set using setParam.
Example Script
<ImportUsers FilePath="shark-1800-Shared.xlsx" HasHeaders="True" SkipRows="0" SkipValue="(-n/s-)" keepalive ="false" CheckDuplicates='true' MailboxType="Shared" >
<SetParam field="displayName" value= "0" />
<SetParam field="userPrincipalName" value= "1" />
<SetParam field="userType" value= "2" />
<SetParam field="mail" value= "9" />
<SetParam field="mailNickname" value= "10" />
<SetParam field="MAILBOXTYPE" value= "26" />
</ImportUsers>