B

BidINFO Enrichment Admin

Bulk CSV Tool

Contractor Data Hygiene & Lookup Pipeline

Back to Dashboard
Contractors in Missing Queue Loading... Contractors missing either Website, Phone, or City
Total Enriched Contractors Loading... Protected user & API records in contractor_enrichment
Fill-In-The-Blanks Policy COALESCE Active Bulk uploads never overwrite manual contractor values
Association Personnel 0 Key personnel attached via contractor_contacts

Bulk Contractor CSV Enrichment

Upload CSV files to populate missing Websites, Phone numbers, and Locations in batch.

Fill-In-The-Blanks Invariant: Existing manual edits are strictly protected with COALESCE. Bulk uploads will only fill empty fields and will never overwrite verified records.

Click to browse or drop CSV file here

Supported columns: contractor_id, website, phone, location (or city, state)

Max file size: 15MB • UTF-8 CSV

Import Summary Results

0
Total Rows
0
Newly Inserted
0
Filled Blanks
0
Skipped / Empty

Upload Association Contacts

Import key personnel (Executives, Estimators, Project Managers) from external association directories and attach them to standardized Google profiles.

Directory Scope Policy: Personnel are automatically linked via contractor_aliases. Only companies matching active contractors in our DOT bid database are imported; unmapped firms are skipped to avoid polluting records.

Click to browse or drop Association Contacts CSV here

Required headers: Company, Contact, Title, Email, Contact Phone, Source

Max file size: 15MB • Deduplication enforced on (canonical_id, full_name)

Association Contacts Import Results

Processed

0
Total Rows
0
Matched Contacts
0
Newly Inserted
0
Updated Existing
0
Skipped (Not in DOT)

Missing Data Queue (API & Lookup Pipeline)

Real-time candidate queue for automated API lookups or targeted scraping.

Contractor ID Company Name Missing Fields Current Values Action
Loading queue items...
Showing 0 of 0