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® Desk.
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® Desk
What’s a 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.
What’s a Record?
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.
What’s a Contact?
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, email@example.com; Anne White, 4922222222, firstname.lastname@example.org, etc.
What Are The Different Types of Databases?
There are different type of databases:
Client database: It contains all client data, which you import into VCC Live® Desk, either manually or via API.
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.
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.
Events database: Contains all information about each contact attempt from different channels used, such as: calls, SMS messages, emails, chat conversations, etc.
Channel variables: Available only under certain circumstances, eg. during a specific ongoing phone call.
How to Create a Database Import File
You can import records from a spreadsheet file in either CSV or TXT format into your database. Records consist of fields, each of which contains a single or multiple parameters as well as text.
How to Upload a Database Into VCC Live® Desk
We’re going to manually upload a database into VCC Live® Desk. Of course, this can be done using automation as well via APIs, but we’ll look into that option later.
Let’s Create a Database Import File
- Open a spreadsheet application, such as Microsoft® Office Excel.
- Enter “name” in cell A1. This will create a “name” field in your database. This field is mandatory.
- Enter “Allan Lewis” in cell A2. This will create a record in your VCC Live® database.
- Enter “phone1” in cell B1. This will create a “phone1” field in your database. This field is mandatory.
- Enter “255501780” in cell B2. This phone number will be added to Allan’s record.
- 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:
Now, Let’s See How to Upload This File to VCC Live® Desk
- Select a project from the project list, then select Database > Import.
- Select Actions > Import.
- An import wizard window pops up. Navigate to the CSV or TXT file you want to import and select it. Press Open.
- 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.
- Press Next.
- Mark or unmark the checkbox beside the fields you want to import. Select the field types. Press Next.
- If duplicated phone numbers or invalid values are found, you can select one of a number of options to deal with them.
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
- And much more
Overview of Your Database
You sometimes may want to take a look at the size of your database. The Database overview page can help you with that, as it presents quantitative data about your database.
To access the Database overview interface, select a project from the project list, then select Database.
If you want to see details of imported records, you can find them in the Records list.