{"id":111174,"date":"2014-03-01T18:10:04","date_gmt":"2014-03-02T02:10:04","guid":{"rendered":"http:\/\/tri.be\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/"},"modified":"2014-04-11T15:33:18","modified_gmt":"2014-04-11T22:33:18","slug":"best-way-to-import-events-other-than-csv-importer","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/","title":{"rendered":"Best way to import events (other than CSV Importer)"},"content":{"rendered":"<p>Hi all,<\/p>\n<p>So I&#8217;m thinking that since I&#8217;m importing almost 3,000 events and the CSV Importer doesn&#8217;t allow me to import all the fields I need (Event Website url and a couple Additional Fields), my best option might be to have something custom built. <\/p>\n<p>I have all of my existing events data in a MySQL database, with it being in a handful of tables. My question is, if I&#8217;m going to hire a developer to build a custom import tool, is there a particular method that would work best given the structure of The Events Calendar and how the data is located in the WP database? Hopefully this all makes sense and sorry if there is only one way to custom import a database &#8211; I&#8217;m not familiar with any of that and just want to make sure I ask someone to built the right thing! Thanks for any advice!<\/p>\n<p>Sean<\/p>\n","protected":false},"template":"","class_list":["post-111174","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Best way to import events (other than CSV Importer) -<\/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\/best-way-to-import-events-other-than-csv-importer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Best way to import events (other than CSV Importer) -\" \/>\n<meta property=\"og:description\" content=\"Hi all, So I&#8217;m thinking that since I&#8217;m importing almost 3,000 events and the CSV Importer doesn&#8217;t allow me to import all the fields I need (Event Website url and a couple Additional Fields), my best option might be to have something custom built. I have all of my existing events data in a MySQL [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/\" \/>\n<meta property=\"article:modified_time\" content=\"2014-04-11T22:33:18+00:00\" \/>\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\/best-way-to-import-events-other-than-csv-importer\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/\",\"name\":\"Best way to import events (other than CSV Importer) -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2014-03-02T02:10:04+00:00\",\"dateModified\":\"2014-04-11T22:33:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/#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\":\"Best way to import events (other than CSV Importer)\"}]},{\"@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":"Best way to import events (other than CSV Importer) -","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\/best-way-to-import-events-other-than-csv-importer\/","og_locale":"en_US","og_type":"article","og_title":"Best way to import events (other than CSV Importer) -","og_description":"Hi all, So I&#8217;m thinking that since I&#8217;m importing almost 3,000 events and the CSV Importer doesn&#8217;t allow me to import all the fields I need (Event Website url and a couple Additional Fields), my best option might be to have something custom built. I have all of my existing events data in a MySQL [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/","article_modified_time":"2014-04-11T22:33:18+00:00","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\/best-way-to-import-events-other-than-csv-importer\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/","name":"Best way to import events (other than CSV Importer) -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2014-03-02T02:10:04+00:00","dateModified":"2014-04-11T22:33:18+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/best-way-to-import-events-other-than-csv-importer\/#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":"Best way to import events (other than CSV Importer)"}]},{"@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\/111174","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\/111174\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=111174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}