Introduction
A number of JS7 views offer to export data, for example the JS7 - Daily Plan view, the JS7 - History view and any of its sub-views such as JS7 - Order History, JS7 - Task History etc.
Such data are exported to a Microsoft Excel® file in OpenXML format with an .xlsx extension and are offered for download.
Invoke the Export of Data
Views that offer to export data display the icon in the right upper corner. Clicking the icon invokes export of data.
The export file is offered for download with the application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
mime type. Depending on browser settings the file is offered to be stored to disk or to be opened with an application 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 the view. This applies to scope, sorting and data formats.
Scope
Exported data include any entries visible with the given JS7 view.
- If filters are applied then they are considered to limit exported data.
- The exported data include any entries independent from 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.
- JS7 by default limits views to display 5000 entries. This number can be exceeded by modifying the respective user profile settings, 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 limit for display of entries.
- A number of views such as the JS7 - Workflows view offer to display data in compact mode and in standard mode:
- The compact mode includes far fewer columns than standard mode.
- Toggling between both modes is performed by use of the icon.
Note: Use of JS7 - Views - Customizations and JS7 - Views - Ignore Lists can further limit the scope of exported data.
Sorting
Exported data are sorted according to the sort 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.
Use of the and icons toggles between descending and ascending order.
Note: The sort order depends on the collating sequence used with the JS7 - Database.
Number Format
Numeric values are exported as visible from 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 start time and end time of an Order.
Date Format
Date values are exported as visible from the view.
Note: The time zone and date format in use are determined from the JS7 - Profiles - Preferences. Any dates are converted to the time zone specified by the user profile's preferences.
Reporting
Delimitation
Export capabilities of the JOC Cockpit GUI are aimed at a WYSIWYG user experience. This includes to consider user preferences and to manually invoke the export of data.
Reporting is different from export:
- Reporting is performed
- for normalization of data, for example to use a standard date format instead of user specific formats,
- without applying user based filters.
- Reporting is automated to be executed at a regular basis, for example from a weekly JS7 job.
Automation
For reporting purposes the JS7 - REST Web Service API is offered.
- Users are free to implement reporting client applications with the scripting language or programming language of their choice. The only prerequisite being that the language in use 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 JS7 JOC Cockpit by use of HTTP/HTTPS connections - exactly as users would do from their browser. Therefore, the PowerShell Module can be operated on any supported platform to access the JS7 on a remote machine.
- The PowerShell Module offers
- JS7 - How to automate creation of reports including cmdlets to create
- a number of general considerations for