The Admin Module provides access to additional functionality for the database. To show it, select
Admin in the Left Side Navigation. (This module will only be shown for those with administrator permission.)
There are currently 2 pages within this module:
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.
Awards – provides access to criteria for triggering awards.
Attendance Awards - lists the selected club's attendance award criteria for both Club Attendance and Church Attendance, including in use status, designated term, Absences allowed per term and the Award Item. Use the Edit button
to change details for the selected Club's attendance award criteria. These settings determine when attendance awards are created as club and church attendance are marked on Members > Check-in.