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

Add CSV-As-A-Source to Zoho One 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.

The steps to add CSV-As-A-Source to Zoho One using Identity Connect vary between the two User Interface versions supported in Zoho One. Select the UI version that you use from the tabs below and proceed with the steps that follow.
One Experience UI
Spaces UI
One Experience UI

Step 1: Download the agent

  1. Sign in to Zoho One, then click the Admin Panel icon  in the top-right corner.
  2. Click User Management on the left menu.
  3. Go to Directory Stores, then click Add Directory. 

  4. Click Add next to CSV-As-A-Source.
  5. 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 One 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 One.
  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 One 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 One 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 One 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 One. If you choose to apply the changes to Zoho One, the changes will reflect in the corresponding Zoho One 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 One.
    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.

Spaces UI

Step 1: Download the agent

  1. Sign in to Zoho One, then click the Directory Settings icon  in the top-right corner.
  2. Click User Management on the left menu.
  3. Go to Directory Stores, then click Add Directory. 
  4. Click Add next to CSV-As-A-Source.
  5. 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 One 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 One.
  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 One 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 One Directory Settings to complete the remaining setup.

Step 5: CSV-As-A-Source integration

  1. From the Directory Settings, 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 One 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 One. If you choose to apply the changes to Zoho One, the changes will reflect in the corresponding Zoho One 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 One.
    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 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 One. It enables automated ...
                                                                                                                                    • 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 One. It automates synchronization ...
                                                                                                                                    • Add JumpCloud to Zoho One

                                                                                                                                      Prerequisites: Roles required in Zoho One: Organization Owner Organization Admin Roles required in JumpCloud: Admin Plan dependency in Zoho One: Free plan Using API Using SCIM Using API To add JumpCloud as a store in Zoho One using API integration, ...
                                                                                                                                    • Configure Directory Sync

                                                                                                                                      Prerequisites: The Identity Connect Agent must already be installed - See Install the Identity Connect Agent. This article covers choosing what to sync and mapping fields correctly. The steps to configure directory sync vary between the two User ...
                                                                                                                                    • Add greytHR to Zoho One

                                                                                                                                      Prerequisites Roles required in Zoho One to perform this action: Organization Owner Organization Admin Roles required in greytHR: Admin Plan dependency in Zoho One: Free plan The steps to add greytHR to Zoho One vary between the two User Interface ...
                                                                                                                                      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