Export item data values
Learn how to select items and a time range, export stored values to CSV, understand the file layout and browser time zone, and resolve export errors.
Use Export data values to download stored values and timestamps from one or more items in an instance. You can choose the items and limit the export to a specific time range.
This export contains data values. It does not contain item configuration, instance settings, or mappings.
Before you begin
- Open an instance that contains at least one item.
- Confirm that the selected items have collected data.
- Use Logging mode when you need a history of every collected value.
- Check the configured retention period and maximum sample count. Values removed by retention cannot be exported.
Gateway mode keeps the latest item value. Logging mode retains collected values according to the instance and item storage settings.
Open Export data values
- In the sidebar, expand Instances.
- Open All instances or the relevant instance category.
- Open the instance containing the data.
- Open its items view.
- Select Export data values.
The Export data dialog lists the available items alphabetically. Each item is selected independently.
Select items to export
- Select an item name to include it.
- Select additional item names when the file should contain more than one item.
- Check the selected counter to confirm how many items are included.
Use Select all to include every item in the instance. Use Clear to remove the complete selection.
You must select at least one item before the export can start.
Choose the time range
The export dialog provides From and To date and time fields.
| Selection | Values included |
|---|---|
| Both fields completed | Available values between the selected start and end date and time. |
| From cleared | All available retained values up to the selected To time. |
| To cleared | All available retained values from the selected From time onwards. |
| Both fields cleared | All retained values available for the selected items. |
The default range covers the previous seven 24-hour periods ending at the current time.
The selected times use the browser's local time zone. The active browser time zone and UTC offset are displayed in the dialog. Changing the gateway time zone does not change the browser time zone used by the date and time fields.
From must be earlier than or equal to To. If you move From past the current end time, the Edge Portal moves To to the same value.
Export the CSV file
- Select the required items.
- Set or clear From and To.
- Review the displayed browser time zone.
- Select Export CSV.
- Wait while the button displays Exporting....
- Confirm that Data values exported successfully. appears.
- Open the downloaded CSV file and verify the selected items and time range.
The file uses the instance name followed by .csv. Characters that are not valid in filenames are removed or replaced.
Understand the CSV layout
When the Edge Portal generates the CSV from an API data response, it uses a comma-separated UTF-8 file.
| Row | Content |
|---|---|
| First row | The selected item names. Each item uses a pair of columns. |
| Second row | Value and Time below each item name. |
| Remaining rows | The exported values and their formatted timestamps. |
Each item has its own value series. Rows are aligned by the position of each value in that series, not by matching timestamps between items. If one item contains fewer values than another, its remaining cells are empty.
Timestamps are formatted using the browser's locale and time zone. Null values become empty cells. Text, numeric, and Boolean values are written directly. Structured values are written as JSON text.
If the backend returns a ready-made file instead of a data response, the Edge Portal downloads that file directly.
Understand what affects the result
| Condition | Effect on the export |
|---|---|
| Instance or item uses Gateway mode | Only the latest retained value may be available. |
| Instance or item uses Logging mode | Collected values are available until they are removed by the configured age or sample-count limit. |
| Item was offline | The selected period can contain gaps or no values. |
| Selected period is outside retention | Older values are no longer available and are not included. |
| Items have different collection intervals | The series can contain different numbers of rows. |
| Browser time zone differs from gateway time zone | The dialog and portal-generated CSV timestamps follow the browser time zone. |
Verify the exported values
- Confirm that the file contains a pair of columns for every selected item.
- Check the first and last timestamp for each item.
- Confirm that the timestamps match the browser time zone shown during export.
- Compare several values with the latest values shown in the Edge Portal.
- Check for empty sections caused by offline periods or different collection intervals.
Troubleshoot data export
| Message or condition | What to do |
|---|---|
| No items are available for export yet. | Create items in the instance, then refresh the item list. |
| This instance is missing export context. Refresh the page and try again. | Reload the instance and wait for its Connector and instance information to load. |
| Select at least one item to export. | Select one or more item names, or use Select all. |
| Choose at least one item to export. | The API request did not contain an item. Reopen the dialog, select an item, and try again. |
| Enter a valid From date and time or clear the field. | Correct the start value or clear it for an open-ended start. |
| Enter a valid To date and time or clear the field. | Correct the end value or clear it for an open-ended end. |
| The From date/time must be earlier than or equal to the To date/time. | Move the start earlier or the end later. |
| No data values were found for the selected items and time range. | Widen the range, clear one or both date fields, and confirm that the items collected values during the period. Check Logging mode and retention settings if history was expected. |
| The export response format is not supported. | Reload the page and retry. If the message returns, check that the Edge Portal and API versions are compatible. |
| Failed to export data values. or Failed to export data values. Please try again. | Read any more specific API message, check the gateway connection, and retry with fewer items or a shorter range. |
| The success message appears but no file is visible | Check the browser download list and download permissions, then export again. |
| The timestamps appear shifted | Compare them with the browser time zone displayed in the export dialog. Change the computer's time zone if the export must use another local zone. |
| The file contains fewer values than expected | Check the selected range, item status, collection interval, Logging mode, Store Time, and Max Samples To Store. |