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
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 data if no new data is available: 

During incremental import,

  1. If the checkbox is checked: When there is no new data in the source, the last fetched data will be imported again.
  2. If the checkbox is unchecked: When there is no new data in the source, the import will fail and no files will be imported. This will, in turn, cause the entire pipeline job to fail.

 

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.

NotesNote: 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.

InfoInfo: 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

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit

                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsFormstack alternativeEncrypted Forms

                              Wufoo alternativeSecure Forms

                              TypeformWCAG


                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now




                                                            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


                                                                  • Desk Community Learning Series


                                                                  • Digest


                                                                  • Functions


                                                                  • Meetups


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner


                                                                  • Word of the Day


                                                                  • Ask the Experts


                                                                    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 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 With these connectors, you can streamline your ETL workflows, enable smooth data movement, and simplify data ...
                                                                                                                            • 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). Prerequisites for MySQL Please ensure the following conditions ...
                                                                                                                            • 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). Prerequisites ...
                                                                                                                            • 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 Google Cloud SQL PostgreSQL

                                                                                                                              Zoho DataPrep allows you to import data from Google Cloud SQL, a cloud database. It is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform. Before looking into ...
                                                                                                                              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