Maintaining accurate employee records can be challenging for L&D, HR, and IT teams, and this challenge only grows when using a number of systems and platforms.

In order to reduce the maintenance overhead required to manage the users within your GO1 Portal, we are pleased to offer a data mapping tool (available by request).

This tool allows an organization to update user details in their GO1 Portal to match the data held in their organization's system. It automates the process of adding new users, blocking old users, and details against individual GO1 user account profiles.

Before we begin

The first step is to understand if there is any additional information from the data source you will be using that needs to be stored against the users in your GO1 Portal. 

If it is determined that additional information does need to be captured, custom profile fields can be added to your GO1 Portal by your customer success manager.

Custom profile fields are a means of capturing organizational information, such as role, department, office, or region, against the individual users within your GO1 Portal; with the ability to then segment reporting based on those values. 

Please talk to your GO1 customer success manager to discuss the establishment of your user data feed integration and to determine if the use of custom profile fields is right for your organization.

Getting started

Once the data mapping tool has been added to your GO1 Portal by your customer success manager, you will need a test file of your user data. You can download a template from your GO1 Portal, or use a file extract from your organization's database.

Downloading a user data template from your GO1 Portal

  1. Select your user account icon from the top navigation, followed by the menu item Administer. From the Administration dashboard, select the tab Users: this will take you to Administer > Users report, a list of all of the users on your GO1 Portal. 
  2. Select the more button (...) from the top right of the Users tab, followed by Import
    From the Upload file popup, select the link: Click here to download sample csv file.
  3. A CSV file will download to your computer. Open the file in a spreadsheet application such as Microsoft Excel, and input some test records. 

The records can be dummy data, but the layout of the file needs to be accurate. It also needs to be in an excel .csv format.

Create mapping rules

Navigate to the data mapping tool by clicking on your user account icon from the top navigation, followed by Integrations > User Data Feed.

Click to Get Started. You will be taken to a page prompting you to Select file. Upload your the test user data file that you have pre-prepared to the file field on this page. 

Note: This will not add the users or data to your GO1 portal, this is for mapping purposes only.

Once the CSV has uploaded, the page will then transition to Create mapping rules. Use the dropdown boxes provided to confirm which fields on the portal (left side) equate to which columns from your CSV (right side). 

Status

If you don’t map the Status field from your GO1 Portal to a column from your .csv, all users in the file will be active, meaning that they will be able to log in to your GO1 Portal and complete learning activities. 

The tool will mark users who were created via the user data feed as inactive if their records do not appear in the next user data file.

Role

In order to manage user roles via the data feed, ensure your your data file contains a column which specifies the roles associated with each user in the following the standard GO1 format:

Learner|Manager|Administrator

The tool will automatically mark a user as a manager if their email address is included in the Managers column against any user in your data file.

The data mapping tool merges roles between file and existing roles of users, meaning that if a user is marked as an Administrator via the portal interface, they will remain as an Administrator regardless of the roles listed within the user data feed, and they will also have any roles specified for them within the data file.

Please note: All users are Learners.

Please speak to your customer success manager if you need clarification the portal fields.

Connect your data source

Once you are happy with the mapping, press the Next button from the bottom right hand corner and you will be taken to the AWS Connection Details. 

These details need to be provided to your IT team as they tell them where to send the exported file (referred to as a 'Bucket'), from your database. You will not be able to access the Secret key once you navigate away from this page - make sure you copy the Secret key and paste it somewhere safe!

Once you have copied the details provided to a safe place, select Done. You are now ready to test your data mapping rules by sending a data file to the bucket.

You're all set!

Your setup is now complete on the GO1 Portal. You have created a ‘bucket’, an online folder, where you can now send user data files at your discretion. You have also set the mapping rules that dictate how information in your file corresponds to the user account fields in GO1. 

It's now up to your IT team to push data (in the format as the example csv) to this bucket. As soon as a file appears in your dedicated bucket, our system will import the data it contains, based on the mapping rules you have dictated. It is therefore important for you to control who has access to the access and secret keys for your bucket in order to prevent unwanted data being added to your GO1 Portal.

If you need to edit your data mapping at a later time, you can do so via the User Data Feed settings. Find out more about managing your data feed.

What's the next step?

Please contact your customer success manager for assistance. For any questions regarding the management of users in your GO1 Portal in the meantime, please reach out to our friendly 24/7 support team through our live chat.

Did this answer your question?