The MissionInsite Export
With the MissionInsite Export, you can export data from Realm for use in MissionInsite.
MissionInsite lets you “plot” congregants on a mapping interface. From this plot, you can determine the size of your ministry area, visualize potential small group locations, identify potential ministry or church planting opportunities, and more.
With the MissionInsite Export, you can export your Realm data, review and update some fields in Excel or Google Sheets, then import your file into MissionInsite’s People Plot.
Export Data for Realm
Before you can plot congregants in MissionInsite, you must export your congregants' names, addresses, and other related information from Realm. You can do this by selecting a saved custom query.
- In the top-left corner, click your ministry hub then Realm. Then click .
- Click the Select a saved custom query text box, then select the custom query from the drop-down menu.
- To create the export from the custom query, click Run.
- To display the export, refresh the page. The export’s title includes the current date.
- To download the export, click , then click Download.
Review the MissionInsite Export
You must review certain fields before importing data into MissionInsite.
After downloading the MissionInsite export, you can open the file in Microsoft Excel or import it into Google Sheets.
Columns B-H include the most vital fields and the only data points required for a successful upload. Data in other columns is optional and is not required to plot congregants.
Field | Updates and Information |
---|---|
First and Last Name (Columns B and C) |
First and Last Names serve as the labels for each relative point on the MissionInsite map. The export contains all donors, so company names may display in the Last Name field. If you don’t want to upload companies, delete those rows from the export file. |
Address (Columns D-H) |
Since you’re plotting data on a map, addresses are very important. Be sure to clean up the following issues.
|
Primary Phone and Email (Columns I and J) | In MissionInsite, primary phones and emails display when you click a mapped location but are not required. |
Member Status |
MissionInsite recognizes five member statuses:
In your export, you must change member statuses to match these numbers. You can do this with find and replace. Note: Custom Member Statuses While Realm allows custom member statuses, MissionInsite does not. If you use custom member statuses in Realm, you must change these statuses to one of the five MissionInsite status numbers before importing. |
Member by Means |
MissionInsite recognizes four member by means statuses:
You can plot member by means on maps similar to member status. Before importing the file, be sure your export only contains these status codes. |
Optional Fields |
These fields are optional, but you can upload them to MissionInsite and filter which individuals display when mapping.
We suggest reviewing these fields prior to importing. |
Import Congregants
After reviewing and updating your export, you can import your congregant list to MissionInsite and plot people.
To upload people and use People Plot, you must be a Study Manager. You can request access from your Agency Manager.
- Log into MissionInsite with your username and password.
- If your organization has multiple studies, under Which Study Would You Like to Work With?, select your study’s name.
- In the User Assistant, under What Would You Like to Do?, click People Plot.
- Click Upload People, then Next.
- Select a Study and People Type. To add a new people type, click Add New People Type. You can also add attributes for additional fields to upload.
- Click Next
- When prompted, download the people upload template.
- In the downloaded template, enter your congregants' data.
- When your congregants' data is entered and saved in the template, click File input.
- Select your file and click Open. Your file's data displays in the window, along with any errors.
- Correct any errors. After correcting them, click Download to download a corrected .xls spreadsheet file for your records.
- Click Upload. Do not close the upload window until the upload completes.
After uploading, MissionInsite queues and processes your data.
You will receive an email when your upload is complete and when geocoding is complete. Then, you can log in and view your congregants on the plotted map.