Text file | Create Google Users
Rule description
This rule queries the specified text file data source that is in a comma-separated variable format (CSV) and provisions new Google user accounts according to the Action section settings.
NOTE: CSV-file should be in UTF-8 format in case of using letters with an accent: á, ä, é, í, ö, ü and etc.
When to use this rule
Use this rule when you need to create Google users in bulk.
This rule requires a source text file in the comma-separated variable format (CSV). You can use the template CSV file provided with the rule, or create a file in Microsoft Excel and export CSV.
To use a template CSV file:
In the Query section, click the [...] button next to the Select Data Source setting.
Open the Templates folder.
Select the Create Office 365 Users - Template CSV file.
Click Open.
The Query source text file requires the following CSV (comma-separated value) format:
NOTE: User External ID and PhoneNumber must be specified in the CSV file.
FirstName,LastName,Description,PrimaryEmail,ExtIDValue,PhoneNumber
Joe,Smith,test user,joe@domain.com,123abc,+19159969739
Kelly,Jones,test user,kelly@domain.com,456abc,+17864206154Rule settings
Query section
| Setting name | Description |
|---|---|
Select Data Source |
Specify the text file to be imported. The […] (three dots) button allows the user to browse for the file and the Create/Edit button allows the creation or editing of the existing file in the built-in Data Source editor. |
More Options | |
Filter CSV Data |
This setting specifies the filter that can remove data rows from the imported text file that satisfies the specific condition. |
Properties to display |
Each object property defined in this setting matches the column that will be displayed in the Web Portal for this web query. To display additional columns, add the required properties to the Properties to display list. |
Skip user if anchor attribute already exists |
The anchor attribute must be unique in the Data Source. Using the defined Anchor attribute, the rule checks to see if the anchor is already present in the target system. If the anchor is present, then this user was previously created, and the row in the Data Source is skipped. |
Data Source Anchor attribute |
Select a column in the data source that contains the attribute value for identifying and mapping a computer. |
Google anchor attribute |
Defines the attribute in Google to which the Data Source anchor attribute is to be compared. When a new user has been created this value also specifies the Google attribute into which the Data Source anchor is written for comparison the next time the rule is executed. |
Action section
| Setting name | Description |
|---|---|
| Create in | Specify the Google Organizational Unit where the Google users will be created. |
| Account | |
|
Primary email
|
Specify primary email format. |
First Name (FirstName) |
If the Data Source contains a field named FirstName, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. |
Last Name (LastName) |
If the Data Source contains a field named LastName, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. |
|
Alternate email
|
If the Data Source contains a field named AltEmail, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. |
Settings | |
Default Password |
This setting defines the password for the new account. This value can be static text or a field from the Data Source chosen using the Selection button. |
|
Change password at next logon
|
Specify if a user must change the password at the next logon. |
Include in Global Address list |
Specify if a created Google user account should be included in the Global Address List. |
Suspended account |
Specify if the created account should be suspended. |
IP whitelisted |
Specify if a Google account should be added to the email allowlist - a list of IP addresses that are defined as approved to send mail to your Google domain. |
Organization | |
|
Specify a static text value or use the Selector button to choose a field from the Data Source. |
Full-time equivalent (percent) |
Specify full-time equivalent in percent. |
Is primary organization |
Specify if this is a user primary organization. |
External ID | |
Type |
Specify Google user type. |
|
Custom Type Value |
Specify a static text value or use the Selector button to choose a field from the Data Source. |
Phone | |
|
Phone number Type Custom Type Is primary phone |
Specify a static text value or use the Selector button to choose a field from the Data Source. |
Relation | |
|
Type Custom Type Value |
Specify a static text value or use the Selector button to choose a field from the Data Source. |
Output section
This section defines the output format of this rule.
To get more information about this section, please see the Rule Output section article.
Enforce/Schedule section
This section defines the schedule for how often to run the rule.
To get more information about this section, please see the Rule Enforce/Schedule section article.
Comments
0 comments
Please sign in to leave a comment.