Title: Locations Data Import
Last modified: March 10, 2019

---

# Locations Data Import

 *  Resolved [SteveHale](https://wordpress.org/support/users/stevehale/)
 * (@stevehale)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/locations-data-import/)
 * Hi All
 * I have imported all the locations that my customers events are taking place directly
   into the correct mySql table in the database.
 * However the locations do not show in Event Manager.
 * How do I get them to show?
 * Cheers
 * Steve B

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * (@angelo_nwl)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/locations-data-import/#post-11311294)
 * hi,
 * since EM is using custom post types; your imported locations should exists to
   both tables wp_em_locations and wp_posts, postmeta
 * maybe this snippet can help you get started -> [https://pastebin.com/3UDjZ8Le](https://pastebin.com/3UDjZ8Le)
 *  Thread Starter [SteveHale](https://wordpress.org/support/users/stevehale/)
 * (@stevehale)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/locations-data-import/#post-11312177)
 * There is no wp_posts table in the database…..
 * Any other ideas??
 * Cheers
 * Steve B
 *  [timrv](https://wordpress.org/support/users/timrv/)
 * (@timrv)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/locations-data-import/#post-11314533)
 * Hello,
 * There should be a “*_posts” table on your Database. It’s a core WordPress table
   where they store all the contents like pages, Post. Here is a screenshot of the
   table: [https://monosnap.com/file/UwYNsyZZN6fKJr8UY3lztHU9RSuYvi](https://monosnap.com/file/UwYNsyZZN6fKJr8UY3lztHU9RSuYvi)
 *  Thread Starter [SteveHale](https://wordpress.org/support/users/stevehale/)
 * (@stevehale)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/locations-data-import/#post-11315411)
 * Ah yes. I found the tables noe on a “page 2”.
 * As there are 422 pages how on earth I find the entries is beyond me!!
 * Steve B
 *  Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * (@angelo_nwl)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/locations-data-import/#post-11341916)
 * under events table you can cross matched post_id and under wp_posts you can filter
   by post type eg. event, location

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Locations Data Import’ is closed to new replies.

 * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=1039078)
 * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * Last activity: [7 years, 1 month ago](https://wordpress.org/support/topic/locations-data-import/#post-11341916)
 * Status: resolved