transform maps

Burra Mounika
Tera Contributor

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???

0 REPLIES 0