VERIFIED SOLUTION i

Importing Inventory Data into Confirm

Product Feature: Confirm, PMS, UKPMS
 

General Notes

An Inventory Import can be carried out using one of three Import Types, which behave as described below:

  • Partial – This will check whether there is any overlap between Inventory Items in the import file and those in the database, and if so an error message will be displayed and it will not be possible to save the data.
  • Full – This will End Date all existing Inventory Items on the Sections to which new Inventory Items are being imported.
  • Full by Inventory Type – This will also End Date existing Inventory Items, however for each Section only existing Inventory of an Inventory Type being imported to that Section will be End Dated. For example if the import file only contains Footway Items for a particular Section, then existing Footway on that Section will be End Dated but all other Inventory will remain Live.
Note: If a Full or Full by Inventory Type import is carried out via an External Network Section (i.e. using Network Translation) with mappings to several Base Network Sections, then Inventory Items on all the mapped Sections will be End Dated, even if the mappings mean that new Items are only imported to some of them.

Section

If NETCODE identifies the Base Network (or is blank), then SECTLAB is used to identify a Section in the database live at the Survey Date. Tolerance checks are carried out between MEASLEN and the stored length of the identified Section.

If NETCODE identifies a Network other than the Base Network, then SECTLAB is used to identify an External Network Section in the database for that Network. Tolerance checks are carried out between MEASLEN and the stored length of the identified External Network Section.
 

FieldSizeTypeComment
SURVDTE-DateDefaults to today
NETCODE6 or 50CharacterThe base network is assumed if none is supplied
SECTNO8.0Numeric 
SECTLAB20CharacterMust identify a valid Section in the database on the specified Network
DIRECT1 or 7Character 
MEASLEN8.2Numeric 


Inventory Item

An Import Construction Type attribute may be specified in system settings.

If this attribute is present for an inventory item, it is used in conjunction with FEATURE to identify the feature type.

If no such attribute is present, or the combination does not match an existing feature type, then FEATURE is checked to see whether it itself is a feature type.

If an Inventory Item is being imported referenced to an External Network Section, then it will be mapped to any appropriate Base Network Sections live at the Survey Date with a link to this External Network Section. This may involve reversing or stretching/shrinking in addition to that which takes place to take into account the MEASLEN and DIRECT fields. It may result in an Item in the file being split to produce two (or possibly more) Items in the database.r.

If Module 4050 is turned on, and SNODE or ENODE columns are supplied, the associated chainage will be interpreted as an offset from the identified node rather than chainage from the beginning of the section, provided that node exists (and does not exist at multiple points) on the section. This functionality cannot be used if the import is doing a Network Translation, or is reversing or stretching/shrinking inventory data to match stored section length.

FieldSizeTypeComment
SECTLAB20CharacterNot required in HMDIF import, mandatory in Delimited import. Must identify a section in the section file
INVKEY16NumericNot required in HMDIF import, mandatory in Delimited import. Must be unique within section
OWNER4 or 30Character 
FEATURE4CharacterMandatory
SNODE CharacterOnly with Module 4050
SCHAIN8.2NumericMandatory
ENODE CharacterOnly with Module 4050
ECHAIN8.2NumericMandatory
CROSSXSP6 or 30CharacterMandatory
SEQNUM8Numeric 
WIDTH18.2Numeric 
WIDTH28.2Numeric 
MEASURE8.2NumericMay be overwritten with a calculated measurement if inventory type is flagged to do so
FWHIER8.2NumericBecomes site class. Defaults from section
LINKED SITE10CharacterSite Code of the existing Feature to which this Item is linked. If blank, assumed to be the same as that of the Section
LINKED10.2NumericPlot Number of the existing Feature to which this Item is linked

Inventory Attribute

The appropriate value column should be supplied depending on the data type of the Attribute.

An additional numeric value NUMVAL may be imported. The value is not saved in its own right, but is added to the comment text.

All Attributes that are mandatory for the item’s Feature Group must be specified.

FieldSizeTypeComment
SECTLAB20CharacterNot required in HMDIF import, mandatory in Delimited import. Must identify a section in the section file
INVKEY16NumericNot required in HMDIF import, mandatory in Delimited import. Must identify an item on the section in the inventory item file
ATTRIB4 or 30CharacterMandatory. Must be an existing attribute type
OPTION4 or 30CharacterMust be a valid value of the attribute type
NUMVAL NumericIncluded in comment text
NUMERIC VALUE Numeric 
DATE VALUE Date 
TEXT VALUE2000Character 
COMTEXT2000Character 
UPDATED:  September 24, 2018