transform maps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 11:41 PM
Design:
Create a catalogue item with name : Update date of Gift card
Catalogue: Human Resources catalogue
Short Description: Re importing a date of Gift card Receival
Description:
How does it work:
Download the data template from the link below
Ensure to fill the HR case and date details in the Excel sheet
After filling the details attach the file in "Upload the sheet here" field. Submitting without an attachment will generate a pop up error and the operation will not be allowed
Depending on the volume of the records being processed the import might take some time; an automated catalog task will be generated and closed
If any errors or warnings occur,
NOTE:
Do not change the column names of excel sheet.
Variables :
1..custom variable type which holds the widget so that the user can download the Excel sheet Template.
name: Download the Template from here
2.Attachment type variable to upload the Excel sheet template
After Submission it should trigger the transform map to update the HR Case details
Transform map: on sn_hr_core_case_benefits table
Name: Update Gift card dates
Field Maps:
Peer Bonus case Number to Number on the HR Case
Date to Last date of gift card received on the HR case
After submission, the Last date of gift card received will be updated with the date mentioned in the excel sheet.
Then it should clear the Data source attachment and update the RITM and Request to Closed complete.
note to developer: please make sure a new HR case does not get created, anytime the action = insert. ignore must be true.
How can i achieve this???