Posted by: paolyn lazo on: December 12, 2008
Now i realize that you can import and export data forms in planning…
You can use the FormDefUtil.cmd to export and import dataforms.
The default path for version 11.1.1 is on C:\Hyperion\products\Planning\bin
NOte: you should be provisioned as admin to be able to do this
Step 1: open the command prompt
Click start, Run, Type cmd
Step 2: Locate the path of FormDefUtil.cmd in our case it is located in our default path which is C:\Hyperion\products\Planning\bin
type cd C:\Hyperion\products\Planning\bin press enter
Step 3: Export the dataform from the application (This will export all the dataforms)
The correct syntax for exporting the dataform is:
Usage: FormDefUtil [-f:]
In this case I type:
FormDefUtil.cmd export -all localhost admin VSHI
Step 4: You will ask for the password
In my case my i type password
Step 5: Wait for the util to process the command. If you have done successfully.
It will look like below:
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
C:\Hyperion\common\config\9.5.0.0\product\planning\9.5.0.0\planning_1.xml
displayName = Planning
componentTypes =
priority = 50
version = 9.5.0.0
build = 1
location = C:\Hyperion\products\Planning
taskSequence =
task =
using Java property for Hyperion Home C:\Hyperion
Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.5.0.0
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Entering A
udit Client http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Initializi
ng Manager for the serverhttp://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.manager.AuditContext – Creating N
ew Audit Client Instance …. http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Audit Clie
nt has been created for the server http://paolynl.misnet.com.ph:28080/interop/Au
dit
Form exported complete.
Form exported complete.
Form exported complete.
No composite form found.
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime – Writi
ng Audit Records for migrated Artifacts …
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime – Store
d Audited Data Successfully !!!
Step 6: check the dataforms in xml file in the following location:
C:\Hyperion\products\Planning\bin
Step 7: To import to the application the following command is the same:
Usage: FormDefUtil [-f:]
in my case i type:
FormDefUtil.cmd import -all localhost admin VITest
NOte: You will use import instead.
Step 8:Finish check the form in the application