Import File Formats¶

Sites from CSV File¶

Network Sites or Subscriber Sites can be defined in a CSV (comma separated variable) file, created using Excel or a text editor. The first row contains titles. For example:

Name, Latitude, Longitude, Maximum Height, Description
Place1, 50.371N, 3.523W, 200, Desc of place 1
Place2, 50.384N, 3.525W, 100, Desc of place 2

PTP Links from CSV File¶

PTP Links can be defined in a CSV (comma separated variable) file, created using Excel or a text editor. The first row contains titles. For example:

Name,   Desc.,  Local      Local       Remote     Remote      Local   Remote
                Latitude,  Longitude,  Latitude,  Longitude,  Height, Height
A to B, Description, 39.75093N, 104.84035W, 39.74828N, 104.84861W, 10, 20

The columns that are required for the CSV import and the Paste PTP links command are different. See Importing PTP Links from a Spreadsheet for more information.

note

The PTP link import file only imports the coordinates and heights, which is different from the format in which PTP links are exported from LINKPlanner as the export contains all the detailed link parameters. An exported PTP link CSV file cannot be imported directly back into LINKPlanner. To import a PTP Link exported CSV, first remove all the detailed parameter columns until only the above columns are left in the CSV.

PMP Links from CSV File¶

PMP Links can be defined in a CSV (comma separated variable) file, created using Excel or a text editor. The first row contains titles. For example:

Hub Name,  Hub        Hub         AP       SM Name,  SM         SM
           Latitude,  Longitude,  Azimuth,           Latitude,  Longitude,
Golf Club, 39.75093N, 104.84035W, 90,      Billings, 39.74739N, 104.82459W,

AP           SM          AP Name,    AP Tilt, Description
Height(ft),  Height(ft),
66,          23,         Golf Club:1, -1,     Description

note

The PMP link import file combines a small subset of the information from the PMP Hub, Access Point and PMP Link files which are exported from LINKPlanner. An exported PMP link CSV file cannot be imported directly back into LINKPlanner.

Path from CSV File¶

Paths can be defined in a CSV (comma separated variable) file, created using Excel or a text editor. The first row contains the headings. To ensure that the path is imported correctly the units should be defined in the header. Range can take the units (km) or (mi.) and the clutter type (if using) and height values can be in (m) or (ft). If the units are missing or not recognized then the preferred units will be used. The range value increments from zero at the local (left hand) end of the path to the maximum path length. For an example, see Path Profile Units.

Path from Pathloss (*.txt)¶

Path profiles can be imported from Pathloss text reports, using the Terrain profile listing which will give the name and co-ordinates of each site and the path profile including obstructions between the sites.

In Pathloss 5.1 the text report is built by clicking Operations, Reports. In the Composite reports window click Terrain profile listing, then click Print selected links. Save the resulting output as Text Format (*.TXT). Multiple sites can be included in the same file.

LINKPlanner can only support path profiles from Pathloss with a Datum of World Geodetic System 1984 (WGS 1984) or North American 1983.

Navigation