If your church has a separate database that can export registration or person data in a Microsoft Excel or .CSV format, the Windows App's Data Import tool can use that as a source file to populate some database information. We recommend using a .CSV file (which can be opened and edited in MS Excel, then saved as file type .CSV). Make sure the file has ONE header row identifying column names.

In the Windows App, under the Tools menu, select the Data Import utility. Review the Introduction tab on the dialog and also under "Step 2: Map the fields" click the button to "Print a Field Mapping Report". This document shows all the fields that can be imported, which will help match our database fields with your exported source file's columns. Pay particular attention to the field mapping notes because some fields like Gender only allow specific valid choices (e.g. Male/Female or M/F but NOT Boy/Girl; or for Grade, use 1, 2, 3 and NOT 1st, 2nd, 3rd)

Once the field mappings are completed, do a test run using an abbreviated source file that contains only 4 or 5 rows then check the results to be sure that all the data was imported into the correct fields. Once you've verified the mapping is correct, run the import procedure on the full source file.

Tip: Be sure every row contains a clubber's first name, last name, and birth date so that proper matching can be done and duplicate records are prevented.