Import from CLM Explorer

JW Scheduler supports Importing and Exporting data into a variety of common file formats.

We believe your congregation and person data is your own, and you should be able to Import and Export your data as you wish. We also believe that as true Christians, it is both reasonable and right to allow data exchange between other JW scheduling programs.

Import Persons and Life and Ministry Meeting Schedule (CLM) from CLM Explorer (recommended)

Export from CLM Explorer

  1. Update to the latest version of CLM Explorer
  2. Open CLM Explorer
  3. Click File > Export to Excel
  4. Under Export What?, select Students
  5. On the right side, Tick all Fields to Include
  6. Tick Ensure Field Names in First Row
  7. Untick Launch When Done
  8. Click Export
  9. Save the csv file to a folder on your computer, e.g. Documents
  10. Repeat steps 4-9, but selecting Talk History instead.
  11. You should now have two files called Students.csv and Talk History.csv in a folder.

Import into JW Scheduler

  1. Open JW Scheduler
  2. At Getting Started, click Import Congregation from CLM Explorer
  3. Carefully follow the instructions, then click Import
  4. Select the folder where you saved the two csv files, then click Select Folder.
  5. Your data will now import
  6. Once the Import is completed, the Import Log will appear
  7. Please carefully check the Import Log, then click Save Import Log and Close
    • Note: When you click Save Import Log, you will be asked where to save this file to. Select a location on your computer, e.g. Documents.
  8. If there are any major problems, see Import Problems

Import Persons from CLM Explorer

  • Note: If you have already created a JW Scheduler Congregation, we recommend you first Delete the congregation before importing from CLM Explorer. Otherwise, please follow these instructions to import from CLM Explorer into an existing JW Scheduler Congregation.
  • If the First Name and Last Name exactly matches, the person data will be merged. Otherwise a new person will be added.

Export from CLM Explorer

  1. Update to the latest version of CLM Explorer
  2. Open CLM Explorer
  3. Click File > Export to Excel
  4. Under Export What?, select Students
  5. On the right side, Tick all Fields to Include
  6. Tick Ensure Field Names in First Row
  7. Untick Launch When Done
  8. Click Export
  9. Save the csv file to a folder on your computer, e.g. Documents
  10. You should now have a file called Students.csv in a folder

Import into JW Scheduler

  1. Open JW Scheduler
  2. Click Persons
  3. Click Import
  4. Click from CLM Explorer
  5. Carefully follow the instructions, then click Import
  6. Select the folder where you saved the Students csv file, then click Select Folder.
  7. Your data will now import
  8. Once the Import is completed, the Import Log will appear
  9. Please carefully check the Import Log, then click Save Import Log and Close
    • Note: When you click Save Import Log, you will be asked where to save this file to. Select a location on your computer, e.g. Documents.
  10. If there are any major problems, see Import Problems

Import Life and Ministry Meeting Schedule (CLM) only from CLM Explorer

  • Note: If you have already created a JW Scheduler Congregation, we recommend you first Delete the congregation before importing from CLM Explorer. Otherwise, please follow these instructions to import from CLM Explorer into an existing JW Scheduler Congregation.
  • If the First Name and Last Name exactly matches, the CLM assignment will be added. Otherwise it will not be added.

Export from CLM Explorer

  1. Update to the latest version of CLM Explorer
  2. Open CLM Explorer
  3. Click File > Export to Excel
  4. Under Export What?, select Talk History
  5. On the right side, Tick all Fields to Include
  6. Tick Ensure Field Names in First Row
  7. Untick Launch When Done
  8. Click Export
  9. Save the csv file to a folder on your computer, e.g. Documents
  10. You should now have a file called Talk History.csv in a folder

Import into JW Scheduler

  1. Open JW Scheduler
  2. Click Schedule > Life and Ministry Meeting
  3. Click Import
  4. Click from CLM Explorer
  5. Carefully follow the instructions, then click Import
  6. Select the folder where you saved the Talk History csv file, then click Select Folder.
  7. Your data will now import
  8. Once the Import is completed, the Import Log will appear
  9. Please carefully check the Import Log, then click Save Import Log and Close
    • Note: When you click Save Import Log, you will be asked where to save this file to. Select a location on your computer, e.g. Documents.
  10. If there are any major problems, see Import Problems

Importing Problems

Please see Import Problems

Scroll to Top