DIS Workbook Export Script

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Use this report to migrate Discoverer workbooks to Blitz Report through the following steps:

1. Run this report 'DIS Workbook Export Script' to generate a list of commands to export xmls for all recently used Discoverer workbooks.
2. Create a new folder on a windows machine having the Discoverer Admin executable dis51adm.exe installed (contact Enginatics, if you need help with the Discov ...  Use this report to migrate Discoverer workbooks to Blitz Report through the following steps:

1. Run this report 'DIS Workbook Export Script' to generate a list of commands to export xmls for all recently used Discoverer workbooks.
2. Create a new folder on a windows machine having the Discoverer Admin executable dis51adm.exe installed (contact Enginatics, if you need help with the Discoverer Administrator installation).
3. Open a Command Prompt window, cd to the new folder, and execute (copy and paste) the commands generated in step 1. This will start individual processes to export the workbooks as .eex files. Depending on your client capacity, you can run between 100 and 200 export processes at the same time. In case of errors, delete all zero size .eex files and rerun the script.
4. Zip together all generated (non-zero size) workbook_*.eex files. Do not include the generated *.log files.
5. If you have more than one EUL, set the profile option 'Blitz Report Discoverer Default EUL' to the end user layer for which you run the migration
6. Navigate to Setup>Tools>Import>XML Upload and upload the .zip file generated in step 4. You will see a message with the count of uploaded xml files.
7. Run concurrent program 'Blitz Report Discoverer Import' from the System Administrator responsibility, and specify a report name prefix to easily distinguish the migrated reports.
8. Verify the migration result by running reports: Blitz Report SQL Validation, Blitz Report LOV SQL Validation, DIS Workbook Import Validation, DIS End User Layers. The migrated reports are assigned to a new Discoverer category.   more
Run DIS Workbook Export Script and other Oracle EBS reports with Blitz Report™ on our demo environment
select
'if not exist workbook_'||ed.doc_id||'.eex (start "'||:executable_path||'" /connect '||:eul||'/'||:eul_password||'@'||:db_service_name||' /export "workbook_'||ed.doc_id||'.eex" /workbook "'||xxen_util.dis_user_name(ed.doc_eu_id,:eul,'N')||'.'||ed.doc_name||'" /xmlworkbook'||chr(38)||' ping /n '||:delay_seconds||' localhost >NUL) else (echo workbook_'||ed.doc_id||'.eex exists)' text,
ed.doc_name workbook,
xxen_util.dis_user_name(ed.doc_eu_id,:eul) owner,
'workbook_'||ed.doc_id||'.eex' file_name
from
&eul.eul5_documents ed
where
1=1 and
(ed.doc_name, xxen_util.dis_user_name(ed.doc_eu_id,:eul,'N')) in (select eqs.qs_doc_name, upper(eqs.qs_doc_owner) qs_doc_owner from &eul.eul5_qpp_stats eqs where 2=2 &or_owner_restriction)
order by
ed.doc_id
Parameter Name SQL text Validation
Accessed within Days 
eqs.qs_created_date>sysdate-:history_days
 Number
Accessed After 
eqs.qs_created_date>:date_from
 Date
Workbook Owner 
 or upper(eqs.qs_doc_owner)=:doc_owner
 LOV
Workbook 
eqs.qs_doc_name=:workbook
 LOV
End User Layer 
<parameter_value>
 LOV
End User Layer Password 
 
 Char
Executable Path 
 
 Char
DB Service Name 
 
 Char
Not yet imported only 
ed.doc_id not in (select xdwx.doc_id from xxen_discoverer_workbook_xmls xdwx where xdwx.eul=:eul)
 LOV
Download
 
Related Blitz Reports
DIS Access Privileges DIS Workbooks, Folders, Items and LOVs DIS Worksheet Execution History DIS Workbook Import Validation DIS Folders, Business Areas, Items and LOVs DIS Business Areas DIS Worksheet Execution Summary DIS Users DIS Worksheet SQLs
Blitz Report™

Blitz Report™ provides multiple benefits: