How to Add, Edit or Delete Learners using an Excel Template

Manage Batch User Import and Export in KMx Platform

Once you have logged into the administration side, this guide will help you understand how to use the Excel template to add, edit, or delete learners all at once.

Go to vubizkmx.com

1. Introduction

This tutorial walks you through the batch user import and export process to efficiently manage your organization's user data.
Introduction

2. Access Setup Menu

To start the process, click on Setup.
Access Setup Menu

3. Select Member Administration

Under Site Configuration, select the Member Administration option
Select Member Administration

4. Proceed to Next Step

Click Next.
Proceed to Next Step

5. Choose Batch User Import/Export

Select the Batch User Import or Export option.
Choose Batch User Import/Export

6. Open Batch User Import Help

The options available here are batch user import help guides.
Open Batch User Import Help

7. Export Entire Organization

You can export your entire organization, edit the file, and then re-import it.
Export Entire Organization

8. Export Single User Spreadsheet

You can export a spreadsheet with only one individual on the list.
Export Single User Spreadsheet

9. Export by Personnel Category

You can export the spreadsheet by personnel category if applicable.
Export by Personnel Category

10. Export by Company

You can export the spreadsheet by company if applicable.
Export by Company

11. Export Entire Organization Again

We're going to export the entire organization for edit and re-import.
Export Entire Organization Again

12. Download Excel Template

Clicking this option will download an Excel template that can be opened and edited.
Download Excel Template

13. The User Import Help

The user help can be selected.
The User Import Help

14. Access Batch User Options

This will give you a column by column breakdown of the requirements for the Excel template.
Access Batch User Options

15. View Additional Options

If you have any questions about a specific column of information, please refer to this template and this help guide in order to answer those specific questions.
View Additional Options

16. Select Batch User Import

Once you have made the changes to the Excel template you want and you have saved the file, you can then batch import.
Select Batch User Import

17. Select Saved File

From this screen you can choose the file that you have previously saved.
Select Saved File

18. Upload Selected File

Once you have selected the file, click the upload button.
Upload Selected File

19. View Processing Results

The file will then process. Please note that this might take a few minutes for the file to process.
View Processing Results

20. Close Processing Window

Once this is completed, you can click the close button.
Close Processing Window

21. Complete Batch Process

To complete the process, click done, which returns you to the home screen.
Complete Batch Process
You have successfully managed batch user import and export using the KMx platform. This process allows you to efficiently add, edit, or delete multiple learners at once by using the Excel template and batch import features. For further assistance, refer to the batch user help guides provided within the system.