Importing CSV

If you have a spreadsheet with your pole or node data, you can drag that file directly on the map to seed the poles with the data.

Setting Up The Spreadsheet

When preparing a spreadsheet or CSV file for import into Katapult Pro, Column A should have the header "latitude" (all lowercase) and Column B should have the header "longitude" (all lowercase). These location coordinates are essential for properly placing nodes on the map. 

All columns should have headers that match attributes in your Katapult Pro model. While this isn't a strict requirement, it's extremely helpful long term if importing CSV files will be your typical workflow. If any headers don't match attributes perfectly, the importer will prompt you to map the unknown headers to existing attributes. Keep in mind that you should use underscores in place of spaces in attribute names within the column headers. 

The attribute "node_type" should be used anytime you're importing data, but it's especially valuable when designing more than just poles on the map. The "pole_tag" attribute is a "complex" attribute, meaning it's made up of multiple data points. You can format your spreadsheet under the pole_tag column by using the format "Company::ID Number::TRUE". In this format, the company is the name of the utility company, the ID Number would be the text of the pole tag, and TRUE or FALSE denotes whether they own the pole or not. If the ownership field is left blank, Katapult Pro will assume false. Most default map styles include a red circle indicator for an unchecked "done" attribute. It's best practice to include a header for "done" in your spreadsheet and leave the cells in that column blank. 

Importing Data

To import your CSV file into Katapult Pro, drag the file onto the map and select "Upload Node Data." The importer will prompt you to map any unknown headers to existing attributes if needed. Once you've completed any necessary mapping, select "Add to Job" to import the poles onto your map. 

This import method is most common when you don't have connection data available in your CSV file. To connect the imported poles, you can use the Join Aerial tool to click through each pole and draw an aerial cable connection between them. Alternatively, in the Office Power Tools toolset, the Join All tool will automatically connect all poles with the aerial cable connection type.

Note that the Join All tool treats the design as fairly simple and does not handle intersections. There will be situations on the map where connections should be deleted and redrawn as needed to accurately reflect real world conditions.

To import connections, you'll need the connection information in a separate CSV file. The bare minimum for your file with connections is to have two attributes that link the connection to two separate nodes that already exist in Katapult Pro as the connection's end points. These attributes should be unique to the node; no other node should have the same value for that attribute.