Import from CSV

By /

New World 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.

New World Scheduler can import the following from CSV file into New World Scheduler:

Note: If you are importing data from Majestic KHS, Hourglass app, CLM Explorer or TSWin, please DO NOT use these instructions. Instead, please see:

Import Persons from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: If the First name and Last name exactly match any existing person, the person will be merged. Otherwise a new person will be created.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
  3. Ensure your CSV file only contains supported fields
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Persons
  7. Click Import
  8. Click Persons
  9. Click from CSV file
  10. Follow the instructions, then click Import
  11. Your person data will now import
  12. Once the Import is completed, the Import Log will appear
  13. 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
  14. If there are any major problems, see Import Problems

Sample Persons CSV

New World Scheduler Import Congregation from CSV file Sample

Supported Persons CSV Fields

  • Name
  • FirstName
  • LastName
  • Address
  • Email
  • Phone
  • PhoneHome
  • PhoneCell
  • PhoneWork
  • Gender
  • Male
  • Female
  • Privilege
  • Elder
  • MS
  • Publisher
  • UBP
  • RP
  • AP
  • SP
  • RegularPioneer
  • AuxiliaryPioneer
  • SpecialPioneer
  • Missionary
  • Group
  • Anointed
  • Disfellowshipped
  • ElderlyInfirm
  • Child
  • RPNumber
  • Notes
  • DOB
  • DateOfBirth
  • DateOfBaptism
  • DateOfDPA
  • DateOfRP
  • DateOfDisfellowshipped
  • DateOfFirstMonth

Import Emergency Contacts from CSV file into NW Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: If the First name and Last name exactly match any existing emergency contact, the emergency contact will be merged. Otherwise a new emergency contact will be created.
  • Note: Either the PublisherID field must match an existing publisher ID, OR the PublisherFirstName and PublisherLastName must exactly match an existing publisher, otherwise the emergency contact will not be imported.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
    • See Sample Emergency Contacts CSV
  3. Ensure your CSV file only contains supported fields
    • See Supported Emergency Contacts CSV Fields below
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Persons
  7. Click Import
  8. Click Emergency Contacts
  9. Click from CSV file
  10. Follow the instructions, then click Import
  11. Your emergency contact data will now import
  12. Once the Import is completed, the Import Log will appear
  13. 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
  14. If there are any major problems, see Import Problems

Sample Emergency Contacts CSV

NW Scheduler Persons Emergency Contacts Import from CSV Sample CSV

Supported Emergency Contacts CSV Fields

  • PublisherID
  • PublisherFirstName
  • PublisherLastName
  • ID
  • CongregationPersonID
  • Order
  • Name
  • Address
  • Email
  • Mobile
  • Phone
  • Relationship
  • Notes

Import Field Service data from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: If the First name and Last name exactly match an existing person, the Field Service data will be imported. Otherwise data will not be imported.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
  3. Ensure your CSV file only contains supported fields
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Congregation > Congregation Field Service Report
  7. Select the correct month you wish to import data for
  8. Click Publishers
  9. Click Import and confirm your choice
  10. Locate your CSV file and click Open
  11. Your data will now import
  12. Once the Import is completed, the Import Log will appear
  13. 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
  14. If there are any major problems, see Import Problems

Sample Field Service data CSV

New World Scheduler Congregation Field Service Report Congregation Import from CSV Sample Excel

Supported Field Service data CSV Fields

When importing Field Service data in CSV format, the follow fields are required and must exactly match an existing person in New World Scheduler:

  • Name, OR
  • FirstName and LastName

The follow fields are optional and describe the field service data for that person, for the selected month:

  • Placements – number
  • Videos – number
  • Hours – number (may include decimal points)
  • ReturnVisits (number)
  • BibleStudies (number)
  • Credit (number)
  • AP (true or false)
  • Remarks (text)

No other CSV fields are supported.

Import Neighbour Congregations from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: If the congregation name exactly matches an existing congregation, the data will be merged. Otherwise a new congregation will be created.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
    • See Sample Neighbour Congregations CSV below
  3. Ensure your CSV file only contains supported fields
    • See Supported Neighbour Congregations CSV Fields below
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Congregation > Circuits, Congregations & Public Speakers
  7. Click Import
  8. Under Neighbor Congregations, click from CSV file
  9. Locate your CSV file and click Open
  10. Your data will now import
  11. Once the Import is completed, the Import Log will appear
  12. 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
  13. If there are any major problems, see Import Problems

Sample Neighbour Congregations CSV

NW Scheduler Circuits, Congregations and Public Speakers Import Neighbor Congregations from CSV Sample 2
NW Scheduler Circuits, Congregations and Public Speakers Import Neighbor Congregations from CSV Sample 1

