Syncing data via an SFTP server

charthop provides an sftp sync app that connects to your sftp server, retrieves a csv file, and uploads the data to charthop when you set up the app, you configure the address and credentials for your sftp server so that charthop can connect to it it runs daily at 9 a m eastern time, similar to charthop's payroll apps you can only have one csv in your upload path at one time to upload additional data, you need to replace the file on your sftp server with one of the same name if the same csv file exists on the server, it will be uploaded a second time when this happens, it overwrites any data you've changed in charthop that was included in your csv via the sftp you can configure the sftp app to ignore files older than the time period you set for example, you can set it to ignore any files older than two days charthop supports servers using best practice encryption algorithms known insecure algorithms including sha1 or md5 are not supported key algorithms, including ssh ed25519, ecdsa sha2 nistp256 , ecdsa sha2 nistp384, ecdsa sha2 nistp521 , rsa sha2 512 , and rsa sha2 256 sftp protocol versions up to and including 3 formatting your csv the csv format is the same as when manually uploading a spreadsheet with the spreadsheet importer https //docs charthop com/importing spreadsheet data you can use a csv file or an xlsx file the column headings in your spreadsheet should match the charthop field names to which you are importing you’ll need to ensure that your column headers use the appropriate charthop field names to ensure a proper upload learn more about built in fields mapping column names to charthop fields if you are automating this process and need to keep the header names from the system you are exporting; you can add a one to one field mapping of your exported headers to the appropriate charthop field for example, if your system exports titles to a spreadsheet column named employee title instead of title, you can map that header name to the appropriate charthop field instead of changing the name in your spreadsheet when mapping column names to charthop fields, you need to use the charthop code name and preface your spreadsheet column name with the “column ” the below example maps data in the spreadsheet column employee title to the title field in charthop mapping custom column headers to charthop fields the code name for the charthop field is title, while the name of the column in the spreadsheet is prefaced with column use camel case to indicate spaces in your column names for example, column employeetitle represents a column header called “employee title” install the sftp sync app to install the sftp app from the left sidebar, select apps & bundles from the sub menu, select apps if not already pre selected select the second tab available apps find the sftp sync app in the list of available apps click install on the far right hand side of the table configure your sftp sync settings remote hostname enter the hostname of your sftp server port e nter the port of your sftp server username enter the username that charthop will use to log in to your sftp server password enter the password associated with the username you entered remote file path enter the complete path, including filename, of the csv file you want to upload to charthop mark the run daily check box remember that the upload syncs daily at 9 a m est mark whether or not you want the upload to skip errors if you mark this option, the upload continues but rows with errors aren't uploaded mark upsert charthop recommends enabling this check box so that new people and jobs can be added when unmarked, the upload can only make changes to existing data add an email to which to send notification emails when the upload occurs if you want to add multiple emails, you must separate them with a comma optionally, you can work with your charthop representative to add custom fields you want to upload you can only upload data to fields that already exist in charthop select save settings run a one time sync you can run a one time sync from the sftp app you can do this even when you have configured an automated sync an on demand sync runs as soon as you select the option when you run a one time sync, you have the flexibility of syncing your data to a charthop scenario or to your primary org from the left sidebar, select apps & bundles from the sub menu, select apps if not already pre selected from the installed apps tab, find the sftp app and select the gear icon ⚙️ scroll to the bottom of the screen to view the sync to primary and sync to scenario buttons choose one of the following select sync to primary to sync the current data on your sftp server to your primary org select sync to scenario to sync the current data on your sftp server to a scenario you can choose from a list of existing scenarios or choose to create a new scenario when you sync select sync once completed, a message indicates that the sync has been completed packages basic basic | | headcount planning headcount planning | compensation reviews compensation reviews | performance performance | engagement engagement roles owner | technical owner