if office and center names are the same it errors out from for looking for a number in a string on group import. DataImport goes through row by row, col by col and looks for the first match. If the office is the same name it stops, and looks at the next col over for the id but finds the center name instead of a numerical id. You have to check if the cell is a number first, and if not get the next column.
if office and center names are the same it errors out from for looking for a number in a string on group import. DataImport goes through row by row, col by col and looks for the first match. If the office is the same name it stops, and looks at the next col over for the id but finds the center name instead of a numerical id. You have to check if the cell is a number first, and if not get the next column.