Results 1 to 4 of 4

Thread: Bug found in Excel node (filename and path restrictions)

  1. #1
    Contributor
    Join Date
    Aug 2011
    Location
    Helsinki, Finland
    Posts
    16

    Default Bug found in Excel node (filename and path restrictions)

    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. #2
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    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:
    Code:
    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

    Code:
    FileName
    Tim.

  3. #3
    Contributor
    Join Date
    Aug 2011
    Location
    Helsinki, Finland
    Posts
    16

    Default

    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
    Last edited by erno; 12-23-2011 at 08:19 AM.

  4. #4
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    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.

Similar Threads

  1. Excel 2007 Node
    By jhoitt in forum Data Acquisition
    Replies: 13
    Last Post: 11-19-2012, 02:48 PM
  2. Replies: 4
    Last Post: 03-22-2010, 06:06 PM
  3. Directory Node FileName Output
    By phourigan_MDS in forum Data Acquisition
    Replies: 2
    Last Post: 06-23-2009, 05:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •