Let’s say you have a test list based on which you wish to batch create posts. I’ve not seen this covered anywhere else in the forums and I found it to be really neat so let me describe how useful it could be.
Let’s assume your text is comma separated and consists of three fields. Title, Description and Category.
You can manipulate your data in many ways but I strongly recommend using Excel. Once you import your text into Excel, you now have three columns of information.
Add a third column to form the XML item for each item.
All you need to do is some text processing to enclose each information item within the proper XML tags.
So you open with the Item tag, then enclose Title and Description and Category in their respective tags. I’m unable to show the Excel formula here but you you can see an example on my web page http://www.yagci.com/wordpress/.
That’s all you need to do per item. Now, of course, since we are within Excel, we can manipulate the text using Excel formulas. That’s what I find to be so useful. Also, we can put actual HTML code in the Description field.
All that’s needed now is to put the resultant text records in a text file and give it the extension XML.
Then you can import it into WordPress using the RSS import function.
What I really enjoyed observing was that I did not have to form a full RSS feed. One XML record per line was sufficient for WordPress to import my data and create one post per record using the Title, Description and Category fields.
Back in the ASP days, I had a database of items where I stored textual information and links to an audio database. The advantage of using database was that I could manipulate records in a systematic way. After I moved to WordPress, I had to create each item one by one. As I had something like 1000 items in the database it was not practical. With method I described above, I can now manipulate all my data on Excel, create a pseudo RSS feed and import that to WordPress. As long a I have a way to mass delete existing posts, a mass update is as simple as mass deleting and mass importing again.
- The topic ‘Creating Batch Posts and a pseudo RSS feed by using Excel’ is closed to new replies.