Employee 1095 Import crashes unexpectedly

When we attempt a headers records or covered individual import for the 1095s, we see the import crash and a detail box gives us the a long script of errors, two lines we can make out are:

1. Message=Error calling ExcelImporter.readFileHeaders().
2. Message=DateTime data found with invalid format at cell J2, value: Y

May also see this error:

Program stopped at 'ExcelConversionService.4gl;, line number 130.

FORMS statement error number -15549.

HTTPruntime exception: Bad MIME in Content-type.

When we import our 1095 records, the program crashes.

• Affordable Care Act Report
• Employee 1095
• Import

There is a column (or multiples) that have custom cell formatting, we recommend cell formatting is either General or Text for best practice.

You will need to update the excel file columns and switch the cell formatting to either General or Text.

The easiest way to change the format without affecting the format of the SSN or other data was to save the file as a CSV, close it, and then open that same file back and save as an Excel Workbook. Once completed, all of the fields were formatted as General and able to successfully import the file without error.

Please review the Master Article - Affordable Care Act Year End Reporting for all related topics.