Graphics

 View Only
  • 1.  Excel Datalinq Character Limit

    Posted 09-28-2016 02:53
    I am experiencing an issue where a cell in Excel with lots of text will not datalinq properly with Xpression v6.2. It cuts the text off after a certain number of characters.
    Is there a way to fix this? And is it being caused by Xpression or Excel?

    Note: I am using an ADODB database with the Excel template.

    Thanks,
    Clancy


  • 2.  RE: Excel Datalinq Character Limit

    Posted 09-29-2016 15:25
    How many character are we talking about here?
    Does your XPression text object have a script or logic that limits the number of characters in it?
    If you just hit 'browse' in your Datalinq server on the ADODB data source do you also see the characters being cut off?
    #XPression


  • 3.  RE: Excel Datalinq Character Limit

    Posted 10-05-2016 18:35
    This is an excel limitation. If there is no data that exceeds 255 characters in the first 8 rows of the exported table it will assume all the following rows should be truncated to 255 (I know, it sounds silly). Try adding a field that is more than 255 characters long into the first 8 rows of the region you are exporting to Datalinq.

    FYI, this worked for me in a small test I ran here.
    #XPression