The Database Menu

Top  Previous  Next
Import à DonorsImport just Donors from an Excel or text file. This is a quite easy and flexible option for importing donors from another donor-management program (such as Membership Plus) or, from a spreadsheet program like Excel.

 

Import à DonationsImport just Donations from an Excel or text file, for instance to import recurring monthly donations.

 

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

 

Import à From Church AssistantImports data from The Church Assistant program from Wincrafters.

 

ValidateCheck that your data has not been damaged in any way, e.g. by suddenly turning off your computer while DONATION is working on something.

 

Copy Missing DonorsAllows you to copy missing donors and categories from one year to another.

 

Reassign Envelope NumbersAllows you to reassign the envelope numbers to all or some donors, e.g. at the start of a new year.

 

Split DonorSplits a donor record into two identical ones, e.g. to separate a joint record for spouses into two records, one for each spouse.

 

Merge Duplicate DonorsAllows you to merge duplicate donors.

 

Change Date of DonationsAllows you to change all donations with one specified date to be on another specified date. Generally used if you  realize that you accidentally entered a batch of donations with the wrong date, with the File à One Date Batch Entry menu option.

 

Delete Old DataDelete data from past years, that is at least 2 years old (you can choose how old it has to be, before it gets deleted).

 

Delete All DataDeletes all data from your database, so that you are starting over with a new empty database.

 

Delete Latest YearUsed only in very unusual circumstances, if you have changed to a new year but didn't intend to, to delete that latest year's data. Can only be used if there are no donations in that year so far!

 

Switch DatabasesSwitch to using a database for another organization, or create a new database.

 

SQL SelectCreate simply formatted ad-hoc reports and data extractions using SQL Select statements. (Most users would never use this option, instead using Reports à Custom Report for ad-hoc reports.)