• Partners
  • Email Us
  • Product
    • Channels
      • Voice
      • Email
      • SMS
      • Chat
      • Messenger
      • WhatsApp
      • 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 ManagementUpdating Databases
  • 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

Updating Databases

You can mass update your database records.

Table of Contents

  • To Prepare a Database Update File
  • To Update your Database

To Prepare a Database Update File

  1. Open a CSV or TXT file containing your records in a spreadsheet application, such as Microsoft® Office Excel.
  2. Select a full column (representing a field in the database) that you want the system to recognize as an identifier, and cut and insert it as the first column. This tells the system which records you want to update. If it is a system field, then you need to insert two underscores (__) at the beggining and end of the field name. If it is a project field, no additional characters are needed.
  3. The second and other columns contain the fields that you update. If it is a system field, then you need to insert two underscores (__) at the beggining and end of the field name. If it is a project field, then you need to insert (field.) at the beginning of field name.
  4. Make your changes to the field values as required.
  5. Save your file in a CSV or TXT format.

Tip: If you want to update single parameter or multiple parameter fields, value IDs must be used instead of names. Multiple values separator is a vertical bar: |.

Note: For more details about field categories and types, see Managing Fields.

VCC Live mass update database screenshot

To Update your Database

  1. Select a project from the project list, then select database.menu.label > import.menu.label.
  2. Select action.toolbarbutton.label > update.button.tooltiptext.
  3. An update wizard window pops up. Navigate to the CSV or TXT file you want to import and select it. Press Open.
  4. Select one or more dispositions. Only records terminated with the selected dispositions will be updated.
  5. Press next.button.label, then finish.button.label.

Note: Please note that there is a 64-character limit regarding the following cells in your database: contactX.name, contactX.title, contactX.phone (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 handle your database.

Related articles

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

Importing Records

February 25 in User Guides

Exporting Database

July 05 in User Guides

Searching Contacts and Records

February 21 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