Attendance Import – upload a CSV file and map columns to attendance fields to import attendance data from a church-wide database. Follow the steps:
- Upload a CSV File - tap/click the button and navigate to the CSV file to upload
- Map CSV Columns to Identify Members - person matching may use any of the following:
- Person ID (AWdb's unique identifier)
- External ID (identifier from another database, must be set in AWdb's Member External ID field)
- First Name (or Preferred Name), Last Name, and Birth Date
The Session date is optional. The currently selected club date will be used if not mapped.
3. Map CSV Checkin Columns - select which AWdb fields should be updated from the CSV data.
- Values of 1, true, t, yes, or y (ignoring case) will mark the item as checked.
- All other values will have no effect so that manually entered data is not changed.
- Marking any checkin item as checked will also mark the attendance as checked.
- Attendance awards will be evaluated and created for those meeting the criteria with an earned data of the last club date of the term
4. Review Mappings and Submit - the Field Mappings are shown. When ready, tap/click the Submit button.
A log will be shown with the results of the import.
Gather Emails – provides the ability to Gather Emails or Email-to-Text Phone Numbers. The results are returned and a button provided to copy the results to a clipboard. The results can then be pasted into the Bcc field of an email client. Set the Filters to determine the selection criteria and choose the Email Options to include. For additional details, see this FAQ.
Query – provides the ability to build custom reports by selecting tables and columns to include as well as an option to create custom filters and grouping/sorting options. The results are displayed in a table that allows filtering. Results can then be printed or exported to a CSV file.
*** Shown only for users with admin permission.