Grow your career with VCC Live Academy by joining our free online contact center courses.

Sign up today
  • Partners
  • Talk to Sales
+44 208 638 0169
  • Product
    • Channels
      • Voice
      • Email
      • SMS
      • Chat
      • Messenger
      • Whatsapp
      • Omnichannel
    • Main Features
      • Call Center Software
      • Predictive Dialer
      • VCC Live Pay
      • Outbound IVR
      • Voicemail Detection
      • Live Dashboards
      • IVR
      • ACD
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Pricing
  • Resources
    • Blog
    • Customer Stories
    • Ebooks
    • Courses
    • Webinars
    • Information Security
    • Learning Center
    • Developers
  • Company
    • About us
    • Careers
    • News
    • Partners
Hungary
+36 19996400
UK
+44 2086380169
Germany
+49 3021782516
Poland
+48 123950886
Romania
+40 31706167
USA
+1 3024988337
Contact Us Book Demo
+44 208 638 0169
TutorialsGetting StartedCreating a Simple Database
  • Overview
    • Introduction
    • Available Tutorials
    • Legal Information
  • The Most Common Use Cases
    • Outbound Email Customization
    • IVR Settings - Use Cases
    • Outbound Calls - PPD
    • Incoming Calls - Setting up an IVR
    • The Main Agent KPIs
    • State Machine
    • Editing Scripts
    • Email Handling
    • Softphone Integration
    • Customize your Dashboard
  • Getting Started
    • About This Chapter
    • First Steps
    • Creating a Simple Database
    • Setting up Users
    • Creating a Simple Project
    • The Basics of Inbound Projects
    • The Basics of Outbound Projects
    • The Basics of Measurement Tools
    • Introduction to Dispositions
    • The Basics of Call Recording Management
    • Getting Started with VCC Live Chat
    • Get to Know the Agent Workspace
    • Dynamic Email Contents
  • Communication Channels
    • About This chapter
    • Outbound Projects
      • Manual Dialer
      • Power and Predictive Dialing Modes
      • Outbound IVR
      • Robinson List
      • Outbound-Related Statistics
      • Measuring CSAT
    • Emails and Ticketing
      • Disposition-Triggered Emails
      • Dynamic Email Contents
      • Email Attachments - Basic, Dynamic and Conditional
      • Outbound and Inbound Emails
      • Email Statistics
      • Mass Email
    • SMS
      • Inbound SMS
      • Disposition-Triggered SMS
      • Dynamic SMS Contents
      • SMS Notifications
      • SMS Statistics
      • SMS Triggered Actions
      • Scheduled SMS Sending
      • Bulk Text Messaging
    • Inbound Robinson List
    • Quota Tool
  • Managing Users
    • Resource Management
      • Multi Project Management
      • Users, Rights and Teams
    • User Activity
      • Break Codes
      • User State Log
  • Security
    • About This Chapter
    • User Right Groups
    • Password Policies and Two-Factor Authentication
    • OAuth 2.0
    • IP Filtering
    • Database API
    • Functions to Help You Comply with Privacy Regulations
  • VCC Live Archiver
    • About This Chapter
    • Introduction to VCC Live Archiver
    • Setting up VCC Live Archiver
    • Using VCC Live Archiver
    • Commands and Command Options
    • CDR Log Headers
    • Switches (Deprecated)
  • Miscellaneous
    • About This Chapter
    • Salesforce Integration
    • VCC Live Pay IVR
    • Voice File Tagging
    • Replacing Transfer Process
Back to Support and Learning Center

Creating a Simple Database

Estimated reading time: 6 minutes | Target users: New users

Managing a database is a crucial task in a contact center. While your database naturally expands as you’re handling calls, you can also upload an existing database into VCC Live

In this lesson, you will learn:

  • What a database is
  • What a record is
  • What a contact is
  • What types of databases there are
  • How do you create a database import file
  • How do you upload a database to VCC Live

1. Database

A contact center database is data repository where you store information about your existing or potential clients, and calls. It helps you organize, maintain and update your data. The database consists of records.

1.1 Records

A record contains the name, phone and other contact details, private and demographical information, buying patterns, owned products, and other information of a customer. It also includes detailed information about executed calls, such as source and destination numbers, IDs, call duration, completion status, and scheduled follow up actions.

1.2 Contacts

A record may contain contacts that include client contact details. Each record can contain up to 9 different contacts with different phone numbers, email addresses and contact names. For example, the record name is “A Company”, while its contacts may be John Smith, 49111111111, john.smith@acompany.com; Anne White, 4922222222, anne.white@acompany.com, etc.


2. Database Types

There are different type of databases.

2.1 Client Database

