XLSX export data scope
Most lists in the Action Audit web platform can be downloaded as a spreadsheet using the XLSX button above the table. This page describes which data is included in the file when exporting:
- Action plans (
/action_plans.xlsx) - Audits (
/audit_plans.xlsx) - Activities (
/activities.xlsx) - Submissions (Kaizen) (
/idea_plans.xlsx) - Users (
/adm/users.xlsx) - Workers (
/adm/workers.xlsx)
General rules
Which records are included
- The export contains all records shown in the list, with the currently applied filters and sorting - regardless of pagination (not only the current page).
- The scope depends on the view the export was started from (e.g. My, All, Overdue). Available views are described in the sections below.
- Only records the user can access according to their roles and permissions and their place in the organizational structure are exported.
- Archived records are not exported (except for the user and worker lists - see below).
Language and data format
- Column headers and dictionary values (statuses, roles, etc.) are generated in the language set in the profile of the user running the export (or, if not set, in the organization’s default language).
- Date columns are stored as Excel dates, and the Work progress and Time progress columns as percentages.
- In the action plan, audit and submission exports, the cell with the record number is a hyperlink that opens the record in the platform.
Global parameters
Action plan, audit and submission exports additionally contain columns with global parameters. Exported parameters are those that have a name and are not marked as unavailable for the given module. The column header is the parameter name. Parameter columns are placed directly after the Tags column.
File generation and delivery
Action plan, audit, activity, submission and user exports are generated in the background:
- If the file is ready within the time limit (20 seconds by default), it is downloaded by the browser immediately.
- If generation takes longer, the message “Too long action, report will be deliver on your e-mail” is displayed and the finished file is sent as an attachment to the user’s e-mail address.
- If e-mail delivery to the user’s address is paused, the file is not sent and an appropriate message is displayed.
- If an error occurs, the message “Export failed. Please try again or contact the administrator” is displayed.
The worker export is generated directly (without background processing) - the file is always downloaded immediately.
In file names, [YYYYMMDDHHMM] is the export timestamp, e.g. Plans [202611161430].xlsx.
Action plans
Address: /action_plans.xlsx
File name: Plans [YYYYMMDDHHMM].xlsx
Sheet: Plans
The export contains regular action plans only - audits and submissions are not included (they have their own exports).
| View | Address | Scope |
|---|---|---|
| Default | /action_plans.xlsx | Unfinished plans, excluding parent plans that contain nested plans |
| All ongoing | /action_plans/all_ongoing.xlsx | All unfinished plans (including parent plans) |
| All | /action_plans/all.xlsx | All accessible plans, including finished ones |
| My | /action_plans/my.xlsx | Unfinished plans owned by the user |
| Overdue | /action_plans/overdue.xlsx | Unfinished plans past their due date |
The table starts at cell B2 (the first row and first column are empty).
| # | Column | Content |
|---|---|---|
| 1 | Number | Plan number (hyperlink to the plan) |
| 2 | Subject | Plan subject |
| 3 | Problem description | Plan description |
| 4 | Tags | List of tags |
| … | Global parameters | One column for each active parameter |
| 5 | Creator | Plan author |
| 6 | Owner | Plan owner |
| 7 | Orgcell | Full name of the organizational cell |
| 8 | Start date | Start date |
| 9 | Due date | Planned end date |
| 10 | Real end date | Actual end date |
| 11 | Work progress | Completion percentage |
| 12 | Time progress | Elapsed time percentage |
| 13 | Source plan number | Number of the record the plan originated from (e.g. an audit or a submission) - hyperlink; --- if none |
Audits
Address: /audit_plans.xlsx
File name: Audits [YYYYMMDDHHMM].xlsx
Sheet: Audits
| View | Address | Scope |
|---|---|---|
| Default | /audit_plans.xlsx | Unfinished audits, excluding audits with the Planned status |
| My | /audit_plans/my.xlsx | Unfinished audits where the user is the auditor, excluding Planned audits |
| All | /audit_plans/all.xlsx | All accessible audits, including finished and unexecuted ones |
Audits with the Planned status are exported only for users with the Administrator or Audit Manager role (All view), in line with the visibility rules described in Audits list.
The table starts at cell B2.
| # | Column | Content |
|---|---|---|
| 1 | Number | Audit number (hyperlink to the audit) |
| 2 | Subject | Audit subject |
| 3 | Description | Audit description |
| 4 | Tags | List of tags |
| … | Global parameters | One column for each active parameter |
| 5 | Auditor | Person assigned to the audit |
| 6 | Orgcell | Full name of the organizational cell |
| 7 | Type | Audit type |
| 8 | Audited area | Audit area |
| 9 | Layer | Audit layer (layered audits) |
| 10 | Status | Audit status |
| 11 | Unexecution reason | Reason, if the audit was marked as unexecuted |
| 12 | Score | Audit result; with an alternative score scale in the format alternative score (main score) |
| 13 | Start date | Planned start date |
| 14 | Due date | Planned end date |
| 15 | Real end date | Actual end date |
| 16 | Work progress | Completion percentage |
| 17 | Time progress | Elapsed time percentage |
| 18 | Real audit start | Actual start date and time |
| 19 | Real audit end | Actual end date and time |
| 20 | Real audit duration | Duration in the [hh]:mm:ss format |
Activities
Address: /activities.xlsx
File name: view title, e.g. My activities.xlsx
Sheet: date range from the Start date filter (if set)
The export contains published activities of action plans. Answers to audit checklist questions are not included.
| View | Address | Scope |
|---|---|---|
| Relevant activities | /activities.xlsx | Unfinished activities in active plans |
| Activities to do | /activities/todo.xlsx | The user’s activities waiting to be done |
| Activities to accept | /activities/toaccept.xlsx | Completed activities waiting for the user’s acceptance |
| My activities | /activities/my.xlsx | Unfinished activities related to the user |
| Overdue activities | /activities/overdue.xlsx | Unfinished activities past their due date |
| All activities | /activities/all.xlsx | All accessible activities, including finished ones |
The table starts at cell A2 (the first row is empty).
| # | Column | Content |
|---|---|---|
| 1 | Record number | Activity number |
| 2 | Subject | Activity subject |
| 3 | Description | Activity description |
| 4 | Resolution | Resolution entered during execution |
| 5 | Assignee | Person responsible for the activity |
| 6 | Area | Audit area related to the plan (applies to corrective plans created from audits) |
| 7 | Work progress | Completion percentage |
| 8 | Time progress | Elapsed time percentage |
| 9 | Start date | Start date |
| 10 | Due date | Planned end date |
| 11 | End date | Actual end date |
| 12 | Prio. | Priority |
| 13 | State | Activity workflow state |
The activity export contains neither global parameter columns nor hyperlinks to records.
Submissions (Kaizen)
Address: /idea_plans.xlsx
File name: Idea Plans [YYYYMMDDHHMM].xlsx
Sheet: Ideas
| View | Address | Scope |
|---|---|---|
| Default | /idea_plans.xlsx | Unfinished submissions |
| My | /idea_plans/my.xlsx | Unfinished submissions owned by the user |
| All | /idea_plans/all.xlsx | All accessible submissions, including finished ones |
The table starts at cell B2.
| # | Column | Content |
|---|---|---|
| 1 | Number | Submission number (hyperlink to the submission) |
| 2 | Subject | Submission subject |
| 3 | Submission description | Submission description |
| 4 | Resolution | Resolution description |
| 5 | Effect of the change | Description of benefits |
| 6 | Tags | List of tags |
| … | Global parameters | One column for each active parameter |
| 7 | Creator | Author of the submission in the system |
| 8 | Owner | Submission owner |
| 9 | Orgcell | Full name of the organizational cell |
| 10 | Regards | Organizational cell the submission concerns |
| 11 | Submitter | Person who submitted the idea (last name and first name) |
| 12 | Stage | Submission stage |
| 13 | Total points | Total points from ratings |
| 14 | Total effective points | Total effective points |
| 15 | Points threshold | Submission points threshold |
| 16 | Rejection reason | Rejection reason (if applicable) |
| 17 | Decision | Decision description |
| 18 | Start date | Start date |
| 19 | Due date | Planned end date |
| 20 | Real end date | Actual end date |
| 21 | Work progress | Completion percentage |
| 22 | Time progress | Elapsed time percentage |
If all exported submissions are of the same type (e.g. Quick Kaizen only), the export contains the global parameters available for that type. Otherwise, parameters available for all submissions are exported.
Users
Address: /adm/users.xlsx
File name: Users.xlsx
Sheet: Users
The export is available in the Resource administration module and contains only users that the exporting person can manage.
| View | Address | Scope |
|---|---|---|
| Default | /adm/users.xlsx | Non-archived users |
| Archived | /adm/users/archived.xlsx | Archived users only |
| All | /adm/users/all.xlsx | All users |
The first row of the sheet contains a title with a hyperlink to the platform; table headers are in row 2.
| # | Column | Content |
|---|---|---|
| 1 | Last name | User’s last name and first name |
| 2 | Organizational cell | Name of the organizational cell |
| 3 | Position | Position |
| 4 | E-mail address | |
| 5 | Login | Username |
| 6 | Roles | Comma-separated list of roles (e.g. Administrator, Audit Manager) |
| 7 | Is restricted? | Boolean value (TRUE/FALSE) |
| 8 | Report frequency | No reports, Less frequent reports or More frequent reports |
| 9 | Status | Active, Blocked, Archived or System |
Workers
Address: /adm/workers.xlsx
File name: Workers data [YYYYMMDDHHMM].xlsx
The export is available in the Resource administration module. It contains all accessible workers - including archived ones - with the applied filters. By default it is sorted by last name.
Table headers are in row 1.
| # | Column | Content |
|---|---|---|
| 1 | Worker number | Worker number |
| 2 | Last name | Last name |
| 3 | First name | First name |
| 4 | Organizational cell | Organizational cell abbreviation |
| 5 | Status | Active or Archived |
| 6 | Remarks | Remarks |
Pulse contact list
A separate worker export is available in the Pulse tab (/pulse/workers.xlsx, file Users data [YYYYMMDDHHMM].xlsx). All values are stored as text.
| # | Column | Content |
|---|---|---|
| 1 | Worker number | Worker number |
| 2 | Last name | Last name |
| 3 | First name | First name |
| 4 | Organizational cell | Organizational cell abbreviation |
| 5 | Phone number | Phone number or --- |
| 6 | Status | Pulse status: Not active, Pending, Active or Blocked |
| 7 | Push notifications | Whether push notifications are enabled |
| 8 | OS | Mobile app operating system (iOS, Android) |
| 9 | Version | Mobile app version |