At Tithely, we strive to make data migration as painless as possible. The instructions below will guide you through how to export People and Giving information out of your current Church Windows account to be imported into Elvanto.
How to Export People from Church Windows
Please Note: Church Windows has many versions. For this reason, there are two routes you can take to export your data. Try method one first, if that doesn’t work, please use the second.
Method One:
-
Navigate to: Membership > Reports > Directory > Export. This should open a ‘Print Membership Reports’ Window.
-
Under the People tab:
- Select a membership field: choose Individual #.
- Make selections: Is not Blank.
- Click the + Selection button.
- Check "Members, Visitors, and Terminated/Inactive (if desired).
- Click the "Next" button at the bottom of the screen. This should open a ‘Selections for Membership Report’ Window.
-
In the ‘Selections for Membership Report’ Window, under the Options tab:
- Select Mail Merge/Export.
- Click the + button to add a report. Name it "Tithe.ly People".
- Click the Select Fields button. Select all fields.
-
Under the Export Options section:
- For File, click the ... button and select the location of the export file (Ex: C:\Temp\Tithe.ly People.csv).
- Select Comma as the Delimiter.
- Check Include year on Birth Date.
- Make sure it's not only for children.
- Enter "Tithe.ly People" in the Export Name field.
-
Click the Export button at the bottom of the screen.
Method Two:
-
Navigate to: Membership.
-
Click the Contact List button at the bottom right corner of the window.
-
In the Contact List window click the Print button in the top row of buttons. This will open a Report Format window.
- Select Mail Merge/Export.
- Check Include year on Birth Date.
- Make sure it's not only for children.
-
Click the New + button: This will open a Mail Merge/Export window.
- Title: "Tithe.ly_People".
- File Name: c:\temp\tithe.ly_people.
- Separate fields with: {Comma} ().
- Uncheck Include at End of Record.
- Select the fields to import: click the Add all >> button to get everything.
- Click the OK button.
-
Click the Next button. When the preview of the report appears the export file has been created at the identified location.
How to Export Giving from Church Windows
There are 2 versions of Church Windows. If you have the version that has "Donations" then you can export the givings easily. If you have the version with "Contributions" then you can only export the givings one year at a time to a PDF file.
Donations Version
-
Navigate to: Donations > Reports/Export > Donation Reports > Donations Log Report.
-
In the Donations Log Report Window:
- Filter tab: Set Date Range.
- Column tab: Set Columns & Suppression.
- Select these Columns:
- Trans #
- Donation Date
- Batch Code
- Check #
- Account
- Amount
- Account ID
- Account Name
- Pymt. Method
- Line Item Comments
- Giver Name
- Giver #
- Check Suppress repeating transaction data.
-
Click the Select Print button. This will open a Preview window.
- Click the Disk icon (Export Document).
- Select Excel Document.
- Save the file.
Contributions Version
Please Note: This method produces a PDF file that can be very difficult to process. If the total number of contributions to import is relatively low (1-5 pages) it may be easier and faster to enter this manually. We will still assess files produced by this method, but the work required to produce an importable file from the PDF may exceed the potential amount of time needed to do this by hand.
-
Navigate to: Contributions > Special Functions > Contribution Profile > Change Date.
- Select the year you’d like to export.
- Create PDF.
-
Navigate to: Contributions > Reports > Log Report.
- Click the Select Printer button.
- Select PDF if possible, if not available select XPS.
- Click the Next button.
- Click the Print All button.
- Save the file.
-
Repeat steps for each year you would like to export.
Once you have completed your export, click here to learn how to import your information into Elvanto!