LogoLogo
  • Table of Contents
  • 📖Learn About Empuls
    • What is Empuls?
    • How Empuls Works?
    • Why Use Empuls?
    • What's New In Empuls?
  • 📌Getting Started for Admins
    • Sign Up For Empuls
    • Add Teammates
      • Add Users in Bulk
    • Set Up Awards & Core Values
    • Set Up Budgets for Awards
    • Set Up Automated Greetings
    • Communications & Gifts
    • White-Labeling
      • Email Whitelisting
    • Add In-House Catalog Item
    • Add Money to Empuls Wallet
    • Measure Employee Engagement
    • Connect Through Groups
    • Integrations
      • Single Sign On
        • Azure AD
      • HR Management Systems
        • UKG Pro
        • JustLogin
        • Namely
        • Zoho People
        • Gusto
        • Freshteam
        • Keka
        • Darwinbox
        • Greyt HR
        • Bamboo HR
        • SAP SuccessFactors
        • Page 1
        • PeopleStrong
        • Other HRMS (SFTP)
      • Microsoft Teams
      • Slack
      • Other Integrations
    • Engagement Resources
  • Feed Settings
  • 🎨Getting Started for Users
    • Log in to Empuls
    • Introduce Yourself to Others
    • Update Your Profile
    • Connect Through Groups
    • Appreciate Your Teammates
    • Share on LinkedIn
    • Give Award Nominations
    • Review Award Nominations
    • Gather 360° Feedback
    • Ace The Leaderboard
    • Manage Your Budgets
    • Redeem Your Earned Points
    • Create Support Ticket
  • 🔓Privacy and Security
    • Empuls Privacy Policy
    • Information Security Policy
    • Terms of Use
    • Security Related FAQs
    • 📄Certificates and Compliance Documents
    • User Access Settings
    • Cancellations & Refund Policy
      • User Management
    • Shipping & Delivery Policy
      • Add Users to Empuls
    • Terms & Conditions for Loan
      • Add Users in Bulk
  • 🛠️ Platform Settings
    • User Access Settings
      • User Management
      • Access Controls
      • User Authentication
    • Rewards & Recognition Settings
      • Awards, Values & Gifts
        • Manage Awards
        • Manage Core Values
        • Set up Gift / Send Gift
        • Revoke Awards or Gifts
        • Cost of Living Factor and Multi - wallet.
      • Automations
        • Automated Greetings
      • Automated Budgets
      • In house Catalog
      • Manage Org. Budgets
        • Organizational R&R Budget
        • Add Money to Wallet
    • Billing & Customization
      • Branding & Customization
      • Subscription & Billing
      • Business Information
    • Notification Settings
    • Other Settings
      • Manage Leaderboard
      • Data
  • Integration
    • HR Management Systems
      • UKG Pro
      • JustLogin
      • Namely
      • Zoho People
      • Gusto
      • Freshteam
      • Keka
      • Darwinbox
      • Greyt HR
      • Bamboo HR
      • SAP SuccessFactors
      • Workday
      • PeopleStrong
      • HiBob
      • Other HRMS (SFTP)
    • Miscellaneous Integrations- Linkedln, GIPHY.
    • Collaboration Apps
      • Microsoft Teams
      • Slack
  • 💬Groups
    • Introduction to Groups
    • How To Use Groups
    • Create/Delete Groups
    • Manage Group Members
    • Manage Group Settings
  • 🏆Awards & Recognitions
    • Introduction to Awards
    • Give Awards
    • Approve Nominations
    • Jury Panel based Approvals
    • Leaderboard
    • Certificates
  • 💰Budgets
    • Introduction to Budgets
    • 💰My Budgets
    • Manage Organization Budgets
      • Manage Organizational R&R Budget
  • 📜Surveys
    • My Surveys
      • 360° Feedback for Employees
      • HR Surveys for Admins
    • Org Surveys
      • eNPS Survey
      • Employee Pulse Survey
      • Custom Pulse Survey
      • Interpreting the Pulse Survey Results
      • Recommended Action Items to Improve eNPS
        • Strategic Alignment With the Employees
        • Hygiene Factors at Work
        • Relationships and Culture at Work
        • Recognition and Growth at the Organization
  • ❓Quizzes
    • Get started with Quizzes
  • 👥User Account
    • User Profile
    • Account Statement & Order History
    • Settings
  • 💸 Reward Store
    • Redeem Points
  • 💰Instant Credit
    • Instant Credit
      • 💸Perks & Benefits
        • Terms & Conditions For Instant Credit
  • 📈Reports
    • Live Status Dashboard
    • R&R Dashboard
    • Data Reports
  • 💼Resources
    • FAQs
    • Empuls Product Updates
      • May 2023
      • March 2023
      • February 2023
      • January 2023
    • Employee Engagement Ideas
      • Fun Contests, Ideas and Badges
        • Employee Appreciation Ideas
        • Groups to Create on Empuls
    • Diwali Greetings Resources
    • Women's Day Resources
    • Perks & Discounts Promotion Kit
    • Launch Communication Kit
    • MS Teams App Promotion Kit
    • 🖥️Empuls Software Development Kit
    • 📩Postman Collection
    • Privacy and Security
