4 Replies Latest reply on Aug 1, 2017 1:36 PM by Jeff Sikorski

    Truncate field in CSV for Spoon - Attribute value does not fall within the limits defined for this attribute. Character value exceeds max length

    Jeff Sikorski

      version:  BMC Atrium 8.1.02


      Kettle - Spoon - 4.1.0

       

      Hi All -


      I have a CSV file from another team.  I'm trying to import a few fields from the CSV into the CMDB.


      The error i'm seeing in Atrium Integrator is:
      Attribute value does not fall within the limits defined for this attribute. Character value exceeds max length


      Now I know the obvious reason:
      ~Field_in_CMDB =  255 chars
        ~CSV file has some records with 256+ chars

       

      I've looked over all the Spoon options about 6x and I don't see any easy way to truncate.

       

      What I WANT is:
      To configure the job in spoon to say "Truncate any field that's greater than 255".


      You can do this easily in SQL jobs by writing your SQL to truncate.  I don't see a similar option for CSV files.,

       

       

      Is there something obvious I'm missing?

       

      Thanks,
      Jeff