SAP Knowledge Base Article - Public

2461362 - Imported Visits Have Different Start Date/Time and End Date/Time Than set in Data Workbench Template

Symptom

You are using Data Workbench to import Visits, but the imported visits are displaying different Start Date/Time and End Date/Time than the time maintained in Data Workbench template.

Reproducing the Issue

  1. Go to Data Workbench work center
  2. Click Import
  3. Select Object Visits
  4. Click Download Metadata
  5. Add visit information to the CSV template
  6. Click Next
  7. Click Browse to select the CSV template
  8. Click Upload
  9. Click Next
  10. Confirm field mappings
  11. Click Next until you reach the Review step
  12. Click Import
  13. Go to Visits work center
  14. Find imported visit
  15. Check Start Date/Time and End Date/Time have different time information than maintained in Data Workbench template

 

Cause

The expectation of the system is to get the time in UTC format.

Resolution

The Start Date/Time and End Date/Time should be imported using UTC time format in the CSV template, then the data will be shown in accordance to each Business User defined Time Zone on Personalize ->My Settings.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP Cloud for Customer all versions