Skip to main content
rsacco
Member
Sep 14, 2022 6:28 PM UTC

Special Character/ number of characters impeding upload of subledger for a single item in a data set

We have come across an issue where a subledger has been loaded but is not picking up a singular item/line in the subledger. The item contains a number of commas and special characters in one of the text attribute columns, as do other items in the subledger, these other items load no problem. For additional context the item contains over 100 characters in this text attribute column, as do other items in the subledger, and although a character limit had been placed in the data source via complex expression all other items make it in except this item. Any thoughts would be great, Thanks!

3 replies

NidhiMangtani
Veteran
Sep 14, 2022 7:09 PM UTC

Hello,

Edit your complex expression to stop that special character from loading or replace before loading.

    TonyToniTone
    Sep 15, 2022 1:57 PM UTC

    A couple of things:

    1.  Have you reviewed the Import Processing Log to see what Log Code was assigned to the line item not being picked up?  

    2.  As Nidhi mentioned, remove special characters.  There is a snippet for this.  The StringHelper has other functions that may be useful in your case outside of this below function.  Give them a look.  

    'Removes characters not valid for an XF name property
    Return args.Value = StringHelper.RemoveInvalidNameCharacters(args.Value, False)

      RobbSalzmann
      Employee - Advisor
      RobbSalzmannEmployee - Advisor
      Employee - Advisor
      Jan 8, 2024 4:00 PM UTC

      Hi rsacco ,

      The following special characters are considered invalid for names and descriptions:

      /,
      |,
      !,
      @,
      #,
      ,,
      ;,
      ^,
      *,
      +,
      -,
      =,
      \\,
      ?,
      <,
      >,
      ",
      [,
      ],
      {,
      },
      \r,
      \n,
      \t

        Terms & ConditionsAccessibility statement