CSV Dataset Creation Requirements

CSV Requirements

Before you get ready to upload a CSV file to DropBox or OneDrive, please note the following requirements/guidelines: 

-The CSV file cannot contain:

-Blank rows 

-Blank column headers

-Duplicate column headers

-Symbols in column headers

-Column headers can be no longer than 25 characters long

-Numbers cannot have commas

-Once a dataset has been built from a CSV, Changes cannot be made to the CSV with regards to the:

-File name

-Column titles

-Column arrangement

-Number of columns

The overriding (or updated) CSV's moving forward, must be identically configured to the original CSV that was used to create the dataset, with regards to the components just mentioned above.

 

 

Accessing "Datasets" Page and "Upload From Drop Box"

Open your Data menu on the top right hand corner of the screen. Then select "Datasets".

Image_2019-11-21_at_12.58.03_PM.png

 

Once on the "Datasets" page, at the top right of the page, click on the "Upload CSV" option. 

Image_2019-11-19_at_4.57.59_PM.png

Configure DropBox Dataset "Overview"

Select Dropbox from the "Datasource" dropdown and configure the rest of the necessary fields:

Image_2019-11-21_at_1.01.13_PM.png-Select Datasource (#1 Above)

-Name your Dataset (#2 Above)

This is the name for your new dataset that will pull the data from your Dropbox csv file

-Click on "Choose File" to access the DropBox File Search (#3 Above)

Type the name of your CSV file into the Dropbox search box and hit "Enter" on your keyboard. 

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

Image_2019-11-21_at_1.30.24_PM.png

It might take some time for the search to occur, but eventually a blue link should appear below.  Click on the desired link to select your CSV file for upload.

Image_2019-11-21_at_1.28.25_PM.png

Once a file is selected, you'll be redirected back to the main dataset overview page.

- Choose the sync frequency (#4 above)

Your dataset will sync when one of its gauges is up on a dashboard. For further explanation on a dataset's Dashboard Sync Frequency, please refer to this article. 

-Check the "Contains Header Row" box if the CSV file has a header row. If it does not, you will be able to specify these column header in the next section.

 

-Click "Choose Field types" (#5 in screenshot above) to continue to the next step

 

 

Set DropBox Dataset "Field Types"

The last step is to name the columns (if no header row) and assign the field types to each column from the CSV file.

Text

Number

Date Time = All values must be in the following format:  YYYY-MM-DD hh:mm:ss:nnnn and in UTC time.  BrightGauge will convert the UTC time into your local timezone.  If it's not in UTC time, then the time (and possibly date) will be off.

Boolean = True or FalseImage_2019-11-21_at_1.22.07_PM.png

 

Once the field types have been set, click on the "Test Field Types" button at the bottom of the page. This will verify that all the selected field types match up with the content in the CSV columns. 

Image_2019-11-21_at_1.23.34_PM.png

If all fields test successfully(✓), select the "Finalize Dataset" option and you are all set. If any field returns an error(!), please review the selected field type and confirm it is set correctly.

Image_2019-11-21_at_1.25.42_PM.png

Was this article helpful?
1 out of 5 found this helpful

Comments

0 comments