You can migrate data from Salesforce onto the web application with just a few steps.
|
How to export data from Salesforce?
To export data from Salesforce,
On the Home page, click the Basic Sales Setup button and choose Setup
On the Setup page, go to ADMINISTRATION > Data > Data Export and click the Export Now button.
Choose the CRM data that you wish to export and dick Start Export
Salesforce creates a zip archive of CSV files and emails you when it’s ready. You can download the zip file/s from the same section.
Click here to know more about Salesforce data export.
How to import data using the import wizard onto the web application?
As a prerequisite to importing data, ensure to add users to associate with records and create custom fields with exact column header name.
To import migration data,
Go to Admin Settings > Data & Import > Salesforce Migration
On the SALESFORCE MIGRATION overlay enable the checkboxes and upload the zip file containing migration data.
How are the records imported?
Lead module present in the zip file will be migrated as contacts.
Lead status in Salesforce will be mapped to contact status in the web application. A similar status has to be created in the web application if not already present.
The corresponding lifecycle stage of the contact status will be applied on the contact as there is no lifecycle stage in Salesforce.
| Web Application Field | Salesforce Field | Description |
Address | Address | Street address for the lead, for example, 475 Boardwalk Ave. Up to 255 characters are allowed in this field. |
Associated company. annual revenue | Annual Revenue | Amount of annual revenue at lead’s company. |
City | City | City portion of the lead’s address, for example, San Francisco. Up to 40 characters are allowed in this field. |
Account Name - Associated company.name | Company | Name of company with which lead is affiliated. Up to 255 characters are allowed in this field. |
Country | Country | Country portion of user’s address. Entry is selected from a picklist of standard values, or entered as text. Up to 80 characters are allowed if the field is a text field. |
Click the email address in this field to send an email using your personal email application. If the Gmail Buttons and Links feature is enabled, you can click the Gmail link next to the field to send an email from your Gmail account. | ||
subscription_status - Unsubscribed subscription_status - subscribed | Email Opt Out- True Email Opt Out- False | Whether the lead wants to receive email (false) or not (true). If you use Data.com, the Email field value is hidden from search results and on the Contact Card, and it’s blank in .csv files that are created when you export records. |
Fax | Fax | Lead’s fax number. Up to 40 characters are allowed in this field. |
First name | First Name | First name of the lead, as displayed on the lead edit page. Up to 40 characters are allowed in this field. |
Associated company.Industry type | Industry | Primary business of lead’s company. Entry is selected from a picklist of available values, which are set by an administrator. Each picklist value can have up to 40 characters. |
Last name | Last Name | Last name of the lead, as displayed on the lead edit page. Up to 80 characters are allowed in this field. |
Owner | Lead Owner | Assigned owner of the lead. |
Source | Lead Source | Source of lead, for example, Advertisement, Partner, or Web. Entry is selected from a picklist of available values, which are set by an administrator. Each picklist value can have up to 40 characters. |
Status | Lead Status | Status of the lead, for example, Open, Contacted, Qualified. Entry is selected from a picklist of available values, which are set by an administrator. Each picklist value can have up to 40 characters. |
Mobile | Mobile | Cellular or mobile phone number. Up to 40 characters are allowed in this field. |
Associated company. Number of employees | No. of Employees | Number of employees at the lead’s company. |
Work | Phone | Lead’s primary phone number. Up to 40 characters are allowed in this field. |
State | State/Province | State or province portion of user’s address. Entry is selected from a picklist of standard values, or entered as text. Up to 80 characters are allowed if the field is a text field. |
Job title | Title | Position of lead within his or her company. Up to 80 characters are allowed in this field. |
Associated company.website | Website | URL of company’s website, for example, www.acme.com. Up to 255 characters are allowed in this field; only the first 50 are displayed. |
Zipcode | ZIP | ZIP code or postal code portion of the lead’s address. Up to 20 characters are allowed in this field. |
created by | Created By | User who created the lead, including creation date and time. |
external_id | Data.com Key | The company’s ID in Data.com. When Salesforce records are compared with Data.com records (via manual cleaning or automated clean jobs), if Data.com finds a match, the two records are linked by this field’s numeric value. |
What are the reasons for failure?
Invalid email address - If the email addresses in your CSV/XLSX file aren’t of the proper format (e.g: jamesampleton@sales, jeangrey.com)
Unmapped Columns - Columns that aren’t mapped with any of the fields in the web application.
Improper Field Type - If the field type is different from the type of value in the column.
Drop-down Values - If you’re mapping a column with values for a picklist (such as Radio button/Checkbox/Drop down menu) with a field in the web application (also a picklist), you need to double-check that the values in the column match with the choices of the field (picklist) in the web application. For e.g: If you’ve got a column that has the values 1, 2, 3 for the Number of contacts attempted and want to map it to a radio button (field) in the web application, make sure that that radio button has 1, 2, 3 as the field’s choices.
Checkbox column values: If you want to map one of the fields as a checkbox, it should only contain True or False. If not, the import for that column would remain blank and the process will move on.
Invalid file - If the uploaded file is not a valid zip file
At Least one file is required to start the import - Ensure that the contact, account or deal file is uploaded to start the import process.