SAP Knowledge Base Article - Preview

3491918 - Issue when Excel changes the data type from "Date" to "Text" in XML template - Migration Cockpit (Staging)

Symptom

You open an XML template file using Microsoft Excel and find that fields that should have the data type "Date" now have the data type "Text".

When you enter data in such fields and then upload the file to the migration cockpit, the upload fails as the original template data type "Date", that is expected by the migration cockpit is now the data type "String". The upload fails with the following error messages during validation:

  • CNV_DMC_MD_EXTRACTOR 015 "Uploaded file Source data for <template>.xml contains error; see the following messages for details:"
  • CNV_DMC_MD_EXTRACTOR 034 "Incorrect data type for field "<field>" in row <no.> of sheet "<structure>". Type Date expected."
  • LTB/MC 347 "Error occurred while validating file"


Read more...

Environment

The issue was recognized in template files opened using Microsoft Excel on the Windows operating system.

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions ; SAP S/4HANA all versions

Keywords

CNV_DMC_MD_EXTRACTOR 015; CNV_DMC_MD_EXTRACTOR 034; LTB/MC 347; CNV_DMC_MD_EXTRACTOR015; CNV_DMC_MD_EXTRACTOR034; LTB/MC347; regional settings, Date, Text, DateTime, String, Date, Text, XML Template, migration cockpit, LTMC, Excel, Office, Migrate Your Data , KBA , CA-LT-MC , S/4HANA Migration Cockpit , CA-GTF-MIG , SAP S/4HANA Data Migration Cockpit Content , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.