{"id":1501070,"date":"2018-04-09T16:38:14","date_gmt":"2018-04-09T23:38:14","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/"},"modified":"2018-04-09T16:38:14","modified_gmt":"2018-04-09T23:38:14","slug":"bulk-importing-editing-events","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/","title":{"rendered":"Bulk importing\/editing events"},"content":{"rendered":"

We have a programme of events of between 100 to 600 events ‘live’ at any one time across a year. We add, remove or edit these events at least once per week and at peak times several times per week. Whilst the events aggregator may offer the solution we need I’m not sure if it’s as effective\/simple to use as our current one (from the user point of view). <\/p>\n

We maintain the master data within our own internal CRM system built on SQL Server. We have a single ‘click’ facility that locally packages the records we have selected to show on the website, it contacts the remotely hosted SQL database linked to the remotely hosted website (same host), it sends the data which is then unpackaged into the remote SQL database which the website then accesses as and when requested. This is literally a one button click for the user as and when we want to and a 5-10 second wait before the new data is live on the website, whether this be a simple edit of a single spelling error, or marking and event as ‘cancelled’ or uploading a complete new set of 100 plus events. I.e. the data is ‘pushed’ to the website.<\/p>\n

Event Aggregator would seem to always need the data to have been repackaged into a csv or exported to another package in some way, before it is pulled in by various actions from within event calendar. Have I missed something. Can it be as simple as our current system? Can it be set up so that from the event calendar end it can automatically find a remotely hosted csv or similar file… or something else?<\/p>\n

Many thanks<\/p>\n","protected":false},"template":"","class_list":["post-1501070","topic","type-topic","status-closed","hentry"],"yoast_head":"\nBulk importing\/editing events -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bulk importing\/editing events -\" \/>\n<meta property=\"og:description\" content=\"We have a programme of events of between 100 to 600 events ‘live’ at any one time across a year. We add, remove or edit these events at least once per week and at peak times several times per week. Whilst the events aggregator may offer the solution we need I’m not sure if it’s […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/\",\"name\":\"Bulk importing\/editing events -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2018-04-09T23:38:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Welcome!\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Pre-Sales Questions\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Bulk importing\/editing events\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bulk importing\/editing events -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/","og_locale":"en_US","og_type":"article","og_title":"Bulk importing\/editing events -","og_description":"We have a programme of events of between 100 to 600 events ‘live’ at any one time across a year. We add, remove or edit these events at least once per week and at peak times several times per week. Whilst the events aggregator may offer the solution we need I’m not sure if it’s […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/","name":"Bulk importing\/editing events -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2018-04-09T23:38:14+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/bulk-importing-editing-events\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Welcome!","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/"},{"@type":"ListItem","position":4,"name":"Pre-Sales Questions","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/"},{"@type":"ListItem","position":5,"name":"Bulk importing\/editing events"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1501070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1501070\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1501070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}