Export with Scheduler

Import Scheduler API

<%@ import="oz.scheduler.*,
            oz.framework.api.*,
            oz.util.SortProperties,
            oz.framework.cp.OZCPException
            ..."
%>
<%
    Scheduler scheduler = new Scheduler(schedulerIp, schedulerPort);
    Service service = new Service(serverUrl, serverID, serverPW, false, false);
    ServerInfo serverInfo = new ServerInfo();
    SortPropertie configMap = new SortProperties();
    SortProperties exportMap = new SortProperties();
%>

scheduler.export()

Boolean result = scheduler.export(serverInfo, configMap, exportMap);

export.jsp
<%@ page language="java"
  contentType="text/html; charset=UTF-8" 
  import="oz.scheduler.*,
          oz.framework.api.*,
          oz.util.SortProperties,
          oz.framework.cp.OZCPException,
	  org.apache.log4j.*,
          java.util.*,
          java.io.*"
%>
<%
  request.setCharacterEncoding("UTF-8");
  String ozrName	= request.getParameter("ozrName");
  String exportFormat	= request.getParameter("exportFormat");
  String inputData	= request.getParameter("inputData");
  // OZ Server
  String serverUrl 	= "http://localhost/oz/server";
  String serverID	= "admin";
  String serverPW	= "password";
  // Scheduler
  String schedulerIp 	= "127.0.0.1";
  int    schedulerPort 	= 9521;
  // Export env
  String exportPath = "C:\\Program Files\\Apache Software Foundation\\Tomcat 9.0\\webapps\\exported\\demo\\";			
  String exportFile = ozrName + "_export." + exportFormat; 
  String exportFilePath = exportPath + exportFile;
  String publishFilePath = exportFormat + "\\" + ozrName + "." + exportFormat ; 
  String ozrPath = "demo\\" + ozrName + ".ozr";
%>
<%
  Scheduler	scheduler = new Scheduler(schedulerIp, schedulerPort);
  Publisher	publisher = new Publisher(schedulerIp, schedulerPort);
  Service	service	= new Service(serverUrl, serverID, serverPW, false, false);
  ServerInfo	serverInfo = new ServerInfo();
  SortProperties configMap = new SortProperties();
  SortProperties exportMap = new SortProperties();
					
try {
  if (!service.ping()) {
    out.println("ERROR: Cannot connect to OZ Server [" + serverUrl + "]");
    if (true) return ;
  }
  if (!scheduler.ping()) {
    out.println("ERROR: Cannot connect to OZ Scheduler [" + schedulerIp + ":" + schedulerPort + "]");
    if (true) return ;
  }
  // OZ Server connection
  serverInfo.setURL(serverUrl);
  serverInfo.setID(serverID);
  serverInfo.setPWD(serverPW);
  serverInfo.setIsDaemon(false);
  // Task parameters
  configMap.setProperty("launch_type", "immediately"); // Task schedule option: 'immediately', 'once', 'periodically'
  configMap.setProperty("cfg.type", "new"); // Task type option: 'new', 'edit'
  configMap.setProperty("task_type", "viewerTag"); // Use Viewer parameters for task run option
  // Export parameters
  exportMap.setProperty("connection.servlet", serverUrl); // OZ Server connection
  exportMap.setProperty("connection.reportname", ozrPath); // OZR file name (full path)
  exportMap.setProperty("connection.inputjson", inputData);
  exportMap.setProperty("viewer.mode", "export");
  exportMap.setProperty("export.mode", "silent");
  exportMap.setProperty("export.confirmsave", "false");
  exportMap.setProperty("export.format", exportFormat);
  exportMap.setProperty("pdf.fontembedding", "true"); 
  exportMap.setProperty(exportFormat + ".filename", exportFile);
  /* Form Parameters
  exportMap.setProperty("connection.pcount", pcount);		
  export.setProperty("connection.args1", "param1=value");
  */
  /* ODI Parameters
  exportMap.setProperty("odi.odinames", odiName);
  exportMap.setProperty("odi." + odiName + ".pcount", pcount);
  exportMap.setProperty("odi.odiName.args1", "param1=value");
  */
  // Export request to the Scheduler
  Boolean result = scheduler.export(serverInfo, configMap, exportMap);
  out.println("scheduler.export result=" + result);
}
catch (Exception e) {
  out.println("Exception: " + e.getMessage());
  return;
}
%>

scheduler.directExport()

DirectExportResult result = scheduler.export(serverInfo, configMap, exportMap)

Member variables:

  • String taskID

  • String taskName

  • String taskGroupName

  • String completedTime

  • Stringt executeTime (seconds)

  • Boolean isSuccessful

  • String formName

  • String formCategoryName

  • String exportFileList

  • int pageCount

  • String errorMessage

directExport.jsp
  String exportFile = ozrName + "_directExport." + exportFormat; 
...
	// Export request to the Scheduler
	DirectExportResult result = scheduler.directExport(serverInfo, configMap, exportMap);
	// get result
	out.println("scheduler.directExport:");
	out.println("isSuccessful=" + result.isSuccessful);
	if (result.isSuccessful) {
	    out.println("taskID=" + result.taskID);
	    out.println("exportFileList=" + result.exportFileList);
	    out.println("completedTime=" + result.completedTime );
	} else {
	    out.println("errorMessage=" + result.errorMessage);
	}

Last updated

Was this helpful?