Asset Manager - Asset Domains - Exor 4.5.0.0

Is it possible to bulk upload an asset domain (NM0301)  via csv loaders (HIG2020) ?
 
I have a list of around 300 items I need to load against a domain rather than entering each one (around 150 mins)  is there a bulk load option?

Mark

Parents
  • Hi Mark,

    Yes, it is possible to do that. If you want to load domain values against the existing domain you need to set up a loader against NM_INV_ATTRI_LOOKUP_ALL table in HIG2020 form.

    If you first need to create new domains you can create them manually in NM0301 form or load them via CSV loader as well. They need to be loaded into NM_INV_TYPE_ATTRIBS_ALL table.

    Please let me know if you need more details on the process.

    Answer Verified By: Sarah Willis-Culpitt 

Reply
  • Hi Mark,

    Yes, it is possible to do that. If you want to load domain values against the existing domain you need to set up a loader against NM_INV_ATTRI_LOOKUP_ALL table in HIG2020 form.

    If you first need to create new domains you can create them manually in NM0301 form or load them via CSV loader as well. They need to be loaded into NM_INV_TYPE_ATTRIBS_ALL table.

    Please let me know if you need more details on the process.

    Answer Verified By: Sarah Willis-Culpitt 

Children
  • Hi Kristijonas,

    I have created an oracle business area and extracted table data of the two tables you mentioned into excel, to look at.

    Having looked at NM_INV_TYPE_ATTRIBS_ALL, this appears to hold the metamodel data.
    Whereas NM_INV_ATTRI_LOOKUP_ALL appears to hold all of the Domain data.

    Which appears to be the exact opposite of what you are stating with NM_INV_ATTRI_LOOKUP_ALL & NM_INV_TYPE_ATTRIBS_ALL.

    In NM_INV_ATTRI_LOOKUP_ALL, I obviously have to populate Domain, sequence, value, meaning, created by, start date.

    Do I have to populate all fields?
    I have ignored all fields with "NULL" in.

    eg.

    start date: Day
    start date: Month
    start date: Quarter
    start date: Year
    date modified: Day
    date modified: Month
    date modified: Quarter
    date modified: Year
    etc.....

    In HIG2020 on the file destinations tab I also cant seem to fine the NM_INV_ATTRI_LOOKUP_ALL as a destination table. hence my origianl question.

    Regards

    Mark

    Mark Davies FIHE, MCIHT, MIAM.
    Principal Engineer, Infrastructure.
    Asset Manager
    MGWSP,

    Northamptonshire Highways
    Brixworth Depot, Harborough Road, Northamptonshire, NN6 9BX
    Tel : 01604 883411
    Mob +44(0)7500 122947

  • I want to correct the mistake I made in the previous response – if you need to load a new domain you should do the load against NM_INV_DOMAINS_ALL table. My apologies.

     

    However I can confirm that when you need to load the domain values you do that against NM_INV_ATTRI_LOOKUP_ALL table. In order to do that you need to select this table as a ‘Destination Table’ it in HIG2020 ‘File Destinations’ tab (should be visible in the List of Values – checked on few systems).

     

    The file you are going to load needs to have the same number of columns that appears in the NM_INV_ATTRI_LOOKUP_ALL table. Non-mandatory columns (fields) can be left blank. See below an example record from my test CSV file (non-mandatory fields are left blank):

    KN_TEST_3,23,,SE (side entry),11-Jan-1998,,18,,12-Jan-2005,12-Jan-2005,HIGHWAYS,HIGHWAYS

     

    Then you need to describe file columns in HIG2020 ‘File Columns’ tab (should be enough to describe only mandatory fields) and indicate them as source columns for corresponding NM_INV_ATTRI_LOOKUP_ALL table columns in ‘File Destinations’ tab. Click ‘Create Holding Table’ and you are ready to load.

  • Hi Krisijonas,

    I have just tried this today and it took 3.04 seconds to load 272 domain records, which might have took at least a few hours to build.
    This has opened up a wide range of possibilities.

    Thank you Very Very much an excellent result.

    Regards

    Mark

    Mark Davies FIHE, MCIHT, MIAM.
    Principal Engineer, Infrastructure.
    Asset Manager
    MGWSP,

    Northamptonshire Highways
    Brixworth Depot, Harborough Road, Northamptonshire, NN6 9BX
    Tel : 01604 883411
    Mob +44(0)7500 122947