23
Responses
Comments
Trackbacks/Pingbacks
-
[…] & Exporting not just by author, but by category, or time range, or tag. Today there was a an interesting post by Jeff Chandler on the long way to export by category. However, a simple plugin would be awesome. […]
-
[…] på 100 poster var ikke tiltalende. Etter å ha søkt litt på nett, fant jeg løsningen hos Weblog tools collection. God bless […]
-
[…] that get the job done. This is taken from an article I wrote exactly one year ago, the irony! http://weblogtoolscollection.com/arc…ng-a-category/ WPTavern Twitter Account | Personal Blog | WordPress Weekly […]
-
[…] se altera en el proceso de importación (véanse, a este respecto, los comentarios al artículo Exporting-Importing A Category, del que me ocuparé más adelante). Esto no debería ser un problema (incluso puede ser ventajoso, […]
Translate This Page
About the Author
- Jeff Chandler
Categories
- bbpress
- Best of WordPress
- Blog Templates Blog Skins Blog Themes
- Blogging
- Blogging Essays
- Blogging News
- brainstorming
- buddypress
- Business of Blogging
- CMS
- Code
- Cold Fusion
- Community Interviews
- Cool Scripts
- General
- HOW-TO
- LinkyLoo
- Movable Type Plugins
- Photolog Script
- Podcasting
- QuickLinking
- Spam
- SXSW
- TLA
- Tutorials
- User Reviews
- Web Design
- Web Ethics
- Weblog Add-Ons
- Weblog tools blog tools blogging tools
- Weekly Plugin Review
- WLTC Community
- wordcamp
- WordPress
- WordPress Discussions
- WordPress FAQs
- Wordpress for Beginners
- WordPress Hack
- WordPress News
- WordPress Plugin Competition
- WordPress Plugins
- WordPress Polls
- WordPress Security
- WordPress Templates WordPress Skins WordPress Themes
- WordPress Tips
- WordPress Tools
- WordPress Troubleshooting
- WordPress Weekly
- WordPress Widgets
- WordPress WishList
- XHTML Tips
Obviously Powered by WordPress. © 2003-2013
I agree, this would be a nice feature — to export by category. To export by date would be an even better feature. Indeed, it is nearly an essential feature if you have a large number of posts and the WXR file exceeds the limit on import file size.
I have a somewhat related question. I find that the WXR file corrupts many characters — em dashes, latin letters, etc. Why is this? How can it be corrected? Anyone know?
thanks for that info…it helps me with one problem i’ve been trying to figure out…and WXR file exceeds the limit…
Awesome thanks. It’s exactly what I was looking for.
The real problem with the exporter, at least as I see it, is that an export-import process will renumber the IDs of the post and taxonomy records. There are a number of plugins out there that use IDs rather than slugs (as I found when I was updating earlier this year), and they break horribly when this happens.
The SQL to do this export wouldn’t be too difficult, especially with WordPress being nicely designed with only a small number of tables. If you’ve got access to the database directly with something like PHPMySQL then it’d be relatively simple to draft up a few queries (or one slightly more complex one) to drop the data out.
I’m no expert (honestly, I’m not!), but I honestly think this is an easy task from that point of view. I know next to nothing about coding plug-ins however… There are far more complex works out there. If someone sees the need, I can see this being a relatively simple plug-in to write.
The most difficult thing to keep on top of is the change in schema/structure of the WP database between versions, and any additional meta data added by other plug-ins. Still, this could be handled.
Hmm. I forsee a project…
Nice find
@NewMexiKen I would love to see the exporter obtain many of those exporting options you described and I think it’s only a matter of time before those are added. As for the character corruption problem, I don’t know. I would look through the bug tracker for WordPress and see if thats been reported or look through the support forums. If you don’t see anything written about it, you might want to submit a bug report
@Peter Murray Peter, you are spot on. When I reformatted my WordPress install and went the WXR route, it numbered all of my tags, comments, and post IDs, it was actually really annoying.
@Mosh I’m no plugin or SQL magician myself which is why I came up with this mundane solution that end user’s shouldn’t have a problem executing. I don’t think creating a plugin for this type of functionality would be difficult at all, keeping up with the development of the core of WordPress would probably be the most difficult aspect of it.
A matter of time still hasn’t come. We are a year and a half after you wrote this comment and more than 3 years since we started asking for this feature and they still haven’t listened. Everyone agrees it is an easily added feature, but alas no one on the development team seems to give a damn. WordPress keeps getting bloated with new and worthless features increasing the DB size and memory limit necessary to run it, yet we still can’t export by date or category, or even the more brilliant import/export between two blogs.
It is time for Matt and the gang to remember this is wordpress, not windows…
Well, you’re right, the exporter/importer still lacks the ability to perform even a simple export/import of a category. However, someone has heard my pleas and this year within the plugin competition, Ron created an advanced exporter/importer which I reviewed here.
http://www.wptavern.com/review.....for-wpwpmu
You can bet I gave this plugin a high score during the judging.
This remind me of the problem with WPMU Category. Not only that by default you can’t edit the category slug. But also when you want to modify the slug or name you will face troubles. So I wrote How to Change WPMU Category Name or Slug
I wish I had the time to sit down and try to figure out plug-ins. This would be a good one to start on as a project. if I ever get the chance, you’ll be the first to know!
@Mosh:I think your method is direct, but I have a question. If you use sql to export the posts from database directly, how can you import this file(i don’t know what the db export exactly) to another weblog powered by WP?
@Charles: And another good point! The plug-in would have to be *import* as well as export. Dropping data from a database is simple enough, and you can dump it into a text file of whatever format (plain text, XML, whatever). But you’re right – whatever you use to import it back in must understand that format.
Databases I do know, SQL I’m passingly familiar with, PHP is where I fall over and specific WordPress code… barely a beginner! But this *would* make a decent project, as I said. Worst case, you can use something scary like myPHPadmin to drop and reload the data but I’d recommend against in unless you really know what you’re doing
An import SQL wouldn’t be that tough, once you have the export. I usually worry that I’m not getting (and sending) all the pieces. Once you’ve got that figured out, the SQL is trivial.
I also had looked high and low at one time to export a certain category of posts out of WordPress. I came across the HandySolo method, but the other method of changing the author is helpful albeit a pain.
Seriously, it sounds like technically it could be difficult to make a plugin that would export / import individual categories, or integrate it into the core, but this is a feature that would see a ton of use.
Maybe some brave sole will attempt it in your WordPress plugin contest running over the next two months. I have to belive a developer willing to make this as a plugin would have a good chance of winning if they did.
Honestly, I wish I had the time. I’ve never developed a plugin, but yes – this looks like an ideal task to work at. Sadly, I’ve got 3 weeks left on my contract, 20+ PCs to rebuild (very slow, old ones – one at a time), and 5 months’ of work to document for whoever takes over.
After that I’m off travelling again. I almost wish I was sat somewhere I could work at this!
its easier you download rss file from a category (in category url add a /feed – ex: myblog.com/category22/feed), save to your desktop and import from other wordpress installation. very easy. sorry for my bad english.
While is may be the ‘easiest’ solution available, that doesn’t mean it’s the best and I still think they should integrate this option into the core of WordPress, or if they think that this messes with their philosophy of the main package, I’ll like to hear the opposing argument.
Please help me anyone!
I hope the commenters in this topic can give me some pointers since my problem is somehow related to the discussion.
Here it is … I tried to export my blog to a local computer. But instead of downloading a .XML file it is downloading a .PHP file with 0kb. I am still using WP 2.8.5 and I am worried that I needed to upgrade to a newer version? Will that solve it or there is something wrong with my WP installation?