Database Export

  • Resolved rachelove

    (@rachelove)


    7 years, 8 months ago

    Hi there, how might I export placemark points? Or please point me to the db table they exist in, having trouble finding them 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Nagmay

    (@gabrielmcgovern)

    7 years, 8 months ago

    Placemarks are a custom post type that utilize a bunch of metadata.

    To export you could:

    • Get the ID from wp_posts
    • Get the data from wp_postmeta where post_id=ID

    Each meta_key starts with “placemarks-“. For instance “placemarks-lat”.

    Plugin Author Nagmay

    (@gabrielmcgovern)

    7 years, 8 months ago

    Or… I just realized that you can use the default WordPress exporter.
    Tools > Export and choose placemarks.

    This will spit out XML like:

    
...
	        <wp:postmeta>
			<wp:meta_key><![CDATA[placemarks-lat]]></wp:meta_key>
			<wp:meta_value><![CDATA[45.43715546770171]]></wp:meta_value>
		</wp:postmeta>
		<wp:postmeta>
			<wp:meta_key><![CDATA[placemarks-lng]]></wp:meta_key>
			<wp:meta_value><![CDATA[-122.73131936789241]]></wp:meta_value>
		</wp:postmeta>
    Thread Starter rachelove

    (@rachelove)

    7 years, 8 months ago

    Sweet! Thx for your help 🙂

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

The topic ‘Database Export’ is closed to new replies.