Download BadgePass DataSync User Manual

Example source data:
Name
Christmas Day
Teacher Holiday
Date
12/25/2015
3/15/2015
type
Full day
Half day
In this scenario you would map the name column to the name field in the holiday table, the date
column to the startDate field in the holiday table. For duration, since that field is not in the
source data, you would set its default value to 1 as described in Mapping Fields.
For holidayTypeUID you will need to map the UID ( unique identifier ) for the holiday type.
Since only the name and not the UID is available in the source data, you will need to use
BadgePass Query. You would want to build a query like this: