Managed Reporting Extract Utility Output Files

WebFOCUS Online Help > Managed Reporting Administrator > Managed Reporting Extract Utility > Managed Reporting Extract Utility Output Files

Output files extracted by the Managed Reporting Extract utility contain comma-delimited information.

Top of page

Example: Extracting User Information

When you generate an output file for user information, the data is written in the following format:

"user_htm","mr_id","user_properties","user_description","group_href"

One line is generated in the output file for each group to which the user belongs. For example,

"wfuser.htm","wfuser","active,htmluser,","user descript.","#default"
"abcuser2.htm","abcuser2","active","ABC User 2 Desc","#abccommongro"
"abcuser2.htm","abcuser2","active","ABC User 2 Desc","#abcgroup2"
"abcuser1.htm","abcuser1","active","ABC User 1 Desc","#abccommongro"
"abcuser1.htm","abcuser1","active","ABC User 1 Desc","#abcgroup1"
"verylong.htm","verylongusernameindeed","active","jim
smith","#abccommongro"
"admin.htm","admin","admin,robot,robot,shared,sync","default
user","#default"
"phil.htm","phil","active,shared,robot","phil","#default"
"phil.htm","phil","active,shared,robot","phil","#verylonggrou"
"javauser.htm","javauser","active,robot,shared","javauser","#default"
"javauser.htm","javauser","active,robot,shared","javauser","#verylonggrou
"

Top of page

Example: Extracting Group Information

When you generate an output file for group information, the data is written in the following format:

"group_href","group_description","domain_htm"

For example,

"#verylonggrou","verylonggroup name indeed","untitled/untitled.htm"
"#verylonggrou","verylonggroup name indeed","a77q8wik/a77q8wik.htm"
"#verylonggrou","verylonggroup name indeed","jimv0o1e/jimv0o1e.htm"
"#abccommongro","ABC Common Group","abccommo/abccommo.htm"
"#default","default group","untitled/untitled.htm"
"#abcgroup2","ABC Group 2","a77q8wik/a77q8wik.htm"
"#abcgroup2","ABC Group 2","db5cwlin/db5cwlin.htm"
"#abcgroup1","ABC Group 1","abcdomai/abcdomai.htm"
"#mrgroup2","MR Group 2","samplere/samplere.htm"
"#mrgroup1","MR Group 1","salesrep/salesrep.htm"

Top of page

Example: Extracting Domain Information

When you generate an output file for domain information, the data is written in the following format:

"domain_htm","domain_properties","domain_description"

For example,

"jimssumm/jimssumm.htm","disabled","Jim's Summit Domain"
"untitled/untitled.htm","none","zzManagement Reporting (Development 
Area)"
"db5cwlin/db5cwlin.htm","none","ABC Domain 2"
"samplere/samplere.htm","none","zzSales Reporting (Development Area)"
"philipse/philipse.htm","none","Company Reporting"
"abccommo/abccommo.htm","none","ABC Common Domain"
"a77q8wik/a77q8wik.htm","none","ABC Domain 2 (test)"
"salesrep/salesrep.htm","none","Sales Reporting"
"jimv0o1e/jimv0o1e.htm","","jim"
"abcdomai/abcdomai.htm","none","ABC Domain 1"

Top of page

Example: Extracting Domain Content Information

When you generate an output file for domain content information, the data is written in the following format:

"domain_htm","record_type","record_subtype","item_href","item_description",
"item_flags","item_folder"

Note:

The record_type indicates the type of item found. Possible values are: HELP, PROFILE, OTHER (Others Files), STDRPT (Standard Report), or RPTOBJ (Reporting Object).
The record_subtype indicates the type of Standard Report or Reporting Object item found. Possible values are: ITEM or FOLDER. If the type is not ITEM or FOLDER, record_subtype is empty.
The item_href is the item's reference. This is prefixed with the following characters depending on its type:
- #foldername when the item is a folder.
- app/standardreportname.fex when the item is a Standard Report.
- mrv/reportingobjectname.fex when the item is a Reporting Object.

For example,

"domain01/domain01.htm","HELP","","app/help.htm","Help","",""
"domain01/domain01.htm","STDRPT","FOLDER","#dailyreports","Daily 
Reports","belongsto=#salesreports","#salesreports"
"domain01/domain01.htm","STDRPT","ITEM","app/salestra.fex","Sales 
Transactions","node=UNIXSRV8E,appname=salesdtl","#dailyreports"
"domain01/domain01.htm","STDRPT","FOLDER","#salesreports","Sales 
Reports","none",""
"domain01/domain01.htm","STDRPT","FOLDER","#weeklyreport","Weekly 
Reports","belongsto=#salesreports","#salesreports"
"domain01/domain01.htm","STDRPT","ITEM","app/salesana.fex","Sales 
Analysis","runasolap","#weeklyreport"
"domain01/domain01.htm","STDRPT","ITEM","app/salesbyb.fex","Sales by 
Branch","none","#weeklyreport"
"domain01/domain01.htm","RPTOBJ","FOLDER","#salesdatau5t","Sales 
Data","none",""
"domain01/domain01.htm","RPTOBJ","ITEM","mrv/
customer.fex","Customers","suffix","#salesdatau5t"
"domain02/domain02.htm","HELP","","app/help.htm","Help","",""
"domain02/domain02.htm","STDRPT","FOLDER","#inventoryrep","Inventory 
Reports","none",""

WebFOCUS