Skip to content
Technical documentationXLSX export data scope

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:

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:

  1. If the file is ready within the time limit (20 seconds by default), it is downloaded by the browser immediately.
  2. 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.
  3. If e-mail delivery to the user’s address is paused, the file is not sent and an appropriate message is displayed.
  4. 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).

ViewAddressScope
Default/action_plans.xlsxUnfinished plans, excluding parent plans that contain nested plans
All ongoing/action_plans/all_ongoing.xlsxAll unfinished plans (including parent plans)
All/action_plans/all.xlsxAll accessible plans, including finished ones
My/action_plans/my.xlsxUnfinished plans owned by the user
Overdue/action_plans/overdue.xlsxUnfinished plans past their due date

The table starts at cell B2 (the first row and first column are empty).

#ColumnContent
1NumberPlan number (hyperlink to the plan)
2SubjectPlan subject
3Problem descriptionPlan description
4TagsList of tags
…Global parametersOne column for each active parameter
5CreatorPlan author
6OwnerPlan owner
7OrgcellFull name of the organizational cell
8Start dateStart date
9Due datePlanned end date
10Real end dateActual end date
11Work progressCompletion percentage
12Time progressElapsed time percentage
13Source plan numberNumber 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

ViewAddressScope
Default/audit_plans.xlsxUnfinished audits, excluding audits with the Planned status
My/audit_plans/my.xlsxUnfinished audits where the user is the auditor, excluding Planned audits
All/audit_plans/all.xlsxAll 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.

#ColumnContent
1NumberAudit number (hyperlink to the audit)
2SubjectAudit subject
3DescriptionAudit description
4TagsList of tags
…Global parametersOne column for each active parameter
5AuditorPerson assigned to the audit
6OrgcellFull name of the organizational cell
7TypeAudit type
8Audited areaAudit area
9LayerAudit layer (layered audits)
10StatusAudit status
11Unexecution reasonReason, if the audit was marked as unexecuted
12ScoreAudit result; with an alternative score scale in the format alternative score (main score)
13Start datePlanned start date
14Due datePlanned end date
15Real end dateActual end date
16Work progressCompletion percentage
17Time progressElapsed time percentage
18Real audit startActual start date and time
19Real audit endActual end date and time
20Real audit durationDuration 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.

ViewAddressScope
Relevant activities/activities.xlsxUnfinished activities in active plans
Activities to do/activities/todo.xlsxThe user’s activities waiting to be done
Activities to accept/activities/toaccept.xlsxCompleted activities waiting for the user’s acceptance
My activities/activities/my.xlsxUnfinished activities related to the user
Overdue activities/activities/overdue.xlsxUnfinished activities past their due date
All activities/activities/all.xlsxAll accessible activities, including finished ones

The table starts at cell A2 (the first row is empty).

#ColumnContent
1Record numberActivity number
2SubjectActivity subject
3DescriptionActivity description
4ResolutionResolution entered during execution
5AssigneePerson responsible for the activity
6AreaAudit area related to the plan (applies to corrective plans created from audits)
7Work progressCompletion percentage
8Time progressElapsed time percentage
9Start dateStart date
10Due datePlanned end date
11End dateActual end date
12Prio.Priority
13StateActivity 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

ViewAddressScope
Default/idea_plans.xlsxUnfinished submissions
My/idea_plans/my.xlsxUnfinished submissions owned by the user
All/idea_plans/all.xlsxAll accessible submissions, including finished ones

The table starts at cell B2.

#ColumnContent
1NumberSubmission number (hyperlink to the submission)
2SubjectSubmission subject
3Submission descriptionSubmission description
4ResolutionResolution description
5Effect of the changeDescription of benefits
6TagsList of tags
…Global parametersOne column for each active parameter
7CreatorAuthor of the submission in the system
8OwnerSubmission owner
9OrgcellFull name of the organizational cell
10RegardsOrganizational cell the submission concerns
11SubmitterPerson who submitted the idea (last name and first name)
12StageSubmission stage
13Total pointsTotal points from ratings
14Total effective pointsTotal effective points
15Points thresholdSubmission points threshold
16Rejection reasonRejection reason (if applicable)
17DecisionDecision description
18Start dateStart date
19Due datePlanned end date
20Real end dateActual end date
21Work progressCompletion percentage
22Time progressElapsed 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.

ViewAddressScope
Default/adm/users.xlsxNon-archived users
Archived/adm/users/archived.xlsxArchived users only
All/adm/users/all.xlsxAll users

The first row of the sheet contains a title with a hyperlink to the platform; table headers are in row 2.

#ColumnContent
1Last nameUser’s last name and first name
2Organizational cellName of the organizational cell
3PositionPosition
4EmailE-mail address
5LoginUsername
6RolesComma-separated list of roles (e.g. Administrator, Audit Manager)
7Is restricted?Boolean value (TRUE/FALSE)
8Report frequencyNo reports, Less frequent reports or More frequent reports
9StatusActive, 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.

#ColumnContent
1Worker numberWorker number
2Last nameLast name
3First nameFirst name
4Organizational cellOrganizational cell abbreviation
5StatusActive or Archived
6RemarksRemarks

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.

#ColumnContent
1Worker numberWorker number
2Last nameLast name
3First nameFirst name
4Organizational cellOrganizational cell abbreviation
5Phone numberPhone number or ---
6StatusPulse status: Not active, Pending, Active or Blocked
7Push notificationsWhether push notifications are enabled
8OSMobile app operating system (iOS, Android)
9VersionMobile app version