1. Administrator's Guide
  2. Managing the Budgeting Process
  3. Managing Task Lists
  4. Importing and Exporting Task Lists

Importing and Exporting Task Lists

Administrators can use TaskListDefUtil.cmd (Windows) or TaskListDefUtil.sh (UNIX) to move task list definitions between Oracle Hyperion Planning applications. You can export or import task list definitions to or from an XML file.

TaskListDefUtil uses a command line interface and is installed in the planning1 directory. For the full path to planning1, see About EPM Oracle Instance.

To launch the TaskListDefUtil utility:

  1. Enter the command from the planning1 directory, using this syntax:

    TaskListDefUtil [-f:passwordFile] import|exportFILE_NAME|TASK_LIST_NAME|-all SERVER_NAME USER_NAME APPLICATION

    Parameter Purpose Required?

    [-f:passwordFile]

    If an encrypted password file is set up, you can use this option as the first parameter in the command line to run the utility with the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

    No

    import|export

    Import or export the task list definition.

    Yes

    FILE_NAME|TASK_LIST_NAME|-all

    When used with import, specify the XML file containing the task list definition. When used with export, specify the task list to export to XML. Use -all with import or export to import or export all XML files or task list definitions in the current application.

    Yes (-all is optional)

    SERVER_NAME

    Server name on which the Planning application resides.

    Yes

    USER_NAME

    Administrator's name.

    Yes

    APPLICATION

    When used with export, the name of the Planning application containing the task list definitions to export. When used with import, the name of the Planning application to which to import the task list definition.

    Yes
  2. If prompted, enter your password.

When you export task list definitions, the utility creates an XML file in the current directory and logs errors in TaskListDefUtil.log in the EPM_ORACLE_INSTANCE/diagnostics/logs/planning directory. You can copy the utility to any directory and launch it from there to save files to another directory.

Examples:

  • To import one file:

    TaskListDefUtil.cmd import c:\EPM_ORACLE_INSTANCE\Planning\planning1\TaskList1.xml localhost admin APP1

  • To export one file:

    TaskListDefUtil.cmd export TaskList1 localhost admin APP1

  • To export all task list definitions:

    TaskListDefUtil.cmd export -all localhost admin APP1

  • To import all task list definitions:

    TaskListDefUtil.cmd import -all localhost admin APP1