Zack Preble

I’ve improved (I hope) the csv to post import plugin to support multiple categories and excerpts. csv Basically the header row should/may look like this:

wp_title|wp_post_date|wp_category|wp_category|wp_excerpt|wp_content|field1|field2

See my original post on the csv to post importer plugin to make sense of this. Please give me your feedback if you have tested it. Thanks!

Special note on importing categories and subcategories

Ok guys, here’ s the problem. One post might fall under several categories. The importer now lets you import a post under several categories. I’ve tested it and works good for me. The issue is that you might want one category to be a subcategory of another. Rather than create some funky syntax for the csv, like

wp_title | wp_post_date        | wp_category | wp_content      | cylinders | etc..
Mustang  | 2007-12-31 23:59:59 | ford > cars | <p>nice car</p> | v8        |

which could get REALLY messy if you had a lot of subcategories, I decided to make a Category Importer
This works the same way as the post importer.

1. Download Category Importer.
2. Unzip and up load the file called csv.php to /wp-admin/import/
3. Prepare your csv file, here is a sample_category_file. It’s really a pipe delimited file. It MUST follow this format or it will not work. This is an example of what it should look like:

Yes this requires more work, you need to prepare a category file making sure you list the parent categories before the subcategories. After you do this, you can use the regular csv to post plugin listing all the categories you want the post to be listed under.

If you found this plugin useful, help pay for my kids college fund:

Problem: I have a big excel spreadsheet with posts and extra fields and I want to import it into Wordpress.

I haven’t found a plugin to do this so I decided to make my own. It’s not complete, and it’s not quite a ‘plugin’ but it works. Here’s how to do it:

1. Download CSV_Import class from me. csv2 post.
2. Unzip and up load the file called csv.php to /wp-admin/import/
3. Prepare your csv file, here is a sample file. It’s really a pipe delimited file. It MUST follow this format or it will not work. Make sure you include the header row.
   
4. In admin panel , go to Manage, Import, choose CSV
5. The rest is pretty self explanitory, upload file, pick a user, and voilá