Symptom
You need to perform mass update of the check-out date of visits, but you noticed that the update does not occur via Data Workbench, and you need to complete those visits, as you have configuration that does not allow the users to check in in multiple visits.
Environment
SAP Hybris Cloud for Customer
Reproducing the Issue
- Go to the Data Workbench work center.
- Go to the Export view.
- Choose the object Visits.
- To find all visits in your SAP solution that are not checked out of, set up these filters:
Check-In Date/Time: Greater Than: <date that you implemented the SAP solution>
Check-Out Date/Time: Is Initial: None - Export the resulting list of visits and set a check-out date.
- Import the same list of visits that now have a check-out date.
- The import is successful, but the check-out date is not updated.
Cause
[Enter your Cause here...]
Resolution
This is the system expected behavior. Currently is not possible to import check-in date and check-out date.
As work around, you can remove from scope the check-in and check-out validations to set visits that you need to close as "Completed".
Follow the below steps:
- Go to the Business Configuration work center.
- Go to the Implementation Projects view.
- Select the current project.
- Press "Edit Project Scope".
- Go to the Questions step.
- Remove the below question:
- Save the changes.
- Go to the Data Workbench work center.
- Go to the Export view.
- Choose the object Visits.
- To find all visits in your SAP solution that are not checked out of, set up these filters:
Check-In Date/Time: Greater Than: <date that you implemented the SAP solution>
Check-Out Date/Time: Is Initial: None - Export the resulting list of visits and set them to status Completed.
- Import the same list of visits that now have status Completed.
- Reactivate any validation steps in scoping.
See Also
This is documented in our guide in the section Configuring Multiple Visit Check-In Prevention.
Keywords
Visits, Import, Check-Out, Check-In, Data Workbench, Date , KBA , LOD-CRM-ACT-VST , Visit Planning , LOD-CRM-INT-DWB , Data Workbench , How To