Difference between revisions of "Casamaba Punch Import"
From sbv.wiki
(3 intermediate revisions by one user not shown) | |||
Line 14: | Line 14: | ||
| Employee Identifier | | Employee Identifier | ||
| Therapist | | Therapist | ||
− | | This is used to uniquely identify the employee by extracting the employee ID from between the open and end brackets. With a multi-facility configuration you must also provide the Facility column. | + | | This is used to uniquely identify the employee by extracting the employee ID from between the open and end brackets, e.g. Smith, John (1234) will look for an employee with the employee ID of 1234. With a multi-facility configuration you must also provide the Facility column. |
| Yes | | Yes | ||
Line 20: | Line 20: | ||
| Punch Date | | Punch Date | ||
| Activity Date | | Activity Date | ||
− | | | + | | Casamba may display this as a 5 digit number starting with 4. This is the numerical equivalent of the date and is allowable. |
| Yes | | Yes | ||
Line 26: | Line 26: | ||
| In and Out Punch Times | | In and Out Punch Times | ||
| TimeInOut | | TimeInOut | ||
− | | | + | | This will display in the format such as 08:00 - 17:00. The in and out times will be extracted from this text. |
| Yes | | Yes | ||
|} | |} |
Latest revision as of 03:37, 2 May 2016
This imports punches from the Casamba software.
A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba".
Column Type | Identifiers | Notes | Required |
---|---|---|---|
Employee Identifier | Therapist | This is used to uniquely identify the employee by extracting the employee ID from between the open and end brackets, e.g. Smith, John (1234) will look for an employee with the employee ID of 1234. With a multi-facility configuration you must also provide the Facility column. | Yes |
Punch Date | Activity Date | Casamba may display this as a 5 digit number starting with 4. This is the numerical equivalent of the date and is allowable. | Yes |
In and Out Punch Times | TimeInOut | This will display in the format such as 08:00 - 17:00. The in and out times will be extracted from this text. | Yes |