Automating User Updates
For a more hands-free experience, we support user file automation by linking our platform to your HRIS through SFTP.
Employee Data Import Using SFTP
Steps for Setting up SFTP process
- Set up and test
- Create File
- Encrypt File
- Upload Files
- Debugging
Set Up & Test Connection –
- The userName and Password to access SFTP server will be shared individually with the relevant IT person from your team who will lead the Integration
- Try login into respective SFTP account with provided Credentials
- SFTP Server Address :- sftp.gethyphen.com :22
- Enter Username and Password
- In case of any access related issue kindly reach out to Betterworks Engage Team
- Test Connection – You can try uploading any dummy file if you wish to test the connection
- Once Connection is established, tested and is working fine, you can start uploading the data in .csv file format only
- The file can be uploaded either daily, weekly or monthly depending on your requirement
Create File –
Create the file as per the instructions shared below
- File should be in the CSV format mentioned here
- File must be PGP encrypted
- The file name must be employees.<timestamp>
- Make sure to Timestamp the file in the right format (YYYYMMDDHHMMSS)
- For Eg – the file name would look something like this employee.20190420112944
Encrypt File –
Use any of the below PGP tools to encrypt your files in PGP format
SSH key to use for PGP encryption
-------------------- BEGIN PGP PUBLIC KEY BLOCK --------------------
Version: GnuPG v1
mQINBFo7/uoBEADNAkN8G6/jfwM5ZJMp21twIu576LGTFu3rgiChjBWRIubHJ20X
6PQlSG+EJkzOPn/yshS+CAVTnDHbNYbXfkWW6/8wQDMByfdk+qmlIbQvSOLkH5Uw
o0gMQZEaIN7Yyx4PCaAJneFA5Fw0lqoEn7cTSX1fXJDULRGMJa6pPmhFGRS/CvVe
A8i+77quUh0J6ytRHR82NI0FzJhPENXjrzLzFtJ7pXN+9yhAgSw/JMgaF0t/nHBP
oaorSo1BbDrQlURXmqfXusnjVIQ8hVLP0Or/9D0NJ0uJHYuX2XlNP/oY+pc0rlFR
+Ox2uXA6TkyNfEz3a39lh03Xz1C2Bt0nr832Zw4er7K5ex3YHB23fUonLCN2HwpA
tY+QDZ0ZUHGlYUOs0W0Ov9s+FdPLk3+vKp78u3qNrUmESj6+phkKS9pK6x77MrHn
+VR7XKyEyGsf9ba4XWLEiw3TG2gwu3VZcqUW+PQUFSNmHseQIwqafkq+NhiB0QvP
+VuPhTtSioz5M3V5jkOG2bHtPQa1/dKyvQj3EYYO3Sj2IO5jf3+VC5ydZO//cYCu
PTSY2SKLK4Ktg5tgoj0gXA9JkoWaIkz2rN/39WgZ6osEGoMigRMdm8QDVUjKohEu
ZopIlDZRq4LUFYtcWlbiddEVvvzPTw+dOjn9eQFiDJTgzxlOdr2ZuotCowARAQAB
tCBIeXBoZW4gU0ZUUCA8c2Z0cEBnZXRoeXBoZW4uY29tPokCOAQTAQIAIgUCWjv+
6gIbAwYLCQgHAwIGFQgCCQoLBBYCAwECHgECF4AACgkQvKUxZtaTxO/wrA//TMnb
6CJhe9d+ajK7RZ09OVR4guK94tCODMY0s4jRBZME2kwO13wwqw1sMjAsLrnoTy7e
hBEAtKnSQks5lkCwhp16Y4935lp5owxvCNUJpFggtUoUqFGYED0LTxV7fHFfFBoD
rWHdxQE7+ClG/iNdIUUcNmSjxK3R1PkENQs8pBqk4peHXb0kf/CuDkoHP0vedO4V
3pXAB4CNT68KgpkkmPIGo0zP0wC+ShPWUIUuJTcExQMnEt7U6y5CHQLptaTXSOKq
ibY33sltegFpE/Qc1eXEtF0YM5NKC9hrLYnb/Zi9lV33Dzf7GXqMibR2FFnTFZA5
i0UZF/tp2wzMhypjdPC7vsOlkJ1iLSVuhCFkWKjCja48yzXFhhacxGABns9g2mjj
DPM0hAST0eXECOmSF6+yeDezmfDzxXmgPIV6FzdejmITOMG0swd8SoqUk2oP9Zc5
raQJZVEqSa4vCjT7N5eNSgB7IwxaFvoZXTIXBRhBnB/zgnVt4FrTfpNL+FKlDtPl
Spf6LxWtV/2haKtww/puRVF9jZykLpnr+p6FLGEa4NBsAxFpyIneCEM+2QZUQM3R
6S4F55xrztUNhJyP+m8DQ7Uh+pmpZLiB3S6laTsZIPfYngyaKQw1S1B0cS/mZG8s
LNeJdGGeI0Pnob8kTnDdbA5tOAQHah/2eSj1cGW5Ag0EWjv+6gEQAMb2XM3p7S0X
5C5hfrv6fQpT+qIiig662PzrpU7Cb/WyeD2NuUwsuIuz1gjvziAcovJ4Umk5ejte
iBlH3cikTEw7oDycGZGjaE74PXDg7hSeMQLQsogDk5+rn9+sWA3WjJj4+4FcPD/D
1f9qEvZQhP0fd1Pm9XB9CbIbBLtFUlkhTFt8fg8OuhZHXj5aT9AINg1j3DE4lPu1
z6IP1D1+0rV8Ui32J8JlAWhbiTxrrnDy/bZIKS6AqQ1ISC0fnRsWeX8t3P9P06Do
oKFhAZAJQi92lOOxhiuYKI/djv1aiqM8riJxzc1Zdigqg5nVAz43CK1gFu269Sdd
rUTsDnfJFNdD0DuyTm8a0mOd2jZ5i+HqCEEdNBIaC574UvE795YMUVptzMSoTPNw
3ZG1hw87ttSfEaPmQCVa645Rd1LWF2NjhSoeu83V8lvqS5VbjuuM8YeTaqyRXAwS
TMNkf/3d7qB32J/J2Lf8oSejW5sUBQrZoFYlUP0fX3N1M/KPvIJiMUhL/bvsz4oc
jnoOisbK743SpsvfB7O4I9Aj8OofYxkP5qmz5eG+GdmBU881wBESv3k7ltIhOoJR
4+8ZKkJ1hOtcbQr1Jmm1CFd1F9ukPETFvLIfAVtpPQ0feK/hkqobO2fbQWW5q7jA
FRnfkXBwPj/WI82MiRU4JqkwjeYm2ByXABEBAAGJAh8EGAECAAkFAlo7/uoCGwwA
CgkQvKUxZtaTxO/9zQ/9Fm4quItgSuxq+13ZsLwnpKlMLCQrzl02HtRt010C0wTp
OPMqM6mQoqk1Soxm2laVMx+/oG78XDv3m0wJPCsiBEqxK4YgW2EUCayCyPjY4wBD
fBPZKYgTRJe5Txhh7IZvwY+tbluQdKo7IIETDLkizY0MVbyHxe/9fiMc2g5DgU+d
QoqEQKP/C8j1RrBTPtESYyZfldyhlZyfhzU6tAIZWx+t4YlSBg6kU12dmhdF8MEn
R33w6DBHWWGhvjJItXDDKigqhPfR0Shu4neNoJuFzlUF5+ee3wSM7bHYYUBKIxDW
Wd4j9NiRiDK1vWE7mw76QTNeaBEljGjgY/7Ib3syBw6CJ/vXWeCHYjEuhzqDJIQl
c89e4gSo6352lu5NqsonJ1p03n8gF7ZwdfhzeQyWGXlvXzVpJojVEIxm7EvwpX/O
9hmHWM4mn1tMdqJ/hAozf/dpJOYYy2VN7LFHkGCRp5Gj0FRptIVMKCE/Izdrt5ch
3B358BAP5Gpl+RaBo3YUFl+ZPAiXf/gnNa354JBOOrUGpmdkMLLflZFn+60NthMm
FEMDG46KPztFLbpyrwCDXBiu4poPBBpzMtQCC8QtmOILbXYMej+Q/hTZqE0NSSkx
Lt7lNqwI8yp/2yE/tJCJl1NdPgnKb/llqN+zzKyqyXEMBz9jclaSPcMnYpQrbKc=
=Kf6e
-------------------- END PGP PUBLIC KEY BLOCK --------------------Files to be Uploaded –
- A regular employee data file in the format employees.<timestamp>.csv.pgp (Eg – employees.20190420113017.csv.pgp)
- Then, a Done file to be uploaded once SFTP transfer is completed employees.<timestamp>.csv.done.pgp (Eg –
employees.20190420113017.csv.done.pgp)
Debugging Errors in CSV Data File –
Kindly refer to the Correctness Checklist if you face any issues with the data in the CSV file