Importing .CSV Files In BrightGauge

This article will provide a walkthrough on importing the bvoip CSV files into BrightGauge.

Updated at July 27th, 2024

1stream Core Required

1stream Core Required

This feature is available for only 1stream Core licensed users and higher plans. If you don't have this and would like this feature to be available, please reach out to your Sales Representative to upgrade user licensing.

 

Where do I get the CSV?

The CSV files discussed in this article are generated automatically every hour when 1stream is connected to Dropbox or OneDrive

If the CSV file was recently added to the Dropbox or OneDrive account, please allow a few minutes for it to sync before trying to search and create a dataset from it.

Setting up the Datasource

Follow BrightGauge's official documentation on how to setup their OneDrive or Dropbox integration to access the account you configured in the 1stream integration.

Uploading a .CSV File

  1. Login to BrightGauge.
  2. Go to the Data > Datasets menu in the top right.
  3. Click the Upload CSV text.
  4. In the Datasource drop-down, select either the Dropbox or OneDrive option.
  5. In the Name Your Dataset field, enter a name for the dataset. This is the name for the new dataset that pulls the data from the uploaded CSV file.  
  6. In the File Path field, click the Choose File button A pop-up will appear to allow the entering of the file name where the CSV can be located, this should be 1streamCallSummary.csv or 1streamQueueStatuses.csv.
  7. Select the Contains Header Row checkbox, as both of the CSV files have headers.
  8. In the Dashboard Sync Frequency drop-down, select 1 hr. For further explanation on a dataset's Dashboard Sync Frequency, please refer to  this article.
    image-png-Feb-07-2024-03-26-39-5600-PM
  9. Click the Choose Field Types button to assign the field types to each column from the CSV file. You can find a recommend list at the article below:
  10. Click the  Test Field Types button to verify that all the selected field types match up with the content in the CSV.
     BGcsv3
  11. Click the Finalize Dataset button if all fields test successfully. If any field returns an error, please review the selected field type and confirm it is set correctly. 
  12. In the Client Mapping Column, select the No Client Column option and click Save Dataset.
    image-png-Feb-07-2024-03-58-16-5905-PM

Next Steps

Repeat the steps as needed for each additional dataset you need to add, then you can follow the guide below to build out the gauges.

File Location Notice

If an Enterprise Dropbox account was used to connect Dropbox to BrightGauge, the file must be located under the folder of the user who authorized the connection. For personal Dropbox accounts, the file may be placed in any folder within the account. 

Tip: If you are having trouble finding your files in the search, type .CSV into the search field and wait a bit for your files to show.