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?

Problem

3 Replies

Sort By
  • AshC's avatar
    AshC
    Retired GoTo Contributor
    4 years ago

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

  • swampyedwards's avatar
    swampyedwards
    New Contributor
    4 years ago

    Thanks, Ash

     

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

     

     

     

     

  • AshC's avatar
    AshC
    Retired GoTo Contributor
    4 years ago

    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.