Difference between revisions of "Casamaba Punch Import"
From sbv.wiki
(Created page with "This imports punches from the Casamba software. A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba". {| class="wikitable" |- !...") |
|||
| (4 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | This imports punches from the Casamba software. A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba". | + | This imports punches from the Casamba software. |
| + | |||
| + | A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba". | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 11: | Line 13: | ||
|- | |- | ||
| Employee Identifier | | Employee Identifier | ||
| − | | | + | | Therapist |
| − | | This is used to uniquely identify the employee | + | | 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 | ||
|- | |- | ||
| − | | Punch Date | + | | 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 | | Yes | ||
|- | |- | ||
| − | | Punch | + | | 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 |
|} | |} | ||
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 |
