40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Edit timezone offset for Business Hours

This topic contains 6 replies, has 2 voices, and was last updated by  Foster 4 years, 3 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: , , ,

  • Author
    Posts
  • January 27, 2020 at 7:51 pm #527560

    Foster
    Full Member
    Post count: 164

    I have recently begun importing Business Hours with Social Importer.
    I did not know a Google Geocoding API Key was required but I have just entered one.
    Is there a way to correct the offset on all the recent venues without going in to edit each listing manually?

    January 27, 2020 at 7:58 pm #527566

    Alex Rollin
    Moderator
    Post count: 27815

    You can certainly bulk export, edit and import

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/

    January 27, 2020 at 8:05 pm #527567

    Foster
    Full Member
    Post count: 164

    My directory spans 4 timezones and there’s about 300 listings to fix.
    I don’t think exporting & importing will make it any easier.
    Some sort of tool would be nice, though.

    Thanks

    January 27, 2020 at 9:32 pm #527588

    Alex Rollin
    Moderator
    Post count: 27815

    Well, you can ‘fill down’ pretty easily if you sort them by state.

    January 28, 2020 at 3:17 pm #527727

    Foster
    Full Member
    Post count: 164

    I went ahead and did it manually because I get a little nervous messing with tables. I have used OpenOffice and Google Sheets before to edit tables. Is there a better way or software to use?

    January 28, 2020 at 4:34 pm #527745

    Alex Rollin
    Moderator
    Post count: 27815

    Export/Import for CSVs should only be edited with Open or Libre Office.

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/

    January 28, 2020 at 4:37 pm #527746

    Foster
    Full Member
    Post count: 164

    OK, Thanks
    “Other editors leave artifacts in saved files that make them unreadable.” Explains some issues I had before.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket