You can export your measurements from LiLz Cloud as CSV or Excel files.
Exporting Measurements as CSV/Excel Files
1. Click the “Export” button in LiLz Cloud.
2. Select the period you want the file to cover, the format (CSV or Excel), and which gauges' data you want to include (all gauges or selected gauges).
3-1. If you select “Select inspection targets,” a list of registered inspection targets will be displayed.
3-2. Select the desired inspection targets from the list.
4. Click the “Export” button.
The export of measurement results is complete.
Content of the CSV/Excel Files
The data exported in CSV or Excel format is downloaded as a ZIP file.
The downloaded ZIP file may contain up to two files:
- File name: lilzgauge_yyyy-mm-dd-~
(Gauge reading data measured by LiLz Gauge) - File name: lilzguard_yyyy-mm-dd-~
(Anomaly detection data determined by the AI model of LiLz Guard)
Data Structure
Each file contains a combination of:
- Common basic information
- Additional information depending on the inspection type
Data is output in descending order by date and time.
- Common Fields (included in all files)
- Capture date and time
- Camera ID
- Camera display name
- Type-specific Fields
- LiLz Gauge data: Estimated value, Confirmed value, etc.
- LiLz Guard data: Score, Judgment result (Normal/Abnormal), etc.
| Note: If no data exists for the specified period, an empty file containing only the headers (column names) will be exported, with zero data records. |
Common
| datetime | Capture date and time |
| camera_id | Camera ID |
| camera_name | Camera display name |
LiLz Gauge
| gauge_id | Gauge ID |
| gauge_name | Gauge display name |
| measurement_id | Measurement setting ID |
| value | Measured value Displays either the estimated value or the confirmed value. If the estimated value has been edited, the confirmed value is shown; otherwise, the estimated value is shown. |
| predicted_value | Estimated value The value read by AI is displayed. |
| corrected_value | Confirmed value The edited value is displayed when the estimated value is incorrect. |
| is_confirmed | Inspection status Displays TRUE if the estimated value has been confirmed, and FALSE if not. |
| unit | unit |
LiLz Guard
| guard_id | Anomaly detection ID |
| guard_name | Anomaly detection display name |
| anomaly_score | Value of the anomaly score |
| is_anomaly_estimate | Estimated anomaly result Based on the AI model’s judgment, FALSE is displayed for normal, and TRUE for abnormal. |
| does_human_agree | Inspection status |