Arduino Cloud Historic Data CSV Excel Sheet

from: 2024-11-20T00:00:00Z
to: 2024-11-27T23:59:59Z

I have encountered a time discrepancy issue between the Cloud Variables and the timeline recorded in the CSV file. Even though I have configured the timezone in the metadata as "Asia/Seoul," the times are not aligning as expected.

I have attached four screenshots to demonstrate the issue:

  1. Screenshot of the CSV file and folder structure.
  2. Screenshot of the variable details for cc_air_temp_f.
  3. Overview of Cloud Variables and their timestamps.
  4. Metadata settings showing the configured timezone.

Could you please assist in identifying and resolving this discrepancy?

Hi!
CSV file exported via mail contains samples at UTC timezone. You can see in the TS format picture (the Z at the end of the timestamp).

Regards

I would like to request assistance with displaying the timestamps in the downloaded CSV file in Korean Standard Time (KST, UTC+9). Currently, the timestamps in the CSV file appear to be in UTC, and I would like them to be converted to KST for better alignment with my local time.

Could you please let me know if there is a way to configure this, or if there are any additional steps I should take to ensure that the timestamps in the CSV file are displayed in KST?

As of now, it is not possible to configure exporter to match a specific timezone.
You can parse CSV files with a script.
Here is a sample Python script that modify CSV files adapting TZ to Asia/Tokyo timezone.
In the zip file, you will find installation instructions.

tz-converter.zip (3,1 KB)

Regards

Hello,

Thank you for providing the script and instructions for converting timezones in CSV files. While this is a helpful workaround, it would be even more convenient if the Exporter itself included a feature to configure and adapt to specific timezones directly.

Such a feature would save time and streamline the workflow, making it easier to handle data in various timezones without additional processing steps.

I hope this functionality can be considered for future updates. Thank you again for the support and solution provided.

Best regards,