Search

Home

Release Notes

User Docs

BDS Field Definition CSV (1)

The field definition CSV is a file you can download and upload to update the field definitions for a datasource. The CSV has a particular format to conform to in order to properly update.

Downloading CSV

Downloading a field definition is a fairly straightforward operation

  1. Log into Bettrdata
  2. Click on the “Data Source” link on the left navigation bar
  3. Click on “BD Select Sources” on the top menu bar
  4. Select your data source
  5. Click on the “Fields” tab
  6. Click on “Download CSV” to download the CSV file.

Editing

The CVS has a set of columns used to fill edit field definitions the columns are in a certain order and some columns pertain to certain field types. The columns are:

  1. name
    • The column name of the table in all-caps
  2. label
    • The label for the filter, usually corresponding to the column name, but not required
  3. displayType
    • This is the filter type. Types include
      1. number-slider
      2. number-input
      3. range-slider
      4. selection-unique
      5. selection-multi
      6. boolean
      7. data-relation
      8. multi-text
      9. date-picker
      10. contains
      11. zip-code-radius
  4. categories
    • Pipe delimited set of category name, the left most being the parent
    • Example: “Interests and Affinities|Interests|Sports”
  5. skipDefaultWhere
    • Used to designed whether this field will be included in the main query
    • See, , advanced features
  6. whereTags
    • Use to designate a sub-query
    • See, , advanced features
  7. isStatic
    • Whether the field is of type static
    • See, , fields
  8. validations.min
    • For numeric data types
    • Specifies the minimum accepted value
  9. validations.max
    • For numeric data types
    • Specifies the maximum accepted value
  10. validations.value
    1. For string data types
    2. Specifies the column table to match in the table column
  11. validations.value_label
    • For string data types
    • Specifies the displayed value
  12. validations.minDate
    • For date data types
    • Specifies the minimum accepted value
    • In date format YYYY-MM-dd’T’HH:mm:ss.SSS’Z’
    • See
      SimpleDateFormat (Java Platform SE 8 )SimpleDateFormat (Java Platform SE 8 )
    • Example: “1924-01-01T07:00:00.000Z”
  13. validations.maxDate
    • For date data types
    • Specifies the minimum accepted value
    • In date format YYYY-MM-dd’T’HH:mm:ss.SSS’Z’
    • See
      SimpleDateFormat (Java Platform SE 8 )SimpleDateFormat (Java Platform SE 8 )
    • Example: “1924-01-01T07:00:00.000Z”

Considerations

  • For multivalue choices, make sure all the rows are contiguous related to the field
  • Order of rows determines order on the UI
  • If editing in a spreadsheet application, make sure to not mistakenly add or remove columns. This can be difficult to detect. Check in a text editor (NOT Word) to see if the number of columns are correct if there are issues
  • All rows should be contiguous

Uploading CSVs

Uploading a field definition is a fairly straightforward operation

  1. Log into Bettrdata
  2. Click on the “Data Source” link on the left navigation bar
  3. Click on “BD Select Sources” on the top menu bar
  4. Select your data source
  5. Click on the “Fields” tab
  6. Click on “Upload CSV”. A dialog box appears to find the file upload.
  7. Select the file and choose “Select”
  8. A dialog box asks if you want to import the file
  9. Choose “Yes” to finish the process
image