/** Validate Student entries */ public void validateStudent() { String file = "student.csv"; // CHECK ALL ENTRIES FOR BLANK FIELDS for (int i = 0; i < entries.size(); i++) { boolean rowHasMissingFields = false; // Line Number. First row (index 0) is data row. So +2 to get line number. int line = i + 2; ArrayList<String> rowMessageList = new ArrayList<>(); String[] row = entries.get(i); rowHasMissingFields = tool.rowHasMissingFields(row, rowMessageList); if (rowHasMissingFields) { blacklistedEntries.add(row); String[] message = rowMessageList.toArray(new String[0]); errorList.add(new BootstrapError(file, line, message)); } } // STEP 2: CHECK ALL FOR duplicateUserid and invalidEDollar for (int i = 0; i < entries.size(); i++) { boolean rowHasDuplicateUserId = false; boolean rowHasInvalidEDollar = false; int line = i + 2; ArrayList<String> rowMessageList = new ArrayList<>(); String[] row = entries.get(i); // if not already blacklisted due to error if (!blacklistedEntries.contains(row)) { // if there are duplicates, the latest/bottomest row will be accepted. // The earlier rows will be errored. rowHasDuplicateUserId = tool.rowHasDuplicatePrimaryKey("userid", row, line, rowMessageList); rowHasInvalidEDollar = tool.rowHasInvalidEDollar(row, rowMessageList); // Blacklist row if any of the validations blacklistedEntries are "true" if (rowHasInvalidEDollar || rowHasDuplicateUserId) { blacklistedEntries.add(row); // add row to blackList String[] message = rowMessageList.toArray(new String[0]); errorList.add(new BootstrapError(file, line, message)); } } } // method ends }