Hitachi Vantara Pentaho Community Forums
Results 1 to 14 of 14

Thread: Error Message: Unable to recognize OLE stream

  1. #1
    Join Date
    Mar 2008
    Posts
    12

    Unhappy Error Message: Unable to recognize OLE stream

    If I try to configure an Excel input and try to get the fields, I get an error-message: "Unable to recognize OLE stream"
    With another Excel input it works without problems... the Excel file with the error message, I have created with an MySQL Export...
    Have anyone any idea?

    Thanks so far...

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Excel 2007? We don't support it yet.

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Maybe you created a CSV file and not an excel file?

    - Open up the file that PDI can't open in Excel itself. IF you get a dialog to ask for some settings to "import" you don't have an excel file, you have a CSV file.
    - Open up the Excel file in notepad (or vi if on UNIX). If the file is still readable you have a CSV file, not an excel file.

    Regards,
    Sven

  4. #4
    Join Date
    Mar 2008
    Posts
    12

    Unhappy

    Thanks for the fast replyes, but didn't help :-(
    It is definitly Excel 2000 and also definitly no CSV, but a real Excel file...

    So, any other ideas?

  5. #5
    Join Date
    May 2006
    Posts
    4,882

    Default

    Make a small sample excel file available so that we can play with it.

    Regards,
    Sven

  6. #6
    Join Date
    Mar 2008
    Posts
    12

    Default Not your fault

    I just find out, that its obviously not your fault.
    Probably a problem of the export-function of phpMyAdmin. If I open the Excel-File and save it again in a Excel 200 or older format I had no Problems... And with Excel-files, which are not build by phpMyAdmin, I also have no problems!

    So thanks so far for your best effort!

  7. #7
    Join Date
    Feb 2011
    Posts
    840

    Default

    6 years later and still no support for Excel newer than 2000?
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  8. #8
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    What are you talking about Joao?
    xlsx is supported... You just have to configure PDI carefully.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  9. #9
    Join Date
    Feb 2011
    Posts
    840

    Default

    XLSX yes, but not XLS in newest Excel versions. JXL supports only up to 2000.

    What I'm saying is that I just tried to deal with a XLS file through ftp and I get the same error - Unable to recognize OLE stream
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  10. #10
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    So it looks like a very narrow edge case - According to Excel 2013, xls is Excel 97 - 2003 ... So the only one that isn't showing as supported is Excel 2003.

    I've never had an issue with opening Excel 2003 xls files.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  11. #11
    Join Date
    Feb 2011
    Posts
    840

    Default

    no idea what could be the deal here. Excel 2013 opens without any error or warning messages.
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  12. #12
    Join Date
    Feb 2011
    Posts
    840

    Default

    holy crap. Thanks gutlez for the tip of using cygwin's file command.
    Just found out it's a dBase 3 data file. Using XBase Input I was able to read the file but...

    BUT it seems I can't use it directly on a FTP file. I'll have to download it first and them use it... thanks gutlez!
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  13. #13

    Default

    still not supported yet? The manual tell me to transform it to 97-2000-XP but the MS Excel input has 97-03 as an option

  14. #14
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by ov3rt1me View Post
    still not supported yet? The manual tell me to transform it to 97-2000-XP but the MS Excel input has 97-03 as an option
    You clearly didn't read the thread.
    All the standard Excel versions for the last decade or so are supported.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.