本文介绍了获取所有报告的CUID的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何捕获CMC(中央管理控制台)或WEBI工具中可用的所有报告的CUID,并将其粘贴到Excel中?

How can I capture CUIDs of all reports available in CMC (Central management Console) or WEBI tool and paste it in Excel?

我可以手动查看每个报告来进行检查报告属性,但是如果我希望通过编码手动捕获所有CUID,那有可能吗?

Manually I can check by viewing each report properties but if I want all the CUID to be captured with out manually through coding Is that possible?

这可以用Java语言完成吗?

Can this be done in Java language?

推荐答案

不是我的,但希望它能为您提供帮助:

Not mine, but hope it can help you :

以下是示例Java代码

Here is the sample Java code to export a Web Intelligence document to CSV format.

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.ProtocolException;
import java.net.URL;

import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;
import org.json.simple.parser.ParseException;

public class Document {

public static void main(String[] args) {
  try {

            URL url = new URL(

                    "http://localhost:6405/biprws/raylight/v1/documents/7485/dataproviders/DP0/flows/0");

            HttpURLConnection conn = (HttpURLConnection) url.openConnection();

            conn.setRequestMethod("GET");

            conn.setRequestProperty("Accept", "text/plain");//change to text/plain if you want in CSV format

            String logonToken = "\"" + getLogonToken() + "\"";

            conn.setRequestProperty("X-SAP-LogonToken", logonToken);

            conn.setDoOutput(true);

            conn.setDoInput(true);

            conn.connect();

            if (conn.getResponseCode() != 200) {

                throw new RuntimeException("Failed : HTTP error code : "

                        + conn.getResponseCode());

            }

            BufferedReader br = new BufferedReader(new InputStreamReader(

                    (conn.getInputStream())));

            String output;
            // Exported CSV file will be generated at "C://rest.csv", location could be changed as required.
            File f1 = new File("C://rest.csv");
            f1.createNewFile();

            FileWriter fw = new FileWriter(f1);//change extension to .csv for csv format

            BufferedWriter bw = new BufferedWriter(fw);

            while ((output = br.readLine()) != null) {

                bw.write(output);

                bw.write("\n");

            }

            bw.close();

            conn.disconnect();

        } catch (MalformedURLException e) {

            e.printStackTrace();

        } catch (ProtocolException e) {

            e.printStackTrace();

        } catch (IOException e) {

            e.printStackTrace();

        } catch (ParseException e) {



            e.printStackTrace();

        }

}

public static String getLogonToken() throws ParseException, IOException {

    String logontoken = null;

    URL url = new URL("http://localhost:6405/biprws/logon/long/");

    HttpURLConnection conn = (HttpURLConnection) url.openConnection();

    conn.setRequestMethod("POST");

    conn.setRequestProperty("Accept", "application/json");

    conn.setRequestProperty("Content-Type",

            "application/xml; charset=utf-8");

    conn.setDoInput(true);

    conn.setDoOutput(true);

    String body = "<attrs xmlns=\"http://www.sap.com/rws/bip\">"

            + "<attr name=\"userName\" type=\"string\">Administrator</attr>"

            + "<attr name=\"password\" type=\"string\">Password</attr>"

            + "<attr name=\"auth\" type=\"string\" possibilities=\"secEnterprise,secLDAP,secWinAD\">secEnterprise</attr>"

            + "</attrs>";

    int len = body.length();

    conn.setRequestProperty("Content-Length", Integer.toString(len));

    conn.connect();

    OutputStreamWriter out = new OutputStreamWriter(conn.getOutputStream());

    out.write(body, 0, len);

    out.flush();

    if (conn.getResponseCode() != 200) {

        throw new RuntimeException("Failed : HTTP error code : "

                + conn.getResponseCode());

    }

    BufferedReader br = new BufferedReader(new InputStreamReader(

            (conn.getInputStream())));

    String jsontxt = br.readLine();

    JSONParser parser = new JSONParser();

    JSONObject json = (JSONObject) parser.parse(jsontxt);

    logontoken = (String) json.get("logonToken");

    conn.disconnect();

    return logontoken;

}

}

您可以检查也是:

这篇关于获取所有报告的CUID的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-09 19:38