At Tithely we strive to make data migration as painless as possible. The directions below will guide you through how to export People and Giving information out of your current Servant Keeper account to be imported into Elvanto.
Important Note:
Please do not edit the exported files. If you have to, please save them and send them to us as Excel spreadsheets (.xls, .xlsx) and NOT as .csv files.
How to Export People from Servant Keeper
-
Login to your Servant Keeper account.
-
Navigate to "Group" > "Add Group" > "selections and lists".
-
This will bring up the Add/Edit Group Window. Call the Report "Tithely_People".
-
Checklist the search results using "individuals" (not families, circled in image below at the top center).
a) Select a field to search, use "Individual ID"
b) Select how to search the field: "Is not Blank"
c) Enter the item to search for: leave this field blank
d) Add Criteria [+ Add] (click the add button) -
Click the "Select Fields" button (circled in image above on the right side).
-
Select all the fields that you wish to import. You must include "Individual ID" and "Family ID".
Please Note: There are two different icon types you'll see on the field selector.-
2 People red and blue icon = Household/Family
-
1 Blue person icon = Individual
You can have a Family Address and a different Individual Address, however the Excel file will label both as "Address". When you send your export over, please group family-specific fields together in the output so we can tell which ones are for families and which ones are for individuals.
-
-
When done selecting, click the "Save As" and then click "Excel Spreadsheet File".
-
You should now be back at the Group Keeper main menu. Double Click the report "Tithely_People". This will bring up the preview.
-
Click "Options" > "Export Group" > "Excel".
-
Save the file.
How to Export Giving from Servant Keeper
In some versions, some menus and buttons may have different names, but the basic outline is the same.
-
Login to your Servant Keeper account.
-
Open up Contribution Manager.
-
Navigate to "File" > "Save As (Export)" or "Export" > "List Individual Contributions".
-
Check "Show Split Trans Detail".
-
Click the "Individuals" radio button.
-
Click "Select fields" and make the following selections:
a) Select "Individual ID
b) Select "Family ID"
c) Select all fields related to contributions - Account, Amount, Tax, Type, Batch Date
d) Click "Save" -
Check "Include Inactive People".
-
Click the "Find" button.
You may be asked about stopping at 500 rows, just click "NO".
-
Click "Export" and select "Microsoft Excel".
-
Save the file.
When complete, check that the file contains all relevant transactions.
Please Note: Servant Keeper will cut off data if there are too many (over 65535) transactions within the parameters specified. If this is the case for you, then we recommend re-doing the export by using date ranges to split up the data. As a general practice, we do not import giving information that is over 5 years old.
Once you have completed your export, click here to learn how to import your information into Elvanto!