{"id":1176346,"date":"2016-10-13T17:26:31","date_gmt":"2016-10-14T00:26:31","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/"},"modified":"2016-10-13T17:26:31","modified_gmt":"2016-10-14T00:26:31","slug":"aggregator-how-are-changed-events-determined","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/","title":{"rendered":"Aggregator – How are changed events determined?"},"content":{"rendered":"

I’m looking to use Aggregator to schedule recurring imports from CSV files.<\/p>\n

I have three CSV files Events.csv, Venues.csv, and Organizers.csv each have about 400 rows.<\/p>\n

Those files will get updated nightly with the new batch of events, venues, and organizers. Most of them will be the same, but some events will be gone (cancelled) or others moved (from one date to another).<\/p>\n

Is there a unique key that Aggregator uses to tell if an event has changed?
\nIs it the Event Name, Venue Name, Organizer Name respectively?
\nCan I change that to be a different field (such as an ID field I would add through Pro)?<\/p>\n

Also not sure how to handle events that are gone from the list to have them automatically deleted.<\/p>\n

Thanks for any help!
\nRodrigo<\/p>\n","protected":false},"template":"","class_list":["post-1176346","topic","type-topic","status-closed","hentry"],"yoast_head":"\nAggregator - How are changed events determined? -<\/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\/aggregator-how-are-changed-events-determined\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Aggregator - How are changed events determined? -\" \/>\n<meta property=\"og:description\" content=\"I’m looking to use Aggregator to schedule recurring imports from CSV files. I have three CSV files Events.csv, Venues.csv, and Organizers.csv each have about 400 rows. Those files will get updated nightly with the new batch of events, venues, and organizers. Most of them will be the same, but some events will be gone (cancelled) […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/\" \/>\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\/aggregator-how-are-changed-events-determined\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/\",\"name\":\"Aggregator - How are changed events determined? -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-10-14T00:26:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/#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\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Aggregator – How are changed events determined?\"}]},{\"@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":"Aggregator - How are changed events determined? -","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\/aggregator-how-are-changed-events-determined\/","og_locale":"en_US","og_type":"article","og_title":"Aggregator - How are changed events determined? -","og_description":"I’m looking to use Aggregator to schedule recurring imports from CSV files. I have three CSV files Events.csv, Venues.csv, and Organizers.csv each have about 400 rows. Those files will get updated nightly with the new batch of events, venues, and organizers. Most of them will be the same, but some events will be gone (cancelled) […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/","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\/aggregator-how-are-changed-events-determined\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/","name":"Aggregator - How are changed events determined? -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-10-14T00:26:31+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/aggregator-how-are-changed-events-determined\/#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":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Aggregator – How are changed events determined?"}]},{"@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\/1176346","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\/1176346\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1176346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}