Import Records
Importing records is an essential data administration task. In Bigin, this important action can be performed without much hassle and complexity. Currently, you can import records to the Companies, Contacts, Deals, and Products modules. You can also import tasks and notes by associating them with their parent records.
Import Checklist
Before you begin importing, we recommend you go through the following checklist:
Profile permission
Ensure you have the Import permission enabled for your profile. If you do not have this option, the Import option will not be available in your account.
Import file format
The import file must be in one of the following formats and the attachments and the data must be kept separate:
-
Excel (XLS, XLSX)
-
Comma Separated Value (CSV)
-
Business Card or vCard Format (VCF)
Allowed values
-
The data that is to be imported must not be enclosed inside "<script> </script>".
-
The data must match the field type, for example, a Number type field should contain only number values. If string values are added to a Number type field then that field value will not be imported.
Mandatory fields
Ensure that the mandatory fields in a record are not empty but contain a proper value, otherwise that record will be skipped during the import process.
Boolean or checkbox fields
The data you want to import to checkbox fields must contain suitable values that can be properly converted during the import process. The file must contain the data for checkbox fields in the following formats:
-
If checkbox is selected: True or 1
-
If checkbox is not selected: False or 0
Dropdown or Picklist field values
All the possible values in the dropdown list in your import file must exist in the corresponding field in Bigin. For example, there is a dropdown field named
Contact Source
in your
Contacts
module. Before importing contacts, ensure that you have added all the dropdown values in the file to the
Contacts
module in Bigin. Please note that if the values are not added to Bigin, the record will be imported with the dropdown value but the specific value will not be available in the dropdown field in Bigin.
Field names
Make sure the first row of data in the import file contains the column headings or field names rather than actual data values.
Blank rows in the import file
10 consecutive blank rows in the file will be considered the end of the file, so any data after the blank rows will not be imported. Try to avoid blank rows in between rows of data.
Import file size
The import file's size must not exceed the following limits:
|
|
License type
|
Limit
|
|
File size for all type of files
|
Free
|
5 MB
|
|
Express
|
10 MB
|
|
|
Rows limit for non .csv files (.xls, .xlsx, .vcf)
|
Free
|
250
|
|
Express
|
5000
|
|
|
Rows limit for .csv files
|
Free
|
250
|
|
Express
|
10,000
|
Unique fields
Unique fields help Bigin identify a record that is mapped to a record in another module.
Example: Contact Name field in the Deals module.
Here is a list of standard unique fields in Bigin:
|
Module Name
|
Field Name
|
|
Contacts
|
Email
|
|
Companies
|
Company Name
|
|
Deals
|
Deal Name
|
|
Products
|
Product Name
|
Fields like Contact ID, Company ID, and Deal ID are generated in Bigin when records are exported. These values are useful for importing records which were previously exported from Bigin. Here is a list of the system-generated unique fields in Bigin:
|
Module Name
|
Field Name
|
|
Contacts
|
Contact ID
|
|
Companies
|
Company ID
|
|
Deals
|
Deal ID
|
|
Products
|
Product ID
|
Tasks | Task ID |
In addition to these fields, the user can create a maximum of two custom unique fields per module.
Unique fields are not case-sensitive. For example, if the unique field's value in the import file is "ABC" and in an existing record, it is "abc", Bigin will still identify this as a match.
Importing deals
A deal is always created in association with a Company or Contact. So before you import deals into you Bigin account, you must associate them with their parent module (
Contacts or Companies)
. This can be done by creating fields in the import file that will contain unique values associated with the parent module. These unique reference fields can be the
Company Name, Company ID, Contact name, the Contact ID
, or any other unique field.
Points to remember:
-
If the import file does not have a field for Pipeline and the user has also not mapped the pipeline during import then the system will choose the standard pipeline as the default.
-
The stage value of a particular record should be created in the respective Pipeline before importing the records. If the stage value for a record does not exist in the Pipeline then the record will be skipped during import.
-
If the user has not mapped the Pipeline field during import and all the pipeline values in the file were not created before importing, the records with no pipeline values will be skipped.
Importing Tasks
Tasks must be associated with one or more of their parent modules (Contact, Company and Deals). Before importing, ensure the import file contains unique reference fields to the Contacts, Companies, and Deals modules. Some examples of unique fields are Company Name, Company ID, Contact name, Contact Email, Deal ID, and Deal Name.
Order of Import
Once all the conditions in the checklist are met, you can begin importing the records. We recommend administrators import data into the Bigin account in the following order. It is important to follow this order to ensure that all the related records are properly mapped. For example, if you import Deals first, you will not have any company to associate the deals with. So, you must first import Companies, followed by Contacts, and then associate the contacts with the relevant companies. You can then import Deals and associate them with companies and contacts in your Bigin account.
You should import the modules in the following order:
-
Companies
-
Contacts
-
Products
-
Deals
-
Notes
- Tasks
Stages in the import process
There are four stages in the import process:
Stage 1: Upload file
The user must upload a file that satisfies the conditions in the checklist above.
If required, you can change the character encoding from the dropdown list.
Stage 2: Choose an action
Importing the records can add new records to Bigin and/or update existing ones. Specify whether to add, update, or add and update in this step.
Add as new Records:
Choose this option if you would like to import the data as new records in your Bigin account.
There is also an option to skip records from the file that match existing records in your Bigin account. For example, when you import companies, you can skip records by matching the data in the file with fields like Company Name, Company ID, or any other unique fields.
There is also an option to skip records from the file that match existing records in your Bigin account. For example, when you import companies, you can skip records by matching the data in the file with fields like Company Name, Company ID, or any other unique fields.
Update existing Records only:
Choose this option to only make changes to existing records in your Bigin account. Select a field from the dropdown to identify matching records in Bigin.
You can also prevent values in Bigin from being overwritten with any empty values in the file by selecting the Don't update empty values for existing records checkbox.
You can also prevent values in Bigin from being overwritten with any empty values in the file by selecting the Don't update empty values for existing records checkbox.
Both
: This option allows you to add new records as well as update existing records. Select a field from the dropdown to identify matching records in Bigin. You can choose to skip overwriting fields with empty values.
Stage 3: Map your data
In this stage of the import process, you must map fields from your file to the fields in Bigin account. There are some options available in this section to help you map the fields:
Create New Fields:
To create a custom field to map records from your import file to your Bigin account.
Mapped Columns:
To view the list of fields that are already mapped.
Unmapped Columns:
To view the list of fields that are not mapped.
Reset Field Mapping:
To undo all the field mapping start again from scratch.
Apply Auto Mapping:
To automatically map the fields in the import file with matching fields in Bigin.
Sample Data from File:
To verify how the data in the file is to be mapped or imported. The first two valid values from the import file are show here.
Stage 4: Additional Operations
Assign record owner
-
From Mapped Column:
Select this option to assign different record owners for the records that you import. You will need to specify the email address or User ID of the Bigin users in a separate column in the import file and map it with the Record Owner field.
-
From Bigin:
Select this option to assign one user as the record owner for all the records that you import.
Add tags
-
From Mapped column:
Select this option to add different tags to the record that you import. You need to add the tags in a separate column in the import file and map it with the Tag field.
-
Add tags:
Select this option to add one or more tags to all the records that are imported from the file.
Importing records into your Bigin account
We recommend that you import records into the primary modules Companies and Contacts first, followed by records for Products, Deals, Notes and Tasks.
To import records
-
Go to the desired module (
Contacts, Companies, Products, Deals
) module.
-
Click the drop-down button next to
+ Contact/Company/Product/Deal
and select
Import
.
-
In the
Upload your file
stage, click
Upload
or drag and drop your file.
-
Click
Next
.
-
In the
Choose an Action
section, select one of the following:
-
Add as New Record
-
Update Existing Records Only
-
Both
-
Click
Next
.
-
In the
Map Your Data
section, map the fields from your file to the fields in the Bigin account.
-
Click
Next
.
-
In the
Additional Options
stage, select the record owner and add tags, if required.
-
Click
Finish
to start importing.
The import process will run in the background. Once it is completed, you will receive a notification in the bottom-right corner of your Bigin account. This notification will have an option to view a detailed summary of the import. You can also access the summary from the
Import History
section under the Data Administration settings.
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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
How to import contacts into Bigin?
You can import your contacts from a spreadsheet, CSV file, or VCF file. Refer to the checklist here to ensure your import file meets all the required parameters. Note: You must import the Companies into Bigin first so that you can map the imported ...Import Notes
Permissions: Users with the following permissions enabled in their profile can import notes in their Bigin account. 1. 'Create' permission for Notes under Basic Permissions. 2. Import permissions should be enabled under Advanced Features. For ...How to import deals into Bigin?
You can import your deals from a spreadsheet, CSV file, or VCF file. Refer to the checklist here to ensure your import file meets all the required parameters. A deal is created with a contact or company. So, before you import deals, ensure that the ...Manage your Data
All businesses rely on data, so your administrators need to be able to control how data is managed in Bigin. Import History This section displays a consolidated list of all the data that has been imported to any module in your Bigin account. ...Why wasn't the Company Name field added when I imported contacts?
The Company Name field will only be added to contacts if a record for that company already exists in the Companies module. Data in Bigin is organized into modules. When importing data into your Bigin account, we recommend that you import them in ...