Follow

Import Employee Leave Assignments

Import Employee Leave Assignments

1) From the navigation menu, select Administration icon, go to Settings section and select Tools.

2) Select Excel Client link from the options under Tools.

Screen_Shot_2017-04-09_at_8.19.47_PM.png

3) Open and unzip the folder for Excel Client.

4) Open folders in the following order: Excelinteropclient > Import > Core > Use Mappings.

5) Open EmployeeLeaveRequests.import.xml.

6) Specify the <ExternalSystem value=””/> in the opened xml.

xmlexample.png

Note: the External System value can be found from the Administration>Settings>External System.

Screen_Shot_2017-04-09_at_8.32.24_PM.png

7) Verify that the Excel import file has the following format.

 145.png

Note: Make sure that the following fields below are set properly.

  •     ID = Blank
  •     Employee = External Code

This code can be found from the Administration>Settings>Entity Mappings under the Employee from the Select Entity Type drop-down.

Screen_Shot_2017-04-09_at_8.37.17_PM.png

  •     Leave Type = External Code

This code can be found from the Administration>Settings>Entity Mappings under the Leave Type from the Select Entity Type drop-down.

Screen_Shot_2017-04-09_at_8.39.35_PM.png

  •     Accounting Period = External Code

This code can be found from the Administration>Settings>Entity Mappings under the Accounting Period from the Select Entity Type drop-down.

Screen_Shot_2017-04-09_at_8.41.51_PM.png

  •     Order = 0

Note: This is the preference order for employee requests.

  •     Istatus = 0-4

Note: 0=Requested, 1=Rejected, 2=Suggested, 3=Approved and 4=Withdrawn.

  • LeaveStartDate and LeaveEndDate = yyyy-mm-ddThh:mm

8) From the previous Excelinteropclient folder, open the WorkLoud.xla file.

9) Enable Macro feature.

10) Under the Add-Ins menu, select Workloud Interop Addin.

149.png

11) Highlight entries you want to import, including the headers.

150.png

12) From the Workloud Interop Addin drop-down, select Import, then All Supported Imports.

151.png

13) Enter your login information.

Note: Make sure that the Server URL is set to Production.

152.png

14) Press the Login button.

15) From the list select Employee Leave Requests.

 153.png

16) Press the OK button.

17) Optional: Select Run in Background, if you are importing a large number of entries at one time.

154.png

18) Press the OK button.

19) When the import is complete, press the OK button on the pop-up window.

155.png

20) The leaves will now show on the Roster of Workloud (you may need to refresh the page).

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk