Importing .CSV Files In BrightGauge

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

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.

• Connecting to Dropbox

• Connecting to OneDrive

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.
   
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:
   
   • Recommended Field Types for BrightGauge CSVs
10. Click the  Test Field Types button to verify that all the selected field types match up with the content in the CSV.
     
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.
    

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.

• • Building Gauges in BrightGauge