A client database contains all client data, which you import into VCC Live, either manually or via API.

2.2 System Database

The system database logs all information about your records, including date and time created, creation mode, time of last disposition saved and last modification, user who modified it, etc.

2.3 CDR Log

The CDR log displays all information about call attempts mad including: prework, ringing and call duration, agent who handles it, saved disposition, information about who hung up the call and more.

2.4 Events Database

The events database contains all information about each contact attempt from different channels used, such as: calls, SMS messages, emails, chat conversations, etc.

2.5 Channel Variables

Channel variables are available only under certain circumstances, eg. during a specific ongoing phone call.


3. Creating a Database

Creating a database in VCC Live requires creating a database import file, which is a spreadsheet file in either CSV or TXT format. After entering the data into the file, you can import the file into VCC Live. Records consist of fields, each of which contains a single or multiple parameters as well as text.

You’re going to manually upload a database to VCC Live. Of course, this can be done using automation as well via APIs, but we’ll look into that option later.

3.1 Creating a Database Import File

  1. Open a spreadsheet application, such as Microsoft® Office Excel.
  2. Enter “name” in cell A1. This will create a “name” field in your database. This field is mandatory.
  3. Enter “Allan Lewis” in cell A2. This will create a record in your VCC Live database.
  4. Enter “phone1” in cell B1. This will create a “phone1” field in your database. This field is mandatory.
  5. Enter “255501780” in cell B2. This phone number will be added to Allan’s record.
  6. Save your file. Name it as “VCC Live Sample Records”, and select the Comma separated values text files (.csv) or Delimited text files (.txt) format from the formats drop-down list. The final file should look like this:

3.2 Importing the Database File to VCC Live

  1. Select a project from the project list, then select Database > Import.
  2. Select Actions > Import.
  3. An import wizard window pops up. Navigate to the CSV or TXT file you want to import and select it. Press Open.
  4. Optional: if you want to import phone numbers with only a specific prefix, then mark the Show warning message if imported phone numbers do not match this prefix checkbox, and enter a prefix in the text field.
  5. Press Next.
  6. Mark or unmark the checkbox beside the fields you want to import. Select the field types. Press Next.
  7. If duplicated phone numbers or invalid values are found, you can select one of a number of options to deal with them.

4. Database Overview

You sometimes may want to take a look at the size of your database. The Database overview worksheet presents quantitative data about your database.

  • To access the Database overview worksheet, select a project from the project list, then select Database.

Note: If you want to see details of imported records, you can find them in the Records list.


5. Database Creation Summary

Whenever you are creating a database file, you need to keep in mind these:

  • The database import file must be in CSV or TXT format.
  • The first row always represents the field names.
  • The second row onwards represents individual records.
  • Each column generates a separate database field variable.

Each field you add to your database can be used:

  • In an agent script, using different control types
  • To prioritize the order of your dialing
  • To assign records to agents (skills)
  • To handle incoming calls accordingly (if and switch options)
  • To send proper email and SMS versions to your customers

Congratulations!

You’ve just learned how to create a simple database in VCC Live.

Ready for the next lesson? You’ll learn how to set up users.
Start next lesson >

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

  • Channels
    • Voice
    • Email
    • SMS
    • Chat
    • Messenger
    • Omnichannel
  • Main Features
    • Call Center Software
    • Predictive Dialer
    • VCC Live Pay
    • Outbound IVR
    • Voicemail Detection
    • Live Dashboards
    • IVR
    • ACD
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Resources
    • Blog
    • Customer Stories
    • Ebooks
    • Courses
    • Webinars
    • Information Security
    • Learning Center
    • Developers
    • Download
  • Company
    • About us
    • Careers
    • News
    • Partners
https://vcc.live/wp-content/uploads/2019/07/iso-cert-1.png https://vcc.live/wp-content/uploads/2019/07/iso-cert-2.png https://vcc.live/wp-content/uploads/2019/07/iso-cert-3.png
Social Media
https://vcc.live/wp-content/uploads/2019/07/linkedin.svg https://vcc.live/wp-content/uploads/2019/07/twitter.svg https://vcc.live/wp-content/uploads/2019/07/facebook-1.svg https://vcc.live/wp-content/uploads/2019/07/instagram-1.svg
Call us
Hungary
+36 19996400
UK
+44 2086380169
Germany
+49 3021782516
Poland
+48 123950886
Romania
+40 31706167
USA
+1 3024988337
Hungary
+36 19996400
UK
+44 2086380169
Germany
+49 3021782516
Poland
+48 123950886
Romania
+40 31706167
USA
+1 3024988337
  • Privacy Policy
  • Legal Statement
  • General Terms of Agreement