Search Icon

Create a Line Design from CSV File

 This article outlines some of the basic concepts behind how Tension Types and Sag are accounted for in O-Calc® Pro. The full primer on this topic is linked here OCP Tension Sag Primer.

This document provides users with the instructions for creating a line design from a CSV file. An expected format is used to record the data prior to importing the .csv file into Line Design. Follow the steps below to add a line of poles in O-Calc Pro Line Design from a .csv file.

Show Expected Format

Begin by opening any pole file (.pplx) you want to use as a template for the poles in the line design, add it to the Inventory.

  1. From Line Design select File > New Line Design > Import > Show Expected Format.

Picture4-Mar-24-2025-05-38-41-7604-PM

2. The Expected Format information box appears. Click OK to close.

Picture2-Mar-24-2025-05-38-41-8189-PM

Sample CSV File

  1. Using the expected format information, prepare your file in Excel and Save it as a CSV (Comma delimited) (*.csv) file. Here’s an example:

Picture3-Mar-24-2025-05-38-42-2758-PM

Create Line from Data

  1. From Line Design select File > New Line Design > Import > Create Line From Data.

Picture4-Mar-24-2025-05-38-41-7604-PM

  1. Select your saved CSV file, click Open. See the O-Calc Pro Working progress window.
  2. Click Yes or No to Save the .pplx file that is currently open in the Inventory.
  3. In the Create Line Design window enter a File name, click Save. O-Calc Pro is now working to create your line of poles from the CSV file.

Sample Line Design from CSV Date file

Picture5-Mar-24-2025-05-38-42-2415-PM

Note: Inspect that the line design outcome includes the pole information as you expected per your input.

 

Contact your local Osmose professional.