The Shapefile feature relies on an equivalent and corresponding entry in the ComboBox Data module.
Loading data into IMS from GIS systems requires some initial analysis and ComboBox Data preparation work. Once these are set up, they can be reused rapidly whenever new mapping data becomes available and is required for importing into IMS.
Import Shapefile Setup (Mappings)
The mapping relationship between the Shapefile and an IMS entity is achieved through the use of the ComboBoxData feature.
For more detailed information on how to setup a ComboBoxData instance please refer to the section called: Combobox Data in the IMS Admin User Guide.
The following information is important to note and follow when creating a new ComboBoxData selection instance:
ComboBox Data component description:
1 |
The name must start with SHAPEIMPORT_MAPPING followed by underscore symbol |
||||||||||||||
2 |
The next portion must contain the IMS Entity Type Name - Site, Circuit, Node, etc.) followed by underscore symbol |
||||||||||||||
3 |
User defined portion of the selection name that helps identify this ComboBoxData selection |
||||||||||||||
4 |
the individual IMS Property Name (table field) - followed by the equal symbol (=) This IMS Property Name becomes the header used in the Bulkloader. It can also be an extrafield of the IMS Entity |
||||||||||||||
5 |
Attributes that can be used for the IMS Property Name are:
|
||||||||||||||
6 |
Example where any incoming NULL value for an OrderId will be replaced with a user defined OrderId |
ComboBoxData Selection Examples
Point Data Example
LATITUDE=POINTY
LONGITUDE=POINTX
GETADDRESSFROMGOOGLEAPI=TRUE
ORDERID=#ORDERID#
INVENTORYSTATUSID='PL'
CITYID='UNKNOWN'
STREET='-'
HOUSENUMBER='-'
ZIPCODE='-'
NAME={ST_CODE}
CUSTOMERID='UNKN'
SITETYPEID={ST_PROPTYP}
LineString Data Example
SPEEDID='DUCT{CAPACITY}'
DUCT_ID={DUCT_ID}
DUCT_GROUP={DUCT_GROUP}
PRODUCTID='DUCT HDPE 24X4MM ORANGE 50MM'
CUSTOMERID='FIBER'
ORDERID=#ORDERID#
VENDORID='ID:2049'
SERVICEPARTS='FIBER'
SITEAID='UNKN'
SITEBID='UNKN'
COORDINATES=COORDINATES
Polygon Data Example
NAME=BLDG_ID
POLYGONTYPEID='COMSOF'
COORDINATES=COORDINATES
Example Data Mapping
Locate the GIS file that contains the new data to be mapped into IMS.
This table shows the property names from the two different systems:
GIS Property Name |
IMS Property Name |
Cab_Name |
Name |
Latitude |
Latitude |
Longitude |
Longitude |
CabinetNam |
SiteName |
The next step is to create a new ComboBox Data entry that represents this import routine. The ComboBox Data Name is made up of three parts as described above in the ComboBox Data component description section.
In this case it is the IMS Site object that is the focus for the import routine.
In the Selection area, build out the Property mapping details [GIS to IMS], one property at a time - one per entry under the same ComboBox Data Name.
Where there is no direct mapping to the GIS data then fix a value for any required property in IMS:
Below is a screen shot example of a completed mapping exercise:
For comparison purposes only:
Although the creation of a Bulkloader instance (file) is not required when using the Import Shapefile routine from the Network Map, and for those who are familiar with loading from Bulkloaders, the screenshot below shows the equivalent mapping of Properties between the GIS and Bulkloader files.
