[USER MANULA] BATCH FILE UPLOAD

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD Preface This documentation is for element batch file upload. Document Control AUTHOR POSITION DEPARTMENT DATE Reyna Jane A. Faderon Computer Programmer II Information Management Service 08 - 11 - 2020 Reviewer POSITION DEPARTMENT NAME Admin Officer V Information Management Service Dennis U. Martin

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD Navigation : UPM HR Information System > Mass Information eXchange: MIX > BEE Spreadsheet Interface > Create Batch > OK Note : Excel file will download and automatically open. Wait until the document is created. Batch file procedures 1. When document has been created, click ‘Close’

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 2. Fill out the file.

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 3. After listing all elements to upload. Click Oracle > Click upload.

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 4. Row to upload : Choose Flagged Rows > Click upload

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 5. Once successfully upload, click ‘Close’.

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 6. Navigate to UPM HR Information System > Mass Information eXchange: MIX > BEE Spreadsheet Interface. Input the created batch name > Click Go > Select batch name below > Select Create Lines > Click Process

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 7. From Element Field : Input the element where the batch will be loaded > Click Go.

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 8. A file will automatically download > click OK to open file using Excel

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 9. Wait for the document to be created > Click close

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 10. Input the effective date of the element > Input the Assignment number of ICS employee > Input the value for Less > Click Add-ins > Click Oracle > Click Upload

UNIVERSITY OF THE PHILIPPINES - MANILA HRIS BATCH FILE UPLOAD 11. Navigate to UPM HR Information System > Mass Information eXchange: MIX > Batch Element Entry > Ctrl F11 > Input the batch name > Click Process > Select Validate > View > Request > Find > Check if Successful Validated > Click close > Ctrl F11 > Input the batch name > Click Process > Select Transfer