WP Plugin to Create Posts from a Delimited Text File?

by MarkR
3 replies
I have a data file which is in text format, delimited with the | symbol.

It does not have headers with post name, category, tags, etc. Just raw data. But I can assign one of the fields to be used as a title, tag, category if the plugin allows that.

Is there a plugin that reads this file and creates posts from it?

Preferably a post with some formatting/style to it?
#create #delimited #file #plugin #posts #text
  • Profile picture of the author cbgaloot
    Just brain storming a bit here. What you may need is actually a database import program.

    All the posts in a WP blog are in a MYSQL database.

    Probably the easiest way to do what you want is to find a way to read the delimited text file into the MYSQL datbase.

    I'm sure you would have to have the posts formatted in a way that would "fit" the database.

    In other words the database would have a place for Post Title, Tags, Post body, and you would have format your text file similarly.
    {{ DiscussionBoard.errors[4005423].message }}
  • Profile picture of the author Istvan Horvath
    There are two plugins that I know of... dealing with similar issues. I bolded the "similar" to warn everybody: they may not be the solution.

    However, one is dealing with exporting to txt, the other one (allegedly working well in tandem) is importing CSV.

    WordPress › Export to Text « WordPress Plugins
    WordPress › CSV Importer « WordPress Plugins

    If nothing else, they can give you an idea about the formatting needed and/or create a start point...

    HTH
    Signature

    {{ DiscussionBoard.errors[4005450].message }}
    • Profile picture of the author MarkR
      cbgaloot, thanks for the input.

      Istvan, I can always count on you to chip in. That's why you're the King of WordPress! That sounds like what i need. I'll try it out.

      This file is a file of products for sale, that changes every day. Some are sold and no longer available, and new ones come in. Is there a way to automatically delete every post, every day? Preferably by category or tag?

      Ideally an RSS feed that dynamically updates itself would probably work better, but that's not available.
      {{ DiscussionBoard.errors[4005701].message }}

Trending Topics