array(28) {
  ["bamboohr_incoming_id"]=>
  int(4739)
  ["batchdate"]=>
  string(19) "2025-08-10 23:45:01"
  ["recordtype"]=>
  string(6) "update"
  ["firstname"]=>
  string(7) "Barbara"
  ["lastname"]=>
  string(6) "Newton"
  ["email"]=>
  string(24) "barbaralnewton@gmail.com"
  ["employmentHistoryStatus"]=>
  string(9) "Full-Time"
  ["employmentHistoryStatusEffectiveDate"]=>
  string(10) "2022-07-31"
  ["status"]=>
  string(6) "Active"
  ["location"]=>
  string(0) ""
  ["employeeNumber"]=>
  string(5) "21143"
  ["bambooID"]=>
  string(4) "3876"
  ["address1"]=>
  string(12) "783 Bayou Dr"
  ["address2"]=>
  string(0) ""
  ["city"]=>
  string(6) "Destin"
  ["state"]=>
  string(2) "FL"
  ["zipcode"]=>
  string(5) "32541"
  ["country"]=>
  string(13) "United States"
  ["dateOfBirth"]=>
  string(10) "1961-10-23"
  ["gender"]=>
  int(2)
  ["mobilePhone"]=>
  string(0) ""
  ["emergencyContact"]=>
  string(0) ""
  ["emergencyContactPhone"]=>
  string(0) ""
  ["lasterror"]=>
  NULL
  ["processed"]=>
  int(0)
  ["dateprocessed"]=>
  NULL
  ["processed_empstatus"]=>
  int(0)
  ["processed_date_empstatus"]=>
  NULL
}
</br>---START---Barbara Newton:</br>Lenght of employeeNumber is 5 (a zero would indicate no employeeNumber)</br>did not qualifyarray(28) {
  ["bamboohr_incoming_id"]=>
  int(4607)
  ["batchdate"]=>
  string(19) "2025-10-15 12:45:01"
  ["recordtype"]=>
  string(6) "update"
  ["firstname"]=>
  string(5) "James"
  ["lastname"]=>
  string(5) "Kirks"
  ["email"]=>
  string(36) "michael.jk@recreationinvestments.com"
  ["employmentHistoryStatus"]=>
  string(9) "Part-Time"
  ["employmentHistoryStatusEffectiveDate"]=>
  string(10) "2023-11-24"
  ["status"]=>
  string(6) "Active"
  ["location"]=>
  string(24) "The Track - Pigeon Forge"
  ["employeeNumber"]=>
  string(5) "21014"
  ["bambooID"]=>
  string(4) "4446"
  ["address1"]=>
  string(20) "125 tobodlygo street"
  ["address2"]=>
  string(0) ""
  ["city"]=>
  string(12) "Pigeon Forge"
  ["state"]=>
  string(2) "TN"
  ["zipcode"]=>
  string(5) "37863"
  ["country"]=>
  string(13) "United States"
  ["dateOfBirth"]=>
  string(10) "1971-11-07"
  ["gender"]=>
  int(1)
  ["mobilePhone"]=>
  string(12) "865-453-4777"
  ["emergencyContact"]=>
  string(14) "Leaonard Nimoy"
  ["emergencyContactPhone"]=>
  string(12) "865-428-6634"
  ["lasterror"]=>
  NULL
  ["processed"]=>
  int(0)
  ["dateprocessed"]=>
  NULL
  ["processed_empstatus"]=>
  int(0)
  ["processed_date_empstatus"]=>
  NULL
}
</br>---START---James Kirks:</br>Lenght of employeeNumber is 5 (a zero would indicate no employeeNumber)</br>comparedate: 2026-04-14 employmentHistoryStatusEffectiveDate: 2023-11-24 employmentHistoryStatus: Part-Time</br>22222</br>UPDATE EMPLOYEE: James Kirks STATUS: A</br>UPDATE staff SET first_name = "James"
, last_name = "Kirks"
, email = "michael.jk@recreationinvestments.com"
, phone = '865-453-4777', address = "125 tobodlygo street"
, address_2 = ""
, state = 'TN', city = 'Pigeon Forge', postal_code = '37863', status = 'A',updated = now() WHERE staff_id = 3092<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: Duplicate entry 'michael.jk@recreationinvestments.com' for key 'staff.staff_email_uindex' in /opt/bitnami/apache/htdocs/DCS/cronS_staff_import_functions.php:56
Stack trace:
#0 /opt/bitnami/apache/htdocs/DCS/cronS_staff_import_functions.php(56): mysqli_query()
#1 /opt/bitnami/apache/htdocs/DCS/cronS_add_bamboohr_incoming_to_staff.php(74): updatestaff()
#2 {main}
  thrown in <b>/opt/bitnami/apache/htdocs/DCS/cronS_staff_import_functions.php</b> on line <b>56</b><br />