This content has been marked as final. Show 36 replies
Reports can be migrated using Discoverer Admin. Fire up the admin tool, and select Export from the File menu.
Choose the bottom option - Selected objects in the EUL, and click Next.
On step 2, select workbooks from the drop down, then select the workbooks you want to export (and click the right arrow to move them to the other side of the shuttle control). Click Next.
On step 3, type in (or use the browse button) the path and file name where the export is to be saved. Click finish.
Back n the admin tool, choose Connect from the file menu, and log into the target (or production) database.
Choose Import from the file menu.
Click Add File, and select the export file you created. Click next.
On step 2, select the options you want - the first set tell disco what to do if the object already exists, the second set tells disco what criteria on which to match, and the third set tells disco who should "own" the workbooks. Click next.
On step 3, click Start (in the upper right hand corner). Any errors or problems will be displayed. At this point, click Finish for disco to commit the changes, or click Cancel for Disco to roll everything back.
Thanks for your reply. I am using admin version 4.1.37. When i go to file and then export, it only asks to save the file in a particular location and when i click ok whole BA is exported.
I do not see any options button to select Workbooks nor i see any drop down list. I am not sure what is wrong. I again repeat we are using 4.1.37 Admin Version.
With Discoverer 4 it was a very manual process to migrate workbooks.
You can use discoverer administrator but you have to call the export
from the command line and you can export only one workbook at a time.
A script is available that you can use to do this.
Check out Metalink
Note 258392.1 How to mass transfer the workbooks created by one User to
another user in Discoverer 4.1.xx?
I read the documentation for the command line reference and followed the steps in it, but i am not able to export my business area. The commands which i used are :
DIS4ADM.EXE/CONNECT EUL_US/PASSWORD@DATABASE/EXPORT TEST.EEX/BUSINESS_AREA "TEST_BA"/ALL/EUL EUL_US/LOG IMPORT.LOG
I also tried like this
dis4adm.exe/connect eul_us/password@database/export text.eex "test_ba"/eul eul_us/log import.log
But i am getting the following error which is :
Unexpected Argument test.eex on command line.
I dont know whats wrong in my commands. It would be great if some body helps me out.
Yes, I think your command format is not correct.
Try the one that Rod posted.
About the note on metalink. It seems that it is under review.
Here is the basics of the note:
1. Determine the owner of the workbook. Say UserA.
2. Open an sqlplus session to the database.
3. Run the following sql:
SQL> set heading off
SQL> set feedback off
SQL> set echo off
4. Now spool the result of the following sql to a file.
SQL> spool c:\exp.bat
5. Run the sql statement
NOTE: CHANGE DISCOE_HOME
SQL>select '<Disco_Home>\discvr4\dis4adm /connect
EUL_owner_name/passwd@connect_string /export c:\'||rownum||'.eex /workbook "'||
SELECT EUL4_DOCUMENTS.DOC_NAME, doc_created_by, NVL(EUL4_EUL_USERS.EU_USERNAME,
'Document Not Shared') shared_with
FROM EUL4_ACCESS_PRIVS EUL4_ACCESS_PRIVS, EUL4_DOCUMENTS EUL4_DOCUMENTS,
WHERE ( EUL4_DOCUMENTS.DOC_ID = EUL4_ACCESS_PRIVS.GD_DOC_ID(+) ) AND (
EUL4_EUL_USERS.EU_ID(+) = EUL4_ACCESS_PRIVS.AP_EU_ID )
Disco_Home is the Location or Discoverer 4 Home.
4. SQL> spool off
5. SQL> set feedback on
6. Now run the batch command file (exp.bat)
I am able to export workbook 'kowon_test' and it created kowon_test.eex file in C:\orant\DISCVR4 directory. I used the following command.
C:\orant\DISCVR4\DIS4ADM.EXE /CONNECT "eul4_us/eul4_us@Test" /EUL "EUL4_US" /EXPORT kowon_test.eex /workbook "kowon_test"
Now I am trying to import this worksheet into sysadmin by using following command(In dev instance).
C:\orant\DISCVR4\DIS4ADM.EXE /CONNECT "eul4_us/eul4_us@dev" /EUL "EUL4_US" /IMPORT C:\orant\DISCVR4\kowon_test.eex
But not able to see the worksheet in the dev instance. Let me know if I need to follow any additional steps.