Workflow Reports
Workflow Reports are highly customizable automated reports for customers who wish to be notified about their shipments on a regular basis via email. Report format can be set as CSV or HTML or XML Spreadsheet or MS-Excel format. It can be scheduled and auto sent on email as an attachment as per a given format. Workflow reports are specific to workflows. Each workflow can have any number of Workflow Reports according to the fields that are required to be reported.
Viewing Reports
Select the workflow for which reports are to be viewed or you can also search by the report name. A sample is given below:
Creating a New Report
Select the workflow for which a new report is to be created and click on the 'Create' button. The following dialog box appears:
Select the Workflow from the drop-down menu.
Provide a name for the report in the Report Name field.
Select 'File History' to store the generated report files history. It can be 'No History', 'Sent Only ', or 'Sent or Previewed'.
Select Report Type from the drop-down list. It can either be by Work Order (a single work order per line) or by Job (a single shipment per line).
The Active checkbox is selected by default. It can be used for deactivating the entire report and all subscriptions.
Select the Restricted checkbox if you want the report to be restricted. (Restricted Report can only be viewed by the user creating the report and SysAdmins)
Click on the Create button to create the report for this workflow.
A newly created report does not contain any fields or email subscriptions. Click on the 'Create' button under each of them to define the report.
Modify Report
Click on the Pencil icon to modify report name, history or status as shown below:
The page will disappear as mentioned:
Make desired changes and click on 'Save' button.
Report Owner: "Report Owner" is the one who owes responsibility of the report. A report is accessible and modifiable only by the Report Owner or a System Administrator. The responsibility of the report owner includes creation, adding fields, modifying subscriptions, setting recipients, etc. No other user (except SysAdmins) are able to make any changes to the report.
Once the report is created, the creator of the report automatically becomes the owner. It is also possible to transfer the ownership of a report to another user by owner or SysAdmins.
Note: The ownership of the report can't be given to multiple users. Report owner can always be a single user.
Reports that are generated/pulled manually should be accessible to other users and access can only be given by the report owner or SysAdmin which is based on subscription instead of report. Such access can be granted or revoked as needed to specific users.
No changes can be made by such users who have access to report. They can only generate/download the reports from Reports -> My Reports.
Report Columns
Click on the 'Create' button under to create a new field for the report. The following window pops up:
Make the desired changes and click on 'Save' report.
Click on the mentioned icon to create a copy of this report. This copies the export fields of the report but Customer Subscriptions and User Subscriptions need to be defined for it
Click on mentioned icon to delete a report. A confirmation window pops up. Click on the 'Delete' button to confirm the deletion.
Once the report is created, looks as below:
Click on the 'Add Field' button under Fields to add to this report. The following dialog box is displayed:
Select a Source for the field. The source is the location from where the export field will be extracted from the Work Order. It can be extracted from Basic (WO header fields), Events, Data, Delay Tracking, KPIs.
Select a Field. This is the name of the field that is extracted from the specified Source.
Choose Select Option from the drop-down menu. It can be Data Value, Remarks Only, Data Updated Time & Date, or Data Updated By.
Provide a Column Name. This name is a description of the Field Name that will be used in the report.
Select Wrap Data if the contents of this field should wrap (applicable only for HTML or Excel reports).
Click on the 'Create' button to add this field to the report.
Customer Subscriptions
Once the fields are added to the report, customer subscriptions need to be defined. Click on the 'Add Subscription' button under Customer Subscriptions, the following window pops up:
Select the country code from the drop-down list and select a Customer from the auto-complete list.
Select Customer Type from the drop-down menu.
Checkbox for adding customer as recipients.
Type in a customized message for the recipients of this subscription in the Custom Message box.
Select Completed/NA Events from the drop-down list if applicable. If selected, work orders that have the event completed are excluded from the report.
Select Non-Completed/TBA Events from the drop-down list if applicable. If selected, work orders that do not have the event completed are excluded from the report.
Select the format in which the report will be sent from the Report Type drop-down list. It can be CSV or HTML or MS-Excel format.
If MS-Excel format is chosen, an option list of pre-defined Excel templates is provided from which one can be selected.
Zip Report when selected, the attachment file is zipped into the standard .zip file format. The report will be zipped only when sent via email, previewing the report will not generate a zip file.
Select whether or not to include closed work orders for this report from the Closed Work Orders drop-down list.
Select Report Frequency for a weekly or monthly subscription of the emails.
Select the days on which this report will be sent out, in the Send On checkboxes.
Provide the time in UTC hours at which the report will be sent out in At Hour(s) text box. More than one time can be provided with comma-separated values
Click on the 'Create' button.
User Subscriptions
User Subscriptions can be defined if internal users need regular reports for the workflow as well. While Customer Subscriptions are specific to a single customer, User Subscriptions can contain all active work orders for the selected workflow.
Click on the 'Add Subscription' button under User Subscriptions, the following window pops up:
Provide a Title for this subscription.
Type in a customized message for the recipients of this subscription in the Custom Message box.
Select Completed/NA Events from the drop-down list if applicable. If selected, Work Orders that do not have the event completed are excluded from the report.
Select Non-Completed/TBA Events from the drop-down list if applicable. If selected, Work Orders that have the event completed are excluded from the report.
Select the format in which the report will be sent. It can be CSV or HTML or XML Spreadsheet or MS-Excel.
Select the excel template from the drop-down.
Zip Report when selected, the attachment file is zipped into the standard .zip file format. The report will be zipped only when sent via email, previewing the report will not generate a zip file.
Select the days on which the report will be sent out in the Send On checkboxes.
Provide time in UTC hours in the At Hour(s) text box. Multiple hours can be provided as comma or semi-colon separated values.
Click on the 'Create' button.
The email is sent automatically to the selected recipients on the selected days and time with specified fields in the form of an attachment.
Fields are displayed in a report in the order of their creation. This order can be changed by dragging icon up or down.
Hover over icon for any field to modify or delete it.
Under the Customer Subscription tab, subscriptions can be created/viewed/modified.
Under the User Subscription tab, subscriptions can be created/viewed/modified.
Hover over icon to select one of the following actions from the menu:
Previewing a Subscription
Click on icon in Customer/User Email subscriptions to preview the subscription. It opens in the format selected for it during creation.
Creating a Recipients List
Click on icon to add the name or email addresses of the User or Customer who are subscribed to this report.
Setting User Access
Click on icon to set user access which allows user to generate/download subscription manually from Reports -> My Reports.
Emailing a Report to Customers/Users
Click on icon to send the email to customers and users who are subscribed to this report.
Modifying a Customer/User Subscription
Click on icon to edit any Export Field or Customer or User Email Subscriptions. In Customer Email Subscriptions, all fields except the Customer field can be edited. In User Email Subscriptions, all the fields can be edited.
Deleting a Customer/User Subscription
Click on icon to delete an Export/Field or Customer or User Email Subscriptions. A confirmation window pops up, click on the 'Delete' button to confirm the deletion.