Importing Records

Reading Time: 2 minutes

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

  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. Save your file as a CSV or TXT file.

VCC Live import records screenshot

To Import Records

  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 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.

To Withdraw Records

  1. Select a project from the project list, then select Database > Import.
  2. Select a file you want to withdraw, then select Actions > Withdraw import.
  3. Press 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:

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.
Subscribe to our newsletter
or Contact us!
Please note that by subscribing to our newsletter, you agree to receive regular email messages from VCC Live® about service related news and updates. By subscribing to our newsletter, you also agree that VCC Live® will use your data in accordance with the applicable Privacy Policy until you unsubscribe from the newsletter.

Privacy Settings Center

Necessary

Necessary cookies are essential in order to navigate around a website and use its basic features. You must accept these cookies as the website cannot function properly without them.

__cfduid,debug,PHPSESSID

Marketing

Marketing cookies are used to track visitors across websites and deliver advertisements that are more relevant and engaging to you.

__atuvc,__atuvs,_at.cww,_hjIncludedInSample,_hjRecordingEnabled,ads/user-lists/#,at-lojson-cache-#,at-rand,bt2,di2,_fbp,IDE,lidc,loc,NID,ouid,r/collect,rc::a,rc::b,s,test_cookie,uid,uvc,vc,xtc

Statistics

Statistic cookies collect data to help us understand how visitors use our websites and are used to improve the user experience. These cookies don’t collect personal information and cannot identify visitors.

_ceg.s,_ceg.u,_ga,_gat,_gid,_gat_UA-1696494-11

Other

Other cookies are those cookies that do not fall into the categories above. These cookies are in the process of being classified.

loglevel,socketCluster.authToken,u,webchatClientId,webchatOpen