When importing users into Jostle you have a choice of several different sources to import users from - Microsoft Outlook, Active Directory and so on.
Table of Contents
Import users from Microsoft Outlook
Import users from Active Directory
Import users from ERP or HRIS system
Import users from Microsoft Outlook
A) Import your Outlook contacts first by exporting your contacts as a .csv file from Outlook:
- Click the File tab
- Click Options
- Click Advanced ("Advanced command" in the Outlook Options dialogue box)
- Under "Export", click Export.
- In the Import and Export Wizard, click Export to a file, and then click Next.
- Under "Create a file of type", click Comma Separated Values (Windows), and then click Next.
- Under "Select folder to export from", select the contact folder that you want to export, and then click Next.
- Under "Save exported file as", click Browse, select a destination folder, and in the File name box, type a name for the file.
- Click OK.
- In the "Export to a File" dialogue box, click Next.
- Click Finish.
For instructions and additional help with older editions:
Microsoft Outlook 2007
Microsoft Office Outlook® 2003
Microsoft Outlook® 2002
Microsoft Office Excel 2003
Microsoft Excel 2002
- Click Admin Settings at the bottom of the Main Navigation (this will take you where all the Administration settings are located and only those that have admin privileges see this link)
- Go to User Data to/from Other Systems > Import Users CSV
- Click on Microsoft Outlook Contacts
- Click Continue
- Click Choose file
- Navigate to the CSV file you created above on your computer
- Click Upload
- If there are any errors on the file, Jostle provides you with a downloadable report stating which rows contained errors and what the errors were. Once those are corrected, upload the sheet again to add/edit the information.
Import Contributors from Active Directory
A) To import from your Active Directory, first export your users as a .csv file. Here are the fields you will want to export:
- mail (required)
- givenName (required)
- sn (required)
- mobile
- telephoneNumber
- title
- department
- Click Admin Settings at the bottom of the Main Navigation (this will take you where all the Administration settings are located and only those that have admin privileges see this link)
- Go to User Data to/from Other Systems > Import Users CSV
- Click on Microsoft Active Directory
- Click Continue
- Click Choose file
- Navigate to the CSV file you just created
- Click Upload
- If there are any errors on the file, Jostle provides you with a downloadable report stating which rows contained errors and what the errors were. Once those are corrected, upload the sheet again to add/edit the information.
Import Contributors from ERP or HRIS system
A) To import from your ERP or HRIS system, first export your users as a .csv file. The following information is needed for each user when exporting:
- email address (required)
- first name (required)
- last name (required)
- mobile phone number
- office phone number
- title
- department
- Click Admin Settings at the bottom of the Main Navigation (this will take you where all the Administration settings are located and only those that have admin privileges see this link)
- Go to User Data to/from Other Systems > Import Users CSV
- Click on ERP or HRIS system
- Click Continue
- Click Choose file
- Navigate to the CSV file you just created
- Click Upload
- If there are any errors on the file, Jostle provides you with a downloadable report stating which rows contained errors and what the errors were. Once those are corrected, upload the sheet again to add/edit the information.
Import users from CSV (spreadsheet) file
The CSV process can be used to add new users to Jostle or it can be used to update data for existing users. In either case the file can contain some or all of the Contributors in your organization.
For the case of updating it can be particularly helpful to export the current information and use it as a guide. To do this, click the Gear icon and go to Administration settings > User Data to/from Other Systems > Import Users CSV.
NOTE - while the template or the downloaded files contain most of the fields that are available, there are some additional fields that you can use. They are explained in the Template guide.
To reduce the chance of input errors, it is generally considered best practice for your initial import to only include columns for necessary fields. At it's most basic the file should contain columns for:
- Username
- First Name
- Last Name
- Work Email
From there you can add any additional columns for the data you want to set or update. TIP: If you first add some users manually via Administration settings > User Accounts and Data > Create a New User and then do a bulk export, the exported file can be used (as mentioned above) as a guide to populating your bulk import.
The PrimarySupervisorUsername field is a special case and is specifically available for the case when a few new contributors are being added to Jostle and you wish to add then to the Main Organization chart in Teams. In order for this to work the supervisor must already exist in the Main Organization and can only appear once in Main Organization and the contributor is not yet in the Main Organization. To import larger numbers of contributors into Teams charts we recommend that you use the Reports-to import. It is strongly recommended that you do NOT import a CSV that contains a large part or all of your organization if you are including the PrimarySupervisorUsername in the file. (Note: If you import a contributor that is already in Main Organization and you specify PrimarySupervisorUsername then if you specify the same supervisor it will ignore and proceed, however if the supervisor is different it will fail.)
- Download & fill out the Jostle user template.
- When your template is complete, log in to your Jostle platform to begin importing.
- Click Admin Settings at the bottom of the Main Navigation
- Go to User data to/from other systems > Import users (CSV)
- Select Jostle user template.
- Click Choose file.
- Navigate to the CSV file you just created
- Click Upload.
- If there are any errors on the file, Jostle provides you with a downloadable report stating which rows contained errors and what the errors were. Once those are corrected, upload the sheet again to add/edit the information.
Import users from Google Workspace
If you signed up for Jostle through the Google Workspace Marketplace, then you will have an option to import your contributors from there.
- Click Admin Settings at the bottom of the Main Navigation (this will take you where all the Administration settings are located and only those that have admin privileges see this link)
- Go to User Data to/from Other Systems > Import Users from Google Workspace Domain
- Choose to "Exclude specific users" or "Invite all", then click the Import button.
NOTE—The "Edit blocklist" option will upload a CSV file containing the usernames of blocked accounts (the "blocklist") to automatically populate the "excluded users" list instead.
Importing the blocklist is not incremental, meaning that each time a new CSV of blocked accounts is imported, it doesn’t add to the previous import, it replaces it. System Administrators can also export the current list of blocked accounts as a CSV file at any time.
TIP: If you have Jostle turned off for some of your Google users (i.e. in your Marketplace Apps setup for Jostle you selected Status > ON for some), you can click the link "Have Jostle turned off for some Google users?" (shown above) and then on the next screen check the box next to "Only import Google domain users which Jostle platform is turned on" to avoid importing them into your platform.
0 Comments