Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: OpenOffice calc ods file format support

  1. #1
    Join Date
    Mar 2007
    Posts
    216

    Question OpenOffice calc ods file format support

    Hi,

    I have data to create for a datawarehouse project because they are in a format that can not be parsed.

    I have searched for the best data format to use and finally choose an open format : OpenOffice Calc ods

    In Pentaho Data Integration I can't import ods data.
    Is there a way to import ods files in PDI ?

    a+, =)
    -=Clément=-

    Windows XP Pro SP2
    Pentaho Data Integration - Spoon version 2.5.1

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

    Default

    Nope, not yet directly.

    Regards,
    Sven

  3. #3
    jdixon Guest

    Default

    In theory you can do this. The ODS file is actually a zip file that contains various other files. In the zip file you will find a content.xml that has the data in it. You could use the XML input step to read data from this file.

    James

  4. #4

    Default

    We have a similar problem - but as of now we are using open office to save it as xls file and use the excel import. Not as good as direct import but works.

    Any idea on when ods support will be included?

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

    Default

    Nothing planned yet (that I'm aware of), so not short term probably... raise a tracker at http://jira.pentaho.org/browse/PDI

    Regards,
    Sven

  6. #6
    Join Date
    Mar 2007
    Posts
    216

    Default JIRA tracker : Calc ods support

    Hi,

    Quote Originally Posted by sboden View Post
    Nothing planned yet (that I'm aware of), so not short term probably... raise a tracker at http://jira.pentaho.org/browse/PDI

    Regards,
    Sven
    Done.
    http://jira.pentaho.org/browse/PDI-212

    a+, =)
    -=Clement=-

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.