Forum Discussion

swampyedwards's avatar
swampyedwards
New Contributor
4 years ago

csv import timezone incorrect

When importing incidents to G2A using a csv the timezone seems to be an hour out.

 

My account is set to London (GMT +0)

The service is set to London (GMT +0)

The csv file is generated in Google Sheets and the orig doc has the timezone as London.

The value in the csv is correct but I cannot see an adjustment for DST (BST).

 

Does the csv import expect UTC times?

  • AshC's avatar
    AshC
    Retired GoTo Contributor

    swampyedwards  It may be that we have not fully accounted for the British Summer Time adjustment.  For the time being, you may have to use the zone GMT +1 as a workaround.

    • swampyedwards's avatar
      swampyedwards
      New Contributor

      Thanks, Ash

       

      Have added a manual BST to UTC adjustment to create the CSV sheet for importing.

       

       

       

       

      • AshC's avatar
        AshC
        Retired GoTo Contributor

        swampyedwards  I will follow up with the team to make sure this gets addressed.