Bulk Employee Group Import Error: IndexOutOfRangeException

Bulk Employee Group Import Error: IndexOutOfRangeException

Issue:
When trying to import bulk employee groups using the Employee Details import, I receive this error:



Cause:
This error is commonly caused by:
  1. The removal of column I in the template.
  2. Columns in the template have been reordered.
Solution:
Check the template you have used matches the one provided in our guide article.
    • Related Articles

    • Bulk Employee Entry Import Guide and Template

      The Employee Group Import or Payroll Import allows you to easily bulk import a number of employees and their salary components into different cost centres or departments into Forecast 5. Go to the attachments tab to download the guide and template.
    • Import Error: SqlException - Unclosed quotation mark after the character string..

      Issue: When trying to import bulk Employee Groups, you receive a similar error message to the ones below:   Cause: This is caused by an apostrophe or quotation mark being entered on the template. Forecast 5 is built on an SQL database and the SQL ...
    • SQLException: Cannot insert the value NULL into column

      Issue: When importing or copying a forecast, you are are getting the following error: SqlException Cannot insert the value NULL into column 'InputDataBase', table 'Forecast52020.dbo.InputData'; column does not allow nulls. INSERT fails. The statement ...
    • Import Error: SQL Exception: Incorrect Syntax near "s"

      Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...
    • Xero Integration Error: Method Not Found

      Issue: Connection to Xero is OK, but when clicking the import data button an error is reported: Solution: Uninstall and reinstall Forecast 5.