}
private List<Department> departments(List<Map<String, String>> values) throws ParseException {
List<Department> retval = new ArrayList<Department>(values.size());
for (Map<String,String> val : values) {
Department dept = new Department();
dept.setId(Long.valueOf(val.get("DEPARTMENT_ID")));
dept.setName(val.get("DEPARTMENT_NAME"));
String mgr = val.get("MANAGER_ID");
dept.setManager(mgr.isEmpty() ? null : ofy().load().key(Key.create(Employee.class, Long.parseLong(val.get("MANAGER_ID")))).now());
dept.setLocation(ofy().load().key(Key.create(Location.class, Long.parseLong(val.get("LOCATION_ID")))).now());
retval.add(dept);
}
return retval;
}