Transfer Files To FTP Server For Data Loader

Before Data Loader can import a file you must transfer your files to the FTP server that Bronto configured for you. This is done outside of Data Loader.

About this task

You will need a valid FTPS/SFTP client to transfer the file(s) from your computer to your FTP account, or you can use cURL. For security, we've purposefully chosen non-standard FTPS and SFTP ports. This type of nonstandard port might confuse some FTP clients. FileZilla, for example, might not be able to properly recognize these ports. To work around this, prefix the host ftp.bronto.com with ftps:// for FTPS transfers or sftp:// for SFTP transfers. We do not support the insecure ftp:// protocol transfer.

The FTP credentials for your account can be found by clicking on Display FTP Credentials, located in the Account Information box on the main page of Data Loader. This is an example of what the FTP Credentials window looks like; your FTP Credentials will be specific to your account.

FTP Credentials window

The general steps for transferring files is provided below. For specific details about how to complete an FTP transfer, see the documentation for your FTP client.

To transfer files to Bronto's FTP server:

Procedure

  1. Open the FTP client of your choice.
  2. Use the FTP data provided in Data Loader to connect to the server.
  3. Transfer your files.

If you wish to use cURL instead of an FTP client

  1. Use the following command to upload files
    curl -F "filename=@FILENAME" -F "username=USERNAME" -F "password=PASSWORD" https://ftp.bronto.com/upload
  2. Use the following command to view a list of files
    curl -F "username=USERNAME" -F "password=PASSWORD" https://ftp.bronto.com/list/uploads
  3. Use the following command to delete files
    curl -F "username=USERNAME" -F "password=PASSWORD" https://ftp.bronto.com/delete/FILENAME