Mapping Asset record <OPE>

n.a.

Fixed mappings

soortonderhoud = ‘SAO’

prioriteit = 5

elementstatus = 1

enable_automatic_myp = FALSE

enable_automatic_myp so there are no NEW MYP Task generated when adding an Asset to HUMBLE

ele_tekst

Direct mapping

name

ele_hvh

Direct mapping

numberof

ele_fabrikaat

Direct mapping

fabricate

ele_type

Direct mapping

model

ele_levensduur

Direct mapping

lifecycle

ele_serienummer

Direct mapping

serialno

ele_tag

Direct mapping

customer_tag

ele_qrcode

Direct mapping

barcode

ele_pk

Direct mapping

custom_1

ele_nlsfb

Functional mapping

nlsfb_id

Removes all '.' and spaces from field ele_nlsfb

Search for existence in HUMBLE, if not it will use a default NL-SfB code 0

Note: it is possible to add mappings to the importer. This is not applicable from the front-end application

ele_eenheid

Functional mapping

unit2_id

Search for existence in HUMBLE, if not the unit will be empty

Note: it is possible to add mappings to the importer. This is not applicable from the front-end application

ele_cvo

Functional mapping

condition

If set the value is used from ele_cvo

When ele_cvo = 0 it will convert the condition to 1

ele_bouwjaar

Functional mapping

installation_date

Maps to ‘01-01-’ + ele_bouwjaar

lastinspection_date

Functional mapping

lastinspection_date

Gets the lastinspection_date from the Location (Building)

Functional mapping

status_id

Get the ID for the listitem value ('0') of the sysitem_list = 'element status'

ele_capaciteit

gConditie

Functional mapping

remark

Concatenates a few fields when applicable ele_capaciteit and gConditie are used ti create a combined remark text

ele_bouwjaar

Functional mapping

yearbuild

Creates the integer value for the year build. So when empty in OPrognose it will be 1970

ele_locatie

Functional mapping

custom_4

Puts the original location ele_locatie into custom_4

ele_foto

Image mapping

Added as separate images within HUMBLE. Images are related to the Asset