How to Format Pole Data for Upload
The following instructions explain how to format your data file for:
• Adding & Updating Poles
• Deleting Poles
• Adding & Updating Attachments
• Deleting Attachments
Choose Your Work Task
In Notify™, you can choose to perform one of the 4 tasks below. Depending upon which type of work you wish to do, your file should be formatted specifically for that task. To begin, choose which task you wish to complete. This will determine how your file should be formatted.
All files must be pipe-delimited text files (.txt).
Formatting Your Data File
Format your pipe-delimited text file with one of the following 4 layouts.
The first character denotes the task you wish to complete.
All files must be pipe-delimited text files (.txt).
1. Add/Update Poles = P | View Sample File
P|LegacyID|Latitude|Longitude|Owner|SerialNo|PowerPoleNo|TelcoPoleNo|Location|Address|PoleHeight|PoleClass|PoleMaterial|Notes
2. Delete Poles = DP | View Sample File
DP|LegacyID
3. Add/Update Attachments = A | View Sample File
A|LegacyID|Attacher|NoOfAttachments|AttachmentID|AttachmentType|AttachmentHeight
4. Delete Attachments = DA | View Sample File
DA|LegacyID|Attacher
Top of Page
Setting Up Data Fields
The chart below explains each field. Note which fields are required and which are optional.
*Fields that aren't populated should be denoted as no space (i.e. ||)
Fields for Adding, Updating or Deleting Poles |
||
|---|---|---|
Pole (P) |
Data Field |
Description |
LegacyID varchar (100) |
Required |
Unique identifier for this pole- This must be your company's unique pole identifier. NOT the pole number. |
Latitude decimal (18,10) |
Required |
Latitude |
Longitude decimal (18,10) |
Required |
Longitude |
Owner varchar (100) |
Required |
Company Code or Name the uploading company uses to reference the pole owner. NOTE FOR JOINTLY-OWNED POLES: If the pole is jointly-owned, owner must be formatted as 'company1/company2(custodian)'. The custodian is optional and may either be company1 or company2. |
SerialNo varchar (50) |
Optional |
If the pole is serialized, input that number here. |
PowerPoleNo varchar (50) |
Optional |
The Pole Number the power company uses to reference a pole. |
TelcoPoleNo varchar (50) |
Optional |
The Pole Number the telephone company uses to reference a pole. |
Location varchar (50) |
Optional |
The Geographic Area where the pole is located. |
Address varchar (100) |
Optional |
Address where the pole resides. |
PoleHeight varchar (50) |
Optional |
Height of Pole |
PoleClass varchar (50) |
Optional |
Class of Pole |
PoleMaterial varchar (50) |
Optional |
Material of Pole (i.e. Concrete, Wood brown, Metal/Steel, etc.) |
Notes varchar (max) |
Optional |
Additional Notes/Comments |
Adding, Updating or Deleting Attachments |
||
Attachment (A) |
Data Field |
Description
|
LegacyID varchar (100) |
Required |
Unique identifier for this pole- This must be your company's unique pole identifier. NOT the pole number. |
Attacher varchar (100) |
Required |
Company Code or Name uploading company uses to reference the attaching company. |
NoOfAttachments int |
Optional |
Number of Attachments on pole. Defaults to 1 if not populated. |
AttachmentID varchar (100) |
Required |
Unique identifier for this attachment |
AttachmentType varchar (50) |
Optional |
Type of Attachment (Drop, Anchor, Antenna, etc.) |
AttachmentHeight decimal (2,2) |
Optional |
Height of Attachment |
If your data is correct, click SUBMIT to upload your file to the database.
If there are errors, click CANCEL to go back and make changes.
Top of Page
Mapping Company Names
After you have uploaded your file, there may be companies that are not mapped to an existing Notify™ company. If you see the highlighted link below, click on it to map your companies at that time.
Map companies at any time by choosing Map Pole Companies on the Admin page within Notify™.
Next, select the company in Notify™ that should be mapped to your imported company
from the drop-down menu. If a company is not listed, click ‘Company Not Listed.’
Add the company name by which the company should be known in Notify™
along with any additional information and select CREATE.
You can then map your imported company to the new company you created in Notify™.
Once you have mapped all of your imported companies, save your changes.
Viewing Your Data
Once uploaded, your data must be reconciled by Alden BEFORE it is visible on the map.
If there are no errors in your file and you have properly mapped all your company names
if necessary, your data will be visible after reconciliation.
Ready to Upload Pole Data?
Visit www.notifyweb.com to sign up and start managing your poles.
Want More Information about Registration?
Send an email to info@aldensys.com to request a registration packet.
|
Home About Alden Contact Us |
Uploading Your Pole Data FAQs Features |
Alden Corporate Home Terms & Conditions |
|---|
