X
177546

Ticket #177546 Public

Sync with Google Sheets

  • Currently I have a bunch of agents who each have a google sheet. I then have these ggoel sheets compile into one sheet. This sheet is formatted for the CSV upload. I have 2 questions

    1)Is there a way to auto sync Google Sheet with Eventon
    2) Is there a way to auto sync that brings down the event id from assigned to events after sheet is uploaded ( incase a event is updated on the sheet, we wouldnt want to create a new event just uipdate the one uploaded previously)

    BY: timothy cermak - May 21,2020 AT 7:53AM - 4 months ago
    • By: Artem May 21,2020 AT 1:47PM - Posted 4 months ago - #177612

      Hello,

      1. CSV Importer allows you to import .csv files. Unfortunately, it doesn’t allow you to import them automatically, only manually.

      2. CSV Importer allows you to do this:

      event_id (int) – Event post ID, if passed, event with this id will be updated with meta data

      Try on http://dev.myeventon.com/wp-admin/

    • By: timothy cermak May 26,2020 AT 8:59AM - Posted 4 months ago - #178287

      Doesnt answer my questrion at all

      Thanks

      Its there a way the CSV export doesnt have a bunch of gobble gook in the cells?

       

      I keep getting things liker

      My Main $%#^*%#* Event

    • By: Artem May 26,2020 AT 12:31PM - Posted 4 months ago - #178326

      You can export Google Sheets in different formats. For example, CSV: https://www.solveyourtech.com/save-csv-google-sheets/

      After you exported it, you can import it with CSV Import (if file’s format is correct). The problem is that it doesn’t allow you to do this automatically, only manually.

      Please let us know if you still have questions on this topic.

      Its there a way the CSV export doesnt have a bunch of gobble gook in the cells?

      Please check Google’s documentation on how to export data to files.

    • By: timothy cermak May 26,2020 AT 12:48PM - Posted 4 months ago - #178329

      Imm talking about Eventon’s Export having a bunch of characters and gobbly gook, not Google

       

       

    • By: Artem May 26,2020 AT 12:54PM - Posted 4 months ago - #178334

      Could you send us a link to the exported file so we can check it?

You must login to reply to this ticket

HelpDesk

Welcome to EventON helpdesk.

EventON is the #1 Best selling event calendar plugin for WordPress websites in envato marketplace.

Checkout EventON