THE MAIN MENU > The Database Menu

This menu starts with an Import sub-menu, then continues with a number of additional options.

Import ⇒ Donors

Import just Donors from an Excel, text or CSV file. This is a quite easy and flexible option for importing donors from another donor-management program, or just from a spreadsheet program.

Import ⇒ Donations

Import just Donations from an Excel, text or CSV file, for instance to import recurring monthly donations, or donations exported from another program.

Import ⇒ Donors and

Donations

Imports both donors and donations from an Excel, text or CSV file containing both types of information on each line of the file.

Import ⇒ PAR Donations

Import only donations from a text import file provided by the United Church of Canada's PAR (Pre-Authorized Remittance) service.

Import ⇒ All Data

Import data exported from other programs. (This is a rather complex option to import the Donors, Donations, Receipts, Organization Info, and Categories.)

Import ⇒ Abundant Donations

Downloads and imports batches of donations from the Abundant online donation system, which is integrated with DONATION. This menu option is only displayed if Abundant has been configured with the Maintenance ⇒ Setup Abundant Online Donations menu option.

Import ⇒ Vanco Donations

Imports donations downloaded from the Vanco online donation system.

Import ⇒ From Membership

Plus	Imports data directly from the database files of the program Membership Plus.

Import ⇒ From GiftWorks

Imports data directly from a GiftWorks database or backup file.

Import ⇒ From PowerChurch

Plus	Imports data directly from your PowerChurch plus database files.

Import ⇒ From Roll Call

Imports data dumped from a Roll Call database.

Import ⇒ From Church

Assistant

Imports data directly from the database files of The Church Assistant program from Wincrafters, which is no longer available or supported.

Import ⇒ From Viansoft

Church Contribution System

Imports data exported from the Church Contribution System from Viansoft, which is no longer available or supported.

Import ⇒ From Geminon

Imports data directly from a Geminon database file.

Migrate Data to DONATION

Online

Migrates from one to three of your last years of data (donors, donations, pledges, receipts, etc.) from your current DONATION database to our new web-based application, DONATION Online.

Bring Data Back from

DONATION Online

This menu option is only visible if you have successfully done a migration to DONATION Online with the previous menu option. It could be used if you tried that, decided to come back to this version of DONATION, and have entered a significant amount of new data in DONATION Online that you don't want to lose. See Migrating Back from DONATION Online.

Validate

Check that your data has not been damaged in any way, for example by suddenly turning off your computer while DONATION is working on something.

Copy Missing Donors

Allows you to copy missing donors and categories from one year to another.

Copy Addresses

Allows you to copy all donor addresses and emails from one year to one or more other years, to get changes you have made in that one year's donor records into the other year's copies of those same donor records.

Reassign Envelope Numbers

Allows you to reassign the envelope numbers to all or some donors, for example at the start of a new year.

Split Donor

Splits a donor record into two identical ones, for example to separate a joint record for spouses into two records, one for each spouse.

Merge Duplicate Donors

Allows you to merge duplicate donors (or non-duplicates that you want to put together, like records for spouses).

Merge Duplicate Donation