SAP Knowledge Base Article - Public

2131378 - Undefined Date Format When Uploading a Migration Template

Symptom

You are uploading a migration template via Migration Tool, however you get a date format error.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center.
  2. Go to Implementation Projects view.
  3. Open the activity list of the relevant project.
  4. Open activity Migration of Accounting Transaction Data.
  5. Click Migrate accounting transaction data using the migration tool.
  6. Select the migration unit that you are using to migrate or create a new migration unit.
  7. Click Execute Migration.
  8. In the Process Files step, Click Upload File for one of the migration elements (e.g. Fixed Assets, Open Items Payables, etc.)
  9. Browse your xml migration file and start the upload.

A dialog window is shown stating an Undefined Date Format. The messages can be as follows:

  • 'File contains some date values for which the format could not be determined. Correct these entries before executing migration.'
  • 'Some date entries are in error; enter dates in the format YYYY-MM-DD HH:MM:SS before initiating the migration'

Cause

The attributes that carries a Date parameter, such as Document Date and/or Base Line Date, Depreciation Start Date, Deactivation Date (depending on the template being used) have one or more records in the file with, for example, time details alongside the Date. The cells itself are formatted to display only date information, hence you have to select the concerned cell and refer to its content in the Formula Bar.

Resolution

In order to be able to upload your excel file and process it in the migration tool, you have to remove the time details so that the fields are populated only with Date.

In case you have many records, you may copy all the column content to a Notepad, you'll see that only the Date is copied due to cell formatting, and copy the Notepad content back to the excel file only with Date information.

You must review your file and make sure that all the records have the correct date assigned back, before you upload the same into the system.

Keywords

Migration, Date Format, Fixed Asset, Migration Tool, Open Items Payable, Open Items Receivable. , KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To

Product

SAP Business ByDesign all versions