- Welcome to the Knowledge Base
- Desktop Environment
- Forecasts & Quotas
- Importing Data
- Marketing Campaigns
- Upload Library
- Mail Shots
- Using HubSpot with Workbooks
- People & Organisations
- Introduction to Reporting
- Displaying Reports
- Creating Reports
- Reporting Explained
- Emailing Scheduled Reports
- Sharing Reports
- Using Formulae
- Displaying reports within Record Views
- Audit Reporting
- Introduction to Transaction Documents
- Credit Notes
- Customer Orders
- Supplier Orders
- Contract Management
- Adobe Sign Integration
- Workbooks Mobile Client
- Introduction to the Outlook Connector
- Using the Outlook Connector
- Before downloading the Outlook Connector
- System Requirements
- Installation Guide
- First Run Assistant
- Download/update the Outlook Connector
- Outlook Connector Troubleshooting
- Exchange Server Sync
- Introduction to System Administration
- Users & Security
- Email & Integration
- Creating & Modifying Picklists
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- PDF Configuration
- Releases & Roadmap
- Workbooks Glossary
- Contact Support
Introduction to Importing
Take a considered view before importing data from a legacy system - do you really need all your old data?
If you have existing data in other CRM systems, databases or spreadsheets, you can import it into Workbooks from a CSV (Comma Separated Value) file. CSV files are a standard way of exchanging data between systems. Workbooks Import tool is extremely powerful and allows you to carry out various types of import, for example:
- Carry out a 'simple' import of new data of just one record type, such as importing new Organisations or new Sales Leads or new Products.
- Import new records and 'link' them to existing records on your database. For example, you might want to import new People records and link them to existing Organisation records (because the person is employed by that Organisation), or you might want to import Activities (Tasks or Meetings) that are linked to existing People records.
- Extend the type of import you are carrying out so that you can import more than one record type at the same time. For example, you can import new People records with associated Activities, at the same time.
- Update the fields on existing records. Data that has been taken out of Workbooks for cleansing can be imported and the amended data overwrites the existing information. When using the update mode you can choose between simply updating existing records, or updating existing records AND creating new records, where there is not currently an existing record.
Each import type is based on a specific record type. Below is a list of the types of records that Workbooks can import:
Campaign Membership (click here for worked example)
As already mentioned, when importing some record types it is possible to create additional related records at the same time by extending your import to include a different record type.
For example, when using the People import, Notes, Tasks, Meetings, and Organisations related to that Person can be created at the same time as the Person record; and when importing Opportunity or Contract records you can import the Line Items applicable to those records.
Click here for a list showing record types that can be imported, and which other record types can be imported at the same time, together with information on which fields are mandatory when importing.
To help make your imports successful, follow the steps below:
- Cleanse the data.
- Map the fields from your source data against your Workbooks fields and run the import.
- Review the imported data.
- Approve the data (thus making it available to users).
The first step doesn't involve Workbooks. From step 2, Workbooks provides an easy to use Wizard to guide you through the process. To help you with preparing your data you can create Import Templates relevant to your database from Workbooks.
The Import Template contains columns corresponding to fields of your chosen record type enabling straight-forward one-to-one field mapping at the mapping stage. The Import template can also include additional columns for any record types you chose to extend to. For more information about Import Templates, click here.