At Tithely we strive to make data migration as painless as possible. The instructions below will guide you through how to export People, Giving, Attendance, Notes, Attributes, and Groups information out of your current Fellowship One account to be imported into Elvanto.
How to Export People from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for P9400 (top black bar search box) and select v3.2.
-
Select "Ignore This" for Group fields.
-
Select the following fields to display:
-
Household Fields: "Household ID" and “Home Phone”
-
Individual Fields: "Select all fields".
-
-
Select the following Output fields:
-
Separate Email Columns "Yes".
-
Separate Phone Columns "Yes".
-
-
Select the following display options:
-
1stAddress; “Primary” (this selection will trigger the next pull down).
-
These Fields for each Address; “Select all except full address”.
-
-
Select "Excel" as the Output Type.
-
Run Report.
-
When the Report has run, download the file to your computer.
-
Open the file in Excel and Save As a CSV file type.
How to Export Giving from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for G1050 (Core Giving Records v 3.0).
-
Set the following criteria for Return Giving Records:
-
For Based on this date select "Received Date"
-
For Week starts on select "Sunday"
-
Occurring within this Date Range select "Custom Date Range"
-
Occurring after this time select "Ignore This" (If not selected this will cause an error)
-
Occurring before this time select "Ignore This" (If not selected this will cause an error)
-
Belonging to Batches select "Ignore This" (If not selected this will cause an error)
-
-
Set the following criteria for choice fields and configure output:
-
For Page/Sheet select "Ignore This"
-
For Subgroup with Subtotal on select "Ignore This"
-
In the Multi Select Box select Gift Columns to display and:
- All Trans by ID
- ACH,Check,Cash,BankCard
- Batch Date
- Batch Name
- Contribution or Receipt- Contribution Attributes
- Contribution Subtype
- Create Date
- Fund
- Fund account Reference description
- Memo
- Received Date
- Reference (check number)
- Sub Fund -
In the Multi select box select Contributor Columns to display and:
- Contributor ID
- Contributor Full Name
- Contributor Last Name
- Giving Unit ID
- Giving Unit Full Name
- Giving Unit Last Name
- Household, Individual or Organization (needed to get correct name)
- Mem/Envelope # -
In the Multi select box select "Primary Address columns to Display" and select "Ignore".
-
In the Multi select box select "Grand total columns to display" and select "Ignore"
-
-
For the Display total amount field select "Yes".
-
Sort Records by "Received Date & Time".
-
For the Output to labels field select "No".
-
Select Excel as your output type.
-
Run Report.
-
Click on the "Queue" link (top black bar) and when your report is ready download it to your computer..
-
Open the file in Excel and Save As a CSV file type.
How to Export Attendance from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for M1211 Core Attendance Records v3.1.
-
Select the following People options:
-
"Anyone Attending and is Assigned or in a Group"
-
"Anyone Attending and is not Assigned in a Group"
-
Occurring within this time Period -> "Custom Time Range" (we recommend doing a year at a time.)
-
For Return Group Attendance select "Don't Return Group Attendance"
-
For Get these Spans of Care select "Ignore this"
-
For Get these Group Types select "Ignore this"
-
For These Campuses select "Ignore this"
-
For Get these Groups select "Ignore this"
-
-
Select the Activity Attendance options:
-
For List inactive/past Items too? select "No"
-
For Base on the Role/type select "No"
-
Activity Participants
-
Activity Volunteers/Staff
-
For Get these Activities types (Campuses) select "Ignore this"
-
For These Ministries select "Ignore this"
-
For Get these Activities select "Ignore this"
-
For Get these Activity schedules/service times select "Ignore this"
-
For These Report Folders select "Ignore this"
-
For Get These Rosters select "Ignore this"
-
For These Breakout Groups select "Ignore this"
-
For These Volunteer/staff types select "Ignore this"
-
For These Volunteer/staff Jobs select "Ignore this"
-
-
Choose Fields to Display
-
For Activity/Group fields to Display select "Don't Display"
-
For individual fields to Display select Individual ID
-
For HouseHold fields to display select "Don't Display"
-
For Primary Address fields to display select "Don't Display"
-
-
Configure output
-
For Page/sheet Break select "Ignore this"
-
Attendance Columns to display
- Attendance by Activity/Group and Date
- Attendance Totals and Percentages
- For Create Labels/Groups using select "I am not outputting to label or groups."
-
-
Additional Fields - Ignore this section
-
Select Excel as your output type.
-
Run Report
-
Click on the "Queue" link (top black bar) and when your report is ready download it to your computer.
-
Open the file in Excel and Save As a CSV file type.
How to Export Notes from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for M4010 (top black bar search box).
-
Select "M4010 - Core Contact & Note Summary (v2.5)".
-
Enter the following criteria for Contact Data:
-
Return Contacts Belonging to this Level: "Both Household and Individual Level Contacts"
-
List Inactive Forms & Items too?: No
-
For these specific Contact Forms: Pick
-
Return & display these contact items: Ignore this
-
Change in this manner: "All Changes in Period"
-
Occurring within this Time Period: "Custom Date Range"
-
Contact Custom Date on or After: 1/1/1900
-
Contact Custom Date on or Before: current date
-
Currently in this Status: Ignore this
-
Having this Disposition: Ignore this
-
Currently Assigned to This Person: Ignore this
-
And this Ministry: Ignore this
-
-
For Personal Notes Summary:
-
Return Notes Belonging to this Level: "Both Household and Individual Level Notes"
-
Return & Display these types of Notes: Ignore this
-
Change in this manner: "All Changes in Period"
-
Occurring within this Time Period: "Custom Date Range"
-
Contact Custom Date on or After: 1/1/1900
-
Contact Custom Date on or Before: current date
-
Entered/Last Updated By: Ignore This
-
Household/Individual Fields to Display: Ignore this
-
Page/Sheet Break on: Ignore This
-
Sort Records by: "Last Name"
-
Households in Temporary Group will consist of: "I am not outputting to Labels or Groups"
-
-
Select "Excel" as the output type.
-
Run Report
-
Open the file in Excel and Save As a CSV file type.
How to Export Attributes from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for A2501E (top black bar search box).
-
Select "Export Attributes".
-
Select CSV as the output type.
-
Click the "Run Report" button.
Repeat step 4 until you have all the Attribute options you would like to be imported.
How to Export Groups from Fellowship One
-
Login to your Fellowship One account.
-
Go to reports (far right on the menu bar).
-
Search for P9500 (Groups 2.0 Export v2.0)
-
Select the following options:
-
For Return These Pages select Ignore
-
List inactive members/Leaders on Sheet 5 Also? select No
-
-
Select Excel as the output type.
-
Run Report.
-
Click on the "Queue" link (top black bar) and when your report is ready download it to your computer.
-
Open the file in Excel and Save As a CSV file type.
Additional Export Report Names and Report Codes (if applicable)
Organizations (A2505E)
Background Checks (M3751 V 1.1)
Head count for ministry events (M1350E)
Assignments (M1400 v2.7)
Once you have completed your export, click here to learn how to import your information into Elvanto!