private List<Employee> employees(List<Map<String, String>> values) throws ParseException {
List<Employee> retval = new ArrayList<Employee>(values.size());
SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-yy");
for (Map<String,String> val : values) {
Employee emp = new Employee();
emp.setId(Long.valueOf(val.get("EMPLOYEE_ID")));
emp.setFirstName(val.get("FIRST_NAME"));
emp.setLastName(val.get("LAST_NAME"));
emp.setEmail(val.get("EMAIL"));
emp.setPhoneNumber(val.get("PHONE_NUMBER"));
emp.setHireDate(formatter.parse(val.get("HIRE_DATE")));
emp.setJob(ofy().load().key(Key.create(Job.class, val.get("JOB_ID"))).now());
emp.setSalary(Double.parseDouble(val.get("SALARY")));
String comm = val.get("COMMISSION_PCT").replace(",", ".");
emp.setCommissionPercentage(comm.isEmpty() ? null : Double.parseDouble(comm));
//emp.setManager(val.get("MANAGER_ID"));
//emp.setDepartment(val.get("DEPARTMENT_ID"));
retval.add(emp);
}
return retval;