Have GRLoader ignore the 'EMPTY' keyword when loading into TWA

Idea created by SHAWN WALSH Employee on Apr 10, 2014
    Not planned
    Score0

    GRLoader changes the EMPTY keyword when loading into TWA.

    I cannot think of any use case as to why. It should only change the EMPTY keyword to a null string when running grloader to updates CIs from TWA.

    Current workaround:

    1- CSV or other file type with:
      "name","family","class","system_name","serial_number","mac_address","tgt_id"
      "WNC6602A","Hardware.Server","server","WNC6602A","USE11287CE","blank",
      "WNC6602A"
     
      2- LTTWA.cfg contents:
      grloader.server=http://walsh04-vm80592:8080
      grloader.spinner=no
      grloader.csv.escape=
      grloader.inputfile=Book1.csv
     
      3- Sample GRLoader command to load into TWA:
      grloader -cfg LTTWA.cfg -lttwa -i Book1.xml -u ServiceDesk -p <password>
     
      4- LFTWA.cfg contents:
     
      grloader.server=http://walsh04-vm80592:8080
      grloader.spinner=no
      grloader.csv.escape=
      grloader.emptyvalue=blank
     
      5- Sample GRloader command to load from TWA:
      grloader -cfg LFTWA.cfg -lftwa -u ServiceDesk -p <password> -a

     

    This will clear the value in the mac_address field of the CI.

     

    ------------------

     

    It would be nice to just have GRLOADER be able to create rows in TWA with the EMPTY keyword in a field.