• Partners
  • Email Us
  • Product
    • Channels
      • Voice
      • Email
      • SMS
      • Chat
      • Messenger
      • Omnichannel
    • Features
      • Predictive Dialer
      • VCC Live Pay
      • Outbound IVR
      • Inbound IVR
      • Voicemail Detection
      • Live Dashboards
      • ACD
      • Salesforce Integration
      • Dialogflow
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Pricing
  • Resources
    • Blog
    • Case Studies
    • Ebooks
    • Courses
    • Webinars
    • Information Security
    • Learning Center
    • Developers
  • Company
    • About us
    • Careers
    • News
    • Partners
  • Partners
  • Email Us
+44 208 638 0169
GET STARTED
User GuidesVCC LiveDatabase ManagementImporting Records
  • 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
    • Single Sign-On
    • Connecting IP Phones
  • Learning the Basics
    • Login Screen
    • Admin Workspace
    • Accessing Settings
    • Local Settings
    • Profile and Notifications
    • IVR Sound Library
  • 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
    • Managing Robinson Lists
    • Setting up After-work Limits
    • Adding Web Pages for Agents
    • Managing Tickets
  • Communication Channels
    • Outbound Calls
    • Inbound Calls
    • SMS
    • SMS Transliteration
    • Email
    • Chat - Website Integration
    • Chat - Facebook and Whatsapp Integration
    • Social Media - Handling Facebook Comments
  • Database Management
    • Database Management Overview
    • Importing Records
    • Exporting Database
    • Updating Databases
    • Searching Contacts and Records
    • Managing Records List
    • Managing Fields
    • 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
    • Quality Management Tools
    • Quality Management Statistics
    • Downloading and Listening to Call Recordings
  • Monitoring
    • Dashboards
    • Real Time Monitoring
    • Call Wallboard
    • 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 Call Statistics
    • Global Inbound Statistics
    • User-Based Statistics
    • Project-Specific Call Statistics
    • Project-Specific Inbound Statistics
    • Project-Independent CDR Search
    • Weekly Inbound Statistics
    • Webhook Statistics
  • Internal Communication
    • Silent Coaching and Whispering
    • Using the Internal Chat
    • 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
  • Campaign Manager
    • Introduction
    • Importing
    • Advanced Filter
    • Using Filters and Collections
    • Loading from Collection to Campaign
    • Exporting
    • Automatic Import
  • VCC Live for Salesforce
    • VCC Live for Salesforce
  • 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
  • References
    • Dialing Modes
    • Multi-Project Dialing and Inherited Projects
    • Dispositions
    • Inbound Processes
    • Polygon Voice Recognition
    • Google Dialogflow
    • Voice File Name Parameters
Back to Support and Learning Center
English Hungarian

Importing Records

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.

Table of Contents

  • To Prepare a File to Import
  • Set up contacts to be called later
  • To Import Records
  • To Withdraw Records

To Prepare a File to Import

  1. Open a spreadsheet application, such as Microsoft® Office Excel.
  2. Enter field names in the first row, each in a separate column. “name” and “phone1” fields are mandatory.
  3. Enter your records below the first row, one record per row.
  4. Please note that there is a 64-character limit regarding the following cells in your database: contactX.name, contactX.title
    (X is a value between 1-9, e.g.: contact1.name, contact2.name, …, contact9.name). If one of these cells exceed this limit, our system will not be able to import your database.
  5. Save your file as a CSV or TXT file.

VCC Live import records screenshot

Set up contacts to be called later

It is possible to include system-related fields in the import file as well, such as next_contact. Next_contact can be used for setting up a specific time and date for a contact to be called by VCC Live. It is practical if you do not want to have a contact to be called immediately once the import process is done, but at a later point in time.

To achieve this, you need to create a new column in your database and the columns name needs to start and end with two underscore character.( _ ) Following the above example, a new columns header then shold be:

__next_contact__

Note: The format of the next_contact is as follows: “2017-01-17 11:00:00”

To Import Records

  1. Select a project from the project list, then select database.menu.label > import.menu.label.
  2. Select action.toolbarbutton.label > import.menu.label.
  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 import_wizard_prefix_checkbox.label checkbox, and enter a prefix in the text field.
  5. Press next.button.label.
  6. Mark or unmark the checkbox beside the fields you want to import. Select field types. Press next.button.label.
  7. If duplicated phone numbers or invalid values are found, you can select one of a number of options to deal with them.

To Withdraw Records

  1. Select a project from the project list, then select database.menu.label > import.menu.label.
  2. Select a file you want to withdraw, then select action.toolbarbutton.label > withdrawal_of_import.button.tooltiptext.
  3. Press buttonDialog.button.yes.

Note: You can only withdraw records that were not used, for example, an agent has not contacted the record.

Related articles

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

Exporting Database

July 05 in User Guides

Updating Databases

September 06 in User Guides

Searching Contacts and Records

February 21 in User Guides

Managing Records List

February 28 in User Guides

Managing Fields

April 20 in User Guides

Database Statistics

July 10 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

  • Channels
    • Voice
    • Email
    • SMS
    • Chat
    • Messenger
    • Omnichannel
  • Main Features
    • Call Center Software
    • Predictive Dialer
    • VCC Live Pay
    • Outbound IVR
    • Inbound IVR
    • Voicemail Detection
    • Live Dashboards
    • ACD
    • Salesforce Integration
    • Dialogflow
  • Solutions
    • Customer Service
    • Sales Teams
    • Debt Collection
    • Virtual Call Center
  • Resources
    • Blog
    • Case Studies
    • 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
  • Cookie Policy
  • Legal Statement
  • General Terms of Agreement
  • Magyar nyelvű jogi dokumentumok