Job/Role Bulk Upload errors - Row number mis-match

Owned by Graham Kennedy
Last updated: Jan 11, 2019
1 min read

Problem

Issues/Errors reported by the Job/Role bulk upload process provide a row number mismatch against the actual upload file.

e.g. invalid file detected record at row 8 duplicate job name

Solution

  1. The row number indicated in the error message references the Input row # NOT the Upload Spreadsheet Row #
  2. The actual Upload spreadsheet Row # is the reported row # + 1 (so in the case above the error Row would be Row 9 in the spreadsheet)
The Upload process ignores the Upload Spreadsheet Header row