private Contact processRow(HSSFRow row, Map headerTable) {
Contact contact = null;
String name = retriveCellData(row, headerTable, "NOME");
List categories = retrieveCategories(row, headerTable);
Companie companie = retrieveCompany(row, headerTable, categories);
if (!name.equals("")) {
contact = new Contact();
contact.setName(retriveCellData(row, headerTable, "NOME"));
contact.setSex(retriveCellData(row, headerTable, "SEXO"));
contact.setStreetAddress(retriveCellData(row, headerTable, "ENDEREÇO"));
contact.setPostalCode(retriveCellData(row, headerTable, "CEP"));
contact.setCity(retriveCellData(row, headerTable, "CIDADE"));
contact.setState(retriveCellData(row, headerTable, "ESTADO"));
contact.setCountry("BR");
contact.setPhone(processFoneNumber(row, headerTable, "TEL RESIDENCIAL"));
contact.setCellular(processFoneNumber(row, headerTable, "CELULAR"));
contact.setEmail(retriveCellData(row, headerTable, "E-MAIL 1"));
contact.setEmail2(retriveCellData(row, headerTable, "E-MAIL 2"));
contact.setUrl(retriveCellData(row, headerTable, "SITE"));
contact.setDepartment(retriveCellData(row, headerTable, "ÁREA"));
contact.setFunction(retriveCellData(row, headerTable, "CARGO"));
contact.setPhoneWork(processFoneNumber(row, headerTable, "TEL COMERCIAL"));
contact.setFax(processFoneNumber(row, headerTable, "FAX"));
contact.setComments(retriveCellData(row, headerTable, "OBSERVAÇÃO"));
contact.setIndication(retriveCellData(row, headerTable, "INDICACAO"));
contact.setCompany(companie);
// contact.setCategory(categoryId);
contact.setCategories(categories);
contact.setUsername(ETEAM_USER);
}
return contact;
}
