FTP

FTP

Our platform enables you to quickly and easily connect your data sources to data from a file located on an FTP server. This enables a one-way synchronization to occur - where any changes in the FTP file are downloaded into your data source on a regular basis. Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the file).

To Set up an FTP Connector to your Data Source by following these simple steps. Not that you need to have configured a Connection to your FTP account. You will also need to install an SSL certificate on your FTP server which has been issued by a Microsoft-recognized certificate authority in order to connect and use the server on eForms Mobile . Self-signed certificates will not work.

  1. Go to  Connected Data -> Data Sources
  2. In the list of available data sources, hover your mouse over the listing of the data source you wish to connect. A set of options will show; click on the settings link.


  3. In the Settings page, mid way down you should see a Connector heading. Click on "Add Connector." 

  4. A new window will appear with the selection of connectors to choose from. Click on the FTP optio
  5. The page should refresh with your newly added connector. Enter the File Location. This should be entered in the following format: 'FolderName/Folder2/FileName.csv'.
  6. Select the Refresh Frequency that this connector will pull data. Note: Data must be in .csv or .xlsx format and cannot contain formulae. The spreadsheet must exist in your connected FTP account.
  7. When you save your changes, the connector will be fired for the first time and after that will run at the interval you specified in the connector settings. Wait a minute or so and then check the Rows page for your data source. You should see the rows have been downloaded from the FTP file. If rows are not downloaded, then there may be an error with the file's data or in the permissions to access the file. You can check this by clicking on the Error Logs button shown next to your connector on the Settings page.


    • Related Articles

    • Connecting to FTP

      Authenticating a connection to an FTP server enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Sources can pull data. Adding The Data Hub area of the platform is where you can add ...

    • Form Connector – FTP

      Connecting a form to a remote FTP server allows you to automatically send PDF reports and other documents to an FTP location. This guide explains how to use the FTP Form Connector to push reports to your remote FTP server after you’ve added and ...

    • Data Source Connector – FTP

      Connecting a data source to a file on an FTP server is a quick and easy process on our platform. This creates a one-way synchronization, automatically updating your data source whenever the FTP file changes. Your data will be kept up to date until ...

    • Data Source Connector – NetSuite

      Our platform enables you to quickly and easily connect your data sources to NetSuite Objects. This enables a one-way synchronization to occur – where any changes in the NetSuite Objects are downloaded into your data source on a regular basis. Your ...

    • Editing Settings and Rows

      To add rows to a Data Source, you can either upload a CSV-formatted spreadsheet or a standard Excel spreadsheet or else manually add items using the Add Row link. NOTE that for data to be entered into the data source, it is highly recommended to ...