LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Bug found in Excel node (filename and path restrictions)

    Employee
    Posted 12-06-2011 07:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: erno

    I noted that the Excel node in LAE 4.5.2 has a bug when filename or directory path contains certain special characters.

    For instance ���.xlsx fails to import where as aaa.xlsx works OK. Same goes for C:\���\aaa.xlsx. LAE gives the following error message: Process exited before ENDIO message received.


  • 2.  RE: Bug found in Excel node (filename and path restrictions)

    Employee
    Posted 12-12-2011 16:12

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hi,

    I have raised a bug report about this (issue 3617).
    Until this issue is fixed, the following workaround will work in your case:

    Create a static data node, and copy the filename into the static data node.
    For example, the static data node would contain the following text in the StaticData parameter:
    FileName:string
C:\\���\\aaa.xlsx
    (be sure to use the extra '\' character, as '\' is an escape character within the static data node)

    Connect the output of the Static Data node to the input of the Excel File node.

    Then, within the Excel File node, rather than populating the "File" parameter, you can populate the "FilenameExpr" parameter, with the string

    FileName
    Tim.


  • 3.  RE: Bug found in Excel node (filename and path restrictions)

    Employee
    Posted 12-23-2011 01:11

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: erno

    Thanks Tim!

    Excel node has also two other issues with ���-characters that would be nice to get fixed:
    1) Excel node is unable to fetch data from worksheets named with ���-characters. In other words, if I have Excel file with sheet "���" the node fails, but sheet named "Aaa" works OK.
    2) Excel node fails when column titles include ���-characters

    Again, not a major problem as workarounds exists.

    Happy holidays,
    Erno


  • 4.  RE: Bug found in Excel node (filename and path restrictions)

    Employee
    Posted 12-23-2011 05:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hi,

    These issues had already been raised as bugs and will be fixed in the upcoming LAE 4.5.3 release.

    Unfortunately no-one else had noticed the original issue you raised with the filename containing extended Ascii characters, so the fix for that bug was not able to be rolled into the 4.5.3 release. However, this should make it into one of the next upcoming maintenance releases on the 4.5. branch.

    Tim.