Automated employee data updates

Export employee data from your HRMS

It’s likely that your human resource management system (HRMS) can be configured to export your employee data to a file formatted for OrgPlus RealTime, which supports .txt, .csv, .xls and .xlsx. Once you’ve exported employee data from your HRMS, you need to set up your FTP client and built-in scheduler to automatically transfer your employee data source to Insperity’s FTP mailbox. 

Set up the secure FTP transfer to the Insperity FTP mailbox

The FTP transfer uses a secure and managed file transfer application. This application may be an installed client application or a cloud application, depending on vendor and product. Once configured, the FTP client will transfer the employee data source file to your unique Insperity FTP mailbox at the scheduled time.

To use employee photos, set up the FTP client scheduler to transfer those photos to Insperity’s FTP mailbox. Your photos need to be transferred to the folder within the Insperity FTP mailbox labeled “images.”

OrgPlus RealTime supports photo file formats .bmp, .jpg and .png. All photos should be portrait orientation, 100×128 pixels and 72ppi.

Your Insperity FTP mailbox size is limited to 500MB for employee data and photos. 

Setup for Ispwitch WS_FTP client

Your setup wizard may vary slightly, depending on the FTP client your organization uses.

Make sure SSL ports 6980-7000 are open. 

  1. Install the FTP client on the OrgPlus RealTime administrator’s PC. The FTP client must reside on the OrgPlus RealTime administrator’s PC.
  2. Create a label or site name.
  3. Example: OrgPlus RealTime employee data.
  4. Example: OrgPlus RealTime photos (optional).

3. Set the connection type to FTP/SSL (AUTH SSL) **Explicit method**.
Connection_Type

4. Enter the server address: secureftp.orgplus.com
Server_Address

5. Enter the username and password, which:

  • Must be associated with the OrgPlusRealTime administrator
  • Must have username must in Secureftp.orgplus.com|your username (note the ‘pipe’ between the URL and username).

Username_Password

  • Must have an updated administrator password if you change the OrgPlus RealTime administrator’s password.

6. On the Finish screen, click Advanced.
7. Click the Advanced section in the left navigation.
8. Disable Use Passive Mode for data connections.
9. Set Remote Port to 21.

Advanced_Button
Advance_Connection_Detail

10. Click Ok
11. Click Finish (If not prompted, launch your FTP client to connect).

12. Click Trust this Certificate and OK to accept the Insperity certificate.
Trust_Certificate

13. Open the data folder on the right-hand side (destination).
14. Choose the employee data source file or photo files on the left-hand side (source).
15. Click the right pointing arrow in the center.
Please note that your employee data source file name must match the file name of the data source originally uploaded for the domain.
ipswitch-view

Tip: Most FTP clients allow incremental transfers for only new files or files that have changed.

16. Configure the FTP client scheduler in accordance with the application used, if applicable.

Setup for FileZilla FTP client

Your setup wizard may vary slightly, depending on the FTP client your organization uses.

Make sure SSL ports 6980-7000 are open

  1. Install the FTP client. When complete, launch the FTP application to configure.
  2. Select File> Site Manager.

fz-sitemanager

  1. Click New Site.
    1. Name the site
    2. Input Host: secureftp.orgplus.com
    3. Input Port: 21
    4. Protocol: FTP – File Transfer Protocol
    5. Encryption: Requires explicit FTP over TLS *Explicit Method*
    6. Login Type: Normal
    7. User: secureftp.orgplus.com|name@domain.com

Username must be in the following format: Secureftp.orgplus.com|yourusername

(Note the ‘pipe’ between the URL and username.) 

  1. Password: your OrgPlus RealTime password

fz-login-details

  1. Click on Transfer Settings
    1. Select Passive.
    2. Click OK.
      fz-transfer-settings
  2. Click Connect.