The EspressReport ES Organizer is a powerful graphical user interface that allows users to design charts and reports and organize them with other files in virtual folders. The Organizer contents are automatically published to the Menu page and users can automatically generate URLs to run reports and charts. In addition, schedule and archive jobs are created and maintained through the Organizer. The Organizer also includes the user permissions and security level setting options.
To start the Organizer, click the link labeled Organizer in the Start page. This will open a pop-up window. Confirm ERES_Organizer.jnlp
file open by Java Web Start Launcher. Then the Organizer will open.
If you use Chrome as a browser, you have to save ERES_Organizer.jnlp
at first, and then to open it from your download directory. You will see the next dialog. Click and Organizer will open.
If you are working on the same machine as the ERES Server, you can also start the Organizer as an application. To do this, go to the directory where EspressReport ES is installed. With the server running, execute the ERESOrganizer.bat/.sh
file. This will open a dialog allowing you to login to the Organizer.
Since the Organizer is at heart a file management system, it is no coincidence that the application window resembles a file browser. The left-hand side of the window contains a list of projects and their associated sub-folders, while the right-hand side lists the contents of a folder in the upper pane and the project/folder descriptions in the lower pane.
Most of the Organizer functions can be controlled using the drop-down menus located at the top of the Application window.
This menu performs most of the file operations. Options in this menu include:
If you select this option, another menu pops up.
Creates a new project in Organizer.
Creates a new folder in current project/folder.
Launches ChartDesigner. (see Section 3.11 - Introduction to Chart Designer).
Launches DashboardBuilder (see Chapter 5 - Designing Dashboards).
Launches ReportDesigner (see Section 3.1 - Introduction to Report Designer).
This option allows you to set-up and manage data registries, their associated data files, and database queries.
This will open the currently selected file. If the file is a chart then the Chart Designer will open, allowing you to edit the chart. If the file is a report file then the Report Designer will open allowing you to edit the report.
Pack a GXML (Google Map), SXML (SVG Map) or DSB (Dashboard) file and its components (Templates, Tooltips etc.) into a single file (see Section 2.1.4.4 - Dashboard and Map Packages).
Unpack a GPAK (Google Map), SPAK (SVG Map) or DPAK (Dashboard) pack file into Organizer (see Section 2.1.4.4 - Dashboard and Map Packages).
This will delete the currently selected project, folder, or file.
This will refresh your Organizer window, allowing it to reflect the latest changes/modifications performed by other users.
This will close the Organizer.
This menu allows you to edit, and cut/paste files, folders and projects. Options in this menu include:
This allows you to insert a report or chart into the selected project/folder.
This allows you to edit the currently selected project, folder, or file. For projects and folders, you can change the project/folder name as well as its description. For files, you can change the display name, the location path or URL, and the description.
This option is only available to the administrator. It allows you to set owner privileges for defined users and groups.
This option is only available to the administrator. It allows you to setup and maintain user/group security levels that are applied to reports.
This option is only available to the admininstrator. It allows you to change the owner of the selected file, folder, or project.
This removes the selected project, folder, or file, and places it on the clipboard.
This makes a copy of the selected project, folder, or file, and places it on the clipboard.
This pastes the current clipboard project, folder, or file into the currently selected project or folder.
This menu allows you to setup and view published reports and charts. Options in this menu include:
This will load the ERES Menu page in a new browser window.
This option generates an Image URL for the currently selected chart.
This option generates a Report URL for the currently selected report.
This option generates a Dashboard URL for the currently selected dashboard.
This menu allows you to search for files or edit charts and reports. Options in this menu include:
This allows you to search through projects, folders, and files.
This will open the Chart Designer, allowing you to design or modify charts.
This will open the Report Designer, allowing you to design or modify reports.
The menu allows you to set and view options related to chart/report scheduling and archiving. Options in this menu include:
This allows you to set a schedule for the currently selected chart, report, project, or folder.
This allows you to set an archive for the currently selected chart, report, project, or folder.
This allows you to set an alert monitoring for the currently selected chart, report, dashboard, svg map, project, or folder.
This will open the log allowing you to view all the of the currently scheduled and archived jobs.
This will open the log allowing you to view all the current alert monitoring jobs.
This menu allows you to set and view several of the Organizer options. Options in this menu include:
This allows you to specify whether to open every chart or report in the same Chart Designer or Report Designer window (thus closing the current chart or report), or to open a new Chart Designer or Report Designer window for each chart or report opened.
This allows you to set up and modify virtual directories.
This allows you to search for, repair, or delete any broken links to files in the Organizer.
This allows you to update the path of certain items in the Organizer. This is helpful if you are moving files between installations or moving complete installations.
The toolbar at the top of the Organizer window offers easy access to some of the most commonly used features. The buttons perform the following functions:
Create a new project | |
Insert a new folder into the current project | |
Insert a new file into the current project or folder | |
Cut the currently selected project, folder, or file, and place on the clipboard | |
Copy the currently selected project, folder, or file, and place on the clipboard | |
Paste the current clipboard project, folder, or file into the currently selected project or folder | |
Delete the currently selected project, folder, or file | |
Set user privileges (Administrator only) | |
Manage Data Registries, files, queries, etc. | |
Search for projects, folders, or files | |
Edit the currently selected project, folder, or file | |
Preview the menu page | |
Generate a URL for the currently selected dashboard | |
Pack a map or a dashboard and it's components into a single file (see Section 2.1.4.4 - Dashboard and Map Packages) | |
Unpack a GPAK (Google Map), SPAK (SVG Map) or DPAK (Dashboard) pack file into Organizer (see Section 2.1.4.4 - Dashboard and Map Packages). | |
Go to Chart Designer | |
Go to Report Designer | |
Set schedule for the currently selected chart, report, folder, or project | |
Refresh the Organizer window |
Projects and their associated folders are the central part of the Organizer interface. They provide the primary means of organizing charts and reports. Projects are the top level of organization. You can use different projects for different users, for different groups in your organization, or to group charts and reports representing different data or information. You can insert many layers of sub-folders into the top-level project, creating just about any organizational structure.
It is important to note that all folders in the Organizer are virtual folders, meaning that they do not necessarily have a physical location on the server machine or mirror an actual directory structure. Projects and folders in the Organizer are pointers to real directories and files that may be stored in a variety of locations.
To create a new project, you can do one of the following: click the New Project from the File menu, right click in the left-hand pane and select New Project from the pop-up menu, or press Ctrl+P. A node labeled new project will appear at the top of the file tree in the left-hand pane.
button on the toolbar, selectTo edit the project name and description, first select it, then you can do one of the following: click the Edit from the Edit menu, or right click, and select Edit from the pop-up menu. A dialog will then appear, prompting you to change the project name and description. Once you have entered your desired changes, click and the new project name and description will be displayed in the lower right-hand pane.
button on the toolbar, selectTo insert a sub-folder into a project or folder, first select the project or folder in which you would like to place the new sub-folder. Then you can either click the New Folder from the File menu, right-click in the left-hand pane and select New Folder from the pop-up menu, or press Ctrl+F. A node labeled new folder will appear under the currently selected project or folder.
button on the toolbar, selectTo edit the folder name and description, first select it, and then you can either click the Edit from the Edit menu, or right-click, and select Edit from the pop-up menu. A dialog will then appear prompting you to change the folder name and description. Once you have entered your desired changes, click , and the new project name and description will be displayed in the lower right-hand pane.
button on the toolbar, selectYou can insert files of any type into projects and folders. However, if you want your files to be accessible to other users or visible within the Menu, then files should be viewable within a web browser (i.e. HTML pages, image files, etc.), or be chart, report, map or dashboard files (CHT, TPL, RPT, PAK, PAC QPT, QCH, DSB, GXML, SXML, CXML or XML format). Files added to the Organizer must be accessible via http protocol, and may need to be mapped via URL mapping. For more about URL mapping in Organizer, see Section 2.1.5 - URL Mapping.
To add a file, first select the folder or project in which you would like to place the file. Then you can either click the Insert File from the Edit menu, or right click in the upper right-hand pane, and select Insert File from the pop-up menu. A dialog box will appear, prompting you to enter a display name for the file (by default the file name is used), the location of the file (a direct path) and a description of the file. (If you select a path that is not the server root or a mapped virtual directory, you will be prompted to map one.) Click and the file will be inserted into the current directory or folder.
button on the toolbar, selectTo insert more than one file at a time, click the CTRL+Click to select multiple files in the browse dialog. Then when you click all of the files will be added to the Organizer.
button on the insert file dialog, and useThe list of files in the currently selected folder will be displayed in the upper right-hand pane of the Organizer. Each entry shows the file's display name, the file type, the file description, path, and URL.
To edit the file's display name, location, or description, first select the file that you would like to edit. Once you have selected a file, you can either click the Edit from the Edit menu, or right click, and select Edit from the pop-up menu. A dialog box will appear allowing you to make changes to the display name, location, and description. Click and the changes will be reflected in the file list.
button on the toolbar, selectTo open a file, first select it, and then you can select Open File from the File menu, or right click and select Open File from the pop-up menu. If the file is a chart (PAC, CHT, TPL, or QCH) format, it will be opened in the Chart Designer. If the file is a report (PAK, RPT, QPT, or XML) format, it will be opened in the Report Designer. If the file is a dashboard, the Dashboard Builder interface will open in a new window. If the file is a map, the Map Builder interface will open in a new window. All other file types, such as SVG, will be opened in a web browser window.
To arrange files within folder or project, open the folder (click on it in the left-hand side tree-list) and then click on a column header in the right-hand side. Files in the folder/project will be arranged by the content of the selected column. To switch between ascending and descending order, click on the column header again.
The ERES Organizer has an automatic report locking system designed to block multiple users from editing the same report in Report Designer at the same time. The system utilizes your IP address, your username, and a special token to determine whether you are allowed to open a specific file. Here is an example illustrating how the advanced file locking system operates.
Suppose you are logged in as userA and you are editing a report Sales.pak
. One of your colleagues logs in as userB and attempts to edit the same Sales.pak
. She would see the following error message, alerting her that the file is currently locked.
Suppose after opening the file, your browser crashed or you moved to a different computer. Now you log back in as userA and open the same file again. You will see the following message allowing you to override your own lock.
If you moved to another computer and the report is still opened on the previous computer, you will not be able to save on the previous computer. You must close the report and re-open it in order to have write privilege again.
Note | |
---|---|
The admin has the ability to overwrite any lock. |
A single map or a single dashboard usually consists of several files (for example, a dashboard needs several chart/report/map templates, a svg map needs a svg image, drill-down template, etc) which could make moving maps or dashboards to another machine very difficult, because you would have to move all the linked files as well. Fortunately, you do not have to move each file manually. A dashboard or a map and can be packed into a single file along with all the linked files (dashboard templates, drill-down templates, etc) without even knowing which exact files are needed for the dashboard or map to work. The packed files can be moved or archived quickly and easily.
To pack a dashboard or a map (both SVG and Google maps can be packed), select the dashboard (.dsb
) or map (.sxml
or .gxml
) file in Organizer and then click on the icon on the main Organizer tool bar. A dialog will pop up prompting you to select the pack file name. Enter a file name or use the default one and click . Another dialog should show up confirming that the package was created successfully and showing you the full file path. The packed file will be also automatically inserted into the current Organizer folder/project.
Packed files can be viewed in the Menu page without being unpacked, but they can not be modified in the Map Builder or in the Dashboard Builder. In order to modify a packed dashboard or map, you need to unpack the gpak, spak, or dpak file first.
To un-pack a dpak, spak, or gpak file that has not been inserted into Organizer, click on the icon on the main Organizer tool bar. A dialog will pop up, allowing you to choose the file on your hard drive and to enter a name which will be used for the main unpacked file (.dsb, .sxml
or .gxml
file).
If you want to unpack a file that has been inserted into Organizer, select the file in Organizer and then click on the . The same dialog will pop up but the file path and the file name fields will be filled automatically.
To view the list of all files that are stored in the package, click on the
button. A new window will open.In this window, you can edit both physical and Organizer file path of all files that can be un-packed from the package (which also allows you to resolve potencial file name conflicts). After you are done editing the file paths, click the
and then click to unpack the package.The ERES will now try to unpack all files from the packed file to their original locations. If there are any filename conflicts (i.e. there already is a file with the same name in the same path on your hard drive or in Organizer), the following dialog will show up:
If you click Unpack File List dialog will open again allowing you to edit the filename conflicts. Then click to unpack the files into their locations and to insert them into Organizer.
, all existing files will be overwritten by the files from the package without no further questions. If you click , theAny report or chart that is added to the Organizer needs to be accessible via URL. This is so that reports can be run/viewed through the menu page, using URLs, or retrieved through the API. In order for the Organizer to know the URL path to charts and reports, you need to set the URL mapping.
The first, and most important, thing to map is your ERES installation. You should have a virtual directory setup in the app server/servlet container where you have deployed the server that points to your installation. If you selected to install Tomcat with ERES then a virtual directory has automatically been setup where http://MachineName:Port/ERES
points to the ERES installation directory. In order for Organizer to read and write files to your installation directory you will need to make sure that this mapping is correctly set.
URL mapping can also be used to set the URL path for other servers or virtual directories on your server whose report/chart files you would like to import to the Organizer. Please note that only the admin can create and change the URL Mapping entries. You will have to log in as the admin user to make changes to the URL Mapping.
To set up a virtual directory, select Set URL Mapping from the Option menu. A dialog will appear listing all of the virtual directories that have been set up. (By default, the Web root for the app server/servlet container where you have deployed the server is mapped to the URL http://machinename:port/
depending on your machine name and specified port number. To add a virtual directory, click on . A dialog will appear allowing you to enter or browse to a direct path. Once you have specified the path, then enter the corresponding URL. Click and the virtual directory will be added. You can also edit and remove mapped URLs from the main dialog.
You will also be prompted to specify URL mapping any time you add a file from a new location that has not been mapped with a corresponding URL.
Because Organizer uses virtual directories, it is possible to have files in many different physical locations listed in the Organizer. While this makes it easy to publish reports and charts, it can be difficult to manually keep track of all the files. Specifically, if the files are moved or the directory structure is changed, then the Organizer will not be able to find the files and the links within the Menu page may no longer work.
You can use the Repair Broken Links feature in the Organizer to automatically check the status of the listed files. The Organizer will check all of the files within your projects and folders to check whether the path/URL specified is still correct.
To check for broken links, select Repair Broken Links from the Option menu. The Organizer will then check all of your files and pop up a list of any broken links found. You can then choose to repair any broken links by specifying a new path or file/filename, or you can remove the files from the Organizer.
Sometimes you may want to update the directory path of certain items in the Organizer. The Update Directory feature is helpful if you are moving files between installations or if you are moving complete installations.
In order to update the directory paths of items in the Organizer, select Update Directory from the Option menu. The update directory dialog will then open.
The dialog allows you to specify the original directory (the directory you want to update) and the new directory. You can either use the
buttons to select directories or just type directory paths manually.Please note that when you are updating directories using the update directory feature, all the organizer items that contain the original path in their directory paths will be updated. For example, if you specify the original path as C:/ERES
and the new path as D:/Install/ERES
, all the items in the Organizer that contain C:/ERES
in their paths such as (C:/ERES/Reportfiles/SalesReport.pak
, C:/ERES/ChartFiles/MonthSales.cht
, C:/ERES/DashboardFiles/Dashboards/SalesDashboard.dsb
, ...) will be updated to (D:/Install/ERES/Reportfiles/SalesReport.pak
, D:/Install/ERES/ChartFiles/MonthSales.cht
, D:/Install/ERES/DashboardFiles/Dashboards/SalesDashboard.dsb
, ...). Also, note that the new directory (the updated directory) needs to be added to your URL mapping. Otherwise, you will not be able to repair broken URL links after the update, so the affected organizer items will not work correctly. For more information about URL mapping and repairing broken URL links, please see Section 2.1.5 - URL Mapping and Section 2.1.6 - Repairing Broken Links.
Example:
For instance, assume that you have moved the MonthSales.pak
, OrderDetails.pak
, and TopCustomers.pak
reports from the C:/ERES/ReportFiles/SalesReports
directory to the C:/Marketing/SalesReports
directory. The following image shows the reports in the Organizer before the updating process.
Select Update Directory from the Option menu in the Organizer to open the update directory dialog. In the dialog, specify the original directory as C:/ERES/ReportFiles/SalesReports
and similarly the new directory as C:/Marketing/SalesReports
.
Once you have properly specified the directories, press the
button. The following dialog will then appear showing you the list of updated organizer items as well as number of updated files.Next, click the
button in the dialog. This will bring you back to the Organizer. The image below shows updated reports paths after the updating process.Now you have to repair the broken URL links. Otherwise, URLs of the affected organizer items will remain mapped to the original directory. In order to repair broken URL links properly, you have to add the new directory (the directory you have specified in the Update directory dialog C:/Marketing/SalesReports
) as new URL link to your URL mapping. To open the URL mapping dialog, select Setup Url Mapping from the Option menu in the Organizer. The dialog will then appear.
In order to add a new URL link, click the Virtual Directory and Corresponding URL. Specify the virtual directory as C:/Marketing/SalesReports
and the corresponding URL e.g. as http://<MachineName>:<Port>/Marketing/SalesReports
. After that, click . For more information about URL mapping, please see Section 2.1.5 - URL Mapping.
Once you have specified the URL link, click the Repair Broken Links from the Option menu in the Organizer. For more information about repairing broken URL links, please see Section 2.1.6 - Repairing Broken Links.
button again. The repair broken links dialog will then appear prompting you whether you want to check for broken links now. Click . Please note that if you click , you may check for broken URL links by selectingIf you have correctly specified the URL mapping, you should get the following dialog that will inform you that broken links have been successfully fixed. Clicking the
button will bring you back to the Organizer.Note | |
---|---|
If you did not specify the URL link in the URL mapping or did not specify the URL link correctly, the dialog below will appear informing you that broken URL links cannot be repaired. If you got this dialog, return back to the URL mapping dialog and add/modify the URL link as described in previous steps. After that try to repair broken links again. |
Now you may check whether the URL fields of the organizer items have been correctly repaired. The URL fields should be similar as the ones shown on the image below.
Often, if you have many files in many folders in the Organizer, it can be hard to find a specific file. To locate files or folders, you can use the search function. To search, you can either click the button on the toolbar, select Search from the View menu, or right click in the upper right-hand panel and select Search from the pop-up menu. The search dialog will then appear.
The search dialog prompts you to enter a search string in the project or folder in which you would like to search. By default, the currently selected project or folder is listed. If you leave the Look In field blank, it will search all projects.
Other options allow you to include sub-folders in your search, and to match the search string to filenames, descriptions, and URLs. You can also match case in your search by selecting the Case Sensitive option.
In ERES, you can limit the open and insert dialogs in Organizer, Report Designer, and Chart Designer by adding a parameter to the Organizer. If launching the Organizer through the JSP page, edit /ERESOrganizer.jsp
and add the following line:
<param name="BrowseRootDir" value="<Directory>"/>
For instance, the follow limits the browse directory to the ERES root directory located under C:\ERES
<param name="BrowseRootDir" value="C:\ERES"/>
If starting the Organizer using the bat file, edit ERESOrganizer.bat
and add the following option at the end of the command.
... quadbase.reportorganizer.manager.OrganizerClient -BrowseRootDir:<Directory>