Powered by GitBook
On this page
  • Introduction
  • Navigate to below mentioned -
  • Admin Settings > Other Settings > Integrations
  • Select SFTP > Add SFTP
  • You get 2 options -
  • Option -1 Your ( Client ) Environment.
  • Option - 2 Empuls Environment
  • Data Fields Required from HRMS
  • SFTP Integration Approach
  • Integration Process
  • Data Validation and Processing

Was this helpful?

  1. Integration
  2. HR Management Systems

Other HRMS (SFTP)

User data integration with Empuls based on Secure File Transfer Protocol

PreviousHiBobNextMiscellaneous Integrations- Linkedln, GIPHY.

Last updated 1 year ago

Was this helpful?

Introduction

This document describes the process for integrating your native HRMS (that do not provide REST APIs) with Empuls for automating user data management.

Navigate to below mentioned -

Admin Settings > Other Settings > Integrations

Select SFTP > Add SFTP

You get 2 options -

  1. To host in your ( Client ) environment.

  2. To host in Empuls environment.

Option -1 Your ( Client ) Environment.

You would be prompted to fill in basic details to establish connection.

Option - 2 Empuls Environment

You may ask for Username and Password from your Implementation consultant or write to us at support@empuls.io And you would receive the credentials. Once done, Click on > Test Connection

Data Fields Required from HRMS

The following data fields need to be shared for all employees in a CSV format. The nomenclature for the file shared should be 'CompanyName_DD_MM_YYYY'.

Data Fields are provided below:

Column

Data Fields

Required / Conditional

Data Type

A

Employee ID

Required

Varchar

B

Email

Required

Varchar

C

First Name

Required

Varchar

D

Last Name

Conditional

Varchar

E

Department

Conditional

Varchar

F

Department Head Email

Conditional

Varchar

G

Designation

Conditional

Varchar

H

Grade Name

Conditional

Varchar

I

HR Email

Conditional

Varchar

J

Manager Email

Conditional

Varchar

K

Cost Centre

Conditional

Varchar

L

Cost Centre Head Email

Conditional

Varchar

M

Business Unit

Conditional

Varchar

N

Site / Location

Conditional

Varchar

O

Joining Date

Conditional

Date

P

Date Of Birth

Conditional

Date

Q

Contact No.

Conditional

Varchar

R

Employee Status*

Required

Varchar

*Employee Status can be Active/Inactive.

The fields marked as conditional depend upon the modules available, the Rewards matrix, etc.

SFTP Integration Approach

Empuls uses the SFTP approach of data transfer, which follows the structure provided in the image below.

Integration Process

1. Empuls team will provide the SFTP folder setup details i.e the Folder link, Username & Password. Please drop your request at support@empuls.io or your account manager.

2. The customer HRMS function is expected to push the CSV file to the SFTP folder. The data should be of the sequence as provided in the Data Requirements section above. The first row should contain column headers. It's recommended you schedule the .CSV file push to the SFPT folder at 11 PM IST.

3. The .CSV file shared will be processed by the Empuls application at 1 AM IST through a pre-scheduled data sync job.

4. The system will log the data sync status and notify the Super Admin of the status of the data update via email.

Data Validation and Processing

Here are the sequence of steps followed for updating employee data on Empuls

  • Empuls scans the folder for .csv files, other format files are ignored.

  • The .csv file is validated against the format as provided in the data requirements section

  • Empuls will validate the data to ensure

    • Mandatory fields are not empty.

    • The data shared matches the standard template wrt to columns.

    • The email id field has a valid email id.

    • The primary email id field has a valid domain (among the whitelisted domain names).

  • The data processing will follow the sequence below:

    • The CSV data is read in rows wherein the email id in the first row is compared with the whole inactive list on Empuls.

      • If the employee account exists in the inactive state on Empuls, Ignore it and proceed to the next row on the csv file

      • If the user does not exist, then the user account is created and flagged as 'Active'. All data fields for the user are updated as per the data in csv file

      • If the user account already exists, the changes in data are scanned and updated on Empuls

    • The process continues until the last row of the csv file is read.

    • The csv file is deleted from the sftp folder and email notification is sent to the super admin.

CONNECTIVITY TEST

If there is no connection established, please check/confirm your public IP.

To test connectivity pls use the command "telnet 22"

Visit the page - to get your current active public IP and confirm if this is the same as what has been whitelisted. If IP is correct, please check with your networking/infosec team if port 22 is allowed for outbound communication.

sftp1.xoxoday.com
https://whatismyipaddress.com/
Integrations Tab shall be found in "Other Settings"
Select SFTP from the list of HRMSs
Click on "Add SFTP" to proceed further