Skip to main content
J. J. Keller Support Center

Import/Export Learners in TMC

Go to Learners > Manage Learners.

clipboard_e9ad8115bb2ce6289be3c5dacdf7c73e6.png

You can also click Manage Learners under the Quick Links on the TMC dashboard.

clipboard_ea9f9f546b008e53fd66f1c752d413d9a.png

ImporT New Users

First, download the Add New Users Template to your device.

clipboard_ee8c634e9b336bdbea3259fe5c22f3d26.png

Accept the terms and conditions.

clipboard_e533fb7a1e5be8122ff8aa3b300952413.png

The Instructions tab in the Learner Import template spreadsheet will guide you through how to fill out the Records tab.

  • Be sure to enter at least the First Name, Last Name, and Location of the imported learners.
  • When finished, it is important that you save the completed template as a Text (Tab delimited) .txt file
    • clipboard_effb996b59a9ba25e6b067ef1935f2cfd.png
  • Note: If you have more than 800 students, split them up into different documents to avoid a time-out within the site.

clipboard_e39c684083d76f7cb5f536b16c968c1a2.png

Records tab where you will enter your Learner information.

clipboard_e87ef3cfce12f60327a15ee36b4954e3b.png

Once you have completed and saved the template, click Import > Import New Users in TMC.

clipboard_e60afc2ebdf262beaa5a4d375fd0a7059.png

Click File Upload to select the template file from you device and upload to the system.

clipboard_e3a07363edca75bdb5192b719aa96163d.png

Click Import.

clipboard_e9dbdc0c9ff6bfbe95fad641f56dced93.png

The imported learners will now display in your learner list.

clipboard_e123a8286f2759fcb3b01c36bd9d933dd.png

 

Import Existing Users

This is a way to update learner information in bulk. 

First, download the Add Existing Users Template to your device.

clipboard_e691606d103b9c49226196d08dfa57bbd.png

Accept the terms and conditions.

clipboard_e533fb7a1e5be8122ff8aa3b300952413.png

The Instructions tab in the Learner Import template spreadsheet will guide you through how to fill out the Records tab.

Be sure to enter at least the First Name, Last Name, and Location of the imported learners.

  • When finished, it is important that you save the completed template as a Text (Tab delimited) .txt file
    • clipboard_effb996b59a9ba25e6b067ef1935f2cfd.png
  • Note: If you have more than 800 students, split them up into different documents to avoid a time-out within the site.

clipboard_ebff055ec12154d2d95e825c228d10b8d.png

Records tab where you will enter your Learner information.

clipboard_e1fff2a5123326370a6b465423c00959d.png

Once you have completed and saved the template, click Import > Import Existing Users in TMC.

clipboard_e9000e56914195fe05e760ff6d12e7322.png

Click File Upload to select the template file from you device and upload to the system. 

clipboard_eab9500c39525af101dc73d7e0cdd716b.png

Click Import.

clipboard_ee9408d0ba1b7d8fbbbf15a2d921379c4.png

 

In the example below, the learner ID was updated:

Before After
clipboard_eef4cb490e256e33a41eb1652d1113a51.png

clipboard_e481bc6e1e1f8f783d8161082c9aa9127.png

 

Exporting

You can export information about a single learner, or in bulk. To export the entire list of learners, first go to the Manage Learners page.

clipboard_e389a7e9cc64ea86c1b4a7fa400511ac2.png

Check the box next to the learner/s to export. To select ALL learners, click the box in the gray header column.

clipboard_e4b86b236c8f0d1d19d4259aa7bb13f3c.pngORclipboard_eadb367b8613fb61e2452b7d6fd05cda9.png

Then, click Export Selected. Select the desired file type.

clipboard_e9f82f90634dd29f9af1dffe83a01965d.png

 

If desired, you can add more columns to this view; this will include the additional information in the exported file.

clipboard_ee715083e4f4799d0e4897b41bb7cd851.png

To export a select list/group of learners, you can use the filter feature to narrow down the results. Perhaps you want to export information by Learner Group; in the example below, the filter is set to display learners from the Maintenance learner group. Now the list can be exported to the desired file type.

clipboard_e11d90b9a87a5827265818e2a586f08ba.png

  • Was this article helpful?