Go to cioplenu
All Collections
Reports
Export of .xlsx and .csv Reports

Export of .xlsx and .csv Reports

Data export via .csv or .xlsx allows you to analyse further data. We show you which data you get and where they come from.
Rafael Koch avatar
Written by Rafael Koch
Updated over a week ago

How to export a .xlsx and .csv Report

To export a report, got to the Reports section in the editor.

Reports Icon Section

.xlsx and .csv Reports can be exported at any state, no matter they are completed or still in progress. Open a report and click to the cloud icon in the upper right screen area.

Download a report

Select the desired report. To get all data use the general .csv Report / general .xlsx Report.

What data do you get

You will get a break down table with all data from one report. Each row represents one step, one process step or one interaction.

This allows you to filter and post-process the table via a pivot table, PowerPivot or Power-BI.

Please contact our Customer Success Team for further questions and best practise regarding post-processing topics via [email protected] or the chat.

Column name

Data description

progressId

ID for the report for example 1876

progressState

State of the report for example paused

progressPassed

Status of the report e.g. passed if there was no interaction failing

stepId

ID e.g. 2 of the step within the report

stepName

Name of the step e.g. Stator Mounting

stepTimestamp

Time and date in UTC on which the step was opened the first time e.g. 2020-10-23T17:21:29.305Z

stepUpdatedBy

ID of the user opened or actioned in the step e.g. 18

stepUpdatedByUserName

Name of the user opened or actioned in the step e.g. Marco Maintenance

stepOpenedAt

Time and date in UTC on which the step was opened the first time e.g. 2020-10-23T17:21:35.305Z

rowId

ID e.g. 92832 of the process step within the Report

rowHeader

Name of the process step

interactionId

ID e.g. 16832 of the interaction within a process step within the Report

interactionVersionPersistentId

ID e.g. 9714 of the interaction within a process step within the report which is unique over all reports and its versions

interactionType

Type of interaction e.g. number for number feedback

interactionKey

Name of interaction e.g. metering point 123

interactionValueId

ID e.g. 253778 of the entered value for this interaction within the platform

interactionValue

Entered value e.g. by user for this interaction e.g. 12382138 for a serial number entered

interactionValuePassed

Status of the interaction e.g. passed if the interaction value was correct

interactionValueUpdatedAt

Time and date in UTC on which the value was updated last time e.g. 2020-10-23T18:19:35.305Z

interactionValueUpdatedBy

ID of the user entered the value latest e.g. 18

interactionValueUpdatedByUserName

Name of the user entered the value latest e.g. Marco Maintenance

interactionComment

Comment of the user to an interaction

interactionNotApplicable

Set to true if the checkbox N/A for an interaction was set by the user

interactionNominalValue

Nominal value (target value) set for the number feedback e.g. 18.98

interactionCheckDeviation

State of the Report for example 1876

interactionToleranceUp

Upper limit for the absolute tolerances set in the number feedback e.g. 0.2

interactionToleranceDown

Lower limit for the absolute tolerances set in the number feedback e.g. 0.2

interactionCaptureMode

Indicator and ID of the video, image or signature feedback for this interaction

interactionToleranceType

Type of tolerance deviation measurement set for the number interaction e.g. relative-percentage

interactionTagIds

ID of the interaction tag e.g. 32

interactionTagNames

Name of the tag e.g. S/N Material 832/A/26

Did this answer your question?