Upload XML Publisher files from File System

Dear Readers

I am sure when many of us have migrated XML publisher files (such as RTF files of templates, XML files of Data Templates, Bursting control files etc.), we have had to provide detailed document with screenshots so that person migrating the same knows how to upload these files to the database

Now, there is no need to do so. We can use the Oracle standard XDOLoader command to load the files from file system straight into the database without even opening the application

Below is an example of this for uploading a RTF template file. The same can be extended to other types of files and just we need to change the value of the parameter LOB_TYPE to any of the valid values mentioned below (from lookup XDO_LOB_TYPE)

Command
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD $apps_passwd -JDBC_CONNECTION $jdbc_conn_string
-LOB_TYPE TEMPLATE_SOURCE
-APPS_SHORT_NAME XXCUST
-LOB_CODE XXCUSTBIP1
-LANGUAGE en
-TERRITORY 00
-XDO_FILE_TYPE RTF
-FILE_CONTENT_TYPE application/rtf
-FILE_NAME /tmp/XXCUSTBIP_TEMPL1.rtf
-NLS_LANG $NLS_LANG
-CUSTOM_MODE FORCE

Valid Values for LOB_TYPE

LOB_TYPE_CODE	DESCRIPTION
BURSTING_FILE	Bursting Control File
DATA_TEMPLATE	Data Template
TEMPLATE	Template
TEMPLATE_SCHEMA	Template Schema
TEMPLATE_SOURCE	Template Source
XML_SAMPLE	XML Sample Data
XML_SCHEMA	XML Schema

How to find what to pass for XDO_FILE_TYPE and FILE_CONTENT_TYPE

If you are wondering how to determine the values to pass for XDO_FILE_TYPE and FILE_CONTENT_TYPE for files other than RTF templates, then all you need to do is query your already created record in XDO_LOBS in the instance where you manually loaded the file and it will show you the correct values

Hope this helps you all

Cheers
A