Tuesday, August 24, 2010

XML Importer for OA Framework ( A Simple - Easy to Edit Batch File)

As i had mentioned in the previous post about the XML importer . The easy to use and Ready batch file is given below which can be downloaded and a small modification to that file is needed for it to be used. Once this batch file is edited to the page whichever you want to import and just a Double-Click will do the trick to import the (.xml) file to MDS of database. The placing of this batch file will be discussed below .

Usage and Placing of Batch File :

Steps ,

1) Download the import.bat Batch file from the link below -

            import.bat

2) Go to jdevbin of jdeveloper extension and look for oaext directory and place the downloaded batch file in bin directory of oaext

            ie -  jdevbin/oaext/bin/BATCH_FILE_DOWNLOADED

3) Edit the following and leave the rest as it is

           right click on import.bat file and click edit , change :
  •    JDEV_BIN_HOME  to your jdev_bin_home
  •    JDEV_USER_HOME  to your jdev_user_home
  •    In DB_CONNECTION change host , port ( if applicable ) and SID
  •    PAGE2UPLOAD path of the (.xml ) file to import 
  •    APPS_PASSWD your password     
4) Save the import.bat file

5) Double_Click on batch file

and thats it , simple and cool batch script which can be reused just by changing the XML file.

Your XML file will be imported to the MDS of database and follow my post : (click)  to check whether the XML file is imported or not .

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails
Make Money Blogging