Import data from FTP servers
To import data using an FTP connection
To import data from local network
1. Enable the Import from local network toggle if you want to import local files from your FTP server incrementally.
2. Choose an active Databridge.
3. Configure FTP connection to connect to the server and fetch the file.
4. Select one of the below options in the FTP server type drop down.
FTP - File Transfer
FTPS - File Transfer Over Implicit TLS/SSL
FTPS - File Transfer Over Explicit TLS/SSL
SFTP - SSH File Transfer Protocol
5. Enter the FTP server host. You can also enter the IP address or the FQDN (Fully Qualified Domain Name) of the server.
6. Enter the Username and Password if authentication is required.
7. Give a name to your connection in the Connection name text box.
8. Click the Connect button and provide the following details.
Folder path : The folder path where you want to search for files. Eg. /srv/ftp/filesfortest/
Include subfolders : You can select this checkbox if you want to include subfolders while searching for a file.
File pattern : The pattern used to match the file names in the specified location. This supports regex type matching. You can also use the pattern, ".*" to match any file in the path specified.
For example, to fetch files with names such as Sales_2022.csv , Sales_2023.csv , Sales_2024.csv , you can input the pattern Sales_.*
Similarly to fetch files such as PublicData1.csv , PublicData2.csv , PublicData3.csv , use Public.*
If you want to import a single file, then specify the pattern using the exact file name.
Eg: leads_jan_2022.*
Note: If this checkbox is unchecked then, only 1 file will be fetched at a time.9. Click Import to upload data into Zoho DataPrep from the FTP server.
To edit the FTP connection
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Import configuration for FTP servers
You can import data from FTP s using simple selection or advanced selection. Look into the following sections to learn about the import configuration of each selection type. How to import data from FTP servers using simple selection? How to import ...Export data to FTP servers
You can export files to FTP servers using the following steps. To export data to FTP servers 1. Open an existing pipeline or create a pipeline from the Home Page, Pipelines tab or Workspaces tab. You can bring your data from 50+sources. 2. On the ...Import data from URLs
You can enter the URL to a CSV, TSV, JSON, HTML, XLS, XLSX or XML file. DataPrep also supports URL imports that require authentication. To import files from URLs 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or ...Import data using saved data connections
DataPrep saves your data connections to avoid hassles in keying them often. To access your saved data connections 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You ...Import data from a local filesystem
In DataPrep, you can import various file types, including CSV, TSV, JSON, HTML, XLS, XLSX and XML. Note : 1. DataPrep also supports files without any extension or files in plain text format. However, binary files cannot be parsed during import; users ...