Homepage > > Employee Data Import Using 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 – 

  1. 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 
  2. 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 HYPHEN Team
  3. Test Connection – You can try uploading any dummy file if you wish to test the connection
  4. Once Connection is established, tested  and is working fine, you can start uploading the data in .csv file format only
  5. 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

  1. File should be in the CSV format mentioned here
  2. File must be PGP encrypted
  3. The file name must be employees.<timestamp>
  4. Make sure to Timestamp the file in the right format (YYYYMMDDHHMMSS)
  5. 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

  1. PGP Encrypt
  2. PGP Windows
  3. Open PGP

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 –

  1. A regular employee data file in the format employees.<timestamp>.csv.pgp (Eg – employees.20190420113017.csv.pgp)
  2. 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