Uploading Templates

Advertisement
Hi All,
I need some help in moving my templates from one instance to the other. I 've about 120 templates and I'm looking for an option to upload all of these templates simultaneous into other instance.
Also, one thing of note was while I was downloading the templates and creating an ldt file I noticed that the XDOLoader created an xdotmpl.drvx file which seems to 've all the commands to upload all my files simultaneously into other instance.
I was wondering if anyone ever tried using the .drvx file to upload all the template files simultaneously into other instances.
The User Guide just seems to mention the way to upload one file at a time. It definitely works, but thatz a lot of work when u 've about 120 templates to be moved from server to server.
For everyones reference I'm posting a section from mt .drvx file:
----------Begin---------------
# $Header: xdotmpl.drvx 115.0 2001/01/01 00:00:00 mnagakur noship $
# dbdrv: exec java oracle/apps/xdo/oa/util XDOLoader.class \
# dbdrv: java &phase=dat \
# dbdrv: checkfile:~PROD:patch/115/publisher/templates:SSA Statement of Financing LAE OIG_en_US.rtf \
# dbdrv: UPLOAD \
# dbdrv: -DB_USERNAME &un_apps \
# dbdrv: -DB_PASSWORD &pw_apps \
# dbdrv: -JDBC_CONNECTION &jdbc_db_addr \
# dbdrv: -LOB_TYPE TEMPLATE_SOURCE \
# dbdrv: -APPS_SHORT_NAME ~PROD \
# dbdrv: -LOB_CODE SSA Statement of Financing LAE OIG \
# dbdrv: -LANGUAGE en \
# dbdrv: -TERRITORY US \
# dbdrv: -XDO_FILE_TYPE RTF \
# dbdrv: -FILE_NAME &fullpath:~PROD:patch/115/publisher/templates:SSA Statement of Financing LAE OIG_en_US.rtf
# dbdrv: exec java oracle/apps/xdo/oa/util XDOLoader.class \
# dbdrv: java &phase=dat \
# dbdrv: checkfile:~PROD:patch/115/publisher/templates:SSA Statement of Financing LAE OIG_en_US.xsl \
# dbdrv: UPLOAD \
# dbdrv: -DB_USERNAME &un_apps \
# dbdrv: -DB_PASSWORD &pw_apps \
# dbdrv: -JDBC_CONNECTION &jdbc_db_addr \
# dbdrv: -LOB_TYPE TEMPLATE \
# dbdrv: -APPS_SHORT_NAME ~PROD \
# dbdrv: -LOB_CODE SSA Statement of Financing LAE OIG \
# dbdrv: -LANGUAGE en \
# dbdrv: -TERRITORY US \
# dbdrv: -XDO_FILE_TYPE XSL-FO \
# dbdrv: -FILE_NAME &fullpath:~PROD:patch/115/publisher/templates:SSA Statement of Financing LAE OIG_en_US.xsl
---------End------------------
Thanks
Advertisement

Replay

Hi
You should be able to push them all in at once no problem ... I thought we documented that ... need to check
On the drvx file, thats generated for the benefit of ORacle developers for when they build their template patches ... it would be great if you could use but alas ... you can not. I have checked and their is no utility to read and upload ... at least not from Oracle. You could write a perl or unix script to parse the file and load the files pretty easily ... as long as you know your perl or unix of course :o)
Tim