{"id":1178,"date":"2019-07-10T15:41:43","date_gmt":"2019-07-10T15:41:43","guid":{"rendered":"https:\/\/webnus.site\/dox\/?p=1178"},"modified":"2023-10-31T10:42:28","modified_gmt":"2023-10-31T10:42:28","slug":"importing-events-via-sql","status":"publish","type":"knowledgebase","link":"https:\/\/webnus.net\/dox\/modern-events-calendar\/importing-events-via-sql\/","title":{"rendered":"Importing Events via SQL"},"content":{"rendered":"\n

\u00a0Importing Events via SQL in the Modern Events Calendar<\/a> can be done via the following method.<\/p>\n\n\n\n

<\/span>Manually Importing Events via SQL<\/span><\/h2>\n\n\n\n

The first method for importing events to Modern Events Calendar is to use the option in the plugin.<\/p>\n\n\n\n

In this method, you can simply go to the MEC dashboard> Import \/ Export<\/strong> section get the XML output, and then put the action below in the functions.php:<\/p>\n\n\n

\ndo_action ('mec_import_file', XML_PATH);\n<\/pre><\/div>\n\n\n
For the second method which will be done via SQL, note that MEC events are created using WP post type<\/strong> + a record in [wp_prefix]_mec_events<\/strong> table so you should import both, otherwise, the event is incomplete and it won\u2019t be shown on the front-end of the website.<\/p>\n\n\n\n
For importing the post types, you can simply use the solution that you use for other post types such as posts, pages, etc.<\/p>\n\n\n\n
For the mec_events<\/strong> records, we suggest creating a SQL export file<\/strong> from your mec_events<\/strong> table on your demo website and then write a simple PHP code to run the .sql<\/strong> file queries into the client website.<\/p>\n\n\n\n
You can use codes like this:<\/p>\n\n\n
\n$query_file = '\/path\/to\/mec_events.sql';\n$queries = file_get_contents($query_file);\n$sqls = explode(';', $queries);\n\/\/ WordPress DB\nglobal $wpdb;\nforeach($sqls as $sql)\n{\n    $sql = trim($sql, '; ');\n    if(trim($sql) == '') continue;\n\n    $sql .= ';';\n\n    $wpdb->query($sql);\n}\n<\/pre><\/div>\n\n\n
<\/span>Key Considerations While Importing Events to MEC<\/span><\/h3>\n\n\n\n
You should be careful about the WP table prefix<\/strong>.<\/p>\n\n\n\n
We suggest changing the prefix in the SQL file to something unique.<\/p>\n\n\n\n
For example, change the INSERT INTO wp_mec_events to INSERT INTO #__mec_events in the SQL file and replace #__ with $wpdb-> prefix before calling the query.<\/p>\n\n\n\n
Another way is to assign the queries to a PHP variable and then run it by $wpdb->query() function.<\/p>\n\n\n\n
Something like this:<\/p>\n\n\n
\nglobal $wpdb;\n$query = "INSERT INTO ".$wpdb->prefix."mec_events ......";\n$wpdb->query($sql);\n<\/pre><\/div>\n\n\n
Note:<\/strong> The post_id<\/strong> column of the mec_events<\/strong> table should match the Post ID of the event otherwise they won\u2019t link together.
 <\/p>\n","protected":false},"excerpt":{"rendered":"
You can import your events to MEC in two ways: The first method is to use the option in the plugin. In this method, you can simply go to the MEC dashboard> Import \/ Export<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","knowledgebase_cat":[50],"class_list":["post-1178","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-developer-other"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/knowledgebase\/1178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/comments?post=1178"}],"version-history":[{"count":3,"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/knowledgebase\/1178\/revisions"}],"predecessor-version":[{"id":9799,"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/knowledgebase\/1178\/revisions\/9799"}],"wp:attachment":[{"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/media?parent=1178"}],"wp:term":[{"taxonomy":"knowledgebase_cat","embeddable":true,"href":"https:\/\/webnus.net\/dox\/modern-events-calendar\/wp-json\/wp\/v2\/knowledgebase_cat?post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}