The Admin Module provides access to additional functionality for the database. To show it, selectClub module Admin in the Left Side Navigation.  (This module will only be shown for those with administrator permission.) 


There are currently 3 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:

  1. Upload a CSV File - tap/click the button and navigate to the CSV file to upload
  2. 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 buttonEdit buttonto 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.


Leadership Service Awards - shows the attendance criteria for leaders to earn a full service year credit and the service pin. This requirement is evaluated each time club attendance is marked on Members > Check-in. If the leader meets the requirement, the Leader Service record for the current club year is updated to indicate the service counts for 1 year of service and the leader qualifies for the Service Pin Award. 


Lookups – provides management of dropdown lists throughout the app. Select a Category in the main list. All of the related records are shown in the Details pane. Use the Add buttonAssign handbook to create a new record, the Edit buttonEdit buttonto change details about a record, like the in-use status, and the Delete buttonDelete memberto remove a record.


NOTES: 

  • Some tables are locked and do not allow adding or deleting any records. When a table is locked, the add and delete buttons will not be shown.
  • Some records are locked and do not allow editing. Locked records will show a lock icon in the 'Locked' column. These records cannot be edited.
  • If a record is used in the database, it cannot be deleted. If it is no longer needed, in most cases it can be set to not in use.


Lookup categories include:


Base Clubs - locked table, some locked records. Unlocked records allow editing of the Status.

Cell Phone Carriers - 

Church Names - 

City, State, Zip - 

Colors - existing colors cannot be deleted but may be set to not in use. New colors may be added and deleted.

Communication Types - 

Languages - 

Leadership Training - records marked as 'Auto Add to New Leader' will be added for all new leaders and to an existing leader, if needed, when the leader role is set to active.

Locations - 

Positions - 

Relationships -

School Names - 

Section Groups -

States - 

Team Names - 

Titles -