How do I import our list of adorers?

One of the most challenging tasks you'll need to convert an existing chapel to We Adore Him is to gather your adorer information into a single spreadsheet and ensure that the data is accurate. After that, the rest is easy!

We made this process as painless as possible. Here are the steps to import your list of adorers.

Note: You can also create adorer accounts individually.

Also: since every adorer can have multiple commitments, there's a separate process for importing commitments.

Step 1: Prepare the Adorer Data

Please download the We Adore Him Adorers CSV template and open it with your favorite spreadsheet software such as Microsoft Excel, Numbers, or Google Sheets. (CSV stands for "comma-separated values" and is one of several file formats that spreadsheet programs use.)

Then, copy and paste (or type) your adorer information into the template.

Image
Example adorers CSV file

Please note:

  • Leave the headers in the first row and enter your first adorer in the second row.
  • The column order is not essential, and we ignore any columns except those that we expect, so feel free to manipulate this template however you need to.
  • The Name field is required, but the Sort Name field is optional.
    • The Sort Name field is used for sorting (e.g., the adorer's last name).
    • If left empty, the website will automatically generate it from the last word in the Name field.
  • The Password field is optional.
    • Passwords are case-sensitive.
    • If populated, the password should be unique and not shared among multiple adorers.
    • If left empty, the website will generate a random password.
    • If the adorer has an email address, the welcome email will include a one-time login link they can use to set or change their password.
    • If you don't have the adorer's email address, enter a simple password and communicate it personally to the adorer.
    • Learn how adorers can log in if they don't know their password.
  • The Name, Email Address, and Phone Number fields are unique and cannot be shared among multiple adorers. However, there are workarounds.
  • The Gender field is required (but you can make it optional). Enter male or female, or leave it empty if it's optional.
  • In the Language field, enter English or Spanish. If left empty, it will default to "English."
  • In the Notification Preference field, enter email, text, or call, or leave it empty.
  • In the Substitute field, enter Y for adorers who want to be notified of substitute requests, or leave it empty.
  • In the Administrator field, enter Y for adorers with administrative privileges (e.g., adoration coordinators, parish staff), or leave it empty.
  • In the Captain field, enter Y for adorers with elevated privileges (e.g., team captains), or leave it empty.
  • To include postal addresses, populate the Country field with the two-character country code (e.g., US).
    • If you include the country code for an adorer, the system requires all address fields, so leave the country code empty if you don't have their mailing address.
  • If you enabled the Parish Field feature, enter the name of the adorer's parish in the Parish field.
  • If you enabled the Access Code feature, enter the adorer's access code in the Access Code field.
  • In the Notes field, enter internal notes to share with other administrators and captains.

When finished, save the file as a CSV (comma-separated value) file with the .csv file extension. If using Microsoft Excel, select the "CSV UTF-8" option.

Step 2: Review the Welcome Email

The welcome email is sent to an adorer after their account is created on We Adore Him. Learn how to review and customize the welcome email.

Don't want adorers to receive this email quite yet? If you would rather first populate the schedule with their existing commitments (which is a good idea), then we recommend not sending the welcome email to your adorers until after you've populated your schedule (see Steps 4 and 5 below).

Step 3: Import the Adorers

Whew! You just finished most of the hard work.

Now, please visit Admin » Adorers and click the down arrow next to the New Adorer button, and then click Import multiple adorers.

You'll see a place to upload your template file. Choose the file from your computer.

Next, you'll see a checkbox next to Send welcome email. We recommend leaving this unchecked, so they are not notified until after Step 4 (more on this below).

Finally, click the Import button to complete the import process.

Please note: If there are any problems with your import file, the adorers won't be imported, and you'll see some helpful error information. Simply correct the errors and re-run the import. If it's successful, you'll see a confirmation saying so, and every adorer will now appear in the system!

Step 4: Populate the Schedule (optional)

Now, add adoration commitments to the Schedule for your newly imported adorers.

Step 5: Send the Welcome Email (optional)

If you didn't already send the welcome email in Step 3, it's time to do it now. Learn how to send the welcome email to multiple adorers.

Final Thoughts

We are so proud of you. You just muscled through the most difficult part of managing your adoration chapel. Now it's time for smooth sailing with the help of We Adore Him!

Also, it's easy if you ever want to add a new adorer apart from the import process. Visit Admin » Adorers and click on the New Adorer button (learn more).

Back to Help Center