Page History
...
Introduction
A number of JS7 views offer to export data, for example the allow data to be exported:
- JS7 - Daily Plan view
...
- JS7 - Resources - Agent Job Executions sub-view
- JS7 - History view and any of its sub-
...
- views
...
...
Such data are exported to a Microsoft Excel® file in OpenXML format with an .xlsx extension and are offered for downloadcan be downloaded.
Invoke the Export of Data
Views that offer to export data display the allow data to be exported display an icon in the right upper corner. Clicking the icon invokes the export of data.
The export file is offered for download can be downloaded with the application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
mime type. Depending on the browser settings the file is offered to can be stored to disk or to be opened with an application which has been assigned this mime type such as Microsoft Excel® that is assigned this mime type.
Exported Data
Users can start from the fact that data are exported exactly as visible from shown in the view. This applies to scope, sorting and data formats.
...
Exported data include any entries visible with the given JS7 JOC Cockpit view.
- If filters are applied then they are considered to limit as limiting exported data.
- The exported data include any entries independent from entries regardless of the pagination applied by the view.
- For example, if a view finds 1000 resulting entries it might display just 100 entries per page. However, all 1000 entries will be exported.
- Views are limited concerning the total number of entries displayed.
- Such limits are managed per view from the JS7 - Profiles - Preferences.
- By default JS7 by default limits views to display displaying 5000 entries. This number can be exceeded increased by modifying the respective relevant user profile settings, however. However, this will increase memory consumption and CPU load of the user browser. Depending on the capabilities of the client device users are free to choose the their limit for the display of entries.
- A number of views such as the JS7 - Workflows view offer allow data to be display data in compact mode and in standard modemodes:
- The compact mode includes far fewer columns than standard mode.
- Toggling between both modes is performed by use of using the icon.
Note: Use of JS7 - Views - Customizations and JS7 - Views - Ignore Lists can be used to further limit the scope of exported data.
...
Exported data are sorted according to the sort sorting order of the view.
Users can click on any column header in a JS7 view to display entries in ascending or descending order of column values.
...
Numeric values are exported as visible from shown in the view, this excludes decimals and other separators.
Note: Consider units used by the respective view. For example, the JS7 - Order History displays the duration of order execution as a string value. The numeric value can be calculated from the Order start time and end time of an Ordertimes.
Date Format
Date values are exported as visible from shown in the view.
Note: The time zone and date format in use used are determined from by the JS7 - Profiles - Preferences. Any dates are converted to the time zone specified by in the user profile's preferences.
Reporting
Delimitation
Export The export capabilities of the JOC Cockpit GUI are aimed at a WYSIWYG user experience. This includes to consider consideration of user preferences and to manually invoke invoking the export of data.
Reporting is different from export:
- Reporting is performed:
- for normalization of data, for example to use , using a standard date format instead of user specific formats,
- without applying user based filters.
- Reporting is automated to be for executed at on a regular basis and may be carried out, for example from , by a weekly JS7 job.
Automation
For reporting purposes the The JS7 - REST Web Service API is offeredprovided for reporting purposes.
- Users are free to implement reporting client applications with the scripting language or programming language of their choice. The only prerequisite being here is that the language in use used implements a REST Client.
- The JS7 - PowerShell Module:
- is a wrapper to the JS7 REST Web Service API that simplifies use of the API to a few lines of script code.
- is available for Unix, Windows and MacOS platforms.
- connects to the JS7 JOC Cockpit by use of using HTTP/HTTPS connections - exactly as users would do from their browser. Therefore, the PowerShell Module can be operated on any supported platform and used to access the JS7 on a remote machine.
- The PowerShell Module offers provides
- JS7 - How to automate creation of reports including cmdlets to create:
- a number of general considerations for:
...