Spoon CMDB Data Load Issue: single numerical string values getting loaded as decimal

Version 4
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium CMDB Suite


    COMPONENT:

    BMC Atrium Core


    APPLIES TO:

    Pentaho Spoon



    QUESTION:


    We are experiencing an issue with the field data we are loading from the attached spreadsheet into the CMDB via the Data Management Tool (DMT) which uses an Atrium Spoon job (see attached zip). The BMC.CORE:BMC_Equipment form has two custom char fields where if we run the job to load single numeric values on each, those values get converted into decimal. However, if each has multiple values separated by comma, then they get loaded as they are (e.g., “6” becomes “6.0”, but “4,5,6” stays the same).

    We tried to fix the issue by changing the format of the columns from text to General, and even used numbers without the decimal place, but it still produces the same decimal results in the fields.

     


    ANSWER:


    This part of the AI is actually Pentaho code and there is a Pentaho community post that pertains to Excel input adding decimal place to numeric field
    https://forums.pentaho.com/threads/135163-Excel-input-adding-decimal-place-to-numeric-field/

    Try using # in format. That should address the issue
     


    Article Number:

    000156234


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles