Q: Is the SFTP formatting case sensitive?
A: No, headers are not case sensitive. For example, the column header could be "Email" or "email" and function properly.
Q: What are the credentials for SFTP and SFTP2?
For SFTP:
hostname: sftp.lattice.com
port: 22
destination path: /uploads
For SFTP2:
hostname: sftp2.lattice.com
port: 22
destination path: /uploads
Q: Can I sync employee IDs into Lattice via the SFTP sync? And if so, is there a character limit?
A: Yes, you can! You can upload employee IDs into Lattice either using the SFTP sync, or the CSV upload. There is no character limit on employee ID, and they can be alphanumeric.
Q: When setting up an SFTP sync to pull in an Employee ID, do you first need to set up a corresponding custom field for Employee ID?
A: No, you can create this field in the SFTP sync without creating a fieldfor Employee ID.
Q: Is there a way to set up a dotted-line manager relationship that is updated with an SFTP sync?
A: Yes! First, you would need to set up a dotted-line manager field and configure the permissions in Lattice. Then, you can pair that field with the dotted-line manager email with a field in your HRIS.
Q: I've sent a file through SFTP but I don't see the changes in Lattice. Additionally, there were no errors in the import log.
A: Confirm that the file is formatted as .csv. This is case-sensitive - the extension needs to be in all lowercase.
Q: What format must my file be formatted in?
A: Files will need to be formatted as .csv in order to be uploaded into the system.