Checklist: challengers.csv data file format

[MattTriano]

Requirements for the challengers.csv data file format

Per page 26 of the policy notice and Notices of Changes to the process.

Column Names and Order:

1. challenger
2. category
3. organization
4. webpage
5. provider_id
6. contact_name
7. contact_email
8. contact_phone

• Correct column names
  • test: test_challenger__column_names
• Correct column order
  • test: test_challenger__column_order

Column Data Types and Content Requirements

• challenger (dtype: string): required not null.
  • test: test_challenger_col_content__challenger
• category: (dtype: Enum in [B, L, N, T], i.e. single-char string), required not null.
  • test: test_challenger_col_content__category
• organization: (dtype: string), required not null.
  • test: test_challenger_col_content__organization
• webpage: optional; should look like a URL if not null.
  • test: test_challenger_col_content__webpage
• provider_id: (dtype: string) If not null, must be a six digit integer.
  • test: test_challenger_col_content__provider_id
• contact_name: should look like a full name, required not null.
  • test: test_challenger_col_content__contact_name
• contact_email: should look like an email address, required not null.
  • test: test_challenger_col_content__contact_email
• contact_phone: optional; must match the pattern ddd-ddd-dddd if not null.
  • test: test_challenger_col_content__contact_phone

Columns Required to be Not Null

• [challenger, category, organization, provider_id, contact_name, contact_email]

• Check that these aren't blank or null

Columns that can be Conditionally Null

• provider_id: Can only be null if category is not "B"
  • test: test_challenger_row_rule__ISPs_need_provider_ids

Multi-File Column Rules

Intentionally noted but not checked by this project

• provider_id: is checked for existence and correct length but cannot check if there is a match to provider_id in the FCC's provider_id list.