JS7 JobScheduler

Space shortcuts

Page tree

Versions Compared

Old Version 5

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version Current

changes.mady.by.user Alan Amos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Introduction

A number of JS7 views offer to export dataallow data to be exported:

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.

...

  • 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.

...