How to Create a Data Source for data on an sFTP Server

If you have an sFTP server with data you'd like to import into Openprise, please use these instructions as a guide to creating your data source.  The files on the sFTP server should be constructed in UTF-8 CSV format.

Note: If you want to create multiple data sources with different data formats (ie. a file for leads and one for accounts), you must place the files in separate folders on your sFTP server.

Set up your FTP Server

To begin, open or download a separate program to access the server. In the instructions below, we're using FileZilla, which can be downloaded from the internet. 

1. Open your sFTP Software program
2. Enter the credentials to access the file server.
   
   1. You will need credential attributes for: Host, Username, Password, Port.
   2. Input your credential attributes.  
   3. Click Quickconnect to save credentials in FileZilla.
   4. Once connected, create a new directory by right-clicking on the top level folder and completing the details. This will be the directory where your file will be placed. In the screenshots below, this new folder is named "Ref - Country Lookup". 
      
      
      
      
3. Once the folder is created, drag and drop your data file from your desktop to the newly created folder[Ref - Country Lookup].
   Note: Please make sure the file is in .CSV format.
   
   

Create the data source in Openprise

1.  Create the data source definition: from within Openprise, go to: Data Data Source Click Add Data Source 
   
2. Name your Data Source and select FTP for Source Technology and Data Format field. 
   
3. Upon clicking FTP, you will see a pop-up window where you add the FTP account information.
   
   
   
4. Once you have entered the credentials, Test the authentication and Save it. You will be navigated back to the create Data Source window.
   
   
5. We will now pick the directory that contains your data file. Then click Next in the top right corner.
   
6. The file will be located on the server and opened and read. You will see the Parse screen where Openprise shows the first 50 records in the file. Check to make sure Openprise is reading the correct file and is reading the data appropriately.
   
7. Scroll to the bottom of the screen and click "Continue". You will then be navigated to the Map screen.
8. Now Map the Fields with correct data Type. When finished mapping, choose a Primary timestamp attribute and click Finish in the top right corner. 
   

Next, import your file

1. Click on Import now from the Data Sources page to import the records from your file on the sFTP server into your Openprise data source.  

Once completed, use the data source in the same manner as any other data source.