Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: export transformations , jobs to XML file

  1. #1
    Join Date
    Oct 2012
    Posts
    18

    Default export transformations , jobs to XML file

    Hi

    We are using Pentaho 4.4.2 on Linux. We have a requirement to export all the transformations , Jobs to individual XML files. We don't need the complete repository backup which is one single XML file. We have to get all jobs & transformations and export them as individual XML files.
    Please let me know if there is any utility available or custom code written for this use case.

  2. #2
    Join Date
    May 2012
    Posts
    110

    Default

    Use the EXPORT Repository in TOOLS and delete what you don't want.
    Regards Vince

  3. #3
    Join Date
    Oct 2012
    Posts
    18

    Default

    We have 1500+ transformations and 500+ jobs. we want to automate this procedure. Doing it manually is cumbersome

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You want to convert a database repository into a filesystem repository?

    Here's for starters.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Oct 2012
    Posts
    18

    Default

    We have our filesystem repository. Will this attached example split the entire repository.xml taken from filesystem repository to individual transformations / Jobs XML files ?

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I suggest you don't download the attachment.
    Don't even think about trying it out.
    Bad things could happen.
    Be warned.

    (The ktr and kjb files in your repository already are XML files!)
    Last edited by marabu; 11-22-2014 at 01:36 PM.
    So long, and thanks for all the fish.

  7. #7
    Join Date
    Oct 2012
    Posts
    18

    Default

    Is there any way to generate individual transformation, Jobs XML files for the whole repository - We don't want to do it manually

  8. #8

    Default

    you can export all job and trans but you can use Import /limitdir separated which dir you want import!

  9. #9
    Join Date
    May 2012
    Posts
    110

    Default

    Marabu, I get this error:
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Unexpected error
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error opening new file : org.pentaho.di.core.exception.KettleFileException:
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.apache.commons.vfs.FileSystemException: Could not create file "file:///C:/XPATH.ktr".
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Could not create file "file:///C:/XPATH.ktr".
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Could not create file "file:///C:/XPATH.ktr".
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) :
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.openNewFile(TextFileOutput.java:691)
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.setDataWriterForFilename(TextFileOutput.java:203)
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.processRow(TextFileOutput.java:179)
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2014/11/24 11:35:17 - Text file output.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2014/11/24 11:35:17 - Separate-Repository-Objects - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Errors detected!
    2014/11/24 11:35:17 - Separate-Repository-Objects - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Errors detected!
    Regards Vince

  10. #10
    Join Date
    May 2012
    Posts
    110

    Default

    zhaizhisheng,

    I this using the IMPORT Repository in TOOLS?
    Regards Vince

Tags for this Thread

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.