Unable to parse zipcode from excel sheet
After Pega upgrade to 8.5, I am unable to parse the Zip code from excel sheet. I am using OOTB java code to parse the excel
final String magicWord = "Column"; com.pega.pegahc.exceltools.ExcelReader er; java.util.Hashtable inMap = new java.util.Hashtable(); java.util.Hashtable tMap = new java.util.Hashtable(); String propStr; String propValueStr;
// 1. list of properties; we could get those from the page, though.. tMap.put("CensusIndicator", "string"); tMap.put("LastName", "string"); tMap.put("FullName", "string"); tMap.put("Zipcode", "string"); tMap.put("DependentRel", "string"); tMap.put("DateOfBirth", "date"); tMap.put("DateOfBirthText", "string"); tMap.put("Age", "string"); tMap.put("CountyName", "string");
If the Zip code contains only numerical values (For ex., 94559), then the parsing is not happening at all. The field is not mapped to clipboard. It works fine for alphanmeric columns from excel but not columns that have numerical data (even though it is declared as Text property in pega). Pls help