Supported Neighbour Congregations CSV Fields

  • Name
  • Circuit
  • KingdomHallAddress
  • WeekendMeetingDay
  • WeekendMeetingTime
  • COBEFirstName
  • COBELastName
  • COBEPhone
  • COBEEmail
  • PTCFirstName
  • PTCLastName
  • PTCPhone
  • PTCEmail
  • Notes

Import Public Speakers from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: If the First name and Last name exactly match an existing Public Speaker, the data will be merged. Otherwise a new Public Speaker will be created.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the Public Speaker Fields
  3. Ensure your CSV file only contains Supported Public Speaker Fields
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Congregation > Neighbor Congregations and Public Speakers
  7. Select the Congregation you wish to import the Public Speakers into
  8. Under Public Speakers, click Import
  9. Locate your CSV file and click Open
  10. Your data will now import
  11. Once the Import is completed, the Import Log will appear
  12. 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
  13. If there are any major problems, see Import Problems

Sample Public Speakers CSV

New World Scheduler Import Public Speakers Sample CSV

Supported Public Speakers CSV Fields

  • Congregation
  • FirstName
  • LastName
  • Privilege (either E or MS)
  • PhoneHome
  • PhoneCell
  • Email
  • PublicTalksCanGive (numbers separated by commas)
  • PublicNotes
  • AwayFrequencyPeriod (a number)
  • AwayFrequencyType (either 0 for weeks or 1 for calendar months)

Import Territories from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: At this time, map data or coordinates are not able to be imported
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the Territories Fields
  3. Ensure your CSV file only contains Supported Territories Fields
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Congregation > Territories
  7. Click Import
  8. Select Territories from CSV file
  9. Locate the CSV file on your computer, and click Open
  10. Your data will now import
  11. Once the Import is completed, the Import Log will appear
  12. 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
  13. If there are any major problems, see Import Problems

Sample Territories CSV

New World Scheduler Import Congregation Territories Sample CSV Text
New World Scheduler Import Congregation Territories Sample CSV Microsoft Excel

Supported Territories CSV Fields

New World Scheduler supports the following Territory fields only. The fields (or HEADER row) must be named exactly as below (not case sensitive). They must be in English exactly as shown.

  • Number (must be a number only)
  • Area
  • TypeCode
  • TypeName
  • Suffix
  • Link
  • Notes
  • Notes1
  • Notes2
  • CustomNotes1
  • CustomNotes2

Import Territory Assignment Records from CSV file into New World Scheduler

  • Note: If you have not already done so, please Create a New Congregation
  • Note: Either the Territory Number + Territory Code, OR the Territory ID must exactly match an existing Territory, or the import will not work
  • Note: The Publisher name must exactly match an existing publisher, or the import will not work.
  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the Territory Assignment Records Fields
  3. Ensure your CSV file only contains Supported Territory Assignment Records Fields
  4. Ensure your CSV file is saved with the extension .csv
  5. Open New World Scheduler
  6. Click Congregation > Territories
  7. Click Import
  8. Select Territory Assignment Records from CSV file
  9. Locate your CSV file and click Open
  10. Your data will now import
  11. Once the Import is completed, the Import Log will appear
  12. 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
  13. If there are any major problems, see Import Problems

Sample Territory Assignment Records CSV

New World Scheduler Import Congregation Territory Assignments Sample CSV Text
New World Scheduler Import Congregation Territory Assignments Sample CSV Microsoft Excel

Supported Territory Assignment Records CSV Fields

New World Scheduler currently supports the following Territory Assignments fields only. The fields (or HEADER row) must be named exactly as below (not case sensitive). They must be in English exactly as shown.

  • TerritoryID (optional)
  • TypeCode
  • Number
  • DateCompleted
  • DateAssigned
  • Campaign
  • Publisher

Important: New World Scheduler must be able to identify which existing Territory this territory assignment is for. New World Scheduler will try 2 methods:

  • TerritoryID matches an existing Territory ID, OR
  • TypeCode and Number matches an existing Territory.

Additionally, the Publisher field must exactly match the Display Name of an existing publisher or the Publisher will not be assigned.

Problems Importing CSV files

If you have problems Importing from CSV:

  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
  3. Ensure your CSV file is saved with the extension .csv
  4. Ensure your CSV file only contains Supported CSV Fields
  5. If you have done all of the above and still have problems, please Contact Us for assistance. Please include a copy of the CSV file and screenshots of the steps you are performing, and any errors.

Additional Help

Import Data

Import from Program

Other

Scroll to Top
Scroll to Top