Single File Import

Upload one file at a time to build your network data incrementally.

Data Import Guidelines
Files must be uploaded in the following order to maintain proper relationships:
  1. Device Locations (first)
  2. Strands (connects devices to each other)
  3. House Counts (links to devices)
  4. Addresses (links to devices)

Current Database Status:

Devices

544

Strands

358

House Counts

367

Addresses

175

Select File Type to Upload

Expected columns for Device Locations CSV:

Project, Feature Name, Mslink, Primary ID 1, Primary ID 2, Longitude, Latitude, etc.

Expected columns for Strands CSV:

MSLINK, LINK1, LINK2, LENGTH, LOCATION (column K, used to differentiate aerial "A" vs underground "UG" strands), etc.

Expected columns for House Counts CSV:

MSLINK, FACILITY, ACT_COUNT, POT_COUNT, TYPE, etc.

Expected columns for Addresses CSV:

MSLINK, FACILITYLINK, STREETNAME, STREETNUM, CITY, STATE, ZIPCODE, LATCOORD, LONCOORD, etc.

No file chosen
Return to Dashboard Clear All Data
Data Processing

During each file upload, the system will:

  1. Validate the CSV file format
  2. Process each row and create proper database relationships
  3. Skip duplicate entries (based on MSLink values)
  4. Report the number of successful imports and any errors

This step-by-step approach ensures data is loaded incrementally and relationships are maintained.

Switch to Batch Import