Casamaba Punch Import - Revision history

Stage at 03:37, 2 May 2016

2016-05-02T03:37:55Z

Stage at 03:36, 2 May 2016

2016-05-02T03:36:24Z

Stage at 03:34, 2 May 2016

2016-05-02T03:34:08Z

Stage at 03:33, 2 May 2016

2016-05-02T03:33:51Z

Stage at 03:32, 2 May 2016

2016-05-02T03:32:59Z

Stage: 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" |- !..."

2016-05-02T03:26:00Z

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" |- !..."

New page

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"

|-
! Column Type
! Identifiers
! Notes
! Required

|-
| Employee Identifier
| Employee ID, Emp ID, ID, Employee Number, Clock_ID, Payroll_ID, SSN_ID
| This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. With a multi-facility configuration you must also provide the Facility column.
| Yes

|-
| Punch Date Time
| Punch Date, Punch Time, Punch Date Time
|
| Yes

|-
| Punch Type
| Punch Type
| In, Out, Back From Break, Back From Lunch
| No
|}

== See also ==

* [[Import]]

@@ Line 26: / Line 26: @@
 | 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
 |}

@@ Line 20: / Line 20: @@
 | 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

@@ Line 14: / Line 14: @@
 | 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. John Smith (1234) will look for an employee with the employee ID of 1234. 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

@@ Line 14: / Line 14: @@
 | Employee Identifier
 | 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. John Smith (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

@@ 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.
 {| class="wikitable"
@@ Line 11: / Line 13: @@
 |-
 | Employee Identifier
-| Employee ID, Emp ID, ID, Employee Number, Clock_ID, Payroll_ID, SSN_ID
+| Therapist
-| This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. 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. With a multi-facility configuration you must also provide the Facility column.
 | Yes
 |-
-| Punch Date Time
+| Punch Date
-| Punch Date, Punch Time, Punch Date Time
+| Activity Date
+|
 | Yes
 |-
-| Punch Type
+| In and Out Punch Times
-| Punch Type
+| TimeInOut
-| In, Out, Back From Break, Back From Lunch
-| No
+| Yes
 |}