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, Deckhand, CLM Explorer, Territory Helper, Alba 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

NW Scheduler Import Persons from CSV Excel Sample New World Scheduler

Supported Persons CSV Fields

  • Name
  • FirstName
  • MiddleName
  • LastName
  • Suffix
  • Address
  • Email
  • Email2
  • PhoneHome
  • PhoneMobile
  • PhoneWork
  • Gender
  • FamilyHead
  • FamilyID
  • ElderlyInfirm
  • Child
  • Blind
  • Deaf
  • CustomInformation
  • Notes
  • GroupName
  • GroupID
  • GroupResponsibility (either Overseer or Assistant)
  • Privilege (either Elder, MS or UBP)
  • PioneerStatus (either AP, RP or SP)
  • RPNumber
  • Anointed
  • LDCVolunteer
  • KingdomHallKey
  • CLMStudent
  • AllowedHall
  • Disfellowshipped
  • 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

NW Scheduler Import Field Service Reports from CSV Notepad Sample New World Scheduler
NW Scheduler Import Field Service Reports from CSV Excel Sample New World Scheduler

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:

  • FirstName and LastName, OR
  • PersonID

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

  • Date – Format must be yyyy-MM, e.g. 2023-05
  • 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
  • PhoneMobile
  • Email
  • PublicTalksCanGive (numbers separated by commas)
  • PublicNotes
  • AwayFrequencyPeriod (a number)
  • AwayFrequencyType (either 0 for weeks or 1 for calendar months)

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

Export Data

Compare

Scroll to Top
Scroll to Top