The GoTo Community is currently experiencing some technical issues affecting new posts and comments. We are actively working with our service provider and apologize for the frustration.

Forum Discussion

swampyedwards's avatar
swampyedwards
New Contributor
5 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

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

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

  • swampyedwards's avatar
    swampyedwards
    New Contributor
    5 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
    5 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.