{"id":72,"date":"2007-08-02T23:14:52","date_gmt":"2007-08-02T23:14:52","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?p=72"},"modified":"2023-01-16T09:05:46","modified_gmt":"2023-01-16T09:05:46","slug":"csexport-how-did-i-never-find-it-before","status":"publish","type":"post","link":"https:\/\/www.wapshere.com\/missmiis\/csexport-how-did-i-never-find-it-before","title":{"rendered":"csexport &#8211; How did I never find it before?"},"content":{"rendered":"<p>You can even learn about MIIS while on vacatio!.<\/p>\n<p>I was skimming through my <a title=\"MMSUG\" href=\"http:\/\/tech.groups.yahoo.com\/group\/MMSUG\/\" target=\"_blank\" rel=\"noopener noreferrer\">MMSUG<\/a> digest this morning when I read <a href=\"http:\/\/www.microsoftidm.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Joe Stepongzi&#8217;<\/a>s answer to someone about finding transient objects in the connector space by using csexport.<\/p>\n<p>I jumped onto my virtual server to give csexport a go, and it looks like a mighty useful tool. It made me wonder why I&#8217;d been <a href=\"https:\/\/www.wapshere.com\/missmiis\/?p=36\">messing around with SQL queries<\/a> to list disconnectors and pending exports.<\/p>\n<p>If anyone else out there has been unobservant enough (or hasn&#8217;t stumbled across the right help files) to find csexport, it&#8217;s in the bin folder, and it has a range of filter options which allow you to export just the object types you&#8217;re interested in (such as disconnectors).<\/p>\n<p>After trying a couple of exports I figured there&#8217;s probably room for both methods. It may just be my virtual server, but csexport seems slower than the equivalent SQL query. It also returns all information about the object, which I don&#8217;t always want. I think it&#8217;s nice to be able to understand the structure of the underlying SQL database, but really I&#8217;m just trying to find excuses for myself. In future I&#8217;ll be telling people to use csexport|<\/p>\n<p>Thanks Joe.<\/p>\n<blockquote><p>Addendum to this: I think there is still a good reason to get to grips with querying the MIIS database &#8211; sometimes you want to get a list of metaverse objects which don&#8217;t have a corresponding CS object. You can&#8217;t get this info from querying the connector space.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>You can even learn about MIIS while on vacatio!. I was skimming through my MMSUG digest this morning when I read Joe Stepongzi&#8217;s answer to someone about finding transient objects in the connector space by using csexport. I jumped onto my virtual server to give csexport a go, and it looks like a mighty useful&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":[]},"categories":[34,28],"tags":[],"class_list":["post-72","post","type-post","status-publish","format-standard","hentry","category-ilm2007","category-miis2003"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pkp1o-1a","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=72"}],"version-history":[{"count":3,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/72\/revisions"}],"predecessor-version":[{"id":3378,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/72\/revisions\/3378"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=72"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/categories?post=72"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/tags?post=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}