Forum Discussion

rsacco's avatar
rsacco
New Contributor
3 years ago

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!

Data Sources
Workflow
  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    3 years ago

    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)

  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    3 years ago

    Hello,

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

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    11 months ago

    Hi rsacco ,

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

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