Historical DB data extraction process

This guide details the process of exporting data from the On-Premise Callback historical database (VHT_RPT). If you have been asked to provide an export of the database for analysis, the steps outlined in this guide will ensure that the data is packaged in the most efficient and usable way.

Note: No Personally Identifiable Information (PII) is exposed or transmitted during this process.

Required SQL queries

You will need the following SQL queries from the Mindful Support FTP server. Contact the Support team for assistance, if needed.

  • QDump.sql
  • HistoricalOut.sql
  • Settings.sql
  • ThirdPartyInteractionData.sql (optional if needed)

Exporting data

In Microsoft SQL Management Studio, first close any open queries to ensure that configuration changes apply globally. Next, configure the following settings before executing any queries.

  • Tools > Options > Query Results > SQL Server > Results to Text

    • Output format - Select Comma delimited.

    • Deselect include column headers in the result set.

    • Deselect include the query in the results set.

image of sql management studio example sql studio options

With these settings in place, use the steps below to export the VHT_RPT database:

  1. Open the QDump.sql query (File > Open > File...)

  2. Select the VHT_RPT database in the Database dropdown menu to ensure the query will be executed on the correct DB.
    image of the database selector
  3. Click the Results to File icon, then Execute.
    image of the execute icon

  4. When prompted, name the file "QDump.csv".

  5. Repeat the export process for the HistoricalOut.sql and ThirdPartyInteractionData.sql queries, naming the outputs "HistoricalOut.csv" and "ThirdPartyInteractionData.csv", respectively.

  6. Execute the Settings.sql script next.

    • There is no need to select a database or change start/end dates for this script.

  7. Log in to https://vhtsupport.vhtcx.com/ in a web browser (Chrome recommended).

  8. Click Upload in the toolbar, then Choose File.

  9. Navigate to the query output and click Open.

  10. Click Upload to transfer the file to the root directory of the FTP server.

  11. Log out when finished.

Important:
  • We recommend running one query at a time.
  • Pay close attention to CPU utilization. If it nears 100% when running a query, cancel the query and try again after business hours, if possible. Maximizing CPU utilization can cause Callback to crash.
  • Compress each output file separately in .gz format (not .zip or .7z) before uploading.
  • Do not import the output into Excel. Doing so will corrupt the date/time stamps.