JS7 JobScheduler

Space shortcuts

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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 JOC Cockpit 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 be used to 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.


  • No labels