Add CSV-As-A-Source to Zoho Directory | Admin Guide - Directory Stores

Add CSV-As-A-Source to Zoho Directory using Identity Connect

Roles that can perform this action: Organization Owner, Organization Admin
Subscription plans that support this feature: Free trial or any subscription

Prerequisites: Before starting, make sure your machine, account, and network meet the requirements outlined in Prerequisites and Network Requirements.

Step 1: Download the agent

  1. Sign in to Zoho Directory, then click Admin Panel in the left panel.
  2. Click Directory Stores in the left menu, then click Add Directory.
  3. Click Add next to CSV-As-A-Source.
  4. On the Download ZDIC Agent screen: 
    a. Review the listed prerequisites.
    b. Copy the installation key displayed there.
    c. Click Download and wait for the download to complete.

Step 2: Install the agent

  1. Run the downloaded file ZohoDirectory_IdentityConnect.msi to start installation.
  2. Paste the installation key. Upon successful validation, you'll be redirected automatically to the setup wizard.
  3. On the Welcome screen, choose your language.
  4. Read the software license agreement carefully, then accept the terms. Click Continue.
    Notes
    Clicking the URL will not auto-redirect you to the page on some legacy systems. In this case, click 🔗 to copy the URL, then paste it into your browser to read the license agreement.
  5. Open the Login URL shown in the installer, in a browser.
  6. Sign in to your Zoho Directory admin account, if you haven't already.
  7. Enter the Verification Code shown in the installer.
  8. Upon successfully signing in, a confirmation screen with your Zoho account email and display name will appear. Click Next.

Step 3: Configure CSV files to sync

The next step is telling the agent where to find the CSV files it should read and sync to Zoho Directory.
  1. Enter the path to your CSV folder under CSV folder path. Then,
    i. Check the box Sync all files in the folder to sync everything, or
    ii. Leave it unchecked and enter the specific files under Files to sync as comma-separated values (with or without extensions). Ensure all listed files are valid.
  2. Click Save and Next.

Step 4: Complete installation

  1. Click Install to finish setting up the agent. Upon successful installation, the agent starts running.
  2. After installation, click (the tray icon) to perform the following actions:
    i. Change ownership - Switch the Zoho Directory admin account linked to the agent in case the original admin leaves your organization or loses file access.
    ii. Manage File Sync - Modify your CSV files sync details here. After making changes, click Update to save them.
  3. Return to the Zoho Directory Admin Panel to complete the remaining setup.

Step 5: CSV-As-A-Source integration

  1. From the Admin Panel, navigate to CSV-As-A-Source.
  2. Under User Identifier Field, select a field that uniquely identifies each user.
    Alert
    Once this field is selected and saved, it cannot be modified later. Additionally, the values in this column must not be changed in your CSV file, as doing so can cause duplicate records or syncing issues. For example, changing a user's employee ID creates a duplicate user instead of updating the existing record.
  3. Under User Status Field, select a status field that'd mark users as inactive. Then, enter the corresponding inactive state values to map during sync. Use commas in case of multiple values.
    Notes
    Any user whose field matches this value will be deactivated.
  4. Click Save and Next.
  5. Map Zoho Directory fields to your CSV file fields.
  6. Use the tabs to filter by All Fields, Mapped, or Unmapped fields.
  7. On the CRITERIA screen, specify which users to include in the sync. 
    i. Select the import type: Based on criteria or All users.
    ii. If using criteria, define the Field, Relationship, and Value.
    iii. Click Save and Next.
  8. On the Password Sync screen, enable Sync user passwords securely from CSV-As-A-Source to Zoho if your CSV includes passwords and you want them synced.

Step 6: Configure password sync

  1. Under Password field, select which CSV column holds each user's password.
  2. Under Select the hashing algorithm used, choose how the passwords in your CSV are stored (e.g., Plain text or a specific hashing algorithm)
    i. If you select Get from CSV field, choose a CSV field that specifies the algorithm. 
    ii. If you select Plain text, choose whether to validate the password against your password policy. If the the box is checked, passwords that don't meet policy requirements will not be reset automatically; you'll need to update them manually.
    Notes
    When SHA 512/SHA256/Get from CSV field is selected, passwords will be validated against the organization's policy at first login.
  3. Click Save and Next.

Step 7: Configure general settings 

  1. On the General Settings screen, you can define whether and how to notify users on activities related to the store.
  2. Under Mail Notification, choose if you want to notify users about activities related to this integration via email.
  3. Under Password Notification, define how the users newly added to Zoho Directory during import will gain access. You can choose from one of the options listed below. 
    i. Send email OTP to user: Users will receive a one-time password to access the application when logging in the first time, after which they will be forced to set a new password.
     ii. Send email OTP to Admin: You can choose one of the admin users to receive a one-time password to activate the user account. The selected admin can communicate this OTP to the user, or reset the password for the user. 
    iii. Don't notify anyone: Users added during import will not have access to their account unless an admin manually invites them to join the organization. The user must accept the invite to access their account.
    Notes
    The Password Notification section will display only if you select Notify via mail under the Mail Notification section.
  4. Under Status Sync, choose whether changes made to the user status in the custom store should reflect in Zoho Directory. If you choose to apply the changes to Zoho Directory, the changes will reflect in the corresponding Zoho Directory user profiles during the next sync schedule.
  5. Once done, click Save and Next.      

Step 8: Configure scheduled sync 

  1. On the Scheduled Sync screen, disable or enable Scheduled sync as required and define how often you want to sync the selected resources from the CSV-As-A-Source to Zoho Directory.
    Hourly: Set the time interval at which hourly syncing should occur. 
    Daily: Set a particular time at which daily syncing should occur.
    Weekly: Select particular day or days and set time at which weekly syncing should occur.
    Monthly: Select particular date or dates and set time at which monthly syncing should occur. 
  2. Once done, click Save and Next.
  3. The Import Summary page shows how many users have been imported and how many failed. Once you've reviewed them, click Finish.

        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

                                  Zoho FSM Video Tutorials


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                  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

                                                                                                                                    • Integrate Your On-premises LDAP Directory with Zoho Directory Identity Connect

                                                                                                                                      Roles required to perform this action Organization admin Organization owner Zoho Directory Identity Connect (ZDIC) is an on-premises agent that connects your organization’s on-premises LDAP-based directories to Zoho Directory. It automates ...
                                                                                                                                    • Import users to Zoho Directory from other cloud identity solutions

                                                                                                                                      Transferring user information from one identity provider to another can be tedious, and requires utmost care and effort, since even one mistake can lead to data breaches or loss. Zoho Directory provides you with different ways to import your users. ...
                                                                                                                                    • Integrate Your Active Directory with Zoho Directory Identity Connect - Overview

                                                                                                                                      Roles required: Organization admin, Organization owner What is Zoho Directory Identity Connect? Zoho Directory Identity Connect is an on-premises agent that connects your organization's Active Directory to Zoho Directory. It enables automated ...
                                                                                                                                    • Add JumpCloud to Zoho Directory

                                                                                                                                      Prerequisites: Roles required in Zoho Directory: Organization Owner Organization Admin Roles required in JumpCloud: Admin Plan required in Zoho Directory: Free plan Add JumpCloud to Zoho Directory Using API Using SCIM Using API To add JumpCloud as a ...
                                                                                                                                    • Import users from Ping Identity to Zoho Directory

                                                                                                                                      If you are currently using Ping Identity as your cloud directory service to store your organization data, you can import your users to Zoho Directory. To import your users from Ping Identity, contact their support in either of the following ways: ...
                                                                                                                                      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