Initial Setup > Setting Up Coded Fields > Auto-Expanding Code Tables

Configure, Auto-Expand Code Tables

If you have imported a lot of donor data into DonorQuest which includes coded fields, you may wish to have DonorQuest auto-populate the code tables for you with the unique new codes. Clicking on Configure, Auto-Expand Code Tables will cause DonorQuest to go through your entire donor database, including all past entries, looking for codes which exist in the database but are not on the drop-down lists for the various coded fields, expanding the drop-down lists to include any such codes. This is something you may want to do when you are initially moving your data from another fundraising system to DonorQuest to give you a head start in setting up your code tables. You will still need to enter the proper description for each code manually once the codes themselves have been added to the various code tables, and you do this using the Configure, Edit/Print A Code Table option. However, auto-expanding your code tables once you have had DonorQuest in operation for years is not something you generally want to do, as it will have the effect of bringing back every obsolete code you have used in the past, including any obsolete codes you have deleted over time from the drop-down lists supporting the code tables. If you run this procedure by accident, you may restore all of the code tables to their previous state by copying the file CodeTbls.dbf from one of the backup folders DonorQuest creates automatically to the \DQuest\System\ folder, replacing the current (live) file. Be sure no one is using DonorQuest when you do this. If you do this, you also need to run the System, Index, System Tables option. To restore previous code tables for the cloud version of DonorQuest, please contact DonorQuest Support and request the action be done for you.