2626329 - Import Tool failing due to error "The Date/Time cell at row 'X' in column 'X' has an invalid cell type. The cell must be formatted as Text."

SAP Knowledge Base Article - Public

2626329 - Import Tool failing due to error "The Date/Time cell at row 'X' in column 'X' has an invalid cell type. The cell must be formatted as Text."

Symptom

After downloading and filling the import data template, the admin is getting an error for date formatting while trying to import the file.

Environment

SAP SuccessFactors Learning Management Systems (LMS)

Reproducing the Issue

  1. Go to System Admin > Tools > Import Data;
  2. Select import data, record type, import option and browse the files;
  3. Click submit;
  4. Schedule or run the job as needed;
  5. Wait for the completion and download the Error Log.

Cause

This is caused by the formatting of the column.

Resolution

  1. Open the file you are trying to import;
  2. Right click on the column for the date then go to formatting cells;
  3. Select text under category and click OK;
  4. Go back to the column and type the date in the format mm/dd/yyyy;
  5. Try to import the file again.

Keywords

import data, tool, lms, sap, template, curricula assignment, invalid cell type, invalid format , KBA , LOD-SF-LMS-ADM , Admin Tools , Problem

Product

SAP SuccessFactors Learning all versions