“WP Post Corrector” is a plugin, helpful you to correct your post data. It contains mainly 3 modules. (1)Bulk Upload (Insert Mass Post Data) (2)Bulk Update (Update Mass Post Data) and (3)Download Complete Data Excel
(1) Bulk Inset is useful for mass/bulk post data insertion for your site via CSV file. Normally we using “Microsoft CSV” file only. First of all get Create Microsoft Excel file and save it as “CSV(comma seperated format)”. Download sample CSV file to get more help how to prepare the CSV file for Bulk Upload or Mass Upload.
In the sample CSV as you can see some of the rule are common.
–>First column of CSV must be the title of the row.
–>All titles in the row may be changed as per your post custom fields, while post common information like title,content,tags,author,category will be same for any of csv sample data. It should never changed, if you really want to insert your data. Here ts. * post_title : Post Title * post_content : Post Content data * post_excerpt : Post Excerpt data
* category : Post category name. You can insert more then one category name seperated by comma. One of the advantage of this plugin is, it will create new category it self is any of missing so be sure while inserting categor name. It’s case sensitive. If the same category name exists, plugin will get the category ID from it’s name. If there is more than one category of same name, it’s difficulty to decide on which category the post will be inserted. In such case the smartest way is change any of category name so plugin match the category and you have the correct result. * post_tag : Post Tags * post_author : Post Author name. Insert the user “user_login” or user login ID as for this column. The plugin will find the user ID from user login and will assign author ID to your post. * post_status : Post Status. You can set the post status either “publish” or “draft” or “private” or any as you want.
* comment_status : Post comment status. you can set either “open” or “closed”. * IMAGE :Post image or post attachment image column filed. If you want to insert post image (post attachment image), The row title should be “IMAGE”. You can insert more than one image by add more and more row with same title.All above fields are fixed title fields. All are case sensitive. If you change title, it will consider as post custom field and inserted as post custom field.
The custom fields name should same as you can see the field name from custo filed box, while add/edit post from wp-admin.
In the sample CSV file we have consider all type of possibility of the post data that
Normally used in almost blog.
(2)Bulk Update: same as in Bulk Insert but only update the post data while in the Bulk
Insert will insert post every time without checking the post title. If there is some
Mistake in the post data either title, description or any of custom fields, you can use
This Bulk update module. Get the complete data in the Excel format through “Download
Complete Data Excel” and do updates or correction as you want — Save it as “CSV” format
And upload from Bulk Upload module. You can see the post data will be affected.
3) Download Complete Data Excel: It will give you downloaded the complete post data in
Excel format. It will give you title, content, category, excerpt, tags, author, status and
Comment status with all custom filed in the single Microsoft excel format. You can get
It downloads and do your changes as you want. You can store it as data backup also. Same
Way you can use it for Report or for Mass Upload or Mass Update. Make sure you should
Convert it to CSV before using for bulk uploads or bulk update.
This plug-in is supporting only Microsoft excel and csv format. So please install the
Microsoft office software if you want to use this plug-in otherwise this plug-in doesn’t
Support other file formats.