You can install the uSonar extension either from Zoho Marketplace or from within your Zoho CRM account as follows:
Go to Setup > Marketplace > All. All the installed extensions will be listed.
Under All Extensions, browse for and click uSonar. The details about the extension will be available.
Click Install.
Agree to the terms of service and click Install, as shown in the picture below.
Choose one of the following options, then click Confirm
Install for admins only- The extension will only be installed in CRM for users with the administrator profile.
Install for all users- The extension will be installed in CRM for all users.
Choose profiles- The extension will be installed in CRM for manually chosen users. Choose this option, click Confirm, then select the desired profiles. The extension will be installed automatically for the specified users.
uSonar configuration
Once installed, uSonar extension has to be configured with three specific CID numbers. These are namely the Information linkage CID, Search API CID, and Update API CID, as shown below.
LBC ID: A unique ID used to automatically fetch customer data, directly from uSonar's records.
Company ID (CID): A unique ID used by uSonar, to recognize who is accessing their data.
Configuration
To begin using the uSonar extension, users must complete the configuration by setting up all three required sections and then clicking the Save button. This setup can be accessed from the Settings page within the extension.
The Settings page includes the following sections:
Module Fields Configuration
Synchronization
Additional Configuration
1. Module Fields Configuration
This section allows users to configure fields for the Leads and Accounts modules.
Steps to Configure:
Click the Configure now to access the configuration page.
Click the Activate button to enable the configuration.
Configure the following:
Criteria Mapping
Field Mapping
Criteria Mapping
In this section, users can define which specific field should be used as the primary search key to retrieve company details from uSonar. This setting determines how the system queries uSonar to match and fetch relevant company data during the integration process.
- Company Name and Address are mandatory fields.
- Phone Number and Website fields are optional and can be configured as needed.
Field Mapping
The left section of the interface displays the available uSonar fields, while the right section allows users to map these fields to the corresponding fields in the selected Zoho CRM module. Users must ensure that each field is correctly mapped to facilitate accurate data transfer between uSonar and Zoho CRM. In the CRM section, only fields with specific data types and sizes are available for each uSonar field, as outlined in the section below. Once the necessary configurations are complete, click Done to configure the settings.
Note:
- The same configuration steps apply to both Leads and Accounts modules.
- In field mapping, data from uSonar will overwrite the corresponding fields in Zoho CRM. If a uSonar field is blank but the mapped CRM field contains a value, that value will be overwritten with a blank during integration process.
Field Mapping Specifications:
When mapping uSonar fields to Zoho CRM, ensure that the data type and size constraints of the Zoho CRM fields are met. Below is a list of available uSonar fields along with their respective data types and size limits:
uSonar Field | CRM Field - Data Type | CRM Field - Min. Size |
Listed Status flag | Single Line, Multi Line, Pick List | 2 |
Grade | Single Line, Multi Line, Pick List | 2 |
Prefecture Code | Single Line, Multi Line, Pick List | 2 |
Employee Count Details Range Code | Single Line, Multi Line, Pick List | 2 |
Revenue Details Range Code | Single Line, Multi Line, Pick List | 2 |
Net Profit Detail Range Code | Single Line, Multi Line, Pick List | 2 |
Industry Major Classification Code 1 | Single Line, Multi Line, Pick List | 2 |
Industry Middle Classification Code 1 | Single Line, Multi Line, Pick List | 2 |
Industry Major Classification Code 2 | Single Line, Multi Line, Pick List | 2 |
Industry Middle Classification Code 2 | Single Line, Multi Line, Pick List | 2 |
Industry Major Classification Code 3 | Single Line, Multi Line, Pick List | 2 |
Industry Middle Classification Code 3 | Single Line, Multi Line, Pick List | 2 |
Securities Code | Single Line, Multi Line, Pick List | 5 |
City Code | Single Line, Multi Line, Pick List | 5 |
Industry Code 1 | Single Line, Multi Line, Pick List | 5 |
Industry Code 2 | Single Line, Multi Line, Pick List | 5 |
Industry Code 3 | Single Line, Multi Line, Pick List | 5 |
Industry Minor Classification Code 1 | Single Line, Multi Line, Pick List | 5 |
Industry Minor Classification Code 2 | Single Line, Multi Line, Pick List | 5 |
Industry Minor Classification Code 3 | Single Line, Multi Line, Pick List | 5 |
Date of bankruptcy | Single Line, Multi Line, Pick List | 8 |
Post Code | Single Line, Multi Line, Pick List | 8 |
Established Year (month) | Single Line, Multi Line, Pick List | 8 |
Current Fiscal Year | Single Line, Multi Line, Pick List | 8 |
Phone Number Call Checked Date | Single Line, Multi Line, Pick List | 8 |
Survey Date | Single Line, Multi Line, Pick List | 8 |
LBC Head Office ID | Single Line, Multi Line, Pick List | 15 |
LBC Parent Company ID | Single Line, Multi Line, Pick List | 15 |
LBC Top Affiliated Office ID | Single Line, Multi Line, Pick List | 15 |
LBC Merger Company ID | Single Line, Multi Line, Pick List | 15 |
Corporate Number | Single Line, Multi Line, Pick List | 15 |
Integration key | Single Line, Multi Line, Pick List | 15 |
Capital (thousand yen) | Single Line, Multi Line, Pick List | 20 |
Current Period Sales Revenue (thousand yen) | Single Line, Multi Line, Pick List | 20 |
Previous Period Sales Revenue (thousand yen) | Single Line, Multi Line, Pick List | 20 |
Sales Revenue from Two Periods Ago (thousand yen) | Single Line, Multi Line, Pick List | 20 |
Employee Count Details Range Name | Single Line, Multi Line, Pick List | 50 |
Revenue Details Range Name | Single Line, Multi Line, Pick List | 50 |
Net Profit Detail Range Name | Single Line, Multi Line, Pick List | 50 |
Listed Status name | Single Line, Multi Line, Pick List | 96 |
Company Status Name | Single Line, Multi Line, Pick List | 96 |
Office Status Name | Single Line, Multi Line, Pick List | 96 |
Industry Name 1 | Single Line, Multi Line, Pick List | 96 |
Industry Name 2 | Single Line, Multi Line, Pick List | 96 |
Industry Name 3 | Single Line, Multi Line, Pick List | 96 |
Company Classification Name | Single Line, Multi Line, Pick List | 96 |
Industry Major Classification Name 1 | Single Line, Multi Line, Pick List | 96 |
Industry Middle Classification Name 1 | Single Line, Multi Line, Pick List | 96 |
Industry Minor Classification Name 1 | Single Line, Multi Line, Pick List | 96 |
Industry Major Classification Name 2 | Single Line, Multi Line, Pick List | 96 |
Industry Middle Classification Name 2 | Single Line, Multi Line, Pick List | 96 |
Industry Minor Classification Name 2 | Single Line, Multi Line, Pick List | 96 |
Industry Major Classification Name 3 | Single Line, Multi Line, Pick List | 96 |
Industry Middle Classification Name 3 | Single Line, Multi Line, Pick List | 96 |
Industry Minor Classification Name 3 | Single Line, Multi Line, Pick List | 96 |
LBC Parent Company Name | Single Line, Multi Line | 255 |
LBC Top Affiliated Office ID Name | Single Line, Multi Line | 255 |
Merger Company Name | Single Line, Multi Line | 255 |
Company Name | Single Line, Multi Line | 255 |
Company Name Kana | Single Line, Multi Line | 255 |
Office Name | Single Line, Multi Line | 255 |
Prefecture Name | Single Line, Multi Line | 255 |
City/ward/town/village name | Single Line, Multi Line | 255 |
Town/district name | Single Line, Multi Line | 255 |
Block number | Single Line, Multi Line | 255 |
Street number | Single Line, Multi Line | 255 |
Building Name/Room number | Single Line, Multi Line | 255 |
Representative Position | Single Line, Multi Line | 255 |
Representative Name | Single Line, Multi Line | 255 |
URL | Single Line, Multi Line, Website | 255 |
Web Tag | Multi Line | 32000 |
Story | Multi Line | 32000 |
Best Industry | Multi Line | 32000 |
Intent Signal | Multi Line | 32000 |
Telephone Number | Single Line, Multi Line, Phone | 15 |
Fax number | Single Line, Multi Line, Phone | 15 |
Number of establishments | Integer, Bigint, Single Line, Multi Line, Pick List | 6 |
Company Status Flag | Integer, Bigint, Single Line, Multi Line, Pick List | 2 |
Office Status Flag | Integer, Bigint, Single Line, Multi Line, Pick List | 2 |
Phone Number Call Checked Flag | Integer, Bigint, Single Line, Multi Line, Pick List | 2 |
FAX Number Call Checked Flag | Integer, Bigint, Single Line, Multi Line, Pick List | 2 |
Foreign Affiliated flag | Integer, Bigint, Single Line, Multi Line, Pick List | 2 |
LBC Match Result | Single Line, Multi Line, Pick List | 2 |
LBC Match Div | Single Line, Multi Line, Pick List | 2 |
LBC Temporary Flag | Single Line, Multi Line, Pick List | 2 |
Attention Code | Single Line, Multi Line, Pick List | 2 |
Attention Name | Single Line, Multi Line | 255 |
Company Score | Single Line, Multi Line | 255 |
Company Score Range | Single Line, Multi Line, Pick List | 2 |
Company Score Range Name | Single Line, Multi Line, Pick List | 50 |
2. Synchronization
If the scheduler is enabled, the system will automatically update information in Zoho CRM whenever changes are made in uSonar. For example, if Company A has already been synced to Zoho CRM and certain fields are later updated in uSonar, the scheduler will detect these changes and sync the updated data to Zoho CRM automatically.
Only active and configured modules (Leads and/or Accounts) will be included in this scheduler.
Users can view the Status and Last Sync Time for reference.
Administrators also have the option to manually sync the latest company data by clicking Sync Now, which updates previously synced records with the most recent information from uSonar.
3. Additional Configuration
Admin users can set their preference for retrieving company details based on either the Official Name or Abbreviation of the company.
uSonar Widget
1. Accessing the Widget
After configuring the settings, users can access the uSonar widget within the Leads and Accounts modules.
The widget is available on the View Record page.
A uSonar button is displayed in the top-right corner of the record view.
Clicking this button allows users to fetch company details from the uSonar database.
2. Fetching Company Data
A pop-up displays search results, categorized as: Head Office, Branch Office, and Unknown Head Office.
Each entry includes: Business Name, Company Name, Industry, Address, and Zip code.
Select the appropriate company from the list and click Update to sync its details with the current Zoho CRM record.
If the desired company is not listed, users can use the search bar to find and link the correct company.
Once a record has been synced, users can:
In Version 10, we have introduced major improvements to field mapping functionality. Previously, fields were automatically created and mapped by the extension. With this update, users now have the flexibility to manually map fields based on their specific needs.
For customers upgrading from Version 9, previously configured fields will remain accessible and are automatically mapped in the settings. To retain these fields, users must activate them and click the Done button. Alternatively, field mappings can be updated to align with current requirements.
If you need to migrate data from existing fields to newly configured ones, please follow the steps outlined below.
Export Existing Data
Export your data along with the Record ID & LBC ID to ensure a smooth transition.
Refer to this guide for detailed export steps.
Modify the Exported File
Add a new column named "uSonar Data Synced" and set all values to "true" to indicate synced records.
Old Configured Fields Deletion (Optional)
If you no longer need the previously configured fields (created via the extension), please uninstall and reinstall the extension. This will remove all the old fields created by the extension.
Import Data to a Module
Use the Record ID for updating existing records.
Map old fields to the new fields as required.
Follow this guide for detailed import instructions.
Uninstalling the extension
To uninstall the extension:
Go to Setup > Marketplace > All. All the installed extensions will be listed.
Under All Extensions, you can view all the extensions supported in your CRM.
Browse for uSonar and click the corresponding Uninstall link.
Click Ok to confirm and uninstall the extension.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.