The Work Record list can be exported in Excel format or CSV format.
The content of each export differs, so please choose according to your needs.
Excel Format
- Exports one month of Work Records in a calendar layout.
- Includes the daily status, Daily Verification and Daily Verification personnel, and Monthly Verification personnel confirmation status.
- For each Check Item, includes the result, numeric value, and the person who performed it.
- For Work Records corrected in the admin screen, the corrected content will be exported.
The name of the administrator who made the correction will appear in the performer column.
CSV Format
- Exports one row per Check Item.
Suitable for aggregation or importing into other systems. - Includes fields such as: target date, Check File name, Check Sheet Display Name, Check Item name, When To Do, cycle, Work Result, Require Image, Require Number, supplementary work, work performer, Note count, Ticket count, Updated at, URL, and more.
- "URL" is the URL to open the Work Record for that item in the admin screen.
By filtering by "Ticket count" or "Note count" and opening the Work Record via the URL, you can review the contents of Tickets and Notes. - Corrected content is not exported.
The content as submitted by the worker will be exported. - Work Results other than OK or NG will appear as "-", and "Skipped" and blank entries are not distinguished.
- Work Records that have not yet been submitted are also included.
In either format, the at and Reason for Correction are not exported.
How to Use
Export the Work Record list in Excel or CSV format (admin screen)
https://teachme.jp/8/manuals/35914890
Related
What are the conditions for correcting a submitted Work Record?
https://help.check.teachme.jp/hc/en-us/articles/63287580652185