Updating Databases

Reading Time: 2 minutes

You can mass update your database records.

Table of Contents

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 > Import.
  2. Select Actions > Update database.
  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, then Finish.

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