Import configuration for cloud storage services

Import configuration for cloud storage services

You can import data from cloud storage using simple selection or advanced selection. Look into the following sections to learn about the import configuration of each selection type.


While configuring the Schedule, Backfill, Manual reload, Webhooks, or Zoho Flow, the import configuration needs to be mandatorily setup for all the sources. Without setting up the import configuration, the run cannot be saved.

Import configuration for simple selection

If you import data from cloud storage using the simple selection method, you can use the below import configuration options. You can select the Click here link to set the import configuration.


Below is a snapshot from the schedule configuration.

 

How to import data from source? You can choose to Import source file, or Do not import data using this option.

 

Import source file


This option will import the source file during every run.




 Do not import data

The data is imported only once. The second time, the rules get applied to the same data and get exported.

  

 


Import configuration for advanced selection 

If you import data from cloud storage using the advanced selection, you can configure how to import and fetch incremental data from your cloud storage using the below Import configuration options.

You can select the Click here link to set the import configuration.

Below is a snapshot from the schedule configuration.

 


How to import data from source?
Select the way you would like to import your data from the drop-down - Import all data, Incremental file fetch, Do not import data.

 Import all data   

This option will import all available data that matches the file pattern.

 

 

File batch size: Specify the batch size when you choose to import all files. Files will be grouped by this number, based on their first modified time. These files will be imported as a single file and exported to the destination in every run.

Info: File batch size cannot be greater than 10. This option is available only for advanced selection in cloud storage

 Incremental file fetch   

You can configure how to import and fetch incremental data from your cloud storage using the Import configuration option. Incremental data import is a method used to import new or modified records after the previous sync. Click here to know more.


 



 

Use the previously imported file if no new file is available: 

When there are no new files in the source during incremental import,

If the checkbox is checked: The last fetched files will be imported again.

If the checkbox is unchecked: The import will be skipped and no files will be imported.

 

Which file to import? You can choose to import All files, Newest file, or Oldest file using this option.

 All files   

This option will import all the files that match the given file pattern only in the specific data interval based on the Fetch based on field.


Fetch based on: You can choose to select the time based on which the file must be sorted and imported - Modified time, Created time.

Note: Google Drive, OneDrive, SharePoint, Box has modifiedTime and createdTime.
DropBox, Amazon S3 has only modifiedTime (There is no created time)

File batch size: Specify the batch size when you choose to import all files incrementally. Files will be grouped by this number, based on their first created or modified time in that specific data interval. These files will be imported as a single file and exported to the destination in every run.

Info: File batch size cannot be greater than 10. This option is available only for advanced selection in cloud storage.
 

 Newest file   

This option will import the latest file that matches the given file pattern in the specific data interval based on the Fetch based on field.


 Oldest file   

This option will import the oldest file that matches the given file pattern in the specific data interval based on the Fetch based on field.

 

 Do not import data   

The data is imported only once. The second time, the rules get applied to the same data and get exported.

 



SEE ALSO

    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION











                                        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.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Import data from cloud storage services

                                                                                                            DataPrep supports import from the following cloud storage services. Google Drive One Drive Box Storage Dropbox Zoho WorkDrive Amazon S3 To import data from a cloud storage service 1. Open an existing pipeline or create a pipeline from the Home Page, ...
                                                                                                          • Import data from Other Cloud Services - MySQL

                                                                                                            Zoho DataPrep allows you to import data from Other Cloud Services like MySQL, a relational database management system developed by Oracle that is based on structured query language (SQL). To import data from Other Cloud Services - MySQL 1. Create a ...
                                                                                                          • Import data from Other Cloud Services - MS SQL Server

                                                                                                            Zoho DataPrep allows you to import data from Other Cloud Services like MS SQL Server (Microsoft SQL Server), a proprietary relational database management system developed by Microsoft that is based on structured query language (SQL). To import data ...
                                                                                                          • Import data from Oracle Cloud

                                                                                                            Zoho DataPrep supports importing data from Oracle Cloud, a cloud computing service offered by Oracle Corporation. It provides servers, storage, network, applications and services through a global network of Oracle Corporation managed data centers. ...
                                                                                                          • Import data from IBM Cloud DB2

                                                                                                            Zoho DataPrep allows you to export data to IBM Cloud, a cloud database. IBM Cloud database solutions offer a complete portfolio of managed services for data and analytics. Import data from IBM Cloud DB2 1. Create a pipeline or open an existing ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources