https://vcc.live/wp-content/uploads/2022/03/vcclive_main_logo.svg
  • Product
    Back to all pages
    https://vcc.live/wp-content/uploads/2023/09/call-cetner-software-test-7.svg
    Call center

    Explore our call center software for driving productivity, fueling automation, and delivering exceptional CX.

    Powering Decathlon's call center

    https://vcc.live/wp-content/uploads/2022/09/Decathlon_Austria_Thumbnail.jpg
    Why VCC Brochure Security
    https://vcc.live/wp-content/uploads/2023/09/outbound-test-3.svg
    Outbound

    Handle more live calls, boost talk time, and automate outreach with a feature-filled outbound solution.

    Features to boost outbound activities

    Automatic dialing Voicemail detection Outbound IVR Over-the-phone payments

    Fueling your outbound sales

    https://vcc.live/wp-content/uploads/2023/09/boosting-sales-thumbnail-image.jpg
    Sales teams > Case studies > Collections >
    https://vcc.live/wp-content/uploads/2023/09/inbound-icon-3.svg
    Inbound

    Swiftly resolve issues, empower omnichannel, and handle volume with ease with our CX-focused solution.

    VCC live for inbound contact centers

    IVR systems Distributing calls (ACD) Call center scripting KPI dashboard

    Transforming customer service for tbi bank

    https://vcc.live/wp-content/uploads/2023/05/tbi-interview-banking.jpg
    Customer service > Case studies > Multichannel >
    https://vcc.live/wp-content/uploads/2023/09/omnichannel-test-3.svg
    Omnichannel

    Instantly switch between your customer's preferred channels and handle multiple conversations at once.

    Key channels VCC Live supports

    Voice SMS Email Chat software Chat apps Social media

    Email, social and more for SYKES and Huawei

    https://vcc.live/wp-content/uploads/2023/09/sykes-topnav-menu.svg
    WhatsApp > Messenger > Case studies >
    https://vcc.live/wp-content/uploads/2023/09/integrations-test-4.svg
    Integrations

    Connect VCC Live with any of your trusted business tools, including CRMs, payment tools, and much more.

    Selected integrations for VCC Live users

    Salesforce Hubspot Looker (Data Studio) Docusign Dialogflow Zapier

    Handle calls without leaving Salesforce

    https://vcc.live/wp-content/uploads/2023/06/salesforce-video-1.jpg
    Looker case study > Release center > Security >
  • Solutions
    Back to all pages
    https://vcc.live/wp-content/uploads/2023/08/sales-call-center-icon.svg
    Sales teams

    Connect and sell more than ever before with an automation-led solution for driving sales success.

    Powerful BI for next-level sales

    https://vcc.live/wp-content/uploads/2023/09/effective-communicatio-case-study-topnav.png
    https://vcc.live/wp-content/uploads/2023/08/customer-service-call-center-icon.svg
    Customer service

    Orchestrate a high-volume handling and resolution-focused approach that delights customers.

    92% of calls within SLA

    https://vcc.live/wp-content/uploads/2023/09/decathlon-case-study-topnav-2.png
    https://vcc.live/wp-content/uploads/2023/08/debt-collection-call-center-icon.svg
    Debt collection

    Make collections faster and simpler to speed up repayments and recover like never before.

    94% voicemail detection rate

    https://vcc.live/wp-content/uploads/2023/09/delfin-group-case-study-topnav.png
    https://vcc.live/wp-content/uploads/2023/10/ai-topnav-icon-2.svg
    AI and automation

    Drive intelligent productivity and efficiency with VCC Live's suite of AI and automation tools.

  • Industries
    Back to all pages
    BPO Retail Banking Insurance Consumer Lending Healthcare
  • Pricing
  • Resources
    Back to all pages
    Blog Case Studies Ebooks Call Center Courses Webinars Customer interviews Information Security Telco Services Learning Center Developers Release Center Download
  • Company
    Back to all pages

    Explore more

    About us Why VCC Live Careers News Partners

    Check out our history

    https://vcc.live/wp-content/uploads/2023/09/20yrs-anniversary-thumbnail.jpg
  • Partners
  • Become a partner
  • Email us
CONTACT US VIEW DEMO
User GuidesVCC LiveCampaign ManagerImporting
  • About This User Guide
    • Introduction to VCC Live
    • General Information
    • Legal Information
    • Symbols and Notations
  • Installation and Activation
    • System Requirements
    • Firewall Settings
    • Installing VCC Live
    • Installing the MSI Package
    • Installing on Ubuntu
    • Single Sign-On
    • Connecting IP Phones
  • Learning the Basics
    • Login Screen
    • Admin Workspace
    • Accessing Settings
    • Local Settings
    • Profile and Notifications
    • Timezone Settings
    • IVR Sound Library
  • VCC Live 360
    • General Overview
      • Project selection
      • Menu and Sidebar
      • Agent Dashboard
      • Search
      • My Performance
      • Status and Break handling
      • Agent Settings
      • Comparison with VCC Live Desk
      • Browser compatibility
    • Interactions
      • Handling of Calls
      • Handling of Chats
      • Handling of Emails
      • Handling of Customers
      • Handling of Tickets
      • Activities Tab
      • Custom Call
    • Webchat
      • Setup and Usage
  • User Management
    • Managing Users
    • Managing Teams
    • Managing User Right Groups
    • Changing Agent Status
    • Customizing Break Codes
  • Project Management
    • Creating a New Project
    • Modifying Generic Project Settings
    • Deleting a Project
    • Cloning a Project
    • Mass Project Actions
    • Mass Export Project Data
  • Project-Specific Settings
    • Modifying Generic Project Settings
    • Assigning Agents to a Project
    • Assigning Agents to a Queue
    • Configuring Caller ID Settings
    • Managing Dispositions
    • Type of Dispositions
    • Managing Robinson Lists
    • Setting up After-work Limits
    • Adding Web Pages for Agents
    • Managing Tickets
  • Communication Channels
    • Outbound Calls
      • Outbound Call Handling
      • Dialing Modes
      • SIP Trunk Phone Numbers
    • Inbound Calls
      • Inbound Call Handling
      • Inbound Processes
    • SMS
      • SMS
      • SMS Unicode Character Encoding
    • Chat
      • Live Chat - Website Integration
      • Live Chat - Facebook Integration
      • Live Chat - WhatsApp Integration
      • Messaging channel integrations
    • Email
    • Social Media
  • Database Management
    • Database Management Overview
    • Managing Fields
    • Importing Records
    • Exporting Database
    • Updating Databases
    • Searching Contacts and Records
    • Managing Records List
    • Removing Data
    • Managing the Quota Tool
    • Data Extraction Overview
  • Datasheet and Script Management
    • Datasheets and Scripts Overview
    • Managing Datasheets and Scripts
    • Customizing Datasheets and Scripts
    • Types of Controls
  • Quality Management and Call recordings
    • Quality Management Tools
    • Quality Management Statistics
    • Manage Call Recordings
    • Downloading and Listening to Call Recordings
    • Voice File Name Parameters
  • Monitoring
    • Dashboards
    • Real Time Monitoring
    • Inbound Wallboard
    • Quota Wallboard
  • Logs and Statistics
    • Overview
    • CDR Log
    • Chat Log
    • Email Log
    • SMS Log
    • User Activity Log
    • User State Log
    • Database Statistics
    • Disposition Statistics
    • Global Inbound Statistics
    • Network Information
    • User-Based Statistics
    • Project-Specific Inbound Statistics
    • Project-Independent CDR Search
    • Weekly Inbound Statistics
    • Webhook Statistics
    • Global Call Statistics (Deprecated)
    • Project-Specific Call Statistics (Deprecated)
  • Internal Communication
    • Silent Coaching and Whispering
    • Using the Internal Chat
    • Using the Phone Book
    • Releasing News for Agents
  • Subscription Management
    • Prepaid Billing
    • User License Management
    • Checking Your Balance
    • Transaction Details
    • Downloading Invoices
    • Restriction Procedure
    • Bank Transfer Guide
    • Buying Phone Numbers
    • Creating Pro Forma Requests
  • Account Security
    • Changing Your Password
    • Data Deletion After Contract Termination
    • Using a Password Policy
    • Restricting Access Based on IP Addresses
    • Using Two-Factor Authentication
  • AI Capabilities
    • Google Dialogflow ES
    • Google Dialogflow CX
    • Netlife Robotics
    • Biometrid Voice Biometrics
    • Multi-Project Dialing and Inherited Projects
  • Campaign Manager
    • Introduction
    • Importing
    • Advanced Filter
    • Using Filters and Collections
    • Loading from Collection to Campaign
    • Exporting
    • Automatic Import
  • VCC Live for Salesforce
    • Installing VCC Live for Salesforce
    • Agent Workspace
    • Synchronizing Call log to Salesforce
    • Custom Call Pop Setup
  • VCC Live for HubSpot
    • Installing VCC Live for HubSpot
    • Agent Workspace in HubSpot
    • Log interactions in HubSpot
  • Over-the-Phone Payment
    • Introduction to VCC Live Pay
    • Changing Payment Settings
    • Checking Transaction History
    • Security Considerations
  • Agent Workspace
    • Project Selection Screen
    • Agent Workspace
    • Keyboard Shortcuts
    • Using Break Codes
    • Using the Internal Chat
    • Using the Agent Browser
    • Handling Calls
    • Handling Emails and Tickets
    • Handling Chat Messages
    • User States
Back to Support and Learning Center

Importing

Importing in our Campaign Manager interface lets you upload your databases and use them in VCC’s own Database section.

Table of Contents

  • 1. Overview
  • 2. Custom Fields
  • Required and Unique
  • Import Templates
  • Add a new template
  • Edit a template
  • Delete a template
  • Rename a template
  • File to Database – Step 1 of 3
  • File to import
  • Import template
  • Handling duplicates
  • The difference between Keep new only and Override existing
  • File to Database – Step 2 of 3
  • Uploading your file
  • File to Database – Step 3 of 3
  • Your import is ready
  • Import history
  • Database import log
  • From Database to Collection
  • The Collection Tab
  • About the filters
  • From Collection to Campaign

1. Overview

To get a clear understanding of the import workflow, here is an overview of the main steps from uploading an offline CSV file database to using its records in a campaign.

Offline CSV → Database → Filtering, sorting → Collection → Campaign

  1. Most commonly a source file that contains the records is a CSV file, which is imported to the Campaign Manager database, as described below in the File to Database section.
  2. From the Database, following a filtering and sorting process, the filtered results are loaded into different collections.
  3. From a collection, records are loaded into various campaigns that are used by agents. For example:
    • 60% of Collection_1 is loaded to Campaign_A, and
    • 40% of Collection_1 is loaded to Campaign_B.

Note: You can also import data to a Database via API. Check out the related documentation about how to add and modify Customer data here.

2. Custom Fields

Using custom fields is a way to add more, customized attributes to your database. You can use these later on for filtering and sorting purposes. It is optional to create and use custom fields.

To add custom fields:

  1. Select one of your Campaign Manager projects
  2. Click on the Custom fields tab
  3. Select Add new field
  4. Type a name for your field, then set up the other attributes (Required, Unique, Field type)
  5. Press Save

Required and Unique

You can set the Required and Unique attributes to your custom field, but what do they mean exactly? Let’s take a closer look.

Required
It means that the offline database you want to import must include this field, and the field must contain values, otherwise the database and/or lines from the database are not imported to VCC Live.

Unique
It is a mandatory attribute if you want to use VCC Live’s duplication handling process, meaning that at least one of the custom fields needs to be set as unique to enable duplication handling.

If a field is set as unique, then the offline database you want to import must include this field, and the field must contain values, otherwise the database and/or lines from the database are not imported to VCC Live. Important: the values must be also unique in a sense that each line of your database must have a different value for this field.

To illustrate this with some real-life examples: typical fields that can be considered as unique are: IDs or email addresses. Typical fields that cannot be considered as unique are: places of birth, preferred political parties, etc.

Note: If you have a custom field that is set as unique, then it needs to be added to your import template (see next chapter). You can set more than one field as unique.

Tip: If you want to have your database imported without any sort of filtering, then do not set any field as unique.

Adding custom fields to the database

Import Templates

Before you start importing your database, you need to create and set up an import template.

The import template section is located in the upper right-hand corner of the Campaign Manager interface, behind the meatball menu (three-dot icon) as Import templates.

Opening template settings

Add a new template

To create a new template:

  1. Click on the + icon next to the title
  2. Enter a name for your new template
  3. Press Create

Note: If you have a custom field that is set as unique, then it needs to be added to your import template (at least one).

Edit a template

Below you can find a list of available actions you can do to edit your template.

Add a mapping attribute row to the template

Click on the + Add mapping attribute button, so you can start creating the template. To have more rows of mapping attributes, simply click on the + Add mapping attribute button again.

Assign a Column name to a Database field in a mapping attribute

In the first column, enter the column name of your database file you are about to import, then in the second column enter the Database field name that is assigned to the source file’s column name.

In case of contact data types (such as contact title, contact, name, contact phone, contact email), you can further select which contact (1-9) you want the selected field to be assigned.

Setting up import template

Once you have added and edited all your necessary mapping attributes, press either Save changes or Save and close.

Delete a mapping attribute row in the template

Click on the red cross icon at the end of the mapping attribute row.

Delete a template

  1. Click on the kebab menu (vertical three-dot icon) next to the name of the template.
  2. Select Delete template.
  3. Confirm deleting the template in the pop-up window.

Rename a template

  1. Click on the kebab menu (vertical three-dot icon) next to the name of the template.
  2. Select Rename
  3. The name of the template becomes highlighted and editable.
  4. Press Enter or click elsewhere in the window to confirm your changes.

File to Database – Step 1 of 3

File to import

  1. Click on the Import button in the upper right-hand corner of the Campaign Manager interface.
  2. Locate the database file to be imported from your local drive. This file should be in CSV format.

You can either drag and drop it from your computer’s file management window or you can click browse file, and upload it right away.

Import template

Import templates are used for recognizing the file structure of your uploaded file. Moreover, it determines how CSV fields and your custom fields in VCC are paired.

From the dropdown list, select one of the import templates you have set up.

Handling duplicates

If you are importing your CSV to the Campaign Manager database, there might be cases when your imported file contains data that already exists in VCC. In this case, the importing process would result in creating duplicate files. In order to handle this in a clear and understandable way, there are a few options you can choose from:

  1. Ignore duplicates

  2. Consider and sort out duplicates

    2.1 Keep existing: The import process ignores the ‘new’ record data in the imported file and keeps only the record already existing in the Campaign Manager database. During the import process, the already existing record data in the Campaign Managers database do not get updated as per the imported file, yet new records do get imported to the database and appear in the Campaign Manager as new lines. Therefore, if one particular record already exists in the database (as per the unique custom fields), then the update does not take place.

    2.2 Keep new only: The import process overwrites entirely the record already existing in the Campaign Manager database and keeps the ‘new’ record’s data in the imported file only.

    2.3 Override existing: With the exception of empty values, the import process updates the existing record data in the Campaign Manager database with the ‘new’ record’s attributes.

Note: In order to enable duplicate handling, you need to have at least one custom field set as unique. Learn how to set a field as unique in the Custom Fields chapter above. If this is set, then duplicate handling for phone numbers and email addresses is carried out automatically.

The difference between Keep new only and Override existing

The best way to describe the difference between the two is to use an example:

If one of the attributes of the already existing record holds a value and the same attribute of the new record is an empty value, then

  • In case of Keep new only, this attribute would be an empty one, but
  • In case of Override existing, this attribute would keep its original value

File to Database – Step 2 of 3

Uploading your file

Uploading your database file takes place on this screen. Based on the size of your file, this might take several minutes to finish.

Import in progress

File to Database – Step 3 of 3

Your import is ready

On this screen, you can see the number of records that have been successfully uploaded, and the number of records the system could not upload.
These errors are listed on this screen, so you can see what caused the problem. You can also download these errors, so you can correct them, and then upload them again.

Pressing Finish import finalizes the import process, and your new records will appear in your Campaign Manager database.

To indicate the successful import of your CSV file, a green toaster appears in the bottom right corner of your screen.

Successful import

Import history

Based on the importing workflow described above, you can find a database import log in the application as well. Find a brief description of each of them below.

Database import log

This log includes all CSV files that were imported to the Campaign Manager database. For each file, you can find the following information:

  • Name of the file
  • Number of records
  • Completed: The number of Customer records already loaded to the application. In case of an import that is in Progress, this will continuously increase.
  • Date of import
  • Name of the user who performed the file import
  • Status of the import (Finished, Failed, Validating, InProgress or Canceled)

Finished: The import process is carried out successfully.
Failed: An error occurred during the import process and it was not carried out.
Validating: It means that the import process has stopped for some reason, early in the process. By clicking on the three-dot icon and selecting Open import, you can continue the import process.
InProgress: The import process is in progress at that moment.
Pending: The import process is over, but finalization is required from the user to finish the import process.
Canceled: The import process has been stopped by a user.

You can reach it by navigating to the History tab.

From Database to Collection

Collections are groups of records compiled with a specific goal in mind, prepared to be used in one or more campaigns. Once you have created a database, the next step is to load a certain part of it (or all of its records) to one or more collections. Here’s how to do it:

  1. Navigate to the Campaign Manager interface and select the Database you want to use.
  2. Use the Advanced Filter to create a specific list of results you want to use in a collection. To learn more about the Advanced Filter, please visit our related guide.
  3. In the upper right-hand corner, select Load to collection… from the meatball menu (three-dot icon).
    3.1 If you want to load it to a new collection, select the New tab and enter a name for your collection.
    3.2 If you want to load it to an existing collection, choose the Existing tab and select the collection you want to use.
  4. Press the Load to collection button.

To indicate the successful loading process of the filtered database, a green toaster appears in the bottom right corner of your screen.

Records added to collection

The Collection Tab

The Collection tab lets you monitor, edit or remove the collection you have created, before loading it to a VCC Live campaign.

On the main interface, you can see the most important details of your collection, indicated in separate columns.

  • Name shows the name of your collection
  • Assignable shows how many records can be assigned to a campaign. In other words, it shows the number of records left from the total collection, that can still be used for a campaign.
  • Created by shows the name of the user who made the collection
  • Created at shows the time and date of the creation
  • Total shows the total number of records included in the collection
  • Active shows how many records are currently active in this collection
  • Filter assigned shows the name of the filter that is applied to the collection.

About the filters

Filters are set to monitor new additions to your database. This means that when a new set of data (records) is added to your Customers list, then the filter in the Collections tab is applied to the new dataset and Collections will include new records if the filtering rule applies to them.

If you modify a filtering rule, that results in leaving out records from the collection, then our system does not actually remove those records, it just sets their status as inactive.

Please note, that collections are auto-updated as described above only when a filtering parameter is assigned. If you don’t want your collection to be affected by further database uploads, then simply apply “No filter” to your collection.

From the three-dot menu, you can access further actions for your collection:

  • Open collection: Opens the collection and shows the active records.
    • Active records mean that those can be loaded into a campaign.
    • Inactive records mean that these are not loaded to a campaign. This appears when a filter is assigned to the collection because you are not planning to load all records to a campaign.
  • Edit: Here you can rename the collection, assign filters, or set a duplication handling rule. The collection’s contents are automatically updated, based on the selected filter’s scope. Changing the filter also modifies the collection’s records.
  • Delete: It removes the collection from the list.

From Collection to Campaign

Campaigns are focused efforts for your business to break down your customer interactions into segments to create or capitalize on opportunities to generate more sales or better service.

Load data from collections to campaigns

You can create campaigns by adding collections to them. Here’s how to do it:

  1. Navigate to the Collections tab on the Campaign Manager interface.
  2. Hover the mouse over one of the Collections and select Add to campaign.
  3. Refine the matching records and set the number of records to distribute to one or more campaigns (optional step).
  4. Choose your target campaigns. You can use the vertical scroll bar to look up the ones you need to find, or you can use the search bar instead. Once you have selected all of them, press Done.
  5. Define the distribution proportion: here you can set precisely how many records should each campaign receive. Indicating the current status of your distribution, you can find a status bar on the top of this pane.
  6. If you have set up your records accordingly, press Load records.

To indicate the successful loading process of the filtered database, a green Uploaded icon appears in the bottom right corner of the pop-up window.

Related articles

There's always more to learn. Discover similar features by visiting related articles:

Exporting

August 20 in User Guides
Back to Support and Learning Center

Comments

Can’t find what you need? Use the comment section below to connect with others, get answers from our experts, or share your ideas with us.


There are no comments yet.

Click here to cancel reply.

Please note that by clicking on the Submit button, you agree to a member of VCC Live team contacting you with business offers. You can find detailed information on how we can establish contact with you in our Privacy Policy

illustration

Product

  • Call center
  • Outbound
  • Inbound
  • Omnichannel
  • Channels
  • Integrations
  • More on VCC

Main Features

  • IVR system
  • Auto dialer
  • Call queuing software
  • Automatic Call Distribution
  • Call center scripting tool
  • Outbound IVR
  • Predictive dialer
  • Voicemail detection
  • Contact center dashboard

Solutions

  • Customer Service
  • Sales Teams
  • Debt Collection
  • AI and Automation
  • BPO
  • Retail
  • Financial Services
  • Banking
  • Insurance
  • Consumer Lending
  • Healthcare

Resources

  • Blog
  • Case Studies
  • Ebooks
  • Call Center Courses
  • Information Security
  • Learning Center
  • Download
  • Telco services
  • Call center KPI library

Company

  • About us
  • Why VCC Live
  • Careers
  • News
  • Partners
https://vcc.live/wp-content/uploads/2022/03/iso-cert-1-min.png https://vcc.live/wp-content/uploads/2022/03/iso-cert-2-min.png https://vcc.live/wp-content/uploads/2022/03/iso-cert-3-min.png https://vcc.live/wp-content/uploads/2025/04/SOC2-website-e1745483442463.png

Social Media

https://vcc.live/wp-content/uploads/2022/03/linkedin-footer.svg https://vcc.live/wp-content/uploads/2022/03/twitter-footer.svg https://vcc.live/wp-content/uploads/2022/03/facebook-footer.svg https://vcc.live/wp-content/uploads/2022/03/instagram-footer.svg

Call us

https://vcc.live/wp-content/uploads/2022/03/flag-hu.png Hungary
+36 19996400
https://vcc.live/wp-content/uploads/2022/03/flag-en.png UK
+44 2086380169
https://vcc.live/wp-content/uploads/2022/03/flag-de.png Germany
+49 3021782516
https://vcc.live/wp-content/uploads/2022/03/flag-pl.png Poland
+48 123950886
https://vcc.live/wp-content/uploads/2022/03/flag-ro.png Romania
+40 31706167
https://vcc.live/wp-content/uploads/2022/03/flag-usa.png USA
+1 3024988337
  • Privacy Policy
  • Cookie Policy
  • Legal Statement
  • General Terms of Agreement
  • Magyar nyelvű jogi dokumentumok
illustration