Skip to end of metadata
Go to start of metadata

Introduction

A number of JS7 views allow data to be exported:

Such data are exported to a Microsoft Excel® file in OpenXML format with an .xlsx extension and can be downloaded.

Invoke the Export of Data

Views that allow data to be exported display an icon in the right upper corner. Clicking the icon invokes the export.

The export file can be downloaded with the application/vnd.openxmlformats-officedocument.spreadsheetml.sheet mime type. Depending on the browser settings the file can be stored to disk or opened with an application which has been assigned this mime type such as Microsoft Excel®.

Exported Data

Users can start from the fact that data are exported exactly as shown in 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 as limiting exported data.
  • The exported data include any 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 limits views to displaying 5000 entries. This number can be increased by modifying the relevant 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 their limit for the display of entries.
  • A number of views such as the JS7 - Workflows view allow data to be display in compact and in standard modes:
    • The compact mode includes fewer columns than standard mode.
    • Toggling between both modes is performed by using the  icon.

Note: 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 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.

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 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 and end times.

Date Format

Date values are exported as shown in the view.

Note: The time zone and date format used are determined by the JS7 - Profiles - Preferences. Any dates are converted to the time zone specified in the user profile's preferences.

Reporting

Delimitation

The export capabilities of the JOC Cockpit GUI are aimed at a WYSIWYG user experience. This includes consideration of user preferences and manually invoking the export of data.

Reporting is different from export:

  • Reporting is performed:
    • for normalization of data, for example, using a standard date format instead of user specific formats,
    • without applying user based filters.
  • Reporting is automated for executed on a regular basis and may be carried out, for example, by a weekly JS7 job.

Automation

The JS7 - REST Web Service API is provided for reporting purposes.


  • No labels