Symptom
Using Data Workbench, you require to Update the Contacts Status from Active to Obsolete. Therefore, you Export the Contacts from the Export view and make the Status modifications to the same file. On uploading the file in the Update view, system throws the error:
Cannot update the data file. Please correct the following errors: 2
CSVHeader :EndDate
Error Information :Invalid date format entered
Solution :Valid date format is "yyyy-MM-dd"
CSVHeader :CreationDateTime
Error Information :Invalid date format entered
Solution :Valid date format is "yyyy-MM-dd" or "yyyy-MM-dd'T'HH:mm:ss'Z'"
Environment
SAP Hybris Cloud for Customer
Reproducing the Issue
To Export the Contacts:
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to Export tab
- In the search field, select the object Contact
- Radio button Select Data
- Select field Contact ID Equals To XXXXX (where XXXXX represents the Contact)
- Select Next
- Export Data
- Go to the Monitor tab and Download the exported file
- Able to see different date formats for the below fields
- Start Date: YYYY-MM-DD
- End date: MM/DD/YYYY
- Creation Date Time: MM/DD/YYYY
- Make the required changes to the field as below:
- Status: 4
- Status Text: Obsolete
- Save
To Upload the file with Contact Status:
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to the Import tab
- Select the radio button Individual Objects
- Go to Update tab
- Select the object Contact
- Select Next and Browse for the file
- Select Upload
- Choose Next
- System throws errors on Date format
Cause
Data Workbench accepts date format YYYY-MM-DD
Resolution
Once you export the CSV file, open the same file with Notepad++
You will be able to see that the Date format is YYYY-MM-DD
Edit the Contact Status and follow the below steps:
- Go to Menu and select the option Encoding
- Select the option Convert to UTF-8
- Save the file on Menu->File->Save as
- Name the file and add the extension .CSV , Example: filename.csv
- Upload this file in Data Workbench
Note: You may use software which is approved by your organization/IT.
Keywords
Date format in Data Workbench, Invalid date format entered, Valid date format , KBA , valid date format is "yyyy-mm-dd" , invalid date format entered , yyyy-mm-dd't'hh:mm:ss'z' , yyyy-mm-dd , LOD-CRM-INT-DWB , Data Workbench , How To