Knowledgebase articles
- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
- Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
- Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
- GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
- Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
- Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
- Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
- Email Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
- Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
- Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Reporting
- Introduction to Reporting
- Using Reports
- Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
- Transaction Documents
- Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
- Introduction to Transaction Documents
- Auditing
- Configuration
- Introduction to System Administration
- Users & Security
- Preferences
- Database
- Accounting
- Email & Integration
- Customisation
- Creating & Modifying Picklists
- Theme
- Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Automation
- Contact Support
- Releases & Roadmap
Quick Import (BETA)
Last updated : 19/09/2024Fast Import makes it possible to upload large quantities of data into Workbooks very quickly. In contrast to the standard Import job which works through roughly 10 records a second, the Fast Import functionality will work through several thousand records a second. This option can be found within the typical Import wizard under Import Options. Though extremely beneficial when needing to get large amounts of data into Workbooks fast, this functionality does have some limitations which are outlined below:
Custom Records: Fast Importing is available for Custom Records types only that are NOT searchable. This is outlined in the description of Quick Import within the Import Wizard.
NOTE: If you cannot see the ‘Quick Import’ checkbox even though you know it is a custom record, the record may be set to Searchable. You can double check and amend this by going to Start > Configuration > Customization > Custom Record > Select the Custom Record you are looking for > Expand the ‘Advanced’ section and scroll down to find and untick the ‘Searchable’ check box.
Unable to Audit: Selecting the checkbox to ‘Enable audit of imported records’ can significantly slow down the import job which is the opposite of what is needed, so audit functionality is not possible. When ticking the ‘Quick Import’ checkbox, the option for auditing import records will subtly change to ‘Delete Existing’ Records.
Add/Replace Records: As shown in the video above, when the checkbox for ‘Quick Import’ is ticked, the option for Auditing Import Records changes to ‘Delete Existing’. This is because the ‘Fast Import’ functionality will only allow you to create new Records or replace existing Records. You will not be able to update any Records with this process. Leaving the checkbox unticked will create new Records and ticking the checkbox will replace existing Records.
NOTE: Please be conscious of data you are Importing. Importing large batches of data increases the chance of duplicating already existing Records. It is the Users responsibility to manage this to ensure quality data within your Database.
Once Quick Import is selected, the rest of the process is the same as your usual Import. You will be able to review your upload file and manage your Field Mappings in the following stages before confirming to run the Import.
This functionality is beneficial for a number of reasons and an example of one may be that you want to Import hundreds of thousands of Records everyday and maintain a history of those records. This can now be done quickly due to the Fast Import process and by taking a copy of that data at the end of every week or month with a Snapshot Report.
If you have any issues with Fast Importing and your questions cannot be answered in the information on this page, please review the Imports Troubleshooting article. If you still require more assistance then please do not hesitate to contact Workbooks Support.