Hi, I have been trying to export my blog entries using the regular blog export tool, but it times out after exporting about 200 entries. I created an export template and published that instead, which is great, except that it left out all drafts. How can I export my drafts?
Here's the template I published, and am wondering what I need to add here to get the drafts included (I put the lastn as 600 because I have less than that on my blog but wanted to make sure all were included):
<MTEntries lastn="600"> AUTHOR: <$MTEntryAuthor strip_linefeeds="1"$> TITLE: <$MTEntryTitle strip_linefeeds="1"$> BASENAME: <$MTEntryBasename$> STATUS: <$MTEntryStatus strip_linefeeds="1"$> ALLOW COMMENTS: <$MTEntryFlag flag="allow_comments"$> CONVERT BREAKS: <$MTEntryFlag flag="convert_breaks"$> ALLOW PINGS: <$MTEntryFlag flag="allow_pings"$> <MTIfNonEmpty tag="MTEntryCategory">PRIMARY CATEGORY: <$MTEntryCategory$> </MTIfNonEmpty><MTEntryCategories> CATEGORY: <$MTCategoryLabel$> </MTEntryCategories> DATE: <$MTEntryDate format="%m/%d/%Y %I:%M:%S %p"$> ----- BODY: <$MTEntryBody convert_breaks="0"$> ----- EXTENDED BODY: <$MTEntryMore convert_breaks="0"$> ----- EXCERPT: <$MTEntryExcerpt no_generate="1" convert_breaks="0"$> ----- KEYWORDS: <$MTEntryKeywords$> ----- <MTComments> COMMENT: AUTHOR: <$MTCommentAuthor strip_linefeeds="1"$> EMAIL: <$MTCommentEmail strip_linefeeds="1"$> IP: <$MTCommentIP strip_linefeeds="1"$> URL: <$MTCommentURL strip_linefeeds="1"$> DATE: <$MTCommentDate format="%m/%d/%Y %I:%M:%S %p"$> <$MTCommentBody convert_breaks="0"$> ----- </MTComments> -------- </MTEntries>
Thanks!
Reported on Movable Type 4.3

A way to export your draft posts is to use the Brad's SQL plugin available at:
http://plugins.movabletype.org/sql/
Kind Regards,
Mihai Bocsaru
----------------------------------
Daily Movable Type Consultant
Web Development
Movable Type Consulting
Six Apart Partner
http://www.pro-it-service.com/
----------------------------------
Movable Type Demo
http://www.movabletypedemo.org/
----------------------------------
Open Melody Demo
http://www.openmelodydemo.org/
Thank you Mihai, that is helpful and I took a look at it - but it is a little over my understanding, and would probably take me several hours to figure out how to use it properly.
Does anyone have any examples of how to use this as an export template? Or perhaps hints about why the MT export tool only exports the first 200 entries and how to change that?
Thanks!
Amy
Hi Amy,
In order to export also the draft posts, you could use the following coding to surround your export template:
<mt:SQLEntries query="select entry_id from mt_entry">
...your export template here...
</mt:SQLEntries>
You would use this with the mtSQL plugin I've recommended above.
Kind Regards,
Mihai Bocsaru